diff options
Diffstat (limited to 'httemplate/search/report_tax.html')
| -rwxr-xr-x | httemplate/search/report_tax.html | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/httemplate/search/report_tax.html b/httemplate/search/report_tax.html index 217f48146..2ab0e0b2e 100755 --- a/httemplate/search/report_tax.html +++ b/httemplate/search/report_tax.html @@ -32,6 +32,13 @@ <% include( '/elements/tr-input-beginning_ending.html' ) %> +% if ( $city ) { + <TR> + <TD ALIGN="right"><INPUT TYPE="checkbox" NAME="show_cities" VALUE="1"></TD> + <TD>Show cities</TD> + </TR> +% } + % if ( $conf->exists('enable_taxclasses') ) { <TR> <TD ALIGN="right"><INPUT TYPE="checkbox" NAME="show_taxclasses" VALUE="1"></TD> @@ -61,4 +68,12 @@ die "access denied" my $conf = new FS::Conf; +my $city_sql = "SELECT COUNT(*) FROM cust_main_county + WHERE city != '' AND city IS NOT NULL + LIMIT 1"; + +my $city_sth = dbh->prepare($city_sql) or die dbh->errstr; +$city_sth->execute or die $city_sth->errstr; +my $city = $city_sth->fetchrow_arrayref->[0]; + </%init> |