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' } );
55 return $self->search( { found => 'P' } );
60 returns a set of holds that are unfilled from an existing set
67 return $self->search( { found => undef } );
70 =head3 forced_hold_level
72 If a patron has multiple holds for a single record,
73 those holds must be either all record level holds,
74 or they must all be item level holds.
76 This method should be used with Hold sets where all
77 Hold objects share the same patron and record.
79 This method will return 'item' if the patron has
80 at least one item level hold. It will return 'record'
81 if the patron has holds but none are item level,
82 Finally, if the patron has no holds, it will return
83 undef which indicates the patron may select either
84 record or item level holds, barring any other rules
85 that would prevent one or the other.
89 sub forced_hold_level {
92 my $item_level_count = $self->search( { itemnumber => { '!=' => undef } } )->count();
93 return 'item' if $item_level_count > 0;
95 my $item_group_level_count = $self->search( { item_group_id => { '!=' => undef } } )->count();
96 return 'item_group' if $item_group_level_count > 0;
98 my $record_level_count = $self->search( { itemnumber => undef } )->count();
99 return 'record' if $record_level_count > 0;
104 =head3 get_items_that_can_fill
106 my $items = $holds->get_items_that_can_fill();
108 Return the list of items that can fill the hold set.
121 sub get_items_that_can_fill {
124 return Koha::Items->new->empty()
125 unless $self->count() > 0;
127 my @itemnumbers = $self->search({ 'me.itemnumber' => { '!=' => undef } })->get_column('itemnumber');
128 my @biblionumbers = $self->search({ 'me.itemnumber' => undef })->get_column('biblionumber');
130 push @bibs_or_items, 'me.itemnumber' => { in => \@itemnumbers } if @itemnumbers;
131 push @bibs_or_items, 'me.biblionumber' => { in => \@biblionumbers } if @biblionumbers;
133 my @branchtransfers = Koha::Item::Transfers->filter_by_current->search({}, {
134 columns => ['itemnumber'],
137 )->get_column('itemnumber');
138 my @waiting_holds = Koha::Holds->search(
141 columns => ['itemnumber'],
144 )->get_column('itemnumber');
146 return Koha::Items->search(
148 -or => \@bibs_or_items,
149 itemnumber => { -not_in => [ @branchtransfers, @waiting_holds ] },
153 )->filter_by_for_hold();
156 =head3 filter_by_has_cancellation_requests
158 my $with_cancellation_reqs = $holds->filter_by_has_cancellation_requests;
160 Returns a filtered resultset only containing holds that have cancellation requests.
164 sub filter_by_has_cancellation_requests {
167 return $self->search( { 'hold_cancellation_request_id' => { '!=' => undef } },
168 { join => 'cancellation_requests' } );
171 =head3 filter_out_has_cancellation_requests
173 my $holds_without_cancellation_requests = $holds->filter_out_has_cancellation_requests;
175 Returns a filtered resultset without holds with cancellation requests.
179 sub filter_out_has_cancellation_requests {
182 return $self->search( { 'hold_cancellation_request_id' => { '=' => undef } },
183 { join => 'cancellation_requests' } );
186 =head2 Internal methods
206 Kyle M Hall <kyle@bywatersolutions.com>