1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
|
<& 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 $as = ') AS prospect_or_customer';
if ( $cgi->param('link') eq 'cust_main' ) {
push @header, 'Customer';
$select .=
", COALESCE( cust_main.company, 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( prospect_main.company, 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>
|
