Bug 13669: followup to add DBIx::RunSQL dependency
[koha.git] / opac / opac-account.pl
blobe02e5f398ecca395e54ee4f157627bae02e449c2
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::Auth;
26 use C4::Output;
27 use warnings;
29 my $query = new CGI;
30 my ( $template, $borrowernumber, $cookie ) = get_template_and_user(
32 template_name => "opac-account.tt",
33 query => $query,
34 type => "opac",
35 authnotrequired => 0,
36 debug => 1,
40 my $borrower = C4::Members::GetMember( borrowernumber => $borrowernumber );
41 $template->param( BORROWER_INFO => $borrower );
43 #get account details
44 my ( $total , $accts, $numaccts) = GetMemberAccountRecords( $borrowernumber );
46 for ( my $i = 0 ; $i < $numaccts ; $i++ ) {
47 $accts->[$i]{'amount'} = sprintf( "%.2f", $accts->[$i]{'amount'} || '0.00');
48 if ( $accts->[$i]{'amount'} >= 0 ) {
49 $accts->[$i]{'amountcredit'} = 1;
51 $accts->[$i]{'amountoutstanding'} =
52 sprintf( "%.2f", $accts->[$i]{'amountoutstanding'} || '0.00' );
53 if ( $accts->[$i]{'amountoutstanding'} >= 0 ) {
54 $accts->[$i]{'amountoutstandingcredit'} = 1;
58 # add the row parity
59 my $num = 0;
60 foreach my $row (@$accts) {
61 $row->{'even'} = 1 if $num % 2 == 0;
62 $row->{'odd'} = 1 if $num % 2 == 1;
63 $num++;
66 $template->param(
67 ACCOUNT_LINES => $accts,
68 total => sprintf( "%.2f", $total ),
69 accountview => 1,
70 message => scalar $query->param('message') || q{},
71 message_value => scalar $query->param('message_value') || q{},
72 payment => scalar $query->param('payment') || q{},
73 payment_error => scalar $query->param('payment-error') || q{},
76 output_html_with_http_headers $query, $cookie, $template->output, undef, { force_no_caching => 1 };