-<% 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
die "access denied" unless $curuser->access_right('List services');
+my %cust_pkg_cache;
+
my $link = [ "${p}view/svc_acct.cgi?", 'svcnum' ];
my $link_cust = sub {
my $svc_acct = shift;
&& $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';
+my $addl_from = '';
if ( $cgi->param('magic') =~ /^(all|unlinked)$/ ) {
$search_hash{'unlinked'} = 1
if ( $sortby eq 'seconds' ) {
my $tot_time = 0;
- #push @header, 'Time remaining';
- push @header, 'Time';
- push @fields, sub { my $svc_acct = shift;
- $tot_time += $svc_acct->seconds;
- format_time($svc_acct->seconds);
- };
+ push @header, emt('Time');
+
+ if ( $conf->exists('svc_acct-display_paid_time_remaining') ) {
+ push @fields, sub { my $svc_acct = shift;
+ my $seconds = $svc_acct->seconds;
+ my $cust_pkg = $svc_acct->cust_svc->cust_pkg;
+ my $part_pkg = $cust_pkg->part_pkg;
+
+ $tot_time += $svc_acct->seconds;
+
+ $timepermonth = $part_pkg->option('seconds');
+ $timepermonth = $timepermonth / $part_pkg->freq
+ if $part_pkg->freq =~ /^\d+$/ && $part_pkg->freq != 0;
+ my $recur = $part_pkg->base_recur($cust_pkg);
+
+ return format_time($seconds)
+ unless $timepermonth && $recur;
+
+ format_time($seconds).
+ sprintf(' (%.2fx monthly)', $seconds / $timepermonth );
+
+ };
+ } else {
+ push @fields, sub { my $svc_acct = shift;
+ $tot_time += $svc_acct->seconds;
+ format_time($svc_acct->seconds);
+ };
+ }
+
push @links, '';
$align .= 'r';
push @color, '';
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;
} elsif ( $cgi->param('svcpart') ) {
$orderby = "ORDER BY uid";
#$orderby = "ORDER BY svcnum";
+ if ( defined($cgi->param('cancelled')) ) {
+ $search_hash{'cancelled'} = $cgi->param('cancelled') ? 1 : 0;
+ }
} else {
$orderby = "ORDER BY uid";
}
+push @header, emt('Pkg. Status');
+push @fields, sub {
+ $cust_pkg_cache{$_[0]->svcnum} ||= $_[0]->cust_svc->cust_pkg;
+ return '' unless $cust_pkg_cache{$_[0]->svcnum};
+ $cust_pkg_cache{$_[0]->svcnum}->ucfirst_status;
+};
+push @links, '';
+$align .= 'r';
+push @color, sub {
+ $cust_pkg_cache{$_[0]->svcnum} ||= $_[0]->cust_svc->cust_pkg;
+ return '' unless $cust_pkg_cache{$_[0]->svcnum};
+ my $c = FS::cust_pkg::statuscolors;
+ $c->{$cust_pkg_cache{$_[0]->svcnum}->status };
+};
+push @style, 'b';
+
push @header, FS::UI::Web::cust_header($cgi->param('cust_fields'));
push @fields, \&FS::UI::Web::cust_fields,
push @links, map { $_ ne 'Cust. Status' ? $link_cust : '' }
$search_hash{'order_by'} = $orderby;
$search_hash{'where'} = \@extra_sql;
+$search_hash{'addl_from'} = $addl_from;
my $sql_query = FS::svc_acct->search(\%search_hash);
my $count_query = delete($sql_query->{'count_query'});