[Frontaccounting-cvs_updates] /hgroot/frontaccounting/frontaccounting: Bug. WHERE clause versi...
Brought to you by:
frontaccounting,
itronics
From: FrontAccounting <fro...@us...> - 2012-03-13 08:19:15
|
details: http://frontaccounting.hg.sourceforge.net:8000/hgroot/frontaccounting/frontaccounting/hgroot/frontaccounting/frontaccounting/rev/087943c9dae4 changeset: 2989:087943c9dae4 user: Joe Hunt <joe...@gm...> date: Tue Mar 13 09:18:41 2012 +0100 description: Bug. WHERE clause version=1 in rep304.php should be skipped. diffstat: reporting/rep304.php | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diffs (12 lines): diff -r 1ab1011c78f9 -r 087943c9dae4 reporting/rep304.php --- a/reporting/rep304.php Tue Mar 13 09:13:02 2012 +0100 +++ b/reporting/rep304.php Tue Mar 13 09:18:41 2012 +0100 @@ -56,7 +56,7 @@ AND ".TB_PREF."stock_moves.trans_no=".TB_PREF."debtor_trans.trans_no AND ".TB_PREF."stock_moves.tran_date>='$from' AND ".TB_PREF."stock_moves.tran_date<='$to' - AND ((".TB_PREF."debtor_trans.type=".ST_CUSTDELIVERY." AND ".TB_PREF."debtor_trans.version=1) OR ".TB_PREF."stock_moves.type=".ST_CUSTCREDIT.") + AND (".TB_PREF."debtor_trans.type=".ST_CUSTDELIVERY." OR ".TB_PREF."stock_moves.type=".ST_CUSTCREDIT.") AND (".TB_PREF."stock_master.mb_flag='B' OR ".TB_PREF."stock_master.mb_flag='M')"; if ($category != 0) $sql .= " AND ".TB_PREF."stock_master.category_id = ".db_escape($category); |