diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2013-03-10 21:53:55 -0700 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2013-03-10 21:53:55 -0700 |
| commit | 7ad6715f6e0810df90046af7c4c905d945712476 (patch) | |
| tree | 2c8294e80737c02a111988d44ed6ff415636864b | |
| parent | 6c8c35f089c2846feee78ded4f5ce9f829b06391 (diff) | |
fix radius data usage report w/sqlradius_withdomain export, RT#19964
| -rw-r--r-- | httemplate/search/report_sqlradius_usage.html | 9 |
1 files changed, 7 insertions, 2 deletions
diff --git a/httemplate/search/report_sqlradius_usage.html b/httemplate/search/report_sqlradius_usage.html index 01215e834..7e54465d3 100644 --- a/httemplate/search/report_sqlradius_usage.html +++ b/httemplate/search/report_sqlradius_usage.html @@ -8,13 +8,18 @@ 'empty_label' => 'all', &> -% my @exporttypes = map { "'$_'" } qw(sqlradius broadband_sqlradius); +%#more future-proof to actually ask all exports if they ->can('usage_sessions') +% my @exporttypes = qw( sqlradius sqlradius_withdomain broadband_sqlradius +% phone_sqlradius radiator +% ); <& /elements/tr-select-table.html, 'label' => 'Export', 'table' => 'part_export', 'name_col' => 'label', 'hashref' => {}, - 'extra_sql' => ' WHERE exporttype IN('.join(',', @exporttypes).')', + 'extra_sql' => ' WHERE exporttype IN ( '. + join(',', map "'$_'", @exporttypes). + ')', 'disable_empty' => 1, 'order_by' => 'ORDER BY exportnum', &> |