X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=inventory%2Fcost_update.php;h=75f04a0e055fd833c4fd63c5d367d613c28b2fb3;hb=a9e2c0e710a5431ce3c31ef89d4c94bf69538238;hp=ff58f9eb8900ed0bbcca3c7c0293893a2f449e6a;hpb=c09be0dad6b05131e240349a375af7a4b7bf3444;p=fa-stable.git diff --git a/inventory/cost_update.php b/inventory/cost_update.php index ff58f9eb..75f04a0e 100644 --- a/inventory/cost_update.php +++ b/inventory/cost_update.php @@ -1,20 +1,35 @@ . +***********************************************************************/ +$page_security = 'SA_STANDARDCOST'; +if (!@$_GET['popup']) + $path_to_root = ".."; +else + $path_to_root = "../.."; -$page_security = 2; -$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/ui.inc"); include_once($path_to_root . "/includes/banking.inc"); include_once($path_to_root . "/includes/manufacturing.inc"); include_once($path_to_root . "/includes/data_checks.inc"); - include_once($path_to_root . "/inventory/includes/inventory_db.inc"); -$js = ""; -if ($use_popup_windows) - $js .= get_js_open_window(900, 500); -page(_("Inventory Item Cost Update"), false, false, "", $js); + +if (!@$_GET['popup']) +{ + $js = ""; + if ($use_popup_windows) + $js .= get_js_open_window(900, 500); + page(_($help_context = "Inventory Item Cost Update"), false, false, "", $js); +} //-------------------------------------------------------------------------------------- @@ -29,8 +44,8 @@ if (isset($_GET['stock_id'])) if (isset($_POST['UpdateData'])) { - $old_cost = $_POST['OldMaterialCost'] + $_POST['OldLabourCost'] - + $_POST['OldOverheadCost']; + $old_cost = get_standard_cost($_POST['stock_id']); + $new_cost = input_num('material_cost') + input_num('labour_cost') + input_num('overhead_cost'); @@ -51,63 +66,64 @@ if (isset($_POST['UpdateData'])) if ($should_update) { - $update_no = stock_cost_update($_POST['stock_id'], - input_num('material_cost'), input_num('labour_cost'), + $update_no = stock_cost_update($_POST['stock_id'], + input_num('material_cost'), input_num('labour_cost'), input_num('overhead_cost'), $old_cost); - display_note(_("Cost has been updated.")); + display_notification(_("Cost has been updated.")); if ($update_no > 0) { - display_note(get_gl_view_str(systypes::cost_update(), $update_no, _("View the GL Journal Entries for this Cost Update")), 1, 0); + display_notification(get_gl_view_str(ST_COSTUPDATE, $update_no, _("View the GL Journal Entries for this Cost Update"))); } + } } -if (isset($_POST['_stock_id_update'])) +if (list_updated('stock_id')) $Ajax->activate('cost_table'); //----------------------------------------------------------------------------------------- -start_form(false, true); +if (!@$_GET['popup']) + start_form(); if (!isset($_POST['stock_id'])) $_POST['stock_id'] = get_global_stock_item(); -echo "
" . _("Item:"). " "; -stock_costable_items_list('stock_id', $_POST['stock_id'], false, true); +if (!@$_GET['popup']) +{ + echo "
" . _("Item:"). " "; + //echo stock_costable_items_list('stock_id', $_POST['stock_id'], false, true); + echo stock_items_list('stock_id', $_POST['stock_id'], false, true); + + echo "

"; +} +else + br(2); -echo "

"; set_global_stock_item($_POST['stock_id']); -$sql = "SELECT description, units, material_cost, labour_cost, - overhead_cost, mb_flag - FROM ".TB_PREF."stock_master - WHERE stock_id='" . $_POST['stock_id'] . "' - GROUP BY description, units, material_cost, labour_cost, overhead_cost, mb_flag"; -$result = db_query($sql); -check_db_error("The cost details for the item could not be retrieved", $sql); +$myrow = get_item($_POST['stock_id']); -$myrow = db_fetch($result); div_start('cost_table'); -hidden("OldMaterialCost", $myrow["material_cost"]); -hidden("OldLabourCost", $myrow["labour_cost"]); -hidden("OldOverheadCost", $myrow["overhead_cost"]); -start_table($table_style2); +start_table(TABLESTYLE2); +$dec1 = $dec2 = $dec3 = 0; +$_POST['material_cost'] = price_decimal_format($myrow["material_cost"], $dec1); +$_POST['labour_cost'] = price_decimal_format($myrow["labour_cost"], $dec2); +$_POST['overhead_cost'] = price_decimal_format($myrow["overhead_cost"], $dec3); -$_POST['material_cost'] = price_format($myrow["material_cost"]); -$_POST['labour_cost'] = price_format($myrow["labour_cost"]); -$_POST['overhead_cost'] = price_format($myrow["overhead_cost"]); - -amount_row(_("Standard Material Cost Per Unit"), "material_cost", - null, "class='tableheader2'"); +amount_row(_("Standard Material Cost Per Unit"), "material_cost", null, "class='tableheader2'", null, $dec1); +if (@$_GET['popup']) +{ + hidden('_tabs_sel', get_post('_tabs_sel')); + hidden('popup', @$_GET['popup']); +} if ($myrow["mb_flag"]=='M') { - amount_row(_("Standard Labour Cost Per Unit"), "labour_cost", - null, "class='tableheader2'"); - amount_row(_("Standard Overhead Cost Per Unit"), "overhead_cost", - null, "class='tableheader2'"); + amount_row(_("Standard Labour Cost Per Unit"), "labour_cost", null, "class='tableheader2'", null, $dec2); + amount_row(_("Standard Overhead Cost Per Unit"), "overhead_cost", null, "class='tableheader2'", null, $dec3); } else { @@ -117,9 +133,11 @@ else end_table(1); div_end(); -submit_center('UpdateData', _("Update")); - -end_form(); -end_page(); +submit_center('UpdateData', _("Update"), true, false, 'default'); +if (!@$_GET['popup']) +{ + end_form(); + end_page(@$_GET['popup'], false, false); +} ?>