summaryrefslogtreecommitdiff
path: root/httemplate/index.html
blob: 60ab26f8699d0dbbb4c9fbdbc1233827ef41c7e2 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
% 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;

  <TR>
    <TH CLASS="grid" BGCOLOR="#cccccc" COLSPAN=1>Customers I recently added or modified</TH>
  </TR>

% 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 %>"><% $custnum %>: <% $cust_main->name %></A></TD>
    </TR>

%       if ( $bgcolor eq $bgcolor1 ) {
%          $bgcolor = $bgcolor2;
%        } else {
%          $bgcolor = $bgcolor1;
%        }
%    
% } 

  </TABLE>

% } 

<% include('/elements/footer.html') %>