members/boraccount.pl

   1 #!/usr/bin/perl
   2
   3
   4 #writen 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 under the
  13 # terms of the GNU General Public License as published by the Free Software
  14 # Foundation; either version 2 of the License, or (at your option) any later
  15 # version.
  16 #
  17 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
  18 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
  19 # A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
  20 #
  21 # You should have received a copy of the GNU General Public License along
  22 # with Koha; if not, write to the Free Software Foundation, Inc.,
  23 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
  24
  25 use strict;
  26 use warnings;
  27
  28 use C4::Auth;
  29 use C4::Output;
  30 use CGI qw ( -utf8 );
  31 use C4::Members;
  32 use C4::Branch;
  33 use C4::Accounts;
  34 use C4::Members::Attributes qw(GetBorrowerAttributes);
  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     => 1,
  46                              updatecharges => 'remaining_permissions'},
  47         debug           => 1,
  48     }
  49 );
  50
  51 my $borrowernumber=$input->param('borrowernumber');
  52 my $action = $input->param('action') || '';
  53
  54 #get borrower details
  55 my $data=GetMember('borrowernumber' => $borrowernumber);
  56
  57 if ( $action eq 'reverse' ) {
  58   ReversePayment( $input->param('accountlines_id') );
  59 }
  60
  61 if ( $data->{'category_type'} eq 'C') {
  62    my  ( $catcodes, $labels ) =  GetborCatFromCatType( 'A', 'WHERE category_type = ?' );
  63    my $cnt = scalar(@$catcodes);
  64    $template->param( 'CATCODE_MULTI' => 1) if $cnt > 1;
  65    $template->param( 'catcode' =>    $catcodes->[0])  if $cnt == 1;
  66 }
  67
  68 #get account details
  69 my ($total,$accts,undef)=GetMemberAccountRecords($borrowernumber);
  70 my $totalcredit;
  71 if($total <= 0){
  72         $totalcredit = 1;
  73 }
  74
  75 my $reverse_col = 0; # Flag whether we need to show the reverse column
  76 foreach my $accountline ( @{$accts}) {
  77     $accountline->{amount} += 0.00;
  78     if ($accountline->{amount} <= 0 ) {
  79         $accountline->{amountcredit} = 1;
  80     }
  81     $accountline->{amountoutstanding} += 0.00;
  82     if ( $accountline->{amountoutstanding} <= 0 ) {
  83         $accountline->{amountoutstandingcredit} = 1;
  84     }
  85
  86     $accountline->{amount} = sprintf '%.2f', $accountline->{amount};
  87     $accountline->{amountoutstanding} = sprintf '%.2f', $accountline->{amountoutstanding};
  88     if ($accountline->{accounttype} =~ /^Pay/) {
  89         $accountline->{payment} = 1;
  90         $reverse_col = 1;
  91     }
  92 }
  93
  94 $template->param( adultborrower => 1 ) if ( $data->{'category_type'} eq 'A' );
  95
  96 my ($picture, $dberror) = GetPatronImage($data->{'borrowernumber'});
  97 $template->param( picture => 1 ) if $picture;
  98
  99 if (C4::Context->preference('ExtendedPatronAttributes')) {
 100     my $attributes = GetBorrowerAttributes($borrowernumber);
 101     $template->param(
 102         ExtendedPatronAttributes => 1,
 103         extendedattributes => $attributes
 104     );
 105 }
 106
 107 # Computes full borrower address
 108 my $roadtype = C4::Koha::GetAuthorisedValueByCode( 'ROADTYPE', $data->{streettype} );
 109 my $address = $data->{'streetnumber'} . " $roadtype " . $data->{'address'};
 110
 111 $template->param(
 112     finesview           => 1,
 113     firstname           => $data->{'firstname'},
 114     surname             => $data->{'surname'},
 115     othernames          => $data->{'othernames'},
 116     borrowernumber      => $borrowernumber,
 117     cardnumber          => $data->{'cardnumber'},
 118     categorycode        => $data->{'categorycode'},
 119     category_type       => $data->{'category_type'},
 120     categoryname                => $data->{'description'},
 121     address             => $address,
 122     address2            => $data->{'address2'},
 123     city                => $data->{'city'},
 124     state               => $data->{'state'},
 125     zipcode             => $data->{'zipcode'},
 126     country             => $data->{'country'},
 127     phone               => $data->{'phone'},
 128     phonepro            => $data->{'phonepro'},
 129     mobile              => $data->{'mobile'},
 130     email               => $data->{'email'},
 131     emailpro            => $data->{'emailpro'},
 132     branchcode          => $data->{'branchcode'},
 133         branchname                      => GetBranchName($data->{'branchcode'}),
 134     total               => sprintf("%.2f",$total),
 135     totalcredit         => $totalcredit,
 136     is_child            => ($data->{'category_type'} eq 'C'),
 137     reverse_col         => $reverse_col,
 138     accounts            => $accts,
 139         activeBorrowerRelationship => (C4::Context->preference('borrowerRelationship') ne ''),
 140     RoutingSerials => C4::Context->preference('RoutingSerials'),
 141 );
 142
 143 output_html_with_http_headers $input, $cookie, $template->output;