0) { 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='$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) { display_error(_("Cannot delete this sale type because customers are currently set up to use this sales type.")); } else { delete_sales_type($selected_id); meta_forward($_SERVER['PHP_SELF']); } } //end if sales type used in debtor transactions or in customers set up } //---------------------------------------------------------------------------------------------------- $result = get_all_sales_types(); start_table("$table_style width=30%"); $th = array (_('Type Name'), _('Factor'), _('Tax Incl'), '',''); table_header($th); $k = 0; $base_sales = get_base_sales_type(); while ($myrow = db_fetch($result)) { if ($myrow["id"] == $base_sales) start_row("class='overduebg'"); else alt_table_row_color($k); label_cell($myrow["sales_type"]); $f = number_format2($myrow["factor"],4); if($myrow["id"] == $base_sales) $f = ""._('Base').""; label_cell($f); label_cell($myrow["tax_included"] ? _('Yes'):_('No'), 'align=center'); edit_link_cell("selected_id=".$myrow["id"]); delete_link_cell("selected_id=".$myrow["id"]."&delete=1"); end_row(); } end_table(); display_note(_("Marked sales type is the company base pricelist for prices calculations."), 0, 0, "class='overduefg'"); //---------------------------------------------------------------------------------------------------- hyperlink_no_params($_SERVER['PHP_SELF'], _("New Sales type")); start_form(); if (!isset($_POST['tax_included'])) $_POST['tax_included'] = 0; if (!isset($_POST['base'])) $_POST['base'] = 0; start_table("$table_style2 width=30%"); if ($selected_id != -1) { $myrow = get_sales_type($selected_id); $_POST['sales_type'] = $myrow["sales_type"]; $_POST['tax_included'] = $myrow["tax_included"]; $_POST['factor'] = number_format2($myrow["factor"],4); hidden('selected_id', $selected_id); } text_row_ex(_("Sales Type Name").':', 'sales_type', 20); amount_row(_("Calculation factor").':', 'factor'); check_row(_("Tax included").':', 'tax_included', $_POST['tax_included']); end_table(1); submit_add_or_update_center($selected_id == -1); end_form(); end_page(); ?>