1 <% include( '/elements/header.html', 'RADIUS Sessions',
2 include('/elements/menubar.html',
3 'Main menu' => $p, # popurl(2),
13 % #sort of false laziness w/cust_pay.cgi
16 % if ( $cgi->param('beginning')
17 % && $cgi->param('beginning') =~ /^([ 0-9\-\/]{0,10})$/ ) {
18 % $beginning = str2time($1);
20 % if ( $cgi->param('ending')
21 % && $cgi->param('ending') =~ /^([ 0-9\-\/]{0,10})$/ ) {
22 % $ending = str2time($1) + 86399;
24 % if ( $cgi->param('begin') && $cgi->param('begin') =~ /^(\d+)$/ ) {
27 % if ( $cgi->param('end') && $cgi->param('end') =~ /^(\d+)$/ ) {
31 % my $cgi_svc_acct = '';
32 % if ( $cgi->param('svcnum') =~ /^(\d+)$/ ) {
33 % $cgi_svc_acct = qsearchs( 'svc_acct', { 'svcnum' => $1 } );
34 % } elsif ( $cgi->param('username') =~ /^([^@]+)\@([^@]+)$/ ) {
35 % my %search = { 'username' => $1 };
36 % my $svc_domain = qsearchs('svc_domain', { 'domain' => $2 } );
37 % if ( $svc_domain ) {
38 % $search{'domsvc'} = $svc_domain->svcnum;
40 % delete $search{'username'};
42 % $cgi_svc_acct = qsearchs( 'svc_acct', \%search )
44 % } elsif ( $cgi->param('username') =~ /^(.+)$/ ) {
45 % $cgi_svc_acct = qsearchs( 'svc_acct', { 'username' => $1 } );
49 % if ( $cgi->param('ip') =~ /^((\d+\.){3}\d+)$/ ) {
53 % my $prefix = $cgi->param('prefix');
55 % if ( $prefix =~ /^(\d+)$/ ) {
57 % $prefix = "011$prefix" unless $prefix =~ /^1/;
63 % # field formatting subroutines
66 % my %user2svc_acct = ();
67 % my $user_format = sub {
68 % my ( $user, $session, $part_export ) = @_;
71 % if ( exists $user2svc_acct{$user} ) {
72 % $svc_acct = $user2svc_acct{$user};
75 % if ( $part_export->exporttype eq 'sqlradius_withdomain' ) {
77 % if ( $user =~ /^([^@]+)\@([^@]+)$/ ) {
78 % $search{'username'} = $1;
81 % $search{'username'} = $user;
82 % $domain = $session->{'realm'};
84 % my $svc_domain = qsearchs('svc_domain', { 'domain' => $domain } );
85 % if ( $svc_domain ) {
86 % $search{'domsvc'} = $svc_domain->svcnum;
88 % delete $search{'username'};
90 % } elsif ( $part_export->exporttype eq 'sqlradius' ) {
91 % $search{'username'} = $user;
93 % die 'unknown export type '. $part_export->exporttype.
94 % " for $part_export\n";
96 % if ( keys %search ) {
98 % grep { qsearchs( 'export_svc', {
99 % 'exportnum' => $part_export->exportnum,
100 % 'svcpart' => $_->cust_svc->svcpart,
102 % } qsearch( 'svc_acct', \%search );
104 % warn 'multiple svc_acct records for user $user found; '.
105 % 'using first arbitrarily'
106 % if scalar(@svc_acct) > 1;
107 % $user2svc_acct{$user} = $svc_acct = shift @svc_acct;
113 % my $svcnum = $svc_acct->svcnum;
114 % qq(<A HREF="${p}view/svc_acct.cgi?$svcnum"><B>$user</B></A>);
121 % my $customer_format = sub {
122 % my( $unused, $session ) = @_;
123 % return ' ' unless exists $user2svc_acct{$session->{'username'}};
124 % my $svc_acct = $user2svc_acct{$session->{'username'}};
125 % my $cust_pkg = $svc_acct->cust_svc->cust_pkg;
126 % return ' ' unless $cust_pkg;
127 % my $cust_main = $cust_pkg->cust_main;
129 % qq!<A HREF="${p}view/cust_main.cgi?!. $cust_main->custnum. '">'.
130 % $cust_pkg->cust_main->name. '</A>';
133 % my $time_format = sub {
135 % return ' ' if $time == 0;
136 % my $pretty = time2str('%T%P %a %b %o %Y', $time );
137 % $pretty =~ s/ (\d)(st|dn|rd|th)/$1$2/;
141 % my $duration_format = sub {
142 % my $seconds = shift;
143 % my $hour = int($seconds/3600);
144 % my $min = int( ($seconds%3600) / 60 );
145 % my $sec = $seconds%60;
146 % '<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0>'.
147 % '<TR><TD ALIGN="right">'.
148 % ( $hour ? "<B>$hour</B>h" : ' ' ).
149 % '</TD><TD ALIGN="right">'.
150 % ( ( $hour || $min ) ? "<B>$min</B>m" : ' ' ).
151 % '</TD><TD ALIGN="right">'.
153 % '</TD></TR></TABLE>';
156 % my $octets_format = sub {
157 % my $octets = shift;
158 % my $megs = $octets / 1048576;
159 % sprintf('<B>%.3f</B> megs', $megs);
160 % #my $gigs = $octets / 1073741824
161 % #sprintf('<B>%.3f</B> gigabytes', $gigs);
168 % tie my %fields, 'Tie::IxHash',
171 % attrib => 'UserName',
172 % fmt => $user_format,
181 % name => 'Customer',
183 % fmt => $customer_format,
186 % 'framedipaddress' => {
187 % name => 'IP Address',
188 % attrib => 'Framed-IP-Address',
189 % fmt => sub { my $ip = shift;
190 % length($ip) ? $ip : ' ';
194 % 'acctstarttime' => {
195 % name => 'Start time',
196 % attrib => 'Acct-Start-Time',
197 % fmt => $time_format,
200 % 'acctstoptime' => {
201 % name => 'End time',
202 % attrib => 'Acct-Stop-Time',
203 % fmt => $time_format,
206 % 'acctsessiontime' => {
207 % name => 'Duration',
208 % attrib => 'Acct-Session-Time',
209 % fmt => $duration_format,
212 % 'acctinputoctets' => {
213 % name => 'Upload', # (from user)',
214 % attrib => 'Acct-Input-Octets',
215 % fmt => $octets_format,
218 % 'acctoutputoctets' => {
219 % name => 'Download', # (to user)',
220 % attrib => 'Acct-Output-Octets',
221 % fmt => $octets_format,
225 % $fields{$_}->{fmt} ||= sub { length($_[0]) ? shift : ' '; }
226 % foreach keys %fields;
229 % # and finally, display the thing
232 % foreach my $part_export (
233 % #grep $_->can('usage_sessions'), qsearch( 'part_export' )
234 % qsearch( 'part_export', { 'exporttype' => 'sqlradius' } ),
235 % qsearch( 'part_export', { 'exporttype' => 'sqlradius_withdomain' } )
237 % %user2svc_acct = ();
239 % my $efields = tie my %efields, 'Tie::IxHash', %fields;
240 % delete $efields{'framedipaddress'} if $part_export->option('hide_ip');
241 % if ( $part_export->option('hide_data') ) {
242 % delete $efields{$_} foreach qw(acctinputoctets acctoutputoctets);
244 % if ( $part_export->option('show_called_station') ) {
245 % $efields->Splice(1, 0,
246 % 'calledstationid' => {
247 % 'name' => 'Destination',
248 % 'attrib' => 'Called-Station-ID',
250 % sub { length($_[0]) ? shift : ' '; },
259 <% $part_export->exporttype %> to <% $part_export->machine %><BR>
260 <% include( '/elements/table.html' ) %>
262 % foreach my $field ( keys %efields ) {
265 <% $efields{$field}->{name} %><BR>
266 <FONT SIZE=-2><% $efields{$field}->{attrib} %></FONT>
271 % foreach my $session (
272 % @{ $part_export->usage_sessions(
273 % $beginning, $ending, $cgi_svc_acct, $ip, $prefix, ) }
278 % foreach my $field ( keys %efields ) {
280 <TD ALIGN="<% $efields{$field}->{align} %>">
281 <% &{ $efields{$field}->{fmt} }( $session->{$field},