sales/manage/sales_types.php

   1 <?php
   2
   3 $page_security = 14;
   4 $path_to_root="../..";
   5 include($path_to_root . "/includes/session.inc");
   6
   7 page(_("Sales Types"));
   8
   9 include($path_to_root . "/includes/ui.inc");
  10 include($path_to_root . "/sales/includes/db/sales_types_db.inc");
  11
  12 if (isset($_POST['selected_id']))
  13 {
  14         $selected_id = $_POST['selected_id'];
  15 }
  16 elseif (isset($_GET['selected_id']))
  17 {
  18         $selected_id = $_GET['selected_id'];
  19 }
  20 else
  21         $selected_id = -1;
  22
  23 //----------------------------------------------------------------------------------------------------
  24
  25 function can_process()
  26 {
  27         if (strlen($_POST['sales_type']) == 0)
  28         {
  29                 display_error(_("The sales type description cannot be empty."));
  30                 return false;
  31         }
  32         return true;
  33 }
  34
  35 //----------------------------------------------------------------------------------------------------
  36
  37 if (isset($_POST['ADD_ITEM']) && can_process())
  38 {
  39         add_sales_type($_POST['sales_type']);
  40         meta_forward($_SERVER['PHP_SELF']);
  41 }
  42
  43 //----------------------------------------------------------------------------------------------------
  44
  45 if (isset($_POST['UPDATE_ITEM']) && can_process())
  46 {
  47
  48         update_sales_type($selected_id, $_POST['sales_type']);
  49         meta_forward($_SERVER['PHP_SELF']);
  50 }
  51
  52 //----------------------------------------------------------------------------------------------------
  53
  54 if (isset($_GET['delete']))
  55 {
  56         // PREVENT DELETES IF DEPENDENT RECORDS IN 'debtor_trans'
  57
  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);
  61
  62         $myrow = db_fetch_row($result);
  63         if ($myrow[0] > 0)
  64         {
  65                 display_error(_("Cannot delete this sale type because customer transactions have been created using this sales type."));
  66
  67         }
  68         else
  69         {
  70
  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);
  74
  75                 $myrow = db_fetch_row($result);
  76                 if ($myrow[0] > 0)
  77                 {
  78                         display_error(_("Cannot delete this sale type because customers are currently set up to use this sales type."));
  79                 }
  80                 else
  81                 {
  82                         delete_sales_type($selected_id);
  83                         meta_forward($_SERVER['PHP_SELF']);
  84                 }
  85         } //end if sales type used in debtor transactions or in customers set up
  86 }
  87
  88 //----------------------------------------------------------------------------------------------------
  89
  90 $result = get_all_sales_types();
  91
  92 start_table("$table_style width=30%");
  93
  94 $th = array (_("Type Name"), "", "");
  95 table_header($th);
  96 $k = 0;
  97
  98 while ($myrow = db_fetch($result))
  99 {
 100         alt_table_row_color($k);
 101         label_cell($myrow["sales_type"]);
 102     edit_link_cell("selected_id=".$myrow["id"]);
 103     delete_link_cell("selected_id=".$myrow["id"]."&delete=1");
 104         end_row();
 105 }
 106
 107 end_table();
 108
 109 //----------------------------------------------------------------------------------------------------
 110
 111 hyperlink_no_params($_SERVER['PHP_SELF'], _("New Sales type"));
 112
 113 start_form();
 114
 115 start_table("$table_style2 width=30%");
 116
 117 if ($selected_id != -1)
 118 {
 119
 120         $myrow = get_sales_type($selected_id);
 121
 122         $_POST['sales_type']  = $myrow["sales_type"];
 123
 124         hidden('selected_id', $selected_id);
 125 }
 126
 127 text_row_ex(_("Sales Type Name:"), 'sales_type', 20);
 128
 129 end_table(1);
 130
 131 submit_add_or_update_center($selected_id == -1);
 132
 133 end_form();
 134
 135 end_page();
 136
 137 ?>