Moved all SQL statements from PHP files into relevant *_db.inc files.

[fa-stable.git] / manufacturing / includes / db / work_orders_db.inc

diff --git a/manufacturing/includes/db/work_orders_db.inc b/manufacturing/includes/db/work_orders_db.inc
index f97f87a5e3813e39d97d6d014029a852850a89b4..7e8be6487754d9ff4a5f208070173236fb52bc5c 100644 (file)
--- 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