From bbe1652e5a8df78f2a4c49de1e5001168c08c1b0 Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Sun, 17 May 2009 11:58:46 +0000 Subject: [PATCH] Removed obsolete 'K' mb_flag checks. --- includes/data_checks.inc | 6 +++--- includes/ui/ui_lists.inc | 2 +- 2 files changed, 4 insertions(+), 4 deletions(-) diff --git a/includes/data_checks.inc b/includes/data_checks.inc index 95bcb2c..0b46163 100644 --- a/includes/data_checks.inc +++ b/includes/data_checks.inc @@ -267,7 +267,7 @@ function check_db_has_stock_items($msg) function db_has_bom_stock_items() { - return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."stock_master WHERE (mb_flag='M' OR mb_flag='K')"); + return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."stock_master WHERE mb_flag='M'"); } function check_db_has_bom_stock_items($msg) @@ -299,7 +299,7 @@ function check_db_has_manufacturable_items($msg) function db_has_purchasable_items() { - return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."stock_master WHERE (mb_flag!='M' AND mb_flag!='K')"); + return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."stock_master WHERE mb_flag!='M'"); } function check_db_has_purchasable_items($msg) @@ -315,7 +315,7 @@ function check_db_has_purchasable_items($msg) function db_has_costable_items() { - return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."stock_master WHERE (mb_flag!='D' AND mb_flag!='K')"); + return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."stock_master WHERE mb_flag!='D'"); } function check_db_has_costable_items($msg) diff --git a/includes/ui/ui_lists.inc b/includes/ui/ui_lists.inc index 293df26..90a9dc4 100644 --- a/includes/ui/ui_lists.inc +++ b/includes/ui/ui_lists.inc @@ -770,7 +770,7 @@ function base_stock_items_list($where, $name, $selected_id=null, function stock_bom_items_list($name, $selected_id=null, $all_option=false, $submit_on_change=false) { - return base_stock_items_list("(s.mb_flag='M' OR s.mb_flag='K')", + return base_stock_items_list("s.mb_flag='M'", $name, $selected_id, $all_option, $submit_on_change); } /* -- 2.30.2