diff options
author | ivan <ivan> | 2011-07-21 23:33:11 +0000 |
---|---|---|
committer | ivan <ivan> | 2011-07-21 23:33:11 +0000 |
commit | 796183f5d59290f1d8b678f4a5d86431389eb5df (patch) | |
tree | 269b2eadde5feae1a80cac25ae17de49052b1818 /httemplate/search/cust_bill_pkg.cgi | |
parent | c598fcf11241b02111a2df43860199ae8a9d5512 (diff) |
fix tax reports for taxclass+non-taxclass cases, RT#13160
Diffstat (limited to 'httemplate/search/cust_bill_pkg.cgi')
-rw-r--r-- | httemplate/search/cust_bill_pkg.cgi | 11 |
1 files changed, 5 insertions, 6 deletions
diff --git a/httemplate/search/cust_bill_pkg.cgi b/httemplate/search/cust_bill_pkg.cgi index 007f593..15edba0 100644 --- a/httemplate/search/cust_bill_pkg.cgi +++ b/httemplate/search/cust_bill_pkg.cgi @@ -73,6 +73,7 @@ \&FS::UI::Web::cust_fields, ], 'sort_fields' => [ + '', 'setup', #broken in $unearned case i guess ( $unearned ? ('', '') : () ), ( $use_usage eq 'recurring' ? 'recur - usage' : @@ -201,12 +202,9 @@ if ( $cgi->param('taxclass') # #} else { - push @where, - ' ( '. join(' OR ', - map ' part_pkg.taxclass = '.dbh->quote($_), - $cgi->param('taxclass') - ). - ' ) '; + push @where, ' part_pkg.taxclass IN ( '. + join(', ', map dbh->quote($_), $cgi->param('taxclass') ). + ' ) '; #} @@ -312,6 +310,7 @@ if ( $cgi->param('out') ) { die "unknown base region for empty taxclass" unless $cust_main_county; my $same_sql = $cust_main_county->sql_taxclass_sameregion; + $same_sql =~ s/taxclass/part_pkg.taxclass/g; push @where, $same_sql if $same_sql; } |