use Carp;
use Data::Dumper;
+use List::MoreUtils qw( uniq );
use C4::Log qw( logaction );
use C4::Stats qw( UpdateStats );
-use Koha::Account::Line;
use Koha::Account::Lines;
+use Koha::Account::Offsets;
use Koha::DateUtils qw( dt_from_string );
=head1 NAME
Koha::Account->new( { patron_id => $borrowernumber } )->pay(
{
- amount => $amount,
- sip => $sipmode,
- note => $note,
- accountlines_id => $accountlines_id,
- library_id => $branchcode,
+ amount => $amount,
+ sip => $sipmode,
+ note => $note,
+ description => $description,
+ library_id => $branchcode,
+ lines => $lines, # Arrayref of Koha::Account::Line objects to pay
+ account_type => $type, # accounttype code
+ offset_type => $offset_type, # offset type code
}
);
sub pay {
my ( $self, $params ) = @_;
- my $amount = $params->{amount};
- my $sip = $params->{sip};
- my $note = $params->{note} || q{};
- my $accountlines_id = $params->{accountlines_id};
- my $library_id = $params->{library_id};
+ my $amount = $params->{amount};
+ my $sip = $params->{sip};
+ my $description = $params->{description};
+ my $note = $params->{note} || q{};
+ my $library_id = $params->{library_id};
+ my $lines = $params->{lines};
+ my $type = $params->{type} || 'payment';
+ my $account_type = $params->{account_type};
+ my $offset_type = $params->{offset_type} || $type eq 'writeoff' ? 'Writeoff' : 'Payment';
my $userenv = C4::Context->userenv;
my $balance_remaining = $amount; # Set it now so we can adjust the amount if necessary
$balance_remaining ||= 0;
- # We were passed a specific line to pay
- if ( $accountlines_id ) {
- my $fine = Koha::Account::Lines->find( $accountlines_id );
+ my @account_offsets;
- # If accountline id is passed but no amount, we pay that line in full
- $amount = $fine->amountoutstanding unless defined($amount);
+ # We were passed a specific line to pay
+ foreach my $fine ( @$lines ) {
+ my $amount_to_pay =
+ $fine->amountoutstanding > $balance_remaining
+ ? $balance_remaining
+ : $fine->amountoutstanding;
my $old_amountoutstanding = $fine->amountoutstanding;
- my $new_amountoutstanding = $old_amountoutstanding - $amount;
- $fine->amountoutstanding( $new_amountoutstanding )->store();
- $balance_remaining = $balance_remaining - $amount;
+ my $new_amountoutstanding = $old_amountoutstanding - $amount_to_pay;
+ $fine->amountoutstanding($new_amountoutstanding)->store();
+ $balance_remaining = $balance_remaining - $amount_to_pay;
- if ( $fine->accounttype eq 'Rep' || $fine->accounttype eq 'L' )
+ if ( $fine->itemnumber && $fine->accounttype && ( $fine->accounttype eq 'Rep' || $fine->accounttype eq 'L' ) )
{
C4::Circulation::ReturnLostItem( $self->{patron_id}, $fine->itemnumber );
}
+ my $account_offset = Koha::Account::Offset->new(
+ {
+ debit_id => $fine->id,
+ type => $offset_type,
+ amount => $amount_to_pay * -1,
+ }
+ );
+ push( @account_offsets, $account_offset );
+
if ( C4::Context->preference("FinesLog") ) {
logaction(
"FINES", 'MODIFY',
$fine->amountoutstanding( $old_amountoutstanding - $amount_to_pay );
$fine->store();
+ my $account_offset = Koha::Account::Offset->new(
+ {
+ debit_id => $fine->id,
+ type => $offset_type,
+ amount => $amount_to_pay * -1,
+ }
+ );
+ push( @account_offsets, $account_offset );
+
if ( C4::Context->preference("FinesLog") ) {
logaction(
"FINES", 'MODIFY',
$self->{patron_id},
Dumper(
{
- action => 'fee_payment',
+ action => "fee_$type",
borrowernumber => $fine->borrowernumber,
old_amountoutstanding => $old_amountoutstanding,
new_amountoutstanding => $fine->amountoutstanding,
last unless $balance_remaining > 0;
}
- my $account_type = defined($sip) ? "Pay$sip" : 'Pay';
+ $account_type ||=
+ $type eq 'writeoff' ? 'W'
+ : defined($sip) ? "Pay$sip"
+ : 'Pay';
+
+ $description ||= $type eq 'writeoff' ? 'Writeoff' : q{};
my $payment = Koha::Account::Line->new(
{
accountno => $accountno,
date => dt_from_string(),
amount => 0 - $amount,
- description => q{},
+ description => $description,
accounttype => $account_type,
amountoutstanding => 0 - $balance_remaining,
manager_id => $manager_id,
}
)->store();
+ foreach my $o ( @account_offsets ) {
+ $o->credit_id( $payment->id() );
+ $o->store();
+ }
+
$library_id ||= $userenv ? $userenv->{'branch'} : undef;
UpdateStats(
{
branch => $library_id,
- type => 'payment',
+ type => $type,
amount => $amount,
borrowernumber => $self->{patron_id},
accountno => $accountno,
$self->{patron_id},
Dumper(
{
- action => 'create_payment',
+ action => "create_$type",
borrowernumber => $self->{patron_id},
accountno => $accountno,
amount => 0 - $amount,
amountoutstanding => 0 - $balance_remaining,
- accounttype => 'Pay',
+ accounttype => $account_type,
accountlines_paid => \@fines_paid,
manager_id => $manager_id,
}
return $payment->id;
}
+=head3 balance
+
+my $balance = $self->balance
+
+Return the balance (sum of amountoutstanding columns)
+
+=cut
+
+sub balance {
+ my ($self) = @_;
+ my $fines = Koha::Account::Lines->search(
+ {
+ borrowernumber => $self->{patron_id},
+ },
+ {
+ select => [ { sum => 'amountoutstanding' } ],
+ as => ['total_amountoutstanding'],
+ }
+ );
+
+ my $total = $fines->count
+ ? $fines->next->get_column('total_amountoutstanding') + 0
+ : 0;
+}
+
+=head3 non_issues_charges
+
+my $non_issues_charges = $self->non_issues_charges
+
+Calculates amount immediately owing by the patron - non-issue charges.
+
+Charges exempt from non-issue are:
+* Res (holds) if HoldsInNoissuesCharge syspref is set to false
+* Rent (rental) if RentalsInNoissuesCharge syspref is set to false
+* Manual invoices if ManInvInNoissuesCharge syspref is set to false
+
+=cut
+
+sub non_issues_charges {
+ my ($self) = @_;
+
+ # FIXME REMOVE And add a warning in the about page + update DB if length(MANUAL_INV) > 5
+ my $ACCOUNT_TYPE_LENGTH = 5; # this is plain ridiculous...
+
+ my @not_fines;
+ push @not_fines, 'Res'
+ unless C4::Context->preference('HoldsInNoissuesCharge');
+ push @not_fines, 'Rent'
+ unless C4::Context->preference('RentalsInNoissuesCharge');
+ unless ( C4::Context->preference('ManInvInNoissuesCharge') ) {
+ my $dbh = C4::Context->dbh;
+ push @not_fines,
+ @{
+ $dbh->selectcol_arrayref(q|
+ SELECT authorised_value FROM authorised_values WHERE category = 'MANUAL_INV'
+ |)
+ };
+ }
+ @not_fines = map { substr( $_, 0, $ACCOUNT_TYPE_LENGTH ) } uniq(@not_fines);
+
+ my $non_issues_charges = Koha::Account::Lines->search(
+ {
+ borrowernumber => $self->{patron_id},
+ accounttype => { -not_in => \@not_fines }
+ },
+ {
+ select => [ { sum => 'amountoutstanding' } ],
+ as => ['non_issues_charges'],
+ }
+ );
+ return $non_issues_charges->count
+ ? $non_issues_charges->next->get_column('non_issues_charges') + 0
+ : 0;
+}
+
1;
=head1 AUTHOR