projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
fix Tokenized payinfo on upgrade if we can, RT#71513
[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
..
7b4a6d0
100644
(file)
--- a/
httemplate/search/cust_tax_exempt_pkg.cgi
+++ b/
httemplate/search/cust_tax_exempt_pkg.cgi
@@
-107,7
+107,6
@@
my($beginning, $ending) = FS::UI::Web::parse_beginning_ending($cgi);
if ( $beginning || $ending ) {
push @where, "_date >= $beginning",
"_date <= $ending";
if ( $beginning || $ending ) {
push @where, "_date >= $beginning",
"_date <= $ending";
- #"payby != 'COMP';
}
if ( $cgi->param('agentnum') =~ /^(\d+)$/ ) {
}
if ( $cgi->param('agentnum') =~ /^(\d+)$/ ) {
@@
-144,6
+143,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)".