3 my $conf = new FS::Conf;
5 my($query)=$cgi->keywords;
6 $query ||= ''; #to avoid use of unitialized value errors
7 my(@svc_external,$sortby);
8 if ( $query eq 'svcnum' ) {
10 @svc_external=qsearch('svc_external',{});
11 } elsif ( $query eq 'id' ) {
13 @svc_external=qsearch('svc_external',{});
14 } elsif ( $query eq 'UN_svcnum' ) {
15 $sortby=\*svcnum_sort;
16 @svc_external = grep qsearchs('cust_svc',{
17 'svcnum' => $_->svcnum,
19 }), qsearch('svc_external',{});
20 } elsif ( $query eq 'UN_id' ) {
22 @svc_external = grep qsearchs('cust_svc',{
23 'svcnum' => $_->svcnum,
25 }), qsearch('svc_external',{});
26 } elsif ( $cgi->param('svcpart') =~ /^(\d+)$/ ) {
28 qsearch( 'svc_external', {}, '',
29 " WHERE $1 = ( SELECT svcpart FROM cust_svc ".
30 " WHERE cust_svc.svcnum = svc_external.svcnum ) "
32 $sortby=\*svcnum_sort;
34 $cgi->param('id') =~ /^([\w\-\.]+)$/;
36 #push @svc_domain, qsearchs('svc_domain',{'domain'=>$domain});
37 @svc_external = qsearchs('svc_external',{'id'=>$id});
40 if ( scalar(@svc_external) == 1 ) {
41 print $cgi->redirect(popurl(2). "view/svc_external.cgi?". $svc_external[0]->svcnum);
43 } elsif ( scalar(@svc_external) == 0 ) {
47 eidiot "No matching external services found!\n";
51 <%= header("External Search Results",'') %>
53 <%= scalar(@svc_external) %> matching external services found
54 <TABLE BORDER=4 CELLSPACING=0 CELLPADDING=0>
57 <TH><%= FS::Msgcat::_gettext('svc_external-id') || 'External ID' %></TH>
58 <TH><%= FS::Msgcat::_gettext('svc_external-title') || 'Title' %></TH>
62 foreach my $svc_external (
63 sort $sortby (@svc_external)
65 my($svcnum, $id, $title)=(
66 $svc_external->svcnum,
75 <TD ROWSPAN=$rowspan><A HREF="${p}view/svc_external.cgi?$svcnum">$svcnum</A></TD>
76 <TD ROWSPAN=$rowspan><A HREF="${p}view/svc_external.cgi?$svcnum">$id</A></TD>
77 <TD ROWSPAN=$rowspan><A HREF="${p}view/svc_external.cgi?$svcnum">$title</A></TD>
94 $a->getfield('svcnum') <=> $b->getfield('svcnum');
98 $a->getfield('id') <=> $b->getfield('id');