From 64e7037dd42a240f095e76ea7cba007dd1340bc5 Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Tue, 8 Jul 2008 02:19:56 +0000
Subject: fix line-item reports on taxclass-less regions

---
 httemplate/search/cust_bill_pkg.cgi | 11 ++++++++++-
 1 file changed, 10 insertions(+), 1 deletion(-)

(limited to 'httemplate')

diff --git a/httemplate/search/cust_bill_pkg.cgi b/httemplate/search/cust_bill_pkg.cgi
index 4ac9d9f3f..74efe4f7e 100644
--- a/httemplate/search/cust_bill_pkg.cgi
+++ b/httemplate/search/cust_bill_pkg.cgi
@@ -123,8 +123,17 @@ if ( $cgi->param('out') ) {
     if $cgi->param('taxclass');
 
   if ( $cgi->param('taxclassNULL') ) {
-    my $same_sql = $r->sql_taxclass_sameregion;
+
+    my %hash = ( 'country' => scalar($cgi->param('country')) );
+    foreach (qw( state county )) {
+      $hash{$_} = scalar($cgi->param($_)) if $cgi->param($_);
+    }
+    my $cust_main_county = qsearchs('cust_main_county', \%hash);
+    die "unknown base region for empty taxclass" unless $cust_main_county;
+
+    my $same_sql = $cust_main_county->sql_taxclass_sameregion;
     push @where, $same_sql if $same_sql;
+
   }
 
 }
-- 
cgit v1.2.1