fix A/R report
[freeside.git] / httemplate / search / tax_sales.html
1 <% include('/elements/header.html', 'Monthly Sales and Taxes Report' ) %>
2
3 <FORM ACTION="tax_sales.cgi" METHOD="GET">
4
5 <TABLE>
6
7   <% include('/elements/tr-select-from_to.html') %>
8
9   <% include('/elements/tr-select.html',
10       'label'         => 'Country',
11       'field'         => 'country',
12       'options'       => \@countries,
13       'curr_value'    => ($conf->config('countrydefault') || 'US'),
14      ) %>
15
16 </TABLE>
17
18 <BR><INPUT TYPE="submit" VALUE="Get Report">
19
20 </FORM>
21
22 <% include('/elements/footer.html') %>
23 <%init>
24
25 die "access denied"
26   unless $FS::CurrentUser::CurrentUser->access_right('Financial reports');
27
28 my $conf = new FS::Conf;
29
30 # false laziness w report_tax.html, put this in FS::Report::Tax?
31 my $sth = dbh->prepare('SELECT DISTINCT(country) FROM cust_location');
32 $sth->execute or die $sth->errstr;
33 my @countries = map { $_->[0] } @{ $sth->fetchall_arrayref };
34
35 </%init>