X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fsearch%2Freport_tax.html;h=8d8d1084c4eb12f1f73b26a74d16ef0f17cd3527;hb=a6def4c68914a9d8a282eaa34dcff5f6fd002568;hp=55b9e097b30baedc04c1712cdbe01e8c3d250218;hpb=56c771abafb2cad3430fee10deacba6e561933de;p=freeside.git
diff --git a/httemplate/search/report_tax.html b/httemplate/search/report_tax.html
index 55b9e097b..8d8d1084c 100755
--- a/httemplate/search/report_tax.html
+++ b/httemplate/search/report_tax.html
@@ -1,43 +1,82 @@
-
-
- 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 $sth = dbh->prepare('SELECT DISTINCT(COALESCE(taxname, \'Tax\')) FROM cust_main_county');
+$sth->execute or die $sth->errstr;
+my @taxnames = map { $_->[0] } @{ $sth->fetchall_arrayref };
+
+$sth = dbh->prepare('SELECT DISTINCT(country) FROM cust_location');
+$sth->execute or die $sth->errstr;
+my @countries = map { $_->[0] } @{ $sth->fetchall_arrayref };
+
+my @breakdown;
+if ( $conf->exists('enable_taxclasses') ) {
+ push @breakdown, 'taxclass';
+}
+if ( FS::pkg_class->count() > 0 ) {
+ push @breakdown, 'pkgclass';
+}
+if ( FS::cust_main_county->count("city is not null and city != ''") > 0 ) {
+ push @breakdown, 'city';
+}
+if ( FS::cust_main_county->count("district is not null") > 0 ) {
+ push @breakdown, 'district';
+}
+
+%init>