5 include_once($path_to_root . "/purchasing/includes/po_class.inc");
6 include_once($path_to_root . "/includes/session.inc");
7 include_once($path_to_root . "/purchasing/includes/purchasing_ui.inc");
8 include_once($path_to_root . "/reporting/includes/reporting.inc");
11 if ($use_popup_windows)
12 $js .= get_js_open_window(900, 500);
14 $js .= get_js_date_picker();
16 if (isset($_GET['ModifyOrderNumber']))
18 page(_("Modify Purchase Order #") . $_GET['ModifyOrderNumber'], false, false, "", $js);
22 page(_("Purchase Order Entry"), false, false, "", $js);
25 //---------------------------------------------------------------------------------------------------
27 check_db_has_suppliers(_("There are no suppliers defined in the system."));
29 check_db_has_purchasable_items(_("There are no purchasable inventory items defined in the system."));
31 //---------------------------------------------------------------------------------------------------------------
32 if ($ret = context_restore()) {
33 // return from supplier/items editors
35 if(isset($ret['supplier_id']))
36 $_POST['supplier_id'] = $ret['supplier_id'];
37 if(isset($ret['stock_id'])) {
38 $_POST['stock_id'] = $_POST['_stock_id_edit'] = $ret['stock_id'];
42 if (isset($_POST['_supplier_id_editor'])) {
44 context_call($path_to_root.'/purchasing/manage/suppliers.php?supplier_id='.$_POST['supplier_id'], 'PO');
47 if (isset($_POST['_stock_id_editor'])) {
49 context_call($path_to_root.'/inventory/manage/items.php?stock_id='.$_POST['stock_id'], 'PO');
51 //------------------------------------------------------------------------------
53 if (isset($_GET['AddedID']))
55 $order_no = $_GET['AddedID'];
56 $trans_type = systypes::po();
58 if (!isset($_GET['Updated']))
59 display_notification_centered(_("Purchase Order has been entered"));
61 display_notification_centered(_("Purchase Order has been updated") . " #$order_no");
62 display_note(get_trans_view_str($trans_type, $order_no, _("&View this order")));
64 display_note(print_document_link($order_no, _("&Print This Order"), true, $trans_type));
66 hyperlink_params($path_to_root . "/purchasing/po_receive_items.php", _("&Receive Items on this Purchase Order"), "PONumber=$order_no");
68 hyperlink_params($_SERVER['PHP_SELF'], _("Enter &Another Purchase Order"), "NewOrder=yes");
70 hyperlink_no_params($path_to_root."/purchasing/inquiry/po_search.php", _("Select An &Outstanding Purchase Order"));
72 display_footer_exit();
74 //--------------------------------------------------------------------------------------------------
76 function copy_from_cart()
78 $_POST['supplier_id'] = $_SESSION['PO']->supplier_id;
79 $_POST['OrderDate'] = $_SESSION['PO']->orig_order_date;
80 $_POST['Requisition'] = $_SESSION['PO']->requisition_no;
81 $_POST['ref'] = $_SESSION['PO']->reference;
82 $_POST['Comments'] = $_SESSION['PO']->Comments;
83 $_POST['StkLocation'] = $_SESSION['PO']->Location;
84 $_POST['delivery_address'] = $_SESSION['PO']->delivery_address;
87 function copy_to_cart()
89 $_SESSION['PO']->supplier_id = $_POST['supplier_id'];
90 $_SESSION['PO']->orig_order_date = $_POST['OrderDate'];
91 $_SESSION['PO']->reference = $_POST['ref'];
92 $_SESSION['PO']->requisition_no = $_POST['Requisition'];
93 $_SESSION['PO']->Comments = $_POST['Comments'];
94 $_SESSION['PO']->Location = $_POST['StkLocation'];
95 $_SESSION['PO']->delivery_address = $_POST['delivery_address'];
97 //--------------------------------------------------------------------------------------------------
99 function line_start_focus() {
102 $Ajax->activate('items_table');
103 set_focus('_stock_id_edit');
105 //--------------------------------------------------------------------------------------------------
107 function unset_form_variables() {
108 unset($_POST['stock_id']);
109 unset($_POST['qty']);
110 unset($_POST['price']);
111 unset($_POST['req_del_date']);
114 //---------------------------------------------------------------------------------------------------
116 function handle_delete_item($line_no)
118 if($_SESSION['PO']->some_already_received($line_no) == 0)
120 $_SESSION['PO']->remove_from_order($line_no);
121 unset_form_variables();
125 display_error(_("This item cannot be deleted because some of it has already been received."));
130 //---------------------------------------------------------------------------------------------------
132 function handle_cancel_po()
134 global $path_to_root;
136 //need to check that not already dispatched or invoiced by the supplier
137 if(($_SESSION['PO']->order_no != 0) &&
138 $_SESSION['PO']->any_already_received() == 1)
140 display_error(_("This order cannot be cancelled because some of it has already been received.")
141 . "<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."));
145 if($_SESSION['PO']->order_no != 0)
147 delete_po($_SESSION['PO']->order_no);
150 $_SESSION['PO']->clear_items();
151 $_SESSION['PO'] = new purch_order;
153 display_note(_("This purchase order has been cancelled."), 0, 1);
155 hyperlink_params($path_to_root . "/purchasing/po_entry_items.php", _("Enter a new purchase order"), "NewOrder=Yes");
162 //---------------------------------------------------------------------------------------------------
164 function check_data()
166 if (!check_num('qty',0))
168 display_error(_("The quantity of the order item must be numeric and not less than zero."));
173 if (!check_num('price', 0))
175 display_error(_("The price entered must be numeric and not less than zero."));
179 if (!is_date($_POST['req_del_date'])){
180 display_error(_("The date entered is in an invalid format."));
181 set_focus('req_del_date');
188 //---------------------------------------------------------------------------------------------------
190 function handle_update_item()
192 $allow_update = check_data();
195 ($_SESSION['PO']->line_items[$_POST['line_no']]->qty_inv > input_num('qty') ||
196 $_SESSION['PO']->line_items[$_POST['line_no']]->qty_received > input_num('qty')))
198 display_error(_("You are attempting to make the quantity ordered a quantity less than has already been invoiced or received. This is prohibited.") .
199 "<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."));
204 $_SESSION['PO']->update_order_item($_POST['line_no'], input_num('qty'), input_num('price'),
205 $_POST['req_del_date']);
206 unset_form_variables();
210 //---------------------------------------------------------------------------------------------------
212 function handle_add_new_item()
214 $allow_update = check_data();
216 if ($allow_update == true)
218 if (count($_SESSION['PO']->line_items) > 0)
220 foreach ($_SESSION['PO']->line_items as $order_item)
223 /* do a loop round the items on the order to see that the item
224 is not already on this order */
225 if (($order_item->stock_id == $_POST['stock_id']) &&
226 ($order_item->Deleted == false))
228 $allow_update = false;
229 display_error(_("The selected item is already on this order."));
231 } /* end of the foreach loop to look for pre-existing items of the same code */
234 if ($allow_update == true)
236 $sql = "SELECT description, units, mb_flag
237 FROM ".TB_PREF."stock_master WHERE stock_id = '". $_POST['stock_id'] . "'";
239 $result = db_query($sql,"The stock details for " . $_POST['stock_id'] . " could not be retrieved");
241 if (db_num_rows($result) == 0)
243 $allow_update = false;
248 $myrow = db_fetch($result);
249 $_SESSION['PO']->add_to_order ($_POST['line_no'], $_POST['stock_id'], input_num('qty'),
250 $myrow["description"], input_num('price'), $myrow["units"],
251 $_POST['req_del_date'], 0, 0);
253 unset_form_variables();
254 $_POST['stock_id'] = "";
258 display_error(_("The selected item does not exist or it is a kit part and therefore cannot be purchased."));
261 } /* end of if not already on the order and allow input was true*/
266 //---------------------------------------------------------------------------------------------------
268 function can_commit()
270 if (!is_date($_POST['OrderDate']))
272 display_error(_("The entered order date is invalid."));
273 set_focus('OrderDate');
277 if (!$_SESSION['PO']->order_no)
279 if (!references::is_valid(get_post('ref')))
281 display_error(_("There is no reference entered for this purchase order."));
286 if (!is_new_reference(get_post('ref'), systypes::po()))
288 display_error(_("The entered reference is already in use."));
294 if (get_post('delivery_address') == '')
296 display_error(_("There is no delivery address specified."));
297 set_focus('delivery_address');
301 if (get_post('StkLocation') == '')
303 display_error(_("There is no location specified to move any items into."));
304 set_focus('StkLocation');
308 if ($_SESSION['PO']->order_has_items() == false)
310 display_error (_("The order cannot be placed because there are no lines entered on this order."));
317 //---------------------------------------------------------------------------------------------------
319 function handle_commit_order()
326 if ($_SESSION['PO']->order_no == 0)
329 /*its a new order to be inserted */
330 $order_no = add_po($_SESSION['PO']);
332 unset($_SESSION['PO']);
334 meta_forward($_SERVER['PHP_SELF'], "AddedID=$order_no");
340 /*its an existing order need to update the old order info */
341 $order_no = update_po($_SESSION['PO']);
343 unset($_SESSION['PO']);
345 meta_forward($_SERVER['PHP_SELF'], "AddedID=$order_no&Updated=1");
349 //---------------------------------------------------------------------------------------------------
350 $id = find_submit('Delete');
352 handle_delete_item($id);
354 if (isset($_POST['Commit']))
356 handle_commit_order();
358 if (isset($_POST['UpdateLine']))
359 handle_update_item();
361 if (isset($_POST['EnterLine']))
362 handle_add_new_item();
364 if (isset($_POST['CancelOrder']))
367 if (isset($_POST['CancelUpdate']))
368 unset_form_variables();
370 if (isset($_GET['ModifyOrderNumber']) && $_GET['ModifyOrderNumber'] != "")
374 $_SESSION['PO']->order_no = $_GET['ModifyOrderNumber'];
376 /*read in all the selected order into the Items cart */
377 read_po($_SESSION['PO']->order_no, $_SESSION['PO']);
382 if (isset($_POST['CancelUpdate']) || isset($_POST['UpdateLine'])) {
386 if (isset($_GET['NewOrder']))
389 //---------------------------------------------------------------------------------------------------
391 start_form(false, true);
393 display_po_header($_SESSION['PO']);
396 display_po_items($_SESSION['PO']);
398 start_table($table_style2);
399 textarea_row(_("Memo:"), 'Comments', null, 70, 4);
403 div_start('controls', 'items_table');
404 if ($_SESSION['PO']->order_has_items())
406 if ($_SESSION['PO']->order_no)
407 submit_center_first('Commit', _("Update Order"), '', true);
409 submit_center_first('Commit', _("Place Order"), '', true);
410 submit_center_last('CancelOrder', _("Cancel Order"));
413 submit_center('CancelOrder', _("Cancel Order"));
415 //---------------------------------------------------------------------------------------------------