X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Findex.html;h=57d85a9fb01a2fcc9eb97224bb750251e54a615e;hp=1a92b45f626deee16c521edbee6324050ed14d37;hb=3ce7691203a7737406bf2d4442f7fd84b81f847e;hpb=15e561850b61b10a92a46d8f3e316d53d4970087 diff --git a/httemplate/index.html b/httemplate/index.html index 1a92b45f6..57d85a9fb 100644 --- a/httemplate/index.html +++ b/httemplate/index.html @@ -1,59 +1,59 @@ -<% my $conf = new FS::Conf; %> -<%= include('/elements/header.html', 'Billing Main' ) %> +% 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; +% -<% - - 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; - <% foreach my $custnum ( @custnums ) { %> - <% my $cust_main = qsearchs('cust_main', { 'custnum' => $custnum } ); %> - <% next unless $cust_main; %> - <%= $custnum %>: <%= $cust_main->name %> + <% $custnum %>: <% $cust_main->name %> +% +% if ( $bgcolor eq $bgcolor1 ) { +% $bgcolor = $bgcolor2; +% } else { +% $bgcolor = $bgcolor1; +% } +% +% } - <% - if ( $bgcolor eq $bgcolor1 ) { - $bgcolor = $bgcolor2; - } else { - $bgcolor = $bgcolor1; - } - %> - - <% } %> +% } -<% } %> -<%= include('/elements/footer.html') %> +<% include('/elements/footer.html') %>