X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;ds=sidebyside;f=httemplate%2Fsearch%2Fsvc_domain.cgi;h=948b1d9ae1f376c40fddfbe0c66ee6a413641937;hb=fc1979c359ec54f2270f09480a9064e7b68019fe;hp=60f1f8c81aaf2e4abb1201b0fd6535a67f2110aa;hpb=c1e33a61324f4e06157c522af7882a97a021830f;p=freeside.git
diff --git a/httemplate/search/svc_domain.cgi b/httemplate/search/svc_domain.cgi
index 60f1f8c81..948b1d9ae 100755
--- a/httemplate/search/svc_domain.cgi
+++ b/httemplate/search/svc_domain.cgi
@@ -23,6 +23,13 @@ if ( $query eq 'svcnum' ) {
'svcnum' => $_->svcnum,
'pkgnum' => '',
}), qsearch('svc_domain',{});
+} elsif ( $cgi->param('svcpart') =~ /^(\d+)$/ ) {
+ @svc_domain =
+ qsearch( 'svc_domain', {}, '',
+ " WHERE $1 = ( SELECT svcpart FROM cust_svc ".
+ " WHERE cust_svc.svcnum = svc_domain.svcnum ) "
+ );
+ $sortby=\*svcnum_sort;
} else {
$cgi->param('domain') =~ /^([\w\-\.]+)$/;
my($domain)=$1;
@@ -50,8 +57,9 @@ if ( scalar(@svc_domain) == 1 ) {
Service # |
Domain |
- Mail to (click to view account) |
+
END
@@ -67,65 +75,68 @@ END
$svc_domain->domain,
);
- my @svc_acct=qsearch('svc_acct',{'domsvc' => $svcnum});
- my $rowspan = 0;
-
- my $n1 = '';
- my($svc_acct, @rows);
- foreach $svc_acct (
- sort {$b->getfield('username') cmp $a->getfield('username')} (@svc_acct)
- ) {
-
- my (@forwards) = ();
-
- my($svcnum,$username)=(
- $svc_acct->svcnum,
- $svc_acct->username,
- );
-
- my @svc_forward = qsearch( 'svc_forward', { 'srcsvc' => $svcnum } );
- my $svc_forward;
- foreach $svc_forward (@svc_forward) {
- my($dstsvc,$dst) = (
- $svc_forward->dstsvc,
- $svc_forward->dst,
- );
- if ($dstsvc) {
- my $dst_svc_acct=qsearchs( 'svc_acct', { 'svcnum' => $dstsvc } );
- my $destination=$dst_svc_acct->email;
- push @forwards, qq!$destination!,
- qq! | !
- ;
- }else{
- push @forwards, qq!$dst | !
- ;
- }
- }
-
- push @rows, qq!$n1!,
- #print '', ( ($domuser eq '*') ? "(anything)" : $domuser );
- ( ($username eq '*') ? "(anything)" : $username ),
- qq!\@$domain | !,
- ;
-
- push @rows, @forwards;
-
- $rowspan += (scalar(@svc_forward) || 1);
- $n1 = "";
- }
- #end of false laziness
-
-
+ #don't display all accounts here
+ my $rowspan = 1;
+
+ #my @svc_acct=qsearch('svc_acct',{'domsvc' => $svcnum});
+ #my $rowspan = 0;
+ #
+ #my $n1 = '';
+ #my($svc_acct, @rows);
+ #foreach $svc_acct (
+ # sort {$b->getfield('username') cmp $a->getfield('username')} (@svc_acct)
+ #) {
+ #
+ # my (@forwards) = ();
+ #
+ # my($svcnum,$username)=(
+ # $svc_acct->svcnum,
+ # $svc_acct->username,
+ # );
+ #
+ # my @svc_forward = qsearch( 'svc_forward', { 'srcsvc' => $svcnum } );
+ # my $svc_forward;
+ # foreach $svc_forward (@svc_forward) {
+ # my($dstsvc,$dst) = (
+ # $svc_forward->dstsvc,
+ # $svc_forward->dst,
+ # );
+ # if ($dstsvc) {
+ # my $dst_svc_acct=qsearchs( 'svc_acct', { 'svcnum' => $dstsvc } );
+ # my $destination=$dst_svc_acct->email;
+ # push @forwards, qq!$destination!,
+ # qq! |
!
+ # ;
+ # }else{
+ # push @forwards, qq!$dst | !
+ # ;
+ # }
+ # }
+ #
+ # push @rows, qq!$n1!,
+ # #print '', ( ($domuser eq '*') ? "(anything)" : $domuser );
+ # ( ($username eq '*') ? "(anything)" : $username ),
+ # qq!\@$domain | !,
+ # ;
+ #
+ # push @rows, @forwards;
+ #
+ # $rowspan += (scalar(@svc_forward) || 1);
+ # $n1 = "";
+ #}
+ ##end of false laziness
+ #
+ #
print <
- $svcnum |
- $domain |
+ $svcnum |
+ $domain |
END
- print @rows;
+ #print @rows;
print "
";
}