X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=inventory%2Fcost_update.php;h=2ce775fc66c439681abba877375a998e465d954a;hb=cc9972b02f2bf4ece12da3431266e85e96872fb1;hp=16544599b89fac222e8c7ba76192cd4022581ceb;hpb=6183e9450dcd7e4c747889c10903f6ff1b0add33;p=fa-stable.git diff --git a/inventory/cost_update.php b/inventory/cost_update.php index 16544599..2ce775fc 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); //-------------------------------------------------------------------------------------- @@ -26,12 +35,11 @@ if (isset($_GET['stock_id'])) } //-------------------------------------------------------------------------------------- - if (isset($_POST['UpdateData'])) { - $old_cost = input_num('OldMaterialCost') + input_num('OldLabourCost') - + input_num('OldOverheadCost'); + $old_cost = $_POST['OldMaterialCost'] + $_POST['OldLabourCost'] + + $_POST['OldOverheadCost']; $new_cost = input_num('material_cost') + input_num('labour_cost') + input_num('overhead_cost'); @@ -52,59 +60,63 @@ 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 (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 "

"; set_global_stock_item($_POST['stock_id']); -$sql = "SELECT description, units, last_cost, actual_cost, material_cost, labour_cost, +$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, last_cost, actual_cost, material_cost, labour_cost, overhead_cost, mb_flag"; + WHERE stock_id=".db_escape($_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 = 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); -label_row(_("Last Cost"), price_format($myrow["last_cost"]), - "class='tableheader2'", "nowrap align=right"); + +$_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", - price_format($myrow["material_cost"]), "", "", "class='tableheader2'"); + null, "class='tableheader2'"); if ($myrow["mb_flag"]=='M') { amount_row(_("Standard Labour Cost Per Unit"), "labour_cost", - price_format($myrow["labour_cost"]), '', "", "class='tableheader2'"); + null, "class='tableheader2'"); amount_row(_("Standard Overhead Cost Per Unit"), "overhead_cost", - price_format($myrow["overhead_cost"]), "", "", "class='tableheader2'"); + null, "class='tableheader2'"); } else { @@ -113,7 +125,8 @@ else } end_table(1); -submit_center('UpdateData', _("Update")); +div_end(); +submit_center('UpdateData', _("Update"), true, false, 'default'); end_form(); end_page();