Cleanup in db_pager get_sql and testing it.

[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 12332c785e763ba1b39b9313beb5be49ddb0f264..35c00d392d882cc627fa6c9e27b112d74c473288 100644 (file)
--- a/manufacturing/includes/db/work_orders_db.inc
+++ b/manufacturing/includes/db/work_orders_db.inc
@@ -337,7 +337,7 @@ function get_sql_for_work_orders($outstanding_only, $stock_id, $location = ALL_T
                $sql .= " AND workorder.wo_ref LIKE ".db_escape('%'.$order.'%');
        }
 
-       if ($stock_id != '')
+       if ($stock_id != ALL_TEXT)
        {
                $sql .= " AND workorder.stock_id=".db_escape($stock_id);
        }