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 if ( $patron->is_child ) {
  73     my $patron_categories = Koha::Patron::Categories->search_limited({ category_type => 'A' }, {order_by => ['categorycode']});
  74     $template->param( 'CATCODE_MULTI' => 1) if $patron_categories->count > 1;
  75     $template->param( 'catcode' => $patron_categories->next->categorycode )  if $patron_categories->count == 1;
  76 }
  77
  78 #get account details
  79 my $total = $patron->account->balance;
  80
  81 my $accts = Koha::Account::Lines->search(
  82     { borrowernumber => $patron->borrowernumber },
  83     { order_by       => { -desc => 'accountlines_id' } }
  84 );
  85
  86 my $totalcredit;
  87 if($total <= 0){
  88         $totalcredit = 1;
  89 }
  90
  91 my $reverse_col = 0; # Flag whether we need to show the reverse column
  92 my @accountlines;
  93 while ( my $line = $accts->next ) {
  94     # FIXME We should pass the $accts iterator to the template and do this formatting part there
  95     my $accountline = $line->unblessed;
  96     $accountline->{amount} += 0.00;
  97     if ($accountline->{amount} <= 0 ) {
  98         $accountline->{amountcredit} = 1;
  99     }
 100     $accountline->{amountoutstanding} += 0.00;
 101     if ( $accountline->{amountoutstanding} <= 0 ) {
 102         $accountline->{amountoutstandingcredit} = 1;
 103     }
 104
 105     $accountline->{amount} = sprintf '%.2f', $accountline->{amount};
 106     $accountline->{amountoutstanding} = sprintf '%.2f', $accountline->{amountoutstanding};
 107     if ($accountline->{accounttype} =~ /^Pay/) {
 108         $accountline->{payment} = 1;
 109         $reverse_col = 1;
 110     }
 111
 112     if ( $accountline->{itemnumber} ) {
 113         # Because we will not have access to the object from the template
 114         $accountline->{item} = $line->item;
 115     }
 116     push @accountlines, $accountline;
 117 }
 118
 119 if (C4::Context->preference('ExtendedPatronAttributes')) {
 120     my $attributes = GetBorrowerAttributes($borrowernumber);
 121     $template->param(
 122         ExtendedPatronAttributes => 1,
 123         extendedattributes => $attributes
 124     );
 125 }
 126
 127 $template->param(
 128     patron              => $patron,
 129     finesview           => 1,
 130     total               => sprintf("%.2f",$total),
 131     totalcredit         => $totalcredit,
 132     reverse_col         => $reverse_col,
 133     accounts            => \@accountlines,
 134 );
 135
 136 output_html_with_http_headers $input, $cookie, $template->output;