+function get_sql_for_work_orders($outstanding_only, $stock_id, $location = ALL_TEXT, $order_no='', $order_ref = '', $overdue = false)
+{
+ $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 ($location != ALL_TEXT)
+ {
+ $sql .= " AND workorder.loc_code=".db_escape($location);
+ }
+
+ if ($order_no != '')
+ {
+ $sql .= " AND workorder.id LIKE ".db_escape('%'.$order_no.'%');
+ }
+
+ if ($order_ref != '')
+ {
+ $sql .= " AND workorder.wo_ref LIKE ".db_escape('%'.$order_ref.'%');
+ }
+
+ if ($stock_id != ALL_TEXT)
+ {
+ $sql .= " AND workorder.stock_id=".db_escape($stock_id);
+ }
+
+ if ($overdue)
+ {
+ $Today = date2sql(Today());
+
+ $sql .= " AND workorder.required_by < '$Today' ";
+ }
+ $sql .= " ORDER BY workorder.id DESC";
+ return $sql;
+}
+
+function get_sql_for_where_used($stock_id)
+{
+ $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($stock_id);
+ return $sql;
+}