1 %my $conf = new FS::Conf;
3 %my @svc_external = ();
4 %my @h_svc_external = ();
5 %my $sortby=\*svcnum_sort;
6 %if ( $cgi->param('magic') =~ /^(all|unlinked)$/ ) {
8 % @svc_external=qsearch('svc_external',{});
10 % if ( $cgi->param('magic') eq 'unlinked' ) {
11 % @svc_external = grep { qsearchs('cust_svc', {
12 % 'svcnum' => $_->svcnum,
20 % if ( $cgi->param('sortby') =~ /^(\w+)$/ ) {
22 % if ( $sortby eq 'id' ) {
23 % $sortby = \*id_sort;
27 %} elsif ( $cgi->param('svcpart') =~ /^(\d+)$/ ) {
30 % qsearch( 'svc_external', {}, '',
31 % " WHERE $1 = ( SELECT svcpart FROM cust_svc ".
32 % " WHERE cust_svc.svcnum = svc_external.svcnum ) "
35 %} elsif ( $cgi->param('title') =~ /^(.*)$/ ) {
37 % @svc_external=qsearch('svc_external',{ title => $1 });
38 % if( $cgi->param('history') == 1 ) {
39 % @h_svc_external=qsearch('h_svc_external',{ title => $1 });
41 %} elsif ( $cgi->param('id') =~ /^([\w\-\.]+)$/ ) {
43 % @svc_external = qsearchs('svc_external',{'id'=>$id});
46 %if ( scalar(@svc_external) == 1 ) {
49 <% $cgi->redirect(popurl(2). "view/svc_external.cgi?". $svc_external[0]->svcnum) %>
52 %} elsif ( scalar(@svc_external) == 0 ) {
55 <% include('/elements/header.html', 'External Search Results' ) %>
57 No matching external services found
61 <% include('/elements/header.html', 'External Search Results', '') %>
63 <% scalar(@svc_external) %> matching external services found
64 <TABLE BORDER=4 CELLSPACING=0 CELLPADDING=0>
67 <TH><% FS::Msgcat::_gettext('svc_external-id') || 'External ID' %></TH>
68 <TH><% FS::Msgcat::_gettext('svc_external-title') || 'Title' %></TH>
71 % foreach my $svc_external (
72 % sort $sortby (@svc_external)
74 % my($svcnum, $id, $title)=(
75 % $svc_external->svcnum,
77 % $svc_external->title,
84 % <TD ROWSPAN=$rowspan><A HREF="${p}view/svc_external.cgi?$svcnum">$svcnum</A></TD>
85 % <TD ROWSPAN=$rowspan><A HREF="${p}view/svc_external.cgi?$svcnum">$id</A></TD>
86 % <TD ROWSPAN=$rowspan><A HREF="${p}view/svc_external.cgi?$svcnum">$title</A></TD>
93 % if( scalar(@h_svc_external) > 0 ) {
96 % <TABLE BORDER=4 CELLSPACING=0 CELLPADDING=0>
98 % <TH>Freeside ID</TH>
105 % foreach my $h_svc ( @h_svc_external ) {
106 % my($svcnum, $id, $title, $user, $date)=(
110 % $h_svc->history_user,
111 % $h_svc->history_date,
114 % my ($h_cust_svc) = qsearchs( 'h_cust_svc', {
117 % my $cust_pkg = qsearchs( 'cust_pkg', {
118 % pkgnum => $h_cust_svc->pkgnum,
120 % my $custnum = $cust_pkg->custnum;
124 % <TD ROWSPAN=$rowspan><A HREF="${p}view/cust_main.cgi?$custnum">$custnum</A></TD>
125 % <TD ROWSPAN=$rowspan><A HREF="${p}view/cust_main.cgi?$custnum">$svcnum</A></TD>
126 % <TD ROWSPAN=$rowspan><A HREF="${p}view/cust_main.cgi?$custnum">$title</A></TD>
127 % <TD ROWSPAN=$rowspan><A HREF="${p}view/cust_main.cgi?$custnum">$date</A></TD>
142 % $a->getfield('svcnum') <=> $b->getfield('svcnum');
146 % $a->getfield('id') <=> $b->getfield('id');