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