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->exporrtype 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 "guru meditation #420";
89 grep { qsearchs( 'export_svc', {
90 'exportnum' => $part_export->exportnum,
91 'svcpart' => $_->cust_svc->svcpart,
93 } qsearch( 'svc_acct', \%search );
95 warn 'multiple svc_acct records for user $user found; '.
96 'using first arbitrarily'
97 if scalar(@svc_acct) > 1;
98 $user2svc_acct{$user} = $svc_acct = shift @svc_acct;
104 my $svcnum = $svc_acct->svcnum;
105 qq(<A HREF="${p}view/svc_acct.cgi?$svcnum"><B>$user</B></A>);
112 my $customer_format = sub {
113 my( $unused, $session ) = @_;
114 return ' ' unless exists $user2svc_acct{$session->{'username'}};
115 my $svc_acct = $user2svc_acct{$session->{'username'}};
116 my $cust_pkg = $svc_acct->cust_svc->cust_pkg;
117 return ' ' unless $cust_pkg;
118 my $cust_main = $cust_pkg->cust_main;
120 qq!<A HREF="${p}view/cust_main.cgi?!. $cust_main->custnum. '">'.
121 $cust_pkg->cust_main->name. '</A>';
124 my $time_format = sub {
126 return ' ' if $time == 0;
127 my $pretty = time2str('%T%P %a %b %o %Y', $time );
128 $pretty =~ s/ (\d)(st|dn|rd|th)/ $1$2/;
131 my $duration_format = sub {
133 my $hour = int($seconds/3600);
134 my $min = int( ($seconds%3600) / 60 );
135 my $sec = $seconds%60;
136 '<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0>'.
137 '<TR><TD ALIGN="right">'.
138 ( $hour ? "<B>$hour</B>h" : ' ' ).
139 '</TD><TD ALIGN="right">'.
140 ( ( $hour || $min ) ? "<B>$min</B>m" : ' ' ).
141 '</TD><TD ALIGN="right">'.
143 '</TD></TR></TABLE>';
146 my $octets_format = sub {
148 my $megs = $octets / 1048576;
149 sprintf('<B>%.3f</B> megs', $megs);
150 #my $gigs = $octets / 1073741824
151 #sprintf('<B>%.3f</B> gigabytes', $gigs);
158 tie my %fields, 'Tie::IxHash',
161 attrib => 'UserName',
171 fmt => $customer_format,
173 'framedipaddress' => {
174 name => 'IP Address',
175 attrib => 'Framed-IP-Address',
176 fmt => sub { my $ip = shift;
177 length($ip) ? $ip : ' ';
181 name => 'Start time',
182 attrib => 'Acct-Start-Time',
187 attrib => 'Acct-Stop-Time',
190 'acctsessiontime' => {
192 attrib => 'Acct-Session-Time',
193 fmt => $duration_format,
195 'acctinputoctets' => {
196 name => 'Upload', # (from user)',
197 attrib => 'Acct-Input-Octets',
198 fmt => $octets_format,
200 'acctoutputoctets' => {
201 name => 'Download', # (to user)',
202 attrib => 'Acct-Output-Octets',
203 fmt => $octets_format,
206 $fields{$_}->{fmt} ||= sub { length($_[0]) ? shift : ' '; }
207 foreach keys %fields;
210 # and finally, display the thing
213 foreach my $part_export ( map $_->rebless,
214 qsearch( 'part_export', { 'exporttype' => 'sqlradius' } ),
215 qsearch( 'part_export', { 'exporttype' => 'sqlradius_withdomain' } )
220 <%= $part_export->exporttype %> to <%= $part_export->machine %><BR>
221 <%= include( '/elements/table.html' ) %>
223 <% foreach my $field ( keys %fields ) { %>
225 <%= $fields{$field}->{name} %><BR>
226 <FONT SIZE=-2><%= $fields{$field}->{attrib} %></FONT>
230 <% foreach my $session (
231 @{ $part_export->usage_sessions( $beginning, $ending, $cgi_svc_acct, $ip ) }
234 <% foreach my $field ( keys %fields ) { %>
236 <%= &{ $fields{$field}->{fmt} }( $session->{$field},