#!/usr/bin/perl
-#writen 11/1/2000 by chris@katipo.oc.nz
+#written 11/1/2000 by chris@katipo.oc.nz
#script to display borrowers account details
# You should have received a copy of the GNU General Public License
# along with Koha; if not, see <http://www.gnu.org/licenses>.
-use strict;
-use warnings;
+use Modern::Perl;
+use URI::Escape;
use C4::Auth;
use C4::Output;
use CGI qw ( -utf8 );
use C4::Members;
-use C4::Branch;
use C4::Accounts;
-use C4::Members::Attributes qw(GetBorrowerAttributes);
+use Koha::Cash::Registers;
+use Koha::Patrons;
+use Koha::Patron::Categories;
+use Koha::Items;
my $input=new CGI;
query => $input,
type => "intranet",
authnotrequired => 0,
- flagsrequired => { borrowers => 1,
+ flagsrequired => { borrowers => 'edit_borrowers',
updatecharges => 'remaining_permissions'},
debug => 1,
}
);
-my $borrowernumber=$input->param('borrowernumber');
-my $action = $input->param('action') || '';
-
-#get borrower details
-my $data=GetMember('borrowernumber' => $borrowernumber);
-
-if ( $action eq 'reverse' ) {
- ReversePayment( $input->param('accountlines_id') );
+my $schema = Koha::Database->new->schema;
+my $borrowernumber = $input->param('borrowernumber');
+my $payment_id = $input->param('payment_id');
+my $change_given = $input->param('change_given');
+my $action = $input->param('action') || '';
+my @renew_results = $input->param('renew_result');
+
+my $logged_in_user = Koha::Patrons->find( $loggedinuser );
+my $library_id = C4::Context->userenv->{'branch'};
+my $patron = Koha::Patrons->find( $borrowernumber );
+unless ( $patron ) {
+ print $input->redirect("/cgi-bin/koha/circ/circulation.pl?borrowernumber=$borrowernumber");
+ exit;
}
-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;
-}
+output_and_exit_if_error( $input, $cookie, $template, { module => 'members', logged_in_user => $logged_in_user, current_patron => $patron } );
-#get account details
-my ($total,$accts,undef)=GetMemberAccountRecords($borrowernumber);
-my $totalcredit;
-if($total <= 0){
- $totalcredit = 1;
-}
+my $registerid;
+if ( C4::Context->preference('UseCashRegisters') ) {
+ $registerid = scalar $input->param('registerid');
+ my $registers = Koha::Cash::Registers->search(
+ { branch => $library_id, archived => 0 },
+ { order_by => { '-asc' => 'name' } }
+ );
-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;
+ if ( !$registers->count ) {
+ $template->param( error_registers => 1 );
}
- $accountline->{amountoutstanding} += 0.00;
- if ( $accountline->{amountoutstanding} <= 0 ) {
- $accountline->{amountoutstandingcredit} = 1;
+ else {
+
+ if ( !$registerid ) {
+ my $default_register = Koha::Cash::Registers->find(
+ { branch => $library_id, branch_default => 1 } );
+ $registerid = $default_register->id if $default_register;
+ }
+ $registerid = $registers->next->id if !$registerid;
+
+ $template->param(
+ registerid => $registerid,
+ registers => $registers,
+ );
}
+}
- $accountline->{amount} = sprintf '%.2f', $accountline->{amount};
- $accountline->{amountoutstanding} = sprintf '%.2f', $accountline->{amountoutstanding};
- if ($accountline->{accounttype} =~ /^Pay/) {
- $accountline->{payment} = 1;
- $reverse_col = 1;
- }
+if ( $action eq 'void' ) {
+ my $payment_id = scalar $input->param('accountlines_id');
+ my $payment = Koha::Account::Lines->find( $payment_id );
+ $payment->void();
}
-$template->param( adultborrower => 1 ) if ( $data->{'category_type'} eq 'A' );
+if ( $action eq 'payout' ) {
+ my $payment_id = scalar $input->param('accountlines_id');
+ my $payment = Koha::Account::Lines->find($payment_id);
+ my $amount = scalar $input->param('amount');
+ my $transaction_type = scalar $input->param('transaction_type');
+ $schema->txn_do(
+ sub {
+ my $payout = $payment->payout(
+ {
+ payout_type => $transaction_type,
+ branch => $library_id,
+ staff_id => $logged_in_user->id,
+ cash_register => $registerid,
+ interface => 'intranet',
+ amount => $amount
+ }
+ );
+ }
+ );
+}
-my ($picture, $dberror) = GetPatronImage($data->{'borrowernumber'});
-$template->param( picture => 1 ) if $picture;
+if ( $action eq 'refund' ) {
+ my $charge_id = scalar $input->param('accountlines_id');
+ my $charge = Koha::Account::Lines->find($charge_id);
+ my $amount = scalar $input->param('amount');
+ my $transaction_type = scalar $input->param('transaction_type');
+ $schema->txn_do(
+ sub {
+
+ my $refund = $charge->reduce(
+ {
+ reduction_type => 'REFUND',
+ branch => $library_id,
+ staff_id => $logged_in_user->id,
+ interface => 'intranet',
+ amount => $amount
+ }
+ );
+ unless ( $transaction_type eq 'AC' ) {
+ my $payout = $refund->payout(
+ {
+ payout_type => $transaction_type,
+ branch => $library_id,
+ staff_id => $logged_in_user->id,
+ cash_register => $registerid,
+ interface => 'intranet',
+ amount => $amount
+ }
+ );
+ }
+ }
+ );
+}
-if (C4::Context->preference('ExtendedPatronAttributes')) {
- my $attributes = GetBorrowerAttributes($borrowernumber);
- $template->param(
- ExtendedPatronAttributes => 1,
- extendedattributes => $attributes
+if ( $action eq 'discount' ) {
+ my $charge_id = scalar $input->param('accountlines_id');
+ my $charge = Koha::Account::Lines->find($charge_id);
+ my $amount = scalar $input->param('amount');
+ $schema->txn_do(
+ sub {
+
+ my $discount = $charge->reduce(
+ {
+ reduction_type => 'DISCOUNT',
+ branch => $library_id,
+ staff_id => $logged_in_user->id,
+ interface => 'intranet',
+ amount => $amount
+ }
+ );
+ }
);
}
-my $roadtype = C4::Koha::GetAuthorisedValueByCode( 'ROADTYPE', $data->{streettype} );
+#get account details
+my $total = $patron->account->balance;
+
+my @accountlines = Koha::Account::Lines->search(
+ { borrowernumber => $patron->borrowernumber },
+ { order_by => { -desc => 'accountlines_id' } }
+);
+
+my $totalcredit;
+if($total <= 0){
+ $totalcredit = 1;
+}
-#workaround for Bug 4041 to get rid of duplicated code in circ-menu.tt, use circ-menu.inc instad
-$template->param(%$data);
+# Populate an arrayref with everything we need to display any
+# renew errors that occurred based on what we were passed
+my $renew_results_display = [];
+foreach my $renew_result(@renew_results) {
+ my ($itemnumber, $success, $info) = split(/,/, $renew_result);
+ my $item = Koha::Items->find($itemnumber);
+ if ($success) {
+ $info = uri_unescape($info);
+ }
+ push @{$renew_results_display}, {
+ item => $item,
+ success => $success,
+ info => $info
+ };
+}
$template->param(
+ patron => $patron,
finesview => 1,
- borrowernumber => $borrowernumber,
- roadtype => $roadtype,
- 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 ''),
- RoutingSerials => C4::Context->preference('RoutingSerials'),
+ accounts => \@accountlines,
+ payment_id => $payment_id,
+ change_given => $change_given,
+ renew_results => $renew_results_display,
);
output_html_with_http_headers $input, $cookie, $template->output;