X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=admin%2Fprinters.php;h=8d11b7261efdc182fd91ae70525b980ce72281a4;hb=46c5f7a65a7659a44ae8254c63152074363d3987;hp=d46afeeb0f0ff9aaae9906eca2a20399d61690e7;hpb=35f482e2a9246960de37e5f1d975c734e08951e6;p=fa-stable.git diff --git a/admin/printers.php b/admin/printers.php index d46afeeb..8d11b726 100644 --- a/admin/printers.php +++ b/admin/printers.php @@ -59,18 +59,14 @@ if ($Mode == 'Delete') { // PREVENT DELETES IF DEPENDENT RECORDS IN print_profiles - $sql= "SELECT COUNT(*) FROM ".TB_PREF."print_profiles WHERE printer = ".db_escape($selected_id); - $result = db_query($sql,"check printers relations failed"); - $myrow = db_fetch_row($result); - if ($myrow[0] > 0) + if (key_in_foreign_table($selected_id, 'print_profiles', 'printer')) { display_error(_("Cannot delete this printer definition, because print profile have been created using it.")); } else { - $sql="DELETE FROM ".TB_PREF."printers WHERE id=".db_escape($selected_id); - db_query($sql,"could not delete printer definition"); - display_notification(_('Selected printer definition has been deleted')); + delete_printer($selected_id); + display_notification(_('Selected printer definition has been deleted')); } $Mode = 'RESET'; } @@ -84,7 +80,7 @@ if ($Mode == 'RESET') $result = get_all_printers(); start_form(); -start_table($table_style); +start_table(TABLESTYLE); $th = array(_("Name"), _("Description"), _("Host"), _("Printer Queue"),'',''); table_header($th); @@ -112,7 +108,7 @@ echo '
'; start_form(); -start_table($table_style2); +start_table(TABLESTYLE2); if ($selected_id != -1) {