X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fgraph%2Fmoney_time.cgi;h=2b98af838a582e16ced6b0efad197596ecd27d4c;hb=eb4ff7f73c5d4bdf74a3472448b5a195598ff4cd;hp=829b1e66fbd8f9516fdc741b0517b15a069b4c94;hpb=c8cccb4a92adceb943c635fe62dad0d034462ce0;p=freeside.git diff --git a/httemplate/graph/money_time.cgi b/httemplate/graph/money_time.cgi index 829b1e66f..2b98af838 100644 --- a/httemplate/graph/money_time.cgi +++ b/httemplate/graph/money_time.cgi @@ -1,68 +1,3 @@ -% -% -%#find first month -%my $syear = $cgi->param('start_year'); # || 1899+$curyear; -%my $smonth = $cgi->param('start_month'); # || $curmon+1; -% -%#find last month -%my $eyear = $cgi->param('end_year'); # || 1900+$curyear; -%my $emonth = $cgi->param('end_month'); # || $curmon+1; -% -%#XXX or virtual -%my( $agentnum, $agent ) = ('', ''); -%if ( $cgi->param('agentnum') =~ /^(\d+)$/ ) { -% $agentnum = $1; -% $agent = qsearchs('agent', { 'agentnum' => $agentnum } ); -% die "agentnum $agentnum not found!" unless $agent; -%} -%my $agentname = $agent ? $agent->agent.' ' : ''; -% -%my @items = qw( invoiced netsales credits payments receipts ); -%if ( $cgi->param('12mo') == 1 ) { -% @items = map $_.'_12mo', @items; -%} -% -%my %label = ( -% 'invoiced' => 'Gross Sales', -% 'netsales' => 'Net Sales', -% 'credits' => 'Credits', -% 'payments' => 'Gross Receipts', -% 'receipts' => 'Net Receipts', -%); -% -%my %graph_suffix = ( -% 'invoiced' => ' (invoiced)', -% 'netsales' => ' (invoiced - applied credits)', -% 'credits' => '', -% 'payments' => ' (payments)', -% 'receipts' => '/Cashflow (payments - refunds)', -%); -%my %graph_label = map { $_ => $label{$_}.$graph_suffix{$_} } keys %label; -% -%$label{$_.'_12mo'} = $label{$_}. " (previous 12 months)" -% foreach keys %label; -% -%$graph_label{$_.'_12mo'} = $graph_label{$_}. " (previous 12 months)" -% foreach keys %graph_label; -% -%my %color = ( -% 'invoiced' => '9999ff', #light blue -% 'netsales' => '0000cc', #blue -% 'credits' => 'cc0000', #red -% 'payments' => '99cc99', #light green -% 'receipts' => '00cc00', #green -%); -%$color{$_.'_12mo'} = $color{$_} -% foreach keys %color; -% -%my %link = ( -% 'invoiced' => "${p}search/cust_bill.html?agentnum=$agentnum;", -% 'credits' => "${p}search/cust_credit.html?agentnum=$agentnum;", -% 'payments' => "${p}search/cust_pay.cgi?magic=_date;agentnum=$agentnum;", -%); -%# XXX link 12mo? -% -% <% include('elements/monthly.html', 'title' => $agentname. 'Sales, Credits and Receipts Summary', @@ -79,3 +14,72 @@ 'nototal' => scalar($cgi->param('12mo')), ) %> +<%init> + +die "access denied" + unless $FS::CurrentUser::CurrentUser->access_right('Financial reports'); + +#find first month +my $syear = $cgi->param('start_year'); # || 1899+$curyear; +my $smonth = $cgi->param('start_month'); # || $curmon+1; + +#find last month +my $eyear = $cgi->param('end_year'); # || 1900+$curyear; +my $emonth = $cgi->param('end_month'); # || $curmon+1; + +#XXX or virtual +my( $agentnum, $agent ) = ('', ''); +if ( $cgi->param('agentnum') =~ /^(\d+)$/ ) { + $agentnum = $1; + $agent = qsearchs('agent', { 'agentnum' => $agentnum } ); + die "agentnum $agentnum not found!" unless $agent; +} + +my $agentname = $agent ? $agent->agent.' ' : ''; + +my @items = qw( invoiced netsales credits payments receipts ); +if ( $cgi->param('12mo') == 1 ) { + @items = map $_.'_12mo', @items; +} + +my %label = ( + 'invoiced' => 'Gross Sales', + 'netsales' => 'Net Sales', + 'credits' => 'Credits', + 'payments' => 'Gross Receipts', + 'receipts' => 'Net Receipts', +); + +my %graph_suffix = ( + 'invoiced' => ' (invoiced)', + 'netsales' => ' (invoiced - applied credits)', + 'credits' => '', + 'payments' => ' (payments)', + 'receipts' => '/Cashflow (payments - refunds)', +); +my %graph_label = map { $_ => $label{$_}.$graph_suffix{$_} } keys %label; + +$label{$_.'_12mo'} = $label{$_}. " (previous 12 months)" + foreach keys %label; + +$graph_label{$_.'_12mo'} = $graph_label{$_}. " (previous 12 months)" + foreach keys %graph_label; + +my %color = ( + 'invoiced' => '9999ff', #light blue + 'netsales' => '0000cc', #blue + 'credits' => 'cc0000', #red + 'payments' => '99cc99', #light green + 'receipts' => '00cc00', #green +); +$color{$_.'_12mo'} = $color{$_} + foreach keys %color; + +my %link = ( + 'invoiced' => "${p}search/cust_bill.html?agentnum=$agentnum;", + 'credits' => "${p}search/cust_credit.html?agentnum=$agentnum;", + 'payments' => "${p}search/cust_pay.cgi?magic=_date;agentnum=$agentnum;", +); +# XXX link 12mo? + +