Bug 18309: Fix INSERT sql query in unimarc_framework_DEFAULT.sql
[koha.git] / members / boraccount.pl
blob5ccfb0c04d590608b50740854bc142e5ca48ca12
1 #!/usr/bin/perl
4 #written 11/1/2000 by chris@katipo.oc.nz
5 #script to display borrowers account details
8 # Copyright 2000-2002 Katipo Communications
10 # This file is part of Koha.
12 # Koha is free software; you can redistribute it and/or modify it
13 # under the terms of the GNU General Public License as published by
14 # the Free Software Foundation; either version 3 of the License, or
15 # (at your option) any later version.
17 # Koha is distributed in the hope that it will be useful, but
18 # WITHOUT ANY WARRANTY; without even the implied warranty of
19 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
20 # GNU General Public License for more details.
22 # You should have received a copy of the GNU General Public License
23 # along with Koha; if not, see <http://www.gnu.org/licenses>.
25 use Modern::Perl;
27 use C4::Auth;
28 use C4::Output;
29 use CGI qw ( -utf8 );
30 use C4::Members;
31 use C4::Accounts;
32 use Koha::Patrons;
33 use Koha::Patron::Categories;
35 my $input=new CGI;
38 my ($template, $loggedinuser, $cookie) = get_template_and_user(
40 template_name => "members/boraccount.tt",
41 query => $input,
42 type => "intranet",
43 authnotrequired => 0,
44 flagsrequired => { borrowers => 'edit_borrowers',
45 updatecharges => 'remaining_permissions'},
46 debug => 1,
50 my $borrowernumber = $input->param('borrowernumber');
51 my $payment_id = $input->param('payment_id');
52 my $action = $input->param('action') || '';
54 my $logged_in_user = Koha::Patrons->find( $loggedinuser ) or die "Not logged in";
55 my $patron = Koha::Patrons->find( $borrowernumber );
56 unless ( $patron ) {
57 print $input->redirect("/cgi-bin/koha/circ/circulation.pl?borrowernumber=$borrowernumber");
58 exit;
61 output_and_exit_if_error( $input, $cookie, $template, { module => 'members', logged_in_user => $logged_in_user, current_patron => $patron } );
63 if ( $action eq 'void' ) {
64 my $payment_id = scalar $input->param('accountlines_id');
65 my $payment = Koha::Account::Lines->find( $payment_id );
66 $payment->void();
69 #get account details
70 my $total = $patron->account->balance;
72 my @accountlines = Koha::Account::Lines->search(
73 { borrowernumber => $patron->borrowernumber },
74 { order_by => { -desc => 'accountlines_id' } }
77 my $totalcredit;
78 if($total <= 0){
79 $totalcredit = 1;
82 $template->param(
83 patron => $patron,
84 finesview => 1,
85 total => sprintf("%.2f",$total),
86 totalcredit => $totalcredit,
87 accounts => \@accountlines,
88 payment_id => $payment_id,
91 output_html_with_http_headers $input, $cookie, $template->output;