6 include($path_to_root . "/includes/session.inc");
7 page(_("Shipping Company"));
8 include($path_to_root . "/includes/ui.inc");
10 simple_page_mode(true);
11 //----------------------------------------------------------------------------------------------
13 function can_process()
15 if (strlen($_POST['shipper_name']) == 0)
17 display_error(_("The shipping company name cannot be empty."));
18 set_focus('shipper_name');
24 //----------------------------------------------------------------------------------------------
25 if ($Mode=='ADD_ITEM' && can_process())
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']) . ")";
34 db_query($sql,"The Shipping Company could not be added");
35 display_notification(_('New shipping company has been added'));
39 //----------------------------------------------------------------------------------------------
41 if ($Mode=='UPDATE_ITEM' && can_process())
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";
50 db_query($sql,"The shipping company could not be updated");
51 display_notification(_('Selected shipping company has been updated'));
55 //----------------------------------------------------------------------------------------------
57 if ($Mode == 'Delete')
59 // PREVENT DELETES IF DEPENDENT RECORDS IN 'sales_orders'
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);
67 display_error(_("Cannot delete this shipping company because sales orders have been created using this shipper."));
71 // PREVENT DELETES IF DEPENDENT RECORDS IN 'debtor_trans'
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);
79 display_error(_("Cannot delete this shipping company because invoices have been created using this shipping company."));
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'));
96 //----------------------------------------------------------------------------------------------
98 $sql = "SELECT * FROM ".TB_PREF."shippers ORDER BY shipper_id";
99 $result = db_query($sql,"could not get shippers");
102 start_table($table_style);
103 $th = array(_("Name"), _("Contact Person"), _("Phone Number"), _("Address"), "", "");
106 $k = 0; //row colour counter
108 while ($myrow = db_fetch($result))
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"));
124 //----------------------------------------------------------------------------------------------
128 start_table($table_style2);
130 if ($selected_id != -1)
132 if ($Mode == 'Edit') {
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($selected_id == -1, '', true);