Improving borrowers statitics management

[koha.git] / boraccount.pl

diff --git a/boraccount.pl b/boraccount.pl
index 704f412..332e07d 100755 (executable)
--- a/boraccount.pl
+++ b/boraccount.pl
@@ -1,5 +1,7 @@
 #!/usr/bin/perl
 
+# $Id$
+
 #writen 11/1/2000 by chris@katipo.oc.nz
 #script to display borrowers account details
 
@@ -22,7 +24,10 @@
 # Suite 330, Boston, MA  02111-1307 USA
 
 use strict;
+use C4::Auth;
 use C4::Output;
+use C4::Interface::CGI::Output;
+use C4::Date;
 use CGI;
 use C4::Search;
 use HTML::Template;
@@ -30,8 +35,16 @@ use HTML::Template;
 my $input=new CGI;
 
 my $theme = $input->param('theme'); # only used if allowthemeoverride is set
-my %tmpldata = pathtotemplate ( template => 'boraccount.tmpl', theme => $theme );
-my $template = HTML::Template->new(filename => $tmpldata{'path'}, die_on_bad_params => 0);
+#my %tmpldata = pathtotemplate ( template => 'boraccount.tmpl', theme => $theme );
+#my $template = HTML::Template->new(filename => $tmpldata{'path'}, die_on_bad_params => 0);
+my ($template, $loggedinuser, $cookie)
+    = get_template_and_user({template_name => "boraccount.tmpl",
+                            query => $input,
+                            type => "intranet",
+                            authnotrequired => 0,
+                            flagsrequired => {borrowers => 1},
+                            debug => 1,
+                            });
 
 my $bornum=$input->param('bornum');
 #get borrower details
@@ -39,18 +52,37 @@ my $data=borrdata('',$bornum);
 
 #get account details
 my %bor;
-$bor{'borrowernumber'}=$bornum;                            
-my ($numaccts,$accts,$total)=getboracctrecord('',\%bor);   
-
+$bor{'borrowernumber'}=$bornum;
+my ($numaccts,$accts,$total)=getboracctrecord('',\%bor);
+my $totalcredit;
+if($total <= 0){
+       $totalcredit = 1;
+}
 my @accountrows; # this is for the tmpl-loop
 
+my $toggle;
 for (my $i=0;$i<$numaccts;$i++){
+       if($i%2){
+               $toggle = 0;
+       } else {
+               $toggle = 1;
+       }
+  $accts->[$i]{'toggle'} = $toggle;
   $accts->[$i]{'amount'}+=0.00;
+  if($accts->[$i]{'amount'} <= 0){
+       $accts->[$i]{'amountcredit'} = 1;
+  }
   $accts->[$i]{'amountoutstanding'}+=0.00;
-  my %row = (   'date'              => $accts->[$i]{'date'},
+  if($accts->[$i]{'amountoutstanding'} <= 0){
+       $accts->[$i]{'amountoutstandingcredit'} = 1;
+  }
+  my %row = (   'date'              => format_date($accts->[$i]{'date'}),
+               'amountcredit' => $accts->[$i]{'amountcredit'},
+               'amountoutstandingcredit' => $accts->[$i]{'amountoutstandingcredit'},
+               'toggle' => $accts->[$i]{'toggle'},
                'description'       => $accts->[$i]{'description'},
-               'amount'            => $accts->[$i]{'amount'},
-               'amountoutstanding' => $accts->[$i]{'amountoutstanding'} );
+               'amount'            => sprintf("%.2f",$accts->[$i]{'amount'}),
+               'amountoutstanding' => sprintf("%.2f",$accts->[$i]{'amountoutstanding'}) );
 
   if ($accts->[$i]{'accounttype'} ne 'F' && $accts->[$i]{'accounttype'} ne 'FU'){
     $row{'printtitle'}=1;
@@ -60,12 +92,12 @@ for (my $i=0;$i<$numaccts;$i++){
   push(@accountrows, \%row);
 }
 
-$template->param( startmenumember => startmenu('member'),
-                       endmenumember   => endmenu('member'),
+$template->param(
                        firstname       => $data->{'firstname'},
                        surname         => $data->{'surname'},
                        bornum          => $bornum,
-                       total           => $total,
-                       accounts        => \@accountrows ); 
+                       total           => sprintf("%.2f",$total),
+                       totalcredit => $totalcredit,
+                       accounts        => \@accountrows );
 
-print "Content-Type: text/html\n\n", $template->output;
\ No newline at end of file
+output_html_with_http_headers $input, $cookie, $template->output;