From f8ad8280fa3d47484bafbf753c6e048a729d3ad6 Mon Sep 17 00:00:00 2001 From: Joe Date: Fri, 12 Sep 2014 08:15:34 +0200 Subject: [PATCH] Removed redundant mb_flag 'A'. --- includes/db/manufacturing_db.inc | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/includes/db/manufacturing_db.inc b/includes/db/manufacturing_db.inc index 637ef4b9..ddb93c58 100644 --- a/includes/db/manufacturing_db.inc +++ b/includes/db/manufacturing_db.inc @@ -109,7 +109,7 @@ function get_demand_asm_qty($stock_id, $location) $sql .= TB_PREF."sales_orders.from_stk_loc =".db_escape($location)." AND "; $sql .= TB_PREF."sales_order_details.quantity-".TB_PREF."sales_order_details.qty_sent > 0 AND ".TB_PREF."stock_master.stock_id=".TB_PREF."sales_order_details.stk_code AND - (".TB_PREF."stock_master.mb_flag='M' OR ".TB_PREF."stock_master.mb_flag='A') + ".TB_PREF."stock_master.mb_flag='M' GROUP BY ".TB_PREF."sales_order_details.stk_code"; $result = db_query($sql, "No transactions were returned"); while ($row = db_fetch_row($result)) { @@ -161,7 +161,7 @@ function get_on_worder_qty($stock_id, $location) else $qoo = 0.0; $flag = get_mb_flag($stock_id); - if ($flag == 'A' || $flag == 'M') + if ($flag == 'M') { $sql = "SELECT SUM((".TB_PREF."workorders.units_reqd-".TB_PREF."workorders.units_issued)) AS qoo FROM ".TB_PREF."workorders -- 2.30.2