-<% include( 'elements/search.html',
- 'title' => 'Account Search Results',
- 'name' => 'accounts',
+<& elements/svc_Common.html,
+ 'title' => emt('Account Search Results'),
+ 'name' => emt('accounts'),
'query' => $sql_query,
'count_query' => $count_query,
'redirect' => $link,
'color' => \@color,
'style' => \@style,
'footer' => \@footer,
- )
-%>
+ 'html_init' => include('/elements/email-link.html',
+ 'search_hash' => \%search_hash,
+ 'table' => 'svc_acct'
+ ),
+&>
<%once>
#false laziness w/ClientAPI/MyAccount.pm
my %search_hash = ();
my @extra_sql = ();
-my @header = ( '#', 'Service', 'Account' );
-my @fields = ( 'svcnum', 'svc', 'email' );
-my @links = ( $link, $link, $link );
-my $align = 'rll';
-my @color = ( '', '', '' );
-my @style = ( '', '', '' );
+my @header = ( 'Service', 'Account' );
+my @fields = ( 'svc', 'email' );
+my @links = ( $link, $link );
+my $align = 'll';
+my @color = ( '', '' );
+my @style = ( '', '' );
my @footer = ();
my $conf = new FS::Conf;
&& $curuser->access_right('List service passwords') #but if you insist...
)
{
- push @header, 'Password';
+ push @header, emt('Password');
push @fields, 'get_cleartext_password';
push @links, $link;
$align .= 'l';
push @style, '';
}
-push @header, 'Real Name';
+push @header, emt('Real Name');
push @fields, 'finger';
push @links, $link;
$align .= 'l';
#hide the UID, its much less useful these days
if ( $cgi->param('show_uid') ) { #XXX add a checkbox
- push @header, 'UID';
+ push @header, emt('UID');
push @fields, 'uid';
push @links, $link;
$align .= 'l';
push @style, '';
}
-push @header, 'Last Login';
+push @header, emt('Last Login');
push @fields, 'last_login_text';
push @links, $link;
$align .= 'r';
$search_hash{$_} = $cgi->param($_) if length($cgi->param($_));
}
+for (qw( towernum sectornum )) {
+ $search_hash{$_} = [ $cgi->param($_) ] if $cgi->param($_);
+}
+
my $timepermonth = '';
my $orderby = 'ORDER BY svcnum';
if ( $sortby eq 'seconds' ) {
my $tot_time = 0;
- #push @header, 'Time remaining';
- push @header, 'Time';
+ push @header, emt('Time');
push @fields, sub { my $svc_acct = shift;
$tot_time += $svc_acct->seconds;
format_time($svc_acct->seconds);
push @color, '';
push @style, '';
- @footer = ( '', 'Total', '', '', '',
+ @footer = ( 'Total', '', '', '',
sub { format_time($tot_time) }, #time
);
if ( $conf->exists('svc_acct-display_paid_time_remaining') ) {
my $tot_paid_time = 0;
my %tot = ( '30'=>0, '60'=>0, '90'=>0 );
- push @header, 'Paid time', 'Last 30', 'Last 60', 'Last 90';
+ push @header, emt('Paid time'), emt('Last 30'), emt('Last 60'), emt('Last 90');
push @fields,
sub {
my $svc_acct = shift;
;
}
+ push @footer, '', '';
+
}
} elsif ( $cgi->param('magic') =~ /^nologin$/ ) {
}
$cgi->param('username') =~ /^([\w\-\.\&]+)$/; #untaint username_text
- my $username = $1;
+ my $username = lc($1);
- push @username_sql, "username ILIKE '$username'"
+ push @username_sql, "LOWER(username) LIKE '$username'"
if $username_type{'Exact'}
|| $username_type{'Fuzzy'};
- push @username_sql, "username ILIKE '\%$username\%'"
+ push @username_sql, "LOWER(username) LIKE '\%$username\%'"
if $username_type{'Substring'}
|| $username_type{'All'};