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 unfilled from an existing set
60 return $self->search( { found => undef } );
63 =head3 forced_hold_level
65 If a patron has multiple holds for a single record,
66 those holds must be either all record level holds,
67 or they must all be item level holds.
69 This method should be used with Hold sets where all
70 Hold objects share the same patron and record.
72 This method will return 'item' if the patron has
73 at least one item level hold. It will return 'record'
74 if the patron has holds but none are item level,
75 Finally, if the patron has no holds, it will return
76 undef which indicates the patron may select either
77 record or item level holds, barring any other rules
78 that would prevent one or the other.
82 sub forced_hold_level {
85 my $item_level_count = $self->search( { itemnumber => { '!=' => undef } } )->count();
86 return 'item' if $item_level_count > 0;
88 my $item_group_level_count = $self->search( { item_group_id => { '!=' => undef } } )->count();
89 return 'item_group' if $item_group_level_count > 0;
91 my $record_level_count = $self->search( { itemnumber => undef } )->count();
92 return 'record' if $record_level_count > 0;
97 =head3 get_items_that_can_fill
99 my $items = $holds->get_items_that_can_fill();
101 Return the list of items that can fill the hold set.
114 sub get_items_that_can_fill {
117 return Koha::Items->new->empty()
118 unless $self->count() > 0;
120 my @itemnumbers = $self->search({ 'me.itemnumber' => { '!=' => undef } })->get_column('itemnumber');
121 my @biblionumbers = $self->search({ 'me.itemnumber' => undef })->get_column('biblionumber');
123 push @bibs_or_items, 'me.itemnumber' => { in => \@itemnumbers } if @itemnumbers;
124 push @bibs_or_items, 'me.biblionumber' => { in => \@biblionumbers } if @biblionumbers;
126 my @branchtransfers = Koha::Item::Transfers->filter_by_current->search({}, {
127 columns => ['itemnumber'],
130 )->get_column('itemnumber');
131 my @waiting_holds = Koha::Holds->search(
134 columns => ['itemnumber'],
137 )->get_column('itemnumber');
139 return Koha::Items->search(
141 -or => \@bibs_or_items,
142 itemnumber => { -not_in => [ @branchtransfers, @waiting_holds ] },
146 )->filter_by_for_hold();
149 =head3 filter_by_has_cancellation_requests
151 my $with_cancellation_reqs = $holds->filter_by_has_cancellation_requests;
153 Returns a filtered resultset only containing holds that have cancellation requests.
157 sub filter_by_has_cancellation_requests {
160 return $self->search( { 'hold_cancellation_request_id' => { '!=' => undef } },
161 { join => 'cancellation_requests' } );
164 =head3 filter_out_has_cancellation_requests
166 my $holds_without_cancellation_requests = $holds->filter_out_has_cancellation_requests;
168 Returns a filtered resultset without holds with cancellation requests.
172 sub filter_out_has_cancellation_requests {
175 return $self->search( { 'hold_cancellation_request_id' => { '=' => undef } },
176 { join => 'cancellation_requests' } );
179 =head2 Internal methods
199 Kyle M Hall <kyle@bywatersolutions.com>