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_WORKORDERENTRY';
15 include_once($path_to_root . "/includes/session.inc");
17 include_once($path_to_root . "/includes/date_functions.inc");
18 include_once($path_to_root . "/includes/data_checks.inc");
20 include_once($path_to_root . "/manufacturing/includes/manufacturing_db.inc");
21 include_once($path_to_root . "/manufacturing/includes/manufacturing_ui.inc");
24 if ($SysPrefs->use_popup_windows)
25 $js .= get_js_open_window(900, 500);
26 if (user_use_date_picker())
27 $js .= get_js_date_picker();
28 page(_($help_context = "Work Order Entry"), false, false, "", $js);
31 check_db_has_manufacturable_items(_("There are no manufacturable items defined in the system."));
33 check_db_has_locations(("There are no inventory locations defined in the system."));
35 //---------------------------------------------------------------------------------------
37 if (isset($_GET['trans_no']))
39 $selected_id = $_GET['trans_no'];
41 elseif(isset($_POST['selected_id']))
43 $selected_id = $_POST['selected_id'];
46 //---------------------------------------------------------------------------------------
48 if (isset($_GET['AddedID']))
50 $id = $_GET['AddedID'];
51 $stype = ST_WORKORDER;
53 display_notification_centered(_("The work order been added."));
55 display_note(get_trans_view_str($stype, $id, _("View this Work Order")), 0, 1);
57 if ($_GET['type'] != WO_ADVANCED)
59 include_once($path_to_root . "/reporting/includes/reporting.inc");
61 submenu_print(_("&Print This Work Order"), ST_WORKORDER, $id, 'prtopt');
62 submenu_print(_("&Email This Work Order"), ST_WORKORDER, $id, null, 1);
63 display_note(get_gl_view_str($stype, $id, _("View the GL Journal Entries for this Work Order")), 1);
64 $ar = array('PARAM_0' => $_GET['date'], 'PARAM_1' => $_GET['date'], 'PARAM_2' => $stype, 'PARAM_3' => '',
65 'PARAM_4' => (user_def_print_orientation() == 1 ? 1 : 0));
66 display_note(print_link(_("Print the GL Journal Entries for this Work Order"), 702, $ar), 1);
67 hyperlink_params("$path_to_root/admin/attachments.php", _("Add an Attachment"), "filterType=$stype&trans_no=$id");
73 //---------------------------------------------------------------------------------------
75 if (isset($_GET['UpdatedID']))
77 $id = $_GET['UpdatedID'];
79 display_notification_centered(_("The work order been updated."));
83 //---------------------------------------------------------------------------------------
85 if (isset($_GET['DeletedID']))
87 $id = $_GET['DeletedID'];
89 display_notification_centered(_("Work order has been deleted."));
93 //---------------------------------------------------------------------------------------
95 if (isset($_GET['ClosedID']))
97 $id = $_GET['ClosedID'];
99 display_notification_centered(_("This work order has been closed. There can be no more issues against it.") . " #$id");
103 //---------------------------------------------------------------------------------------
107 global $path_to_root;
109 hyperlink_no_params("", _("Enter a new work order"));
110 hyperlink_no_params("search_work_orders.php", _("Select an existing work order"));
112 display_footer_exit();
115 //-------------------------------------------------------------------------------------
116 if (!isset($_POST['date_']))
118 $_POST['date_'] = new_doc_date();
119 if (!is_date_in_fiscalyear($_POST['date_']))
120 $_POST['date_'] = end_fiscalyear();
123 function can_process()
125 global $selected_id, $SysPrefs, $Refs;
127 if (!isset($selected_id))
129 if (!check_reference($_POST['wo_ref'], ST_WORKORDER))
136 if (!check_num('quantity', 0))
138 display_error( _("The quantity entered is invalid or less than zero."));
139 set_focus('quantity');
143 if (!is_date($_POST['date_']))
145 display_error( _("The date entered is in an invalid format."));
149 elseif (!is_date_in_fiscalyear($_POST['date_']))
151 display_error(_("The entered date is out of fiscal year or is closed for further data entry."));
155 // only check bom and quantites if quick assembly
156 if (!($_POST['type'] == WO_ADVANCED))
158 if (!has_bom($_POST['stock_id']))
160 display_error(_("The selected item to manufacture does not have a bom."));
161 set_focus('stock_id');
165 if ($_POST['Labour'] == "")
166 $_POST['Labour'] = price_format(0);
167 if (!check_num('Labour', 0))
169 display_error( _("The labour cost entered is invalid or less than zero."));
173 if ($_POST['Costs'] == "")
174 $_POST['Costs'] = price_format(0);
175 if (!check_num('Costs', 0))
177 display_error( _("The cost entered is invalid or less than zero."));
182 if (!$SysPrefs->allow_negative_stock())
184 if ($_POST['type'] == WO_ASSEMBLY)
186 // check bom if assembling
187 $result = get_bom($_POST['stock_id']);
189 while ($bom_item = db_fetch($result))
192 if (has_stock_holding($bom_item["ResourceType"]))
195 $quantity = $bom_item["quantity"] * input_num('quantity');
197 if (check_negative_stock($bom_item["component"], -$quantity, $bom_item["loc_code"], $_POST['date_']))
199 display_error(_("The work order cannot be processed because there is an insufficient quantity for component:") .
200 " " . $bom_item["component"] . " - " . $bom_item["description"] . ". " . _("Location:") . " " . $bom_item["location_name"]);
201 set_focus('quantity');
207 elseif ($_POST['type'] == WO_UNASSEMBLY)
209 // if unassembling, check item to unassemble
210 if (check_negative_stock($_POST['stock_id'], -input_num('quantity'), $_POST['StockLocation'], $_POST['date_']))
212 display_error(_("The selected item cannot be unassembled because there is insufficient stock."));
220 if (!is_date($_POST['RequDate']))
222 set_focus('RequDate');
223 display_error( _("The date entered is in an invalid format."));
226 //elseif (!is_date_in_fiscalyear($_POST['RequDate']))
228 // display_error(_("The entered date is out of fiscal year or is closed for further data entry."));
231 if (isset($selected_id))
233 $myrow = get_work_order($selected_id, true);
235 if ($_POST['units_issued'] > input_num('quantity'))
237 set_focus('quantity');
238 display_error(_("The quantity cannot be changed to be less than the quantity already manufactured for this order."));
247 //-------------------------------------------------------------------------------------
249 if (isset($_POST['ADD_ITEM']) && can_process())
251 if (!isset($_POST['cr_acc']))
252 $_POST['cr_acc'] = "";
253 if (!isset($_POST['cr_lab_acc']))
254 $_POST['cr_lab_acc'] = "";
255 $id = add_work_order($_POST['wo_ref'], $_POST['StockLocation'], input_num('quantity'),
256 $_POST['stock_id'], $_POST['type'], $_POST['date_'],
257 $_POST['RequDate'], $_POST['memo_'], input_num('Costs'), $_POST['cr_acc'], input_num('Labour'), $_POST['cr_lab_acc']);
259 new_doc_date($_POST['date_']);
260 meta_forward($_SERVER['PHP_SELF'], "AddedID=$id&type=".$_POST['type']."&date=".$_POST['date_']);
263 //-------------------------------------------------------------------------------------
265 if (isset($_POST['UPDATE_ITEM']) && can_process())
268 update_work_order($selected_id, $_POST['StockLocation'], input_num('quantity'),
269 $_POST['stock_id'], $_POST['date_'], $_POST['RequDate'], $_POST['memo_'],
270 $_POST['old_stk_id'], $_POST['old_qty']);
271 new_doc_date($_POST['date_']);
272 meta_forward($_SERVER['PHP_SELF'], "UpdatedID=$selected_id");
275 //--------------------------------------------------------------------------------------
277 if (isset($_POST['delete']))
279 //the link to delete a selected record was clicked instead of the submit button
281 $cancel_delete = false;
283 // can't delete it there are productions or issues
284 if (work_order_has_productions($selected_id) ||
285 work_order_has_issues($selected_id) ||
286 work_order_has_payments($selected_id))
288 display_error(_("This work order cannot be deleted because it has already been processed."));
289 $cancel_delete = true;
292 if ($cancel_delete == false)
293 { //ie not cancelled the delete as a result of above tests
295 // delete the actual work order
296 delete_work_order($selected_id, $_POST['stock_id'], $_POST['quantity'], $_POST['date_']);
297 meta_forward($_SERVER['PHP_SELF'], "DeletedID=$selected_id");
301 //-------------------------------------------------------------------------------------
303 if (isset($_POST['close']))
306 // update the closed flag in the work order
307 close_work_order($selected_id);
308 meta_forward($_SERVER['PHP_SELF'], "ClosedID=$selected_id");
311 //-------------------------------------------------------------------------------------
312 if (get_post('_type_update'))
314 $Ajax->activate('_page_body');
316 //-------------------------------------------------------------------------------------
320 start_table(TABLESTYLE2);
322 $existing_comments = "";
325 if (isset($selected_id))
327 $myrow = get_work_order($selected_id);
329 if (strlen($myrow[0]) == 0)
331 echo _("The order number sent is not valid.");
335 // if it's a closed work order can't edit it
336 if ($myrow["closed"] == 1)
339 display_error(_("This work order is closed and cannot be edited."));
343 $_POST['wo_ref'] = $myrow["wo_ref"];
344 $_POST['stock_id'] = $myrow["stock_id"];
345 //$_POST['quantity'] = qty_format($myrow["units_reqd"], $_POST['stock_id'], $dec);
346 $_POST['quantity'] = $myrow["units_reqd"];
347 $_POST['StockLocation'] = $myrow["loc_code"];
348 $_POST['released'] = $myrow["released"];
349 $_POST['closed'] = $myrow["closed"];
350 $_POST['type'] = $myrow["type"];
351 $_POST['date_'] = sql2date($myrow["date_"]);
352 $_POST['RequDate'] = sql2date($myrow["required_by"]);
353 $_POST['released_date'] = sql2date($myrow["released_date"]);
354 $_POST['memo_'] = "";
355 $_POST['units_issued'] = $myrow["units_issued"];
356 $_POST['Costs'] = price_format($myrow["additional_costs"]);
358 $_POST['memo_'] = get_comments_string(ST_WORKORDER, $selected_id);
360 hidden('wo_ref', $_POST['wo_ref']);
361 hidden('units_issued', $_POST['units_issued']);
362 hidden('released', $_POST['released']);
363 hidden('released_date', $_POST['released_date']);
364 hidden('selected_id', $selected_id);
365 hidden('old_qty', $myrow["units_reqd"]);
366 hidden('old_stk_id', $myrow["stock_id"]);
368 label_row(_("Reference:"), $_POST['wo_ref']);
369 label_row(_("Type:"), $wo_types_array[$_POST['type']]);
370 hidden('type', $myrow["type"]);
374 $_POST['units_issued'] = $_POST['released'] = 0;
375 ref_row(_("Reference:"), 'wo_ref', '', $Refs->get_next(ST_WORKORDER, null, get_post('date_')), false, ST_WORKORDER);
377 wo_types_list_row(_("Type:"), 'type', null);
380 if (get_post('released'))
382 hidden('stock_id', $_POST['stock_id']);
383 hidden('StockLocation', $_POST['StockLocation']);
384 hidden('type', $_POST['type']);
386 label_row(_("Item:"), $myrow["StockItemName"]);
387 label_row(_("Destination Location:"), $myrow["location_name"]);
391 stock_manufactured_items_list_row(_("Item:"), 'stock_id', null, false, true);
392 if (list_updated('stock_id'))
393 $Ajax->activate('quantity');
395 locations_list_row(_("Destination Location:"), 'StockLocation', null);
398 if (!isset($_POST['quantity']))
399 $_POST['quantity'] = qty_format(1, $_POST['stock_id'], $dec);
401 $_POST['quantity'] = qty_format($_POST['quantity'], $_POST['stock_id'], $dec);
404 if (get_post('type') == WO_ADVANCED)
406 qty_row(_("Quantity Required:"), 'quantity', null, null, null, $dec);
407 if ($_POST['released'])
408 label_row(_("Quantity Manufactured:"), number_format($_POST['units_issued'], get_qty_dec($_POST['stock_id'])));
409 date_row(_("Date") . ":", 'date_', '', true);
410 date_row(_("Date Required By") . ":", 'RequDate', '', null, $SysPrefs->default_wo_required_by());
414 qty_row(_("Quantity:"), 'quantity', null, null, null, $dec);
415 date_row(_("Date") . ":", 'date_', '', true);
416 hidden('RequDate', '');
418 $bank_act = get_default_bank_account();
419 if (!isset($_POST['Labour']))
421 $_POST['Labour'] = price_format(0);
422 $_POST['cr_lab_acc'] = $bank_act['account_code'];
425 amount_row($wo_cost_types[WO_LABOUR], 'Labour');
426 gl_all_accounts_list_row(_("Credit Labour Account"), 'cr_lab_acc', null);
427 if (!isset($_POST['Costs']))
429 $_POST['Costs'] = price_format(0);
430 $_POST['cr_acc'] = $bank_act['account_code'];
432 amount_row($wo_cost_types[WO_OVERHEAD], 'Costs');
433 gl_all_accounts_list_row(_("Credit Overhead Account"), 'cr_acc', null);
437 if (get_post('released'))
438 label_row(_("Released On:"),$_POST['released_date']);
440 textarea_row(_("Memo:"), 'memo_', null, 40, 5);
444 if (isset($selected_id))
446 echo "<table align=center><tr>";
448 submit_cells('UPDATE_ITEM', _("Update"), '', _('Save changes to work order'), 'default');
449 if (get_post('released'))
451 submit_cells('close', _("Close This Work Order"),'','',true);
453 submit_cells('delete', _("Delete This Work Order"),'','',true);
455 echo "</tr></table>";
459 submit_center('ADD_ITEM', _("Add Workorder"), true, '', 'default');