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 //--------------------------------------------------------------------------------------------------
64 function unset_form_variables() {
65 unset($_POST['stock_id']);
67 unset($_POST['price']);
68 unset($_POST['req_del_date']);
71 //---------------------------------------------------------------------------------------------------
73 function handle_delete_item($line_no)
75 if($_SESSION['PO']->some_already_received($line_no) == 0)
77 $_SESSION['PO']->remove_from_order($line_no);
78 unset_form_variables();
82 display_error(_("This item cannot be deleted because some of it has already been received."));
87 //---------------------------------------------------------------------------------------------------
89 function handle_cancel_po()
93 //need to check that not already dispatched or invoiced by the supplier
94 if(($_SESSION['PO']->order_no != 0) &&
95 $_SESSION['PO']->any_already_received() == 1)
97 display_error(_("This order cannot be cancelled because some of it has already been received.")
98 . "<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."));
102 if($_SESSION['PO']->order_no != 0)
104 delete_po($_SESSION['PO']->order_no);
107 $_SESSION['PO']->clear_items();
108 $_SESSION['PO'] = new purch_order;
110 display_note(_("This purchase order has been cancelled."), 0, 1);
112 hyperlink_params($path_to_root . "/purchasing/po_entry_items.php", _("Enter a new purchase order"), "NewOrder=Yes");
119 //---------------------------------------------------------------------------------------------------
121 function check_data()
123 if (!check_num('qty',0))
125 display_error(_("The quantity of the order item must be numeric and not less than zero."));
130 if (!check_num('price', 0))
132 display_error(_("The price entered must be numeric and not less than zero."));
136 if (!is_date($_POST['req_del_date'])){
137 display_error(_("The date entered is in an invalid format."));
138 set_focus('req_del_date');
145 //---------------------------------------------------------------------------------------------------
147 function handle_update_item()
149 $allow_update = check_data();
152 ($_SESSION['PO']->line_items[$_POST['line_no']]->qty_inv > input_num('qty') ||
153 $_SESSION['PO']->line_items[$_POST['line_no']]->qty_received > input_num('qty')))
155 display_error(_("You are attempting to make the quantity ordered a quantity less than has already been invoiced or received. This is prohibited.") .
156 "<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."));
161 $_SESSION['PO']->update_order_item($_POST['line_no'], input_num('qty'), input_num('price'),
162 $_POST['req_del_date']);
163 unset_form_variables();
167 //---------------------------------------------------------------------------------------------------
169 function handle_add_new_item()
171 $allow_update = check_data();
173 if ($allow_update == true)
175 if (count($_SESSION['PO']->line_items) > 0)
177 foreach ($_SESSION['PO']->line_items as $order_item)
180 /* do a loop round the items on the order to see that the item
181 is not already on this order */
182 if (($order_item->stock_id == $_POST['stock_id']) &&
183 ($order_item->Deleted == false))
185 $allow_update = false;
186 display_error(_("The selected item is already on this order."));
188 } /* end of the foreach loop to look for pre-existing items of the same code */
191 if ($allow_update == true)
193 $sql = "SELECT description, units, mb_flag
194 FROM ".TB_PREF."stock_master WHERE stock_id = '". $_POST['stock_id'] . "'";
196 $result = db_query($sql,"The stock details for " . $_POST['stock_id'] . " could not be retrieved");
198 if (db_num_rows($result) == 0)
200 $allow_update = false;
205 $myrow = db_fetch($result);
206 $_SESSION['PO']->add_to_order ($_POST['line_no'], $_POST['stock_id'], input_num('qty'),
207 $myrow["description"], input_num('price'), $myrow["units"],
208 $_POST['req_del_date'], 0, 0);
210 unset_form_variables();
211 $_POST['stock_id'] = "";
215 display_error(_("The selected item does not exist or it is a kit part and therefore cannot be purchased."));
218 } /* end of if not already on the order and allow input was true*/
223 //---------------------------------------------------------------------------------------------------
225 function can_commit()
227 if (!is_date($_POST['OrderDate']))
229 display_error(_("The entered order date is invalid."));
230 set_focus('OrderDate');
234 if (!$_SESSION['PO']->order_no)
236 if (!references::is_valid(get_post('ref')))
238 display_error(_("There is no reference entered for this purchase order."));
243 if (!is_new_reference(get_post('ref'), systypes::po()))
245 display_error(_("The entered reference is already in use."));
251 if (get_post('delivery_address') == '')
253 display_error(_("There is no delivery address specified."));
254 set_focus('delivery_address');
258 if (get_post('StkLocation') == '')
260 display_error(_("There is no location specified to move any items into."));
261 set_focus('StkLocation');
265 if ($_SESSION['PO']->order_has_items() == false)
267 display_error (_("The order cannot be placed because there are no lines entered on this order."));
274 //---------------------------------------------------------------------------------------------------
276 function handle_commit_order()
281 $_SESSION['PO']->supplier_id = $_POST['supplier_id'];
282 $_SESSION['PO']->orig_order_date = $_POST['OrderDate'];
283 $_SESSION['PO']->reference = $_POST['ref'];
284 $_SESSION['PO']->requisition_no = $_POST['Requisition'];
285 $_SESSION['PO']->Comments = $_POST['Comments'];
286 $_SESSION['PO']->Location = $_POST['StkLocation'];
287 $_SESSION['PO']->delivery_address = $_POST['delivery_address'];
289 if ($_SESSION['PO']->order_no == 0)
292 /*its a new order to be inserted */
293 $order_no = add_po($_SESSION['PO']);
295 unset($_SESSION['PO']);
297 meta_forward($_SERVER['PHP_SELF'], "AddedID=$order_no");
303 /*its an existing order need to update the old order info */
304 $order_no = update_po($_SESSION['PO']);
306 unset($_SESSION['PO']);
308 meta_forward($_SERVER['PHP_SELF'], "AddedID=$order_no&Updated=1");
312 //---------------------------------------------------------------------------------------------------
313 $id = find_submit('Delete');
315 handle_delete_item($id);
317 if (isset($_POST['Commit']))
319 handle_commit_order();
321 if (isset($_POST['UpdateLine']))
322 handle_update_item();
324 if (isset($_POST['EnterLine']))
325 handle_add_new_item();
327 if (isset($_POST['CancelOrder']))
330 if (isset($_POST['CancelUpdate']))
331 unset_form_variables();
333 if (isset($_GET['ModifyOrderNumber']) && $_GET['ModifyOrderNumber'] != "")
337 $_SESSION['PO']->order_no = $_GET['ModifyOrderNumber'];
339 /*read in all the selected order into the Items cart */
340 read_po($_SESSION['PO']->order_no, $_SESSION['PO']);
342 $_POST['supplier_id'] = $_SESSION['PO']->supplier_id;
343 $_POST['OrderDate'] = $_SESSION['PO']->orig_order_date;
344 $_POST['Requisition'] = $_SESSION['PO']->requisition_no;
345 $_POST['ref'] = $_SESSION['PO']->reference;
346 $_POST['Comments'] = $_SESSION['PO']->Comments;
347 $_POST['StkLocation'] = $_SESSION['PO']->Location;
348 $_POST['delivery_address'] = $_SESSION['PO']->delivery_address;
351 if (isset($_POST['CancelUpdate']) || isset($_POST['UpdateLine'])) {
355 if (isset($_GET['NewOrder']))
358 //---------------------------------------------------------------------------------------------------
360 start_form(false, true);
362 display_po_header($_SESSION['PO']);
365 display_po_items($_SESSION['PO']);
367 start_table($table_style2);
368 textarea_row(_("Memo:"), 'Comments', null, 70, 4);
372 div_start('controls', 'items_table');
373 if ($_SESSION['PO']->order_has_items())
375 if ($_SESSION['PO']->order_no)
376 submit_center_first('Commit', _("Update Order"), '', true);
378 submit_center_first('Commit', _("Place Order"), '', true);
379 submit_center_last('CancelOrder', _("Cancel Order"));
382 submit_center('CancelOrder', _("Cancel Order"));
384 //---------------------------------------------------------------------------------------------------