members/boraccount.pl

   1 #!/usr/bin/perl
   2
   3
   4 #written 11/1/2000 by chris@katipo.oc.nz
   5 #script to display borrowers account details
   6
   7
   8 # Copyright 2000-2002 Katipo Communications
   9 #
  10 # This file is part of Koha.
  11 #
  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.
  16 #
  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.
  21 #
  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>.
  24
  25 use Modern::Perl;
  26
  27 use C4::Auth;
  28 use C4::Output;
  29 use CGI qw ( -utf8 );
  30 use C4::Members;
  31 use C4::Accounts;
  32 use C4::Members::Attributes qw(GetBorrowerAttributes);
  33 use Koha::Patrons;
  34 use Koha::Patron::Categories;
  35
  36 my $input=new CGI;
  37
  38
  39 my ($template, $loggedinuser, $cookie) = get_template_and_user(
  40     {
  41         template_name   => "members/boraccount.tt",
  42         query           => $input,
  43         type            => "intranet",
  44         authnotrequired => 0,
  45         flagsrequired   => { borrowers     => 'edit_borrowers',
  46                              updatecharges => 'remaining_permissions'},
  47         debug           => 1,
  48     }
  49 );
  50
  51 my $borrowernumber = $input->param('borrowernumber');
  52 my $action = $input->param('action') || '';
  53
  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;
  59 }
  60
  61 output_and_exit_if_error( $input, $cookie, $template, { module => 'members', logged_in_user => $logged_in_user, current_patron => $patron } );
  62
  63 if ( $action eq 'reverse' ) {
  64   ReversePayment( scalar $input->param('accountlines_id') );
  65 }
  66 elsif ( $action eq 'void' ) {
  67     my $payment_id = scalar $input->param('accountlines_id');
  68     my $payment    = Koha::Account::Lines->find( $payment_id );
  69     $payment->void();
  70 }
  71
  72 #get account details
  73 my $total = $patron->account->balance;
  74
  75 my $accts = Koha::Account::Lines->search(
  76     { borrowernumber => $patron->borrowernumber },
  77     { order_by       => { -desc => 'accountlines_id' } }
  78 );
  79
  80 my $totalcredit;
  81 if($total <= 0){
  82         $totalcredit = 1;
  83 }
  84
  85 my $reverse_col = 0; # Flag whether we need to show the reverse column
  86 my @accountlines;
  87 while ( my $line = $accts->next ) {
  88     # FIXME We should pass the $accts iterator to the template and do this formatting part there
  89     my $accountline = $line->unblessed;
  90     $accountline->{amount} += 0.00;
  91     if ($accountline->{amount} <= 0 ) {
  92         $accountline->{amountcredit} = 1;
  93     }
  94     $accountline->{amountoutstanding} += 0.00;
  95     if ( $accountline->{amountoutstanding} <= 0 ) {
  96         $accountline->{amountoutstandingcredit} = 1;
  97     }
  98
  99     $accountline->{amount} = sprintf '%.2f', $accountline->{amount};
 100     $accountline->{amountoutstanding} = sprintf '%.2f', $accountline->{amountoutstanding};
 101     if ($accountline->{amount} < 0) {
 102         $accountline->{payment} = 1
 103           if ( $accountline->{accounttype} =~ /^Pay/ );
 104
 105         $reverse_col = 1;
 106     }
 107
 108     if ( $accountline->{itemnumber} ) {
 109         # Because we will not have access to the object from the template
 110         $accountline->{item} = $line->item;
 111     }
 112     push @accountlines, $accountline;
 113 }
 114
 115 if (C4::Context->preference('ExtendedPatronAttributes')) {
 116     my $attributes = GetBorrowerAttributes($borrowernumber);
 117     $template->param(
 118         ExtendedPatronAttributes => 1,
 119         extendedattributes => $attributes
 120     );
 121 }
 122
 123 $template->param(
 124     patron              => $patron,
 125     finesview           => 1,
 126     total               => sprintf("%.2f",$total),
 127     totalcredit         => $totalcredit,
 128     reverse_col         => $reverse_col,
 129     accounts            => \@accountlines,
 130 );
 131
 132 output_html_with_http_headers $input, $cookie, $template->output;