1 <%= include( '/elements/header.html', 'RADIUS Sessions',
2 include('/elements/menubar.html',
3 'Main menu' => $p, # popurl(2),
14 #sort of false laziness w/cust_pay.cgi
17 if ( $cgi->param('beginning')
18 && $cgi->param('beginning') =~ /^([ 0-9\-\/]{0,10})$/ ) {
19 $beginning = str2time($1);
21 if ( $cgi->param('ending')
22 && $cgi->param('ending') =~ /^([ 0-9\-\/]{0,10})$/ ) {
23 $ending = str2time($1) + 86399;
25 if ( $cgi->param('begin') && $cgi->param('begin') =~ /^(\d+)$/ ) {
28 if ( $cgi->param('end') && $cgi->param('end') =~ /^(\d+)$/ ) {
32 my $cgi_svc_acct = '';
33 if ( $cgi->param('svcnum') =~ /^(\d+)$/ ) {
34 $cgi_svc_acct = qsearchs( 'svc_acct', { 'svcnum' => $1 } );
35 } elsif ( $cgi->param('username') =~ /^([^@]+)\@([^@]+)$/ ) {
36 my %search = { 'username' => $1 };
37 my $svc_domain = qsearchs('svc_domain', { 'domain' => $2 } );
39 $search{'domsvc'} = $svc_domain->svcnum;
41 delete $search{'username'};
43 $cgi_svc_acct = qsearchs( 'svc_acct', \%search )
45 } elsif ( $cgi->param('username') =~ /^(.+)$/ ) {
46 $cgi_svc_acct = qsearchs( 'svc_acct', { 'username' => $1 } );
50 if ( $cgi->param('ip') =~ /^((\d+\.){3}\d+)$/ ) {
55 # field formatting subroutines
58 my %user2svc_acct = ();
59 my $user_format = sub {
60 my ( $user, $session, $part_export ) = @_;
63 if ( exists $user2svc_acct{$user} ) {
64 $svc_acct = $user2svc_acct{$user};
67 if ( $part_export->exporttype eq 'sqlradius_withdomain' ) {
69 if ( $user =~ /^([^@]+)\@([^@]+)$/ ) {
70 $search{'username'} = $1;
73 $search{'username'} = $user;
74 $domain = $session->{'realm'};
76 my $svc_domain = qsearchs('svc_domain', { 'domain' => $domain } );
78 $search{'domsvc'} = $svc_domain->svcnum;
80 delete $search{'username'};
82 } elsif ( $part_export->exporttype eq 'sqlradius' ) {
83 $search{'username'} = $user;
85 die 'unknown export type '. $part_export->exporttype.
86 " for $part_export\n";
90 grep { qsearchs( 'export_svc', {
91 'exportnum' => $part_export->exportnum,
92 'svcpart' => $_->cust_svc->svcpart,
94 } qsearch( 'svc_acct', \%search );
96 warn 'multiple svc_acct records for user $user found; '.
97 'using first arbitrarily'
98 if scalar(@svc_acct) > 1;
99 $user2svc_acct{$user} = $svc_acct = shift @svc_acct;
105 my $svcnum = $svc_acct->svcnum;
106 qq(<A HREF="${p}view/svc_acct.cgi?$svcnum"><B>$user</B></A>);
113 my $customer_format = sub {
114 my( $unused, $session ) = @_;
115 return ' ' unless exists $user2svc_acct{$session->{'username'}};
116 my $svc_acct = $user2svc_acct{$session->{'username'}};
117 my $cust_pkg = $svc_acct->cust_svc->cust_pkg;
118 return ' ' unless $cust_pkg;
119 my $cust_main = $cust_pkg->cust_main;
121 qq!<A HREF="${p}view/cust_main.cgi?!. $cust_main->custnum. '">'.
122 $cust_pkg->cust_main->name. '</A>';
125 my $time_format = sub {
127 return ' ' if $time == 0;
128 my $pretty = time2str('%T%P %a %b %o %Y', $time );
129 $pretty =~ s/ (\d)(st|dn|rd|th)/$1$2/;
133 my $duration_format = sub {
135 my $hour = int($seconds/3600);
136 my $min = int( ($seconds%3600) / 60 );
137 my $sec = $seconds%60;
138 '<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0>'.
139 '<TR><TD ALIGN="right">'.
140 ( $hour ? "<B>$hour</B>h" : ' ' ).
141 '</TD><TD ALIGN="right">'.
142 ( ( $hour || $min ) ? "<B>$min</B>m" : ' ' ).
143 '</TD><TD ALIGN="right">'.
145 '</TD></TR></TABLE>';
148 my $octets_format = sub {
150 my $megs = $octets / 1048576;
151 sprintf('<B>%.3f</B> megs', $megs);
152 #my $gigs = $octets / 1073741824
153 #sprintf('<B>%.3f</B> gigabytes', $gigs);
160 tie my %fields, 'Tie::IxHash',
163 attrib => 'UserName',
175 fmt => $customer_format,
178 'framedipaddress' => {
179 name => 'IP Address',
180 attrib => 'Framed-IP-Address',
181 fmt => sub { my $ip = shift;
182 length($ip) ? $ip : ' ';
187 name => 'Start time',
188 attrib => 'Acct-Start-Time',
193 name => 'End time',
194 attrib => 'Acct-Stop-Time',
198 'acctsessiontime' => {
200 attrib => 'Acct-Session-Time',
201 fmt => $duration_format,
204 'acctinputoctets' => {
205 name => 'Upload', # (from user)',
206 attrib => 'Acct-Input-Octets',
207 fmt => $octets_format,
210 'acctoutputoctets' => {
211 name => 'Download', # (to user)',
212 attrib => 'Acct-Output-Octets',
213 fmt => $octets_format,
217 $fields{$_}->{fmt} ||= sub { length($_[0]) ? shift : ' '; }
218 foreach keys %fields;
221 # and finally, display the thing
224 foreach my $part_export ( map $_->rebless,
225 qsearch( 'part_export', { 'exporttype' => 'sqlradius' } ),
226 qsearch( 'part_export', { 'exporttype' => 'sqlradius_withdomain' } )
231 <%= $part_export->exporttype %> to <%= $part_export->machine %><BR>
232 <%= include( '/elements/table.html' ) %>
234 <% foreach my $field ( keys %fields ) { %>
236 <%= $fields{$field}->{name} %><BR>
237 <FONT SIZE=-2><%= $fields{$field}->{attrib} %></FONT>
241 <% foreach my $session (
242 @{ $part_export->usage_sessions( $beginning, $ending, $cgi_svc_acct, $ip ) }
245 <% foreach my $field ( keys %fields ) { %>
246 <TD ALIGN="<%= $fields{$field}->{align} %>">
247 <%= &{ $fields{$field}->{fmt} }( $session->{$field},