projects
/
freeside.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(from parent 1:
a744e0e
)
parenthesis help alot
author
ivan
<ivan>
Tue, 9 Nov 2004 09:31:10 +0000
(09:31 +0000)
committer
ivan
<ivan>
Tue, 9 Nov 2004 09:31:10 +0000
(09:31 +0000)
httemplate/search/report_tax.cgi
patch
|
blob
|
history
diff --git
a/httemplate/search/report_tax.cgi
b/httemplate/search/report_tax.cgi
index
601763b
..
8cf6bd7
100755
(executable)
--- a/
httemplate/search/report_tax.cgi
+++ b/
httemplate/search/report_tax.cgi
@@
-125,7
+125,7
@@
foreach my $r (
my $named_tax =
$r->taxname
? 'AND itemdesc = '. dbh->quote($r->taxname)
- : "AND
itemdesc IS NULL OR itemdesc = '' OR itemdesc = 'Tax'
";
+ : "AND
( itemdesc IS NULL OR itemdesc = '' OR itemdesc = 'Tax' )
";
my $x = scalar_sql($r, \@taxparam,
"SELECT SUM(cust_bill_pkg.setup+cust_bill_pkg.recur) $taxwhere ".
"AND pkgnum = 0 $named_tax",