fix contact self-service disabled on edit (and some basic contact reports), RT#25533...

[freeside.git] / httemplate / search / contact.html

diff --git a/httemplate/search/contact.html b/httemplate/search/contact.html
index 0292fa5..1933493 100644 (file)
--- a/httemplate/search/contact.html
+++ b/httemplate/search/contact.html
@@ -8,16 +8,23 @@
                      extra_sql => $extra_sql,
                    },
   count_query   => "SELECT COUNT(*) FROM contact $extra_sql", #XXX
-  header        => [ 'First', 'Last', 'Title', 'Company', 'Self-service', ],
-  fields        => [ 'first', 'last', 'title', 'company', 'selfservice_access' ],
-  links         => [ '', '', '', $company_link, '', ],
+  header        => \@header,
+  fields        => \@fields,
+  links         => \@links,
 &>
 <%init>
 
+die "access denied"
+  unless $FS::CurrentUser::CurrentUser->access_right('List contacts');
+
 my $select = 'contact.*';
 my %hash = ();
 my $addl_from = '';
 
+my @header = ( 'First', 'Last', 'Title', );
+my @fields = ( 'first', 'last', 'title', );
+my @links = ( '', '', '' );
+
 my $company_link = '';
 
 if ( $cgi->param('selfservice_access') eq 'Y' ) {
@@ -25,18 +32,36 @@ if ( $cgi->param('selfservice_access') eq 'Y' ) {
 }
 
 my $extra_sql = '';
-if ( $cgi->param('cust_main') ) {
-  $select .= ', cust_main.company';
-  $addl_from = ' LEFT JOIN cust_main USING ( custnum )';
-  $extra_sql = ' custnum IS NOT NULL ';
-  $company_link  = [ $p.'view/cust_main.cgi?', 'custnum' ];
-} elsif ( $cgi->param('prospect_main') ) {
-  $select .= ', prospect_main.company';
-  $addl_from = ' LEFT JOIN prospect_main USING ( prospectnum )';
-  $extra_sql = ' prospectnum IS NOT NULL ';
-  $company_link  = [ $p.'view/prospect_main.html?', 'prospectnum' ];
+if ( $cgi->param('link') ) {
+
+  my $coalesce = ', COALESCE( cust_main.company,';
+  my $as       = ') AS prospect_or_customer';
+
+  if ( $cgi->param('link') eq 'cust_main' ) {
+    push @header, 'Customer';
+    $select .= "$coalesce cust_main.first||' '||cust_main.last $as";
+    $addl_from = ' LEFT JOIN cust_main USING ( custnum )';
+    $extra_sql = ' custnum IS NOT NULL ';
+    $company_link  = [ $p.'view/cust_main.cgi?', 'custnum' ];
+  } elsif ( $cgi->param('link') eq 'prospect_main' ) {
+    push @header, 'Prospect';
+    $select .= "$coalesce contact.first||'  '||contact.last $as";
+    $addl_from = ' LEFT JOIN prospect_main USING ( prospectnum )';
+    $extra_sql = ' prospectnum IS NOT NULL ';
+    $company_link  = [ $p.'view/prospect_main.html?', 'prospectnum' ];
+  } else {
+    die "don't know how to report on contacts linked to specified table";
+  }
+
+  #because right now its harder to show it for both kinds of contacts
+  push @fields, 'prospect_or_customer';
+  push @links, $company_link; 
+
 }
 
+push @header, 'Self-service';
+push @fields, 'selfservice_access';
+
 $extra_sql = (keys(%hash) ? ' AND ' : ' WHERE '). $extra_sql
  if $extra_sql;