sales/manage/sales_types.php

   1 <?php
   2
   3 $page_security = 14;
   4 $path_to_root="../..";
   5 include_once($path_to_root . "/includes/session.inc");
   6
   7 page(_("Sales Types"));
   8
   9 include_once($path_to_root . "/includes/ui.inc");
  10 include_once($path_to_root . "/sales/includes/db/sales_types_db.inc");
  11
  12 simple_page_mode(true);
  13 //----------------------------------------------------------------------------------------------------
  14
  15 function can_process()
  16 {
  17         if (strlen($_POST['sales_type']) == 0)
  18         {
  19                 display_error(_("The sales type description cannot be empty."));
  20                 set_focus('sales_type');
  21                 return false;
  22         }
  23
  24         if (!check_num('factor', 0))
  25         {
  26                 display_error(_("Calculation factor must be valid positive number."));
  27                 set_focus('factor');
  28                 return false;
  29         }
  30         return true;
  31 }
  32
  33 //----------------------------------------------------------------------------------------------------
  34
  35 if ($Mode=='ADD_ITEM' && can_process())
  36 {
  37         add_sales_type($_POST['sales_type'], isset($_POST['tax_included']) ? 1:0,
  38             input_num('factor'));
  39         display_notification(_('New sales type has been added'));
  40         $Mode = 'RESET';
  41 }
  42
  43 //----------------------------------------------------------------------------------------------------
  44
  45 if ($Mode=='UPDATE_ITEM' && can_process())
  46 {
  47
  48         update_sales_type($selected_id, $_POST['sales_type'], isset($_POST['tax_included']) ? 1:0,
  49              input_num('factor'));
  50         display_notification(_('Selected sales type has been updated'));
  51         $Mode = 'RESET';
  52 }
  53
  54 //----------------------------------------------------------------------------------------------------
  55
  56 if ($Mode == 'Delete')
  57 {
  58         // PREVENT DELETES IF DEPENDENT RECORDS IN 'debtor_trans'
  59
  60         $sql= "SELECT COUNT(*) FROM ".TB_PREF."debtor_trans WHERE tpe='$selected_id'";
  61         $result = db_query($sql,"check failed");
  62         check_db_error("The number of transactions using this Sales type record could not be retrieved", $sql);
  63
  64         $myrow = db_fetch_row($result);
  65         if ($myrow[0] > 0)
  66         {
  67                 display_error(_("Cannot delete this sale type because customer transactions have been created using this sales type."));
  68
  69         }
  70         else
  71         {
  72
  73                 $sql = "SELECT COUNT(*) FROM ".TB_PREF."debtors_master WHERE sales_type='$selected_id'";
  74                 $result = db_query($sql,"check failed");
  75                 check_db_error("The number of customers using this Sales type record could not be retrieved", $sql);
  76
  77                 $myrow = db_fetch_row($result);
  78                 if ($myrow[0] > 0)
  79                 {
  80                         display_error(_("Cannot delete this sale type because customers are currently set up to use this sales type."));
  81                 }
  82                 else
  83                 {
  84                         delete_sales_type($selected_id);
  85                         display_notification(_('Selected sales type has been deleted'));
  86                         $Mode = 'RESET';
  87                 }
  88         } //end if sales type used in debtor transactions or in customers set up
  89 }
  90
  91 if ($Mode == 'RESET')
  92 {
  93         $selected_id = -1;
  94         unset($_POST);
  95 }
  96 //----------------------------------------------------------------------------------------------------
  97
  98 $result = get_all_sales_types();
  99
 100 start_form();
 101 start_table("$table_style width=30%");
 102
 103 $th = array (_('Type Name'), _('Factor'), _('Tax Incl'), '','');
 104 table_header($th);
 105 $k = 0;
 106 $base_sales = get_base_sales_type();
 107
 108 while ($myrow = db_fetch($result))
 109 {
 110         if ($myrow["id"] == $base_sales)
 111             start_row("class='overduebg'");
 112         else
 113             alt_table_row_color($k);
 114         label_cell($myrow["sales_type"]);
 115         $f = number_format2($myrow["factor"],4);
 116         if($myrow["id"] == $base_sales) $f = "<I>"._('Base')."</I>";
 117         label_cell($f);
 118         label_cell($myrow["tax_included"] ? _('Yes'):_('No'), 'align=center');
 119         edit_button_cell("Edit".$myrow['id'], _("Edit"));
 120         edit_button_cell("Delete".$myrow['id'], _("Delete"));
 121         end_row();
 122 }
 123
 124 end_table();
 125 end_form();
 126 display_note(_("Marked sales type is the company base pricelist for prices calculations."), 0, 0, "class='overduefg'");
 127
 128 //----------------------------------------------------------------------------------------------------
 129
 130 start_form();
 131  if (!isset($_POST['tax_included']))
 132         $_POST['tax_included'] = 0;
 133  if (!isset($_POST['base']))
 134         $_POST['base'] = 0;
 135
 136 start_table("$table_style2 width=30%");
 137
 138 if ($selected_id != -1)
 139 {
 140
 141         if ($Mode == 'Edit') {
 142                 $myrow = get_sales_type($selected_id);
 143
 144                 $_POST['sales_type']  = $myrow["sales_type"];
 145                 $_POST['tax_included']  = $myrow["tax_included"];
 146                 $_POST['factor']  = number_format2($myrow["factor"],4);
 147         }
 148         hidden('selected_id', $selected_id);
 149 } else {
 150                 $_POST['factor']  = number_format2(1,4);
 151 }
 152
 153 text_row_ex(_("Sales Type Name").':', 'sales_type', 20);
 154 amount_row(_("Calculation factor").':', 'factor', null, null, null, 4);
 155 check_row(_("Tax included").':', 'tax_included', $_POST['tax_included']);
 156
 157 end_table(1);
 158
 159 submit_add_or_update_center($selected_id == -1, '', true);
 160
 161 end_form();
 162
 163 end_page();
 164
 165 ?>