X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Findex.html;h=7c21e45054663e000e2da971f12232f40e8707c1;hb=refs%2Fheads%2F3.x-pre;hp=71926aa4ea5d8a47118f8ff690b0e259336ef406;hpb=a10c9fb8cece00fc3b996f56c61b6841e93c1551;p=freeside.git diff --git a/httemplate/index.html b/httemplate/index.html index 71926aa4e..7c21e4505 100644 --- a/httemplate/index.html +++ b/httemplate/index.html @@ -11,43 +11,49 @@ % <& /elements/dashboard-toplist.html &> -% warn time.": fetching recently changed customers\n" if $debug; +% my $curuser = $FS::CurrentUser::CurrentUser; +% my $numcust = $curuser->option('dashboard_customers'); +% $numcust ||= 10 unless $numcust =~ /^\s*0+\s*$/; +% if ( $numcust ) { % -% 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; +% warn time.": fetching recently changed customers\n" if $debug; % -% $sth->execute( getotaker() ) or die $sth->errstr; +% 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 = ? +% AND ". $curuser->agentnums_sql( table=>'cust_main' ). +% " ORDER BY history_date desc LIMIT 1000" # LIMIT 10 +% ) or die dbh->errstr; % -% my %saw = (); -% my @custnums = grep { !$saw{$_}++ } map $_->[0], @{ $sth->fetchall_arrayref }; +% $sth->execute( getotaker() ) or die $sth->errstr; % -% @custnums = splice(@custnums, 0, 10); +% my %saw = (); +% my @custnums = grep { !$saw{$_}++ } map $_->[0], @{ $sth->fetchall_arrayref }; % -% if ( @custnums ) { -% warn time.": displaying recently changed customers\n" if $debug; +% @custnums = splice(@custnums, 0, $numcust); +% +% if ( @custnums ) { +% warn time.": displaying recently changed customers\n" if $debug; - <& /elements/table-grid.html &> + <& /elements/table-grid.html &> -% my $bgcolor1 = '#eeeeee'; +% my $bgcolor1 = '#eeeeee'; % my $bgcolor2 = '#ffffff'; % my $bgcolor = $bgcolor2; -