X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=includes%2Fdata_checks.inc;h=0b461636ed6c7a7f638b2b411ebbe6b7419be412;hb=9b413697aa4ca30f7f336dbf5fd04bf8caf2bc43;hp=95bcb2ca68e5c5f16f29417e63769a99232cec8e;hpb=390ade73042e4dce7d03b90eaab712717dbe2d78;p=fa-stable.git diff --git a/includes/data_checks.inc b/includes/data_checks.inc index 95bcb2ca..0b461636 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)