$sql = "SELECT stock_id, SUM(qty) FROM ".TB_PREF."stock_moves WHERE tran_date <= '$date'";
if ($location != '') $sql .= " AND loc_code = ".db_escape($location);
$sql .= " GROUP BY stock_id";
- $result = db_query($sql, "QOH calulcation failed");
+ $result = db_query($sql, "QOH calculation failed");
while ($row = db_fetch($result)) {
$qoh_stock[$row[0]] = $row[1];
}
return $qoo;
}
-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];
-}
-
//--------------------------------------------------------------------------------------
function add_bom($selected_parent, $component, $workcentre_added, $loc_code, $quantity)
$sql = "SELECT component FROM ".TB_PREF."bom WHERE parent=".db_escape($component_to_check);
$result = db_query($sql,"could not check recursive bom");
- if ($result != 0)
+ if ($result)
{
while ($myrow = db_fetch_row($result))
{
{
return 1;
}
- } //(while loop)
- } //end if $result is true
+ }
+ }
return 0;
-} //end of function check_for_recursive_bom
+}
-?>