[Frontaccounting-cvs_updates] /hg/p/frontaccounting/mercurial: Removed redundant mb_flag 'A'.
Brought to you by:
frontaccounting,
itronics
From: FrontAccounting <fro...@us...> - 2014-09-12 06:22:27
|
details: http://frontaccounting.hg.sourceforge.net:8000/hgroot/frontaccounting/frontaccounting/hg/p/frontaccounting/mercurial/rev/dab8dff3a4b4 changeset: 3405:dab8dff3a4b4 user: Joe date: Fri Sep 12 08:15:34 2014 +0200 description: Removed redundant mb_flag 'A'. diffstat: includes/db/manufacturing_db.inc | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diffs (21 lines): diff -r 51bae6c5e8d5 -r dab8dff3a4b4 includes/db/manufacturing_db.inc --- a/includes/db/manufacturing_db.inc Mon Sep 01 14:18:04 2014 +0200 +++ b/includes/db/manufacturing_db.inc Fri Sep 12 08:15:34 2014 +0200 @@ -109,7 +109,7 @@ $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 @@ 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 |