diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2016-10-21 12:11:19 -0700 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2016-10-21 12:11:19 -0700 |
| commit | b5695128553a9a82eb36e7c75062cc0347057558 (patch) | |
| tree | c8ded6a3879b6dee02091e468d925039c2ed5267 /httemplate/search | |
| parent | b46c1ddcc7264e811b6b64510e786b0cea79fce6 (diff) | |
multi-select for agent on RADIUS usage report, RT#73050
Diffstat (limited to 'httemplate/search')
| -rw-r--r-- | httemplate/search/sqlradius_usage.html | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/httemplate/search/sqlradius_usage.html b/httemplate/search/sqlradius_usage.html index 6b1806ee3..494a27591 100644 --- 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 ) { - @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', - 'extra_sql' => 'WHERE agentnum IN ('. + 'hashref' => { 'disabled' => '', }, + 'extra_sql' => 'AND agentnum IN ('. join(',',@agentnums). ') '. ' AND '. $curuser->agentnums_sql, }); |