5 include_once($path_to_root . "/includes/session.inc");
7 include_once($path_to_root . "/includes/date_functions.inc");
8 include_once($path_to_root . "/includes/ui.inc");
9 include_once($path_to_root . "/includes/banking.inc");
10 include_once($path_to_root . "/includes/manufacturing.inc");
11 include_once($path_to_root . "/includes/data_checks.inc");
13 include_once($path_to_root . "/inventory/includes/inventory_db.inc");
15 if ($use_popup_windows)
16 $js .= get_js_open_window(900, 500);
17 page(_("Inventory Item Cost Update"), false, false, "", $js);
19 //--------------------------------------------------------------------------------------
21 check_db_has_costable_items(_("There are no costable inventory items defined in the system (Purchased or manufactured items)."));
23 if (isset($_GET['stock_id']))
25 $_POST['stock_id'] = $_GET['stock_id'];
28 //--------------------------------------------------------------------------------------
30 if (isset($_POST['UpdateData']))
33 $old_cost = $_POST['OldMaterialCost'] + $_POST['OldLabourCost']
34 + $_POST['OldOverheadCost'];
35 $new_cost = input_num('material_cost') + input_num('labour_cost')
36 + input_num('overhead_cost');
38 $should_update = true;
40 if (!check_num('material_cost') || !check_num('labour_cost') ||
41 !check_num('overhead_cost'))
43 display_error( _("The entered cost is not numeric."));
44 set_focus('material_cost');
45 $should_update = false;
47 elseif ($old_cost == $new_cost)
49 display_error( _("The new cost is the same as the old cost. Cost was not updated."));
50 $should_update = false;
55 $update_no = stock_cost_update($_POST['stock_id'],
56 input_num('material_cost'), input_num('labour_cost'),
57 input_num('overhead_cost'), $old_cost);
59 display_note(_("Cost has been updated."));
63 display_note(get_gl_view_str(systypes::cost_update(), $update_no, _("View the GL Journal Entries for this Cost Update")), 1, 0);
68 if (isset($_POST['_stock_id_update']))
69 $Ajax->activate('cost_table');
70 //-----------------------------------------------------------------------------------------
72 start_form(false, true);
74 if (!isset($_POST['stock_id']))
75 $_POST['stock_id'] = get_global_stock_item();
77 echo "<center>" . _("Item:"). " ";
78 stock_costable_items_list('stock_id', $_POST['stock_id'], false, true);
81 set_global_stock_item($_POST['stock_id']);
83 $sql = "SELECT description, units, last_cost, actual_cost, material_cost, labour_cost,
84 overhead_cost, mb_flag
85 FROM ".TB_PREF."stock_master
86 WHERE stock_id='" . $_POST['stock_id'] . "'
87 GROUP BY description, units, last_cost, actual_cost, material_cost, labour_cost, overhead_cost, mb_flag";
88 $result = db_query($sql);
89 check_db_error("The cost details for the item could not be retrieved", $sql);
91 $myrow = db_fetch($result);
92 div_start('cost_table');
93 hidden("OldMaterialCost", $myrow["material_cost"]);
94 hidden("OldLabourCost", $myrow["labour_cost"]);
95 hidden("OldOverheadCost", $myrow["overhead_cost"]);
97 start_table($table_style2);
98 label_row(_("Last Cost"), price_format($myrow["last_cost"]),
99 "class='tableheader2'", "nowrap align=right");
101 amount_row(_("Standard Material Cost Per Unit"), "material_cost",
102 price_format($myrow["material_cost"]), "class='tableheader2'");
104 if ($myrow["mb_flag"]=='M')
106 amount_row(_("Standard Labour Cost Per Unit"), "labour_cost",
107 price_format($myrow["labour_cost"]), "class='tableheader2'");
108 amount_row(_("Standard Overhead Cost Per Unit"), "overhead_cost",
109 price_format($myrow["overhead_cost"]), "class='tableheader2'");
113 hidden("labour_cost", 0);
114 hidden("overhead_cost", 0);
119 submit_center('UpdateData', _("Update"));