projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Solution for item editable description
[fa-stable.git]
/
reporting
/
rep307.php
diff --git
a/reporting/rep307.php
b/reporting/rep307.php
index 19db40997a4ba6b9485a043a695be1afe9548f91..aee04a26db9231d8d90921acb1d194b07e1b4b6d 100644
(file)
--- a/
reporting/rep307.php
+++ b/
reporting/rep307.php
@@
-37,7
+37,7
@@
function fetch_items($category=0)
units,
cat.description
FROM ".TB_PREF."stock_master stock LEFT JOIN ".TB_PREF."stock_category cat ON stock.category_id=cat.category_id
units,
cat.description
FROM ".TB_PREF."stock_master stock LEFT JOIN ".TB_PREF."stock_category cat ON stock.category_id=cat.category_id
- WHERE mb_flag <> 'D'";
+ WHERE mb_flag <> 'D'
AND mb_flag <>'F'
";
if ($category != 0)
$sql .= " AND cat.category_id = ".db_escape($category);
$sql .= " ORDER BY stock.category_id, stock_id";
if ($category != 0)
$sql .= " AND cat.category_id = ".db_escape($category);
$sql .= " ORDER BY stock.category_id, stock_id";