- my $join_pkg = "
- JOIN cust_pkg USING ( pkgnum )
- JOIN part_pkg USING ( pkgpart )
- ";
-
- my $where = "
- WHERE _date >= $beginning AND _date <= $ending
- AND ( county = ? OR ? = '' )
- AND ( state = ? OR ? = '' )
- AND ( country = ? )
- AND payby != 'COMP'
- ";
-
- my $taxwhere = my $fromwhere = "
- FROM cust_bill_pkg
- JOIN cust_bill USING ( invnum )
- JOIN cust_main USING ( custnum )
- ";
-
- $fromwhere .= $join_pkg. $where;
- $taxwhere .= $where;
-
- my @taxparam = my @param = qw( county county state state country );
-
- my $num_others =
- scalar_sql( $r, [qw( country state state county county taxname taxname )],
- "SELECT COUNT(*) FROM cust_main_county
- WHERE country = ?
- AND ( state = ? OR ( state IS NULL AND ? = '' ) )
- AND ( county = ? OR ( county IS NULL AND ? = '' ) )
- AND ( taxname = ? OR ( taxname IS NULL AND ? = '' ) ) "
- );