-% my $conf = new FS::Conf;
+<%init>my $debug = $cgi->param('debug');</%init>
+% warn time.": header.html\n" if $debug;
+%
+<& /elements/header.html, mt('Billing Main') &>
-<% include('/elements/header.html', 'Billing Main' ) %>
+% warn time.": dashboard-install_welcome.html\n" if $debug;
+%
+<& /elements/dashboard-install_welcome.html &>
-<% include('/elements/dashboard-toplist.html') %>
+% warn time.": dashboard-toplist.html\n" if $debug;
+%
+<& /elements/dashboard-toplist.html &>
-% my $sth = dbh->prepare(
-% #"SELECT DISTINCT custnum FROM h_cust_main JOIN cust_main USING ( custnum )
-% "SELECT custnum FROM h_cust_main JOIN cust_main USING ( custnum )
-% WHERE ( history_action = 'insert' OR history_action = 'replace_new' )
-% AND history_user = ?
-% ORDER BY history_date desc" # LIMIT 10
-% ) or die dbh->errstr;
+% my $curuser = $FS::CurrentUser::CurrentUser;
+% my $numcust = $curuser->option('dashboard_customers');
+% $numcust ||= 10 unless $numcust =~ /^\s*0+\s*$/;
+% if ( $numcust ) {
+%
+% warn time.": fetching recently changed customers\n" if $debug;
+%
+% my $sth = dbh->prepare(
+% #"SELECT DISTINCT custnum FROM h_cust_main JOIN cust_main USING ( custnum )
+% "SELECT custnum FROM h_cust_main JOIN cust_main USING ( custnum )
+% WHERE ( history_action = 'insert' OR history_action = 'replace_new' )
+% AND ( history_usernum = ? OR history_user = ? )
+% AND ". $curuser->agentnums_sql( table=>'cust_main' ).
+% " ORDER BY history_date desc LIMIT 1000" # LIMIT 10
+% ) or die dbh->errstr;
+%
%
-% $sth->execute( getotaker() ) or die $sth->errstr;
+% $sth->execute( $curuser->usernum, $curuser->username ) or die $sth->errstr;
%
-% my %saw = ();
-% my @custnums = grep { !$saw{$_}++ } map $_->[0], @{ $sth->fetchall_arrayref };
+% my %saw = ();
+% my @custnums = grep { !$saw{$_}++ } map $_->[0], @{ $sth->fetchall_arrayref };
%
-% @custnums = splice(@custnums, 0, 10);
+% @custnums = splice(@custnums, 0, $numcust);
%
-% if ( @custnums ) {
+% if ( @custnums ) {
+% warn time.": displaying recently changed customers\n" if $debug;
- <% include('/elements/table-grid.html') %>
+ <& /elements/table-grid.html &>
-% my $bgcolor1 = '#eeeeee';
+% my $bgcolor1 = '#eeeeee';
% my $bgcolor2 = '#ffffff';
% my $bgcolor = $bgcolor2;
- <TR>
- <TH CLASS="grid" BGCOLOR="#cccccc" COLSPAN=1>Customers I recently added or modified</TH>
- </TR>
+ <TR>
+ <TH CLASS="grid" BGCOLOR="#cccccc" COLSPAN=1><% mt('Customers I recently added or modified') |h %></TH>
+ </TR>
-% foreach my $custnum ( @custnums ) {
-% my $cust_main = qsearchs('cust_main', { 'custnum' => $custnum } );
-% next unless $cust_main;
+% foreach my $custnum ( @custnums ) {
+% my $cust_main = qsearchs('cust_main', { 'custnum' => $custnum } );
+% next unless $cust_main;
- <TR>
- <TD CLASS="grid" BGCOLOR="<% $bgcolor %>"><A HREF="view/cust_main.cgi?<% $custnum %>"><% $cust_main->display_custnum %>: <% $cust_main->name %></A></TD>
- </TR>
+ <TR>
+ <TD CLASS="grid" BGCOLOR="<% $bgcolor %>"><A HREF="view/cust_main.cgi?<% $custnum %>"><% $cust_main->display_custnum %>: <% $cust_main->name |h %></A></TD>
+ </TR>
% if ( $bgcolor eq $bgcolor1 ) {
% $bgcolor = $bgcolor2;
% $bgcolor = $bgcolor1;
% }
%
-% }
+% }
- </TABLE>
+ </TABLE>
-% }
+% }
+% }
-<% include('/elements/footer.html') %>
+<& /elements/footer.html &>