3 # This file is part of Koha.
5 # Koha is free software; you can redistribute it and/or modify it under the
6 # terms of the GNU General Public License as published by the Free Software
7 # Foundation; either version 2 of the License, or (at your option) any later
10 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
11 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
12 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
14 # You should have received a copy of the GNU General Public License along
15 # with Koha; if not, write to the Free Software Foundation, Inc.,
16 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
27 use t
::lib
::TestBuilder
;
29 use Test
::More tests
=> 9;
35 use_ok
('Koha::Items');
38 my $schema = Koha
::Database
->new->schema;
39 my $location = 'My Location';
41 subtest
'General Add, Get and Del tests' => sub {
45 $schema->storage->txn_begin;
47 my $builder = t
::lib
::TestBuilder
->new;
48 my $library = $builder->build({
52 # Create a biblio instance for testing
53 C4
::Context
->set_preference('marcflavour', 'MARC21');
54 my ($bibnum, $bibitemnum) = get_biblio
();
57 my ($item_bibnum, $item_bibitemnum, $itemnumber) = AddItem
({ homebranch
=> $library->{branchcode
}, holdingbranch
=> $library->{branchcode
}, location
=> $location } , $bibnum);
58 cmp_ok
($item_bibnum, '==', $bibnum, "New item is linked to correct biblionumber.");
59 cmp_ok
($item_bibitemnum, '==', $bibitemnum, "New item is linked to correct biblioitemnumber.");
62 my $getitem = GetItem
($itemnumber);
63 cmp_ok
($getitem->{'itemnumber'}, '==', $itemnumber, "Retrieved item has correct itemnumber.");
64 cmp_ok
($getitem->{'biblioitemnumber'}, '==', $item_bibitemnum, "Retrieved item has correct biblioitemnumber.");
65 is
( $getitem->{location
}, $location, "The location should not have been modified" );
66 is
( $getitem->{permanent_location
}, $location, "The permanent_location should have been set to the location value" );
68 # Modify item; setting barcode.
69 ModItem
({ barcode
=> '987654321' }, $bibnum, $itemnumber);
70 my $moditem = GetItem
($itemnumber);
71 cmp_ok
($moditem->{'barcode'}, '==', '987654321', 'Modified item barcode successfully to: '.$moditem->{'barcode'} . '.');
74 DelItem
({ biblionumber
=> $bibnum, itemnumber
=> $itemnumber });
75 my $getdeleted = GetItem
($itemnumber);
76 is
($getdeleted->{'itemnumber'}, undef, "Item deleted as expected.");
78 ($item_bibnum, $item_bibitemnum, $itemnumber) = AddItem
({ homebranch
=> $library->{branchcode
}, holdingbranch
=> $library->{branchcode
}, location
=> $location, permanent_location
=> 'my permanent location' } , $bibnum);
79 $getitem = GetItem
($itemnumber);
80 is
( $getitem->{location
}, $location, "The location should not have been modified" );
81 is
( $getitem->{permanent_location
}, 'my permanent location', "The permanent_location should not have modified" );
83 ModItem
({ location
=> $location }, $bibnum, $itemnumber);
84 $getitem = GetItem
($itemnumber);
85 is
( $getitem->{location
}, $location, "The location should have been set to correct location" );
86 is
( $getitem->{permanent_location
}, $location, "The permanent_location should have been set to location" );
88 ModItem
({ location
=> 'CART' }, $bibnum, $itemnumber);
89 $getitem = GetItem
($itemnumber);
90 is
( $getitem->{location
}, 'CART', "The location should have been set to CART" );
91 is
( $getitem->{permanent_location
}, $location, "The permanent_location should not have been set to CART" );
93 $schema->storage->txn_rollback;
96 subtest
'GetHiddenItemnumbers tests' => sub {
100 # This sub is controlled by the OpacHiddenItems system preference.
102 $schema->storage->txn_begin;
104 my $builder = t
::lib
::TestBuilder
->new;
105 my $library1 = $builder->build({
109 my $library2 = $builder->build({
113 # Create a new biblio
114 C4
::Context
->set_preference('marcflavour', 'MARC21');
115 my ($biblionumber, $biblioitemnumber) = get_biblio
();
118 my ($item1_bibnum, $item1_bibitemnum, $item1_itemnumber) = AddItem
(
119 { homebranch
=> $library1->{branchcode
},
120 holdingbranch
=> $library1->{branchcode
},
124 my ($item2_bibnum, $item2_bibitemnum, $item2_itemnumber) = AddItem
(
125 { homebranch
=> $library2->{branchcode
},
126 holdingbranch
=> $library2->{branchcode
},
132 my @itemnumbers = ($item1_itemnumber,$item2_itemnumber);
135 push @items, GetItem
( $item1_itemnumber );
136 push @items, GetItem
( $item2_itemnumber );
138 # Empty OpacHiddenItems
139 C4
::Context
->set_preference('OpacHiddenItems','');
140 ok
( !defined( GetHiddenItemnumbers
( @items ) ),
141 "Hidden items list undef if OpacHiddenItems empty");
144 C4
::Context
->set_preference('OpacHiddenItems',' ');
145 ok
( scalar GetHiddenItemnumbers
( @items ) == 0,
146 "Hidden items list empty if OpacHiddenItems only contains blanks");
148 # One variable / value
151 C4
::Context
->set_preference( 'OpacHiddenItems', $opachiddenitems );
152 @hidden = GetHiddenItemnumbers
( @items );
153 ok
( scalar @hidden == 1, "Only one hidden item");
154 is
( $hidden[0], $item1_itemnumber, "withdrawn=1 is hidden");
156 # One variable, two values
159 C4
::Context
->set_preference( 'OpacHiddenItems', $opachiddenitems );
160 @hidden = GetHiddenItemnumbers
( @items );
161 ok
( scalar @hidden == 2, "Two items hidden");
162 is_deeply
( \
@hidden, \
@itemnumbers, "withdrawn=1 and withdrawn=0 hidden");
164 # Two variables, a value each
167 homebranch: [$library2->{branchcode}]
169 C4
::Context
->set_preference( 'OpacHiddenItems', $opachiddenitems );
170 @hidden = GetHiddenItemnumbers
( @items );
171 ok
( scalar @hidden == 2, "Two items hidden");
172 is_deeply
( \
@hidden, \
@itemnumbers, "withdrawn=1 and homebranch library2 hidden");
174 # Valid OpacHiddenItems, empty list
176 @hidden = GetHiddenItemnumbers
( @items );
177 ok
( scalar @hidden == 0, "Empty items list, no item hidden");
179 $schema->storage->txn_rollback;
182 subtest
'GetItemsInfo tests' => sub {
186 $schema->storage->txn_begin;
188 my $builder = t
::lib
::TestBuilder
->new;
189 my $library1 = $builder->build({
192 my $library2 = $builder->build({
197 my ($biblionumber, $biblioitemnumber) = get_biblio
();
199 my ($item_bibnum, $item_bibitemnum, $itemnumber)
201 homebranch
=> $library1->{branchcode
},
202 holdingbranch
=> $library2->{branchcode
},
205 my $branch = GetBranchDetail
( $library1->{branchcode
} );
206 $branch->{ opac_info
} = "homebranch OPAC info";
209 $branch = GetBranchDetail
( $library2->{branchcode
} );
210 $branch->{ opac_info
} = "holdingbranch OPAC info";
213 my @results = GetItemsInfo
( $biblionumber );
214 ok
( @results, 'GetItemsInfo returns results');
215 is
( $results[0]->{ home_branch_opac_info
}, "homebranch OPAC info",
216 'GetItemsInfo returns the correct home branch OPAC info notice' );
217 is
( $results[0]->{ holding_branch_opac_info
}, "holdingbranch OPAC info",
218 'GetItemsInfo returns the correct holding branch OPAC info notice' );
219 is
( exists( $results[0]->{ onsite_checkout
} ), 1,
220 'GetItemsInfo returns a onsite_checkout key' );
222 $schema->storage->txn_rollback;
225 subtest
q{Test Koha::Database->schema()->resultset('Item')->itemtype()} => sub {
229 $schema->storage->txn_begin;
232 $schema->resultset('Biblio')->create(
234 title
=> "Test title",
237 itemtype
=> 'BIB_LEVEL',
238 items
=> [ { itype
=> "ITEM_LEVEL" } ]
244 my @bi = $biblio->biblioitems();
245 my ( $item ) = $bi[0]->items();
247 C4
::Context
->set_preference( 'item-level_itypes', 0 );
248 ok
( $item->effective_itemtype() eq 'BIB_LEVEL', '$item->itemtype() returns biblioitem.itemtype when item-level_itypes is disabled' );
250 C4
::Context
->set_preference( 'item-level_itypes', 1 );
251 ok
( $item->effective_itemtype() eq 'ITEM_LEVEL', '$item->itemtype() returns items.itype when item-level_itypes is enabled' );
253 # If itemtype is not defined and item-level_level item types are set
254 # fallback to biblio-level itemtype (Bug 14651) and warn
255 $item->itype( undef );
257 my $effective_itemtype;
258 warning_is
{ $effective_itemtype = $item->effective_itemtype() }
259 "item-level_itypes set but no itemtype set for item ($item->itemnumber)",
260 '->effective_itemtype() raises a warning when falling back to bib-level';
262 ok
( defined $effective_itemtype &&
263 $effective_itemtype eq 'BIB_LEVEL',
264 '$item->effective_itemtype() falls back to biblioitems.itemtype when item-level_itypes is enabled but undef' );
266 $schema->storage->txn_rollback;
269 subtest
'SearchItems test' => sub {
272 $schema->storage->txn_begin;
273 my $dbh = C4
::Context
->dbh;
274 my $builder = t
::lib
::TestBuilder
->new;
276 my $library1 = $builder->build({
279 my $library2 = $builder->build({
283 C4
::Context
->set_preference('marcflavour', 'MARC21');
284 my $cpl_items_before = SearchItemsByField
( 'homebranch', $library1->{branchcode
});
286 my ($biblionumber) = get_biblio
();
288 my (undef, $initial_items_count) = SearchItems
(undef, {rows
=> 1});
291 my (undef, undef, $item1_itemnumber) = AddItem
({
292 homebranch
=> $library1->{branchcode
},
293 holdingbranch
=> $library1->{branchcode
},
295 my (undef, undef, $item2_itemnumber) = AddItem
({
296 homebranch
=> $library2->{branchcode
},
297 holdingbranch
=> $library2->{branchcode
},
300 my ($items, $total_results);
302 ($items, $total_results) = SearchItems
();
303 is
($total_results, $initial_items_count + 2, "Created 2 new items");
304 is
(scalar @
$items, $total_results, "SearchItems() returns all items");
306 ($items, $total_results) = SearchItems
(undef, {rows
=> 1});
307 is
($total_results, $initial_items_count + 2);
308 is
(scalar @
$items, 1, "SearchItems(undef, {rows => 1}) returns only 1 item");
310 # Search all items where homebranch = 'CPL'
312 field
=> 'homebranch',
313 query
=> $library1->{branchcode
},
316 ($items, $total_results) = SearchItems
($filter);
317 ok
($total_results > 0, "There is at least one CPL item");
318 my $all_items_are_CPL = 1;
319 foreach my $item (@
$items) {
320 if ($item->{homebranch
} ne $library1->{branchcode
}) {
321 $all_items_are_CPL = 0;
325 ok
($all_items_are_CPL, "All items returned by SearchItems are from CPL");
327 # Search all items where homebranch != 'CPL'
329 field
=> 'homebranch',
330 query
=> $library1->{branchcode
},
333 ($items, $total_results) = SearchItems
($filter);
334 ok
($total_results > 0, "There is at least one non-CPL item");
335 my $all_items_are_not_CPL = 1;
336 foreach my $item (@
$items) {
337 if ($item->{homebranch
} eq $library1->{branchcode
}) {
338 $all_items_are_not_CPL = 0;
342 ok
($all_items_are_not_CPL, "All items returned by SearchItems are not from CPL");
344 # Search all items where biblio title (245$a) is like 'Silence in the %'
346 field
=> 'marc:245$a',
347 query
=> 'Silence in the %',
350 ($items, $total_results) = SearchItems
($filter);
351 ok
($total_results >= 2, "There is at least 2 items with a biblio title like 'Silence in the %'");
353 # Search all items where biblio title is 'Silence in the library'
354 # and homebranch is 'CPL'
356 conjunction
=> 'AND',
359 field
=> 'marc:245$a',
360 query
=> 'Silence in the %',
364 field
=> 'homebranch',
365 query
=> $library1->{branchcode
},
370 ($items, $total_results) = SearchItems
($filter);
372 foreach my $item (@
$items) {
373 if ($item->{itemnumber
} == $item1_itemnumber) {
378 ok
($found, "item1 found");
380 my ($itemfield) = GetMarcFromKohaField
('items.itemnumber', '');
382 # Create item subfield 'z' without link
383 $dbh->do('DELETE FROM marc_subfield_structure WHERE tagfield=? AND tagsubfield="z" AND frameworkcode=""', undef, $itemfield);
384 $dbh->do('INSERT INTO marc_subfield_structure (tagfield, tagsubfield, frameworkcode) VALUES (?, "z", "")', undef, $itemfield);
387 $C4::Context
::context
->{marcfromkohafield
} = undef;
388 $C4::Biblio
::inverted_field_map
= undef;
390 my $item3_record = new MARC
::Record
;
391 $item3_record->append_fields(
392 new MARC
::Field
($itemfield, '', '', 'z' => 'foobar')
394 my (undef, undef, $item3_itemnumber) = AddItemFromMarc
($item3_record,
397 # Search item where item subfield z is "foobar"
399 field
=> 'marc:' . $itemfield . '$z',
403 ($items, $total_results) = SearchItems
($filter);
404 ok
(scalar @
$items == 1, 'found 1 item with $z = "foobar"');
406 # Link $z to items.itemnotes (and make sure there is no other subfields
408 $dbh->do('DELETE FROM marc_subfield_structure WHERE kohafield="items.itemnotes" AND frameworkcode=""', undef, $itemfield);
409 $dbh->do('UPDATE marc_subfield_structure SET kohafield="items.itemnotes" WHERE tagfield=? AND tagsubfield="z" AND frameworkcode=""', undef, $itemfield);
412 $C4::Context
::context
->{marcfromkohafield
} = undef;
413 $C4::Biblio
::inverted_field_map
= undef;
415 ModItemFromMarc
($item3_record, $biblionumber, $item3_itemnumber);
417 # Make sure the link is used
418 my $item3 = GetItem
($item3_itemnumber);
419 ok
($item3->{itemnotes
} eq 'foobar', 'itemnotes eq "foobar"');
421 # Do the same search again.
422 # This time it will search in items.itemnotes
423 ($items, $total_results) = SearchItems
($filter);
424 ok
(scalar @
$items == 1, 'found 1 item with itemnotes = "foobar"');
426 my $cpl_items_after = SearchItemsByField
( 'homebranch', $library1->{branchcode
});
427 is
( ( scalar( @
$cpl_items_after ) - scalar ( @
$cpl_items_before ) ), 1, 'SearchItemsByField should return something' );
429 $schema->storage->txn_rollback;
432 subtest
'Koha::Item(s) tests' => sub {
436 $schema->storage->txn_begin();
438 my $builder = t
::lib
::TestBuilder
->new;
439 my $library1 = $builder->build({
442 my $library2 = $builder->build({
446 # Create a biblio and item for testing
447 C4
::Context
->set_preference('marcflavour', 'MARC21');
448 my ($bibnum, $bibitemnum) = get_biblio
();
449 my ($item_bibnum, $item_bibitemnum, $itemnumber) = AddItem
({ homebranch
=> $library1->{branchcode
}, holdingbranch
=> $library2->{branchcode
} } , $bibnum);
452 my $item = Koha
::Items
->find( $itemnumber );
453 is
( ref($item), 'Koha::Item', "Got Koha::Item" );
455 my $homebranch = $item->home_branch();
456 is
( ref($homebranch), 'Koha::Branch', "Got Koha::Branch from home_branch method" );
457 is
( $homebranch->branchcode(), $library1->{branchcode
}, "Home branch code matches homebranch" );
459 my $holdingbranch = $item->holding_branch();
460 is
( ref($holdingbranch), 'Koha::Branch', "Got Koha::Branch from holding_branch method" );
461 is
( $holdingbranch->branchcode(), $library2->{branchcode
}, "Home branch code matches holdingbranch" );
463 $schema->storage->txn_rollback;
466 subtest
'C4::Biblio::EmbedItemsInMarcBiblio' => sub {
469 $schema->storage->txn_begin();
471 my $builder = t
::lib
::TestBuilder
->new;
472 my $library1 = $builder->build({
475 my $library2 = $builder->build({
479 my ( $biblionumber, $biblioitemnumber ) = get_biblio
();
481 { homebranch
=> $library1->{branchcode
}, holdingbranch
=> $library1->{branchcode
} },
482 { homebranch
=> $library1->{branchcode
}, holdingbranch
=> $library1->{branchcode
} },
483 { homebranch
=> $library1->{branchcode
}, holdingbranch
=> $library1->{branchcode
} },
484 { homebranch
=> $library2->{branchcode
}, holdingbranch
=> $library2->{branchcode
} },
485 { homebranch
=> $library2->{branchcode
}, holdingbranch
=> $library2->{branchcode
} },
486 { homebranch
=> $library1->{branchcode
}, holdingbranch
=> $library2->{branchcode
} },
487 { homebranch
=> $library1->{branchcode
}, holdingbranch
=> $library2->{branchcode
} },
488 { homebranch
=> $library1->{branchcode
}, holdingbranch
=> $library2->{branchcode
} },
490 my $number_of_items = scalar @
$item_infos;
491 my $number_of_items_with_homebranch_is_CPL =
492 grep { $_->{homebranch
} eq $library1->{branchcode
} } @
$item_infos;
495 for my $item_info (@
$item_infos) {
496 my ( undef, undef, $itemnumber ) = AddItem
(
498 homebranch
=> $item_info->{homebranch
},
499 holdingbranch
=> $item_info->{holdingbanch
}
503 push @itemnumbers, $itemnumber;
506 # Emptied the OpacHiddenItems pref
507 t
::lib
::Mocks
::mock_preference
( 'OpacHiddenItems', '' );
510 C4
::Biblio
::GetMarcFromKohaField
( 'items.itemnumber', '' );
511 my $record = C4
::Biblio
::GetMarcBiblio
($biblionumber);
512 warning_is
{ C4
::Biblio
::EmbedItemsInMarcBiblio
() }
513 { carped
=> 'EmbedItemsInMarcBiblio: No MARC record passed' },
514 'Should crap is no record passed.';
516 C4
::Biblio
::EmbedItemsInMarcBiblio
( $record, $biblionumber );
517 my @items = $record->field($itemfield);
518 is
( scalar @items, $number_of_items, 'Should return all items' );
520 C4
::Biblio
::EmbedItemsInMarcBiblio
( $record, $biblionumber,
521 [ $itemnumbers[1], $itemnumbers[3] ] );
522 @items = $record->field($itemfield);
523 is
( scalar @items, 2, 'Should return all items present in the list' );
525 C4
::Biblio
::EmbedItemsInMarcBiblio
( $record, $biblionumber, undef, 1 );
526 @items = $record->field($itemfield);
527 is
( scalar @items, $number_of_items, 'Should return all items for opac' );
529 my $opachiddenitems = "
530 homebranch: ['$library1->{branchcode}']";
531 t
::lib
::Mocks
::mock_preference
( 'OpacHiddenItems', $opachiddenitems );
533 C4
::Biblio
::EmbedItemsInMarcBiblio
( $record, $biblionumber );
534 @items = $record->field($itemfield);
537 'Even with OpacHiddenItems set, all items should have been embeded' );
539 C4
::Biblio
::EmbedItemsInMarcBiblio
( $record, $biblionumber, undef, 1 );
540 @items = $record->field($itemfield);
543 $number_of_items - $number_of_items_with_homebranch_is_CPL,
544 'For OPAC, the pref OpacHiddenItems should have been take into account. Only items with homebranch ne CPL should have been embeded'
548 homebranch: ['$library1->{branchcode}', '$library2->{branchcode}']";
549 t
::lib
::Mocks
::mock_preference
( 'OpacHiddenItems', $opachiddenitems );
550 C4
::Biblio
::EmbedItemsInMarcBiblio
( $record, $biblionumber, undef, 1 );
551 @items = $record->field($itemfield);
555 'For OPAC, If all items are hidden, no item should have been embeded'
558 $schema->storage->txn_rollback;
561 # Helper method to set up a Biblio.
563 my $bib = MARC
::Record
->new();
565 MARC
::Field
->new('100', ' ', ' ', a
=> 'Moffat, Steven'),
566 MARC
::Field
->new('245', ' ', ' ', a
=> 'Silence in the library'),
568 my ($bibnum, $bibitemnum) = AddBiblio
($bib, '');
569 return ($bibnum, $bibitemnum);