X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fsearch%2Freport_sqlradius_usage.html;h=89b60847bd9ac64fa37cb216d36406887a6e5c33;hb=4e2e2afe2b9d54e971f433350f215df156e64f60;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..89b60847b 100644 --- a/httemplate/search/report_sqlradius_usage.html +++ b/httemplate/search/report_sqlradius_usage.html @@ -1,20 +1,26 @@ +%# some overlap with report_sqlradius_usage_custnum.html <& /elements/header.html, mt($title) &>
- <& /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', &>