purchasing/supplier_invoice.php

   1 <?php
   2
   3 $page_security=5;
   4 $path_to_root="..";
   5
   6 include_once($path_to_root . "/purchasing/includes/purchasing_db.inc");
   7
   8 include_once($path_to_root . "/includes/session.inc");
   9
  10 include_once($path_to_root . "/includes/banking.inc");
  11 include_once($path_to_root . "/includes/data_checks.inc");
  12
  13 include_once($path_to_root . "/purchasing/includes/purchasing_ui.inc");
  14 $js = "";
  15 if ($use_popup_windows)
  16         $js .= get_js_open_window(900, 500);
  17 if ($use_date_picker)
  18         $js .= get_js_date_picker();
  19 page(_("Enter Supplier Invoice"), false, false, "", $js);
  20
  21
  22 //----------------------------------------------------------------------------------------
  23
  24 check_db_has_suppliers(_("There are no suppliers defined in the system."));
  25
  26 //---------------------------------------------------------------------------------------------------------------
  27 if ($ret = context_restore()) {
  28  // return from supplier editor
  29         copy_from_trans($_SESSION['supp_trans']);
  30         if(isset($ret['supplier_id']))
  31                 $_POST['supplier_id'] = $ret['supplier_id'];
  32 }
  33 if (isset($_POST['_supplier_id_editor'])) {
  34         copy_to_trans($_SESSION['supp_trans']);
  35         context_call($path_to_root.'/purchasing/manage/suppliers.php?supplier_id='.$_POST['supplier_id'], 'supp_trans');
  36 }
  37
  38 //---------------------------------------------------------------------------------------------------------------
  39
  40 if (isset($_GET['AddedID']))
  41 {
  42         $invoice_no = $_GET['AddedID'];
  43         $trans_type = 20;
  44
  45
  46     echo "<center>";
  47     display_notification_centered(_("Supplier invoice has been processed."));
  48     display_note(get_trans_view_str($trans_type, $invoice_no, _("View this Invoice")));
  49
  50         display_note(get_gl_view_str($trans_type, $invoice_no, _("View the GL Journal Entries for this Invoice")), 1);
  51
  52         hyperlink_params($_SERVER['PHP_SELF'], _("Enter Another Invoice"), "New=1");
  53
  54         hyperlink_params("$path_to_root/admin/attachments.php", _("Add an Attachment"), "filterType=$trans_type&trans_no=$invoice_no");
  55
  56         display_footer_exit();
  57 }
  58
  59 //--------------------------------------------------------------------------------------------------
  60
  61 if (isset($_GET['New']))
  62 {
  63         if (isset( $_SESSION['supp_trans']))
  64         {
  65                 unset ($_SESSION['supp_trans']->grn_items);
  66                 unset ($_SESSION['supp_trans']->gl_codes);
  67                 unset ($_SESSION['supp_trans']);
  68         }
  69
  70         //session_register("SuppInv");
  71         session_register("supp_trans");
  72         $_SESSION['supp_trans'] = new supp_trans;
  73         $_SESSION['supp_trans']->is_invoice = true;
  74 }
  75
  76 //--------------------------------------------------------------------------------------------------
  77 function clear_fields()
  78 {
  79         global $Ajax;
  80
  81         unset($_POST['gl_code']);
  82         unset($_POST['dimension_id']);
  83         unset($_POST['dimension2_id']);
  84         unset($_POST['amount']);
  85         unset($_POST['memo_']);
  86         unset($_POST['AddGLCodeToTrans']);
  87         $Ajax->activate('gl_ctrls');
  88         set_focus('gl_code');
  89 }
  90 //------------------------------------------------------------------------------------------------
  91 //      GL postings are often entered in the same form to two accounts
  92 //  so fileds are cleared only on user demand.
  93 //
  94 if (isset($_POST['ClearFields']))
  95 {
  96         clear_fields();
  97 }
  98
  99 if (isset($_POST['AddGLCodeToTrans'])){
 100
 101         $Ajax->activate('gl_items');
 102         $input_error = false;
 103
 104         $sql = "SELECT account_code, account_name FROM ".TB_PREF."chart_master WHERE account_code='" . $_POST['gl_code'] . "'";
 105         $result = db_query($sql,"get account information");
 106         if (db_num_rows($result) == 0)
 107         {
 108                 display_error(_("The account code entered is not a valid code, this line cannot be added to the transaction."));
 109                 set_focus('gl_code');
 110                 $input_error = true;
 111         }
 112         else
 113         {
 114                 $myrow = db_fetch_row($result);
 115                 $gl_act_name = $myrow[1];
 116                 if (!check_num('amount'))
 117                 {
 118                         display_error(_("The amount entered is not numeric. This line cannot be added to the transaction."));
 119                         set_focus('amount');
 120                         $input_error = true;
 121                 }
 122         }
 123
 124         if ($input_error == false)
 125         {
 126                 $_SESSION['supp_trans']->add_gl_codes_to_trans($_POST['gl_code'], $gl_act_name,
 127                         $_POST['dimension_id'], $_POST['dimension2_id'],
 128                         input_num('amount'), $_POST['memo_']);
 129                 set_focus('gl_code');
 130         }
 131 }
 132
 133 //------------------------------------------------------------------------------------------------
 134
 135 function check_data()
 136 {
 137         If (!$_SESSION['supp_trans']->is_valid_trans_to_post())
 138         {
 139                 display_error(_("The invoice cannot be processed because the there are no items or values on the invoice.  Invoices are expected to have a charge."));
 140                 return false;
 141         }
 142
 143         if (!references::is_valid($_SESSION['supp_trans']->reference))
 144         {
 145                 display_error(_("You must enter an invoice reference."));
 146                 set_focus('reference');
 147                 return false;
 148         }
 149
 150         if (!is_new_reference($_SESSION['supp_trans']->reference, 20))
 151         {
 152                 display_error(_("The entered reference is already in use."));
 153                 set_focus('reference');
 154                 return false;
 155         }
 156
 157         if (!references::is_valid($_SESSION['supp_trans']->supp_reference))
 158         {
 159                 display_error(_("You must enter a supplier's invoice reference."));
 160                 set_focus('supp_reference');
 161                 return false;
 162         }
 163
 164         if (!is_date( $_SESSION['supp_trans']->tran_date))
 165         {
 166                 display_error(_("The invoice as entered cannot be processed because the invoice date is in an incorrect format."));
 167                 set_focus('trans_date');
 168                 return false;
 169         }
 170         elseif (!is_date_in_fiscalyear($_SESSION['supp_trans']->tran_date))
 171         {
 172                 display_error(_("The entered date is not in fiscal year."));
 173                 set_focus('trans_date');
 174                 return false;
 175         }
 176         if (!is_date( $_SESSION['supp_trans']->due_date))
 177         {
 178                 display_error(_("The invoice as entered cannot be processed because the due date is in an incorrect format."));
 179                 set_focus('due_date');
 180                 return false;
 181         }
 182
 183         $sql = "SELECT Count(*) FROM ".TB_PREF."supp_trans WHERE supplier_id='" . $_SESSION['supp_trans']->supplier_id . "' AND supp_reference='" . $_POST['supp_reference'] . "'";
 184         $result=db_query($sql,"The sql to check for the previous entry of the same invoice failed");
 185
 186         $myrow = db_fetch_row($result);
 187         if ($myrow[0] == 1)
 188         {       /*Transaction reference already entered */
 189                 display_error(_("This invoice number has already been entered. It cannot be entered again." . " (" . $_POST['supp_reference'] . ")"));
 190                 return false;
 191         }
 192
 193         return true;
 194 }
 195
 196 //--------------------------------------------------------------------------------------------------
 197
 198 function handle_commit_invoice()
 199 {
 200         copy_to_trans($_SESSION['supp_trans']);
 201
 202         if (!check_data())
 203                 return;
 204
 205         $invoice_no = add_supp_invoice($_SESSION['supp_trans']);
 206
 207     $_SESSION['supp_trans']->clear_items();
 208     unset($_SESSION['supp_trans']);
 209
 210         meta_forward($_SERVER['PHP_SELF'], "AddedID=$invoice_no");
 211 }
 212
 213 //--------------------------------------------------------------------------------------------------
 214
 215 if (isset($_POST['PostInvoice']))
 216 {
 217         handle_commit_invoice();
 218 }
 219
 220 function check_item_data($n)
 221 {
 222         global $check_price_charged_vs_order_price,
 223                 $check_qty_charged_vs_del_qty;
 224         if (!check_num('this_quantity_inv'.$n, 0) || input_num('this_quantity_inv'.$n)==0)
 225         {
 226                 display_error( _("The quantity to invoice must be numeric and greater than zero."));
 227                 set_focus('this_quantity_inv'.$n);
 228                 return false;
 229         }
 230
 231         if (!check_num('ChgPrice'.$n))
 232         {
 233                 display_error( _("The price is not numeric."));
 234                 set_focus('ChgPrice'.$n);
 235                 return false;
 236         }
 237
 238         if ($check_price_charged_vs_order_price == True)
 239         {
 240                 if ($_POST['order_price'.$n]!=input_num('ChgPrice'.$n)) {
 241                      if ($_POST['order_price'.$n]==0 ||
 242                                 input_num('ChgPrice'.$n)/$_POST['order_price'.$n] >
 243                             (1 + (sys_prefs::over_charge_allowance() / 100)))
 244                     {
 245                         display_error(_("The price being invoiced is more than the purchase order price by more than the allowed over-charge percentage. The system is set up to prohibit this. See the system administrator to modify the set up parameters if necessary.") .
 246                         _("The over-charge percentage allowance is :") . sys_prefs::over_charge_allowance() . "%");
 247                         set_focus('ChgPrice'.$n);
 248                         return false;
 249                     }
 250                 }
 251         }
 252
 253         if ($check_qty_charged_vs_del_qty == True)
 254         {
 255                 if (input_num('this_quantity_inv'.$n) / ($_POST['qty_recd'.$n] - $_POST['prev_quantity_inv'.$n]) >
 256                         (1+ (sys_prefs::over_charge_allowance() / 100)))
 257                 {
 258                         display_error( _("The quantity being invoiced is more than the outstanding quantity by more than the allowed over-charge percentage. The system is set up to prohibit this. See the system administrator to modify the set up parameters if necessary.")
 259                         . _("The over-charge percentage allowance is :") . sys_prefs::over_charge_allowance() . "%");
 260                         set_focus('this_quantity_inv'.$n);
 261                         return false;
 262                 }
 263         }
 264
 265         return true;
 266 }
 267
 268 $id = find_submit('grn_item_id');
 269 if ($id != -1)
 270 {
 271         if (check_item_data($id))
 272         {
 273         if (input_num('this_quantity_inv'.$id) >= ($_POST['qty_recd'.$id] - $_POST['prev_quantity_inv'.$id]))
 274         {
 275                 $complete = true;
 276         }
 277         else
 278         {
 279                 $complete = false;
 280         }
 281
 282                 $_SESSION['supp_trans']->add_grn_to_trans($id, $_POST['po_detail_item'.$id],
 283                         $_POST['item_code'.$id], $_POST['item_description'.$id], $_POST['qty_recd'.$id],
 284                         $_POST['prev_quantity_inv'.$id], input_num('this_quantity_inv'.$id),
 285                         $_POST['order_price'.$id], input_num('ChgPrice'.$id), $complete,
 286                         $_POST['std_cost_unit'.$id], "");
 287         }
 288 }
 289
 290 //--------------------------------------------------------------------------------------------------
 291 $id = find_submit('Delete');
 292 if ($id != -1)
 293 {
 294         $_SESSION['supp_trans']->remove_grn_from_trans($id);
 295         $Ajax->activate('grn_items');
 296         $Ajax->activate('grn_table');
 297         $Ajax->activate('inv_tot');
 298 }
 299
 300 $id = find_submit('Delete2');
 301 if ($id != -1)
 302 {
 303         $_SESSION['supp_trans']->remove_gl_codes_from_trans($id);
 304         clear_fields();
 305         $Ajax->activate('gl_items');
 306         $Ajax->activate('inv_tot');
 307 }
 308
 309 start_form(false, true);
 310
 311 start_table("$table_style2 width=98%", 8);
 312 echo "<tr><td valign=center>"; // outer table
 313
 314 echo "<center>";
 315
 316 invoice_header($_SESSION['supp_trans']);
 317 if ($_POST['supplier_id']=='')
 318         display_error('No supplier found for entered search text');
 319 else {
 320         echo "</td></tr><tr><td valign=center>"; // outer table
 321
 322         echo "<center>";
 323
 324         display_grn_items($_SESSION['supp_trans'], 1);
 325         //display_grn_items_for_selection();
 326         display_gl_items($_SESSION['supp_trans'], 1);
 327         //display_gl_controls();
 328
 329         //echo "</td></tr><tr><td align=center colspan=2>"; // outer table
 330         echo "<br>";
 331         div_start('inv_tot');
 332         invoice_totals($_SESSION['supp_trans']);
 333         div_end();
 334 }
 335 echo "</td></tr>";
 336
 337 end_table(); // outer table
 338
 339 //-----------------------------------------------------------------------------------------
 340 $id = find_submit('grn_item_id');
 341 $id2 = find_submit('void_item_id');
 342 if ($id != -1 || $id2 != -1)
 343 {
 344         $Ajax->activate('grn_table');
 345         $Ajax->activate('grn_items');
 346         $Ajax->activate('inv_tot');
 347 }
 348
 349 if (get_post('AddGLCodeToTrans'))
 350         $Ajax->activate('inv_tot');
 351
 352 if ($_SESSION["wa_current_user"]->access == 2)
 353 {
 354         if ($id2 != -1) // Added section 2008-10-18 Joe Hunt for voiding delivery lines
 355         {
 356                 begin_transaction();
 357
 358                 $myrow = get_grn_item_detail($id2);
 359
 360                 $grn = get_grn_batch($myrow['grn_batch_id']);
 361
 362             $sql = "UPDATE ".TB_PREF."purch_order_details
 363                         SET quantity_received = qty_invoiced, quantity_ordered = qty_invoiced WHERE po_detail_item = ".$myrow["po_detail_item"];
 364             db_query($sql, "The quantity invoiced of the purchase order line could not be updated");
 365
 366             $sql = "UPDATE ".TB_PREF."grn_items
 367                 SET qty_recd = quantity_inv WHERE id = ".$myrow["id"];
 368                 db_query($sql, "The quantity invoiced off the items received record could not be updated");
 369
 370                 update_average_material_cost($grn["supplier_id"], $myrow["item_code"],
 371                         $myrow["unit_price"], -$myrow["QtyOstdg"], Today());
 372
 373                 add_stock_move(25, $myrow["item_code"], $myrow['grn_batch_id'], $grn['loc_code'], sql2date($grn["delivery_date"]), "",
 374                         -$myrow["QtyOstdg"], $myrow['std_cost_unit'], $grn["supplier_id"], 1, $myrow['unit_price']);
 375
 376                 commit_transaction();
 377         }
 378 }
 379
 380 echo "<br>";
 381 submit_center('PostInvoice', _("Enter Invoice"), true, '', true);
 382 echo "<br>";
 383
 384 end_form();
 385
 386 //--------------------------------------------------------------------------------------------------
 387
 388 end_page();
 389 ?>