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 = 4;
  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(_("Modify Purchase Order #") . $_GET['ModifyOrderNumber'], false, false, "", $js);
  28 }
  29 else
  30 {
  31         page(_("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 set_editor('supplier', 'supplier_id' , 'ref');
  42 set_editor('item', 'stock_id' , 'qty');
  43
  44 if (isset($_GET['AddedID']))
  45 {
  46         $order_no = $_GET['AddedID'];
  47         $trans_type = systypes::po();
  48
  49         if (!isset($_GET['Updated']))
  50                 display_notification_centered(_("Purchase Order has been entered"));
  51         else
  52                 display_notification_centered(_("Purchase Order has been updated") . " #$order_no");
  53         display_note(get_trans_view_str($trans_type, $order_no, _("&View this order")));
  54         echo '<br>';
  55         display_note(print_document_link($order_no, _("&Print This Order"), true, $trans_type));
  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 = '". $_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         if (!is_date($_POST['OrderDate']))
 265         {
 266                 display_error(_("The entered order date is invalid."));
 267                 set_focus('OrderDate');
 268                 return false;
 269         }
 270
 271         if (!$_SESSION['PO']->order_no)
 272         {
 273         if (!references::is_valid(get_post('ref')))
 274         {
 275                 display_error(_("There is no reference entered for this purchase order."));
 276                         set_focus('ref');
 277                 return false;
 278         }
 279
 280         if (!is_new_reference(get_post('ref'), systypes::po()))
 281         {
 282                 display_error(_("The entered reference is already in use."));
 283                         set_focus('ref');
 284                 return false;
 285         }
 286         }
 287
 288         if (get_post('delivery_address') == '')
 289         {
 290                 display_error(_("There is no delivery address specified."));
 291                 set_focus('delivery_address');
 292                 return false;
 293         }
 294
 295         if (get_post('StkLocation') == '')
 296         {
 297                 display_error(_("There is no location specified to move any items into."));
 298                 set_focus('StkLocation');
 299                 return false;
 300         }
 301
 302         if ($_SESSION['PO']->order_has_items() == false)
 303         {
 304         display_error (_("The order cannot be placed because there are no lines entered on this order."));
 305         return false;
 306         }
 307
 308         return true;
 309 }
 310
 311 //---------------------------------------------------------------------------------------------------
 312
 313 function handle_commit_order()
 314 {
 315
 316         if (can_commit())
 317         {
 318                 copy_to_cart();
 319
 320                 if ($_SESSION['PO']->order_no == 0)
 321                 {
 322
 323                         /*its a new order to be inserted */
 324                         $order_no = add_po($_SESSION['PO']);
 325                         new_doc_date($_SESSION['PO']->orig_order_date);
 326                         unset($_SESSION['PO']);
 327
 328                 meta_forward($_SERVER['PHP_SELF'], "AddedID=$order_no");
 329
 330                 }
 331                 else
 332                 {
 333
 334                         /*its an existing order need to update the old order info */
 335                         $order_no = update_po($_SESSION['PO']);
 336
 337                         unset($_SESSION['PO']);
 338
 339                 meta_forward($_SERVER['PHP_SELF'], "AddedID=$order_no&Updated=1");
 340                 }
 341         }
 342 }
 343 //---------------------------------------------------------------------------------------------------
 344 $id = find_submit('Delete');
 345 if ($id != -1)
 346         handle_delete_item($id);
 347
 348 if (isset($_POST['Commit']))
 349 {
 350         handle_commit_order();
 351 }
 352 if (isset($_POST['UpdateLine']))
 353         handle_update_item();
 354
 355 if (isset($_POST['EnterLine']))
 356         handle_add_new_item();
 357
 358 if (isset($_POST['CancelOrder']))
 359         handle_cancel_po();
 360
 361 if (isset($_POST['CancelUpdate']))
 362         unset_form_variables();
 363
 364 if (isset($_GET['ModifyOrderNumber']) && $_GET['ModifyOrderNumber'] != "")
 365 {
 366         create_new_po();
 367
 368         $_SESSION['PO']->order_no = $_GET['ModifyOrderNumber'];
 369
 370         /*read in all the selected order into the Items cart  */
 371         read_po($_SESSION['PO']->order_no, $_SESSION['PO']);
 372
 373         copy_from_cart();
 374 }
 375
 376 if (isset($_POST['CancelUpdate']) || isset($_POST['UpdateLine'])) {
 377         line_start_focus();
 378 }
 379
 380 if (isset($_GET['NewOrder']))
 381         create_new_po();
 382
 383 //---------------------------------------------------------------------------------------------------
 384
 385 start_form();
 386
 387 display_po_header($_SESSION['PO']);
 388 echo "<br>";
 389
 390 display_po_items($_SESSION['PO']);
 391
 392 start_table($table_style2);
 393 textarea_row(_("Memo:"), 'Comments', null, 70, 4);
 394
 395 end_table(1);
 396
 397 div_start('controls', 'items_table');
 398 if ($_SESSION['PO']->order_has_items())
 399 {
 400         if ($_SESSION['PO']->order_no)
 401                 submit_center_first('Commit', _("Update Order"), '', 'default');
 402         else
 403                 submit_center_first('Commit', _("Place Order"), '', 'default');
 404         submit_center_last('CancelOrder', _("Cancel Order"));
 405 }
 406 else
 407         submit_center('CancelOrder', _("Cancel Order"), true, false, 'cancel');
 408 div_end();
 409 //---------------------------------------------------------------------------------------------------
 410
 411 end_form();
 412 end_page();
 413 ?>