<?php
+/**********************************************************************
+ Copyright (C) FrontAccounting, LLC.
+ Released under the terms of the GNU General Public License, GPL,
+ as published by the Free Software Foundation, either version 3
+ of the License, or (at your option) any later version.
+ This program is distributed in the hope that it will be useful,
+ but WITHOUT ANY WARRANTY; without even the implied warranty of
+ MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
+ See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
+***********************************************************************/
+$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);
+page(_($help_context = "Inventory Item Cost Update"), false, false, "", $js);
//--------------------------------------------------------------------------------------
}
//--------------------------------------------------------------------------------------
-
if (isset($_POST['UpdateData']))
{
- $old_cost = input_num('OldMaterialCost') + input_num('OldLabourCost')
- + input_num('OldOverheadCost');
+ $old_cost = get_standard_cost($_POST['stock_id']);
+
$new_cost = input_num('material_cost') + input_num('labour_cost')
+ input_num('overhead_cost');
!check_num('overhead_cost'))
{
display_error( _("The entered cost is not numeric."));
+ set_focus('material_cost');
$should_update = false;
}
elseif ($old_cost == $new_cost)
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 (list_updated('stock_id'))
+ $Ajax->activate('cost_table');
//-----------------------------------------------------------------------------------------
-start_form(false, true);
+$action = $_SERVER['PHP_SELF'];
+if ($page_nested)
+ $action .= "?stock_id=".get_post('stock_id');
+start_form(false, false, $action);
if (!isset($_POST['stock_id']))
$_POST['stock_id'] = get_global_stock_item();
-echo "<center>" . _("Item:"). " ";
-stock_costable_items_list('stock_id', $_POST['stock_id'], false, true);
+if (!$page_nested)
+{
+ echo "<center>" . _("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 "</center><hr>";
+}
+else
+ br(2);
-echo "</center><hr>";
set_global_stock_item($_POST['stock_id']);
-$sql = "SELECT description, units, last_cost, actual_cost, 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";
-$result = db_query($sql);
-check_db_error("The cost details for the item could not be retrieved", $sql);
-
-$myrow = db_fetch($result);
+$myrow = get_item($_POST['stock_id']);
-hidden("OldMaterialCost", $myrow["material_cost"]);
-hidden("OldLabourCost", $myrow["labour_cost"]);
-hidden("OldOverheadCost", $myrow["overhead_cost"]);
+div_start('cost_table');
-start_table($table_style2);
-label_row(_("Last Cost"), price_format($myrow["last_cost"]),
- "class='tableheader2'", "nowrap align=right");
+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",
- price_format($myrow["material_cost"]), "", "", "class='tableheader2'");
+amount_row(_("Standard Material Cost Per Unit"), "material_cost", null, "class='tableheader2'", null, $dec1);
+if ($page_nested)
+{
+ hidden('popup', @$_GET['popup']);
+}
if ($myrow["mb_flag"]=='M')
{
- amount_row(_("Standard Labour Cost Per Unit"), "labour_cost",
- price_format($myrow["labour_cost"]), '', "", "class='tableheader2'");
- amount_row(_("Standard Overhead Cost Per Unit"), "overhead_cost",
- price_format($myrow["overhead_cost"]), "", "", "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
{
}
end_table(1);
-submit_center('UpdateData', _("Update"));
+div_end();
+submit_center('UpdateData', _("Update"), true, false, 'default');
end_form();
end_page();
-
-?>