projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
fix FS::Record::qsearch to (hopefully) work as before and cluck loudly when the FS...
[freeside.git]
/
httemplate
/
search
/
svc_acct.cgi
diff --git
a/httemplate/search/svc_acct.cgi
b/httemplate/search/svc_acct.cgi
index
bbcac30
..
1e4a03d
100755
(executable)
--- a/
httemplate/search/svc_acct.cgi
+++ b/
httemplate/search/svc_acct.cgi
@@
-46,14
+46,19
@@
if ( $query eq 'svcnum' ) {
$orderby = "ORDER BY ${tblname}username";
} elsif ( $query eq 'uid' ) {
$sortby=\*uid_sort;
$orderby = "ORDER BY ${tblname}username";
} elsif ( $query eq 'uid' ) {
$sortby=\*uid_sort;
- $orderby = ( $unlinked ? '
AND' : '
WHERE' ).
+ $orderby = ( $unlinked ? '
AND' : '
WHERE' ).
" ${tblname}uid IS NOT NULL ORDER BY ${tblname}uid";
" ${tblname}uid IS NOT NULL ORDER BY ${tblname}uid";
-} elsif ( $query =~ /^popnum=(\d+)$/ ) {
- my $popnum = $1;
+} elsif ( $cgi->param('popnum') =~ /^(\d+)$/ ) {
$unlinked .= ( $unlinked ? 'AND' : 'WHERE' ).
$unlinked .= ( $unlinked ? 'AND' : 'WHERE' ).
- " popnum = $
popnum
";
+ " popnum = $
1
";
$sortby=\*username_sort;
$orderby = "ORDER BY ${tblname}username";
$sortby=\*username_sort;
$orderby = "ORDER BY ${tblname}username";
+} elsif ( $cgi->param('svcpart') =~ /^(\d+)$/ ) {
+ $unlinked .= ( $unlinked ? ' AND' : ' WHERE' ).
+ " $1 = ( SELECT svcpart FROM cust_svc ".
+ " WHERE cust_svc.svcnum = svc_acct.svcnum ) ";
+ $sortby=\*uid_sort;
+ #$sortby=\*svcnum_sort;
} else {
$sortby=\*uid_sort;
@svc_acct = @{&usernamesearch};
} else {
$sortby=\*uid_sort;
@svc_acct = @{&usernamesearch};
@@
-63,7
+68,8
@@
if ( $query eq 'svcnum' ) {
if ( $query eq 'svcnum'
|| $query eq 'username'
|| $query eq 'uid'
if ( $query eq 'svcnum'
|| $query eq 'username'
|| $query eq 'uid'
- || $query =~ /^popnum=(\d+)$/ ) {
+ || $cgi->param('popnum') =~ /^(\d+)$/
+ || $cgi->param('svcpart') =~ /^(\d+)$/
) {
my $statement = "SELECT COUNT(*) FROM svc_acct $unlinked";
) {
my $statement = "SELECT COUNT(*) FROM svc_acct $unlinked";