#!/usr/bin/perl
-# $Id$
#writen 11/1/2000 by chris@katipo.oc.nz
#script to display borrowers account details
# WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
# A PARTICULAR PURPOSE. See the GNU General Public License for more details.
#
-# You should have received a copy of the GNU General Public License along with
-# Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
-# Suite 330, Boston, MA 02111-1307 USA
+# You should have received a copy of the GNU General Public License along
+# with Koha; if not, write to the Free Software Foundation, Inc.,
+# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
use strict;
+use warnings;
+
use C4::Auth;
use C4::Output;
-use C4::Interface::CGI::Output;
-use C4::Date;
+use C4::Dates qw/format_date/;
use CGI;
use C4::Members;
-
+use C4::Branch;
+use C4::Accounts;
+use C4::Members::Attributes qw(GetBorrowerAttributes);
my $input=new CGI;
-my $theme = $input->param('theme'); # only used if allowthemeoverride is set
-#my %tmpldata = pathtotemplate ( template => 'boraccount.tmpl', theme => $theme );
-#my $template = HTML::Template->new(filename => $tmpldata{'path'}, die_on_bad_params => 0);
+
my ($template, $loggedinuser, $cookie)
= get_template_and_user({template_name => "members/boraccount.tmpl",
- query => $input,
- type => "intranet",
- authnotrequired => 0,
- flagsrequired => {borrowers => 1},
- debug => 1,
- });
+ query => $input,
+ type => "intranet",
+ authnotrequired => 0,
+ flagsrequired => {borrowers => 1, updatecharges => 1},
+ debug => 1,
+ });
my $borrowernumber=$input->param('borrowernumber');
+my $action = $input->param('action') || '';
+
#get borrower details
-my $data=borrdata('',$borrowernumber);
+my $data=GetMember('borrowernumber' => $borrowernumber);
+
+if ( $action eq 'reverse' ) {
+ ReversePayment( $borrowernumber, $input->param('accountno') );
+}
+
+if ( $data->{'category_type'} eq 'C') {
+ my ( $catcodes, $labels ) = GetborCatFromCatType( 'A', 'WHERE category_type = ?' );
+ my $cnt = scalar(@$catcodes);
+ $template->param( 'CATCODE_MULTI' => 1) if $cnt > 1;
+ $template->param( 'catcode' => $catcodes->[0]) if $cnt == 1;
+}
#get account details
-my %bor;
-$bor{'borrowernumber'}=$borrowernumber;
-my ($numaccts,$accts,$total)=getboracctrecord('',\%bor);
+my ($total,$accts,undef)=GetMemberAccountRecords($borrowernumber);
my $totalcredit;
if($total <= 0){
- $totalcredit = 1;
+ $totalcredit = 1;
+}
+
+my $reverse_col = 0; # Flag whether we need to show the reverse column
+foreach my $accountline ( @{$accts}) {
+ $accountline->{amount} += 0.00;
+ if ($accountline->{amount} <= 0 ) {
+ $accountline->{amountcredit} = 1;
+ }
+ $accountline->{amountoutstanding} += 0.00;
+ if ( $accountline->{amountoutstanding} <= 0 ) {
+ $accountline->{amountoutstandingcredit} = 1;
+ }
+
+ $accountline->{date} = format_date($accountline->{date});
+ $accountline->{amount} = sprintf '%.2f', $accountline->{amount};
+ $accountline->{amountoutstanding} = sprintf '%.2f', $accountline->{amountoutstanding};
+ if ($accountline->{accounttype} eq 'Pay') {
+ $accountline->{payment} = 1;
+ $reverse_col = 1;
+ }
}
-my @accountrows; # this is for the tmpl-loop
-
-my $toggle;
-for (my $i=0;$i<$numaccts;$i++){
- if($i%2){
- $toggle = 0;
- } else {
- $toggle = 1;
- }
- $accts->[$i]{'toggle'} = $toggle;
- $accts->[$i]{'amount'}+=0.00;
- if($accts->[$i]{'amount'} <= 0){
- $accts->[$i]{'amountcredit'} = 1;
- }
- $accts->[$i]{'amountoutstanding'}+=0.00;
- if($accts->[$i]{'amountoutstanding'} <= 0){
- $accts->[$i]{'amountoutstandingcredit'} = 1;
- }
- my %row = ( 'date' => format_date($accts->[$i]{'date'}),
- 'amountcredit' => $accts->[$i]{'amountcredit'},
- 'amountoutstandingcredit' => $accts->[$i]{'amountoutstandingcredit'},
- 'toggle' => $accts->[$i]{'toggle'},
- 'description' => $accts->[$i]{'description'},
- 'amount' => sprintf("%.2f",$accts->[$i]{'amount'}),
- 'amountoutstanding' => sprintf("%.2f",$accts->[$i]{'amountoutstanding'}) );
-
- if ($accts->[$i]{'accounttype'} ne 'F' && $accts->[$i]{'accounttype'} ne 'FU'){
- $row{'printtitle'}=1;
- $row{'title'} = $accts->[$i]{'title'};
- }
-
- push(@accountrows, \%row);
+
+$template->param( adultborrower => 1 ) if ( $data->{'category_type'} eq 'A' );
+
+my ($picture, $dberror) = GetPatronImage($data->{'cardnumber'});
+$template->param( picture => 1 ) if $picture;
+
+if (C4::Context->preference('ExtendedPatronAttributes')) {
+ my $attributes = GetBorrowerAttributes($borrowernumber);
+ $template->param(
+ ExtendedPatronAttributes => 1,
+ extendedattributes => $attributes
+ );
}
$template->param(
- firstname => $data->{'firstname'},
- surname => $data->{'surname'},
- borrowernumber => $borrowernumber,
- total => sprintf("%.2f",$total),
- totalcredit => $totalcredit,
- accounts => \@accountrows );
+ finesview => 1,
+ firstname => $data->{'firstname'},
+ surname => $data->{'surname'},
+ othernames => $data->{'othernames'},
+ borrowernumber => $borrowernumber,
+ cardnumber => $data->{'cardnumber'},
+ categorycode => $data->{'categorycode'},
+ category_type => $data->{'category_type'},
+ categoryname => $data->{'description'},
+ address => $data->{'address'},
+ address2 => $data->{'address2'},
+ city => $data->{'city'},
+ state => $data->{'state'},
+ zipcode => $data->{'zipcode'},
+ country => $data->{'country'},
+ phone => $data->{'phone'},
+ email => $data->{'email'},
+ branchcode => $data->{'branchcode'},
+ branchname => GetBranchName($data->{'branchcode'}),
+ total => sprintf("%.2f",$total),
+ totalcredit => $totalcredit,
+ is_child => ($data->{'category_type'} eq 'C'),
+ reverse_col => $reverse_col,
+ accounts => $accts,
+ activeBorrowerRelationship => (C4::Context->preference('borrowerRelationship') ne ''),
+);
output_html_with_http_headers $input, $cookie, $template->output;