1 <% include( '/elements/header.html', 'RADIUS Sessions') %>
4 % # and finally, display the thing
7 % foreach my $part_export (
8 % #grep $_->can('usage_sessions'), qsearch( 'part_export' )
9 % qsearch( 'part_export', { 'exporttype' => 'sqlradius' } ),
10 % qsearch( 'part_export', { 'exporttype' => 'sqlradius_withdomain' } )
14 % my $efields = tie my %efields, 'Tie::IxHash', %fields;
15 % delete $efields{'framedipaddress'} if $part_export->option('hide_ip');
16 % if ( $part_export->option('hide_data') ) {
17 % delete $efields{$_} foreach qw(acctinputoctets acctoutputoctets);
19 % if ( $part_export->option('show_called_station') ) {
20 % $efields->Splice(1, 0,
21 % 'calledstationid' => {
22 % 'name' => 'Destination',
23 % 'attrib' => 'Called-Station-ID',
25 % sub { length($_[0]) ? shift : ' '; },
33 <% $part_export->exporttype %> to <% $part_export->machine %><BR>
34 <% include( '/elements/table-grid.html' ) %>
35 % my $bgcolor1 = '#eeeeee';
36 % my $bgcolor2 = '#ffffff';
40 % foreach my $field ( keys %efields ) {
42 <TH CLASS="grid" BGCOLOR="#cccccc">
43 <% $efields{$field}->{name} %><BR>
44 <FONT SIZE=-2><% $efields{$field}->{attrib} %></FONT>
50 % foreach my $session (
51 % @{ $part_export->usage_sessions( {
52 % 'stoptime_start' => $beginning,
53 % 'stoptime_end' => $ending,
54 % 'session_status' => $status,
55 % 'starttime_start' => $starttime_beginning,
56 % 'starttime_end' => $starttime_ending,
59 % 'prefix' => $prefix,
60 % 'summarize' => $summarize,
64 % if ( $bgcolor eq $bgcolor1 ) {
65 % $bgcolor = $bgcolor2;
67 % $bgcolor = $bgcolor1;
71 % foreach my $field ( keys %efields ) {
72 % my $html = &{ $efields{$field}->{fmt} }( $session->{$field},
76 % my $class = ( $html =~ /<TABLE/ ? 'inv' : 'grid' );
78 <TD CLASS="<%$class%>" BGCOLOR="<% $bgcolor %>" ALIGN="<% $efields{$field}->{align} %>">
94 unless $FS::CurrentUser::CurrentUser->access_right('List rating data');
101 $summarize = 1 if $cgi->param('summarize') eq 'Y';
103 #sort of false laziness w/cust_pay.cgi
104 my( $beginning, $ending ) = ( '', '' );
105 if ( $cgi->param('stoptime_beginning')
106 && $cgi->param('stoptime_beginning') =~ /^([ 0-9\-\/\:\w]{0,54})$/ ) {
107 $beginning = parse_datetime($1);
109 if ( $cgi->param('stoptime_ending')
110 && $cgi->param('stoptime_ending') =~ /^([ 0-9\-\/\:\w]{0,54})$/ ) {
111 $ending = parse_datetime($1); # + 86399;
113 if ( $cgi->param('begin') && $cgi->param('begin') =~ /^(\d+)$/ ) {
116 if ( $cgi->param('end') && $cgi->param('end') =~ /^(\d+)$/ ) {
121 if ( $cgi->param('session_status') =~ /^(closed|open)$/ ) {
125 my( $starttime_beginning, $starttime_ending ) = ( '', '' );
126 if ( $cgi->param('starttime_beginning')
127 && $cgi->param('starttime_beginning') =~ /^([ 0-9\-\/\:\w]{0,54})$/ ) {
128 $starttime_beginning = parse_datetime($1);
130 if ( $cgi->param('starttime_ending')
131 && $cgi->param('starttime_ending') =~ /^([ 0-9\-\/\:\w]{0,54})$/ ) {
132 $starttime_ending = parse_datetime($1); # + 86399;
136 if ( $cgi->param('svcnum') =~ /^(\d+)$/ ) {
137 $cgi_svc = qsearchs( 'svc_acct', { 'svcnum' => $1 } )
138 || qsearchs( 'svc_broadband', { 'svcnum' => $1 } );
139 } elsif ( $cgi->param('username') =~ /^([^@]+)\@([^@]+)$/ ) {
140 my %search = { 'username' => $1 };
141 my $svc_domain = qsearchs('svc_domain', { 'domain' => $2 } );
143 $search{'domsvc'} = $svc_domain->svcnum;
145 delete $search{'username'};
147 $cgi_svc = qsearchs( 'svc_acct', \%search )
149 } elsif ( $cgi->param('username') =~ /^(.+)$/ ) {
150 $cgi_svc = qsearchs( 'svc_acct', { 'username' => $1 } );
154 if ( $cgi->param('ip') =~ /^((\d+\.){3}\d+)$/ ) {
158 my $prefix = $cgi->param('prefix');
160 if ( $prefix =~ /^(\d+)$/ ) {
162 $prefix = "011$prefix" unless $prefix =~ /^1/;
168 # field formatting subroutines
172 my $user_format = sub {
173 my ( $user, $session, $part_export ) = @_;
176 if ( exists $user2svc{$user} ) {
177 $svc = $user2svc{$user};
180 if ( $part_export->exporttype eq 'broadband_sqlradius' ) {
182 ( my $mac = $user ) =~ s/[^0-9a-f]//ig;
185 grep { qsearchs( 'export_svc', {
186 'exportnum' => $part_export->exportnum,
187 'svcpart' => $_->cust_svc->svcpart,
189 } qsearch( 'svc_broadband', {
190 mac_addr => { op=>'ILIKE', value=>$mac }
193 if ( @svc_broadband ) {
194 warn 'multiple svc_broadband records for user $user found; '.
195 'using first arbitrarily'
196 if scalar(@svc_broadband) > 1;
197 $user2svc{$user} = $svc = shift @svc_broadband;
203 if ( $part_export->exporttype eq 'sqlradius_withdomain' ) {
205 if ( $user =~ /^([^@]+)\@([^@]+)$/ ) {
206 $search{'username'} = $1;
209 $search{'username'} = $user;
210 $domain = $session->{'realm'};
212 my $svc_domain = qsearchs('svc_domain', { 'domain' => $domain } );
214 $search{'domsvc'} = $svc_domain->svcnum;
216 delete $search{'username'};
218 } elsif ( $part_export->exporttype eq 'sqlradius' ) {
219 $search{'username'} = $user;
221 die 'unknown export type '. $part_export->exporttype.
222 " for $part_export\n";
224 if ( keys %search ) {
226 grep { qsearchs( 'export_svc', {
227 'exportnum' => $part_export->exportnum,
228 'svcpart' => $_->cust_svc->svcpart,
230 } qsearch( 'svc_acct', \%search );
232 warn 'multiple svc_acct records for user $user found; '.
233 'using first arbitrarily'
234 if scalar(@svc_acct) > 1;
235 $user2svc{$user} = $svc = shift @svc_acct;
245 #i should use svc_link, but that's expensive per-user
246 my $svcnum = $svc->svcnum;
247 my $table = $svc->table;
248 qq(<A HREF="${p}view/$table.cgi?$svcnum"><B>$user</B></A>);
256 my $customer_format = sub {
257 my( $unused, $session ) = @_;
258 return ' ' unless exists $user2svc{$session->{'username'}};
259 my $svc = $user2svc{$session->{'username'}};
260 my $cust_pkg = $svc->cust_svc->cust_pkg;
261 return ' ' unless $cust_pkg;
262 my $cust_main = $cust_pkg->cust_main;
264 qq!<A HREF="${p}view/cust_main.cgi?!. $cust_main->custnum. '">'.
265 $cust_pkg->cust_main->name. '</A>';
268 my $time_format = sub {
270 return ' ' if $time == 0;
271 my $pretty = time2str('%T%P %a %b %o %Y', $time );
272 $pretty =~ s/ (\d)(st|dn|rd|th)/$1$2/;
276 my $time_format_or_open = sub {
278 return '<CENTER>OPEN</CENTER>' if $time == 0;
279 &{$time_format}($time);
282 my $duration_format = sub {
284 return '' if $seconds eq ''; # open session
285 my $hour = int($seconds/3600);
286 my $min = int( ($seconds%3600) / 60 );
287 my $sec = $seconds%60;
288 '<TABLE CLASS="inv" BORDER=0 CELLSPACING=0 CELLPADDING=0>'.
289 '<TR><TD CLASS="inv" ALIGN="right">'.
290 ( $hour ? "<B>$hour</B>h" : ' ' ).
291 '</TD><TD CLASS="inv" ALIGN="right">'.
292 ( ( $hour || $min ) ? "<B>$min</B>m" : ' ' ).
293 '</TD><TD CLASS="inv" ALIGN="right">'.
295 '</TD></TR></TABLE>';
298 my $octets_format = sub {
300 my $megs = $octets / 1048576;
301 sprintf('<B>%.3f</B> megs', $megs);
302 #my $gigs = $octets / 1073741824
303 #sprintf('<B>%.3f</B> gigabytes', $gigs);
312 tie %fields, 'Tie::IxHash',
315 attrib => 'UserName',
322 fmt => $customer_format,
325 'acctsessiontime' => {
327 attrib => 'Acct-Session-Time',
328 fmt => $duration_format,
331 'acctinputoctets' => {
332 name => 'Upload', # (from user)',
333 attrib => 'Acct-Input-Octets',
334 fmt => $octets_format,
337 'acctoutputoctets' => {
338 name => 'Download', # (to user)',
339 attrib => 'Acct-Output-Octets',
340 fmt => $octets_format,
345 tie %fields, 'Tie::IxHash',
348 attrib => 'UserName',
360 fmt => $customer_format,
363 'framedipaddress' => {
364 name => 'IP Address',
365 attrib => 'Framed-IP-Address',
366 fmt => sub { my $ip = shift;
367 length($ip) ? $ip : ' ';
372 name => 'Start time',
373 attrib => 'Acct-Start-Time',
378 name => 'End time',
379 attrib => 'Acct-Stop-Time',
380 fmt => $time_format_or_open,
383 'acctsessiontime' => {
385 attrib => 'Acct-Session-Time',
386 fmt => $duration_format,
389 'acctinputoctets' => {
390 name => 'Upload', # (from user)',
391 attrib => 'Acct-Input-Octets',
392 fmt => $octets_format,
395 'acctoutputoctets' => {
396 name => 'Download', # (to user)',
397 attrib => 'Acct-Output-Octets',
398 fmt => $octets_format,
403 $fields{$_}->{fmt} ||= sub { length($_[0]) ? shift : ' '; }
404 foreach keys %fields;