diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2013-03-10 21:53:56 -0700 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2013-03-10 21:53:56 -0700 |
| commit | 5a1b5212056dc5f4f497aae8339bed8dde50cb8c (patch) | |
| tree | 98a1abc5770f3e315940a607a1089ad5ced5a42a | |
| parent | 38b842853f3a704a72616ffe080a74a68c87b3aa (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', &> |