3 # This file is part of Koha.
5 # Koha is free software; you can redistribute it and/or modify it
6 # under the terms of the GNU General Public License as published by
7 # the Free Software Foundation; either version 3 of the License, or
8 # (at your option) any later version.
10 # Koha is distributed in the hope that it will be useful, but
11 # WITHOUT ANY WARRANTY; without even the implied warranty of
12 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
13 # GNU General Public License for more details.
15 # You should have received a copy of the GNU General Public License
16 # along with Koha; if not, see <http://www.gnu.org/licenses>.
20 use Test::More tests => 29;
24 use C4::Biblio qw( AddBiblio ModBiblio ModBiblioMarc );
25 use C4::Circulation qw( AddIssue AddReturn );
28 use Koha::Cache::Memory::Lite;
30 use Koha::Acquisition::Orders;
31 use Koha::AuthorisedValueCategories;
32 use Koha::AuthorisedValues;
33 use Koha::MarcSubfieldStructures;
39 use t::lib::TestBuilder;
44 use_ok('Koha::Biblio');
45 use_ok('Koha::Biblios');
48 my $schema = Koha::Database->new->schema;
49 my $builder = t::lib::TestBuilder->new;
51 subtest 'metadata() tests' => sub {
55 $schema->storage->txn_begin;
57 my $title = 'Oranges and Peaches';
59 my $record = MARC::Record->new();
60 my $field = MARC::Field->new('245','','','a' => $title);
61 $record->append_fields( $field );
62 my ($biblionumber) = C4::Biblio::AddBiblio($record, '');
64 my $biblio = Koha::Biblios->find( $biblionumber );
65 is( ref $biblio, 'Koha::Biblio', 'Found a Koha::Biblio object' );
67 my $metadata = $biblio->metadata;
68 is( ref $metadata, 'Koha::Biblio::Metadata', 'Method metadata() returned a Koha::Biblio::Metadata object' );
70 my $record2 = $metadata->record;
71 is( ref $record2, 'MARC::Record', 'Method record() returned a MARC::Record object' );
73 is( $record2->field('245')->subfield("a"), $title, 'Title in 245$a matches title from original record object' );
75 $schema->storage->txn_rollback;
78 subtest 'hidden_in_opac() tests' => sub {
82 $schema->storage->txn_begin;
84 my $biblio = $builder->build_sample_biblio();
85 my $rules = { withdrawn => [ 2 ] };
87 t::lib::Mocks::mock_preference( 'OpacHiddenItemsHidesRecord', 0 );
90 !$biblio->hidden_in_opac({ rules => $rules }),
91 'Biblio not hidden if there is no item attached (!OpacHiddenItemsHidesRecord)'
94 t::lib::Mocks::mock_preference( 'OpacHiddenItemsHidesRecord', 1 );
97 !$biblio->hidden_in_opac({ rules => $rules }),
98 'Biblio not hidden if there is no item attached (OpacHiddenItemsHidesRecord)'
101 my $item_1 = $builder->build_sample_item({ biblionumber => $biblio->biblionumber });
102 my $item_2 = $builder->build_sample_item({ biblionumber => $biblio->biblionumber });
104 $item_1->withdrawn( 1 )->store->discard_changes;
105 $item_2->withdrawn( 1 )->store->discard_changes;
107 ok( !$biblio->hidden_in_opac({ rules => $rules }), 'Biblio not hidden' );
109 $item_2->withdrawn( 2 )->store->discard_changes;
110 $biblio->discard_changes; # refresh
112 ok( !$biblio->hidden_in_opac({ rules => $rules }), 'Biblio not hidden' );
114 $item_1->withdrawn( 2 )->store->discard_changes;
115 $biblio->discard_changes; # refresh
117 ok( $biblio->hidden_in_opac({ rules => $rules }), 'Biblio hidden' );
119 t::lib::Mocks::mock_preference( 'OpacHiddenItemsHidesRecord', 0 );
121 !$biblio->hidden_in_opac( { rules => $rules } ),
122 'Biblio hidden (!OpacHiddenItemsHidesRecord)'
126 $schema->storage->txn_rollback;
129 subtest 'items() tests' => sub {
133 $schema->storage->txn_begin;
135 my $biblio = $builder->build_sample_biblio();
137 is( $biblio->items->count, 0, 'No items, count is 0' );
139 my $item_1 = $builder->build_sample_item({ biblionumber => $biblio->biblionumber });
140 my $item_2 = $builder->build_sample_item({ biblionumber => $biblio->biblionumber });
142 my $items = $biblio->items;
143 is( ref($items), 'Koha::Items', 'Returns a Koha::Items resultset' );
144 is( $items->count, 2, 'Two items in resultset' );
146 $schema->storage->txn_rollback;
150 subtest 'get_coins and get_openurl' => sub {
154 $schema->storage->txn_begin;
156 my $builder = t::lib::TestBuilder->new;
157 my $biblio = $builder->build_sample_biblio({
163 'ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=book&rft.btitle=Title%201&rft.au=Author%201',
164 'GetCOinsBiblio returned right metadata'
167 my $record = MARC::Record->new();
168 $record->append_fields( MARC::Field->new('100','','','a' => 'Author 2'), MARC::Field->new('880','','','a' => 'Something') );
169 my ( $biblionumber ) = C4::Biblio::AddBiblio($record, '');
170 my $biblio_no_title = Koha::Biblios->find($biblionumber);
172 $biblio_no_title->get_coins,
173 'ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=book&rft.au=Author%202',
174 'GetCOinsBiblio returned right metadata if biblio does not have a title'
177 t::lib::Mocks::mock_preference("OpenURLResolverURL", "https://koha.example.com/");
179 $biblio->get_openurl,
180 'https://koha.example.com/?ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=book&rft.btitle=Title%201&rft.au=Author%201',
181 'Koha::Biblio->get_openurl returned right URL'
184 t::lib::Mocks::mock_preference("OpenURLResolverURL", "https://koha.example.com/?client_id=ci1");
186 $biblio->get_openurl,
187 'https://koha.example.com/?client_id=ci1&ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=book&rft.btitle=Title%201&rft.au=Author%201',
188 'Koha::Biblio->get_openurl returned right URL'
191 $schema->storage->txn_rollback;
194 subtest 'is_serial() tests' => sub {
198 $schema->storage->txn_begin;
200 my $biblio = $builder->build_sample_biblio();
202 $biblio->serial( 1 )->store->discard_changes;
203 ok( $biblio->is_serial, 'Bibliographic record is serial' );
205 $biblio->serial( 0 )->store->discard_changes;
206 ok( !$biblio->is_serial, 'Bibliographic record is not serial' );
208 my $record = $biblio->metadata->record;
209 $record->leader('00142nas a22 7a 4500');
210 ModBiblio($record, $biblio->biblionumber );
211 $biblio = Koha::Biblios->find($biblio->biblionumber);
213 ok( $biblio->is_serial, 'Bibliographic record is serial' );
215 $schema->storage->txn_rollback;
218 subtest 'pickup_locations() tests' => sub {
222 $schema->storage->txn_begin;
224 Koha::CirculationRules->search->delete;
225 Koha::CirculationRules->set_rules(
227 categorycode => undef,
231 reservesallowed => 25,
236 my $root1 = $builder->build_object( { class => 'Koha::Library::Groups', value => { ft_local_hold_group => 1 } } );
237 my $root2 = $builder->build_object( { class => 'Koha::Library::Groups', value => { ft_local_hold_group => 1 } } );
238 my $root3 = $builder->build_object( { class => 'Koha::Library::Groups', value => { ft_local_hold_group => 1 } } );
240 my $library1 = $builder->build_object( { class => 'Koha::Libraries', value => { pickup_location => 1, branchname => 'zzz' } } );
241 my $library2 = $builder->build_object( { class => 'Koha::Libraries', value => { pickup_location => 1, branchname => 'AAA' } } );
242 my $library3 = $builder->build_object( { class => 'Koha::Libraries', value => { pickup_location => 0, branchname => 'FFF' } } );
243 my $library4 = $builder->build_object( { class => 'Koha::Libraries', value => { pickup_location => 1, branchname => 'CCC' } } );
244 my $library5 = $builder->build_object( { class => 'Koha::Libraries', value => { pickup_location => 1, branchname => 'eee' } } );
245 my $library6 = $builder->build_object( { class => 'Koha::Libraries', value => { pickup_location => 1, branchname => 'BBB' } } );
246 my $library7 = $builder->build_object( { class => 'Koha::Libraries', value => { pickup_location => 1, branchname => 'DDD' } } );
247 my $library8 = $builder->build_object( { class => 'Koha::Libraries', value => { pickup_location => 0, branchname => 'GGG' } } );
249 our @branchcodes = map { $_->branchcode } ($library1, $library2, $library3, $library4, $library5, $library6, $library7, $library8);
251 Koha::CirculationRules->set_rules(
253 branchcode => $library1->branchcode,
256 holdallowed => 'from_home_library',
257 hold_fulfillment_policy => 'any',
258 returnbranch => 'any'
263 Koha::CirculationRules->set_rules(
265 branchcode => $library2->branchcode,
268 holdallowed => 'from_local_hold_group',
269 hold_fulfillment_policy => 'holdgroup',
270 returnbranch => 'any'
275 Koha::CirculationRules->set_rules(
277 branchcode => $library3->branchcode,
280 holdallowed => 'from_local_hold_group',
281 hold_fulfillment_policy => 'patrongroup',
282 returnbranch => 'any'
287 Koha::CirculationRules->set_rules(
289 branchcode => $library4->branchcode,
292 holdallowed => 'from_any_library',
293 hold_fulfillment_policy => 'holdingbranch',
294 returnbranch => 'any'
299 Koha::CirculationRules->set_rules(
301 branchcode => $library5->branchcode,
304 holdallowed => 'from_any_library',
305 hold_fulfillment_policy => 'homebranch',
306 returnbranch => 'any'
311 Koha::CirculationRules->set_rules(
313 branchcode => $library6->branchcode,
316 holdallowed => 'from_home_library',
317 hold_fulfillment_policy => 'holdgroup',
318 returnbranch => 'any'
323 Koha::CirculationRules->set_rules(
325 branchcode => $library7->branchcode,
328 holdallowed => 'from_local_hold_group',
329 hold_fulfillment_policy => 'holdingbranch',
330 returnbranch => 'any'
336 Koha::CirculationRules->set_rules(
338 branchcode => $library8->branchcode,
341 holdallowed => 'from_any_library',
342 hold_fulfillment_policy => 'patrongroup',
343 returnbranch => 'any'
348 my $group1_1 = $builder->build_object( { class => 'Koha::Library::Groups', value => { parent_id => $root1->id, branchcode => $library1->branchcode } } );
349 my $group1_2 = $builder->build_object( { class => 'Koha::Library::Groups', value => { parent_id => $root1->id, branchcode => $library2->branchcode } } );
351 my $group2_3 = $builder->build_object( { class => 'Koha::Library::Groups', value => { parent_id => $root2->id, branchcode => $library3->branchcode } } );
352 my $group2_4 = $builder->build_object( { class => 'Koha::Library::Groups', value => { parent_id => $root2->id, branchcode => $library4->branchcode } } );
354 my $group3_5 = $builder->build_object( { class => 'Koha::Library::Groups', value => { parent_id => $root3->id, branchcode => $library5->branchcode } } );
355 my $group3_6 = $builder->build_object( { class => 'Koha::Library::Groups', value => { parent_id => $root3->id, branchcode => $library6->branchcode } } );
356 my $group3_7 = $builder->build_object( { class => 'Koha::Library::Groups', value => { parent_id => $root3->id, branchcode => $library7->branchcode } } );
357 my $group3_8 = $builder->build_object( { class => 'Koha::Library::Groups', value => { parent_id => $root3->id, branchcode => $library8->branchcode } } );
359 my $biblio1 = $builder->build_sample_biblio({ title => '1' });
360 my $biblio2 = $builder->build_sample_biblio({ title => '2' });
363 { $biblio1->pickup_locations }
364 'Koha::Exceptions::MissingParameter',
365 'Exception thrown on missing parameter';
367 is( $@->parameter, 'patron', 'Exception param correctly set' );
369 my $item1_1 = $builder->build_sample_item({
370 biblionumber => $biblio1->biblionumber,
371 homebranch => $library1->branchcode,
372 holdingbranch => $library2->branchcode,
375 my $item1_3 = $builder->build_sample_item({
376 biblionumber => $biblio1->biblionumber,
377 homebranch => $library3->branchcode,
378 holdingbranch => $library4->branchcode,
381 my $item1_7 = $builder->build_sample_item({
382 biblionumber => $biblio1->biblionumber,
383 homebranch => $library7->branchcode,
384 holdingbranch => $library4->branchcode,
387 my $item2_2 = $builder->build_sample_item({
388 biblionumber => $biblio2->biblionumber,
389 homebranch => $library2->branchcode,
390 holdingbranch => $library1->branchcode,
393 my $item2_4 = $builder->build_sample_item({
394 biblionumber => $biblio2->biblionumber,
395 homebranch => $library4->branchcode,
396 holdingbranch => $library3->branchcode,
399 my $item2_6 = $builder->build_sample_item({
400 biblionumber => $biblio2->biblionumber,
401 homebranch => $library6->branchcode,
402 holdingbranch => $library4->branchcode,
405 my $patron1 = $builder->build_object( { class => 'Koha::Patrons', value => { firstname=>'1', branchcode => $library1->branchcode } } );
406 my $patron8 = $builder->build_object( { class => 'Koha::Patrons', value => { firstname=>'8', branchcode => $library8->branchcode } } );
409 "ItemHomeLibrary-1-1" => 6,
410 "ItemHomeLibrary-1-8" => 1,
411 "ItemHomeLibrary-2-1" => 2,
412 "ItemHomeLibrary-2-8" => 0,
413 "PatronLibrary-1-1" => 6,
414 "PatronLibrary-1-8" => 3,
415 "PatronLibrary-2-1" => 0,
416 "PatronLibrary-2-8" => 3,
420 my ( $cbranch, $biblio, $patron, $results ) = @_;
421 t::lib::Mocks::mock_preference('ReservesControlBranch', $cbranch);
424 my $pickup_location = $_;
425 grep { $pickup_location->branchcode eq $_ } @branchcodes
426 } $biblio->pickup_locations( { patron => $patron } )->as_list;
429 scalar(@pl) == $results->{ $cbranch . '-'
430 . $biblio->title . '-'
431 . $patron->firstname },
432 'ReservesControlBranch: '
439 . $results->{ $cbranch . '-'
440 . $biblio->title . '-'
441 . $patron->firstname }
447 foreach my $cbranch ('ItemHomeLibrary','PatronLibrary') {
448 my $cache = Koha::Cache::Memory::Lite->get_instance();
449 $cache->flush(); # needed since we change ReservesControlBranch
450 foreach my $biblio ($biblio1, $biblio2) {
451 foreach my $patron ($patron1, $patron8) {
452 _doTest($cbranch, $biblio, $patron, $results);
457 my @pl_names = map { $_->branchname } $biblio1->pickup_locations( { patron => $patron1 } )->as_list;
458 my $pl_ori_str = join('|', @pl_names);
459 my $pl_sorted_str = join('|', sort { lc($a) cmp lc($b) } @pl_names);
461 $pl_ori_str eq $pl_sorted_str,
462 'Libraries must be sorted by name'
464 $schema->storage->txn_rollback;
467 subtest 'to_api() tests' => sub {
469 $schema->storage->txn_begin;
471 my $biblio = $builder->build_sample_biblio();
472 my $item = $builder->build_sample_item({ biblionumber => $biblio->biblionumber });
474 my $biblioitem_api = $biblio->biblioitem->to_api;
475 my $biblio_api = $biblio->to_api;
477 plan tests => (scalar keys %{ $biblioitem_api }) + 1;
479 foreach my $key ( keys %{ $biblioitem_api } ) {
480 is( $biblio_api->{$key}, $biblioitem_api->{$key}, "$key is added to the biblio object" );
483 $biblio_api = $biblio->to_api({ embed => { items => {} } });
484 is_deeply( $biblio_api->{items}, [ $item->to_api ], 'Item correctly embedded' );
486 $schema->storage->txn_rollback;
489 subtest 'suggestions() tests' => sub {
493 $schema->storage->txn_begin;
495 my $biblio = $builder->build_sample_biblio();
497 is( ref($biblio->suggestions), 'Koha::Suggestions', 'Return type is correct' );
500 $biblio->suggestions->unblessed,
502 '->suggestions returns an empty Koha::Suggestions resultset'
505 my $suggestion = $builder->build_object(
507 class => 'Koha::Suggestions',
508 value => { biblionumber => $biblio->biblionumber }
512 my $suggestions = $biblio->suggestions->unblessed;
515 $biblio->suggestions->unblessed,
516 [ $suggestion->unblessed ],
517 '->suggestions returns the related Koha::Suggestion objects'
520 $schema->storage->txn_rollback;
523 subtest 'get_marc_components() tests' => sub {
527 $schema->storage->txn_begin;
529 my ($host_bibnum) = C4::Biblio::AddBiblio(host_record(), '');
530 my $host_biblio = Koha::Biblios->find($host_bibnum);
531 t::lib::Mocks::mock_preference( 'SearchEngine', 'Zebra' );
532 my $search_mod = Test::MockModule->new( 'Koha::SearchEngine::Zebra::Search' );
533 $search_mod->mock( 'search_compat', \&search_component_record2 );
535 my $components = $host_biblio->get_marc_components;
536 is( ref($components), 'ARRAY', 'Return type is correct' );
541 '->get_marc_components returns an empty ARRAY'
544 $search_mod->unmock( 'search_compat');
545 $search_mod->mock( 'search_compat', \&search_component_record1 );
546 my $component_record = component_record1()->as_xml();
549 $host_biblio->get_marc_components,
551 '->get_marc_components returns the related component part record'
553 $search_mod->unmock( 'search_compat');
555 $search_mod->mock( 'search_compat',
556 sub { Koha::Exception->throw("error searching analytics") }
558 warning_like { $components = $host_biblio->get_marc_components }
559 qr{Warning from search_compat: .* 'error searching analytics'};
562 $host_biblio->object_messages,
566 message => 'component_search',
567 payload => "Exception 'Koha::Exception' thrown 'error searching analytics'\n"
571 $search_mod->unmock( 'search_compat');
573 $schema->storage->txn_rollback;
576 subtest 'get_components_query' => sub {
579 my $biblio = $builder->build_sample_biblio();
580 my $biblionumber = $biblio->biblionumber;
581 my $record = $biblio->metadata->record;
583 foreach my $engine ('Zebra','Elasticsearch'){
584 t::lib::Mocks::mock_preference( 'SearchEngine', $engine );
586 t::lib::Mocks::mock_preference( 'UseControlNumber', '0' );
587 t::lib::Mocks::mock_preference( 'ComponentSortField', 'author' );
588 t::lib::Mocks::mock_preference( 'ComponentSortOrder', 'za' );
589 my ( $comp_query, $comp_query_str, $comp_sort ) = $biblio->get_components_query;
590 is($comp_query_str, 'Host-item:("Some boring read")', "$engine: UseControlNumber disabled");
591 is($comp_sort, "author_za", "$engine: UseControlNumber disabled sort is correct");
593 t::lib::Mocks::mock_preference( 'UseControlNumber', '1' );
594 t::lib::Mocks::mock_preference( 'ComponentSortOrder', 'az' );
595 my $marc_001_field = MARC::Field->new('001', $biblionumber);
596 $record->append_fields($marc_001_field);
597 C4::Biblio::ModBiblio( $record, $biblio->biblionumber );
598 $biblio = Koha::Biblios->find( $biblio->biblionumber);
600 ( $comp_query, $comp_query_str, $comp_sort ) = $biblio->get_components_query;
601 is($comp_query_str, "(rcn:\"$biblionumber\" AND (bib-level:a OR bib-level:b))", "$engine: UseControlNumber enabled without MarcOrgCode");
602 is($comp_sort, "author_az", "$engine: UseControlNumber enabled without MarcOrgCode sort is correct");
604 my $marc_003_field = MARC::Field->new('003', 'OSt');
605 $record->append_fields($marc_003_field);
606 C4::Biblio::ModBiblio( $record, $biblio->biblionumber );
607 $biblio = Koha::Biblios->find( $biblio->biblionumber);
609 t::lib::Mocks::mock_preference( 'ComponentSortField', 'title' );
610 t::lib::Mocks::mock_preference( 'ComponentSortOrder', 'asc' );
611 ( $comp_query, $comp_query_str, $comp_sort ) = $biblio->get_components_query;
612 is($comp_query_str, "(((rcn:\"$biblionumber\" AND cni:\"OSt\") OR rcn:\"OSt $biblionumber\") AND (bib-level:a OR bib-level:b))", "$engine: UseControlNumber enabled with MarcOrgCode");
613 is($comp_sort, "title_asc", "$engine: UseControlNumber enabled with MarcOrgCode sort if correct");
614 $record->delete_field($marc_003_field);
618 subtest 'orders() and active_orders() tests' => sub {
622 $schema->storage->txn_begin;
624 my $biblio = $builder->build_sample_biblio();
626 my $orders = $biblio->orders;
627 my $active_orders = $biblio->active_orders;
629 is( ref($orders), 'Koha::Acquisition::Orders', 'Result type is correct' );
630 is( $biblio->orders->count, $biblio->active_orders->count, '->orders->count returns the count for the resultset' );
632 # Add a couple orders
634 $builder->build_object(
636 class => 'Koha::Acquisition::Orders',
638 biblionumber => $biblio->biblionumber,
639 datecancellationprinted => '2019-12-31'
645 $builder->build_object(
647 class => 'Koha::Acquisition::Orders',
649 biblionumber => $biblio->biblionumber,
650 datecancellationprinted => undef
655 $orders = $biblio->orders;
656 $active_orders = $biblio->active_orders;
658 is( ref($orders), 'Koha::Acquisition::Orders', 'Result type is correct' );
659 is( ref($active_orders), 'Koha::Acquisition::Orders', 'Result type is correct' );
660 is( $orders->count, $active_orders->count + 2, '->active_orders->count returns the rigt count' );
662 $schema->storage->txn_rollback;
665 subtest 'tickets() tests' => sub {
669 $schema->storage->txn_begin;
671 my $biblio = $builder->build_sample_biblio();
672 my $tickets = $biblio->tickets;
673 is( ref($tickets), 'Koha::Tickets', 'Koha::Biblio->tickets should return a Koha::Tickets object' );
674 is( $tickets->count, 0, 'Koha::Biblio->tickets should return a count of 0 when there are no related tickets' );
678 $builder->build_object(
680 class => 'Koha::Tickets',
681 value => { biblio_id => $biblio->biblionumber }
686 $tickets = $biblio->tickets;
687 is( ref($tickets), 'Koha::Tickets', 'Koha::Biblio->tickets should return a Koha::Tickets object' );
688 is( $tickets->count, 2, 'Koha::Biblio->tickets should return the correct number of tickets' );
690 $schema->storage->txn_rollback;
693 subtest 'subscriptions() tests' => sub {
697 $schema->storage->txn_begin;
699 my $biblio = $builder->build_sample_biblio;
701 my $subscriptions = $biblio->subscriptions;
702 is( ref($subscriptions), 'Koha::Subscriptions',
703 'Koha::Biblio->subscriptions should return a Koha::Subscriptions object'
705 is( $subscriptions->count, 0, 'Koha::Biblio->subscriptions should return the correct number of subscriptions');
707 # Add two subscriptions
709 $builder->build_object(
711 class => 'Koha::Subscriptions',
712 value => { biblionumber => $biblio->biblionumber }
717 $subscriptions = $biblio->subscriptions;
718 is( ref($subscriptions), 'Koha::Subscriptions',
719 'Koha::Biblio->subscriptions should return a Koha::Subscriptions object'
721 is( $subscriptions->count, 2, 'Koha::Biblio->subscriptions should return the correct number of subscriptions');
723 $schema->storage->txn_rollback;
726 subtest 'get_marc_notes() MARC21 tests' => sub {
729 $schema->storage->txn_begin;
731 t::lib::Mocks::mock_preference( 'NotesToHide', '520' );
733 my $av = $builder->build_object( { class => 'Koha::AuthorisedValues' } );
735 my $biblio = $builder->build_sample_biblio;
736 my $record = $biblio->metadata->record;
737 $record->append_fields(
738 MARC::Field->new( '500', '', '', a => 'Note1' ),
739 MARC::Field->new( '505', '', '', a => 'Note2', u => 'http://someserver.com' ),
740 MARC::Field->new( '520', '', '', a => 'Note3 skipped' ),
741 MARC::Field->new( '541', '0', '', a => 'Note4 skipped on opac' ),
742 MARC::Field->new( '544', '', '', a => 'Note5' ),
743 MARC::Field->new( '590', '', '', a => $av->authorised_value ),
744 MARC::Field->new( '545', '', '', a => 'Invisible on OPAC' ),
747 my $mss = Koha::MarcSubfieldStructures->find({tagfield => "590", tagsubfield => "a", frameworkcode => $biblio->frameworkcode });
748 $mss->update({ authorised_value => $av->category });
750 $mss = Koha::MarcSubfieldStructures->find({tagfield => "545", tagsubfield => "a", frameworkcode => $biblio->frameworkcode });
751 $mss->update({ hidden => 1 });
753 my $cache = Koha::Caches->get_instance;
754 $cache->clear_from_cache("MarcStructure-0-");
755 $cache->clear_from_cache("MarcStructure-1-");
756 $cache->clear_from_cache("MarcSubfieldStructure-");
757 $cache->clear_from_cache("MarcCodedFields-");
759 C4::Biblio::ModBiblio( $record, $biblio->biblionumber );
760 $biblio = Koha::Biblios->find( $biblio->biblionumber);
762 my $notes = $biblio->get_marc_notes;
763 is( $notes->[0]->{marcnote}, 'Note1', 'First note' );
764 is( $notes->[1]->{marcnote}, 'Note2', 'Second note' );
765 is( $notes->[2]->{marcnote}, 'http://someserver.com', 'URL separated' );
766 is( $notes->[3]->{marcnote}, 'Note4 skipped on opac',"Note shows if not opac (Hidden by Indicator)" );
767 is( $notes->[4]->{marcnote}, 'Note5', 'Fifth note' );
768 is( $notes->[5]->{marcnote}, $av->lib, 'Authorised value is correctly parsed to show description rather than code' );
769 is( $notes->[6]->{marcnote}, 'Invisible on OPAC', 'Note shows if not opac (Hidden by framework)' );
770 is( @$notes, 7, 'No more notes' );
771 $notes = $biblio->get_marc_notes({ opac => 1 });
772 is( $notes->[0]->{marcnote}, 'Note1', 'First note' );
773 is( $notes->[1]->{marcnote}, 'Note2', 'Second note' );
774 is( $notes->[2]->{marcnote}, 'http://someserver.com', 'URL separated' );
775 is( $notes->[3]->{marcnote}, 'Note5', 'Fifth note shows after fourth skipped' );
776 is( $notes->[4]->{marcnote}, $av->lib_opac, 'Authorised value is correctly parsed for OPAC to show description rather than code' );
777 is( @$notes, 5, 'No more notes' );
779 $cache->clear_from_cache("MarcStructure-0-");
780 $cache->clear_from_cache("MarcStructure-1-");
781 $cache->clear_from_cache("MarcSubfieldStructure-");
782 $cache->clear_from_cache("MarcCodedFields-");
784 $schema->storage->txn_rollback;
787 subtest 'get_marc_notes() UNIMARC tests' => sub {
790 $schema->storage->txn_begin;
792 t::lib::Mocks::mock_preference( 'NotesToHide', '310' );
793 t::lib::Mocks::mock_preference( 'marcflavour', 'UNIMARC' );
795 my $biblio = $builder->build_sample_biblio;
796 my $record = $biblio->metadata->record;
797 $record->append_fields(
798 MARC::Field->new( '300', '', '', a => 'Note1' ),
799 MARC::Field->new( '300', '', '', a => 'Note2' ),
800 MARC::Field->new( '310', '', '', a => 'Note3 skipped' ),
802 C4::Biblio::ModBiblio( $record, $biblio->biblionumber );
803 $biblio = Koha::Biblios->find( $biblio->biblionumber);
804 my $notes = $biblio->get_marc_notes({ marcflavour => 'UNIMARC' });
805 is( $notes->[0]->{marcnote}, 'Note1', 'First note' );
806 is( $notes->[1]->{marcnote}, 'Note2', 'Second note' );
807 is( @$notes, 2, 'No more notes' );
809 t::lib::Mocks::mock_preference( 'marcflavour', 'MARC21' );
810 $schema->storage->txn_rollback;
813 subtest 'host_items() tests' => sub {
816 $schema->storage->txn_begin;
818 my $biblio = $builder->build_sample_biblio( { frameworkcode => '' } );
820 t::lib::Mocks::mock_preference( 'EasyAnalyticalRecords', 1 );
821 my $host_items = $biblio->host_items;
822 is( ref($host_items), 'Koha::Items' );
823 is( $host_items->count, 0 );
826 $builder->build_sample_item( { biblionumber => $biblio->biblionumber } );
827 my $host_item_1 = $builder->build_sample_item;
828 my $host_item_2 = $builder->build_sample_item;
830 my $record = $biblio->metadata->record;
831 $record->append_fields(
834 9 => $host_item_1->itemnumber,
835 9 => $host_item_2->itemnumber
838 C4::Biblio::ModBiblio( $record, $biblio->biblionumber );
839 $biblio = $biblio->get_from_storage;
840 $host_items = $biblio->host_items;
841 is( $host_items->count, 2 );
842 is_deeply( [ $host_items->get_column('itemnumber') ],
843 [ $host_item_1->itemnumber, $host_item_2->itemnumber ] );
845 t::lib::Mocks::mock_preference( 'EasyAnalyticalRecords', 0 );
846 $host_items = $biblio->host_items;
847 is( ref($host_items), 'Koha::Items' );
848 is( $host_items->count, 0 );
850 subtest 'test host_items param in items()' => sub {
853 my $items = $biblio->items;
854 is( $items->count, 1, "Without host_items param we only get the items on the biblio");
855 $items = $biblio->items({ host_items => 1 });
856 is( $items->count, 3, "With param host_items we get the biblio items plus analytics");
857 is( ref($items), 'Koha::Items', "We correctly get an Items object");
858 is_deeply( [ $items->get_column('itemnumber') ],
859 [ $item_1->itemnumber, $host_item_1->itemnumber, $host_item_2->itemnumber ] );
862 $schema->storage->txn_rollback;
865 subtest 'article_requests() tests' => sub {
869 $schema->storage->txn_begin;
871 my $item = $builder->build_sample_item;
872 my $biblio = $item->biblio;
874 my $article_requests = $biblio->article_requests;
875 is( ref($article_requests), 'Koha::ArticleRequests',
876 'In scalar context, type is correct' );
877 is( $article_requests->count, 0, 'No article requests' );
879 foreach my $i ( 0 .. 3 ) {
881 my $patron = $builder->build_object( { class => 'Koha::Patrons' } );
883 Koha::ArticleRequest->new(
885 borrowernumber => $patron->id,
886 biblionumber => $biblio->id,
887 itemnumber => $item->id,
888 title => $biblio->title,
893 $article_requests = $biblio->article_requests;
894 is( $article_requests->count, 4, '4 article requests' );
896 $schema->storage->txn_rollback;
899 subtest 'current_checkouts() and old_checkouts() tests' => sub {
903 $schema->storage->txn_begin;
905 my $library = $builder->build_object({ class => 'Koha::Libraries' });
907 my $patron_1 = $builder->build_object({ class => 'Koha::Patrons' });
908 my $patron_2 = $builder->build_object({ class => 'Koha::Patrons' });
910 my $item_1 = $builder->build_sample_item;
911 my $item_2 = $builder->build_sample_item({ biblionumber => $item_1->biblionumber });
913 t::lib::Mocks::mock_userenv({ branchcode => $library->id });
915 AddIssue( $patron_1, $item_1->barcode );
916 AddIssue( $patron_1, $item_2->barcode );
918 AddReturn( $item_1->barcode );
919 AddIssue( $patron_2, $item_1->barcode );
921 my $biblio = $item_1->biblio;
922 my $current_checkouts = $biblio->current_checkouts;
923 my $old_checkouts = $biblio->old_checkouts;
925 is( ref($current_checkouts), 'Koha::Checkouts', 'Type is correct' );
926 is( ref($old_checkouts), 'Koha::Old::Checkouts', 'Type is correct' );
928 is( $current_checkouts->count, 2, 'Count is correct for current checkouts' );
929 is( $old_checkouts->count, 1, 'Count is correct for old checkouts' );
931 $schema->storage->txn_rollback;
934 subtest 'get_marc_contributors() tests' => sub {
938 $schema->storage->txn_begin;
940 my $biblio = $builder->build_sample_biblio({ author => 'Main author' });
941 my $record = $biblio->metadata->record;
943 # add author information
944 my $field = MARC::Field->new('700','1','','a' => 'Jefferson, Thomas');
945 $record->append_fields($field);
946 $field = MARC::Field->new('701','1','','d' => 'Secondary author 2');
947 $record->append_fields($field);
950 C4::Biblio::ModBiblio( $record, $biblio->biblionumber );
951 $biblio = Koha::Biblios->find( $biblio->biblionumber );
953 is( @{$biblio->get_marc_authors}, 3, 'get_marc_authors retrieves correct number of author subfields' );
954 is( @{$biblio->get_marc_contributors}, 2, 'get_marc_contributors retrieves correct number of author subfields' );
955 $schema->storage->txn_rollback;
958 subtest 'Recalls tests' => sub {
962 $schema->storage->txn_begin;
964 my $item1 = $builder->build_sample_item;
965 my $biblio = $item1->biblio;
966 my $branchcode = $item1->holdingbranch;
967 my $patron1 = $builder->build_object({ class => 'Koha::Patrons', value => { branchcode => $branchcode } });
968 my $patron2 = $builder->build_object({ class => 'Koha::Patrons', value => { branchcode => $branchcode } });
969 my $patron3 = $builder->build_object({ class => 'Koha::Patrons', value => { branchcode => $branchcode } });
970 my $item2 = $builder->build_object({ class => 'Koha::Items', value => { holdingbranch => $branchcode, homebranch => $branchcode, biblionumber => $biblio->biblionumber, itype => $item1->effective_itemtype } });
971 t::lib::Mocks::mock_userenv({ patron => $patron1 });
973 my $recall1 = Koha::Recall->new(
974 { patron_id => $patron1->borrowernumber,
975 created_date => \'NOW()',
976 biblio_id => $biblio->biblionumber,
977 pickup_library_id => $branchcode,
978 item_id => $item1->itemnumber,
979 expiration_date => undef,
983 my $recall2 = Koha::Recall->new(
984 { patron_id => $patron2->borrowernumber,
985 created_date => \'NOW()',
986 biblio_id => $biblio->biblionumber,
987 pickup_library_id => $branchcode,
989 expiration_date => undef,
993 my $recall3 = Koha::Recall->new(
994 { patron_id => $patron3->borrowernumber,
995 created_date => \'NOW()',
996 biblio_id => $biblio->biblionumber,
997 pickup_library_id => $branchcode,
998 item_id => $item1->itemnumber,
999 expiration_date => undef,
1004 my $recalls = $biblio->recalls;
1005 is( $recalls->count, 3, 'Correctly get number of recalls for biblio' );
1007 $recall1->set_cancelled;
1008 $recall2->set_expired({ interface => 'COMMANDLINE' });
1010 is( $recalls->count, 3, 'Correctly get number of recalls for biblio' );
1011 is( $recalls->filter_by_current->count, 1, 'Correctly get number of active recalls for biblio' );
1013 t::lib::Mocks::mock_preference('UseRecalls', 0);
1014 is( $biblio->can_be_recalled({ patron => $patron1 }), 0, "Can't recall with UseRecalls disabled" );
1016 t::lib::Mocks::mock_preference("UseRecalls", 1);
1017 $item1->update({ notforloan => 1 });
1018 is( $biblio->can_be_recalled({ patron => $patron1 }), 0, "Can't recall with no available items" );
1020 $item1->update({ notforloan => 0 });
1021 Koha::CirculationRules->set_rules({
1022 branchcode => $branchcode,
1023 categorycode => $patron1->categorycode,
1024 itemtype => $item1->effective_itemtype,
1026 recalls_allowed => 0,
1027 recalls_per_record => 1,
1028 on_shelf_recalls => 'all',
1031 is( $biblio->can_be_recalled({ patron => $patron1 }), 0, "Can't recall if recalls_allowed = 0" );
1033 Koha::CirculationRules->set_rules({
1034 branchcode => $branchcode,
1035 categorycode => $patron1->categorycode,
1036 itemtype => $item1->effective_itemtype,
1038 recalls_allowed => 1,
1039 recalls_per_record => 1,
1040 on_shelf_recalls => 'all',
1043 is( $biblio->can_be_recalled({ patron => $patron1 }), 0, "Can't recall if patron has more existing recall(s) than recalls_allowed" );
1044 is( $biblio->can_be_recalled({ patron => $patron1 }), 0, "Can't recall if patron has more existing recall(s) than recalls_per_record" );
1046 $recall1->set_cancelled;
1047 C4::Circulation::AddIssue( $patron1, $item2->barcode );
1048 is( $biblio->can_be_recalled({ patron => $patron1 }), 0, "Can't recall if patron has already checked out an item attached to this biblio" );
1050 is( $biblio->can_be_recalled({ patron => $patron1 }), 0, "Can't recall if on_shelf_recalls = all and items are still available" );
1052 Koha::CirculationRules->set_rules({
1053 branchcode => $branchcode,
1054 categorycode => $patron1->categorycode,
1055 itemtype => $item1->effective_itemtype,
1057 recalls_allowed => 1,
1058 recalls_per_record => 1,
1059 on_shelf_recalls => 'any',
1062 C4::Circulation::AddReturn( $item2->barcode, $branchcode );
1063 is( $biblio->can_be_recalled({ patron => $patron1 }), 0, "Can't recall if no items are checked out" );
1065 $recall2->set_cancelled;
1066 C4::Circulation::AddIssue( $patron2, $item2->barcode );
1067 C4::Circulation::AddIssue( $patron2, $item1->barcode );
1068 is( $biblio->can_be_recalled({ patron => $patron1 }), 2, "Can recall two items" );
1070 $item1->update({ withdrawn => 1 });
1071 is( $biblio->can_be_recalled({ patron => $patron1 }), 1, "Can recall one item" );
1073 $schema->storage->txn_rollback;
1076 subtest 'ill_requests() tests' => sub {
1080 $schema->storage->txn_begin;
1082 my $biblio = $builder->build_sample_biblio;
1084 my $rs = $biblio->ill_requests;
1085 is( ref($rs), 'Koha::Illrequests' );
1086 is( $rs->count, 0, 'No linked requests' );
1089 $builder->build_object(
1091 class => 'Koha::Illrequests',
1092 value => { biblio_id => $biblio->id }
1097 is( $biblio->ill_requests->count, 10, 'Linked requests are present' );
1099 $schema->storage->txn_rollback;
1102 subtest 'item_groups() tests' => sub {
1106 $schema->storage->txn_begin;
1108 my $biblio = $builder->build_sample_biblio();
1110 my @item_groups = $biblio->item_groups->as_list;
1111 is( scalar(@item_groups), 0, 'Got zero item groups');
1113 my $item_group_1 = Koha::Biblio::ItemGroup->new( { biblio_id => $biblio->id } )->store();
1115 @item_groups = $biblio->item_groups->as_list;
1116 is( scalar(@item_groups), 1, 'Got one item group');
1117 is( $item_groups[0]->id, $item_group_1->id, 'Got correct item group');
1119 my $item_group_2 = Koha::Biblio::ItemGroup->new( { biblio_id => $biblio->id } )->store();
1121 @item_groups = $biblio->item_groups->as_list;
1122 is( scalar(@item_groups), 2, 'Got two item groups');
1123 is( $item_groups[0]->id, $item_group_1->id, 'Got correct item group 1');
1124 is( $item_groups[1]->id, $item_group_2->id, 'Got correct item group 2');
1126 $schema->storage->txn_rollback;
1129 subtest 'normalized_isbn' => sub {
1132 # We will move the tests from GetNormalizedISBN here when it will get replaced
1133 my $biblio = $builder->build_sample_biblio();
1134 $biblio->biblioitem->set( { isbn => '9781250067128 | 125006712X' } )->store;
1136 $biblio->normalized_isbn, C4::Koha::GetNormalizedISBN( $biblio->biblioitem->isbn ),
1137 'normalized_isbn is a wrapper around C4::Koha::GetNormalizedISBN'
1141 subtest 'normalized_upc' => sub {
1144 # We will move the tests from GetNormalizedUPC here when it will get replaced
1145 # Note that only a single test exist and it's not really meaningful...
1146 my $biblio = $builder->build_sample_biblio();
1148 $biblio->normalized_upc, C4::Koha::GetNormalizedUPC( $biblio->metadata->record ),
1149 'normalized_upc is a wrapper around C4::Koha::GetNormalizedUPC'
1153 subtest 'normalized_oclc' => sub {
1156 # We will move the tests from GetNormalizedOCLC here when it will get replaced
1157 # Note that only a single test exist and it's not really meaningful...
1158 my $biblio = $builder->build_sample_biblio();
1160 $biblio->normalized_oclc, C4::Koha::GetNormalizedOCLCNumber( $biblio->metadata->record ),
1161 'normalized_oclc is a wrapper around C4::Koha::GetNormalizedOCLCNumber'
1165 subtest 'ratings' => sub {
1167 # See t/db_dependent/Koha/Ratings.t
1171 subtest 'opac_summary_html' => sub {
1175 my $author = 'my author';
1176 my $title = 'my title';
1177 my $isbn = '9781250067128 | 125006712X';
1178 my $biblio = $builder->build_sample_biblio( { author => $author, title => $title } );
1179 $biblio->biblioitem->set( { isbn => '9781250067128 | 125006712X' } )->store;
1181 t::lib::Mocks::mock_preference( 'OPACMySummaryHTML', '' );
1182 is( $biblio->opac_summary_html, '', 'opac_summary_html returns empty string if pref is off' );
1184 t::lib::Mocks::mock_preference(
1185 'OPACMySummaryHTML',
1186 'Replace {AUTHOR}, {TITLE}, {ISBN} AND {BIBLIONUMBER} please'
1189 $biblio->opac_summary_html,
1190 sprintf( 'Replace %s, %s, %s AND %s please', $author, $title, $biblio->normalized_isbn, $biblio->biblionumber ),
1191 'opac_summary_html replaces the different patterns'
1195 sub component_record1 {
1196 my $marc = MARC::Record->new;
1197 $marc->append_fields(
1198 MARC::Field->new( '001', '3456' ),
1199 MARC::Field->new( '245', '', '', a => 'Some title 1' ),
1200 MARC::Field->new( '773', '', '', w => '(FIRST)1234' ),
1204 sub search_component_record1 {
1205 my @results = ( component_record1()->as_xml() );
1206 return ( undef, { biblioserver => { RECORDS => \@results, hits => 1 } }, 1 );
1209 sub search_component_record2 {
1211 return ( undef, { biblioserver => { RECORDS => \@results, hits => 0 } }, 0 );
1215 my $marc = MARC::Record->new;
1216 $marc->append_fields(
1217 MARC::Field->new( '001', '1234' ),
1218 MARC::Field->new( '003', 'FIRST' ),
1219 MARC::Field->new( '245', '', '', a => 'Some title' ),