Bug 14246: Add borrowernumber, altered SQL
[koha.git] / opac / opac-account.pl
blob02bd4dce44105cd8fde3e2d545ee1682a9f487e4
1 #!/usr/bin/perl
3 # Copyright Katipo Communications 2002
4 # Copyright Biblibre 2007,2010
6 # This file is part of Koha.
8 # Koha is free software; you can redistribute it and/or modify it
9 # under the terms of the GNU General Public License as published by
10 # the Free Software Foundation; either version 3 of the License, or
11 # (at your option) any later version.
13 # Koha is distributed in the hope that it will be useful, but
14 # WITHOUT ANY WARRANTY; without even the implied warranty of
15 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
16 # GNU General Public License for more details.
18 # You should have received a copy of the GNU General Public License
19 # along with Koha; if not, see <http://www.gnu.org/licenses>.
22 use strict;
23 use CGI qw ( -utf8 );
24 use C4::Members;
25 use C4::Circulation;
26 use C4::Auth;
27 use C4::Output;
28 use warnings;
30 my $query = new CGI;
31 my ( $template, $borrowernumber, $cookie ) = get_template_and_user(
33 template_name => "opac-account.tt",
34 query => $query,
35 type => "opac",
36 authnotrequired => 0,
37 debug => 1,
41 # get borrower information ....
42 my $borr = GetMemberDetails( $borrowernumber );
43 my @bordat;
44 $bordat[0] = $borr;
46 $template->param( BORROWER_INFO => \@bordat );
48 #get account details
49 my ( $total , $accts, $numaccts) = GetMemberAccountRecords( $borrowernumber );
51 for ( my $i = 0 ; $i < $numaccts ; $i++ ) {
52 $accts->[$i]{'amount'} = sprintf( "%.2f", $accts->[$i]{'amount'} || '0.00');
53 if ( $accts->[$i]{'amount'} >= 0 ) {
54 $accts->[$i]{'amountcredit'} = 1;
56 $accts->[$i]{'amountoutstanding'} =
57 sprintf( "%.2f", $accts->[$i]{'amountoutstanding'} || '0.00' );
58 if ( $accts->[$i]{'amountoutstanding'} >= 0 ) {
59 $accts->[$i]{'amountoutstandingcredit'} = 1;
63 # add the row parity
64 my $num = 0;
65 foreach my $row (@$accts) {
66 $row->{'even'} = 1 if $num % 2 == 0;
67 $row->{'odd'} = 1 if $num % 2 == 1;
68 $num++;
71 $template->param (
72 ACCOUNT_LINES => $accts,
73 total => sprintf( "%.2f", $total ),
74 accountview => 1
77 output_html_with_http_headers $query, $cookie, $template->output, undef, { force_no_caching => 1 };