blob: 6e846118f357191aa9ac298cd9670ea9245cc4df (
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
60
61
62
63
64
65
66
67
68
69
70
71
72
|
<%init>my $debug = $cgi->param('debug');</%init>
% warn time.": header.html\n" if $debug;
%
<& /elements/header.html, mt('Billing Main') &>
% warn time.": dashboard-install_welcome.html\n" if $debug;
%
<& /elements/dashboard-install_welcome.html &>
% warn time.": dashboard-toplist.html\n" if $debug;
%
<& /elements/dashboard-toplist.html &>
% 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( $curuser->usernum, $curuser->username ) or die $sth->errstr;
%
% my %saw = ();
% my @custnums = grep { !$saw{$_}++ } map $_->[0], @{ $sth->fetchall_arrayref };
%
% @custnums = splice(@custnums, 0, $numcust);
%
% if ( @custnums ) {
% warn time.": displaying recently changed customers\n" if $debug;
<& /elements/table-grid.html &>
% my $bgcolor1 = '#eeeeee';
% my $bgcolor2 = '#ffffff';
% my $bgcolor = $bgcolor2;
<TR>
<TH CLASS="grid" BGCOLOR="#cccccc" COLSPAN=1><% mt('Customers I recently added or modified') |h %></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 %>"><% $cust_main->display_custnum %>: <% $cust_main->name |h %></A></TD>
</TR>
% if ( $bgcolor eq $bgcolor1 ) {
% $bgcolor = $bgcolor2;
% } else {
% $bgcolor = $bgcolor1;
% }
%
% }
</TABLE>
% }
% }
<& /elements/footer.html &>
|
