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."));
32 //----------------------------------------------------------------------------------------------
34 if (isset($_POST['ADD_ITEM']) && can_process())
37 $sql = "INSERT INTO ".TB_PREF."shippers (shipper_name, contact, phone, address)
38 VALUES ('" . $_POST['shipper_name'] . "', '" .
39 $_POST['contact'] . "', '" .
40 $_POST['phone'] . "', '" .
41 $_POST['address'] . "')";
43 db_query($sql,"The Shipping Company could not be added");
44 meta_forward($_SERVER['PHP_SELF']);
47 //----------------------------------------------------------------------------------------------
49 if (isset($_POST['UPDATE_ITEM']) && can_process())
52 $sql = "UPDATE ".TB_PREF."shippers SET shipper_name='" . $_POST['shipper_name'] . "' ,
53 contact ='" . $_POST['contact'] . "' ,
54 phone ='" . $_POST['phone'] . "' ,
55 address ='" . $_POST['address'] . "'
56 WHERE shipper_id = $selected_id";
58 db_query($sql,"The shipping company could not be updated");
59 meta_forward($_SERVER['PHP_SELF']);
62 //----------------------------------------------------------------------------------------------
64 if (isset($_GET['delete']))
66 // PREVENT DELETES IF DEPENDENT RECORDS IN 'sales_orders'
68 $sql= "SELECT COUNT(*) FROM ".TB_PREF."sales_orders WHERE ship_via='$selected_id'";
69 $result = db_query($sql,"check failed");
70 $myrow = db_fetch_row($result);
74 display_error(_("Cannot delete this shipping company because sales orders have been created using this shipper."));
78 // PREVENT DELETES IF DEPENDENT RECORDS IN 'debtor_trans'
80 $sql= "SELECT COUNT(*) FROM ".TB_PREF."debtor_trans WHERE ship_via='$selected_id'";
81 $result = db_query($sql,"check failed");
82 $myrow = db_fetch_row($result);
86 display_error(_("Cannot delete this shipping company because invoices have been created using this shipping company."));
90 $sql="DELETE FROM ".TB_PREF."shippers WHERE shipper_id=$selected_id";
91 db_query($sql,"could not delete shipper");
93 meta_forward($_SERVER['PHP_SELF']);
98 //----------------------------------------------------------------------------------------------
100 $sql = "SELECT * FROM ".TB_PREF."shippers ORDER BY shipper_id";
101 $result = db_query($sql,"could not get shippers");
103 start_table($table_style);
104 $th = array(_("Name"), _("Contact Person"), _("Phone Number"), _("Address"), "", "");
107 $k = 0; //row colour counter
109 while ($myrow = db_fetch($result))
111 alt_table_row_color($k);
112 label_cell($myrow["shipper_name"]);
113 label_cell($myrow["contact"]);
114 label_cell($myrow["phone"]);
115 label_cell($myrow["address"]);
116 edit_link_cell("selected_id=".$myrow[0]);
117 delete_link_cell("selected_id=".$myrow[0]."&delete=1");
123 //----------------------------------------------------------------------------------------------
125 hyperlink_no_params($_SERVER['PHP_SELF'], _("New Shipping Company"));
129 start_table($table_style2);
131 if (isset($selected_id))
133 //editing an existing Shipper
135 $sql = "SELECT * FROM ".TB_PREF."shippers WHERE shipper_id=$selected_id";
137 $result = db_query($sql, "could not get shipper");
138 $myrow = db_fetch($result);
140 $_POST['shipper_name'] = $myrow["shipper_name"];
141 $_POST['contact'] = $myrow["contact"];
142 $_POST['phone'] = $myrow["phone"];
143 $_POST['address'] = $myrow["address"];
145 hidden('selected_id', $selected_id);
148 text_row_ex(_("Name:"), 'shipper_name', 40);
150 text_row_ex(_("Contact Person:"), 'contact', 30);
152 text_row_ex(_("Phone Number:"), 'phone', 20);
154 text_row_ex(_("Address:"), 'address', 50);
158 submit_add_or_update_center(!isset($selected_id));