3 my $conf = new FS::Conf;
5 my($query)=$cgi->keywords;
6 $query ||= ''; #to avoid use of unitialized value errors
7 my(@svc_domain,$sortby);
8 if ( $query eq 'svcnum' ) {
10 @svc_domain=qsearch('svc_domain',{});
11 } elsif ( $query eq 'domain' ) {
12 $sortby=\*domain_sort;
13 @svc_domain=qsearch('svc_domain',{});
14 } elsif ( $query eq 'UN_svcnum' ) {
15 $sortby=\*svcnum_sort;
16 @svc_domain = grep qsearchs('cust_svc',{
17 'svcnum' => $_->svcnum,
19 }), qsearch('svc_domain',{});
20 } elsif ( $query eq 'UN_domain' ) {
21 $sortby=\*domain_sort;
22 @svc_domain = grep qsearchs('cust_svc',{
23 'svcnum' => $_->svcnum,
25 }), qsearch('svc_domain',{});
26 } elsif ( $cgi->param('svcpart') =~ /^(\d+)$/ ) {
28 qsearch( 'svc_domain', {}, '',
29 " WHERE $1 = ( SELECT svcpart FROM cust_svc ".
30 " WHERE cust_svc.svcnum = svc_domain.svcnum ) "
32 $sortby=\*svcnum_sort;
34 $cgi->param('domain') =~ /^([\w\-\.]+)$/;
36 #push @svc_domain, qsearchs('svc_domain',{'domain'=>$domain});
37 @svc_domain = qsearchs('svc_domain',{'domain'=>$domain});
40 if ( scalar(@svc_domain) == 1 ) {
41 print $cgi->redirect(popurl(2). "view/svc_domain.cgi?". $svc_domain[0]->svcnum);
43 } elsif ( scalar(@svc_domain) == 0 ) {
47 eidiot "No matching domains found!\n";
52 my($total)=scalar(@svc_domain);
53 print header("Domain Search Results",''), <<END;
55 $total matching domains found
56 <TABLE BORDER=4 CELLSPACING=0 CELLPADDING=0>
60 <!-- <TH>Mail to<BR><FONT SIZE=-1>(click to view account)</FONT></TH>
61 <TH>Forwards to<BR><FONT SIZE=-1>(click to view account)</FONT></TH>
66 # my(%saw); # if we've multiple domains with the same
67 # svcnum, then we've a corrupt database
69 foreach my $svc_domain (
70 # sort $sortby grep(!$saw{$_->svcnum}++, @svc_domain)
71 sort $sortby (@svc_domain)
78 #don't display all accounts here
81 #my @svc_acct=qsearch('svc_acct',{'domsvc' => $svcnum});
85 #my($svc_acct, @rows);
87 # sort {$b->getfield('username') cmp $a->getfield('username')} (@svc_acct)
90 # my (@forwards) = ();
92 # my($svcnum,$username)=(
94 # $svc_acct->username,
97 # my @svc_forward = qsearch( 'svc_forward', { 'srcsvc' => $svcnum } );
99 # foreach $svc_forward (@svc_forward) {
100 # my($dstsvc,$dst) = (
101 # $svc_forward->dstsvc,
105 # my $dst_svc_acct=qsearchs( 'svc_acct', { 'svcnum' => $dstsvc } );
106 # my $destination=$dst_svc_acct->email;
107 # push @forwards, qq!<TD><A HREF="!, popurl(2),
108 # qq!view/svc_acct.cgi?$dstsvc">$destination</A>!,
112 # push @forwards, qq!<TD>$dst</TD></TR>!
117 # push @rows, qq!$n1<TD ROWSPAN=!, (scalar(@svc_forward) || 1),
118 # qq!><A HREF="!. popurl(2). qq!view/svc_acct.cgi?$svcnum">!,
119 # #print '', ( ($domuser eq '*') ? "<I>(anything)</I>" : $domuser );
120 # ( ($username eq '*') ? "<I>(anything)</I>" : $username ),
121 # qq!\@$domain</A> </TD>!,
124 # push @rows, @forwards;
126 # $rowspan += (scalar(@svc_forward) || 1);
129 ##end of false laziness
135 <TD ROWSPAN=$rowspan><A HREF="${p}view/svc_domain.cgi?$svcnum">$svcnum</A></TD>
136 <TD ROWSPAN=$rowspan><A HREF="${p}view/svc_domain.cgi?$svcnum">$domain</A></TD>
153 $a->getfield('svcnum') <=> $b->getfield('svcnum');
157 $a->getfield('domain') cmp $b->getfield('domain');