MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
***********************************************************************/
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
***********************************************************************/
- $sql = "INSERT INTO ".TB_PREF."shippers (shipper_name, contact, phone, address)
+ $sql = "INSERT INTO ".TB_PREF."shippers (shipper_name, contact, phone, phone2, address)
VALUES (" . db_escape($_POST['shipper_name']) . ", " .
db_escape($_POST['contact']). ", " .
db_escape($_POST['phone']). ", " .
VALUES (" . db_escape($_POST['shipper_name']) . ", " .
db_escape($_POST['contact']). ", " .
db_escape($_POST['phone']). ", " .
db_escape($_POST['address']) . ")";
db_query($sql,"The Shipping Company could not be added");
db_escape($_POST['address']) . ")";
db_query($sql,"The Shipping Company could not be added");
$sql = "UPDATE ".TB_PREF."shippers SET shipper_name=" . db_escape($_POST['shipper_name']). " ,
contact =" . db_escape($_POST['contact']). " ,
phone =" . db_escape($_POST['phone']). " ,
$sql = "UPDATE ".TB_PREF."shippers SET shipper_name=" . db_escape($_POST['shipper_name']). " ,
contact =" . db_escape($_POST['contact']). " ,
phone =" . db_escape($_POST['phone']). " ,
db_query($sql,"The shipping company could not be updated");
display_notification(_('Selected shipping company has been updated'));
db_query($sql,"The shipping company could not be updated");
display_notification(_('Selected shipping company has been updated'));
$result = db_query($sql,"check failed");
$myrow = db_fetch_row($result);
if ($myrow[0] > 0)
$result = db_query($sql,"check failed");
$myrow = db_fetch_row($result);
if ($myrow[0] > 0)
$result = db_query($sql,"check failed");
$myrow = db_fetch_row($result);
if ($myrow[0] > 0)
$result = db_query($sql,"check failed");
$myrow = db_fetch_row($result);
if ($myrow[0] > 0)
db_query($sql,"could not delete shipper");
display_notification(_('Selected shipping company has been deleted'));
}
db_query($sql,"could not delete shipper");
display_notification(_('Selected shipping company has been deleted'));
}
-$th = array(_("Name"), _("Contact Person"), _("Phone Number"), _("Address"), "", "");
+$th = array(_("Name"), _("Contact Person"), _("Phone Number"), _("Secondary Phone"), _("Address"), "", "");
label_cell($myrow["shipper_name"]);
label_cell($myrow["contact"]);
label_cell($myrow["phone"]);
label_cell($myrow["shipper_name"]);
label_cell($myrow["contact"]);
label_cell($myrow["phone"]);
label_cell($myrow["address"]);
inactive_control_cell($myrow["shipper_id"], $myrow["inactive"], 'shippers', 'shipper_id');
edit_button_cell("Edit".$myrow["shipper_id"], _("Edit"));
label_cell($myrow["address"]);
inactive_control_cell($myrow["shipper_id"], $myrow["inactive"], 'shippers', 'shipper_id');
edit_button_cell("Edit".$myrow["shipper_id"], _("Edit"));
$result = db_query($sql, "could not get shipper");
$myrow = db_fetch($result);
$result = db_query($sql, "could not get shipper");
$myrow = db_fetch($result);
$_POST['shipper_name'] = $myrow["shipper_name"];
$_POST['contact'] = $myrow["contact"];
$_POST['phone'] = $myrow["phone"];
$_POST['shipper_name'] = $myrow["shipper_name"];
$_POST['contact'] = $myrow["contact"];
$_POST['phone'] = $myrow["phone"];
$_POST['address'] = $myrow["address"];
}
hidden('selected_id', $selected_id);
$_POST['address'] = $myrow["address"];
}
hidden('selected_id', $selected_id);
-text_row_ex(_("Phone Number:"), 'phone', 20);
+text_row_ex(_("Phone Number:"), 'phone', 32, 30);
+
+text_row_ex(_("Secondary Phone Number:"), 'phone2', 32, 30);