X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Findex.html;h=6e846118f357191aa9ac298cd9670ea9245cc4df;hp=5b550dba7d98e5628b1a9c6108572d577a03b61a;hb=ac8410cdb67639afeb84c84e975fffadf3e6cce1;hpb=0fb307c305e4bc2c9c27dc25a3308beae3a4d33c diff --git a/httemplate/index.html b/httemplate/index.html index 5b550dba7..6e846118f 100644 --- a/httemplate/index.html +++ b/httemplate/index.html @@ -1,45 +1,60 @@ -% my $conf = new FS::Conf; - -<% include('/elements/header.html', 'Billing Main' ) %> +<%init>my $debug = $cgi->param('debug'); +% warn time.": header.html\n" if $debug; +% +<& /elements/header.html, mt('Billing Main') &> -<% include('/elements/dashboard-install_welcome.html') %> +% 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; - - Customers I recently added or modified - + + <% mt('Customers I recently added or modified') |h %> + -% 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; - - <% $cust_main->display_custnum %>: <% $cust_main->name %> - + + <% $cust_main->display_custnum %>: <% $cust_main->name |h %> + % if ( $bgcolor eq $bgcolor1 ) { % $bgcolor = $bgcolor2; @@ -47,10 +62,11 @@ % $bgcolor = $bgcolor1; % } % -% } +% } - + -% } +% } +% } -<% include('/elements/footer.html') %> +<& /elements/footer.html &>