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