X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Findex.html;h=6e846118f357191aa9ac298cd9670ea9245cc4df;hp=1a92b45f626deee16c521edbee6324050ed14d37;hb=3f2a7b01b59902faed5767d81e2959e131bdbdfd;hpb=e631aea6e8c9dbc41192948468314afd7b806613

diff --git a/httemplate/index.html b/httemplate/index.html
index 1a92b45f6..6e846118f 100644
--- a/httemplate/index.html
+++ b/httemplate/index.html
@@ -1,59 +1,72 @@
-<% 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') %>
-
+<%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 &>