6 include_once($path_to_root . "/purchasing/includes/po_class.inc");
8 include_once($path_to_root . "/includes/session.inc");
10 include_once($path_to_root . "/purchasing/includes/purchasing_ui.inc");
13 if ($use_popup_windows)
14 $js .= get_js_open_window(900, 500);
16 $js .= get_js_date_picker();
18 if (isset($_GET['ModifyOrderNumber']))
20 page(_("Modify Purchase Order #") . $_GET['ModifyOrderNumber'], false, false, "", $js);
24 page(_("Purchase Order Entry"), false, false, "", $js);
27 //---------------------------------------------------------------------------------------------------
29 check_db_has_suppliers(_("There are no suppliers defined in the system."));
31 check_db_has_purchasable_items(_("There are no purchasable inventory items defined in the system."));
33 //---------------------------------------------------------------------------------------------------------------
35 if (isset($_GET['AddedID']))
37 $order_no = $_GET['AddedID'];
38 $trans_type = systypes::po();
40 if (!isset($_GET['Updated']))
41 display_notification_centered(_("Purchase Order has been entered"));
43 display_notification_centered(_("Purchase Order has been updated") . " #$order_no");
44 display_note(get_trans_view_str($trans_type, $order_no, _("View this order")));
46 hyperlink_params($path_to_root . "/purchasing/po_receive_items.php", _("Receive Items on this Purchase Order"), "PONumber=$order_no");
48 hyperlink_params($_SERVER['PHP_SELF'], _("Enter Another Purchase Order"), "NewOrder=yes");
50 hyperlink_no_params($path_to_root."/purchasing/inquiry/po_search.php", _("Select An Outstanding Purchase Order"));
52 display_footer_exit();
55 //--------------------------------------------------------------------------------------------------
56 function line_start_focus() {
59 $Ajax->activate('items_table');
60 set_focus('_stock_id_edit');
62 //--------------------------------------------------------------------------------------------------
66 $_SESSION['PO']->supplier_id = $_POST['supplier_id'];
67 $_SESSION['PO']->orig_order_date = $_POST['OrderDate'];
68 $_SESSION['PO']->reference = $_POST['ref'];
69 $_SESSION['PO']->requisition_no = $_POST['Requisition'];
70 $_SESSION['PO']->Comments = $_POST['Comments'];
71 $_SESSION['PO']->Location = $_POST['StkLocation'];
72 $_SESSION['PO']->delivery_address = $_POST['delivery_address'];
75 //--------------------------------------------------------------------------------------------------
77 function copy_from_po()
79 $_POST['supplier_id'] = $_SESSION['PO']->supplier_id;
80 $_POST['OrderDate'] = $_SESSION['PO']->orig_order_date;
81 $_POST['Requisition'] = $_SESSION['PO']->requisition_no;
82 $_POST['ref'] = $_SESSION['PO']->reference;
83 $_POST['Comments'] = $_SESSION['PO']->Comments;
84 $_POST['StkLocation'] = $_SESSION['PO']->Location;
85 $_POST['delivery_address'] = $_SESSION['PO']->delivery_address;
88 //--------------------------------------------------------------------------------------------------
90 function unset_form_variables() {
91 unset($_POST['stock_id']);
93 unset($_POST['price']);
94 unset($_POST['req_del_date']);
97 //---------------------------------------------------------------------------------------------------
99 function handle_delete_item($line_no)
101 if($_SESSION['PO']->some_already_received($line_no) == 0)
103 $_SESSION['PO']->remove_from_order($line_no);
104 unset_form_variables();
108 display_error(_("This item cannot be deleted because some of it has already been received."));
113 //---------------------------------------------------------------------------------------------------
115 function handle_cancel_po()
117 global $path_to_root;
119 //need to check that not already dispatched or invoiced by the supplier
120 if(($_SESSION['PO']->order_no != 0) &&
121 $_SESSION['PO']->any_already_received() == 1)
123 display_error(_("This order cannot be cancelled because some of it has already been received.")
124 . "<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."));
128 if($_SESSION['PO']->order_no != 0)
130 delete_po($_SESSION['PO']->order_no);
133 $_SESSION['PO']->clear_items();
134 $_SESSION['PO'] = new purch_order;
136 display_note(_("This purchase order has been cancelled."), 0, 1);
138 hyperlink_params($path_to_root . "/purchasing/po_entry_items.php", _("Enter a new purchase order"), "NewOrder=Yes");
145 //---------------------------------------------------------------------------------------------------
147 function check_data()
149 if (!check_num('qty',0))
151 display_error(_("The quantity of the order item must be numeric and not less than zero."));
156 if (!check_num('price', 0))
158 display_error(_("The price entered must be numeric and not less than zero."));
162 if (!is_date($_POST['req_del_date'])){
163 display_error(_("The date entered is in an invalid format."));
164 set_focus('req_del_date');
171 //---------------------------------------------------------------------------------------------------
173 function handle_update_item()
175 $allow_update = check_data();
178 ($_SESSION['PO']->line_items[$_POST['line_no']]->qty_inv > input_num('qty') ||
179 $_SESSION['PO']->line_items[$_POST['line_no']]->qty_received > input_num('qty')))
181 display_error(_("You are attempting to make the quantity ordered a quantity less than has already been invoiced or received. This is prohibited.") .
182 "<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."));
187 $_SESSION['PO']->update_order_item($_POST['line_no'], input_num('qty'), input_num('price'),
188 $_POST['req_del_date']);
189 unset_form_variables();
193 //---------------------------------------------------------------------------------------------------
195 function handle_add_new_item()
197 $allow_update = check_data();
199 if ($allow_update == true)
201 if (count($_SESSION['PO']->line_items) > 0)
203 foreach ($_SESSION['PO']->line_items as $order_item)
206 /* do a loop round the items on the order to see that the item
207 is not already on this order */
208 if (($order_item->stock_id == $_POST['stock_id']) &&
209 ($order_item->Deleted == false))
211 $allow_update = false;
212 display_error(_("The selected item is already on this order."));
214 } /* end of the foreach loop to look for pre-existing items of the same code */
217 if ($allow_update == true)
219 $sql = "SELECT description, units, mb_flag
220 FROM ".TB_PREF."stock_master WHERE stock_id = '". $_POST['stock_id'] . "'";
222 $result = db_query($sql,"The stock details for " . $_POST['stock_id'] . " could not be retrieved");
224 if (db_num_rows($result) == 0)
226 $allow_update = false;
231 $myrow = db_fetch($result);
232 $_SESSION['PO']->add_to_order ($_POST['line_no'], $_POST['stock_id'], input_num('qty'),
233 $myrow["description"], input_num('price'), $myrow["units"],
234 $_POST['req_del_date'], 0, 0);
236 unset_form_variables();
237 $_POST['stock_id'] = "";
241 display_error(_("The selected item does not exist or it is a kit part and therefore cannot be purchased."));
244 } /* end of if not already on the order and allow input was true*/
249 //---------------------------------------------------------------------------------------------------
251 function can_commit()
253 if (!is_date($_POST['OrderDate']))
255 display_error(_("The entered order date is invalid."));
256 set_focus('OrderDate');
260 if (!$_SESSION['PO']->order_no)
262 if (!references::is_valid($_SESSION['PO']->reference))
264 display_error(_("There is no reference entered for this purchase order."));
269 if (!is_new_reference($_SESSION['PO']->reference, systypes::po()))
271 display_error(_("The entered reference is already in use."));
277 if ($_SESSION['PO']->delivery_address == "")
279 display_error(_("There is no delivery address specified."));
280 set_focus('delivery_address');
284 if (!isset($_SESSION['PO']->Location) || $_SESSION['PO']->Location == "")
286 display_error(_("There is no location specified to move any items into."));
287 set_focus('StkLocation');
291 if ($_SESSION['PO']->order_has_items() == false)
293 display_error (_("The order cannot be placed because there are no lines entered on this order."));
300 //---------------------------------------------------------------------------------------------------
302 function handle_commit_order()
309 if ($_SESSION['PO']->order_no == 0)
312 /*its a new order to be inserted */
313 $order_no = add_po($_SESSION['PO']);
315 unset($_SESSION['PO']);
317 meta_forward($_SERVER['PHP_SELF'], "AddedID=$order_no");
323 /*its an existing order need to update the old order info */
324 $order_no = update_po($_SESSION['PO']);
326 unset($_SESSION['PO']);
328 meta_forward($_SERVER['PHP_SELF'], "AddedID=$order_no&Updated=1");
332 //---------------------------------------------------------------------------------------------------
333 $id = find_submit('Delete');
335 handle_delete_item($id);
337 if (isset($_POST['Delete']) || isset($_POST['Edit']))
342 if (isset($_POST['Commit']))
344 handle_commit_order();
346 if (isset($_POST['UpdateLine']))
349 handle_update_item();
351 if (isset($_POST['EnterLine']))
354 handle_add_new_item();
356 if (isset($_POST['CancelOrder']))
360 if (isset($_POST['CancelUpdate']))
363 unset_form_variables();
365 if (isset($_GET['ModifyOrderNumber']) && $_GET['ModifyOrderNumber'] != "")
369 $_SESSION['PO']->order_no = $_GET['ModifyOrderNumber'];
371 /*read in all the selected order into the Items cart */
372 read_po($_SESSION['PO']->order_no, $_SESSION['PO']);
375 if (isset($_POST['CancelUpdate']) || isset($_POST['UpdateLine'])) {
379 //--------------------------------------------------------------------------------
381 if (isset($_GET['NewOrder']))
387 if (!isset($_POST['supplier_id']))
388 $_POST['supplier_id'] = $_SESSION['PO']->supplier_id;
389 if (!isset($_POST['OrderDate']))
390 $_POST['OrderDate'] = $_SESSION['PO']->orig_order_date;
391 if (!isset($_POST['Requisition']))
392 $_POST['Requisition'] = $_SESSION['PO']->requisition_no;
393 if (!isset($_POST['Comments']))
394 $_POST['Comments'] = $_SESSION['PO']->Comments;
397 //---------------------------------------------------------------------------------------------------
399 start_form(false, true);
401 display_po_header($_SESSION['PO']);
404 display_po_items($_SESSION['PO']);
406 start_table($table_style2);
407 textarea_row(_("Memo:"), 'Comments', null, 70, 4);
411 div_start('controls', 'items_table');
412 if ($_SESSION['PO']->order_has_items())
414 if ($_SESSION['PO']->order_no)
415 submit_center_first('Commit', _("Update Order"));
417 submit_center_first('Commit', _("Place Order"));
418 submit_center_last('CancelOrder', _("Cancel Order"));
421 submit_center('CancelOrder', _("Cancel Order"));
423 //---------------------------------------------------------------------------------------------------