3 # Copyright 2019 Koha Development team
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>.
22 use Test::More tests => 4;
29 use t::lib::TestBuilder;
32 my $schema = Koha::Database->new->schema;
33 my $builder = t::lib::TestBuilder->new;
35 subtest 'hidden_in_opac() tests' => sub {
39 $schema->storage->txn_begin;
41 my $item = $builder->build_sample_item({ itemlost => 2 });
44 # disable hidelostitems as it interteres with OpachiddenItems for the calculation
45 t::lib::Mocks::mock_preference( 'hidelostitems', 0 );
47 ok( !$item->hidden_in_opac, 'No rules passed, shouldn\'t hide' );
48 ok( !$item->hidden_in_opac({ rules => $rules }), 'Empty rules passed, shouldn\'t hide' );
50 # enable hidelostitems to verify correct behaviour
51 t::lib::Mocks::mock_preference( 'hidelostitems', 1 );
52 ok( $item->hidden_in_opac, 'Even with no rules, item should hide because of hidelostitems syspref' );
54 # disable hidelostitems
55 t::lib::Mocks::mock_preference( 'hidelostitems', 0 );
56 my $withdrawn = $item->withdrawn + 1; # make sure this attribute doesn't match
58 $rules = { withdrawn => [$withdrawn], itype => [ $item->itype ] };
60 ok( $item->hidden_in_opac({ rules => $rules }), 'Rule matching itype passed, should hide' );
64 $schema->storage->txn_rollback;
67 subtest 'has_pending_hold() tests' => sub {
71 $schema->storage->txn_begin;
73 my $dbh = C4::Context->dbh;
74 my $item = $builder->build_sample_item({ itemlost => 0 });
75 my $itemnumber = $item->itemnumber;
77 $dbh->do("INSERT INTO tmp_holdsqueue (surname,borrowernumber,itemnumber) VALUES ('Clamp',42,$itemnumber)");
78 ok( $item->has_pending_hold, "Yes, we have a pending hold");
79 $dbh->do("DELETE FROM tmp_holdsqueue WHERE itemnumber=$itemnumber");
80 ok( !$item->has_pending_hold, "We don't have a pending hold if nothing in the tmp_holdsqueue");
82 $schema->storage->txn_rollback;
85 subtest "as_marc_field() tests" => sub {
87 my $mss = C4::Biblio::GetMarcSubfieldStructure( '', { unsafe => 1 } );
89 my @schema_columns = $schema->resultset('Item')->result_source->columns;
90 my @mapped_columns = grep { exists $mss->{'items.'.$_} } @schema_columns;
92 plan tests => 2 * (scalar @mapped_columns + 1) + 1;
94 $schema->storage->txn_begin;
96 my $item = $builder->build_sample_item;
98 # Tests with the mss parameter
99 my $marc_field = $item->as_marc_field({ mss => $mss });
103 $mss->{'items.itemnumber'}[0]->{tagfield},
104 'Generated field set the right tag number'
107 foreach my $column ( @mapped_columns ) {
108 my $tagsubfield = $mss->{ 'items.' . $column }[0]->{tagsubfield};
109 is( $marc_field->subfield($tagsubfield),
110 $item->$column, "Value is mapped correctly for column $column" );
113 # Tests without the mss parameter
114 $marc_field = $item->as_marc_field();
118 $mss->{'items.itemnumber'}[0]->{tagfield},
119 'Generated field set the right tag number'
122 foreach my $column (@mapped_columns) {
123 my $tagsubfield = $mss->{ 'items.' . $column }[0]->{tagsubfield};
124 is( $marc_field->subfield($tagsubfield),
125 $item->$column, "Value is mapped correctly for column $column" );
128 my $unmapped_subfield = Koha::MarcSubfieldStructure->new(
131 tagfield => $mss->{'items.itemnumber'}[0]->{tagfield},
136 $mss = C4::Biblio::GetMarcSubfieldStructure( '', { unsafe => 0 } );
137 my @unlinked_subfields;
138 push @unlinked_subfields, X => 'Something weird';
139 $item->more_subfields_xml( C4::Items::_get_unlinked_subfields_xml( \@unlinked_subfields ) )->store;
141 $marc_field = $item->as_marc_field;
142 is( scalar $marc_field->subfield('X'), 'Something weird', 'more_subfield_xml is considered' );
144 $schema->storage->txn_rollback;
147 subtest 'pickup_locations' => sub {
150 $schema->storage->txn_begin;
152 my $dbh = C4::Context->dbh;
155 Koha::Holds->search->delete;
156 Koha::Patrons->search->delete;
157 Koha::Items->search->delete;
158 Koha::Libraries->search->delete;
159 $dbh->do('DELETE FROM issues');
160 $dbh->do('DELETE FROM issuingrules');
162 q{INSERT INTO issuingrules (categorycode, branchcode, itemtype, reservesallowed)
163 VALUES (?, ?, ?, ?)},
167 $dbh->do('DELETE FROM circulation_rules');
169 my $root1 = $builder->build_object( { class => 'Koha::Library::Groups', value => { ft_local_hold_group => 1 } } );
170 my $root2 = $builder->build_object( { class => 'Koha::Library::Groups', value => { ft_local_hold_group => 1 } } );
172 my $library1 = $builder->build_object( { class => 'Koha::Libraries', value => { pickup_location => 1 } } );
173 my $library2 = $builder->build_object( { class => 'Koha::Libraries', value => { pickup_location => 1 } } );
174 my $library3 = $builder->build_object( { class => 'Koha::Libraries', value => { pickup_location => 0 } } );
175 my $library4 = $builder->build_object( { class => 'Koha::Libraries', value => { pickup_location => 1 } } );
177 my $group1_1 = $builder->build_object( { class => 'Koha::Library::Groups', value => { parent_id => $root1->id, branchcode => $library1->branchcode } } );
178 my $group1_2 = $builder->build_object( { class => 'Koha::Library::Groups', value => { parent_id => $root1->id, branchcode => $library2->branchcode } } );
180 my $group2_1 = $builder->build_object( { class => 'Koha::Library::Groups', value => { parent_id => $root2->id, branchcode => $library3->branchcode } } );
181 my $group2_2 = $builder->build_object( { class => 'Koha::Library::Groups', value => { parent_id => $root2->id, branchcode => $library4->branchcode } } );
183 my $biblioitem = $builder->build( { source => 'Biblioitem' } );
185 my $item1 = Koha::Item->new({
186 biblionumber => $biblioitem->{biblionumber},
187 biblioitemnumber => $biblioitem->{biblioitemnumber},
188 homebranch => $library1->branchcode,
189 holdingbranch => $library2->branchcode,
194 my $item3 = Koha::Item->new({
195 biblionumber => $biblioitem->{biblionumber},
196 biblioitemnumber => $biblioitem->{biblioitemnumber},
197 homebranch => $library3->branchcode,
198 holdingbranch => $library4->branchcode,
203 my $patron1 = $builder->build_object( { class => 'Koha::Patrons', value => { branchcode => $library1->branchcode, firstname => '1' } } );
204 my $patron4 = $builder->build_object( { class => 'Koha::Patrons', value => { branchcode => $library4->branchcode, firstname => '4' } } );
208 "1-1-1-holdgroup" => 2,
209 "1-1-1-patrongroup" => 2,
210 "1-1-1-homebranch" => 1,
211 "1-1-1-holdingbranch" => 1,
213 "1-1-2-holdgroup" => 2,
214 "1-1-2-patrongroup" => 2,
215 "1-1-2-homebranch" => 1,
216 "1-1-2-holdingbranch" => 1,
218 "1-1-3-holdgroup" => 2,
219 "1-1-3-patrongroup" => 2,
220 "1-1-3-homebranch" => 1,
221 "1-1-3-holdingbranch" => 1,
223 "1-4-1-holdgroup" => 0,
224 "1-4-1-patrongroup" => 0,
225 "1-4-1-homebranch" => 0,
226 "1-4-1-holdingbranch" => 0,
228 "1-4-2-holdgroup" => 2,
229 "1-4-2-patrongroup" => 1,
230 "1-4-2-homebranch" => 1,
231 "1-4-2-holdingbranch" => 1,
233 "1-4-3-holdgroup" => 0,
234 "1-4-3-patrongroup" => 0,
235 "1-4-3-homebranch" => 0,
236 "1-4-3-holdingbranch" => 0,
238 "3-1-1-holdgroup" => 0,
239 "3-1-1-patrongroup" => 0,
240 "3-1-1-homebranch" => 0,
241 "3-1-1-holdingbranch" => 0,
243 "3-1-2-holdgroup" => 1,
244 "3-1-2-patrongroup" => 2,
245 "3-1-2-homebranch" => 0,
246 "3-1-2-holdingbranch" => 1,
248 "3-1-3-holdgroup" => 0,
249 "3-1-3-patrongroup" => 0,
250 "3-1-3-homebranch" => 0,
251 "3-1-3-holdingbranch" => 0,
253 "3-4-1-holdgroup" => 0,
254 "3-4-1-patrongroup" => 0,
255 "3-4-1-homebranch" => 0,
256 "3-4-1-holdingbranch" => 0,
258 "3-4-2-holdgroup" => 1,
259 "3-4-2-patrongroup" => 1,
260 "3-4-2-homebranch" => 0,
261 "3-4-2-holdingbranch" => 1,
263 "3-4-3-holdgroup" => 1,
264 "3-4-3-patrongroup" => 1,
265 "3-4-3-homebranch" => 0,
266 "3-4-3-holdingbranch" => 1
270 my ( $item, $patron, $ha, $hfp, $results ) = @_;
272 Koha::CirculationRules->set_rules(
276 categorycode => undef,
279 hold_fulfillment_policy => $hfp,
280 returnbranch => 'any'
284 my @pl = $item->pickup_locations( { patron => $patron} );
285 my $ha_value=$ha==3?'holdgroup':($ha==2?'any':'homebranch');
287 foreach my $pickup_location (@pl) {
288 is( ref($pickup_location), 'Koha::Library', 'Object type is correct' );
292 scalar(@pl) == $results->{
294 . $patron->firstname . '-'
304 . ', hold_fulfillment_policy: '
309 . $patron->firstname . '-'
320 foreach my $item ($item1, $item3) {
321 foreach my $patron ($patron1, $patron4) {
322 #holdallowed 1: homebranch, 2: any, 3: holdgroup
323 foreach my $ha (1, 2, 3) {
324 foreach my $hfp ('any', 'holdgroup', 'patrongroup', 'homebranch', 'holdingbranch') {
325 _doTest($item, $patron, $ha, $hfp, $results);
331 $schema->storage->txn_rollback;