1 <% include( '/elements/header.html', 'RADIUS Sessions',
2 include('/elements/menubar.html',
3 'Main menu' => $p, # popurl(2),
10 % # and finally, display the thing
13 % foreach my $part_export (
14 % #grep $_->can('usage_sessions'), qsearch( 'part_export' )
15 % qsearch( 'part_export', { 'exporttype' => 'sqlradius' } ),
16 % qsearch( 'part_export', { 'exporttype' => 'sqlradius_withdomain' } )
18 % %user2svc_acct = ();
20 % my $efields = tie my %efields, 'Tie::IxHash', %fields;
21 % delete $efields{'framedipaddress'} if $part_export->option('hide_ip');
22 % if ( $part_export->option('hide_data') ) {
23 % delete $efields{$_} foreach qw(acctinputoctets acctoutputoctets);
25 % if ( $part_export->option('show_called_station') ) {
26 % $efields->Splice(1, 0,
27 % 'calledstationid' => {
28 % 'name' => 'Destination',
29 % 'attrib' => 'Called-Station-ID',
31 % sub { length($_[0]) ? shift : ' '; },
39 <% $part_export->exporttype %> to <% $part_export->machine %><BR>
40 <% include( '/elements/table-grid.html' ) %>
41 % my $bgcolor1 = '#eeeeee';
42 % my $bgcolor2 = '#ffffff';
46 % foreach my $field ( keys %efields ) {
48 <TH CLASS="grid" BGCOLOR="#cccccc">
49 <% $efields{$field}->{name} %><BR>
50 <FONT SIZE=-2><% $efields{$field}->{attrib} %></FONT>
56 % foreach my $session (
57 % @{ $part_export->usage_sessions(
58 % $beginning, $ending, $cgi_svc_acct, $ip, $prefix, ) }
60 % if ( $bgcolor eq $bgcolor1 ) {
61 % $bgcolor = $bgcolor2;
63 % $bgcolor = $bgcolor1;
67 % foreach my $field ( keys %efields ) {
68 % my $html = &{ $efields{$field}->{fmt} }( $session->{$field},
72 % my $class = ( $html =~ /<TABLE/ ? 'inv' : 'grid' );
74 <TD CLASS="<%$class%>" BGCOLOR="<% $bgcolor %>" ALIGN="<% $efields{$field}->{align} %>">
90 unless $FS::CurrentUser::CurrentUser->access_right('List rating data');
96 #sort of false laziness w/cust_pay.cgi
99 if ( $cgi->param('beginning')
100 && $cgi->param('beginning') =~ /^([ 0-9\-\/\:\w]{0,54})$/ ) {
101 $beginning = str2time($1);
103 if ( $cgi->param('ending')
104 && $cgi->param('ending') =~ /^([ 0-9\-\/\:\w]{0,54})$/ ) {
105 $ending = str2time($1); # + 86399;
107 if ( $cgi->param('begin') && $cgi->param('begin') =~ /^(\d+)$/ ) {
110 if ( $cgi->param('end') && $cgi->param('end') =~ /^(\d+)$/ ) {
114 my $cgi_svc_acct = '';
115 if ( $cgi->param('svcnum') =~ /^(\d+)$/ ) {
116 $cgi_svc_acct = qsearchs( 'svc_acct', { 'svcnum' => $1 } );
117 } elsif ( $cgi->param('username') =~ /^([^@]+)\@([^@]+)$/ ) {
118 my %search = { 'username' => $1 };
119 my $svc_domain = qsearchs('svc_domain', { 'domain' => $2 } );
121 $search{'domsvc'} = $svc_domain->svcnum;
123 delete $search{'username'};
125 $cgi_svc_acct = qsearchs( 'svc_acct', \%search )
127 } elsif ( $cgi->param('username') =~ /^(.+)$/ ) {
128 $cgi_svc_acct = qsearchs( 'svc_acct', { 'username' => $1 } );
132 if ( $cgi->param('ip') =~ /^((\d+\.){3}\d+)$/ ) {
136 my $prefix = $cgi->param('prefix');
138 if ( $prefix =~ /^(\d+)$/ ) {
140 $prefix = "011$prefix" unless $prefix =~ /^1/;
146 # field formatting subroutines
149 my %user2svc_acct = ();
150 my $user_format = sub {
151 my ( $user, $session, $part_export ) = @_;
154 if ( exists $user2svc_acct{$user} ) {
155 $svc_acct = $user2svc_acct{$user};
158 if ( $part_export->exporttype eq 'sqlradius_withdomain' ) {
160 if ( $user =~ /^([^@]+)\@([^@]+)$/ ) {
161 $search{'username'} = $1;
164 $search{'username'} = $user;
165 $domain = $session->{'realm'};
167 my $svc_domain = qsearchs('svc_domain', { 'domain' => $domain } );
169 $search{'domsvc'} = $svc_domain->svcnum;
171 delete $search{'username'};
173 } elsif ( $part_export->exporttype eq 'sqlradius' ) {
174 $search{'username'} = $user;
176 die 'unknown export type '. $part_export->exporttype.
177 " for $part_export\n";
179 if ( keys %search ) {
181 grep { qsearchs( 'export_svc', {
182 'exportnum' => $part_export->exportnum,
183 'svcpart' => $_->cust_svc->svcpart,
185 } qsearch( 'svc_acct', \%search );
187 warn 'multiple svc_acct records for user $user found; '.
188 'using first arbitrarily'
189 if scalar(@svc_acct) > 1;
190 $user2svc_acct{$user} = $svc_acct = shift @svc_acct;
196 my $svcnum = $svc_acct->svcnum;
197 qq(<A HREF="${p}view/svc_acct.cgi?$svcnum"><B>$user</B></A>);
204 my $customer_format = sub {
205 my( $unused, $session ) = @_;
206 return ' ' unless exists $user2svc_acct{$session->{'username'}};
207 my $svc_acct = $user2svc_acct{$session->{'username'}};
208 my $cust_pkg = $svc_acct->cust_svc->cust_pkg;
209 return ' ' unless $cust_pkg;
210 my $cust_main = $cust_pkg->cust_main;
212 qq!<A HREF="${p}view/cust_main.cgi?!. $cust_main->custnum. '">'.
213 $cust_pkg->cust_main->name. '</A>';
216 my $time_format = sub {
218 return ' ' if $time == 0;
219 my $pretty = time2str('%T%P %a %b %o %Y', $time );
220 $pretty =~ s/ (\d)(st|dn|rd|th)/$1$2/;
224 my $duration_format = sub {
226 my $hour = int($seconds/3600);
227 my $min = int( ($seconds%3600) / 60 );
228 my $sec = $seconds%60;
229 '<TABLE CLASS="inv" BORDER=0 CELLSPACING=0 CELLPADDING=0>'.
230 '<TR><TD CLASS="inv" ALIGN="right">'.
231 ( $hour ? "<B>$hour</B>h" : ' ' ).
232 '</TD><TD CLASS="inv" ALIGN="right">'.
233 ( ( $hour || $min ) ? "<B>$min</B>m" : ' ' ).
234 '</TD><TD CLASS="inv" ALIGN="right">'.
236 '</TD></TR></TABLE>';
239 my $octets_format = sub {
241 my $megs = $octets / 1048576;
242 sprintf('<B>%.3f</B> megs', $megs);
243 #my $gigs = $octets / 1073741824
244 #sprintf('<B>%.3f</B> gigabytes', $gigs);
251 tie my %fields, 'Tie::IxHash',
254 attrib => 'UserName',
266 fmt => $customer_format,
269 'framedipaddress' => {
270 name => 'IP Address',
271 attrib => 'Framed-IP-Address',
272 fmt => sub { my $ip = shift;
273 length($ip) ? $ip : ' ';
278 name => 'Start time',
279 attrib => 'Acct-Start-Time',
284 name => 'End time',
285 attrib => 'Acct-Stop-Time',
289 'acctsessiontime' => {
291 attrib => 'Acct-Session-Time',
292 fmt => $duration_format,
295 'acctinputoctets' => {
296 name => 'Upload', # (from user)',
297 attrib => 'Acct-Input-Octets',
298 fmt => $octets_format,
301 'acctoutputoctets' => {
302 name => 'Download', # (to user)',
303 attrib => 'Acct-Output-Octets',
304 fmt => $octets_format,
308 $fields{$_}->{fmt} ||= sub { length($_[0]) ? shift : ' '; }
309 foreach keys %fields;