5 include($path_to_root . "/includes/session.inc");
7 page(_("Sales Types"));
9 include($path_to_root . "/includes/ui.inc");
10 include($path_to_root . "/sales/includes/db/sales_types_db.inc");
12 if (isset($_POST['selected_id']))
14 $selected_id = $_POST['selected_id'];
16 elseif (isset($_GET['selected_id']))
18 $selected_id = $_GET['selected_id'];
23 //----------------------------------------------------------------------------------------------------
25 function can_process()
27 if (strlen($_POST['sales_type']) == 0)
29 display_error(_("The sales type description cannot be empty."));
35 //----------------------------------------------------------------------------------------------------
37 if (isset($_POST['ADD_ITEM']) && can_process())
39 add_sales_type($_POST['sales_type'], isset($_POST['tax_included']));
40 meta_forward($_SERVER['PHP_SELF']);
43 //----------------------------------------------------------------------------------------------------
45 if (isset($_POST['UPDATE_ITEM']) && can_process())
48 update_sales_type($selected_id, $_POST['sales_type'], isset($_POST['tax_included']) ? 1:0);
49 meta_forward($_SERVER['PHP_SELF']);
52 //----------------------------------------------------------------------------------------------------
54 if (isset($_GET['delete']))
56 // PREVENT DELETES IF DEPENDENT RECORDS IN 'debtor_trans'
58 $sql= "SELECT COUNT(*) FROM ".TB_PREF."debtor_trans WHERE tpe='$selected_id'";
59 $result = db_query($sql,"check failed");
60 check_db_error("The number of transactions using this Sales type record could not be retrieved", $sql);
62 $myrow = db_fetch_row($result);
65 display_error(_("Cannot delete this sale type because customer transactions have been created using this sales type."));
71 $sql = "SELECT COUNT(*) FROM ".TB_PREF."debtors_master WHERE sales_type='$selected_id'";
72 $result = db_query($sql,"check failed");
73 check_db_error("The number of customers using this Sales type record could not be retrieved", $sql);
75 $myrow = db_fetch_row($result);
78 display_error(_("Cannot delete this sale type because customers are currently set up to use this sales type."));
82 delete_sales_type($selected_id);
83 meta_forward($_SERVER['PHP_SELF']);
85 } //end if sales type used in debtor transactions or in customers set up
88 //----------------------------------------------------------------------------------------------------
90 $result = get_all_sales_types();
92 start_table("$table_style width=30%");
94 $th = array (_("Type Name"), 'Tax Incl', '','');
98 while ($myrow = db_fetch($result))
100 alt_table_row_color($k);
101 label_cell($myrow["sales_type"]);
102 label_cell($myrow["tax_included"] ? _('Yes'):_('No'), 'align=center');
103 edit_link_cell("selected_id=".$myrow["id"]);
104 delete_link_cell("selected_id=".$myrow["id"]."&delete=1");
110 //----------------------------------------------------------------------------------------------------
112 hyperlink_no_params($_SERVER['PHP_SELF'], _("New Sales type"));
115 if (!isset($_POST['tax_included']))
116 $_POST['tax_included'] = 0;
118 start_table("$table_style2 width=30%");
120 if ($selected_id != -1)
123 $myrow = get_sales_type($selected_id);
125 $_POST['sales_type'] = $myrow["sales_type"];
126 $_POST['tax_included'] = $myrow["tax_included"];
128 hidden('selected_id', $selected_id);
131 text_row_ex(_("Sales Type Name:"), 'sales_type', 20);
132 check_cells("Tax included", 'tax_included', $_POST['tax_included']);
136 submit_add_or_update_center($selected_id == -1);