purchasing/po_entry_items.php

   1 <?php
   2 /**********************************************************************
   3     Copyright (C) FrontAccounting, LLC.
   4         Released under the terms of the GNU General Public License, GPL,
   5         as published by the Free Software Foundation, either version 3
   6         of the License, or (at your option) any later version.
   7     This program is distributed in the hope that it will be useful,
   8     but WITHOUT ANY WARRANTY; without even the implied warranty of
   9     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
  10     See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
  11 ***********************************************************************/
  12 $page_security = 'SA_PURCHASEORDER';
  13 $path_to_root = "..";
  14 include_once($path_to_root . "/purchasing/includes/po_class.inc");
  15 include_once($path_to_root . "/includes/session.inc");
  16 include_once($path_to_root . "/purchasing/includes/purchasing_ui.inc");
  17 include_once($path_to_root . "/reporting/includes/reporting.inc");
  18
  19 $js = '';
  20 if ($use_popup_windows)
  21         $js .= get_js_open_window(900, 500);
  22 if ($use_date_picker)
  23         $js .= get_js_date_picker();
  24
  25 if (isset($_GET['ModifyOrderNumber']))
  26 {
  27         page(_($help_context = "Modify Purchase Order #") . $_GET['ModifyOrderNumber'], false, false, "", $js);
  28 }
  29 else
  30 {
  31         page(_($help_context = "Purchase Order Entry"), false, false, "", $js);
  32 }
  33
  34 //---------------------------------------------------------------------------------------------------
  35
  36 check_db_has_suppliers(_("There are no suppliers defined in the system."));
  37
  38 check_db_has_purchasable_items(_("There are no purchasable inventory items defined in the system."));
  39
  40 //---------------------------------------------------------------------------------------------------------------
  41
  42 if (isset($_GET['AddedID']))
  43 {
  44         $order_no = $_GET['AddedID'];
  45         $trans_type = ST_PURCHORDER;
  46
  47         if (!isset($_GET['Updated']))
  48                 display_notification_centered(_("Purchase Order has been entered"));
  49         else
  50                 display_notification_centered(_("Purchase Order has been updated") . " #$order_no");
  51         display_note(get_trans_view_str($trans_type, $order_no, _("&View this order")), 0, 1);
  52
  53         display_note(print_document_link($order_no, _("&Print This Order"), true, $trans_type), 0, 1);
  54
  55         display_note(print_document_link($order_no, _("&Email This Order"), true, $trans_type, false, "", "", 1));
  56
  57         hyperlink_params($path_to_root . "/purchasing/po_receive_items.php", _("&Receive Items on this Purchase Order"), "PONumber=$order_no");
  58
  59         hyperlink_params($_SERVER['PHP_SELF'], _("Enter &Another Purchase Order"), "NewOrder=yes");
  60
  61         hyperlink_no_params($path_to_root."/purchasing/inquiry/po_search.php", _("Select An &Outstanding Purchase Order"));
  62
  63         display_footer_exit();
  64 }
  65 //--------------------------------------------------------------------------------------------------
  66
  67 function copy_from_cart()
  68 {
  69         $_POST['supplier_id'] = $_SESSION['PO']->supplier_id;
  70         $_POST['OrderDate'] = $_SESSION['PO']->orig_order_date;
  71     $_POST['Requisition'] = $_SESSION['PO']->requisition_no;
  72     $_POST['ref'] = $_SESSION['PO']->reference;
  73         $_POST['Comments'] = $_SESSION['PO']->Comments;
  74     $_POST['StkLocation'] = $_SESSION['PO']->Location;
  75     $_POST['delivery_address'] = $_SESSION['PO']->delivery_address;
  76 }
  77
  78 function copy_to_cart()
  79 {
  80         $_SESSION['PO']->supplier_id = $_POST['supplier_id'];
  81         $_SESSION['PO']->orig_order_date = $_POST['OrderDate'];
  82         $_SESSION['PO']->reference = $_POST['ref'];
  83         $_SESSION['PO']->requisition_no = $_POST['Requisition'];
  84         $_SESSION['PO']->Comments = $_POST['Comments'];
  85         $_SESSION['PO']->Location = $_POST['StkLocation'];
  86         $_SESSION['PO']->delivery_address = $_POST['delivery_address'];
  87 }
  88 //--------------------------------------------------------------------------------------------------
  89
  90 function line_start_focus() {
  91   global        $Ajax;
  92
  93   $Ajax->activate('items_table');
  94   set_focus('_stock_id_edit');
  95 }
  96 //--------------------------------------------------------------------------------------------------
  97
  98 function unset_form_variables() {
  99         unset($_POST['stock_id']);
 100     unset($_POST['qty']);
 101     unset($_POST['price']);
 102     unset($_POST['req_del_date']);
 103 }
 104
 105 //---------------------------------------------------------------------------------------------------
 106
 107 function handle_delete_item($line_no)
 108 {
 109         if($_SESSION['PO']->some_already_received($line_no) == 0)
 110         {
 111                 $_SESSION['PO']->remove_from_order($line_no);
 112                 unset_form_variables();
 113         }
 114         else
 115         {
 116                 display_error(_("This item cannot be deleted because some of it has already been received."));
 117         }
 118     line_start_focus();
 119 }
 120
 121 //---------------------------------------------------------------------------------------------------
 122
 123 function handle_cancel_po()
 124 {
 125         global $path_to_root;
 126
 127         //need to check that not already dispatched or invoiced by the supplier
 128         if(($_SESSION['PO']->order_no != 0) &&
 129                 $_SESSION['PO']->any_already_received() == 1)
 130         {
 131                 display_error(_("This order cannot be cancelled because some of it has already been received.")
 132                         . "<br>" . _("The line item quantities may be modified to quantities more than already received. prices cannot be altered for lines that have already been received and quantities cannot be reduced below the quantity already received."));
 133                 return;
 134         }
 135
 136         if($_SESSION['PO']->order_no != 0)
 137         {
 138                 delete_po($_SESSION['PO']->order_no);
 139         } else {
 140                 unset($_SESSION['PO']);
 141                 meta_forward($path_to_root.'/index.php','application=AP');
 142         }
 143
 144         $_SESSION['PO']->clear_items();
 145         $_SESSION['PO'] = new purch_order;
 146
 147         display_notification(_("This purchase order has been cancelled."));
 148
 149         hyperlink_params($path_to_root . "/purchasing/po_entry_items.php", _("Enter a new purchase order"), "NewOrder=Yes");
 150         echo "<br>";
 151
 152         end_page();
 153         exit;
 154 }
 155
 156 //---------------------------------------------------------------------------------------------------
 157
 158 function check_data()
 159 {
 160     if (!check_num('qty',0))
 161     {
 162                 display_error(_("The quantity of the order item must be numeric and not less than zero."));
 163                 set_focus('qty');
 164                 return false;
 165     }
 166
 167     if (!check_num('price', 0))
 168     {
 169                 display_error(_("The price entered must be numeric and not less than zero."));
 170                 set_focus('price');
 171                 return false;
 172     }
 173     if (!is_date($_POST['req_del_date'])){
 174                 display_error(_("The date entered is in an invalid format."));
 175                 set_focus('req_del_date');
 176                 return false;
 177     }
 178
 179     return true;
 180 }
 181
 182 //---------------------------------------------------------------------------------------------------
 183
 184 function handle_update_item()
 185 {
 186         $allow_update = check_data();
 187
 188         if ($allow_update &&
 189                 ($_SESSION['PO']->line_items[$_POST['line_no']]->qty_inv > input_num('qty') ||
 190                 $_SESSION['PO']->line_items[$_POST['line_no']]->qty_received > input_num('qty')))
 191         {
 192                 display_error(_("You are attempting to make the quantity ordered a quantity less than has already been invoiced or received.  This is prohibited.") .
 193                         "<br>" . _("The quantity received can only be modified by entering a negative receipt and the quantity invoiced can only be reduced by entering a credit note against this item."));
 194                 set_focus('qty');
 195                 return;
 196         }
 197
 198         $_SESSION['PO']->update_order_item($_POST['line_no'], input_num('qty'), input_num('price'),
 199                 $_POST['req_del_date']);
 200         unset_form_variables();
 201     line_start_focus();
 202 }
 203
 204 //---------------------------------------------------------------------------------------------------
 205
 206 function handle_add_new_item()
 207 {
 208         $allow_update = check_data();
 209
 210         if ($allow_update == true)
 211         {
 212                 if (count($_SESSION['PO']->line_items) > 0)
 213                 {
 214                     foreach ($_SESSION['PO']->line_items as $order_item)
 215                     {
 216
 217                         /* do a loop round the items on the order to see that the item
 218                         is not already on this order */
 219                             if (($order_item->stock_id == $_POST['stock_id']) &&
 220                                 ($order_item->Deleted == false))
 221                             {
 222                                         $allow_update = false;
 223                                         display_error(_("The selected item is already on this order."));
 224                             }
 225                     } /* end of the foreach loop to look for pre-existing items of the same code */
 226                 }
 227
 228                 if ($allow_update == true)
 229                 {
 230                         $sql = "SELECT description, units, mb_flag
 231                                 FROM ".TB_PREF."stock_master WHERE stock_id = ".db_escape($_POST['stock_id']);
 232
 233                     $result = db_query($sql,"The stock details for " . $_POST['stock_id'] . " could not be retrieved");
 234
 235                     if (db_num_rows($result) == 0)
 236                     {
 237                                 $allow_update = false;
 238                     }
 239
 240                         if ($allow_update)
 241                         {
 242                                 $myrow = db_fetch($result);
 243                                 $_SESSION['PO']->add_to_order ($_POST['line_no'], $_POST['stock_id'], input_num('qty'),
 244                                         $myrow["description"], input_num('price'), $myrow["units"],
 245                                         $_POST['req_del_date'], 0, 0);
 246
 247                                 unset_form_variables();
 248                                 $_POST['stock_id']      = "";
 249                         }
 250                         else
 251                         {
 252                              display_error(_("The selected item does not exist or it is a kit part and therefore cannot be purchased."));
 253                         }
 254
 255                 } /* end of if not already on the order and allow input was true*/
 256     }
 257         line_start_focus();
 258 }
 259
 260 //---------------------------------------------------------------------------------------------------
 261
 262 function can_commit()
 263 {
 264         global $Refs;
 265
 266         if (!is_date($_POST['OrderDate']))
 267         {
 268                 display_error(_("The entered order date is invalid."));
 269                 set_focus('OrderDate');
 270                 return false;
 271         }
 272
 273         if (!$_SESSION['PO']->order_no)
 274         {
 275         if (!$Refs->is_valid(get_post('ref')))
 276         {
 277                 display_error(_("There is no reference entered for this purchase order."));
 278                         set_focus('ref');
 279                 return false;
 280         }
 281
 282         if (!is_new_reference(get_post('ref'), ST_PURCHORDER))
 283         {
 284                 display_error(_("The entered reference is already in use."));
 285                         set_focus('ref');
 286                 return false;
 287         }
 288         }
 289
 290         if (get_post('delivery_address') == '')
 291         {
 292                 display_error(_("There is no delivery address specified."));
 293                 set_focus('delivery_address');
 294                 return false;
 295         }
 296
 297         if (get_post('StkLocation') == '')
 298         {
 299                 display_error(_("There is no location specified to move any items into."));
 300                 set_focus('StkLocation');
 301                 return false;
 302         }
 303
 304         if ($_SESSION['PO']->order_has_items() == false)
 305         {
 306         display_error (_("The order cannot be placed because there are no lines entered on this order."));
 307         return false;
 308         }
 309
 310         return true;
 311 }
 312
 313 //---------------------------------------------------------------------------------------------------
 314
 315 function handle_commit_order()
 316 {
 317
 318         if (can_commit())
 319         {
 320                 copy_to_cart();
 321
 322                 if ($_SESSION['PO']->order_no == 0)
 323                 {
 324
 325                         /*its a new order to be inserted */
 326                         $order_no = add_po($_SESSION['PO']);
 327                         new_doc_date($_SESSION['PO']->orig_order_date);
 328                         unset($_SESSION['PO']);
 329
 330                 meta_forward($_SERVER['PHP_SELF'], "AddedID=$order_no");
 331
 332                 }
 333                 else
 334                 {
 335
 336                         /*its an existing order need to update the old order info */
 337                         $order_no = update_po($_SESSION['PO']);
 338
 339                         unset($_SESSION['PO']);
 340
 341                 meta_forward($_SERVER['PHP_SELF'], "AddedID=$order_no&Updated=1");
 342                 }
 343         }
 344 }
 345 //---------------------------------------------------------------------------------------------------
 346 $id = find_submit('Delete');
 347 if ($id != -1)
 348         handle_delete_item($id);
 349
 350 if (isset($_POST['Commit']))
 351 {
 352         handle_commit_order();
 353 }
 354 if (isset($_POST['UpdateLine']))
 355         handle_update_item();
 356
 357 if (isset($_POST['EnterLine']))
 358         handle_add_new_item();
 359
 360 if (isset($_POST['CancelOrder']))
 361         handle_cancel_po();
 362
 363 if (isset($_POST['CancelUpdate']))
 364         unset_form_variables();
 365
 366 if (isset($_GET['ModifyOrderNumber']) && $_GET['ModifyOrderNumber'] != "")
 367 {
 368         create_new_po();
 369
 370         $_SESSION['PO']->order_no = $_GET['ModifyOrderNumber'];
 371
 372         /*read in all the selected order into the Items cart  */
 373         read_po($_SESSION['PO']->order_no, $_SESSION['PO']);
 374
 375         copy_from_cart();
 376 }
 377
 378 if (isset($_POST['CancelUpdate']) || isset($_POST['UpdateLine'])) {
 379         line_start_focus();
 380 }
 381
 382 if (isset($_GET['NewOrder']))
 383         create_new_po();
 384
 385 //---------------------------------------------------------------------------------------------------
 386
 387 start_form();
 388
 389 display_po_header($_SESSION['PO']);
 390 echo "<br>";
 391
 392 display_po_items($_SESSION['PO']);
 393
 394 start_table($table_style2);
 395 textarea_row(_("Memo:"), 'Comments', null, 70, 4);
 396
 397 end_table(1);
 398
 399 div_start('controls', 'items_table');
 400 if ($_SESSION['PO']->order_has_items())
 401 {
 402         if ($_SESSION['PO']->order_no)
 403                 submit_center_first('Commit', _("Update Order"), '', 'default');
 404         else
 405                 submit_center_first('Commit', _("Place Order"), '', 'default');
 406         submit_center_last('CancelOrder', _("Cancel Order"));
 407 }
 408 else
 409         submit_center('CancelOrder', _("Cancel Order"), true, false, 'cancel');
 410 div_end();
 411 //---------------------------------------------------------------------------------------------------
 412
 413 end_form();
 414 end_page();
 415 ?>