diff options
| -rw-r--r-- | httemplate/search/cust_bill_pkg.cgi | 11 |
1 files changed, 10 insertions, 1 deletions
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; + } } |