6 include($path_to_root . "/includes/session.inc");
7 page(_("Shipping Company"));
8 include($path_to_root . "/includes/ui.inc");
11 if (isset($_GET['selected_id']))
13 $selected_id = $_GET['selected_id'];
15 else if (isset($_POST['selected_id']))
17 $selected_id = $_POST['selected_id'];
20 //----------------------------------------------------------------------------------------------
22 function can_process()
24 if (strlen($_POST['shipper_name']) == 0)
26 display_error(_("The shipping company name cannot be empty."));
27 set_focus('shipper_name');
33 //----------------------------------------------------------------------------------------------
35 if (isset($_POST['ADD_ITEM']) && can_process())
38 $sql = "INSERT INTO ".TB_PREF."shippers (shipper_name, contact, phone, address)
39 VALUES (" . db_escape($_POST['shipper_name']) . ", " .
40 db_escape($_POST['contact']). ", " .
41 db_escape($_POST['phone']). ", " .
42 db_escape($_POST['address']) . ")";
44 db_query($sql,"The Shipping Company could not be added");
45 meta_forward($_SERVER['PHP_SELF']);
48 //----------------------------------------------------------------------------------------------
50 if (isset($_POST['UPDATE_ITEM']) && can_process())
53 $sql = "UPDATE ".TB_PREF."shippers SET shipper_name=" . db_escape($_POST['shipper_name']). " ,
54 contact =" . db_escape($_POST['contact']). " ,
55 phone =" . db_escape($_POST['phone']). " ,
56 address =" . db_escape($_POST['address']). "
57 WHERE shipper_id = $selected_id";
59 db_query($sql,"The shipping company could not be updated");
60 meta_forward($_SERVER['PHP_SELF']);
63 //----------------------------------------------------------------------------------------------
65 if (isset($_GET['delete']))
67 // PREVENT DELETES IF DEPENDENT RECORDS IN 'sales_orders'
69 $sql= "SELECT COUNT(*) FROM ".TB_PREF."sales_orders WHERE ship_via='$selected_id'";
70 $result = db_query($sql,"check failed");
71 $myrow = db_fetch_row($result);
75 display_error(_("Cannot delete this shipping company because sales orders have been created using this shipper."));
79 // PREVENT DELETES IF DEPENDENT RECORDS IN 'debtor_trans'
81 $sql= "SELECT COUNT(*) FROM ".TB_PREF."debtor_trans WHERE ship_via='$selected_id'";
82 $result = db_query($sql,"check failed");
83 $myrow = db_fetch_row($result);
87 display_error(_("Cannot delete this shipping company because invoices have been created using this shipping company."));
91 $sql="DELETE FROM ".TB_PREF."shippers WHERE shipper_id=$selected_id";
92 db_query($sql,"could not delete shipper");
94 meta_forward($_SERVER['PHP_SELF']);
99 //----------------------------------------------------------------------------------------------
101 $sql = "SELECT * FROM ".TB_PREF."shippers ORDER BY shipper_id";
102 $result = db_query($sql,"could not get shippers");
104 start_table($table_style);
105 $th = array(_("Name"), _("Contact Person"), _("Phone Number"), _("Address"), "", "");
108 $k = 0; //row colour counter
110 while ($myrow = db_fetch($result))
112 alt_table_row_color($k);
113 label_cell($myrow["shipper_name"]);
114 label_cell($myrow["contact"]);
115 label_cell($myrow["phone"]);
116 label_cell($myrow["address"]);
117 edit_link_cell("selected_id=".$myrow[0]);
118 delete_link_cell("selected_id=".$myrow[0]."&delete=1");
124 //----------------------------------------------------------------------------------------------
126 hyperlink_no_params($_SERVER['PHP_SELF'], _("New Shipping Company"));
130 start_table($table_style2);
132 if (isset($selected_id))
134 //editing an existing Shipper
136 $sql = "SELECT * FROM ".TB_PREF."shippers WHERE shipper_id=$selected_id";
138 $result = db_query($sql, "could not get shipper");
139 $myrow = db_fetch($result);
141 $_POST['shipper_name'] = $myrow["shipper_name"];
142 $_POST['contact'] = $myrow["contact"];
143 $_POST['phone'] = $myrow["phone"];
144 $_POST['address'] = $myrow["address"];
146 hidden('selected_id', $selected_id);
149 text_row_ex(_("Name:"), 'shipper_name', 40);
151 text_row_ex(_("Contact Person:"), 'contact', 30);
153 text_row_ex(_("Phone Number:"), 'phone', 20);
155 text_row_ex(_("Address:"), 'address', 50);
159 submit_add_or_update_center(!isset($selected_id));