"; end_form(); end_page(); exit; } //------------------------------------------------------------------------------------- if (!isset($_POST['date_'])) { $_POST['date_'] = Today(); if (!is_date_in_fiscalyear($_POST['date_'])) $_POST['date_'] = end_fiscalyear(); } function can_process() { global $selected_id; if (!isset($selected_id)) { if (!references::is_valid($_POST['wo_ref'])) { display_error(_("You must enter a reference.")); return false; } if (!is_new_reference($_POST['wo_ref'], systypes::work_order())) { display_error(_("The entered reference is already in use.")); return false; } } if (!check_num('quantity', 0)) { display_error( _("The quantity entered is invalid or less than zero.")); return false; } if (!is_date($_POST['date_'])) { display_error( _("The date entered is in an invalid format.")); return false; } elseif (!is_date_in_fiscalyear($_POST['date_'])) { display_error(_("The entered date is not in fiscal year.")); return false; } // only check bom and quantites if quick assembly if (!($_POST['type'] == wo_types::advanced())) { if (!has_bom($_POST['stock_id'])) { display_error(_("The selected item to manufacture does not have a bom.")); return false; } if ($_POST['Costs'] == "") $_POST['Costs'] = price_format(0); if (!check_num('Costs', 0)) { display_error( _("The cost entered is invalid or less than zero.")); return false; } if (!sys_prefs::allow_negative_stock()) { if ($_POST['type'] == wo_types::assemble()) { // check bom if assembling $result = get_bom($_POST['stock_id']); while ($bom_item = db_fetch($result)) { if (has_stock_holding($bom_item["ResourceType"])) { $quantity = $bom_item["quantity"] * input_num('quantity'); $qoh = get_qoh_on_date($bom_item["component"], $bom_item["loc_code"], $_POST['date_']); if (-$quantity + $qoh < 0) { display_error(_("The work order cannot be processed because there is an insufficient quantity for component:") . " " . $bom_item["component"] . " - " . $bom_item["description"] . ". " . _("Location:") . " " . $bom_item["location_name"]); return false; } } } } elseif ($_POST['type'] == wo_types::unassemble()) { // if unassembling, check item to unassemble $qoh = get_qoh_on_date($_POST['stock_id'], $_POST['StockLocation'], $_POST['date_']); if (-input_num('quantity') + $qoh < 0) { display_error(_("The selected item cannot be unassembled because there is insufficient stock.")); return false; } } } } else { if (!is_date($_POST['RequDate'])) { display_error( _("The date entered is in an invalid format.")); return false; } //elseif (!is_date_in_fiscalyear($_POST['RequDate'])) //{ // display_error(_("The entered date is not in fiscal year.")); // return false; //} if (isset($selected_id)) { $myrow = get_work_order($selected_id, true); if ($_POST['units_issued'] > input_num('quantity')) { display_error(_("The quantity cannot be changed to be less than the quantity already manufactured for this order.")); return false; } } } return true; } //------------------------------------------------------------------------------------- if (isset($_POST['ADD_ITEM']) && can_process()) { $id = add_work_order($_POST['wo_ref'], $_POST['StockLocation'], input_num('quantity'), $_POST['stock_id'], $_POST['type'], $_POST['date_'], $_POST['RequDate'], input_num('Costs'), $_POST['memo_']); meta_forward($_SERVER['PHP_SELF'], "AddedID=$id"); } //------------------------------------------------------------------------------------- if (isset($_POST['UPDATE_ITEM']) && can_process()) { update_work_order($selected_id, $_POST['StockLocation'], input_num('quantity'), $_POST['stock_id'], $_POST['date_'], $_POST['RequDate'], $_POST['memo_']); meta_forward($_SERVER['PHP_SELF'], "UpdatedID=$selected_id"); } //-------------------------------------------------------------------------------------- if (isset($_POST['delete'])) { //the link to delete a selected record was clicked instead of the submit button $cancel_delete = false; // can't delete it there are productions or issues if (work_order_has_productions($selected_id) || work_order_has_issues($selected_id) || work_order_has_payments($selected_id)) { display_error(_("This work order cannot be deleted because it has already been processed.")); $cancel_delete = true; } if ($cancel_delete == false) { //ie not cancelled the delete as a result of above tests // delete the actual work order delete_work_order($selected_id); meta_forward($_SERVER['PHP_SELF'], "DeletedID=$selected_id"); } } //------------------------------------------------------------------------------------- if (isset($_POST['close'])) { // update the closed flag in the work order close_work_order($selected_id); meta_forward($_SERVER['PHP_SELF'], "ClosedID=$selected_id"); } //------------------------------------------------------------------------------------- start_form(); start_table($table_style2); $existing_comments = ""; if (isset($selected_id)) { $myrow = get_work_order($selected_id); if (strlen($myrow[0]) == 0) { echo _("The order number sent is not valid."); safe_exit(); } // if it's a closed work order can't edit it if ($myrow["closed"] == 1) { echo ""; display_error(_("This work order is closed and cannot be edited.")); safe_exit(); } $_POST['wo_ref'] = $myrow["wo_ref"]; $_POST['quantity'] = qty_format($myrow["units_reqd"]); $_POST['StockLocation'] = $myrow["loc_code"]; $_POST['released'] = $myrow["released"]; $_POST['closed'] = $myrow["closed"]; $_POST['stock_id'] = $myrow["stock_id"]; $_POST['type'] = $myrow["type"]; $_POST['date_'] = sql2date($myrow["date_"]); $_POST['RequDate'] = sql2date($myrow["required_by"]); $_POST['released_date'] = sql2date($myrow["released_date"]); $_POST['memo_'] = ""; $_POST['units_issued'] = $myrow["units_issued"]; $_POST['Costs'] = price_format($myrow["Costs"]); $_POST['memo_'] = get_comments_string(systypes::work_order(), $selected_id); hidden('wo_ref', $_POST['wo_ref']); hidden('units_issued', $_POST['units_issued']); hidden('released', $_POST['released']); hidden('released_date', $_POST['released_date']); hidden('selected_id', $selected_id); hidden('old_qty', $myrow["units_reqd"]); hidden('old_stk_id', $myrow["stock_id"]); label_row(_("Reference:"), $_POST['wo_ref']); label_row(_("Type:"), wo_types::name($_POST['type'])); } else { $_POST['units_issued'] = $_POST['released'] = 0; ref_row(_("Reference:"), 'wo_ref', references::get_next(systypes::work_order())); wo_types_list_row(_("Type:"), 'type', $_POST['type']); } if ($_POST['released'] == true) { hidden('stock_id', $_POST['stock_id']); hidden('StockLocation', $_POST['StockLocation']); hidden('type', $_POST['type']); label_row(_("Item:"), $myrow["StockItemName"]); label_row(_("Destination Location:"), $myrow["location_name"]); } else { stock_manufactured_items_list_row(_("Item:"), 'stock_id', null); locations_list_row(_("Destination Location:"), 'StockLocation', null); } if (!isset($_POST['quantity'])) $_POST['quantity'] = qty_format(1); if ($_POST['type'] == wo_types::advanced()) { qty_row(_("Quantity Required:"), 'quantity', 12); if ($_POST['released']) label_row(_("Quantity Manufactured:"), qty_format($_POST['units_issued'])); date_row(_("Date") . ":", 'date_'); date_row(_("Date Required By") . ":", 'RequDate', null, sys_prefs::default_wo_required_by()); } else { qty_row(_("Quantity:"), 'quantity', 12); date_row(_("Date") . ":", 'date_'); hidden('RequDate', ''); if (!isset($_POST['Costs'])) $_POST['Costs'] = price_format(0); amount_row(_("Total Additional Costs:"), 'Costs'); } if ($_POST['released']) label_row(_("Released On:"),$_POST['released_date']); textarea_row(_("Memo:"), 'memo_', null, 40, 5); end_table(1); submit_add_or_update_center(!isset($selected_id)); if (isset($selected_id)) { echo "

"; if (isset($_POST['released'])) { submit_cells('close', _("Close This Work Order")); } submit_cells('delete', _("Delete This Work Order")); echo ""; } end_form(); end_page(); ?>