%
#my ($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = localtime(time);
my ($curmon,$curyear) = (localtime(time))[4,5];
#find first month
my $syear = $cgi->param('syear') || 1899+$curyear;
my $smonth = $cgi->param('smonth') || $curmon+1;
#find last month
my $eyear = $cgi->param('eyear') || 1900+$curyear;
my $emonth = $cgi->param('emonth') || $curmon+1;
%>
Sales, Credits and Receipts Summary
<%= table('e8e8e8') %>
<%
my @items = qw( invoiced netsales credits receipts );
my %label = (
'invoiced' => 'Gross Sales',
'netsales' => 'Net Sales',
'credits' => 'Credits',
'receipts' => 'Receipts',
);
my %color = (
'invoiced' => '9999ff', #light blue
'netsales' => '0000cc', #blue
'credits' => 'cc0000', #red
'receipts' => '00cc00', #green
);
my $report = new FS::Report::Table::Monthly (
'items' => \@items,
'start_month' => $smonth,
'start_year' => $syear,
'end_month' => $emonth,
'end_year' => $eyear,
);
my $data = $report->data;
my @mon = qw(Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec);
%>
|
<% foreach my $column ( @{$data->{label}} ) {
#$column =~ s/^(\d+)\//$mon[$1-1]
/e;
$column =~ s/^(\d+)\//$mon[$1-1]
/;
%>
<%= $column %> |
<% } %>
<% foreach my $row (@items) { %>
<%= $label{$row} %> |
<% foreach my $column ( @{$data->{$row}} ) { %>
$<%= sprintf("%.2f", $column) %>
|
<% } %>
<% } %>