MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
***********************************************************************/
-$page_security = 14;
-$path_to_root="../..";
+$page_security = 'SA_SALESTYPES';
+$path_to_root = "../..";
include_once($path_to_root . "/includes/session.inc");
-page(_("Sales Types"));
+page(_($help_context = "Sales Types"));
include_once($path_to_root . "/includes/ui.inc");
include_once($path_to_root . "/sales/includes/db/sales_types_db.inc");
if ($Mode=='ADD_ITEM' && can_process())
{
- add_sales_type($_POST['sales_type'], isset($_POST['tax_included']) ? 1:0,
+ add_sales_type($_POST['sales_type'], check_value('tax_included'),
input_num('factor'));
display_notification(_('New sales type has been added'));
$Mode = 'RESET';
if ($Mode=='UPDATE_ITEM' && can_process())
{
- update_sales_type($selected_id, $_POST['sales_type'], isset($_POST['tax_included']) ? 1:0,
+ update_sales_type($selected_id, $_POST['sales_type'], check_value('tax_included'),
input_num('factor'));
display_notification(_('Selected sales type has been updated'));
$Mode = 'RESET';
if ($Mode == 'Delete')
{
// PREVENT DELETES IF DEPENDENT RECORDS IN 'debtor_trans'
-
- $sql= "SELECT COUNT(*) FROM ".TB_PREF."debtor_trans WHERE tpe='$selected_id'";
- $result = db_query($sql,"check failed");
- check_db_error("The number of transactions using this Sales type record could not be retrieved", $sql);
-
- $myrow = db_fetch_row($result);
- if ($myrow[0] > 0)
+
+ if (key_in_foreign_table($selected_id, 'debtor_trans', 'tpe'))
{
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)
+ if (key_in_foreign_table($selected_id, 'debtors_master', 'sales_type'))
{
display_error(_("Cannot delete this sale type because customers are currently set up to use this sales type."));
}
$result = get_all_sales_types(check_value('show_inactive'));
start_form();
-start_table("$table_style width=30%");
+start_table(TABLESTYLE, "width='30%'");
$th = array (_('Type Name'), _('Factor'), _('Tax Incl'), '','');
inactive_control_column($th);
if (!isset($_POST['base']))
$_POST['base'] = 0;
-start_table($table_style2);
+start_table(TABLESTYLE2);
if ($selected_id != -1)
{
end_page();
-?>