X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fsearch%2Freport_sqlradius_usage.html;h=e818fb57de9ce9c952f4054fe5a1b4a1c4b4a10d;hb=8eb6542c022ac84b125416f3fb0828b278ba600a;hp=01215e83425e949de7d76b7117d4ee06d31d2c91;hpb=db80d13447786bc554d40d4817a1b0d7a5b5e09f;p=freeside.git diff --git a/httemplate/search/report_sqlradius_usage.html b/httemplate/search/report_sqlradius_usage.html index 01215e834..e818fb57d 100644 --- a/httemplate/search/report_sqlradius_usage.html +++ b/httemplate/search/report_sqlradius_usage.html @@ -2,19 +2,24 @@
- <& /elements/tr-select-agent.html, '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', &>