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 ***********************************************************************/
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");
20 if ($use_popup_windows)
21 $js .= get_js_open_window(900, 500);
23 $js .= get_js_date_picker();
25 if (isset($_GET['ModifyOrderNumber']))
27 page(_("Modify Purchase Order #") . $_GET['ModifyOrderNumber'], false, false, "", $js);
31 page(_("Purchase Order Entry"), false, false, "", $js);
34 //---------------------------------------------------------------------------------------------------
36 check_db_has_suppliers(_("There are no suppliers defined in the system."));
38 check_db_has_purchasable_items(_("There are no purchasable inventory items defined in the system."));
40 //---------------------------------------------------------------------------------------------------------------
41 if ($ret = context_restore()) {
42 // return from supplier/items editors
44 if(isset($ret['supplier_id']))
45 $_POST['supplier_id'] = $ret['supplier_id'];
46 if(isset($ret['stock_id'])) {
47 $_POST['stock_id'] = $_POST['_stock_id_edit'] = $ret['stock_id'];
51 if (isset($_POST['_supplier_id_editor'])) {
53 context_call($path_to_root.'/purchasing/manage/suppliers.php?supplier_id='.$_POST['supplier_id'], 'PO');
56 if (isset($_POST['_stock_id_editor'])) {
58 context_call($path_to_root.'/inventory/manage/items.php?stock_id='.$_POST['stock_id'], 'PO');
60 //------------------------------------------------------------------------------
62 if (isset($_GET['AddedID']))
64 $order_no = $_GET['AddedID'];
65 $trans_type = systypes::po();
67 if (!isset($_GET['Updated']))
68 display_notification_centered(_("Purchase Order has been entered"));
70 display_notification_centered(_("Purchase Order has been updated") . " #$order_no");
71 display_note(get_trans_view_str($trans_type, $order_no, _("&View this order")));
73 display_note(print_document_link($order_no, _("&Print This Order"), true, $trans_type));
75 hyperlink_params($path_to_root . "/purchasing/po_receive_items.php", _("&Receive Items on this Purchase Order"), "PONumber=$order_no");
77 hyperlink_params($_SERVER['PHP_SELF'], _("Enter &Another Purchase Order"), "NewOrder=yes");
79 hyperlink_no_params($path_to_root."/purchasing/inquiry/po_search.php", _("Select An &Outstanding Purchase Order"));
81 display_footer_exit();
83 //--------------------------------------------------------------------------------------------------
85 function copy_from_cart()
87 $_POST['supplier_id'] = $_SESSION['PO']->supplier_id;
88 $_POST['OrderDate'] = $_SESSION['PO']->orig_order_date;
89 $_POST['Requisition'] = $_SESSION['PO']->requisition_no;
90 $_POST['ref'] = $_SESSION['PO']->reference;
91 $_POST['Comments'] = $_SESSION['PO']->Comments;
92 $_POST['StkLocation'] = $_SESSION['PO']->Location;
93 $_POST['delivery_address'] = $_SESSION['PO']->delivery_address;
96 function copy_to_cart()
98 $_SESSION['PO']->supplier_id = $_POST['supplier_id'];
99 $_SESSION['PO']->orig_order_date = $_POST['OrderDate'];
100 $_SESSION['PO']->reference = $_POST['ref'];
101 $_SESSION['PO']->requisition_no = $_POST['Requisition'];
102 $_SESSION['PO']->Comments = $_POST['Comments'];
103 $_SESSION['PO']->Location = $_POST['StkLocation'];
104 $_SESSION['PO']->delivery_address = $_POST['delivery_address'];
106 //--------------------------------------------------------------------------------------------------
108 function line_start_focus() {
111 $Ajax->activate('items_table');
112 set_focus('_stock_id_edit');
114 //--------------------------------------------------------------------------------------------------
116 function unset_form_variables() {
117 unset($_POST['stock_id']);
118 unset($_POST['qty']);
119 unset($_POST['price']);
120 unset($_POST['req_del_date']);
123 //---------------------------------------------------------------------------------------------------
125 function handle_delete_item($line_no)
127 if($_SESSION['PO']->some_already_received($line_no) == 0)
129 $_SESSION['PO']->remove_from_order($line_no);
130 unset_form_variables();
134 display_error(_("This item cannot be deleted because some of it has already been received."));
139 //---------------------------------------------------------------------------------------------------
141 function handle_cancel_po()
143 global $path_to_root;
145 //need to check that not already dispatched or invoiced by the supplier
146 if(($_SESSION['PO']->order_no != 0) &&
147 $_SESSION['PO']->any_already_received() == 1)
149 display_error(_("This order cannot be cancelled because some of it has already been received.")
150 . "<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."));
154 if($_SESSION['PO']->order_no != 0)
156 delete_po($_SESSION['PO']->order_no);
158 unset($_SESSION['PO']);
159 meta_forward($path_to_root.'/index.php','application=AP');
162 $_SESSION['PO']->clear_items();
163 $_SESSION['PO'] = new purch_order;
165 display_notification(_("This purchase order has been cancelled."));
167 hyperlink_params($path_to_root . "/purchasing/po_entry_items.php", _("Enter a new purchase order"), "NewOrder=Yes");
174 //---------------------------------------------------------------------------------------------------
176 function check_data()
178 if (!check_num('qty',0))
180 display_error(_("The quantity of the order item must be numeric and not less than zero."));
185 if (!check_num('price', 0))
187 display_error(_("The price entered must be numeric and not less than zero."));
191 if (!is_date($_POST['req_del_date'])){
192 display_error(_("The date entered is in an invalid format."));
193 set_focus('req_del_date');
200 //---------------------------------------------------------------------------------------------------
202 function handle_update_item()
204 $allow_update = check_data();
207 ($_SESSION['PO']->line_items[$_POST['line_no']]->qty_inv > input_num('qty') ||
208 $_SESSION['PO']->line_items[$_POST['line_no']]->qty_received > input_num('qty')))
210 display_error(_("You are attempting to make the quantity ordered a quantity less than has already been invoiced or received. This is prohibited.") .
211 "<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."));
216 $_SESSION['PO']->update_order_item($_POST['line_no'], input_num('qty'), input_num('price'),
217 $_POST['req_del_date']);
218 unset_form_variables();
222 //---------------------------------------------------------------------------------------------------
224 function handle_add_new_item()
226 $allow_update = check_data();
228 if ($allow_update == true)
230 if (count($_SESSION['PO']->line_items) > 0)
232 foreach ($_SESSION['PO']->line_items as $order_item)
235 /* do a loop round the items on the order to see that the item
236 is not already on this order */
237 if (($order_item->stock_id == $_POST['stock_id']) &&
238 ($order_item->Deleted == false))
240 $allow_update = false;
241 display_error(_("The selected item is already on this order."));
243 } /* end of the foreach loop to look for pre-existing items of the same code */
246 if ($allow_update == true)
248 $sql = "SELECT description, units, mb_flag
249 FROM ".TB_PREF."stock_master WHERE stock_id = '". $_POST['stock_id'] . "'";
251 $result = db_query($sql,"The stock details for " . $_POST['stock_id'] . " could not be retrieved");
253 if (db_num_rows($result) == 0)
255 $allow_update = false;
260 $myrow = db_fetch($result);
261 $_SESSION['PO']->add_to_order ($_POST['line_no'], $_POST['stock_id'], input_num('qty'),
262 $myrow["description"], input_num('price'), $myrow["units"],
263 $_POST['req_del_date'], 0, 0);
265 unset_form_variables();
266 $_POST['stock_id'] = "";
270 display_error(_("The selected item does not exist or it is a kit part and therefore cannot be purchased."));
273 } /* end of if not already on the order and allow input was true*/
278 //---------------------------------------------------------------------------------------------------
280 function can_commit()
282 if (!is_date($_POST['OrderDate']))
284 display_error(_("The entered order date is invalid."));
285 set_focus('OrderDate');
289 if (!$_SESSION['PO']->order_no)
291 if (!references::is_valid(get_post('ref')))
293 display_error(_("There is no reference entered for this purchase order."));
298 if (!is_new_reference(get_post('ref'), systypes::po()))
300 display_error(_("The entered reference is already in use."));
306 if (get_post('delivery_address') == '')
308 display_error(_("There is no delivery address specified."));
309 set_focus('delivery_address');
313 if (get_post('StkLocation') == '')
315 display_error(_("There is no location specified to move any items into."));
316 set_focus('StkLocation');
320 if ($_SESSION['PO']->order_has_items() == false)
322 display_error (_("The order cannot be placed because there are no lines entered on this order."));
329 //---------------------------------------------------------------------------------------------------
331 function handle_commit_order()
338 if ($_SESSION['PO']->order_no == 0)
341 /*its a new order to be inserted */
342 $order_no = add_po($_SESSION['PO']);
343 new_doc_date($_SESSION['PO']->orig_order_date);
344 unset($_SESSION['PO']);
346 meta_forward($_SERVER['PHP_SELF'], "AddedID=$order_no");
352 /*its an existing order need to update the old order info */
353 $order_no = update_po($_SESSION['PO']);
355 unset($_SESSION['PO']);
357 meta_forward($_SERVER['PHP_SELF'], "AddedID=$order_no&Updated=1");
361 //---------------------------------------------------------------------------------------------------
362 $id = find_submit('Delete');
364 handle_delete_item($id);
366 if (isset($_POST['Commit']))
368 handle_commit_order();
370 if (isset($_POST['UpdateLine']))
371 handle_update_item();
373 if (isset($_POST['EnterLine']))
374 handle_add_new_item();
376 if (isset($_POST['CancelOrder']))
379 if (isset($_POST['CancelUpdate']))
380 unset_form_variables();
382 if (isset($_GET['ModifyOrderNumber']) && $_GET['ModifyOrderNumber'] != "")
386 $_SESSION['PO']->order_no = $_GET['ModifyOrderNumber'];
388 /*read in all the selected order into the Items cart */
389 read_po($_SESSION['PO']->order_no, $_SESSION['PO']);
394 if (isset($_POST['CancelUpdate']) || isset($_POST['UpdateLine'])) {
398 if (isset($_GET['NewOrder']))
401 //---------------------------------------------------------------------------------------------------
405 display_po_header($_SESSION['PO']);
408 display_po_items($_SESSION['PO']);
410 start_table($table_style2);
411 textarea_row(_("Memo:"), 'Comments', null, 70, 4);
415 div_start('controls', 'items_table');
416 if ($_SESSION['PO']->order_has_items())
418 if ($_SESSION['PO']->order_no)
419 submit_center_first('Commit', _("Update Order"), '', 'default');
421 submit_center_first('Commit', _("Place Order"), '', 'default');
422 submit_center_last('CancelOrder', _("Cancel Order"));
425 submit_center('CancelOrder', _("Cancel Order"), true, false, 'cancel');
427 //---------------------------------------------------------------------------------------------------