function can_delete($selected_id)
{
- $sql= "SELECT COUNT(*) FROM ".TB_PREF."stock_master WHERE tax_type_id=".db_escape($selected_id);
- $result = db_query($sql, "could not query stock master");
- $myrow = db_fetch_row($result);
- if ($myrow[0] > 0)
+ if (key_in_foreign_table($selected_id, 'stock_master', 'tax_type_id'))
{
display_error(_("Cannot delete this item tax type because items have been created referring to it."));
return false;
}
+ if (key_in_foreign_table($selected_id, 'stock_category', 'dflt_tax_type'))
+ {
+ display_error(_("Cannot delete this item tax type because item categories have been created referring to it."));
+ return false;
+ }
return true;
}
$result2 = $result = get_all_item_tax_types(check_value('show_inactive'));
start_form();
-start_table("$table_style width=30%");
+start_table(TABLESTYLE, "width='30%'");
$th = array(_("Name"), _("Tax exempt"),'','');
inactive_control_column($th);
table_header($th);
end_table(1);
//-----------------------------------------------------------------------------------
-start_table($table_style2);
+start_table(TABLESTYLE2);
if ($selected_id != -1)
{
if ($Mode == 'Edit') {
$myrow = get_item_tax_type($selected_id);
-
+ unset($_POST); // clear exemption checkboxes
$_POST['name'] = $myrow["name"];
$_POST['exempt'] = $myrow["exempt"];
display_note(_("Select which taxes this item tax type is exempt from."), 0, 1);
- start_table($table_style2);
+ start_table(TABLESTYLE2);
$th = array(_("Tax Name"), _("Rate"), _("Is exempt"));
table_header($th);
end_page();
-?>