% my $conf = new FS::Conf; <% include('/elements/header.html', 'Billing Main' ) %> <% include('/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; % % $sth->execute( getotaker() ) or die $sth->errstr; % % my %saw = (); % my @custnums = grep { !$saw{$_}++ } map $_->[0], @{ $sth->fetchall_arrayref }; % % @custnums = splice(@custnums, 0, 10); % % if ( @custnums ) { <% include('/elements/table-grid.html') %> % my $bgcolor1 = '#eeeeee'; % my $bgcolor2 = '#ffffff'; % my $bgcolor = $bgcolor2;