6 include_once($path_to_root . "/includes/session.inc");
8 include_once($path_to_root . "/includes/date_functions.inc");
9 include_once($path_to_root . "/includes/manufacturing.inc");
10 include_once($path_to_root . "/includes/data_checks.inc");
12 include_once($path_to_root . "/manufacturing/includes/manufacturing_db.inc");
13 include_once($path_to_root . "/manufacturing/includes/manufacturing_ui.inc");
17 $js .= get_js_date_picker();
18 page(_("Work Order Entry"), false, false, "", $js);
21 check_db_has_manufacturable_items(_("There are no manufacturable items defined in the system."));
23 check_db_has_locations(("There are no inventory locations defined in the system."));
25 //---------------------------------------------------------------------------------------
27 if (isset($_GET['trans_no']))
29 $selected_id = $_GET['trans_no'];
31 elseif(isset($_POST['selected_id']))
33 $selected_id = $_POST['selected_id'];
36 //---------------------------------------------------------------------------------------
38 if (isset($_GET['AddedID']))
40 $id = $_GET['AddedID'];
42 display_notification_centered(_("The work order been added."));
47 //---------------------------------------------------------------------------------------
49 if (isset($_GET['UpdatedID']))
51 $id = $_GET['UpdatedID'];
53 display_notification_centered(_("The work order been updated."));
57 //---------------------------------------------------------------------------------------
59 if (isset($_GET['DeletedID']))
61 $id = $_GET['DeletedID'];
63 display_notification_centered(_("Work order has been deleted."));
67 //---------------------------------------------------------------------------------------
69 if (isset($_GET['ClosedID']))
71 $id = $_GET['ClosedID'];
73 display_notification_centered(_("This work order has been closed. There can be no more issues against it.") . " #$id");
77 //---------------------------------------------------------------------------------------
83 hyperlink_no_params("", _("Enter a new work order"));
84 hyperlink_no_params("search_work_orders.php", _("Select an existing work order"));
91 //-------------------------------------------------------------------------------------
92 if (!isset($_POST['date_']))
94 $_POST['date_'] = Today();
95 if (!is_date_in_fiscalyear($_POST['date_']))
96 $_POST['date_'] = end_fiscalyear();
99 function can_process()
103 if (!isset($selected_id))
105 if (!references::is_valid($_POST['wo_ref']))
107 display_error(_("You must enter a reference."));
112 if (!is_new_reference($_POST['wo_ref'], systypes::work_order()))
114 display_error(_("The entered reference is already in use."));
120 if (!check_num('quantity', 0))
122 display_error( _("The quantity entered is invalid or less than zero."));
123 set_focus('quantity');
127 if (!is_date($_POST['date_']))
129 display_error( _("The date entered is in an invalid format."));
133 elseif (!is_date_in_fiscalyear($_POST['date_']))
135 display_error(_("The entered date is not in fiscal year."));
139 // only check bom and quantites if quick assembly
140 if (!($_POST['type'] == wo_types::advanced()))
142 if (!has_bom($_POST['stock_id']))
144 display_error(_("The selected item to manufacture does not have a bom."));
145 set_focus('stock_id');
149 if ($_POST['Costs'] == "")
150 $_POST['Costs'] = price_format(0);
151 if (!check_num('Costs', 0))
153 display_error( _("The cost entered is invalid or less than zero."));
158 if (!sys_prefs::allow_negative_stock())
160 if ($_POST['type'] == wo_types::assemble())
162 // check bom if assembling
163 $result = get_bom($_POST['stock_id']);
165 while ($bom_item = db_fetch($result))
168 if (has_stock_holding($bom_item["ResourceType"]))
171 $quantity = $bom_item["quantity"] * input_num('quantity');
173 $qoh = get_qoh_on_date($bom_item["component"], $bom_item["loc_code"], $_POST['date_']);
174 if (-$quantity + $qoh < 0)
176 display_error(_("The work order cannot be processed because there is an insufficient quantity for component:") .
177 " " . $bom_item["component"] . " - " . $bom_item["description"] . ". " . _("Location:") . " " . $bom_item["location_name"]);
178 set_focus('quantity');
184 elseif ($_POST['type'] == wo_types::unassemble())
186 // if unassembling, check item to unassemble
187 $qoh = get_qoh_on_date($_POST['stock_id'], $_POST['StockLocation'], $_POST['date_']);
188 if (-input_num('quantity') + $qoh < 0)
190 display_error(_("The selected item cannot be unassembled because there is insufficient stock."));
198 if (!is_date($_POST['RequDate']))
200 set_focus('RequDate');
201 display_error( _("The date entered is in an invalid format."));
204 //elseif (!is_date_in_fiscalyear($_POST['RequDate']))
206 // display_error(_("The entered date is not in fiscal year."));
209 if (isset($selected_id))
211 $myrow = get_work_order($selected_id, true);
213 if ($_POST['units_issued'] > input_num('quantity'))
215 set_focus('quantity');
216 display_error(_("The quantity cannot be changed to be less than the quantity already manufactured for this order."));
225 //-------------------------------------------------------------------------------------
227 if (isset($_POST['ADD_ITEM']) && can_process())
230 $id = add_work_order($_POST['wo_ref'], $_POST['StockLocation'], input_num('quantity'),
231 $_POST['stock_id'], $_POST['type'], $_POST['date_'],
232 $_POST['RequDate'], input_num('Costs'), $_POST['memo_']);
234 meta_forward($_SERVER['PHP_SELF'], "AddedID=$id");
237 //-------------------------------------------------------------------------------------
239 if (isset($_POST['UPDATE_ITEM']) && can_process())
242 update_work_order($selected_id, $_POST['StockLocation'], input_num('quantity'),
243 $_POST['stock_id'], $_POST['date_'], $_POST['RequDate'], $_POST['memo_']);
245 meta_forward($_SERVER['PHP_SELF'], "UpdatedID=$selected_id");
248 //--------------------------------------------------------------------------------------
250 if (isset($_POST['delete']))
252 //the link to delete a selected record was clicked instead of the submit button
254 $cancel_delete = false;
256 // can't delete it there are productions or issues
257 if (work_order_has_productions($selected_id) ||
258 work_order_has_issues($selected_id) ||
259 work_order_has_payments($selected_id))
261 display_error(_("This work order cannot be deleted because it has already been processed."));
262 $cancel_delete = true;
265 if ($cancel_delete == false)
266 { //ie not cancelled the delete as a result of above tests
268 // delete the actual work order
269 delete_work_order($selected_id);
270 meta_forward($_SERVER['PHP_SELF'], "DeletedID=$selected_id");
274 //-------------------------------------------------------------------------------------
276 if (isset($_POST['close']))
279 // update the closed flag in the work order
280 close_work_order($selected_id);
281 meta_forward($_SERVER['PHP_SELF'], "ClosedID=$selected_id");
284 //-------------------------------------------------------------------------------------
285 if (get_post('_type_update'))
287 $Ajax->activate('_page_body');
289 //-------------------------------------------------------------------------------------
293 start_table($table_style2);
295 $existing_comments = "";
298 if (isset($selected_id))
300 $myrow = get_work_order($selected_id);
302 if (strlen($myrow[0]) == 0)
304 echo _("The order number sent is not valid.");
308 // if it's a closed work order can't edit it
309 if ($myrow["closed"] == 1)
312 display_error(_("This work order is closed and cannot be edited."));
316 $_POST['wo_ref'] = $myrow["wo_ref"];
317 $_POST['stock_id'] = $myrow["stock_id"];
318 $_POST['quantity'] = qty_format($myrow["units_reqd"], $_POST['stock_id'], $dec);
319 $_POST['StockLocation'] = $myrow["loc_code"];
320 $_POST['released'] = $myrow["released"];
321 $_POST['closed'] = $myrow["closed"];
322 $_POST['type'] = $myrow["type"];
323 $_POST['date_'] = sql2date($myrow["date_"]);
324 $_POST['RequDate'] = sql2date($myrow["required_by"]);
325 $_POST['released_date'] = sql2date($myrow["released_date"]);
326 $_POST['memo_'] = "";
327 $_POST['units_issued'] = $myrow["units_issued"];
328 $_POST['Costs'] = price_format($myrow["additional_costs"]);
330 $_POST['memo_'] = get_comments_string(systypes::work_order(), $selected_id);
332 hidden('wo_ref', $_POST['wo_ref']);
333 hidden('units_issued', $_POST['units_issued']);
334 hidden('released', $_POST['released']);
335 hidden('released_date', $_POST['released_date']);
336 hidden('selected_id', $selected_id);
337 hidden('old_qty', $myrow["units_reqd"]);
338 hidden('old_stk_id', $myrow["stock_id"]);
340 label_row(_("Reference:"), $_POST['wo_ref']);
341 label_row(_("Type:"), wo_types::name($_POST['type']));
342 hidden('type', $myrow["type"]);
346 $_POST['units_issued'] = $_POST['released'] = 0;
347 ref_row(_("Reference:"), 'wo_ref', '', references::get_next(systypes::work_order()));
349 wo_types_list_row(_("Type:"), 'type', null);
352 if ($_POST['released'] == true)
354 hidden('stock_id', $_POST['stock_id']);
355 hidden('StockLocation', $_POST['StockLocation']);
356 hidden('type', $_POST['type']);
358 label_row(_("Item:"), $myrow["StockItemName"]);
359 label_row(_("Destination Location:"), $myrow["location_name"]);
363 stock_manufactured_items_list_row(_("Item:"), 'stock_id', null);
365 locations_list_row(_("Destination Location:"), 'StockLocation', null);
368 if (!isset($_POST['quantity']))
369 $_POST['quantity'] = qty_format(1, $_POST['stock_id'], $dec);
371 if (get_post('type') == wo_types::advanced())
373 qty_row(_("Quantity Required:"), 'quantity', null, null, null, $dec);
374 if ($_POST['released'])
375 label_row(_("Quantity Manufactured:"), number_format($_POST['units_issued'], get_qty_dec($_POST['stock_id'])));
376 date_row(_("Date") . ":", 'date_');
377 date_row(_("Date Required By") . ":", 'RequDate', '', null, sys_prefs::default_wo_required_by());
381 qty_row(_("Quantity:"), 'quantity', null, null, null, $dec);
382 date_row(_("Date") . ":", 'date_');
383 hidden('RequDate', '');
385 if (!isset($_POST['Costs']))
386 $_POST['Costs'] = price_format(0);
388 amount_row(_("Total Additional Costs:"), 'Costs');
391 if ($_POST['released'])
392 label_row(_("Released On:"),$_POST['released_date']);
394 textarea_row(_("Memo:"), 'memo_', null, 40, 5);
398 submit_add_or_update_center(!isset($selected_id), '', true);
400 if (isset($selected_id))
402 echo "<br><br><table align=center><tr>";
404 if (isset($_POST['released']))
406 submit_cells('close', _("Close This Work Order"),'','',true);
408 submit_cells('delete', _("Delete This Work Order"),'','',true);
410 echo "</tr></table>";