function add_item_location($loc_code, $location_name, $delivery_address, $phone, $fax, $email, $contact)
{
$sql = "INSERT INTO ".TB_PREF."locations (loc_code, location_name, delivery_address, phone, fax, email, contact)
function add_item_location($loc_code, $location_name, $delivery_address, $phone, $fax, $email, $contact)
{
$sql = "INSERT INTO ".TB_PREF."locations (loc_code, location_name, delivery_address, phone, fax, email, contact)
- VALUES (".db_escape($loc_code).", ".db_escape($location_name).", ".db_escape($delivery_address).", ".db_escape($phone).", ".db_escape($fax).", ".db_escape($email).", ".db_escape($contact).")";
-
+ VALUES (".db_escape($loc_code).", ".db_escape($location_name)
+ .", ".db_escape($delivery_address).", ".db_escape($phone)
+ .", ".db_escape($fax).", ".db_escape($email).", ".db_escape($contact).")";
db_query($sql,"a location could not be added");
/* Also need to add loc_stock records for all existing items */
$sql = "INSERT INTO ".TB_PREF."loc_stock (loc_code, stock_id, reorder_level)
db_query($sql,"a location could not be added");
/* Also need to add loc_stock records for all existing items */
$sql = "INSERT INTO ".TB_PREF."loc_stock (loc_code, stock_id, reorder_level)
delivery_address=".db_escape($delivery_address).",
phone=".db_escape($phone).", fax=".db_escape($fax).",
email=".db_escape($email).", contact=".db_escape($contact)."
delivery_address=".db_escape($delivery_address).",
phone=".db_escape($phone).", fax=".db_escape($fax).",
email=".db_escape($email).", contact=".db_escape($contact)."
function set_reorder_level($stock_id, $loc_code, $reorder_level)
{
$sql = "UPDATE ".TB_PREF."loc_stock SET reorder_level = $reorder_level
function set_reorder_level($stock_id, $loc_code, $reorder_level)
{
$sql = "UPDATE ".TB_PREF."loc_stock SET reorder_level = $reorder_level
$sql = "SELECT ".TB_PREF."loc_stock.*, ".TB_PREF."locations.location_name
FROM ".TB_PREF."loc_stock, ".TB_PREF."locations
WHERE ".TB_PREF."loc_stock.loc_code=".TB_PREF."locations.loc_code
$sql = "SELECT ".TB_PREF."loc_stock.*, ".TB_PREF."locations.location_name
FROM ".TB_PREF."loc_stock, ".TB_PREF."locations
WHERE ".TB_PREF."loc_stock.loc_code=".TB_PREF."locations.loc_code