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

[fa-stable.git] / sales / manage / sales_types.php

diff --git a/sales/manage/sales_types.php b/sales/manage/sales_types.php
index 7ebd768594c14231cbbe796f329392a519601ac8..bc54f635595860db19096be4d749846847a302ba 100644 (file)
--- a/sales/manage/sales_types.php
+++ b/sales/manage/sales_types.php
@@ -65,26 +65,15 @@ if ($Mode=='UPDATE_ITEM' && can_process())
 if ($Mode == 'Delete')
 {
        // PREVENT DELETES IF DEPENDENT RECORDS IN 'debtor_trans'
-
-       $sql= "SELECT COUNT(*) FROM ".TB_PREF."debtor_trans WHERE tpe=".db_escape($selected_id);
-       $result = db_query($sql,"check failed");
-       check_db_error("The number of transactions using this Sales type record could not be retrieved", $sql);
-
-       $myrow = db_fetch_row($result);
-       if ($myrow[0] > 0)
+       
+       if (key_in_foreign_table($selected_id, 'debtor_trans', 'tpe'))
        {
                display_error(_("Cannot delete this sale type because customer transactions have been created using this sales type."));
 
        }
        else
        {
-
-               $sql = "SELECT COUNT(*) FROM ".TB_PREF."debtors_master WHERE sales_type=".db_escape($selected_id);
-               $result = db_query($sql,"check failed");
-               check_db_error("The number of customers using this Sales type record could not be retrieved", $sql);
-
-               $myrow = db_fetch_row($result);
-               if ($myrow[0] > 0)
+               if (key_in_foreign_table($selected_id, 'debtors_master', 'sales_type'))
                {
                        display_error(_("Cannot delete this sale type because customers are currently set up to use this sales type."));
                }