4 use Test::More tests => 17;
8 use C4::Biblio qw( AddBiblio );
9 use C4::Circulation qw( AddIssue AddReturn );
11 use C4::Items qw( AddItem );
12 use C4::Members qw( AddMember GetMember );
14 use t::lib::TestBuilder;
15 use Koha::Borrower::Discharge;
17 my $builder = t::lib::TestBuilder->new;
18 my $dbh = C4::Context->dbh;
19 $dbh->do(q|DELETE FROM discharges|);
21 C4::Context->_new_userenv('xxx');
22 C4::Context->set_userenv(0, 0, 0, 'firstname', 'surname', 'CPL', 'CPL', '', '', '', '', '');
23 my $branchcode = 'CPL';
24 my $another_branchcode = 'MPL';
25 my $borrower = $builder->build({
28 branchcode => $branchcode,
31 my $borrower2 = $builder->build({
34 branchcode => $branchcode,
37 my $borrower3 = $builder->build({
40 branchcode => $another_branchcode,
44 # Discharge not possible with issues
45 my ( $biblionumber ) = AddBiblio( MARC::Record->new, '');
46 my $barcode = 'BARCODE42';
47 my ( undef, undef, $itemnumber ) = AddItem({ homebranch => 'CPL', holdingbranch => 'CPL', barcode => $barcode }, $biblionumber);
48 AddIssue( $borrower, $barcode );
49 is( Koha::Borrower::Discharge::can_be_discharged({ borrowernumber => $borrower->{borrowernumber} }), 0, 'A patron with issues cannot be discharged' );
51 is( Koha::Borrower::Discharge::request({ borrowernumber => $borrower->{borrowernumber} }), undef, 'No request done if patron has issues' );
52 is( Koha::Borrower::Discharge::discharge({ borrowernumber => $borrower->{borrowernumber} }), undef, 'No discharge done if patron has issues' );
53 is_deeply( Koha::Borrower::Discharge::get_pendings(), [], 'There is no pending discharge request' );
54 is_deeply( Koha::Borrower::Discharge::get_validated(), [], 'There is no validated discharge' );
56 AddReturn( $barcode );
58 # Discharge possible without issue
59 is( Koha::Borrower::Discharge::can_be_discharged({ borrowernumber => $borrower->{borrowernumber} }), 1, 'A patron without issues can be discharged' );
61 is(Koha::Borrower::Discharge::generate_as_pdf,undef,"Confirm failure when lacking borrower number");
63 # Verify that the user is not discharged anymore if the restriction has been lifted
64 Koha::Borrower::Discharge::discharge( { borrowernumber => $borrower->{borrowernumber} } );
65 Koha::Borrower::Discharge::discharge( { borrowernumber => $borrower2->{borrowernumber} } );
66 Koha::Borrower::Discharge::discharge( { borrowernumber => $borrower3->{borrowernumber} } );
67 is( Koha::Borrower::Discharge::is_discharged( { borrowernumber => $borrower->{borrowernumber} } ), 1, 'The patron has been discharged' );
68 is( Koha::Borrower::Debarments::IsDebarred( $borrower->{borrowernumber} ), '9999-12-31', 'The patron has been debarred after discharge' );
69 is( scalar( @{ Koha::Borrower::Discharge::get_validated() } ), 3, 'There are 3 validated discharges' );
70 is( scalar( @{ Koha::Borrower::Discharge::get_validated( { borrowernumber => $borrower->{borrowernumber} } ) } ), 1, 'There is 1 validated discharge for a given patron' );
71 is( scalar( @{ Koha::Borrower::Discharge::get_validated( { branchcode => 'CPL' } ) } ), 2, 'There is 2 validated discharges for a given branchcode' ); # This is not used in the code yet
72 Koha::Borrower::Debarments::DelUniqueDebarment( { 'borrowernumber' => $borrower->{borrowernumber}, 'type' => 'DISCHARGE' } );
73 ok( !Koha::Borrower::Debarments::IsDebarred( $borrower->{borrowernumber} ), 'The debarment has been lifted' );
74 ok( !Koha::Borrower::Discharge::is_discharged( { borrowernumber => $borrower->{borrowernumber} } ), 'The patron is not discharged after the restriction has been lifted' );
76 # Verify that the discharge works multiple times
77 Koha::Borrower::Discharge::request({ borrowernumber => $borrower->{borrowernumber} });
78 is(scalar( @{ Koha::Borrower::Discharge::get_pendings() }), 1, 'There is a pending discharge request (second time)');
79 Koha::Borrower::Discharge::discharge( { borrowernumber => $borrower->{borrowernumber} } );
80 is_deeply( Koha::Borrower::Discharge::get_pendings(), [], 'There is no pending discharge request (second time)');
82 # Check if PDF::FromHTML is installed.
83 my $check = eval { require PDF::FromHTML; };
85 # Tests for if PDF::FromHTML is installed
87 isnt( Koha::Borrower::Discharge::generate_as_pdf({ borrowernumber => $borrower->{borrowernumber} }), undef, "Temporary PDF generated." );
89 # Tests for if PDF::FromHTML is not installed
91 warning_like { Koha::Borrower::Discharge::generate_as_pdf({ borrowernumber => $borrower->{borrowernumber}, testing => 1 }) }
92 [ qr/Can't locate PDF\/FromHTML.pm in \@INC/ ],
93 "Expected failure because of missing PDF::FromHTML.";
97 # At this point, there is a problem with the AutoCommit off
98 # The transaction is bloked into DBIx::Class::Storage::DBI::_dbh_execute
99 # line my $rv = $sth->execute();
100 # We are using 2 connections and the one used by Koha::Schema has the AutoCommit set to 1
101 # Even if we switch off this flag, the connection will be blocked.
103 # DBIx::Class::ResultSet::create(): DBI Exception: DBD::mysql::st execute failed: Lock wait timeout exceeded; try restarting transaction [for Statement "INSERT INTO discharges ( borrower, needed, validated) VALUES ( ?, ?, ? )" with ParamValues: 0='121', 1='2014-01-08T16:38:29', 2=undef] at /home/koha/src/Koha/DataObject/Discharge.pm line 33
104 #is( Koha::Service::Borrower::Discharge::request({ borrowernumber => $borrower->{borrowernumber} }), 1, 'Discharge request sent' );