X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;ds=sidebyside;f=inventory%2Fincludes%2Fdb%2Fitems_locations_db.inc;h=e85d39a1ce97164f5379d37574e2b3220b04b684;hb=490690013b7bb161ee2295b89cb18e1a88cae2af;hp=0cdb1e0c3206a4ea431e4b88a6071078f5f6c979;hpb=da8311619dd73feae101d246a1957b972e00cbd2;p=fa-stable.git diff --git a/inventory/includes/db/items_locations_db.inc b/inventory/includes/db/items_locations_db.inc index 0cdb1e0c..e85d39a1 100644 --- a/inventory/includes/db/items_locations_db.inc +++ b/inventory/includes/db/items_locations_db.inc @@ -1,76 +1,97 @@ . +***********************************************************************/ +function add_item_location($loc_code, $location_name, $delivery_address, $phone, $phone2, $fax, $email, $contact, $fixed_asset = 0) { - $sql = "INSERT INTO ".TB_PREF."locations (loc_code, location_name, delivery_address, phone, fax, email, contact) - VALUES ('$loc_code', '$location_name', '$delivery_address', '$phone', '$fax', '$email', '$contact')"; - + $sql = "INSERT INTO ".TB_PREF."locations (loc_code, location_name, delivery_address, phone, phone2, fax, email, contact, fixed_asset) + VALUES (".db_escape($loc_code).", ".db_escape($location_name).", ".db_escape($delivery_address).", " + .db_escape($phone).", ".db_escape($phone2).", ".db_escape($fax).", ".db_escape($email).", " + .db_escape($contact).", ".db_escape($fixed_asset).")"; + 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) - SELECT '$loc_code', ".TB_PREF."stock_master.stock_id, 0 FROM ".TB_PREF."stock_master"; - - db_query($sql,"a location could not be added"); + $sql = "INSERT INTO ".TB_PREF."loc_stock (loc_code, stock_id, reorder_level) + SELECT ".db_escape($loc_code).", ".TB_PREF."stock_master.stock_id, 0 FROM ".TB_PREF."stock_master"; + + db_query($sql,"a location could not be added"); } //------------------------------------------------------------------------------------ -function update_item_location($loc_code, $location_name, $delivery_address, $phone, $fax, $email, $contact) +function update_item_location($loc_code, $location_name, $delivery_address, $phone, $phone2, $fax, $email, $contact, $fixed_asset = 0) { - $sql = "UPDATE ".TB_PREF."locations SET location_name='$location_name', - delivery_address='$delivery_address', - phone='$phone', fax='$fax', - email='$email', contact='$contact' - WHERE loc_code = '$loc_code'"; - - db_query($sql,"a location could not be updated"); + $sql = "UPDATE ".TB_PREF."locations SET location_name=".db_escape($location_name).", + delivery_address=".db_escape($delivery_address).", + phone=".db_escape($phone).", phone2=".db_escape($phone2).", fax=".db_escape($fax).", + email=".db_escape($email).", contact=".db_escape($contact).", + fixed_asset=".db_escape($fixed_asset)." + WHERE loc_code = ".db_escape($loc_code); + + db_query($sql,"a location could not be updated"); } //------------------------------------------------------------------------------------ function delete_item_location($item_location) { - $sql="DELETE FROM ".TB_PREF."locations WHERE loc_code='$item_location'"; + $sql="DELETE FROM ".TB_PREF."locations WHERE loc_code=".db_escape($item_location); + db_query($sql,"a location could not be deleted"); + + $sql = "DELETE FROM ".TB_PREF."loc_stock WHERE loc_code =".db_escape($item_location); db_query($sql,"a location could not be deleted"); - - $sql = "DELETE FROM ".TB_PREF."loc_stock WHERE loc_code ='$item_location'"; - db_query($sql,"a location could not be deleted"); } //------------------------------------------------------------------------------------ function get_item_location($item_location) { - $sql="SELECT * FROM ".TB_PREF."locations WHERE loc_code='$item_location'"; - + $sql="SELECT * FROM ".TB_PREF."locations WHERE loc_code=".db_escape($item_location); + $result = db_query($sql,"a location could not be retrieved"); - - return db_fetch($result); + + return db_fetch($result); } //------------------------------------------------------------------------------------ -function set_reorder_level($stock_id, $loc_code, $reorder_level) +function get_item_locations($show_inactive, $fixed_asset = 0) { - $sql = "UPDATE ".TB_PREF."loc_stock SET reorder_level = $reorder_level - WHERE stock_id = '$stock_id' AND loc_code = '$loc_code'"; - - db_query($sql,"an item reorder could not be set"); + $sql = "SELECT * FROM ".TB_PREF."locations WHERE fixed_asset = ".db_escape($fixed_asset); + if (!$show_inactive) $sql .= " AND !inactive"; + return db_query($sql, "could not query locations"); } //------------------------------------------------------------------------------------ -function get_loc_details($stock_id) +function set_reorder_level($stock_id, $loc_code, $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 - AND ".TB_PREF."loc_stock.stock_id = '" . $stock_id . "' ORDER BY ".TB_PREF."loc_stock.loc_code"; - return db_query($sql,"an item reorder could not be retreived"); + $sql = "UPDATE ".TB_PREF."loc_stock SET reorder_level = $reorder_level + WHERE stock_id = ".db_escape($stock_id)." AND loc_code = ".db_escape($loc_code); + + db_query($sql,"an item reorder could not be set"); } //------------------------------------------------------------------------------------ -?> \ No newline at end of file +function get_loc_details($stock_id, $fixed_asset = 0) +{ + $sql = "SELECT stock.loc_code, stock.location_name, " + .db_escape($stock_id)." as stock_id, reorders.reorder_level + FROM ".TB_PREF."locations stock LEFT JOIN ".TB_PREF."loc_stock reorders ON + reorders.loc_code=stock.loc_code + AND reorders.stock_id = ".db_escape($stock_id) + ." WHERE stock.fixed_asset = ".db_escape($fixed_asset) + ." ORDER BY reorders.loc_code"; + return db_query($sql,"an item reorder could not be retreived"); +} +