3 # Copyright ByWater Solutions 2014
4 # Copyright 2017 Koha Development team
6 # This file is part of Koha.
8 # Koha is free software; you can redistribute it and/or modify it
9 # under the terms of the GNU General Public License as published by
10 # the Free Software Foundation; either version 3 of the License, or
11 # (at your option) any later version.
13 # Koha is distributed in the hope that it will be useful, but
14 # WITHOUT ANY WARRANTY; without even the implied warranty of
15 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
16 # GNU General Public License for more details.
18 # You should have received a copy of the GNU General Public License
19 # along with Koha; if not, see <http://www.gnu.org/licenses>.
23 use List::MoreUtils qw( any );
25 use C4::Context qw(preference);
26 use C4::Letters qw( GetPreparedLetter EnqueueLetter );
27 use C4::Log qw( logaction );
30 use Koha::AuthorisedValues;
31 use Koha::DateUtils qw( dt_from_string );
34 use Koha::Hold::CancellationRequests;
41 use Koha::BackgroundJob::BatchUpdateBiblioHoldsQueue;
44 use Koha::Exceptions::Hold;
46 use base qw(Koha::Object);
50 Koha::Hold - Koha Hold object class
60 returns the number of days since a hold was placed, optionally
63 my $age = $hold->age( $use_calendar );
68 my ( $self, $use_calendar ) = @_;
70 my $today = dt_from_string;
73 if ( $use_calendar ) {
74 my $calendar = Koha::Calendar->new( branchcode => $self->branchcode );
75 $age = $calendar->days_between( dt_from_string( $self->reservedate ), $today );
78 $age = $today->delta_days( dt_from_string( $self->reservedate ) );
81 $age = $age->in_units( 'days' );
88 my $hold = $hold->suspend_hold( $suspend_until );
93 my ( $self, $date ) = @_;
95 my $original = C4::Context->preference('HoldsLog') ? $self->unblessed : undef;
97 $date &&= dt_from_string($date)->truncate( to => 'day' )->datetime;
99 if ( $self->is_found ) { # We can't suspend found holds
100 if ( $self->is_waiting ) {
101 Koha::Exceptions::Hold::CannotSuspendFound->throw( status => 'W' );
103 elsif ( $self->is_in_transit ) {
104 Koha::Exceptions::Hold::CannotSuspendFound->throw( status => 'T' );
106 elsif ( $self->is_in_processing ) {
107 Koha::Exceptions::Hold::CannotSuspendFound->throw( status => 'P' );
110 Koha::Exceptions::Hold::CannotSuspendFound->throw(
111 'Unhandled data exception on found hold (id='
120 $self->suspend_until($date);
127 payload => { hold => $self->get_from_storage }
131 logaction( 'HOLDS', 'SUSPEND', $self->reserve_id, $self, undef, $original )
132 if C4::Context->preference('HoldsLog');
134 Koha::BackgroundJob::BatchUpdateBiblioHoldsQueue->new->enqueue(
136 biblio_ids => [ $self->biblionumber ]
138 ) if C4::Context->preference('RealTimeHoldsQueue');
145 my $hold = $hold->resume();
152 my $original = C4::Context->preference('HoldsLog') ? $self->unblessed : undef;
155 $self->suspend_until( undef );
163 payload => { hold => $self->get_from_storage }
167 logaction( 'HOLDS', 'RESUME', $self->reserve_id, $self, undef, $original )
168 if C4::Context->preference('HoldsLog');
170 Koha::BackgroundJob::BatchUpdateBiblioHoldsQueue->new->enqueue(
172 biblio_ids => [ $self->biblionumber ]
174 ) if C4::Context->preference('RealTimeHoldsQueue');
188 my $deleted = $self->SUPER::delete($self);
190 logaction( 'HOLDS', 'DELETE', $self->reserve_id, $self )
191 if C4::Context->preference('HoldsLog');
210 action => 'transfer',
211 payload => { hold => $self->get_from_storage }
223 my ( $self, $desk_id ) = @_;
227 my $today = dt_from_string();
231 ( !$self->waitingdate ? ( waitingdate => $today->ymd ) : () ),
235 my $max_pickup_delay = C4::Context->preference("ReservesMaxPickUpDelay");
236 my $cancel_on_holidays = C4::Context->preference('ExpireReservesOnHolidays');
238 my $rule = Koha::CirculationRules->get_effective_rule(
240 categorycode => $self->borrower->categorycode,
241 itemtype => $self->item->effective_itemtype,
242 branchcode => $self->branchcode,
243 rule_name => 'holds_pickup_period',
246 if ( defined($rule) and $rule->rule_value ne '' ) {
248 # circulation rule overrides ReservesMaxPickUpDelay
249 $max_pickup_delay = $rule->rule_value;
252 my $new_expiration_date = dt_from_string($self->waitingdate)->clone->add( days => $max_pickup_delay );
254 if ( C4::Context->preference("ExcludeHolidaysFromMaxPickUpDelay") ) {
255 my $itemtype = $self->item ? $self->item->effective_itemtype : $self->biblio->itemtype;
256 my $daysmode = Koha::CirculationRules->get_effective_daysmode(
258 categorycode => $self->borrower->categorycode,
259 itemtype => $itemtype,
260 branchcode => $self->branchcode,
263 my $calendar = Koha::Calendar->new( branchcode => $self->branchcode, days_mode => $daysmode );
265 $new_expiration_date = $calendar->days_forward( dt_from_string($self->waitingdate), $max_pickup_delay );
268 # If patron's requested expiration date is prior to the
269 # calculated one, we keep the patron's one.
270 if ( $self->patron_expiration_date ) {
271 my $requested_expiration = dt_from_string( $self->patron_expiration_date );
274 $requested_expiration
275 ? DateTime->compare( $requested_expiration, $new_expiration_date )
278 $new_expiration_date =
279 $cmp == -1 ? $requested_expiration : $new_expiration_date;
282 $values->{expirationdate} = $new_expiration_date->ymd;
284 $self->set($values)->store();
290 payload => { hold => $self->get_from_storage }
297 =head3 is_pickup_location_valid
299 if ($hold->is_pickup_location_valid({ library_id => $library->id }) ) {
303 Returns a I<boolean> representing if the passed pickup location is valid for the hold.
304 It throws a I<Koha::Exceptions::_MissingParameter> if the library_id parameter is not
309 sub is_pickup_location_valid {
310 my ( $self, $params ) = @_;
312 Koha::Exceptions::MissingParameter->throw('The library_id parameter is mandatory')
313 unless $params->{library_id};
315 my $pickup_locations;
317 if ( $self->itemnumber ) { # item-level
318 $pickup_locations = $self->item->pickup_locations({ patron => $self->patron });
320 else { # biblio-level
321 $pickup_locations = $self->biblio->pickup_locations({ patron => $self->patron });
324 return any { $_->branchcode eq $params->{library_id} } $pickup_locations->as_list;
327 =head3 set_pickup_location
329 $hold->set_pickup_location(
331 library_id => $library->id,
336 Updates the hold pickup location. It throws a I<Koha::Exceptions::Hold::InvalidPickupLocation> if
337 the passed pickup location is not valid.
339 Note: It is up to the caller to verify if I<AllowHoldPolicyOverride> is set when setting the
344 sub set_pickup_location {
345 my ( $self, $params ) = @_;
347 Koha::Exceptions::MissingParameter->throw('The library_id parameter is mandatory')
348 unless $params->{library_id};
352 || $self->is_pickup_location_valid(
353 { library_id => $params->{library_id} }
357 # all good, set the new pickup location
358 $self->branchcode( $params->{library_id} )->store;
361 Koha::Exceptions::Hold::InvalidPickupLocation->throw;
367 =head3 set_processing
369 $hold->set_processing;
371 Mark the hold as in processing.
385 action => 'processing',
386 payload => { hold => $self->get_from_storage }
395 Returns true if hold is waiting, in transit or in processing
402 return 0 unless $self->found();
403 return 1 if $self->found() eq 'W';
404 return 1 if $self->found() eq 'T';
405 return 1 if $self->found() eq 'P';
410 Returns true if hold is a waiting hold
417 my $found = $self->found;
418 return $found && $found eq 'W';
423 Returns true if hold is a in_transit hold
430 return 0 unless $self->found();
431 return $self->found() eq 'T';
434 =head3 is_in_processing
436 Returns true if hold is a in_processing hold
440 sub is_in_processing {
443 return 0 unless $self->found();
444 return $self->found() eq 'P';
447 =head3 is_cancelable_from_opac
449 Returns true if hold is a cancelable hold
451 Holds may be only canceled if they are not found.
453 This is used from the OPAC.
457 sub is_cancelable_from_opac {
460 return 1 unless $self->is_found();
461 return 0; # if ->is_in_transit or if ->is_waiting or ->is_in_processing
464 =head3 cancellation_requestable_from_opac
466 if ( $hold->cancellation_requestable_from_opac ) { ... }
468 Returns a I<boolean> representing if a cancellation request can be placed on the hold
469 from the OPAC. It targets holds that cannot be cancelled from the OPAC (see the
470 B<is_cancelable_from_opac> method above), but for which circulation rules allow
471 requesting cancellation.
473 Throws a B<Koha::Exceptions::InvalidStatus> exception with the following I<invalid_status>
478 =item B<'hold_not_waiting'>: the hold is expected to be waiting and it is not.
480 =item B<'no_item_linked'>: the waiting hold doesn't have an item properly linked.
486 sub cancellation_requestable_from_opac {
489 Koha::Exceptions::InvalidStatus->throw( invalid_status => 'hold_not_waiting' )
490 unless $self->is_waiting;
492 my $item = $self->item;
494 Koha::Exceptions::InvalidStatus->throw( invalid_status => 'no_item_linked' )
497 my $patron = $self->patron;
499 my $controlbranch = $patron->branchcode;
501 if ( C4::Context->preference('ReservesControlBranch') eq 'ItemHomeLibrary' ) {
502 $controlbranch = $item->homebranch;
505 return Koha::CirculationRules->get_effective_rule_value(
507 categorycode => $patron->categorycode,
508 itemtype => $item->itype,
509 branchcode => $controlbranch,
510 rule_name => 'waiting_hold_cancellation',
515 =head3 is_at_destination
517 Returns true if hold is waiting
518 and the hold's pickup branch matches
519 the hold item's holding branch
523 sub is_at_destination {
526 return $self->is_waiting() && ( $self->branchcode() eq $self->item()->holdingbranch() );
531 Returns the related Koha::Biblio object for this hold
537 my $rs = $self->_result->biblionumber;
538 return Koha::Biblio->_new_from_dbic($rs);
543 Returns the related Koha::Patron object for this hold
549 my $rs = $self->_result->patron;
550 return Koha::Patron->_new_from_dbic($rs);
555 Returns the related Koha::Item object for this Hold
561 my $rs = $self->_result->itemnumber;
563 return Koha::Item->_new_from_dbic($rs);
568 Returns the related Koha::Biblio::ItemGroup object for this Hold
574 my $rs = $self->_result->item_group;
576 return Koha::Biblio::ItemGroup->_new_from_dbic($rs);
581 Returns the related Koha::Library object for this hold
588 return shift->pickup_library(@_);
591 =head3 pickup_library
593 Returns the related Koha::Library object for this hold
599 my $rs = $self->_result->pickup_library;
600 return Koha::Library->_new_from_dbic($rs);
605 Returns the related Koha::Desk object for this Hold
611 my $desk_rs = $self->_result->desk;
612 return unless $desk_rs;
613 return Koha::Desk->_new_from_dbic($desk_rs);
618 Returns the related Koha::Patron object for this Hold
622 # FIXME Should be renamed with ->patron
625 my $rs = $self->_result->borrowernumber;
626 return Koha::Patron->_new_from_dbic($rs);
631 my $bool = $hold->is_suspended();
638 return $self->suspend();
641 =head3 add_cancellation_request
643 my $cancellation_request = $hold->add_cancellation_request({ [ creation_date => $creation_date ] });
645 Adds a cancellation request to the hold. Returns the generated
646 I<Koha::Hold::CancellationRequest> object.
650 sub add_cancellation_request {
651 my ( $self, $params ) = @_;
653 my $request = Koha::Hold::CancellationRequest->new(
654 { hold_id => $self->id,
655 ( $params->{creation_date} ? ( creation_date => $params->{creation_date} ) : () ),
659 $request->discard_changes;
664 =head3 cancellation_requests
666 my $cancellation_requests = $hold->cancellation_requests;
668 Returns related a I<Koha::Hold::CancellationRequests> resultset.
672 sub cancellation_requests {
675 return Koha::Hold::CancellationRequests->search( { hold_id => $self->id } );
678 =head3 cancellation_requested
680 if ( $hold->cancellation_requested ) { ... }
682 Returns true if a cancellation request has been placed for the hold.
686 sub cancellation_requested {
689 return Koha::Hold::CancellationRequests->search( { hold_id => $self->id } )->count > 0;
694 my $cancel_hold = $hold->cancel(
696 [ charge_cancel_fee => 1||0, ]
697 [ cancellation_reason => $cancellation_reason, ]
698 [ skip_holds_queue => 1||0 ]
703 - The hold will be moved to the old_reserves table with a priority=0
704 - The priority of other holds will be updated
705 - The patron will be charge (see ExpireReservesMaxPickUpDelayCharge) if the charge_cancel_fee parameter is set
706 - The canceled hold will have the cancellation reason added to old_reserves.cancellation_reason if one is passed in
707 - a CANCEL HOLDS log will be done if the pref HoldsLog is on
712 my ( $self, $params ) = @_;
714 my $autofill_next = $params->{autofill} && $self->itemnumber && $self->found && $self->found eq 'W';
716 my $original = C4::Context->preference('HoldsLog') ? $self->unblessed : undef;
718 $self->_result->result_source->schema->txn_do(
720 my $patron = $self->patron;
722 $self->cancellationdate( dt_from_string->strftime( '%Y-%m-%d %H:%M:%S' ) );
724 $self->cancellation_reason( $params->{cancellation_reason} );
727 my $dbh = $self->_result->result_source->schema->storage->dbh;
731 FROM tmp_holdsqueue q
732 INNER JOIN hold_fill_targets t
733 ON q.borrowernumber = t.borrowernumber
734 AND q.biblionumber = t.biblionumber
735 AND q.itemnumber = t.itemnumber
736 AND q.item_level_request = t.item_level_request
737 AND q.holdingbranch = t.source_branchcode
738 WHERE t.reserve_id = ?
742 if ( $params->{cancellation_reason} ) {
743 my $letter = C4::Letters::GetPreparedLetter(
744 module => 'reserves',
745 letter_code => 'HOLD_CANCELLATION',
746 message_transport_type => 'email',
747 branchcode => $self->borrower->branchcode,
748 lang => $self->borrower->lang,
750 branches => $self->borrower->branchcode,
751 borrowers => $self->borrowernumber,
752 items => $self->itemnumber,
753 biblio => $self->biblionumber,
754 biblioitems => $self->biblionumber,
755 reserves => $self->unblessed,
760 C4::Letters::EnqueueLetter(
763 borrowernumber => $self->borrowernumber,
764 message_transport_type => 'email',
770 my $old_me = $self->_move_to_old;
776 payload => { hold => $old_me->get_from_storage }
780 # anonymize if required
782 if $patron->privacy == 2;
784 $self->SUPER::delete(); # Do not add a DELETE log
785 # now fix the priority on the others....
786 C4::Reserves::_FixPriority({ biblionumber => $self->biblionumber });
788 # and, if desired, charge a cancel fee
789 my $charge = C4::Context->preference("ExpireReservesMaxPickUpDelayCharge");
790 if ( $charge && $params->{'charge_cancel_fee'} ) {
792 Koha::Account->new( { patron_id => $self->borrowernumber } );
796 user_id => C4::Context->userenv ? C4::Context->userenv->{'number'} : undef,
797 interface => C4::Context->interface,
798 library_id => C4::Context->userenv ? C4::Context->userenv->{'branch'} : undef,
799 type => 'RESERVE_EXPIRED',
800 item_id => $self->itemnumber
805 C4::Log::logaction( 'HOLDS', 'CANCEL', $self->reserve_id, $self, undef, $original )
806 if C4::Context->preference('HoldsLog');
808 Koha::BackgroundJob::BatchUpdateBiblioHoldsQueue->new->enqueue(
810 biblio_ids => [ $old_me->biblionumber ]
812 ) unless $params->{skip_holds_queue} or !C4::Context->preference('RealTimeHoldsQueue');
816 if ($autofill_next) {
817 my ( undef, $next_hold ) = C4::Reserves::CheckReserves( $self->item );
819 my $is_transfer = $self->branchcode ne $next_hold->{branchcode};
821 C4::Reserves::ModReserveAffect( $self->itemnumber, $self->borrowernumber, $is_transfer, $next_hold->{reserve_id}, $self->desk_id, $autofill_next );
822 C4::Items::ModItemTransfer( $self->itemnumber, $self->branchcode, $next_hold->{branchcode}, "Reserve" ) if $is_transfer;
831 $hold->fill({ [ item_id => $item->id ] });
833 This method marks the hold as filled. It effectively moves it to old_reserves.
834 The optional I<item_id> parameter is used to set the information about the
835 item that filled the hold.
840 my ( $self, $params ) = @_;
841 $self->_result->result_source->schema->txn_do(
843 my $patron = $self->patron;
845 my $original = C4::Context->preference('HoldsLog') ? $self->unblessed : undef;
851 $params->{item_id} ? ( itemnumber => $params->{item_id} ) : (),
855 my $old_me = $self->_move_to_old;
861 payload => { hold => $old_me->get_from_storage }
865 # anonymize if required
867 if $patron->privacy == 2;
869 $self->SUPER::delete(); # Do not add a DELETE log
871 # now fix the priority on the others....
872 C4::Reserves::_FixPriority({ biblionumber => $self->biblionumber });
874 if ( C4::Context->preference('HoldFeeMode') eq 'any_time_is_collected' ) {
875 my $fee = $patron->category->reservefee // 0;
877 $patron->account->add_debit(
880 description => $self->biblio->title,
881 user_id => C4::Context->userenv ? C4::Context->userenv->{'number'} : undef,
882 library_id => C4::Context->userenv ? C4::Context->userenv->{'branch'} : undef,
883 interface => C4::Context->interface,
885 item_id => $self->itemnumber
891 C4::Log::logaction( 'HOLDS', 'FILL', $self->id, $self, undef, $original )
892 if C4::Context->preference('HoldsLog');
894 Koha::BackgroundJob::BatchUpdateBiblioHoldsQueue->new->enqueue(
896 biblio_ids => [ $old_me->biblionumber ]
898 ) if C4::Context->preference('RealTimeHoldsQueue');
904 =head3 sub change_type
906 $hold->change_type # to record level
907 $hold->change_type( $itemnumber ) # to item level
909 Changes hold type between record and item level holds, only if record has
910 exactly one hold for a patron. This is because Koha expects all holds for
911 a patron on a record to be alike.
916 my ( $self, $itemnumber ) = @_;
918 my $record_holds_per_patron = Koha::Holds->search(
920 borrowernumber => $self->borrowernumber,
921 biblionumber => $self->biblionumber,
925 if ( $itemnumber && $self->itemnumber ) {
926 $self->itemnumber($itemnumber)->store;
930 if ( $record_holds_per_patron->count == 1 ) {
933 itemnumber => $itemnumber ? $itemnumber : undef,
934 item_level_hold => $itemnumber ? 1 : 0,
938 Koha::Exceptions::Hold::CannotChangeHoldType->throw();
946 Override base store method to set default
947 expirationdate for holds.
952 my ($self, $params) = @_;
954 my $hold_reverted = $params->{hold_reverted} // 0;
956 Koha::Exceptions::Hold::MissingPickupLocation->throw() unless $self->branchcode;
958 if ( !$self->in_storage ) {
959 if ( ! $self->expirationdate && $self->patron_expiration_date ) {
960 $self->expirationdate($self->patron_expiration_date);
964 C4::Context->preference('DefaultHoldExpirationdate')
965 && !$self->expirationdate
968 $self->_set_default_expirationdate;
973 my %updated_columns = $self->_result->get_dirty_columns;
974 return $self->SUPER::store unless %updated_columns;
975 if ( exists $updated_columns{reservedate} || $hold_reverted ) {
978 C4::Context->preference('DefaultHoldExpirationdate')
979 && ( !exists $updated_columns{expirationdate} || $hold_reverted )
983 if ( $self->patron_expiration_date ) {
984 $self->expirationdate( $self->patron_expiration_date );
986 $self->_set_default_expirationdate;
992 $self = $self->SUPER::store;
995 sub _set_default_expirationdate {
998 my $period = C4::Context->preference('DefaultHoldExpirationdatePeriod') || 0;
1000 C4::Context->preference('DefaultHoldExpirationdateUnitOfTime') || 'days';
1002 $self->expirationdate(
1003 dt_from_string( $self->reservedate )->add( $timeunit => $period ) );
1008 my $is_moved = $hold->_move_to_old;
1010 Move a hold to the old_reserve table following the same pattern as Koha::Patron->move_to_deleted
1016 my $hold_infos = $self->unblessed;
1017 return Koha::Old::Hold->new( $hold_infos )->store;
1020 =head3 to_api_mapping
1022 This method returns the mapping for representing a Koha::Hold object
1027 sub to_api_mapping {
1029 reserve_id => 'hold_id',
1030 borrowernumber => 'patron_id',
1031 reservedate => 'hold_date',
1032 biblionumber => 'biblio_id',
1033 branchcode => 'pickup_library_id',
1034 notificationdate => undef,
1035 reminderdate => undef,
1036 cancellationdate => 'cancellation_date',
1037 reservenotes => 'notes',
1039 itemnumber => 'item_id',
1040 waitingdate => 'waiting_date',
1041 expirationdate => 'expiration_date',
1042 patron_expiration_date => undef,
1043 lowestPriority => 'lowest_priority',
1044 suspend => 'suspended',
1045 suspend_until => 'suspended_until',
1046 itemtype => 'item_type',
1047 item_level_hold => 'item_level',
1051 =head3 can_update_pickup_location_opac
1053 my $can_update_pickup_location_opac = $hold->can_update_pickup_location_opac;
1055 Returns if a hold can change pickup location from opac
1059 sub can_update_pickup_location_opac {
1062 my @statuses = split /,/, C4::Context->preference("OPACAllowUserToChangeBranch");
1063 foreach my $status ( @statuses ){
1064 return 1 if ($status eq 'pending' && !$self->is_found && !$self->is_suspended );
1065 return 1 if ($status eq 'intransit' && $self->is_in_transit);
1066 return 1 if ($status eq 'suspended' && $self->is_suspended);
1073 Returns a map of column name to string representations including the string.
1080 pickup_library_id => { str => $self->branch->branchname, type => 'library' },
1084 =head2 Internal methods
1096 Kyle M Hall <kyle@bywatersolutions.com>
1097 Jonathan Druart <jonathan.druart@bugs.koha-community.org>
1098 Martin Renvoize <martin.renvoize@ptfs-europe.com>