t/db_dependent/Circulation/transfers.t

   1 #!/usr/bin/perl
   2
   3 use Modern::Perl;
   4 use C4::Biblio;
   5 use C4::Context;
   6 use C4::Items;
   7 use C4::Circulation;
   8 use Koha::Database;
   9 use Koha::DateUtils;
  10 use DateTime::Duration;
  11
  12 use t::lib::TestBuilder;
  13
  14 use Test::More tests => 22;
  15 use Test::Deep;
  16
  17 BEGIN {
  18     use_ok('C4::Circulation');
  19 }
  20 can_ok(
  21     'C4::Circulation',
  22     qw(
  23       CreateBranchTransferLimit
  24       DeleteBranchTransferLimits
  25       DeleteTransfer
  26       GetTransfers
  27       GetTransfersFromTo
  28       )
  29 );
  30
  31 my $schema = Koha::Database->schema;
  32 $schema->storage->txn_begin;
  33 my $builder = t::lib::TestBuilder->new;
  34
  35 my $dbh = C4::Context->dbh;
  36 $dbh->do(q|DELETE FROM issues|);
  37 $dbh->do(q|DELETE FROM borrowers|);
  38 $dbh->do(q|DELETE FROM items|);
  39 $dbh->do(q|DELETE FROM branches|);
  40 $dbh->do(q|DELETE FROM branch_transfer_limits|);
  41 $dbh->do(q|DELETE FROM branchtransfers|);
  42
  43 #Add sample datas
  44 #Add branches
  45 my $samplebranch1 = $builder->build({
  46     source => 'Branch',
  47 });
  48 my $samplebranch2 = $builder->build({
  49     source => 'Branch',
  50 });
  51
  52 #Add biblio and items
  53 my $record = MARC::Record->new();
  54 $record->append_fields(
  55     MARC::Field->new( '952', '0', '0', a => $samplebranch1->{branchcode} ) );
  56 my ( $biblionumber, $biblioitemnumber ) = C4::Biblio::AddBiblio( $record, '', );
  57
  58 my @sampleitem1 = C4::Items::AddItem(
  59     {
  60         barcode        => 1,
  61         itemcallnumber => 'callnumber1',
  62         homebranch     => $samplebranch1->{branchcode},
  63         holdingbranch  => $samplebranch1->{branchcode}
  64     },
  65     $biblionumber
  66 );
  67 my $item_id1    = $sampleitem1[2];
  68 my @sampleitem2 = C4::Items::AddItem(
  69     {
  70         barcode        => 2,
  71         itemcallnumber => 'callnumber2',
  72         homebranch     => $samplebranch1->{branchcode},
  73         holdingbranch  => $samplebranch1->{branchcode}
  74     },
  75     $biblionumber
  76 );
  77 my $item_id2 = $sampleitem2[2];
  78
  79 #Add transfers
  80 ModItemTransfer(
  81     $item_id1,
  82     $samplebranch1->{branchcode},
  83     $samplebranch2->{branchcode}
  84 );
  85 ModItemTransfer(
  86     $item_id2,
  87     $samplebranch1->{branchcode},
  88     $samplebranch2->{branchcode}
  89 );
  90
  91 #Begin Tests
  92 #Test CreateBranchTransferLimit
  93 is(
  94     CreateBranchTransferLimit(
  95         $samplebranch2->{branchcode},
  96         $samplebranch1->{branchcode}, 'CODE'
  97     ),
  98     1,
  99     "A Branch TransferLimit has been added"
 100 );
 101 is(CreateBranchTransferLimit(),undef,
 102     "Without parameters CreateBranchTransferLimit returns undef");
 103 is(CreateBranchTransferLimit($samplebranch2->{branchcode}),undef,
 104     "With only tobranch CreateBranchTransferLimit returns undef");
 105 is(CreateBranchTransferLimit(undef,$samplebranch2->{branchcode}),undef,
 106     "With only frombranch CreateBranchTransferLimit returns undef");
 107 #FIXME: Currently, we can add a transferlimit even to nonexistent branches because in the database,
 108 #branch_transfer_limits.toBranch and branch_transfer_limits.fromBranch aren't foreign keys
 109 #is(CreateBranchTransferLimit(-1,-1,'CODE'),0,"With wrong CreateBranchTransferLimit returns 0 - No transfertlimit added");
 110
 111 #Test GetTransfers
 112 my @transfers = GetTransfers($item_id1);
 113 cmp_deeply(
 114     \@transfers,
 115     [ re('^\d{4}-\d{2}-\d{2} \d{2}:\d{2}:\d{2}$'), $samplebranch1->{branchcode}, $samplebranch2->{branchcode} ],
 116     "Transfers of the item1"
 117 );    #NOTE: Only the first transfer is returned
 118 @transfers = GetTransfers;
 119 is_deeply( \@transfers, [],
 120     "GetTransfers without params returns an empty array" );
 121 @transfers = GetTransfers(-1);
 122 is_deeply( \@transfers, [],
 123     "GetTransfers with a wrong item id returns an empty array" );
 124
 125 #Test GetTransfersFromTo
 126 my @transferfrom1to2 = GetTransfersFromTo( $samplebranch1->{branchcode},
 127     $samplebranch2->{branchcode} );
 128 cmp_deeply(
 129     \@transferfrom1to2,
 130     [
 131         {
 132             itemnumber => $item_id1,
 133             datesent   => re('^\d{4}-\d{2}-\d{2} \d{2}:\d{2}:\d{2}$'),
 134             frombranch => $samplebranch1->{branchcode}
 135         },
 136         {
 137             itemnumber => $item_id2,
 138             datesent   => re('^\d{4}-\d{2}-\d{2} \d{2}:\d{2}:\d{2}$'),
 139             frombranch => $samplebranch1->{branchcode}
 140         }
 141     ],
 142     "Item1 and Item2 has been transferred from branch1 to branch2"
 143 );
 144 my @transferto = GetTransfersFromTo( undef, $samplebranch2->{branchcode} );
 145 is_deeply( \@transferto, [],
 146     "GetTransfersfromTo without frombranch returns an empty array" );
 147 my @transferfrom = GetTransfersFromTo( $samplebranch1->{branchcode} );
 148 is_deeply( \@transferfrom, [],
 149     "GetTransfersfromTo without tobranch returns an empty array" );
 150 @transferfrom = GetTransfersFromTo();
 151 is_deeply( \@transferfrom, [],
 152     "GetTransfersfromTo without params returns an empty array" );
 153
 154 #Test DeleteBranchTransferLimits
 155 is(
 156     C4::Circulation::DeleteBranchTransferLimits( $samplebranch1->{branchcode} ),
 157     1,
 158     "A Branch TransferLimit has been deleted"
 159 );
 160 is(C4::Circulation::DeleteBranchTransferLimits(),undef,"Without parameters DeleteBranchTransferLimit returns undef");
 161 is(C4::Circulation::DeleteBranchTransferLimits('B'),'0E0',"With a wrong id DeleteBranchTransferLimit returns 0E0");
 162
 163 #Test DeleteTransfer
 164 is( C4::Circulation::DeleteTransfer($item_id1),
 165     1, "A the item1's transfer has been deleted" );
 166 is(C4::Circulation::DeleteTransfer(),undef,"Without itemid DeleteTransfer returns undef");
 167 is(C4::Circulation::DeleteTransfer(-1),'0E0',"with a wrong itemid DeleteTranfer returns 0E0");
 168
 169 #Test TransferSlip
 170 is( C4::Circulation::TransferSlip($samplebranch1->{branchcode}, undef, 5, $samplebranch2->{branchcode}),
 171     undef, "No tranferslip if invalid or undef itemnumber or barcode" );
 172 is( C4::Circulation::TransferSlip($samplebranch1->{branchcode}, $item_id1, 1, $samplebranch2->{branchcode})->{'code'},
 173     'TRANSFERSLIP', "Get a transferslip on valid itemnumber and/or barcode" );
 174 cmp_deeply(
 175     C4::Circulation::TransferSlip($samplebranch1->{branchcode}, $item_id1, undef, $samplebranch2->{branchcode}),
 176     C4::Circulation::TransferSlip($samplebranch1->{branchcode}, undef, 1, $samplebranch2->{branchcode}),
 177     "Barcode and itemnumber for same item both generate same TransferSlip"
 178     );