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)
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)
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)
function check_db_has_bank_accounts($msg)
{
global $path_to_root;
+
if (!db_has_bank_accounts())
{
display_error($msg, true);
}
}
+function db_has_cash_accounts()
+{
+ return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."bank_accounts
+ WHERE account_type=3");
+}
+
function db_has_gl_accounts()
{
return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."chart_master");