admin/shipping_companies.php

   1 <?php
   2
   3
   4 $page_security = 14;
   5 $path_to_root="..";
   6 include($path_to_root . "/includes/session.inc");
   7 page(_("Shipping Company"));
   8 include($path_to_root . "/includes/ui.inc");
   9
  10 simple_page_mode(true);
  11 //----------------------------------------------------------------------------------------------
  12
  13 function can_process()
  14 {
  15         if (strlen($_POST['shipper_name']) == 0)
  16         {
  17                 display_error(_("The shipping company name cannot be empty."));
  18                 set_focus('shipper_name');
  19                 return false;
  20         }
  21         return true;
  22 }
  23
  24 //----------------------------------------------------------------------------------------------
  25 if ($Mode=='ADD_ITEM' && can_process())
  26 {
  27
  28         $sql = "INSERT INTO ".TB_PREF."shippers (shipper_name, contact, phone, address)
  29                 VALUES (" . db_escape($_POST['shipper_name']) . ", " .
  30                 db_escape($_POST['contact']). ", " .
  31                 db_escape($_POST['phone']). ", " .
  32                 db_escape($_POST['address']) . ")";
  33
  34         db_query($sql,"The Shipping Company could not be added");
  35         display_notification(_('New shipping company has been added'));
  36         $Mode = 'RESET';
  37 }
  38
  39 //----------------------------------------------------------------------------------------------
  40
  41 if ($Mode=='UPDATE_ITEM' && can_process())
  42 {
  43
  44         $sql = "UPDATE ".TB_PREF."shippers SET shipper_name=" . db_escape($_POST['shipper_name']). " ,
  45                 contact =" . db_escape($_POST['contact']). " ,
  46                 phone =" . db_escape($_POST['phone']). " ,
  47                 address =" . db_escape($_POST['address']). "
  48                 WHERE shipper_id = $selected_id";
  49
  50         db_query($sql,"The shipping company could not be updated");
  51         display_notification(_('Selected shipping company has been updated'));
  52         $Mode = 'RESET';
  53 }
  54
  55 //----------------------------------------------------------------------------------------------
  56
  57 if ($Mode == 'Delete')
  58 {
  59 // PREVENT DELETES IF DEPENDENT RECORDS IN 'sales_orders'
  60
  61         $sql= "SELECT COUNT(*) FROM ".TB_PREF."sales_orders WHERE ship_via='$selected_id'";
  62         $result = db_query($sql,"check failed");
  63         $myrow = db_fetch_row($result);
  64         if ($myrow[0] > 0)
  65         {
  66                 $cancel_delete = 1;
  67                 display_error(_("Cannot delete this shipping company because sales orders have been created using this shipper."));
  68         }
  69         else
  70         {
  71                 // PREVENT DELETES IF DEPENDENT RECORDS IN 'debtor_trans'
  72
  73                 $sql= "SELECT COUNT(*) FROM ".TB_PREF."debtor_trans WHERE ship_via='$selected_id'";
  74                 $result = db_query($sql,"check failed");
  75                 $myrow = db_fetch_row($result);
  76                 if ($myrow[0] > 0)
  77                 {
  78                         $cancel_delete = 1;
  79                         display_error(_("Cannot delete this shipping company because invoices have been created using this shipping company."));
  80                 }
  81                 else
  82                 {
  83                         $sql="DELETE FROM ".TB_PREF."shippers WHERE shipper_id=$selected_id";
  84                         db_query($sql,"could not delete shipper");
  85                         display_notification(_('Selected shipping company has been deleted'));
  86                 }
  87         }
  88         $Mode = 'RESET';
  89 }
  90
  91 if ($Mode == 'RESET')
  92 {
  93         $selected_id = -1;
  94         unset($_POST);
  95 }
  96 //----------------------------------------------------------------------------------------------
  97
  98 $sql = "SELECT * FROM ".TB_PREF."shippers ORDER BY shipper_id";
  99 $result = db_query($sql,"could not get shippers");
 100
 101 start_form();
 102 start_table($table_style);
 103 $th = array(_("Name"), _("Contact Person"), _("Phone Number"), _("Address"), "", "");
 104 table_header($th);
 105
 106 $k = 0; //row colour counter
 107
 108 while ($myrow = db_fetch($result))
 109 {
 110         alt_table_row_color($k);
 111         label_cell($myrow["shipper_name"]);
 112         label_cell($myrow["contact"]);
 113         label_cell($myrow["phone"]);
 114         label_cell($myrow["address"]);
 115         edit_button_cell("Edit".$myrow[0], _("Edit"));
 116         edit_button_cell("Delete".$myrow[0], _("Delete"));
 117         end_row();
 118 }
 119
 120 end_table();
 121 end_form();
 122 echo '<br>';
 123
 124 //----------------------------------------------------------------------------------------------
 125
 126 start_form();
 127
 128 start_table($table_style2);
 129
 130 if ($selected_id != -1)
 131 {
 132         if ($Mode == 'Edit') {
 133                 //editing an existing Shipper
 134
 135                 $sql = "SELECT * FROM ".TB_PREF."shippers WHERE shipper_id=$selected_id";
 136
 137                 $result = db_query($sql, "could not get shipper");
 138                 $myrow = db_fetch($result);
 139
 140                 $_POST['shipper_name']  = $myrow["shipper_name"];
 141                 $_POST['contact']       = $myrow["contact"];
 142                 $_POST['phone'] = $myrow["phone"];
 143                 $_POST['address'] = $myrow["address"];
 144         }
 145         hidden('selected_id', $selected_id);
 146 }
 147
 148 text_row_ex(_("Name:"), 'shipper_name', 40);
 149
 150 text_row_ex(_("Contact Person:"), 'contact', 30);
 151
 152 text_row_ex(_("Phone Number:"), 'phone', 20);
 153
 154 text_row_ex(_("Address:"), 'address', 50);
 155
 156 end_table(1);
 157
 158 submit_add_or_update_center($selected_id == -1, '', true);
 159
 160 end_form();
 161 end_page();
 162 ?>