X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=manufacturing%2Fincludes%2Fdb%2Fwork_orders_db.inc;h=7e8be6487754d9ff4a5f208070173236fb52bc5c;hb=e2fa1c1b9543dedb3cd0a3a36dc539c86f7ff473;hp=f97f87a5e3813e39d97d6d014029a852850a89b4;hpb=8ea6c4dd0d9b31b3456d012b0c94339b801bee0c;p=fa-stable.git

diff --git a/manufacturing/includes/db/work_orders_db.inc b/manufacturing/includes/db/work_orders_db.inc
index f97f87a5..7e8be648 100644
--- a/manufacturing/includes/db/work_orders_db.inc
+++ b/manufacturing/includes/db/work_orders_db.inc
@@ -309,6 +309,78 @@ function void_work_order($woid)
 	}
 }
 
+function get_sql_for_work_orders($outstanding_only, $all_items)
+{
+	$sql = "SELECT
+		workorder.id,
+		workorder.wo_ref,
+		workorder.type,
+		location.location_name,
+		item.description,
+		workorder.units_reqd,
+		workorder.units_issued,
+		workorder.date_,
+		workorder.required_by,
+		workorder.released_date,
+		workorder.closed,
+		workorder.released,
+		workorder.stock_id,
+		unit.decimals
+		FROM ".TB_PREF."workorders as workorder,"
+			.TB_PREF."stock_master as item,"
+			.TB_PREF."item_units as unit,"
+			.TB_PREF."locations as location
+		WHERE workorder.stock_id=item.stock_id 
+			AND workorder.loc_code=location.loc_code
+			AND item.units=unit.abbr";
+
+	if (check_value('OpenOnly') || $outstanding_only != 0)
+	{
+		$sql .= " AND workorder.closed=0";
+	}
+
+	if (isset($_POST['StockLocation']) && $_POST['StockLocation'] != $all_items)
+	{
+		$sql .= " AND workorder.loc_code=".db_escape($_POST['StockLocation']);
+	}
+
+	if (isset($_POST['OrderNumber']) && $_POST['OrderNumber'] != "")
+	{
+		$sql .= " AND workorder.wo_ref LIKE ".db_escape('%'.$_POST['OrderNumber'].'%');
+	}
+
+	if (isset($_POST['SelectedStockItem']) && $_POST['SelectedStockItem'] != $all_items)
+	{
+		$sql .= " AND workorder.stock_id=".db_escape($_POST['SelectedStockItem']);
+	}
+
+	if (check_value('OverdueOnly'))
+	{
+		$Today = date2sql(Today());
+
+		$sql .= " AND workorder.required_by < '$Today' ";
+	}
+	return $sql;
+}
+
+function get_sql_for_where_used()
+{
+	$sql = "SELECT 
+			bom.parent,
+			workcentre.name As WorkCentreName,
+			location.location_name,
+			bom.quantity,
+			parent.description
+			FROM ".TB_PREF."bom as bom, "
+				.TB_PREF."stock_master as parent, "
+				.TB_PREF."workcentres as workcentre, "
+				.TB_PREF."locations as location
+			WHERE bom.parent = parent.stock_id 
+				AND bom.workcentre_added = workcentre.id
+				AND bom.loc_code = location.loc_code
+				AND bom.component=".db_escape($_POST['stock_id']);
+	return $sql;			
+}
 //--------------------------------------------------------------------------------------
 
 ?>
\ No newline at end of file