X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=manufacturing%2Fwork_order_entry.php;h=4aea96fb15d8f5d3b8378e08d0e706ad44ddb1d2;hb=7e6e0807990447d2977b970c3a0fd28dc9250194;hp=9ba52cb68b2b44d175053993aaede0713f02d627;hpb=818719f38b8327cdca616d58b13913dbd174d96a;p=fa-stable.git diff --git a/manufacturing/work_order_entry.php b/manufacturing/work_order_entry.php index 9ba52cb6..4aea96fb 100644 --- a/manufacturing/work_order_entry.php +++ b/manufacturing/work_order_entry.php @@ -1,30 +1,31 @@ . + See the License here . ***********************************************************************/ -$page_security = 10; -$path_to_root=".."; +$page_security = 'SA_WORKORDERENTRY'; +$path_to_root = ".."; include_once($path_to_root . "/includes/session.inc"); include_once($path_to_root . "/includes/date_functions.inc"); -include_once($path_to_root . "/includes/manufacturing.inc"); include_once($path_to_root . "/includes/data_checks.inc"); include_once($path_to_root . "/manufacturing/includes/manufacturing_db.inc"); include_once($path_to_root . "/manufacturing/includes/manufacturing_ui.inc"); $js = ""; -if ($use_date_picker) +if ($SysPrefs->use_popup_windows) + $js .= get_js_open_window(900, 500); +if (user_use_date_picker()) $js .= get_js_date_picker(); -page(_("Work Order Entry"), false, false, "", $js); +page(_($help_context = "Work Order Entry"), false, false, "", $js); check_db_has_manufacturable_items(_("There are no manufacturable items defined in the system.")); @@ -47,9 +48,25 @@ elseif(isset($_POST['selected_id'])) if (isset($_GET['AddedID'])) { $id = $_GET['AddedID']; + $stype = ST_WORKORDER; display_notification_centered(_("The work order been added.")); + display_note(get_trans_view_str($stype, $id, _("View this Work Order")), 0, 1); + + if ($_GET['type'] != WO_ADVANCED) + { + include_once($path_to_root . "/reporting/includes/reporting.inc"); + + submenu_print(_("&Print This Work Order"), ST_WORKORDER, $id, 'prtopt'); + submenu_print(_("&Email This Work Order"), ST_WORKORDER, $id, null, 1); + display_note(get_gl_view_str($stype, $id, _("View the GL Journal Entries for this Work Order")), 1); + $ar = array('PARAM_0' => $_GET['date'], 'PARAM_1' => $_GET['date'], 'PARAM_2' => $stype, 'PARAM_3' => '', + 'PARAM_4' => (user_def_print_orientation() == 1 ? 1 : 0)); + display_note(print_link(_("Print the GL Journal Entries for this Work Order"), 702, $ar), 1); + hyperlink_params("$path_to_root/admin/attachments.php", _("Add an Attachment"), "filterType=$stype&trans_no=$id"); + } + safe_exit(); } @@ -91,42 +108,32 @@ function safe_exit() hyperlink_no_params("", _("Enter a new work order")); hyperlink_no_params("search_work_orders.php", _("Select an existing work order")); - echo "
"; - end_form(); - end_page(); - exit; + + display_footer_exit(); } //------------------------------------------------------------------------------------- if (!isset($_POST['date_'])) { - $_POST['date_'] = Today(); + $_POST['date_'] = new_doc_date(); if (!is_date_in_fiscalyear($_POST['date_'])) $_POST['date_'] = end_fiscalyear(); } function can_process() { - global $selected_id; + global $selected_id, $SysPrefs; if (!isset($selected_id)) { - if (!references::is_valid($_POST['wo_ref'])) + if (!check_reference($_POST['wo_ref'], ST_WORKORDER)) { - display_error(_("You must enter a reference.")); - set_focus('wo_ref'); - return false; - } - - if (!is_new_reference($_POST['wo_ref'], systypes::work_order())) - { - display_error(_("The entered reference is already in use.")); - set_focus('wo_ref'); + set_focus('wo_ref'); return false; } } - if (!check_num('quantity', 0)) + if (!check_num('quantity', 1)) { display_error( _("The quantity entered is invalid or less than zero.")); set_focus('quantity'); @@ -141,32 +148,40 @@ function can_process() } elseif (!is_date_in_fiscalyear($_POST['date_'])) { - display_error(_("The entered date is not in fiscal year.")); + display_error(_("The entered date is out of fiscal year or is closed for further data entry.")); set_focus('date_'); return false; } // only check bom and quantites if quick assembly - if (!($_POST['type'] == wo_types::advanced())) + if (!($_POST['type'] == WO_ADVANCED)) { if (!has_bom($_POST['stock_id'])) { display_error(_("The selected item to manufacture does not have a bom.")); - set_focus('stock_id'); + set_focus('stock_id'); return false; } + if ($_POST['Labour'] == "") + $_POST['Labour'] = price_format(0); + if (!check_num('Labour', 0)) + { + display_error( _("The labour cost entered is invalid or less than zero.")); + set_focus('Labour'); + 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.")); - set_focus('Costs'); + set_focus('Costs'); return false; } - if (!sys_prefs::allow_negative_stock()) + if (!$SysPrefs->allow_negative_stock()) { - if ($_POST['type'] == wo_types::assemble()) + if ($_POST['type'] == WO_ASSEMBLY) { // check bom if assembling $result = get_bom($_POST['stock_id']); @@ -179,22 +194,20 @@ function can_process() $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) + if (check_negative_stock($bom_item["component"], -$quantity, $bom_item["loc_code"], $_POST['date_'])) { 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"]); - set_focus('quantity'); + set_focus('quantity'); return false; } } } } - elseif ($_POST['type'] == wo_types::unassemble()) + elseif ($_POST['type'] == WO_UNASSEMBLY) { // if unassembling, check item to unassemble - $qoh = get_qoh_on_date($_POST['stock_id'], $_POST['StockLocation'], $_POST['date_']); - if (-input_num('quantity') + $qoh < 0) + if (check_negative_stock($_POST['stock_id'], -input_num('quantity'), $_POST['StockLocation'], $_POST['date_'])) { display_error(_("The selected item cannot be unassembled because there is insufficient stock.")); return false; @@ -206,22 +219,15 @@ function can_process() { if (!is_date($_POST['RequDate'])) { - set_focus('RequDate'); + set_focus('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')) { - set_focus('quantity'); + set_focus('quantity'); display_error(_("The quantity cannot be changed to be less than the quantity already manufactured for this order.")); return false; } @@ -235,12 +241,16 @@ function can_process() if (isset($_POST['ADD_ITEM']) && can_process()) { - + if (!isset($_POST['cr_acc'])) + $_POST['cr_acc'] = ""; + if (!isset($_POST['cr_lab_acc'])) + $_POST['cr_lab_acc'] = ""; $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_']); + $_POST['RequDate'], $_POST['memo_'], input_num('Costs'), $_POST['cr_acc'], input_num('Labour'), $_POST['cr_lab_acc']); - meta_forward($_SERVER['PHP_SELF'], "AddedID=$id"); + new_doc_date($_POST['date_']); + meta_forward($_SERVER['PHP_SELF'], "AddedID=$id&type=".$_POST['type']."&date=".$_POST['date_']); } //------------------------------------------------------------------------------------- @@ -250,7 +260,7 @@ 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_']); - + new_doc_date($_POST['date_']); meta_forward($_SERVER['PHP_SELF'], "UpdatedID=$selected_id"); } @@ -275,7 +285,7 @@ if (isset($_POST['delete'])) { //ie not cancelled the delete as a result of above tests // delete the actual work order - delete_work_order($selected_id); + delete_work_order($selected_id, $_POST['stock_id'], $_POST['quantity'], $_POST['date_']); meta_forward($_SERVER['PHP_SELF'], "DeletedID=$selected_id"); } } @@ -299,16 +309,16 @@ if (get_post('_type_update')) start_form(); -start_table($table_style2); +start_table(TABLESTYLE2); $existing_comments = ""; $dec = 0; if (isset($selected_id)) { - $myrow = get_work_order($selected_id); + $myrow = get_work_order($selected_id, true); - if (strlen($myrow[0]) == 0) + if ($myrow === false) { echo _("The order number sent is not valid."); safe_exit(); @@ -324,7 +334,8 @@ if (isset($selected_id)) $_POST['wo_ref'] = $myrow["wo_ref"]; $_POST['stock_id'] = $myrow["stock_id"]; - $_POST['quantity'] = qty_format($myrow["units_reqd"], $_POST['stock_id'], $dec); + //$_POST['quantity'] = qty_format($myrow["units_reqd"], $_POST['stock_id'], $dec); + $_POST['quantity'] = $myrow["units_reqd"]; $_POST['StockLocation'] = $myrow["loc_code"]; $_POST['released'] = $myrow["released"]; $_POST['closed'] = $myrow["closed"]; @@ -332,33 +343,31 @@ if (isset($selected_id)) $_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["additional_costs"]); - $_POST['memo_'] = get_comments_string(systypes::work_order(), $selected_id); + $_POST['memo_'] = get_comments_string(ST_WORKORDER, $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'])); + label_row(_("Type:"), $wo_types_array[$_POST['type']]); hidden('type', $myrow["type"]); } else { $_POST['units_issued'] = $_POST['released'] = 0; - ref_row(_("Reference:"), 'wo_ref', '', references::get_next(systypes::work_order())); + + ref_row(_("Reference:"), 'wo_ref', '', $Refs->get_next(ST_WORKORDER, null, get_post('date_')), false, ST_WORKORDER); wo_types_list_row(_("Type:"), 'type', null); } -if ($_POST['released'] == true) +if (get_post('released')) { hidden('stock_id', $_POST['stock_id']); hidden('StockLocation', $_POST['StockLocation']); @@ -369,35 +378,52 @@ if ($_POST['released'] == true) } else { - stock_manufactured_items_list_row(_("Item:"), 'stock_id', null); + stock_manufactured_items_list_row(_("Item:"), 'stock_id', null, false, true); + if (list_updated('stock_id')) + $Ajax->activate('quantity'); locations_list_row(_("Destination Location:"), 'StockLocation', null); } if (!isset($_POST['quantity'])) $_POST['quantity'] = qty_format(1, $_POST['stock_id'], $dec); +else + $_POST['quantity'] = qty_format($_POST['quantity'], $_POST['stock_id'], $dec); + -if (get_post('type') == wo_types::advanced()) +if (get_post('type') == WO_ADVANCED) { qty_row(_("Quantity Required:"), 'quantity', null, null, null, $dec); if ($_POST['released']) label_row(_("Quantity Manufactured:"), number_format($_POST['units_issued'], get_qty_dec($_POST['stock_id']))); - date_row(_("Date") . ":", 'date_'); - date_row(_("Date Required By") . ":", 'RequDate', '', null, sys_prefs::default_wo_required_by()); + date_row(_("Date") . ":", 'date_', '', true); + date_row(_("Date Required By") . ":", 'RequDate', '', null, $SysPrefs->default_wo_required_by()); } else { qty_row(_("Quantity:"), 'quantity', null, null, null, $dec); - date_row(_("Date") . ":", 'date_'); + date_row(_("Date") . ":", 'date_', '', true); hidden('RequDate', ''); - if (!isset($_POST['Costs'])) - $_POST['Costs'] = price_format(0); + if (!isset($_POST['Labour']) || list_updated('stock_id') || list_updated('type')) + { + $bank_act = get_default_bank_account(); + $item = get_item(get_post('stock_id')); + $_POST['Labour'] = price_format(get_post('type') == WO_ASSEMBLY ? $item['labour_cost'] : 0); + $_POST['cr_lab_acc'] = $bank_act['account_code']; + $_POST['Costs'] = price_format(get_post('type') == WO_ASSEMBLY ? $item['overhead_cost'] : 0); + $_POST['cr_acc'] = $bank_act['account_code']; + $Ajax->activate('_page_body'); + } + + amount_row($wo_cost_types[WO_LABOUR], 'Labour'); + gl_all_accounts_list_row(_("Credit Labour Account"), 'cr_lab_acc', null); + amount_row($wo_cost_types[WO_OVERHEAD], 'Costs'); + gl_all_accounts_list_row(_("Credit Overhead Account"), 'cr_acc', null); - amount_row(_("Total Additional Costs:"), 'Costs'); } -if ($_POST['released']) +if (get_post('released')) label_row(_("Released On:"),$_POST['released_date']); textarea_row(_("Memo:"), 'memo_', null, 40, 5); @@ -408,8 +434,8 @@ if (isset($selected_id)) { echo ""; - submit_cells('UPDATE_ITEM', _("Update"), '', _('Save changes to work order'), true); - if (isset($_POST['released'])) + submit_cells('UPDATE_ITEM', _("Update"), '', _('Save changes to work order'), 'default'); + if (get_post('released')) { submit_cells('close', _("Close This Work Order"),'','',true); } @@ -419,10 +445,9 @@ if (isset($selected_id)) } else { - submit_center('ADD_ITEM', _("Add Workorder"), true, '', true); + submit_center('ADD_ITEM', _("Add Workorder"), true, '', 'default'); } end_form(); end_page(); -?> \ No newline at end of file