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 a2c302b6fe4021964070aa90c13832c66b312cdf..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);
        }
@@ -379,4 +379,3 @@ function get_gl_wo_cost($woid, $cost_type)
        return $cost;   
 }
 
-?>
\ No newline at end of file