Lines 1-32
Link Here
|
1 |
#!/usr/bin/perl |
1 |
#!/usr/bin/perl |
2 |
|
2 |
|
3 |
use strict; |
3 |
use Modern::Perl; |
4 |
use warnings; |
|
|
5 |
|
4 |
|
6 |
use C4::Context; |
5 |
use C4::Context; |
7 |
use C4::Members; |
6 |
use C4::Members; |
8 |
|
7 |
|
9 |
use Test::More tests => 18; |
8 |
use Test::More tests => 18; |
10 |
|
9 |
|
11 |
BEGIN { |
10 |
use_ok('Koha::Borrower::Debarments'); |
12 |
use FindBin; |
|
|
13 |
use lib $FindBin::Bin; |
14 |
use_ok('Koha::Borrower::Debarments'); |
15 |
} |
16 |
|
11 |
|
17 |
# Get a borrower with no current debarments |
12 |
my $dbh = C4::Context->dbh; |
18 |
my $dbh = C4::Context->dbh; |
13 |
$dbh->{AutoCommit} = 0; |
19 |
my $query = " |
14 |
$dbh->{RaiseError} = 1; |
20 |
SELECT b.borrowernumber FROM borrowers b |
|
|
21 |
LEFT JOIN borrower_debarments bd ON ( b.borrowernumber = bd.borrowernumber ) |
22 |
WHERE b.debarred IS NULL AND b.debarredcomment IS NULL AND bd.borrowernumber IS NULL |
23 |
LIMIT 1 |
24 |
"; |
25 |
my $sth = $dbh->prepare($query); |
26 |
$sth->execute; |
27 |
my ($borrowernumber) = $sth->fetchrow_array(); |
28 |
diag("Using borrowernumber: $borrowernumber"); |
29 |
|
15 |
|
|
|
16 |
my $borrowernumber = AddMember( |
17 |
firstname => 'my firstname', |
18 |
surname => 'my surname', |
19 |
categorycode => 'S', |
20 |
branchcode => 'CPL', |
21 |
); |
30 |
|
22 |
|
31 |
my $success = AddDebarment({ |
23 |
my $success = AddDebarment({ |
32 |
borrowernumber => $borrowernumber, |
24 |
borrowernumber => $borrowernumber, |
Lines 99-102
foreach my $d ( @$debarments ) {
Link Here
|
99 |
DelDebarment( $d->{'borrower_debarment_id'} ); |
91 |
DelDebarment( $d->{'borrower_debarment_id'} ); |
100 |
} |
92 |
} |
101 |
$debarments = GetDebarments({ borrowernumber => $borrowernumber }); |
93 |
$debarments = GetDebarments({ borrowernumber => $borrowernumber }); |
102 |
ok( @$debarments == 0, "DelDebarment functions correctly" ) |
94 |
ok( @$debarments == 0, "DelDebarment functions correctly" ); |
|
|
95 |
|
96 |
$dbh->rollback; |
103 |
- |
|
|