X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=includes%2Fdb%2Fmanufacturing_db.inc;h=93027b764b9f32e65beda3e463c4c6ba280ecfb8;hb=317210096efdbe5b375d5a0112d4f10a3c3c0b53;hp=dc635c3a9ec333e2a1b8613a28fff75c865eaa1d;hpb=fc449c48a8d4ba23bfb18318dff08746340a440c;p=fa-stable.git

diff --git a/includes/db/manufacturing_db.inc b/includes/db/manufacturing_db.inc
index dc635c3a..93027b76 100644
--- a/includes/db/manufacturing_db.inc
+++ b/includes/db/manufacturing_db.inc
@@ -149,29 +149,14 @@ function get_on_porder_qty($stock_id, $location)
 
 function get_on_worder_qty($stock_id, $location)
 {
-	$sql = "SELECT SUM((wo.units_reqd-wo.units_issued) * (req.units_req-req.units_issued)) AS qoo
-		FROM ".TB_PREF."wo_requirements req
-			INNER JOIN ".TB_PREF."workorders wo	ON req.workorder_id=wo.id
-		WHERE req.stock_id=".db_escape($stock_id)
-			." AND wo.released=1";
-	if ($location != "")
-		$sql .= " AND req.loc_code=".db_escape($location);
-
-	$qoo_result = db_query($sql,"could not receive quantity on order for item");
-	if (db_num_rows($qoo_result) == 1)
-	{
-		$qoo_row = db_fetch_row($qoo_result);
-		$qoo =  $qoo_row[0];
-	}
-	else
-		$qoo = 0.0;
+ 	$qoo = 0.0;
 	$flag = get_mb_flag($stock_id);
 	if ($flag == 'M')
 	{
 		$sql = "SELECT SUM((units_reqd-units_issued)) AS qoo
 			FROM ".TB_PREF."workorders
 			WHERE stock_id=".db_escape($stock_id)
-				." AND released=1";
+				." AND released AND NOT closed";
 
 		if ($location != "")
 			$sql .= " AND loc_code=".db_escape($location);
@@ -180,7 +165,7 @@ function get_on_worder_qty($stock_id, $location)
 		if (db_num_rows($qoo_result) == 1)
 		{
 			$qoo_row = db_fetch_row($qoo_result);
-			$qoo +=  $qoo_row[0];
+			$qoo = $qoo_row[0];
 		}
 	}
 	return $qoo;