X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Fsearch%2Fsvc_domain.cgi;h=948b1d9ae1f376c40fddfbe0c66ee6a413641937;hp=c397714e5e3b43b2cbb21219699bc4fca3d66eab;hb=5d154e4e153a66c2349ee0c6ca942fa017bfb139;hpb=38198ddef5f92e95ae3f0a151759931400a6ad44 diff --git a/httemplate/search/svc_domain.cgi b/httemplate/search/svc_domain.cgi index c397714e5..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; @@ -125,8 +132,8 @@ END print < - $svcnum - $domain + $svcnum + $domain END #print @rows;