1 %# some overlap with report_sqlradius_usage_custnum.html
2 <& /elements/header.html, mt($title) &>
4 <FORM ACTION="sqlradius_usage.html" METHOD="GET">
6 <TABLE BGCOLOR="#cccccc" CELLSPACING=0>
8 <& /elements/tr-select-agent.html,
9 'empty_label' => 'all',
12 %#more future-proof to actually ask all exports if they ->can('usage_sessions')
13 % my @exporttypes = qw( sqlradius sqlradius_withdomain broadband_sqlradius
14 % phone_sqlradius radiator
16 <& /elements/tr-select-table.html,
18 'table' => 'part_export',
19 'name_col' => 'label',
21 'extra_sql' => ' WHERE exporttype IN ( '.
22 join(',', map "'$_'", @exporttypes).
25 'order_by' => 'ORDER BY exportnum',
28 <& /elements/tr-input-beginning_ending.html &>
33 <INPUT TYPE="submit" VALUE="<% mt('Get Report') |h %>">
37 <& /elements/footer.html &>
41 unless $FS::CurrentUser::CurrentUser->access_right('Usage: RADIUS sessions');
44 my $title = 'Data Usage Report';