X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2FUI%2FWeb.pm;h=4bbe4671e460b287eb058b0ff79302e937c5fa75;hb=5b9562f8e03ae6efea0c2eaa90341083744fa529;hp=6cc04b9ded61f547d4ce735f5049725879d55467;hpb=63bef94c6f244d4569d969fd03e0a32e680d563e;p=freeside.git diff --git a/FS/FS/UI/Web.pm b/FS/FS/UI/Web.pm index 6cc04b9de..4bbe4671e 100644 --- a/FS/FS/UI/Web.pm +++ b/FS/FS/UI/Web.pm @@ -7,7 +7,7 @@ use Carp qw( confess ); use HTML::Entities; use FS::Conf; use FS::Misc::DateTime qw( parse_datetime day_end ); -use FS::Record qw(dbdef); +use FS::Record qw(dbdef qsearch); use FS::cust_main; # are sql_balance and sql_date_balance in the right module? #use vars qw(@ISA); @@ -354,6 +354,24 @@ sub cust_header { $header2method{'Cust#'} = 'display_custnum' if $conf->exists('cust_main-default_agent_custid'); +foreach my $phone_type ( FS::phone_type->get_phone_types() ) { + $header2method{'Contact '.$phone_type->typename.' phone(s)'} = sub { + my $self = shift; + my $num = $phone_type->phonetypenum; + + my @phones; + foreach ($self->contact_list_name_phones) { + my $data = [ + { + 'data' => $_->first.' '.$_->last.' '.FS::contact_phone::phonenum_pretty($_), + }, + ]; + push @phones, $data if $_->phonetypenum eq $phone_type->phonetypenum; + } + return \@phones; + }; +} + my %header2colormethod = ( 'Cust. Status' => 'cust_statuscolor', ); @@ -411,7 +429,14 @@ sub cust_sort_fields { cust_header(@_) if( @_ or !@cust_fields ); #inefficientish, but tiny lists and only run once per page - map { $_ eq 'custnum' ? 'custnum' : '' } @cust_fields; + my @sort_fields; + foreach (@cust_fields) { + if ($_ eq "custnum") { push @sort_fields, 'custnum'; } + elsif ($_ eq "contact" || $_ eq "name") { push @sort_fields, '(last, first)'; } + elsif ($_ eq "company") { push @sort_fields, 'company'; } + else { push @sort_fields, ''; } + } + return @sort_fields; } @@ -468,9 +493,9 @@ sub cust_sql_fields { =item join_cust_main [ TABLE[.CUSTNUM] ] [ LOCATION_TABLE[.LOCATIONNUM] ] Returns an SQL join phrase for the FROM clause so that the fields listed -in L will be available. Currently joins to cust_main +in L will be available. Currently joins to cust_main itself, as well as cust_location (under the aliases 'bill_location' and -'ship_location') if address fields are needed. L should have +'ship_location') if address fields are needed. L should have been called already. All of these will be left joins; if you want to exclude rows with no linked @@ -743,6 +768,7 @@ use FS::CurrentUser; use FS::Record qw(qsearchs); use FS::queue; use FS::CGI qw(rooturl); +use FS::Report::Queued::FutureAutobill; $DEBUG = 0;