3 # Copyright ByWater Solutions 2014
5 # This file is part of Koha.
7 # Koha is free software; you can redistribute it and/or modify it
8 # under the terms of the GNU General Public License as published by
9 # the Free Software Foundation; either version 3 of the License, or
10 # (at your option) any later version.
12 # Koha is distributed in the hope that it will be useful, but
13 # WITHOUT ANY WARRANTY; without even the implied warranty of
14 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 # GNU General Public License for more details.
17 # You should have received a copy of the GNU General Public License
18 # along with Koha; if not, see <http://www.gnu.org/licenses>.
27 use base qw(Koha::Objects);
31 Koha::Holds - Koha Hold object set class
41 returns a set of holds that are waiting from an existing set
48 return $self->search( { found => 'W' } );
53 returns a set of holds that are processing from an existing set
60 return $self->search( { found => 'P' } );
65 returns a set of holds that are unfilled from an existing set
72 return $self->search( { found => undef } );
75 =head3 forced_hold_level
77 If a patron has multiple holds for a single record,
78 those holds must be either all record level holds,
79 or they must all be item level holds.
81 This method should be used with Hold sets where all
82 Hold objects share the same patron and record.
84 This method will return 'item' if the patron has
85 at least one item level hold. It will return 'record'
86 if the patron has holds but none are item level,
87 Finally, if the patron has no holds, it will return
88 undef which indicates the patron may select either
89 record or item level holds, barring any other rules
90 that would prevent one or the other.
94 sub forced_hold_level {
97 my $item_level_count = $self->search( { itemnumber => { '!=' => undef } } )->count();
98 return 'item' if $item_level_count > 0;
100 my $item_group_level_count = $self->search( { item_group_id => { '!=' => undef } } )->count();
101 return 'item_group' if $item_group_level_count > 0;
103 my $record_level_count = $self->search( { itemnumber => undef } )->count();
104 return 'record' if $record_level_count > 0;
109 =head3 get_items_that_can_fill
111 my $items = $holds->get_items_that_can_fill();
113 Return the list of items that can fill the hold set.
126 sub get_items_that_can_fill {
129 return Koha::Items->new->empty()
130 unless $self->count() > 0;
132 my @itemnumbers = $self->search({ 'me.itemnumber' => { '!=' => undef } })->get_column('itemnumber');
133 my @biblionumbers = $self->search({ 'me.itemnumber' => undef })->get_column('biblionumber');
135 push @bibs_or_items, 'me.itemnumber' => { in => \@itemnumbers } if @itemnumbers;
136 push @bibs_or_items, 'me.biblionumber' => { in => \@biblionumbers } if @biblionumbers;
138 my @branchtransfers = Koha::Item::Transfers->filter_by_current->search({}, {
139 columns => ['itemnumber'],
142 )->get_column('itemnumber');
143 my @waiting_holds = Koha::Holds->search(
146 columns => ['itemnumber'],
149 )->get_column('itemnumber');
151 return Koha::Items->search(
153 -or => \@bibs_or_items,
154 itemnumber => { -not_in => [ @branchtransfers, @waiting_holds ] },
158 )->filter_by_for_hold();
161 =head3 filter_by_has_cancellation_requests
163 my $with_cancellation_reqs = $holds->filter_by_has_cancellation_requests;
165 Returns a filtered resultset only containing holds that have cancellation requests.
169 sub filter_by_has_cancellation_requests {
172 return $self->search( { 'hold_cancellation_request_id' => { '!=' => undef } },
173 { join => 'cancellation_requests' } );
176 =head3 filter_out_has_cancellation_requests
178 my $holds_without_cancellation_requests = $holds->filter_out_has_cancellation_requests;
180 Returns a filtered resultset without holds with cancellation requests.
184 sub filter_out_has_cancellation_requests {
187 return $self->search( { 'hold_cancellation_request_id' => { '=' => undef } },
188 { join => 'cancellation_requests' } );
191 =head2 Internal methods
211 Kyle M Hall <kyle@bywatersolutions.com>