sales/manage/sales_groups.php

   1 <?php
   2
   3
   4 $page_security = 3;
   5 $path_to_root="../..";
   6 include($path_to_root . "/includes/session.inc");
   7
   8 page(_("Sales Groups"));
   9
  10 include($path_to_root . "/includes/ui.inc");
  11
  12 simple_page_mode(true);
  13
  14 if ($Mode=='ADD_ITEM' || $Mode=='UPDATE_ITEM')
  15 {
  16
  17         $input_error = 0;
  18
  19         if (strlen($_POST['description']) == 0)
  20         {
  21                 $input_error = 1;
  22                 display_error(_("The area description cannot be empty."));
  23                 set_focus('description');
  24         }
  25
  26         if ($input_error != 1)
  27         {
  28         if ($selected_id != -1)
  29         {
  30                 $sql = "UPDATE ".TB_PREF."groups SET description=".db_escape($_POST['description'])." WHERE id = '$selected_id'";
  31                         $note = _('Selected sales group has been updated');
  32         }
  33         else
  34         {
  35                 $sql = "INSERT INTO ".TB_PREF."groups (description) VALUES (".db_escape($_POST['description']) . ")";
  36                         $note = _('New sales group has been added');
  37         }
  38
  39         db_query($sql,"The sales group could not be updated or added");
  40                 display_notification($note);
  41                 $Mode = 'RESET';
  42         }
  43 }
  44
  45 if ($Mode == 'Delete')
  46 {
  47
  48         $cancel_delete = 0;
  49
  50         // PREVENT DELETES IF DEPENDENT RECORDS IN 'debtors_master'
  51
  52         $sql= "SELECT COUNT(*) FROM ".TB_PREF."debtors_master WHERE group_no='$selected_id'";
  53         $result = db_query($sql,"check failed");
  54         $myrow = db_fetch_row($result);
  55         if ($myrow[0] > 0)
  56         {
  57                 $cancel_delete = 1;
  58                 display_error(_("Cannot delete this group because customers have been created using this group."));
  59         }
  60         if ($cancel_delete == 0)
  61         {
  62                 $sql="DELETE FROM ".TB_PREF."groups WHERE id='" . $selected_id . "'";
  63                 db_query($sql,"could not delete sales group");
  64
  65                 display_notification(_('Selected sales group has been deleted'));
  66         } //end if Delete area
  67         $Mode = 'RESET';
  68 }
  69
  70 if ($Mode == 'RESET')
  71 {
  72         $selected_id = -1;
  73         unset($_POST);
  74 }
  75 //-------------------------------------------------------------------------------------------------
  76
  77 $sql = "SELECT * FROM ".TB_PREF."groups ORDER BY description";
  78 $result = db_query($sql,"could not get groups");
  79
  80 start_form();
  81 start_table("$table_style width=40%");
  82 $th = array(_("Group Name"), "", "");
  83 table_header($th);
  84 $k = 0;
  85
  86 while ($myrow = db_fetch($result))
  87 {
  88
  89         alt_table_row_color($k);
  90
  91         label_cell($myrow["description"]);
  92         edit_button_cell("Edit".$myrow["id"], _("Edit"));
  93         edit_button_cell("Delete".$myrow["id"], _("Delete"));
  94         end_row();
  95 }
  96
  97
  98 end_table();
  99 end_form();
 100 echo '<br>';
 101
 102 //-------------------------------------------------------------------------------------------------
 103
 104 start_form();
 105
 106 start_table("$table_style2 width=40%");
 107
 108 if ($selected_id != -1)
 109 {
 110         if ($Mode == 'Edit') {
 111                 //editing an existing area
 112                 $sql = "SELECT * FROM ".TB_PREF."groups WHERE id='$selected_id'";
 113
 114                 $result = db_query($sql,"could not get group");
 115                 $myrow = db_fetch($result);
 116
 117                 $_POST['description']  = $myrow["description"];
 118         }
 119         hidden("selected_id", $selected_id);
 120 }
 121
 122 text_row_ex(_("Group Name:"), 'description', 30);
 123
 124 end_table(1);
 125
 126 submit_add_or_update_center($selected_id == -1, '', true);
 127
 128 end_form();
 129
 130 end_page();
 131 ?>