<% #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) %> <% } %> <% } %>
From to