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 = 'SA_PURCHASEORDER';
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(_($help_context = "Modify Purchase Order #") . $_GET['ModifyOrderNumber'], false, false, "", $js);
31 page(_($help_context = "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 //---------------------------------------------------------------------------------------------------------------
42 if (isset($_GET['AddedID']))
44 $order_no = $_GET['AddedID'];
45 $trans_type = ST_PURCHORDER;
47 if (!isset($_GET['Updated']))
48 display_notification_centered(_("Purchase Order has been entered"));
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")), 0, 1);
53 display_note(print_document_link($order_no, _("&Print This Order"), true, $trans_type), 0, 1);
55 display_note(print_document_link($order_no, _("&Email This Order"), true, $trans_type, false, "", "", 1));
57 hyperlink_params($path_to_root . "/purchasing/po_receive_items.php", _("&Receive Items on this Purchase Order"), "PONumber=$order_no");
59 hyperlink_params($_SERVER['PHP_SELF'], _("Enter &Another Purchase Order"), "NewOrder=yes");
61 hyperlink_no_params($path_to_root."/purchasing/inquiry/po_search.php", _("Select An &Outstanding Purchase Order"));
63 display_footer_exit();
65 //--------------------------------------------------------------------------------------------------
67 function copy_from_cart()
69 $_POST['supplier_id'] = $_SESSION['PO']->supplier_id;
70 $_POST['OrderDate'] = $_SESSION['PO']->orig_order_date;
71 $_POST['Requisition'] = $_SESSION['PO']->requisition_no;
72 $_POST['ref'] = $_SESSION['PO']->reference;
73 $_POST['Comments'] = $_SESSION['PO']->Comments;
74 $_POST['StkLocation'] = $_SESSION['PO']->Location;
75 $_POST['delivery_address'] = $_SESSION['PO']->delivery_address;
78 function copy_to_cart()
80 $_SESSION['PO']->supplier_id = $_POST['supplier_id'];
81 $_SESSION['PO']->orig_order_date = $_POST['OrderDate'];
82 $_SESSION['PO']->reference = $_POST['ref'];
83 $_SESSION['PO']->requisition_no = $_POST['Requisition'];
84 $_SESSION['PO']->Comments = $_POST['Comments'];
85 $_SESSION['PO']->Location = $_POST['StkLocation'];
86 $_SESSION['PO']->delivery_address = $_POST['delivery_address'];
88 //--------------------------------------------------------------------------------------------------
90 function line_start_focus() {
93 $Ajax->activate('items_table');
94 set_focus('_stock_id_edit');
96 //--------------------------------------------------------------------------------------------------
98 function unset_form_variables() {
99 unset($_POST['stock_id']);
100 unset($_POST['qty']);
101 unset($_POST['price']);
102 unset($_POST['req_del_date']);
105 //---------------------------------------------------------------------------------------------------
107 function handle_delete_item($line_no)
109 if($_SESSION['PO']->some_already_received($line_no) == 0)
111 $_SESSION['PO']->remove_from_order($line_no);
112 unset_form_variables();
116 display_error(_("This item cannot be deleted because some of it has already been received."));
121 //---------------------------------------------------------------------------------------------------
123 function handle_cancel_po()
125 global $path_to_root;
127 //need to check that not already dispatched or invoiced by the supplier
128 if(($_SESSION['PO']->order_no != 0) &&
129 $_SESSION['PO']->any_already_received() == 1)
131 display_error(_("This order cannot be cancelled because some of it has already been received.")
132 . "<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."));
136 if($_SESSION['PO']->order_no != 0)
138 delete_po($_SESSION['PO']->order_no);
140 unset($_SESSION['PO']);
141 meta_forward($path_to_root.'/index.php','application=AP');
144 $_SESSION['PO']->clear_items();
145 $_SESSION['PO'] = new purch_order;
147 display_notification(_("This purchase order has been cancelled."));
149 hyperlink_params($path_to_root . "/purchasing/po_entry_items.php", _("Enter a new purchase order"), "NewOrder=Yes");
156 //---------------------------------------------------------------------------------------------------
158 function check_data()
160 $dec = get_qty_dec($_POST['stock_id']);
161 $min = 1 / pow(10, $dec);
162 if (!check_num('qty',$min))
164 $min = number_format2($min, $dec);
165 display_error(_("The quantity of the order item must be numeric and not less than ").$min);
170 if (!check_num('price', 0))
172 display_error(_("The price entered must be numeric and not less than zero."));
176 if (!is_date($_POST['req_del_date'])){
177 display_error(_("The date entered is in an invalid format."));
178 set_focus('req_del_date');
185 //---------------------------------------------------------------------------------------------------
187 function handle_update_item()
189 $allow_update = check_data();
193 if ($_SESSION['PO']->line_items[$_POST['line_no']]->qty_inv > input_num('qty') ||
194 $_SESSION['PO']->line_items[$_POST['line_no']]->qty_received > input_num('qty'))
196 display_error(_("You are attempting to make the quantity ordered a quantity less than has already been invoiced or received. This is prohibited.") .
197 "<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."));
202 $_SESSION['PO']->update_order_item($_POST['line_no'], input_num('qty'), input_num('price'),
203 $_POST['req_del_date']);
204 unset_form_variables();
209 //---------------------------------------------------------------------------------------------------
211 function handle_add_new_item()
213 $allow_update = check_data();
215 if ($allow_update == true)
217 if (count($_SESSION['PO']->line_items) > 0)
219 foreach ($_SESSION['PO']->line_items as $order_item)
222 /* do a loop round the items on the order to see that the item
223 is not already on this order */
224 if (($order_item->stock_id == $_POST['stock_id']) &&
225 ($order_item->Deleted == false))
227 $allow_update = false;
228 display_error(_("The selected item is already on this order."));
230 } /* end of the foreach loop to look for pre-existing items of the same code */
233 if ($allow_update == true)
235 $result = get_short_info($_POST['stock_id']);
237 if (db_num_rows($result) == 0)
239 $allow_update = false;
244 $myrow = db_fetch($result);
245 $_SESSION['PO']->add_to_order ($_POST['line_no'], $_POST['stock_id'], input_num('qty'),
246 $myrow["description"], input_num('price'), $myrow["units"],
247 $_POST['req_del_date'], 0, 0);
249 unset_form_variables();
250 $_POST['stock_id'] = "";
254 display_error(_("The selected item does not exist or it is a kit part and therefore cannot be purchased."));
257 } /* end of if not already on the order and allow input was true*/
262 //---------------------------------------------------------------------------------------------------
264 function can_commit()
268 if (!is_date($_POST['OrderDate']))
270 display_error(_("The entered order date is invalid."));
271 set_focus('OrderDate');
275 if (!$_SESSION['PO']->order_no)
277 if (!$Refs->is_valid(get_post('ref')))
279 display_error(_("There is no reference entered for this purchase order."));
284 if (!is_new_reference(get_post('ref'), ST_PURCHORDER))
286 display_error(_("The entered reference is already in use."));
292 if (get_post('delivery_address') == '')
294 display_error(_("There is no delivery address specified."));
295 set_focus('delivery_address');
299 if (get_post('StkLocation') == '')
301 display_error(_("There is no location specified to move any items into."));
302 set_focus('StkLocation');
306 if ($_SESSION['PO']->order_has_items() == false)
308 display_error (_("The order cannot be placed because there are no lines entered on this order."));
315 //---------------------------------------------------------------------------------------------------
317 function handle_commit_order()
324 if ($_SESSION['PO']->order_no == 0)
327 /*its a new order to be inserted */
328 $order_no = add_po($_SESSION['PO']);
329 new_doc_date($_SESSION['PO']->orig_order_date);
330 unset($_SESSION['PO']);
332 meta_forward($_SERVER['PHP_SELF'], "AddedID=$order_no");
338 /*its an existing order need to update the old order info */
339 $order_no = update_po($_SESSION['PO']);
341 unset($_SESSION['PO']);
343 meta_forward($_SERVER['PHP_SELF'], "AddedID=$order_no&Updated=1");
347 //---------------------------------------------------------------------------------------------------
348 $id = find_submit('Delete');
350 handle_delete_item($id);
352 if (isset($_POST['Commit']))
354 handle_commit_order();
356 if (isset($_POST['UpdateLine']))
357 handle_update_item();
359 if (isset($_POST['EnterLine']))
360 handle_add_new_item();
362 if (isset($_POST['CancelOrder']))
365 if (isset($_POST['CancelUpdate']))
366 unset_form_variables();
368 if (isset($_GET['ModifyOrderNumber']) && $_GET['ModifyOrderNumber'] != "")
372 $_SESSION['PO']->order_no = $_GET['ModifyOrderNumber'];
374 /*read in all the selected order into the Items cart */
375 read_po($_SESSION['PO']->order_no, $_SESSION['PO']);
380 if (isset($_POST['CancelUpdate']) || isset($_POST['UpdateLine'])) {
384 if (isset($_GET['NewOrder']))
387 //---------------------------------------------------------------------------------------------------
391 display_po_header($_SESSION['PO']);
394 display_po_items($_SESSION['PO']);
396 start_table($table_style2);
397 textarea_row(_("Memo:"), 'Comments', null, 70, 4);
401 div_start('controls', 'items_table');
402 if ($_SESSION['PO']->order_has_items())
404 if ($_SESSION['PO']->order_no)
405 submit_center_first('Commit', _("Update Order"), '', 'default');
407 submit_center_first('Commit', _("Place Order"), '', 'default');
408 submit_center_last('CancelOrder', _("Cancel Order"));
411 submit_center('CancelOrder', _("Cancel Order"), true, false, 'cancel');
413 //---------------------------------------------------------------------------------------------------