1 <% include('elements/monthly.html',
2 'title' => $title. 'Rated Call Sales Report (Gross)',
3 'graph_type' => 'Mountain',
7 'graph_labels' => \@labels,
11 'agentnum' => $agentnum,
17 unless $FS::CurrentUser::CurrentUser->access_right('Financial reports');
20 my( $agentnum, $sel_agent ) = ('', '');
21 if ( $cgi->param('agentnum') =~ /^(\d+)$/ ) {
23 $sel_agent = qsearchs('agent', { 'agentnum' => $agentnum } );
24 die "agentnum $agentnum not found!" unless $sel_agent;
26 my $title = $sel_agent ? $sel_agent->agent.' ' : '';
28 #false lazinessish w/FS::cust_pkg::search_sql (previously search/cust_pkg.cgi)
30 if ( $cgi->param('classnum') =~ /^(\d*)$/ ) {
33 if ( $classnum ) { #a specific class
35 my $pkg_class = ( qsearchs('pkg_class', { 'classnum' => $classnum } ) );
36 die "classnum $classnum not found!" unless $pkg_class;
37 $title .= $pkg_class->classname.' ';
39 } elsif ( $classnum eq '' ) { #the empty class
41 $title .= 'Empty class ';
42 # FS::Report::Table::Monthly.pm has the converse view
45 } elsif ( $classnum eq '0' ) { #all classes
47 # FS::Report::Table::Monthly.pm has the converse view
54 $use_override = 1 if ( $cgi->param('use_override') );
58 if ( $cgi->param('usageclass') =~ /^(\d*)$/ ) {
61 if ( $usageclass ) { #a specific class
63 @usage_class = ( qsearchs('usage_class', { 'classnum' => $usageclass } ) );
64 die "usage class $usageclass not found!" unless $usage_class[0];
65 $title .= $usage_class[0]->classname.' ';
67 } elsif ( $usageclass eq '' ) { #the empty class -- legacy
69 $title .= 'Empty usage class ';
70 @usage_class = ( '(empty usage class)' );
72 } elsif ( $usageclass eq '0' ) { #all classes
74 @usage_class = qsearch('usage_class', {} ); # { 'disabled' => '' } );
75 push @usage_class, '(empty usage class)';
82 #my $hue_increment = 170;
83 #my $hue_increment = 145;
84 my $hue_increment = 125;
91 foreach my $agent ( $sel_agent || qsearch('agent', { 'disabled' => '' } ) ) {
93 my $col_scheme = Color::Scheme->new
94 ->from_hue($hue) #->from_hex($agent->color)
97 my @recur_colors = ();
98 my @onetime_colors = ();
100 ### fixup the color handling for usage classes...
103 foreach my $usage_class ( @usage_class ) {
105 push @items, 'cust_bill_pkg_detail';
108 ( $sel_agent ? '' : $agent->agent.' ' ).
110 ? ( ref($usage_class) ? $usage_class->classname : $usage_class )
114 my $row_classnum = ref($usage_class) ? $usage_class->classnum : 0;
115 my $row_agentnum = $agent->agentnum;
116 push @params, [ 'usageclass' => $row_classnum,
117 'agentnum' => $row_agentnum,
118 'use_override' => $use_override,
119 'classnum' => $classnum,
122 @recur_colors = ($col_scheme->colors)[0,4,8,1,5,9]
123 unless @recur_colors;
124 @onetime_colors = ($col_scheme->colors)[2,6,10,3,7,11]
125 unless @onetime_colors;
126 push @colors, shift @recur_colors;
130 $hue += $hue_increment;
135 #warn Dumper(\@items);