<% #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 ? '' : '' %> <% } %> <% } %>
From to