//------------------------------------------------------------------------------------
+function get_item_locations($show_inactive)
+{
+ $sql = "SELECT * FROM ".TB_PREF."locations";
+ if (!$show_inactive) $sql .= " WHERE !inactive";
+ return db_query($sql, "could not query locations");;
+}
+
+//------------------------------------------------------------------------------------
+
function set_reorder_level($stock_id, $loc_code, $reorder_level)
{
$sql = "UPDATE ".TB_PREF."loc_stock SET reorder_level = $reorder_level
return db_query($sql,"an item reorder could not be retreived");
}
-//------------------------------------------------------------------------------------
-
?>
\ No newline at end of file