sales/manage/sales_areas.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 Areas"));
   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         }
  24
  25         if ($input_error != 1)
  26         {
  27         if ($selected_id != -1)
  28         {
  29                 $sql = "UPDATE ".TB_PREF."areas SET description=".db_escape($_POST['description'])." WHERE area_code = '$selected_id'";
  30                         $note = _('Selected sales area has been updated');
  31         }
  32         else
  33         {
  34                 $sql = "INSERT INTO ".TB_PREF."areas (description) VALUES (".db_escape($_POST['description']) . ")";
  35                         $note = _('New sales area has been added');
  36         }
  37
  38         db_query($sql,"The sales area could not be updated or added");
  39                 display_notification($note);
  40                 $Mode = 'RESET';
  41         }
  42 }
  43
  44 if ($Mode == 'Delete')
  45 {
  46
  47         $cancel_delete = 0;
  48
  49         // PREVENT DELETES IF DEPENDENT RECORDS IN 'debtors_master'
  50
  51         $sql= "SELECT COUNT(*) FROM ".TB_PREF."cust_branch WHERE area='$selected_id'";
  52         $result = db_query($sql,"check failed");
  53         $myrow = db_fetch_row($result);
  54         if ($myrow[0] > 0)
  55         {
  56                 $cancel_delete = 1;
  57                 display_error(_("Cannot delete this area because customer branches have been created using this area."));
  58         }
  59         if ($cancel_delete == 0)
  60         {
  61                 $sql="DELETE FROM ".TB_PREF."areas WHERE area_code='" . $selected_id . "'";
  62                 db_query($sql,"could not delete sales area");
  63
  64                 display_notification(_('Selected sales area has been deleted'));
  65                 $Mode = 'RESET';
  66         } //end if Delete area
  67 }
  68
  69 if ($Mode == 'RESET')
  70 {
  71         $selected_id = -1;
  72         unset($_POST);
  73 }
  74 //-------------------------------------------------------------------------------------------------
  75
  76 $sql = "SELECT * FROM ".TB_PREF."areas";
  77 $result = db_query($sql,"could not get areas");
  78
  79 start_form();
  80 start_table("$table_style width=40%");
  81 $th = array(_("Area Name"), "", "");
  82 table_header($th);
  83 $k = 0;
  84
  85 while ($myrow = db_fetch($result))
  86 {
  87
  88         alt_table_row_color($k);
  89
  90         label_cell($myrow["description"]);
  91         edit_button_cell("Edit".$myrow["area_code"], _("Edit"));
  92         edit_button_cell("Delete".$myrow["area_code"], _("Delete"));
  93         end_row();
  94 }
  95
  96
  97 end_table();
  98 end_form();
  99 echo '<br>';
 100
 101 //-------------------------------------------------------------------------------------------------
 102
 103 start_form();
 104
 105 start_table("$table_style2 width=40%");
 106
 107 if ($selected_id != -1)
 108 {
 109         if ($Mode == 'Edit') {
 110                 //editing an existing area
 111                 $sql = "SELECT * FROM ".TB_PREF."areas WHERE area_code='$selected_id'";
 112
 113                 $result = db_query($sql,"could not get area");
 114                 $myrow = db_fetch($result);
 115
 116                 $_POST['description']  = $myrow["description"];
 117         }
 118         hidden("selected_id", $selected_id);
 119 }
 120
 121 text_row_ex(_("Area Name:"), 'description', 30);
 122
 123 end_table(1);
 124
 125 submit_add_or_update_center($selected_id == -1, '', true);
 126
 127 end_form();
 128
 129 end_page();
 130 ?>