X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Findex.html;h=6e846118f357191aa9ac298cd9670ea9245cc4df;hp=c813991f9faa8f86b099ba27e5382d72b3c8c111;hb=833cfe5c9938d33c3e6b97ed610c25a7afa6eb04;hpb=40a7b3dc653e099f7bd0bd762b649b04c4432db2 diff --git a/httemplate/index.html b/httemplate/index.html index c813991f9..6e846118f 100644 --- a/httemplate/index.html +++ b/httemplate/index.html @@ -1,43 +1,60 @@ -% my $conf = new FS::Conf; +<%init>my $debug = $cgi->param('debug'); +% 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; - - 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; @@ -45,10 +62,11 @@ % $bgcolor = $bgcolor1; % } % -% } +% } - + -% } +% } +% } -<% include('/elements/footer.html') %> +<& /elements/footer.html &>