X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=includes%2Fdb%2Finventory_db.inc;h=48aa125d37b56918c0abe2ce8af964a1b6b957c5;hb=f2343f51b0ed0d9abd2ec98b64f202beb9716d37;hp=b0807f19108ba9267c7e06e1a3eb77b35c34a9dc;hpb=8c8a0c2edc1de65820507e7129bcb340209e6164;p=fa-stable.git

diff --git a/includes/db/inventory_db.inc b/includes/db/inventory_db.inc
index b0807f19..48aa125d 100644
--- a/includes/db/inventory_db.inc
+++ b/includes/db/inventory_db.inc
@@ -445,3 +445,17 @@ function get_location_name($loc_code)
 
 	display_db_error("could not retreive the location name for $loc_code", $sql, true);
 }
+
+function get_mb_flag($stock_id)
+{
+	$sql = "SELECT mb_flag FROM ".TB_PREF."stock_master WHERE stock_id = "
+		.db_escape($stock_id);
+	$result = db_query($sql, "retreive mb_flag from item");
+	
+	if (db_num_rows($result) == 0)
+		return -1;
+
+	$myrow = db_fetch_row($result);
+	return $myrow[0];
+}
+