blob: 1a92b45f626deee16c521edbee6324050ed14d37 (
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
55
56
57
58
59
|
<% my $conf = new FS::Conf; %>
<%= include('/elements/header.html', 'Billing Main' ) %>
<%
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;
%>
<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') %>
|
