From 04377d31d0546daa2ae056c7181268e7ee4d1b52 Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Thu, 4 Sep 2008 15:47:48 +0000 Subject: [PATCH] *** empty log message *** --- reporting/rep301.php | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) diff --git a/reporting/rep301.php b/reporting/rep301.php index 41076dc..a280133 100644 --- a/reporting/rep301.php +++ b/reporting/rep301.php @@ -36,9 +36,10 @@ function getTransactions($category, $location) WHERE ".TB_PREF."stock_master.stock_id=".TB_PREF."stock_moves.stock_id AND ".TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id GROUP BY ".TB_PREF."stock_master.category_id, - ".TB_PREF."stock_category.description, - ".TB_PREF."stock_moves.loc_code, - UnitCost, + ".TB_PREF."stock_category.description, "; + if ($location != 'all') + $sql .= TB_PREF."stock_moves.loc_code, "; + $sql .= "UnitCost, ".TB_PREF."stock_master.stock_id, ".TB_PREF."stock_master.description HAVING SUM(".TB_PREF."stock_moves.qty) != 0"; -- 2.30.2