+<& elements/search.html,
+ title => 'Contacts',
+ name_singular => 'contact',
+ query => { select => $select,
+ table => 'contact',
+ addl_from => $addl_from,
+ hashref => \%hash,
+ extra_sql => $extra_sql,
+ },
+ count_query => "SELECT COUNT(*) FROM contact $extra_sql", #XXX
+ 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' ) {
+ $hash{'selfservice_access'} = 'Y';
+}
+
+my $extra_sql = '';
+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;
+
+</%init>