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 ) {
69 <TD CLASS="grid" BGCOLOR="<% $bgcolor %>" ALIGN="<% $efields{$field}->{align} %>">
70 <% &{ $efields{$field}->{fmt} }( $session->{$field},
92 #sort of false laziness w/cust_pay.cgi
95 if ( $cgi->param('beginning')
96 && $cgi->param('beginning') =~ /^([ 0-9\-\/]{0,10})$/ ) {
97 $beginning = str2time($1);
99 if ( $cgi->param('ending')
100 && $cgi->param('ending') =~ /^([ 0-9\-\/]{0,10})$/ ) {
101 $ending = str2time($1) + 86399;
103 if ( $cgi->param('begin') && $cgi->param('begin') =~ /^(\d+)$/ ) {
106 if ( $cgi->param('end') && $cgi->param('end') =~ /^(\d+)$/ ) {
110 my $cgi_svc_acct = '';
111 if ( $cgi->param('svcnum') =~ /^(\d+)$/ ) {
112 $cgi_svc_acct = qsearchs( 'svc_acct', { 'svcnum' => $1 } );
113 } elsif ( $cgi->param('username') =~ /^([^@]+)\@([^@]+)$/ ) {
114 my %search = { 'username' => $1 };
115 my $svc_domain = qsearchs('svc_domain', { 'domain' => $2 } );
117 $search{'domsvc'} = $svc_domain->svcnum;
119 delete $search{'username'};
121 $cgi_svc_acct = qsearchs( 'svc_acct', \%search )
123 } elsif ( $cgi->param('username') =~ /^(.+)$/ ) {
124 $cgi_svc_acct = qsearchs( 'svc_acct', { 'username' => $1 } );
128 if ( $cgi->param('ip') =~ /^((\d+\.){3}\d+)$/ ) {
132 my $prefix = $cgi->param('prefix');
134 if ( $prefix =~ /^(\d+)$/ ) {
136 $prefix = "011$prefix" unless $prefix =~ /^1/;
142 # field formatting subroutines
145 my %user2svc_acct = ();
146 my $user_format = sub {
147 my ( $user, $session, $part_export ) = @_;
150 if ( exists $user2svc_acct{$user} ) {
151 $svc_acct = $user2svc_acct{$user};
154 if ( $part_export->exporttype eq 'sqlradius_withdomain' ) {
156 if ( $user =~ /^([^@]+)\@([^@]+)$/ ) {
157 $search{'username'} = $1;
160 $search{'username'} = $user;
161 $domain = $session->{'realm'};
163 my $svc_domain = qsearchs('svc_domain', { 'domain' => $domain } );
165 $search{'domsvc'} = $svc_domain->svcnum;
167 delete $search{'username'};
169 } elsif ( $part_export->exporttype eq 'sqlradius' ) {
170 $search{'username'} = $user;
172 die 'unknown export type '. $part_export->exporttype.
173 " for $part_export\n";
175 if ( keys %search ) {
177 grep { qsearchs( 'export_svc', {
178 'exportnum' => $part_export->exportnum,
179 'svcpart' => $_->cust_svc->svcpart,
181 } qsearch( 'svc_acct', \%search );
183 warn 'multiple svc_acct records for user $user found; '.
184 'using first arbitrarily'
185 if scalar(@svc_acct) > 1;
186 $user2svc_acct{$user} = $svc_acct = shift @svc_acct;
192 my $svcnum = $svc_acct->svcnum;
193 qq(<A HREF="${p}view/svc_acct.cgi?$svcnum"><B>$user</B></A>);
200 my $customer_format = sub {
201 my( $unused, $session ) = @_;
202 return ' ' unless exists $user2svc_acct{$session->{'username'}};
203 my $svc_acct = $user2svc_acct{$session->{'username'}};
204 my $cust_pkg = $svc_acct->cust_svc->cust_pkg;
205 return ' ' unless $cust_pkg;
206 my $cust_main = $cust_pkg->cust_main;
208 qq!<A HREF="${p}view/cust_main.cgi?!. $cust_main->custnum. '">'.
209 $cust_pkg->cust_main->name. '</A>';
212 my $time_format = sub {
214 return ' ' if $time == 0;
215 my $pretty = time2str('%T%P %a %b %o %Y', $time );
216 $pretty =~ s/ (\d)(st|dn|rd|th)/$1$2/;
220 my $duration_format = sub {
222 my $hour = int($seconds/3600);
223 my $min = int( ($seconds%3600) / 60 );
224 my $sec = $seconds%60;
225 '<TABLE CLASS="inv" BORDER=0 CELLSPACING=0 CELLPADDING=0>'.
226 '<TR><TD CLASS="inv" ALIGN="right">'.
227 ( $hour ? "<B>$hour</B>h" : ' ' ).
228 '</TD><TD CLASS="inv" ALIGN="right">'.
229 ( ( $hour || $min ) ? "<B>$min</B>m" : ' ' ).
230 '</TD><TD CLASS="inv" ALIGN="right">'.
232 '</TD></TR></TABLE>';
235 my $octets_format = sub {
237 my $megs = $octets / 1048576;
238 sprintf('<B>%.3f</B> megs', $megs);
239 #my $gigs = $octets / 1073741824
240 #sprintf('<B>%.3f</B> gigabytes', $gigs);
247 tie my %fields, 'Tie::IxHash',
250 attrib => 'UserName',
262 fmt => $customer_format,
265 'framedipaddress' => {
266 name => 'IP Address',
267 attrib => 'Framed-IP-Address',
268 fmt => sub { my $ip = shift;
269 length($ip) ? $ip : ' ';
274 name => 'Start time',
275 attrib => 'Acct-Start-Time',
280 name => 'End time',
281 attrib => 'Acct-Stop-Time',
285 'acctsessiontime' => {
287 attrib => 'Acct-Session-Time',
288 fmt => $duration_format,
291 'acctinputoctets' => {
292 name => 'Upload', # (from user)',
293 attrib => 'Acct-Input-Octets',
294 fmt => $octets_format,
297 'acctoutputoctets' => {
298 name => 'Download', # (to user)',
299 attrib => 'Acct-Output-Octets',
300 fmt => $octets_format,
304 $fields{$_}->{fmt} ||= sub { length($_[0]) ? shift : ' '; }
305 foreach keys %fields;