X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fsearch%2Freport_tax.html;h=8a207aafbdc18b1629b02f9d85abab3e906cac31;hb=63973c641c4be00765fa27e55c57cc5b9aa4da19;hp=bdeb8e2372d45c17c14b5d94b3da55afb2e50fb1;hpb=2c757d7db4cb6a7b9655de13206fcc84fb7ce61f;p=freeside.git diff --git a/httemplate/search/report_tax.html b/httemplate/search/report_tax.html index bdeb8e237..8a207aafb 100755 --- a/httemplate/search/report_tax.html +++ b/httemplate/search/report_tax.html @@ -1,30 +1,70 @@ -<%= include('/elements/header.html', 'Tax Report' ) %> +<% include('/elements/header.html', 'Tax Report' ) %>
-<%= include('/elements/footer.html') %> +<% include('/elements/footer.html') %> +<%init> + +die "access denied" + unless $FS::CurrentUser::CurrentUser->access_right('Financial reports'); + +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>