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
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
|
<% include( 'elements/search.html',
'title' => 'Service search results',
'name' => 'services',
'query' => $sql_query,
'count_query' => $count_query,
'redirect' => $link,
'header' => [ '#',
'Service',
# package?
FS::UI::Web::cust_header(),
],
'fields' => [ 'svcnum',
sub {
#$_[0]->svc. ': '. $_[0]->label;
my($label, $value, $svcdb) = $_[0]->label;
"$label: $value";
},
# package?
\&FS::UI::Web::cust_fields,
],
'links' => [ $link,
$link,
# package?
( map { $link_cust }
FS::UI::Web::cust_header()
),
],
)
%>
<%init>
my $addl_from = ' LEFT JOIN part_svc USING ( svcpart ) '.
' LEFT JOIN cust_pkg USING ( pkgnum ) '.
' LEFT JOIN cust_main USING ( custnum ) ';
my @extra_sql = ();
my $orderby = 'ORDER BY svcnum'; #has to be ordered by something
#for pagination to work
if ( length( $cgi->param('search_svc') ) ) {
my $string = $cgi->param('search_svc');
$string =~ s/(^\s+|\s+$)//; #trim leading & trailing whitespace
# implement fuzzy searching in subclasses too at some point?
# service searching maybe shouldn't be fuzzy...
push @extra_sql,
' ( '. join(' OR ',
map { my $table = $_;
my $search_sql = "FS::$table"->search_sql($string);
" ( svcdb = '$table'
AND 0 < ( SELECT COUNT(*) FROM $table
WHERE $table.svcnum = cust_svc.svcnum
AND $search_sql
)
) ";
}
FS::part_svc->svc_tables
). ' ) ';
} elsif ( $cgi->param('magic') =~ /^(all|unlinked)$/ ) {
$cgi->param('svcdb') =~ /^(svc_\w+)$/ or die "unknown svcdb";
push @extra_sql, "svcdb = '$1'";
push @extra_sql, 'pkgnum IS NULL'
if $cgi->param('magic') eq 'unlinked';
if ( $cgi->param('sortby') =~ /^(\w+)$/ ) {
my $sortby = $1;
$orderby = "ORDER BY $sortby";
}
} elsif ( $cgi->param('svcpart') =~ /^(\d+)$/ ) {
push @extra_sql, "svcpart = $1";
} else {
eidiot("No search term specified");
}
#here is the agent virtualization
push @extra_sql, $FS::CurrentUser::CurrentUser->agentnums_sql;
my $extra_sql = ' WHERE '. join(' AND ', @extra_sql );
my $sql_query = {
'select' => join(', ',
'cust_svc.*',
'part_svc.*',
'cust_main.custnum',
FS::UI::Web::cust_sql_fields(),
),
'table' => 'cust_svc',
'addl_from' => $addl_from,
'hashref' => {},
'extra_sql' => "$extra_sql $orderby",
};
my $count_query = "SELECT COUNT(*) FROM cust_svc $addl_from $extra_sql";
my $link = sub {
my $cust_svc = shift;
my $url = FS::UI::Web::svc_url(
'm' => $m,
'action' => 'view',
#'part_svc' => $cust_svc->part_svc,
'svcdb' => $cust_svc->svcdb, #we have it from the joined search
#'svc' => $cust_svc, #redundant
'query' => '',
);
[ $url, 'svcnum' ];
};
my $link_cust = sub {
my $cust_svc = shift;
if ( $cust_svc->custnum ) {
[ "${p}view/cust_main.cgi?", 'custnum' ];
} else {
'';
}
};
</%init>
|
