function db_customer_has_branches($customer_id)
{
- return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."cust_branch WHERE debtor_no='$customer_id'");
+ return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."cust_branch "
+ ."WHERE debtor_no='$customer_id'");
}
function db_has_customer_branches()
{
- return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."cust_branch");
+ return check_empty_result("SELECT COUNT(*) FROM "
+ .TB_PREF."cust_branch WHERE !inactive");
}
function check_db_has_customer_branches($msg)