- my $same_query = 'SELECT taxclass FROM cust_main_county '.
- ' WHERE taxnum != ? AND country = ?';
- my @same_param = ( 'taxnum', 'country' );
- foreach my $opt_field (qw( state county )) {
- if ( $r->$opt_field() ) {
- $same_query .= " AND $opt_field = ?";
- push @same_param, $opt_field;
- } else {
- $same_query .= " AND $opt_field IS NULL";
- }
- }
-
- my @taxclasses = list_sql( $r, \@same_param, $same_query );
-
- if ( scalar(@taxclasses) ) {
- $mywhere .= ' AND '. join(' AND ', map ' taxclass != ? ', @taxclasses );
- push @param, @taxclasses;
- }
-
+ $regions{$label}->{'url_param'} .= ';taxclassNULL=1'
+ if $cgi->param('show_taxclasses');
+
+ my $same_sql = $r->sql_taxclass_sameregion;
+ $mywhere .= " AND $same_sql" if $same_sql;
+