function get_item_edit_info($stock_id)
{
- $sql = "SELECT material_cost + labour_cost + overhead_cost AS standard_cost, units, decimals
- FROM ".TB_PREF."stock_master,".TB_PREF."item_units
+ $sql = "SELECT item.material_cost, item.units, unit.decimals
+ FROM ".TB_PREF."stock_master item,"
+ .TB_PREF."item_units unit
WHERE stock_id=".db_escape($stock_id)
- ." AND ".TB_PREF."stock_master.units=".TB_PREF."item_units.abbr";
+ ." AND item.units=unit.abbr";
$result = db_query($sql, "The standard cost cannot be retrieved");
return db_fetch($result);
//--------------------------------------------------------------------------------------
-function get_standard_cost($stock_id)
+function get_unit_cost($stock_id)
{
- $sql = "SELECT (material_cost + labour_cost + overhead_cost) AS std_cost
- FROM ".TB_PREF."stock_master s WHERE stock_id=".db_escape($stock_id);
+ $sql = "SELECT material_cost
+ FROM ".TB_PREF."stock_master
+ WHERE stock_id=".db_escape($stock_id);
$result = db_query($sql, "The standard cost cannot be retrieved");
$myrow = db_fetch_row($result);
function is_inventory_item($stock_id)
{
- $sql = "SELECT stock_id FROM ".TB_PREF."stock_master
+ $sql = "SELECT stock_id FROM "
+ .TB_PREF."stock_master
WHERE stock_id=".db_escape($stock_id)." AND mb_flag <> 'D'";
$result = db_query($sql, "Cannot query is inventory item or not");
return $row[0];
}
/*
- FIXME: $to ?
Returns start move_id in latest negative status period for $stock_id
+ FIXME: $to ?
*/
function last_negative_stock_trans_id($stock_id, $to)
{
{
/*Gets the GL Codes relevant to the item account */
$sql = "SELECT mb_flag, inventory_account, cogs_account,
- adjustment_account, sales_account, assembly_account, dimension_id, dimension2_id FROM
+ adjustment_account, sales_account, wip_account, dimension_id, dimension2_id FROM
".TB_PREF."stock_master WHERE stock_id = ".db_escape($stock_id);
$get = db_query($sql,"retreive stock gl code");
$id = get_next_trans_no(ST_JOURNAL);
$ref = $Refs->get_next(ST_JOURNAL, null, $date_);
- $diff = round($qoh*get_standard_cost($stock_id) + $quantity*$standard_cost, user_price_dec());
+ $diff = round($qoh*get_unit_cost($stock_id) + $quantity*$standard_cost, user_price_dec());
if ($diff != 0)
{
function get_stock_moves($type, $type_no)
{
- $sql = "SELECT move.*, item.description, item.mb_flag, item.units, stock.location_name,
- item.material_cost + item.labour_cost + item.overhead_cost AS FixedStandardCost
+ $sql = "SELECT move.*, item.description, item.mb_flag, item.units, stock.location_name
FROM ".TB_PREF."stock_moves move,"
.TB_PREF."locations stock,"
.TB_PREF."stock_master item