t/db_dependent/Koha/Libraries.t

   1 #!/usr/bin/perl
   2
   3 # Copyright 2015 Koha Development team
   4 #
   5 # This file is part of Koha
   6 #
   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.
  11 #
  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.
  16 #
  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>.
  19
  20 use Modern::Perl;
  21
  22 use Test::More tests => 12;
  23
  24 use C4::Biblio;
  25 use C4::Context;
  26 use C4::Items;
  27
  28 use Koha::Biblios;
  29 use Koha::Item::Transfer::Limits;
  30 use Koha::Items;
  31 use Koha::Library;
  32 use Koha::Libraries;
  33 use Koha::Database;
  34 use Koha::CirculationRules;
  35
  36 use t::lib::Mocks;
  37 use t::lib::TestBuilder;
  38
  39 my $schema = Koha::Database->new->schema;
  40 $schema->storage->txn_begin;
  41
  42 # Cleanup default_branch_item_rules
  43 my $dbh     = C4::Context->dbh;
  44 $dbh->do('DELETE FROM circulation_rules');
  45
  46 my $builder = t::lib::TestBuilder->new;
  47 my $nb_of_libraries = Koha::Libraries->search->count;
  48 my $new_library_1 = Koha::Library->new({
  49     branchcode => 'my_bc_1',
  50     branchname => 'my_branchname_1',
  51     branchnotes => 'my_branchnotes_1',
  52     marcorgcode => 'US-MyLib',
  53 })->store;
  54 my $new_library_2 = Koha::Library->new({
  55     branchcode => 'my_bc_2',
  56     branchname => 'my_branchname_2',
  57     branchnotes => 'my_branchnotes_2',
  58 })->store;
  59
  60 is( Koha::Libraries->search->count,         $nb_of_libraries + 2,  'The 2 libraries should have been added' );
  61
  62 my $retrieved_library_1 = Koha::Libraries->find( $new_library_1->branchcode );
  63 is( $retrieved_library_1->branchname, $new_library_1->branchname, 'Find a library by branchcode should return the correct library' );
  64
  65 $retrieved_library_1->delete;
  66 is( Koha::Libraries->search->count, $nb_of_libraries + 1, 'Delete should have deleted the library' );
  67
  68 # Stockrotation relationship testing
  69
  70 my $new_library_sr = $builder->build({ source => 'Branch' });
  71
  72 $builder->build({
  73     source => 'Stockrotationstage',
  74     value  => { branchcode_id => $new_library_sr->{branchcode} },
  75 });
  76 $builder->build({
  77     source => 'Stockrotationstage',
  78     value  => { branchcode_id => $new_library_sr->{branchcode} },
  79 });
  80 $builder->build({
  81     source => 'Stockrotationstage',
  82     value  => { branchcode_id => $new_library_sr->{branchcode} },
  83 });
  84
  85 my $srstages = Koha::Libraries->find($new_library_sr->{branchcode})
  86     ->stockrotationstages;
  87 is( $srstages->count, 3, 'Correctly fetched stockrotationstages associated with this branch');
  88
  89 isa_ok( $srstages->next, 'Koha::StockRotationStage', "Relationship correctly creates Koha::Objects." );
  90
  91 $schema->storage->txn_rollback;
  92
  93 subtest '->get_effective_marcorgcode' => sub {
  94
  95     plan tests => 4;
  96
  97     $schema->storage->txn_begin;
  98
  99     my $library_1 = $builder->build_object({ class => 'Koha::Libraries',
 100                                              value => { marcorgcode => 'US-MyLib' } });
 101     my $library_2 = $builder->build_object({ class => 'Koha::Libraries',
 102                                              value => { marcorgcode => undef } });
 103
 104     t::lib::Mocks::mock_preference('MARCOrgCode', 'US-Default');
 105
 106     is( $library_1->get_effective_marcorgcode, 'US-MyLib',
 107        'If defined, use library\'s own marc org code');
 108     is( $library_2->get_effective_marcorgcode, 'US-Default',
 109        'If not defined library\' marc org code, use the one from system preferences');
 110
 111     t::lib::Mocks::mock_preference('MARCOrgCode', 'Blah');
 112     is( $library_2->get_effective_marcorgcode, 'Blah',
 113        'Fallback is always MARCOrgCode syspref');
 114
 115     $library_2->marcorgcode('ThisIsACode')->store();
 116     is( $library_2->get_effective_marcorgcode, 'ThisIsACode',
 117        'Pick library_2 code');
 118
 119     $schema->storage->txn_rollback;
 120 };
 121
 122 subtest '->from_email_address' => sub {
 123
 124     plan tests => 3;
 125
 126     $schema->storage->txn_begin;
 127
 128     my $library_1 = $builder->build_object(
 129         {
 130             class => 'Koha::Libraries',
 131             value => {
 132                 branchemail   => 'from@mybranc.com',
 133             }
 134         }
 135     );
 136
 137     t::lib::Mocks::mock_preference( 'KohaAdminEmailAddress', 'admin@mylibrary.com' );
 138
 139     is( $library_1->from_email_address, $library_1->branchemail,
 140        'If defined, use branches branchemail address');
 141
 142     $library_1->branchemail(undef)->store();
 143     is( $library_1->from_email_address, 'admin@mylibrary.com',
 144        'Fallback to KohaAdminEmailAddress email address when branchemail is undefined');
 145
 146     t::lib::Mocks::mock_preference( 'KohaAdminEmailAddress', '' );
 147     is( $library_1->from_email_address, undef,
 148        'Return undef when branchemail and KohaAdminEmailAddress are both undefined');
 149     $schema->storage->txn_rollback;
 150 };
 151
 152 subtest '->inbound_email_address' => sub {
 153
 154     plan tests => 5;
 155
 156     $schema->storage->txn_begin;
 157
 158     my $library_1 = $builder->build_object(
 159         {
 160             class => 'Koha::Libraries',
 161             value => {
 162                 branchemail   => 'from@mybranc.com',
 163                 branchreplyto => 'reply@mybranch.com'
 164             }
 165         }
 166     );
 167
 168     t::lib::Mocks::mock_preference( 'KohaAdminEmailAddress', 'admin@mylibrary.com' );
 169     t::lib::Mocks::mock_preference( 'ReplytoDefault', 'reply@mylibrary.com' );
 170
 171     is( $library_1->inbound_email_address, $library_1->branchreplyto,
 172        'If defined, use branches replyto address');
 173
 174     $library_1->branchreplyto(undef)->store();
 175     is( $library_1->inbound_email_address, $library_1->branchemail,
 176        'Fallback to branches email address when branchreplyto is undefined');
 177
 178     $library_1->branchemail(undef)->store();
 179     is( $library_1->inbound_email_address, 'reply@mylibrary.com',
 180        'Fallback to ReplytoDefault email address when branchreplyto and branchemail are undefined');
 181
 182     t::lib::Mocks::mock_preference( 'ReplytoDefault', '' );
 183     is( $library_1->inbound_email_address, 'admin@mylibrary.com',
 184        'Fallback to KohaAdminEmailAddress email address when branchreplyto, branchemail and ReplytoDefault are undefined');
 185
 186     t::lib::Mocks::mock_preference( 'KohaAdminEmailAddress', '' );
 187     is( $library_1->inbound_email_address, undef,
 188        'Return undef when  email address when branchreplyto, branchemail, ReplytoDefault and KohaAdminEmailAddress are undefined');
 189     $schema->storage->txn_rollback;
 190 };
 191
 192 subtest '->inbound_ill_address' => sub {
 193
 194     plan tests => 7;
 195
 196     $schema->storage->txn_begin;
 197
 198     my $library_1 = $builder->build_object(
 199         {
 200             class => 'Koha::Libraries',
 201             value => {
 202                 branchemail   => 'from@mylibrary.com',
 203                 branchreplyto => 'reply@mylibrary.com',
 204                 branchillemail => 'ill@mylibrary.com'
 205             }
 206         }
 207     );
 208
 209     t::lib::Mocks::mock_preference( 'KohaAdminEmailAddress', 'admin@mylibrary.com' );
 210     t::lib::Mocks::mock_preference( 'ReplytoDefault', 'reply@mylibrary.com' );
 211     t::lib::Mocks::mock_preference( 'ILLDefaultStaffEmail', 'illdefault@mylibrary.com' );
 212
 213     is( $library_1->inbound_ill_address, $library_1->branchillemail,
 214        'If defined, use library branchillemail address');
 215
 216     $library_1->branchillemail(undef)->store();
 217     is( $library_1->inbound_ill_address, 'illdefault@mylibrary.com',
 218        'Fallback to ILLDefaultStaffEmail preference when branchillemail is undefined');
 219
 220     t::lib::Mocks::mock_preference( 'ILLDefaultStaffEmail', undef );
 221     is( $library_1->inbound_ill_address, $library_1->branchreplyto,
 222        'Fallback to library replyto address when ILLDefaultStaffEmail is undefined');
 223
 224     $library_1->branchreplyto(undef)->store();
 225     is( $library_1->inbound_ill_address, $library_1->branchemail,
 226        'Fallback to branches email address when branchreplyto is undefined');
 227
 228     $library_1->branchemail(undef)->store();
 229     is( $library_1->inbound_ill_address, 'reply@mylibrary.com',
 230        'Fallback to ReplytoDefault email address when branchreplyto and branchemail are undefined');
 231
 232     t::lib::Mocks::mock_preference( 'ReplytoDefault', '' );
 233     is( $library_1->inbound_ill_address, 'admin@mylibrary.com',
 234        'Fallback to KohaAdminEmailAddress email address when branchreplyto, branchemail and ReplytoDefault are undefined');
 235
 236     t::lib::Mocks::mock_preference( 'KohaAdminEmailAddress', '' );
 237     is( $library_1->inbound_ill_address, undef,
 238        'Return undef when  email address when branchreplyto, branchemail, ReplytoDefault and KohaAdminEmailAddress are undefined');
 239
 240     $schema->storage->txn_rollback;
 241 };
 242
 243 subtest 'cash_registers' => sub {
 244     plan tests => 3;
 245
 246     $schema->storage->txn_begin;
 247
 248     my $library = $builder->build_object( { class => 'Koha::Libraries' } );
 249     my $register1 = $builder->build_object(
 250         {
 251             class => 'Koha::Cash::Registers',
 252             value  => { branch => $library->branchcode },
 253         }
 254     );
 255     my $register2 = $builder->build_object(
 256         {
 257             class => 'Koha::Cash::Registers',
 258             value  => { branch => $library->branchcode },
 259         }
 260     );
 261
 262     my $registers = $library->cash_registers;
 263     is( ref($registers), 'Koha::Cash::Registers',
 264 'Koha::Library->cash_registers should return a set of Koha::Cash::Registers'
 265     );
 266     is( $registers->count, 2,
 267         'Koha::Library->cash_registers should return the correct cash registers'
 268     );
 269
 270     $register1->delete;
 271     is( $library->cash_registers->next->id, $register2->id,
 272         'Koha::Library->cash_registers should return the correct cash registers'
 273     );
 274
 275     $schema->storage->txn_rollback;
 276 };
 277
 278 subtest 'get_hold_libraries and validate_hold_sibling' => sub {
 279
 280     plan tests => 12;
 281
 282     $schema->storage->txn_begin;
 283
 284     my $library1 = $builder->build_object( { class => 'Koha::Libraries' } );
 285     my $library2 = $builder->build_object( { class => 'Koha::Libraries' } );
 286     my $library3 = $builder->build_object( { class => 'Koha::Libraries' } );
 287     my $library4 = $builder->build_object( { class => 'Koha::Libraries' } );
 288     my $library5 = $builder->build_object( { class => 'Koha::Libraries' } );
 289
 290     my $root1 = $builder->build_object( { class => 'Koha::Library::Groups', value => { ft_local_hold_group => 1 } } );
 291     my $root2 = $builder->build_object( { class => 'Koha::Library::Groups', value => { ft_local_hold_group => 1 } } );
 292     # G1
 293     $builder->build_object( { class => 'Koha::Library::Groups', value => { parent_id => $root1->id, branchcode => $library1->branchcode } } );
 294     $builder->build_object( { class => 'Koha::Library::Groups', value => { parent_id => $root1->id, branchcode => $library2->branchcode } } );
 295     # G2
 296     $builder->build_object( { class => 'Koha::Library::Groups', value => { parent_id => $root2->id, branchcode => $library3->branchcode } } );
 297     $builder->build_object( { class => 'Koha::Library::Groups', value => { parent_id => $root2->id, branchcode => $library4->branchcode } } );
 298     $builder->build_object( { class => 'Koha::Library::Groups', value => { parent_id => $root2->id, branchcode => $library5->branchcode } } );
 299
 300     my @hold_libraries_1 = ($library1, $library2);
 301     my @hold_libraries_2 = ($library3, $library4, $library5);
 302
 303     my @result = $library1->get_hold_libraries()->as_list;
 304     # library1 and library2 are siblings
 305     is(scalar(@result), 2, 'get_hold_libraries returns 2 libraries');
 306
 307     my %map = map {$_->branchcode, 1} @result;
 308
 309     foreach my $hold_library ( @hold_libraries_1 ) {
 310         ok(exists $map{$hold_library->branchcode}, 'library in hold group');
 311     }
 312
 313     @result = $library3->get_hold_libraries()->as_list;
 314     # library3, library4 and library5 are siblings
 315     is(scalar(@result), 3, 'get_hold_libraries returns 3 libraries');
 316
 317     %map = map {$_->branchcode, 1} @result;
 318
 319     foreach my $hold_library ( @hold_libraries_2 ) {
 320         ok(exists $map{$hold_library->branchcode}, 'library in hold group');
 321     }
 322
 323     ok($library1->validate_hold_sibling( { branchcode => $library2->branchcode } ), 'Library 2 is a valid hold sibling');
 324     ok(!$library1->validate_hold_sibling( { branchcode => $library3->branchcode } ), 'Library 3 is not a valid hold sibling');
 325
 326     ok($library3->validate_hold_sibling( { branchcode => $library4->branchcode } ), 'Library 4 is a valid hold sibling');
 327     ok($library3->validate_hold_sibling( { branchcode => $library5->branchcode } ), 'Library 5 is a valid hold sibling');
 328     ok(!$library3->validate_hold_sibling( { branchcode => $library2->branchcode } ), 'Library 2 is not a valid hold sibling');
 329
 330     $schema->storage->txn_rollback;
 331
 332 };
 333
 334 subtest 'outgoing_transfers' => sub {
 335     plan tests => 3;
 336
 337     $schema->storage->txn_begin;
 338
 339     my $library = $builder->build_object( { class => 'Koha::Libraries' } );
 340     my $transfer1 = $builder->build_object(
 341         {
 342             class => 'Koha::Item::Transfers',
 343             value  => { frombranch => $library->branchcode },
 344         }
 345     );
 346     my $transfer2 = $builder->build_object(
 347         {
 348             class => 'Koha::Item::Transfers',
 349             value  => { frombranch => $library->branchcode },
 350         }
 351     );
 352
 353     my $outgoing_transfers = $library->outgoing_transfers;
 354     is( ref($outgoing_transfers), 'Koha::Item::Transfers',
 355 'Koha::Library->outgoing_transfers should return a set of Koha::Item::Transfers'
 356     );
 357     is( $outgoing_transfers->count, 2,
 358         'Koha::Library->outgoing_transfers should return the correct number of transfers'
 359     );
 360
 361     $transfer1->delete;
 362     is( $library->outgoing_transfers->next->id, $transfer2->id,
 363         'Koha::Library->outgoing_transfers should return the correct transfers'
 364     );
 365
 366     $schema->storage->txn_rollback;
 367 };