projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
multi-select for agent on RADIUS usage report, RT#73050
[freeside.git]
/
httemplate
/
search
/
sqlradius_usage.html
diff --git
a/httemplate/search/sqlradius_usage.html
b/httemplate/search/sqlradius_usage.html
index
6b1806e
..
494a275
100644
(file)
--- a/
httemplate/search/sqlradius_usage.html
+++ b/
httemplate/search/sqlradius_usage.html
@@
-74,12
+74,16
@@
if ( $opt{'agentnum'} =~ /^(\d+)$/ ) {
my @agentnums = grep /^(\d+)$/, $cgi->param('agentnum');
if ( ! @agentnums ) {
my @agentnums = grep /^(\d+)$/, $cgi->param('agentnum');
if ( ! @agentnums ) {
- @include_agents = qsearch('agent', {});
+ @include_agents = qsearch({ 'table' => 'agent',
+ 'hashref' => { 'disabled'=>'' },
+ 'extra_sql' => ' AND '. $curuser->agentnums_sql,
+ });
} elsif ( scalar(@agentnums) == 1 ) {
$agentnum = $agentnums[0];
} else {
@include_agents = qsearch({ 'table' => 'agent',
} elsif ( scalar(@agentnums) == 1 ) {
$agentnum = $agentnums[0];
} else {
@include_agents = qsearch({ 'table' => 'agent',
- 'extra_sql' => 'WHERE agentnum IN ('.
+ 'hashref' => { 'disabled' => '', },
+ 'extra_sql' => 'AND agentnum IN ('.
join(',',@agentnums). ') '.
' AND '. $curuser->agentnums_sql,
});
join(',',@agentnums). ') '.
' AND '. $curuser->agentnums_sql,
});