X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=taxes%2Fitem_tax_types.php;h=5f2d0e06a6d6304a4211c4d45b1ecb3aae747753;hb=25379bdc9f10bda4aae4b37f04d16eb1bbe7e4f6;hp=d398e6c9b2f7e239d5a2d85958174be367078ee4;hpb=0ad7b92c6cf2e4e65ca0fa94ba31f30f7b292ba8;p=fa-stable.git diff --git a/taxes/item_tax_types.php b/taxes/item_tax_types.php index d398e6c9..5f2d0e06 100644 --- a/taxes/item_tax_types.php +++ b/taxes/item_tax_types.php @@ -1,29 +1,30 @@ . +***********************************************************************/ +$page_security = 'SA_ITEMTAXTYPE'; $path_to_root = ".."; -$page_security = 3; include($path_to_root . "/includes/session.inc"); -page(_("Item Tax Types")); +page(_($help_context = "Item Tax Types")); include_once($path_to_root . "/taxes/db/item_tax_types_db.inc"); include_once($path_to_root . "/taxes/db/tax_types_db.inc"); include($path_to_root . "/includes/ui.inc"); -if (isset($_GET['selected_id'])) -{ - $selected_id = $_GET['selected_id']; -} -elseif(isset($_POST['selected_id'])) -{ - $selected_id = $_POST['selected_id']; -} - +simple_page_mode(true); //----------------------------------------------------------------------------------- -if (isset($_POST['ADD_ITEM']) || isset($_POST['UPDATE_ITEM'])) +if ($Mode=='ADD_ITEM' || $Mode=='UPDATE_ITEM') { $input_error = 0; @@ -32,6 +33,7 @@ if (isset($_POST['ADD_ITEM']) || isset($_POST['UPDATE_ITEM'])) { $input_error = 1; display_error(_("The item tax type description cannot be empty.")); + set_focus('name'); } if ($input_error != 1) @@ -52,17 +54,17 @@ if (isset($_POST['ADD_ITEM']) || isset($_POST['UPDATE_ITEM'])) } } - if (isset($selected_id)) - { - + if ($selected_id != -1) + { update_item_tax_type($selected_id, $_POST['name'], $_POST['exempt'], $exempt_from); + display_notification(_('Selected item tax type has been updated')); } else { - add_item_tax_type($_POST['name'], $_POST['exempt'], $exempt_from); + display_notification(_('New item tax type has been added')); } - meta_forward($_SERVER['PHP_SELF']); + $Mode = 'RESET'; } } @@ -70,14 +72,16 @@ if (isset($_POST['ADD_ITEM']) || isset($_POST['UPDATE_ITEM'])) function can_delete($selected_id) { - $sql= "SELECT COUNT(*) FROM ".TB_PREF."stock_master WHERE tax_type_id=$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; } @@ -85,23 +89,33 @@ function can_delete($selected_id) //----------------------------------------------------------------------------------- -if (isset($_GET['delete'])) +if ($Mode == 'Delete') { if (can_delete($selected_id)) { delete_item_tax_type($selected_id); - meta_forward($_SERVER['PHP_SELF']); + display_notification(_('Selected item tax type has been deleted')); } + $Mode = 'RESET'; } +if ($Mode == 'RESET') +{ + $selected_id = -1; + $sav = get_post('show_inactive'); + unset($_POST); + $_POST['show_inactive'] = $sav; +} //----------------------------------------------------------------------------------- -$result2 = $result = get_all_item_tax_types(); -start_table("$table_style width=30%"); -$th = array(_("Name"), _("Tax exempt"),'',''); +$result2 = $result = get_all_item_tax_types(check_value('show_inactive')); +start_form(); +start_table(TABLESTYLE, "width='30%'"); +$th = array(_("Name"), _("Tax exempt"),'',''); +inactive_control_column($th); table_header($th); $k = 0; @@ -121,41 +135,36 @@ while ($myrow = db_fetch($result2)) label_cell($myrow["name"]); label_cell($disallow_text); - edit_link_cell("selected_id=" . $myrow["id"]); - delete_link_cell("selected_id=" . $myrow["id"]. "&delete=1"); + inactive_control_cell($myrow["id"], $myrow["inactive"], 'item_tax_types', 'id'); + edit_button_cell("Edit".$myrow["id"], _("Edit")); + delete_button_cell("Delete".$myrow["id"], _("Delete")); end_row(); } -end_table(); - +inactive_control_row($th); +end_table(1); //----------------------------------------------------------------------------------- -hyperlink_no_params($_SERVER['PHP_SELF'], _("New Item Tax type")); - -start_form(); - -start_table($table_style2); +start_table(TABLESTYLE2); -if (isset($selected_id)) +if ($selected_id != -1) { - - if (!isset($_POST['name'])) - { - $myrow = get_item_tax_type($selected_id); - - $_POST['name'] = $myrow["name"]; - $_POST['exempt'] = $myrow["exempt"]; + if ($Mode == 'Edit') { + $myrow = get_item_tax_type($selected_id); + unset($_POST); // clear exemption checkboxes + $_POST['name'] = $myrow["name"]; + $_POST['exempt'] = $myrow["exempt"]; - // read the exemptions and check the ones that are on - $exemptions = get_item_tax_type_exemptions($selected_id); + // read the exemptions and check the ones that are on + $exemptions = get_item_tax_type_exemptions($selected_id); - if (db_num_rows($exemptions) > 0) - { - while ($exmp = db_fetch($exemptions)) - { - $_POST['ExemptTax' . $exmp["tax_type_id"]] = 1; - } - } + if (db_num_rows($exemptions) > 0) + { + while ($exmp = db_fetch($exemptions)) + { + $_POST['ExemptTax' . $exmp["tax_type_id"]] = 1; + } + } } hidden('selected_id', $selected_id); @@ -172,7 +181,7 @@ if (!isset($_POST['exempt']) || $_POST['exempt'] == 0) 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); @@ -184,7 +193,7 @@ if (!isset($_POST['exempt']) || $_POST['exempt'] == 0) alt_table_row_color($k); label_cell($myrow["name"]); - label_cell(percent_format($myrow["rate"])." %", "nowrap align=right"); + label_cell(percent_format($myrow["rate"])." %", "nowrap align=right"); check_cells("", 'ExemptTax' . $myrow["id"], null); end_row(); } @@ -192,7 +201,7 @@ if (!isset($_POST['exempt']) || $_POST['exempt'] == 0) end_table(1); } -submit_add_or_update_center(!isset($selected_id)); +submit_add_or_update_center($selected_id == -1, '', 'both'); end_form(); @@ -200,4 +209,3 @@ end_form(); end_page(); -?>