%
#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 payments receipts );
my %label = (
'invoiced' => 'Gross Sales',
'netsales' => 'Net Sales',
'credits' => 'Credits',
'payments' => 'Gross Receipts',
'receipts' => 'Net Receipts',
);
my %color = (
'invoiced' => '9999ff', #light blue
'netsales' => '0000cc', #blue
'credits' => 'cc0000', #red
'payments' => '99cc99', #light green
'receipts' => '00cc00', #green
);
my %link = (
'invoiced' => "${p}search/cust_bill.html?",
'credits' => "${p}search/cust_credit.html?",
'payments' => "${p}search/cust_pay.cgi?magic=_date;",
);
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} %> |
<% my $link = exists($link{$row})
? qq(
<%= $link ? $link. 'begin='. shift(@speriod). ';end='. shift(@eperiod). '">' : '' %>$<%= sprintf("%.2f", $column) %><%= $link ? '' : '' %>
<% } %>
<% } %>