X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fsearch%2Freport_tax.html;h=2ab0e0b2e37988e16fa76c267f26965a6ec47d55;hb=2888eb3dd278260b3ed6ad4a2d4ae3ba656f6a57;hp=85af212d7c040aa7b38a47cddf6d65c8d4a0e540;hpb=34647c32b50ce3b8ee1b6d3d7aef4ba9d0297bdb;p=freeside.git
diff --git a/httemplate/search/report_tax.html b/httemplate/search/report_tax.html
index 85af212d7..2ab0e0b2e 100755
--- a/httemplate/search/report_tax.html
+++ b/httemplate/search/report_tax.html
@@ -1,44 +1,79 @@
-
-
- Tax Report Criteria
-
-
-
-
-
- Tax Report Criteria
-
-
-
+<% include('/elements/header.html', 'Tax Report' ) %>
+
+
+<% 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>