X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Findex.html;fp=httemplate%2Findex.html;h=1a92b45f626deee16c521edbee6324050ed14d37;hp=95d4580bd2d2bf75ad2321c2917eaae9ec682698;hb=e631aea6e8c9dbc41192948468314afd7b806613;hpb=2594960a919709a148ff56c1176e9df6f7176753 diff --git a/httemplate/index.html b/httemplate/index.html index 95d4580bd..1a92b45f6 100644 --- a/httemplate/index.html +++ b/httemplate/index.html @@ -1,66 +1,59 @@ <% my $conf = new FS::Conf; %> -<%= include('/elements/header.html', 'Freeside Main Menu' ) %> - -
- -[ Sales / Customer service ] -[ Bookkeeping / Collections ] -[ Reports ] - - - -
Sales / Customer service
-
Username
-
Domain
-
IP Address
-
-
- -


- - -[ Sales / Customer service ] -[ Bookkeeping / Collections ] -[ Reports ] - - - -
Bookkeeping / Collections
-
Quick payment entry -
-
Credit card #
-
Invoice #
-
Check #
-
- Invoice event reports - -

-
- - - -


- - - -[ Sales / Customer service ] -[ Bookkeeping / Collections ] -[ Reports ] - - - -
Reports
-
- RADIUS sessions

-
SQL query: SELECT
- -
-
- -


+<%= 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; + %> + + + Customers I recently added or modified + + + <% foreach my $custnum ( @custnums ) { %> + <% my $cust_main = qsearchs('cust_main', { 'custnum' => $custnum } ); %> + <% next unless $cust_main; %> + + + <%= $custnum %>: <%= $cust_main->name %> + + + <% + if ( $bgcolor eq $bgcolor1 ) { + $bgcolor = $bgcolor2; + } else { + $bgcolor = $bgcolor1; + } + %> + + <% } %> + + + +<% } %> <%= include('/elements/footer.html') %>