From e75f08d15a25977a68948399350f6e13303d560a Mon Sep 17 00:00:00 2001 From: Mark Wells Date: Wed, 9 Sep 2015 19:18:45 -0700 Subject: [PATCH] fix itemdesc filter, #38020, from #26770 --- httemplate/search/cust_bill_pkg.cgi | 10 ++++++++++ 1 file changed, 10 insertions(+) diff --git a/httemplate/search/cust_bill_pkg.cgi b/httemplate/search/cust_bill_pkg.cgi index 4fb9b662b..278382feb 100644 --- a/httemplate/search/cust_bill_pkg.cgi +++ b/httemplate/search/cust_bill_pkg.cgi @@ -601,6 +601,16 @@ if ( $cgi->param('nottax') ) { } } + # itemdesc, for breakdown from the vendor tax report + # (this is definitely used) + if ( $cgi->param('itemdesc') ) { + if ( $cgi->param('itemdesc') eq 'Tax' ) { + push @where, "($itemdesc = 'Tax' OR $itemdesc is null)"; + } else { + push @where, "$itemdesc = ". dbh->quote($cgi->param('itemdesc')); + } + } + } else { # the internal-tax case my $tax_select = 'SELECT tax.billpkgnum, SUM(tax.amount) as tax_total'; -- 2.11.0