} else { delete_sales_type($selected_id); display_notification(_('Selected sales type has been deleted')); } } //end if sales type used in debtor transactions or in customers set up $Mode = 'RESET'; } if ($Mode == 'RESET') { $selected_id = -1; $sav = get_post('show_inactive'); unset($_POST); $_POST['show_inactive'] = $sav; } //---------------------------------------------------------------------------------------------------- $result = get_all_sales_types(check_value('show_inactive')); start_form(); start_table(TABLESTYLE, "width='30%'"); $th = array(_('Type Name'), _('Factor'), _('Tax Incl'), '', ''); inactive_control_column($th); 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);
} else { $sql = "SELECT COUNT(*) FROM 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(tr("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(tr("Type Name"), 'Tax Incl', 'Price factor', '', ''); table_header($th); $k = 0; while ($myrow = db_fetch($result)) { alt_table_row_color($k); label_cell($myrow["sales_type"]); label_cell($myrow["tax_included"] ? tr('Yes') : tr('No'), 'align=center'); qty_cell($myrow["price_factor"], null, 2); edit_link_cell("selected_id=" . $myrow["id"]); delete_link_cell("selected_id=" . $myrow["id"] . "&delete=1"); end_row(); } end_table(); //----------------------------------------------------------------------------------------------------