From e631aea6e8c9dbc41192948468314afd7b806613 Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 22 May 2006 00:45:37 +0000 Subject: 1.7.0? why not! --- httemplate/index.html | 117 ++++++++++++++++++++++++-------------------------- 1 file changed, 55 insertions(+), 62 deletions(-) (limited to 'httemplate/index.html') 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') %> -- cgit v1.2.1