Moved all SQL statements from PHP files into relevant *_db.inc files.

[fa-stable.git] / taxes / tax_groups.php

diff --git a/taxes/tax_groups.php b/taxes/tax_groups.php
index be6834826fb4ac384790bca52af2552592be8935..13990c38bb4bdafce31e6257a1c508fb71d886cb 100644 (file)
--- a/taxes/tax_groups.php
+++ b/taxes/tax_groups.php
@@ -99,21 +99,15 @@ function can_delete($selected_id)
 {
        if ($selected_id == -1)
                return false;
-       $sql = "SELECT COUNT(*) FROM ".TB_PREF."cust_branch WHERE tax_group_id=".db_escape($selected_id);
-       $result = db_query($sql, "could not query customers");
-       $myrow = db_fetch_row($result);
-       if ($myrow[0] > 0) 
+       if (key_in_foreign_table($selected_id, 'cust_branch', 'tax_group_id'))  
        {
-               display_note(_("Cannot delete this tax group because customer branches been created referring to it."));
+               display_error(_("Cannot delete this tax group because customer branches been created referring to it."));
                return false;
        }
 
-       $sql = "SELECT COUNT(*) FROM ".TB_PREF."suppliers WHERE tax_group_id=".db_escape($selected_id);
-       $result = db_query($sql, "could not query suppliers");
-       $myrow = db_fetch_row($result);
-       if ($myrow[0] > 0) 
+       if (key_in_foreign_table($selected_id, 'suppliers', 'tax_group_id'))
        {
-               display_note(_("Cannot delete this tax group because suppliers been created referring to it."));
+               display_error(_("Cannot delete this tax group because suppliers been created referring to it."));
                return false;
        }