From 5944763e883b09eb2b5ca20b5a852682f35c38c5 Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Mon, 24 Nov 2008 20:06:41 +0000 Subject: [PATCH] Added decimals to get_item_edit_info() return for sql usage optimization. --- includes/db/inventory_db.inc | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/includes/db/inventory_db.inc b/includes/db/inventory_db.inc index 46a16b41..7be45e6a 100644 --- a/includes/db/inventory_db.inc +++ b/includes/db/inventory_db.inc @@ -37,8 +37,10 @@ function get_qoh_on_date($stock_id, $location=null, $date_=null, $exclude=0) function get_item_edit_info($stock_id) { - $sql = "SELECT material_cost + labour_cost + overhead_cost AS standard_cost, units - FROM ".TB_PREF."stock_master WHERE stock_id='$stock_id'"; + $sql = "SELECT material_cost + labour_cost + overhead_cost AS standard_cost, units, decimals + FROM ".TB_PREF."stock_master,".TB_PREF."item_units + WHERE stock_id='$stock_id' + AND ".TB_PREF."stock_master.units=".TB_PREF."item_units.abbr"; $result = db_query($sql, "The standard cost cannot be retrieved"); return db_fetch($result); -- 2.30.2