projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Increased memory limit if reports in unicode (48M) as suggested in forum.
[fa-stable.git]
/
reporting
/
rep301.php
diff --git
a/reporting/rep301.php
b/reporting/rep301.php
index 41076dcb1e137a93dfd978e6b8076cdf0d3ab065..a2801336bd5f30f7f4bcdff9fb612470d5e45563 100644
(file)
--- 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,
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";
".TB_PREF."stock_master.stock_id,
".TB_PREF."stock_master.description
HAVING SUM(".TB_PREF."stock_moves.qty) != 0";