X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=inventory%2Fcost_update.php;h=0e39a0c050c33f6fe5799b5e79f9bf40b46ed728;hb=8e299fb1bbc9113b4efdcb6973239041129c47cf;hp=ff58f9eb8900ed0bbcca3c7c0293893a2f449e6a;hpb=c09be0dad6b05131e240349a375af7a4b7bf3444;p=fa-stable.git diff --git a/inventory/cost_update.php b/inventory/cost_update.php index ff58f9eb..0e39a0c0 100644 --- a/inventory/cost_update.php +++ b/inventory/cost_update.php @@ -1,7 +1,16 @@ . +***********************************************************************/ +$page_security = 'SA_STANDARDCOST'; +$path_to_root = ".."; include_once($path_to_root . "/includes/session.inc"); include_once($path_to_root . "/includes/date_functions.inc"); @@ -14,7 +23,7 @@ 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); +page(_($help_context = "Inventory Item Cost Update"), false, false, "", $js); //-------------------------------------------------------------------------------------- @@ -29,8 +38,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 +60,50 @@ 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_note(get_gl_view_str(ST_COSTUPDATE, $update_no, _("View the GL Journal Entries for this Cost Update")), 0, 1); } } } -if (isset($_POST['_stock_id_update'])) +if (list_updated('stock_id')) $Ajax->activate('cost_table'); //----------------------------------------------------------------------------------------- -start_form(false, true); +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); +//echo stock_costable_items_list('stock_id', $_POST['stock_id'], false, true); +echo stock_items_list('stock_id', $_POST['stock_id'], false, true); 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); - -$_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'"); +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); +amount_row(_("Standard Material Cost Per Unit"), "material_cost", null, "class='tableheader2'", null, $dec1); 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,7 +113,7 @@ else end_table(1); div_end(); -submit_center('UpdateData', _("Update")); +submit_center('UpdateData', _("Update"), true, false, 'default'); end_form(); end_page();