X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fgraph%2Fmoney_time.cgi;h=4e4157ea101eae9f88b3a1d2d2553286825d6a3b;hb=f360579dd091f1adf9cea1062aa06afdf5bff42b;hp=41b82fa84cccecbb109ff0c3012d2480c32ee92e;hpb=6b74e2e7a98a11b8b4f62a10676ba8b37ee2ef4f;p=freeside.git diff --git a/httemplate/graph/money_time.cgi b/httemplate/graph/money_time.cgi index 41b82fa84..4e4157ea1 100644 --- a/httemplate/graph/money_time.cgi +++ b/httemplate/graph/money_time.cgi @@ -25,48 +25,73 @@ if ( $cgi->param('agentnum') =~ /^(\d+)$/ ) { my $agentname = $agent ? $agent->agent.' ' : ''; -my @items = qw( invoiced netsales credits payments receipts ); +my @items = qw( invoiced netsales + credits netcredits + payments receipts + refunds netrefunds + cashflow netcashflow + ); 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', + 'invoiced' => 'Gross Sales', + 'netsales' => 'Net Sales', + 'credits' => 'Gross Credits', + 'netcredits' => 'Net Credits', + 'payments' => 'Gross Receipts', + 'receipts' => 'Net Receipts', + 'refunds' => 'Gross Refunds', + 'netrefunds' => 'Net Refunds', + 'cashflow' => 'Gross Cashflow', + 'netcashflow' => 'Net Cashflow', ); my %graph_suffix = ( - 'invoiced' => ' (invoiced)', - 'netsales' => ' (invoiced - applied credits)', - 'credits' => '', - 'payments' => ' (payments)', - 'receipts' => '/Cashflow (payments - refunds)', + 'invoiced' => ' (invoiced)', + 'netsales' => ' (invoiced - applied credits)', + 'credits' => ' (credited)', + 'netcredits' => ' (applied credits)', + 'payments' => ' (payments)', + 'receipts' => ' (applied payments)', + 'refunds' => ' (refunds)', + 'netrefunds' => ' (applied refunds)', + 'cashflow' => ' (payments - refunds)', + 'netcashflow' => ' (applied payments - applied refunds)', ); my %graph_label = map { $_ => $label{$_}.$graph_suffix{$_} } keys %label; -$label{$_.'_12mo'} = $label{$_}. " (previous 12 months)" +$label{$_.'_12mo'} = $label{$_}. " (prev 12 months)" foreach keys %label; -$graph_label{$_.'_12mo'} = $graph_label{$_}. " (previous 12 months)" +$graph_label{$_.'_12mo'} = $graph_label{$_}. " (prev 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 + 'invoiced' => '9999ff', #light blue + 'netsales' => '0000cc', #blue + 'credits' => 'ff9999', #light red + 'netcredits' => 'cc0000', #red + 'payments' => '99cc99', #light green + 'receipts' => '00cc00', #green + 'refunds' => 'ffcc99', #light orange + 'netrefunds' => 'ff9900', #orange + 'cashflow' => '99cc33', #light olive + 'netcashflow' => '339900', #olive ); $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;", + 'invoiced' => "${p}search/cust_bill.html?agentnum=$agentnum;", + 'netsales' => "${p}search/cust_bill.html?agentnum=$agentnum;net=1;", + 'credits' => "${p}search/cust_credit.html?agentnum=$agentnum;", + 'netcredits' => "${p}search/cust_credit_bill.html?agentnum=$agentnum;", + 'payments' => "${p}search/cust_pay.cgi?magic=_date;agentnum=$agentnum;", + 'receipts' => "${p}search/cust_bill_pay.html?agentnum=$agentnum;", + 'refunds' => "${p}search/cust_refund.html?magic=_date;agentnum=$agentnum;", + 'netrefunds' => "${p}search/cust_credit_refund.html?agentnum=$agentnum;", ); # XXX link 12mo?