projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
disable quotations, RT#20688, RT#22232
[freeside.git]
/
httemplate
/
search
/
cust_tax_exempt_pkg.cgi
diff --git
a/httemplate/search/cust_tax_exempt_pkg.cgi
b/httemplate/search/cust_tax_exempt_pkg.cgi
index
382dbc4
..
ba3f275
100644
(file)
--- a/
httemplate/search/cust_tax_exempt_pkg.cgi
+++ b/
httemplate/search/cust_tax_exempt_pkg.cgi
@@
-144,6
+144,10
@@
if ( $cgi->param('classnum') =~ /^(\d+)$/ ) {
push @where, "COALESCE(part_pkg.classnum,0) = $1";
}
push @where, "COALESCE(part_pkg.classnum,0) = $1";
}
+# no reason ever to show the negative exemptions created by credits.
+# they'll just confuse people.
+push @where, "creditbillpkgnum IS NULL";
+
my $where = scalar(@where) ? 'WHERE '.join(' AND ', @where) : '';
my $count_query = "SELECT COUNT(*), SUM(amount)".
my $where = scalar(@where) ? 'WHERE '.join(' AND ', @where) : '';
my $count_query = "SELECT COUNT(*), SUM(amount)".