httemplate/search/report_sqlradius_usage.html

   1 <& /elements/header.html, mt($title) &>
   2
   3 <FORM ACTION="sqlradius_usage.html" METHOD="GET">
   4
   5 <TABLE BGCOLOR="#cccccc" CELLSPACING=0>
   6
   7 <& /elements/tr-select-agent.html,
   8   'empty_label'   => 'all',
   9 &>
  10
  11 %#more future-proof to actually ask all exports if they ->can('usage_sessions')
  12 % my @exporttypes = qw( sqlradius sqlradius_withdomain broadband_sqlradius
  13 %                       phone_sqlradius radiator
  14 %                     );
  15 <& /elements/tr-select-table.html,
  16   'label'         => 'Export',
  17   'table'         => 'part_export',
  18   'name_col'      => 'label',
  19   'hashref'       => {},
  20   'extra_sql'     => ' WHERE exporttype IN ( '.
  21                                             join(',', map "'$_'", @exporttypes).
  22                                           ')',
  23   'disable_empty' => 1,
  24   'order_by'      => 'ORDER BY exportnum',
  25 &>
  26
  27 <& /elements/tr-input-beginning_ending.html &>
  28
  29 </TABLE>
  30
  31 <BR>
  32 <INPUT TYPE="submit" VALUE="<% mt('Get Report') |h %>">
  33
  34 </FORM>
  35
  36 <& /elements/footer.html &>
  37 <%init>
  38
  39 die "access denied"
  40   unless $FS::CurrentUser::CurrentUser->access_right('Usage: RADIUS sessions');
  41   # yes?
  42
  43 my $title = 'Data Usage Report';
  44
  45 </%init>