From 662838dbd9ca05b28690f1cbf33683d203a1084a Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Fri, 5 Feb 2010 13:35:32 +0000 Subject: [PATCH] Fixed get_standard_cost() result for dummy items. --- includes/db/inventory_db.inc | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/includes/db/inventory_db.inc b/includes/db/inventory_db.inc index 3695166..2680f3e 100644 --- a/includes/db/inventory_db.inc +++ b/includes/db/inventory_db.inc @@ -59,8 +59,8 @@ function get_item_edit_info($stock_id) function get_standard_cost($stock_id) { - $sql = "SELECT material_cost + labour_cost + overhead_cost AS std_cost - FROM ".TB_PREF."stock_master WHERE stock_id=".db_escape($stock_id); + $sql = "SELECT IF(s.type='D', 0, material_cost + labour_cost + overhead_cost) AS std_cost + FROM ".TB_PREF."stock_master s WHERE stock_id=".db_escape($stock_id); $result = db_query($sql, "The standard cost cannot be retrieved"); $myrow = db_fetch_row($result); -- 2.30.2