X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Fsearch%2Fsvc_acct.cgi;h=0954bf65224993a8db78e639521cbea944ced5b4;hp=0a4338b529d26123f88cf1e995c80ba14322e7f0;hb=71eb3c33da045ffdc963b5ad8111af8a8bef878d;hpb=c9b608b9c0df8921d30055f18c23fd2d030afb25
diff --git a/httemplate/search/svc_acct.cgi b/httemplate/search/svc_acct.cgi
index 0a4338b52..0954bf652 100755
--- a/httemplate/search/svc_acct.cgi
+++ b/httemplate/search/svc_acct.cgi
@@ -1,7 +1,5 @@
<%
-my $mydomain = '';
-
my $conf = new FS::Conf;
my $maxrecords = $conf->config('maxsearchrecordsperpage');
@@ -32,7 +30,7 @@ if ( $query =~ /^UN_(.*)$/ ) {
WHERE 0 <
( SELECT count(*) FROM cust_svc
WHERE cust_svc.svcnum = svc_acct.svcnum
- AND ( pkgnum IS NULL OR pkgnum = 0 OR pkgnum = $empty )
+ AND ( pkgnum IS NULL OR pkgnum = 0 )
)
";
}
@@ -50,12 +48,23 @@ if ( $query eq 'svcnum' ) {
$sortby=\*uid_sort;
$orderby = ( $unlinked ? 'AND' : 'WHERE' ).
" ${tblname}uid IS NOT NULL ORDER BY ${tblname}uid";
+} elsif ( $query =~ /popnum=(\d+)/ ) {
+ my $popnum = $1;
+ $unlinked .= ( $unlinked ? 'AND' : 'WHERE' ).
+ " popnum = $popnum";
+ $sortby=\*username_sort;
+ $orderby = "ORDER BY ${tblname}username";
} else {
$sortby=\*uid_sort;
@svc_acct = @{&usernamesearch};
}
-if ( $query eq 'svcnum' || $query eq 'username' || $query eq 'uid' ) {
+
+if ( $query eq 'svcnum'
+ || $query eq 'username'
+ || $query eq 'uid'
+ || $query eq 'popnum'
+ ) {
my $statement = "SELECT COUNT(*) FROM svc_acct $unlinked";
my $sth = dbh->prepare($statement)
@@ -147,14 +156,8 @@ END
$domain = "svcnum.
"\">". $svc_domain->domain. "";
} else {
- unless ( $mydomain ) {
- my $conf = new FS::Conf;
- unless ( $mydomain = $conf->config('domain') ) {
- die "No legacy domain config file and no svc_domain.svcnum record ".
- "for svc_acct.domsvc: ". $svc_acct->domsvc;
- }
- }
- $domain = "$mydomain*";
+ die "No svc_domain.svcnum record for svc_acct.domsvc: ".
+ $svc_acct->domsvc;
}
my($cust_pkg,$cust_main);
if ( $cust_svc->pkgnum ) {
@@ -216,17 +219,8 @@ END
}
- print "$pager
";
-
- if ( $mydomain ) {
- print "
* The $mydomain domain ".
- "is contained in your legacy domain
".
- "configuration file. ".
- "You should run the bin/fs-migrate-svc_acct_sm
script ".
- "to create a proper svc_domain record for this domain.";
- }
-
- print '