=cut
+
sub cust_fields {
my $record = shift;
warn "FS::UI::Web::cust_fields called for $record ".
#cust_header(@_) unless @cust_fields; #now need to cache to keep cust_fields
# #override incase we were passed as a sub
-
+
my $seen_unlinked = 0;
+
map {
if ( $record->custnum ) {
warn " $record -> $_" if $DEBUG > 1;
} @cust_fields;
}
+=item cust_fields_subs
+
+Returns an array of subroutine references for returning customer field values.
+This is similar to cust_fields, but returns each field's sub as a distinct
+element.
+
+=cut
+
+sub cust_fields_subs {
+ my $unlinked_warn = 0;
+ return map {
+ my $f = $_;
+ if( $unlinked_warn++ ) {
+ sub {
+ my $record = shift;
+ if( $record->custnum ) {
+ $record->$f(@_);
+ }
+ else {
+ '(unlinked)'
+ };
+ }
+ }
+ else {
+ sub {
+ my $record = shift;
+ $record->$f(@_) if $record->custnum;
+ }
+ }
+ } @cust_fields;
+}
+
=item cust_colors
Returns an array of subroutine references (or empty strings) for returning
'name' => 'customers',
'query' => $sql_query,
'count_query' => $count_sql,
- 'header' => [
+ 'header' => [
FS::UI::Web::cust_header(),
+ @pay_head,
'0-30',
'30-60',
'60-90',
( map '',
( 1 ..
scalar(FS::UI::Web::cust_header()-1)
- )
+ ), @pay_labels
),
+
sprintf( $money_char.'%.2f',
$row->{'rangecol_0_30'} ),
sprintf( $money_char.'%.2f',
$row->{'rangecol_0_0'} ),
],
'fields' => [
- \&FS::UI::Web::cust_fields,
+ FS::UI::Web::cust_fields_subs(),
+ @pay_labels,
format_rangecol('0_30'),
format_rangecol('30_60'),
format_rangecol('60_90'),
( map { $_ ne 'Cust. Status' ? $clink : '' }
FS::UI::Web::cust_header()
),
+ @pay_links,
'',
'',
'',
#'size' => [ '', '', '-1', '-1', '', '', '', '', '', ],
#'style' => [ '', '', 'b', 'b', '', '', '', '', 'b', ],
'size' => [ ( map '', FS::UI::Web::cust_header() ),
+ ( map '', @pay_labels ),
#'-1', '', '', '', '', '', ],
- '', '', '', '', '', ],
+ '', '', '', '', '', '', ],
'style' => [ FS::UI::Web::cust_styles(),
+ ( map '', @pay_labels ),
#'b', '', '', '', '', 'b', ],
'', '', '', '', 'b', ],
'color' => [
FS::UI::Web::cust_colors(),
+ ( map '', @pay_labels ),
+ '',
'',
'',
'',
$range_cols,
$packages_cols,
FS::UI::Web::cust_sql_fields(),
+ 'payby',
),
'extra_sql' => $where,
'order_by' => "order by coalesce(lower(company), ''), lower(last)",
my $clink = [ "${p}view/cust_main.cgi?", 'custnum' ];
+my (@pay_head, @pay_labels, @pay_links);
+
+if($opt{'payment_links'} && $curuser->access_right('Process payment')) {
+ @pay_head = ({ label => 'Process', nodownload => 1, colspan => 2 },
+ { nodownload => 1 });
+
+ @pay_labels = (map { my ($payby,$label) = @$_;
+ sub {($payby eq $_[0]->payby) ? "<b>$label</b>" : $label}
+ } ([CARD => 'Card'], [CHEK => 'ACH']) );
+
+ @pay_links = (map { [ "${p}misc/payment.cgi?payby=$_;custnum=", 'custnum' ] }
+ 'CARD', 'CHEK' );
+}
+
</%init>
<%once>
my $conf = new FS::Conf;
+my $curuser = $FS::CurrentUser::CurrentUser;
my $money_char = $conf->config('money_char') || '$';
my $curuser = $FS::CurrentUser::CurrentUser;
+my $type = $cgi->param('_type') =~ /^(csv|\w*\.xls|select|html(-print)?)$/
+ ? $1 : 'html' ;
+
my %align = (
'l' => 'left',
'r' => 'right',
$opt{align} = [ map $align{$_}, split(//, $opt{align}) ],
unless !$opt{align} || ref($opt{align});
+if($type =~ /csv|xls/) {
+ my $h = $opt{'header'};
+ my @del;
+ my $i = 0;
+ do {
+ if( ref($h->[$i]) and exists($h->[$i]->{'nodownload'}) ) {
+ splice(@{$opt{$_}}, $i, 1) foreach
+ qw(header footer fields links link_onclicks
+ align color size style cell_style xls_format);
+ }
+ else {
+ $i++;
+ }
+ } while ( exists($h->[$i]) );
+}
+
$opt{disable_download} = 0
if $opt{disable_download} && $curuser->access_right('Configuration download');
if ( $cgi->param('showdisabled') ) {
$cgi->param('showdisabled', 0);
$opt{'html_posttotal'} .=
- '( <a href="'. $cgi->self_url. qq!">hide disabled $items</a> )!;
+ '( <a href="'. $cgi->self_url. qq!">hide disabled $items</a> )!; #"
$cgi->param('showdisabled', 1);
} else {
$cgi->param('showdisabled', 1);
$opt{'html_posttotal'} .=
- '( <a href="'. $cgi->self_url. qq!">show disabled $items</a> )!;
+ '( <a href="'. $cgi->self_url. qq!">show disabled $items</a> )!; #"
$cgi->param('showdisabled', 0);
}
}
-my $type = $cgi->param('_type') =~ /^(csv|\w*\.xls|select|html(-print)?)$/
- ? $1 : 'html';
-
my $limit = '';
my($confmax, $maxrecords, $offset );
-unless ( $type =~ /^(csv|\w*\.xls)$/ ) {
-
+if ( !$type =~ /^(csv|\w*.xls)$/) {
+# html mode
unless (exists($opt{count_query}) && length($opt{count_query})) {
( $opt{count_query} = $opt{query} ) =~
s/^\s*SELECT\s*(.*?)\s+FROM\s/SELECT COUNT(*) FROM /i; #silly vim:/