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>.
26 use Test::More tests => 14;
28 use t::lib::TestBuilder;
31 use_ok('C4::Circulation');
34 can_ok( 'C4::Circulation', qw(
37 GetBranchBorrowerCircRule
43 my $schema = Koha::Database->schema;
44 $schema->storage->txn_begin;
45 my $dbh = C4::Context->dbh;
47 $dbh->do(q|DELETE FROM issues|);
48 $dbh->do(q|DELETE FROM items|);
49 $dbh->do(q|DELETE FROM borrowers|);
50 $dbh->do(q|DELETE FROM branches|);
51 $dbh->do(q|DELETE FROM categories|);
52 $dbh->do(q|DELETE FROM accountlines|);
53 $dbh->do(q|DELETE FROM itemtypes|);
54 $dbh->do(q|DELETE FROM branch_item_rules|);
55 $dbh->do(q|DELETE FROM branch_borrower_circ_rules|);
56 $dbh->do(q|DELETE FROM default_branch_circ_rules|);
57 $dbh->do(q|DELETE FROM default_circ_rules|);
58 $dbh->do(q|DELETE FROM default_branch_item_rules|);
60 my $builder = t::lib::TestBuilder->new();
63 my $samplebranch1 = $builder->build({ source => 'Branch' });
64 my $samplebranch2 = $builder->build({ source => 'Branch' });
66 my $no_circ_itemtype = $builder->build({
73 my $sampleitemtype1 = $builder->build({
76 rentalcharge => '10.0',
80 my $sampleitemtype2 = $builder->build({
83 rentalcharge => '5.0',
88 my $samplecat = $builder->build({
96 my $record = MARC::Record->new();
97 $record->append_fields(
98 MARC::Field->new( '952', '0', '0', a => $samplebranch1->{branchcode} ) );
99 my ( $biblionumber, $biblioitemnumber ) = C4::Biblio::AddBiblio( $record, '' );
101 # item 1 has home branch and holding branch samplebranch1
102 my @sampleitem1 = C4::Items::AddItem(
104 barcode => 'barcode_1',
105 itemcallnumber => 'callnumber1',
106 homebranch => $samplebranch1->{branchcode},
107 holdingbranch => $samplebranch1->{branchcode},
108 itype => $no_circ_itemtype->{ itemtype }
112 my $item_id1 = $sampleitem1[2];
114 # item 2 has holding branch samplebranch2
115 my @sampleitem2 = C4::Items::AddItem(
117 barcode => 'barcode_2',
118 itemcallnumber => 'callnumber2',
119 homebranch => $samplebranch2->{branchcode},
120 holdingbranch => $samplebranch1->{branchcode},
121 itype => $no_circ_itemtype->{ itemtype }
125 my $item_id2 = $sampleitem2[2];
127 # item 3 has item type sampleitemtype2 with noreturn policy
128 my @sampleitem3 = C4::Items::AddItem(
130 barcode => 'barcode_3',
131 itemcallnumber => 'callnumber3',
132 homebranch => $samplebranch2->{branchcode},
133 holdingbranch => $samplebranch2->{branchcode},
134 itype => $sampleitemtype2->{itemtype}
138 my $item_id3 = $sampleitem3[2];
141 my $borrower_id1 = C4::Members::AddMember(
142 firstname => 'firstname1',
143 surname => 'surname1 ',
144 categorycode => $samplecat->{categorycode},
145 branchcode => $samplebranch1->{branchcode},
147 my $borrower_1 = C4::Members::GetMember(borrowernumber => $borrower_id1);
150 GetBranchBorrowerCircRule(),
151 { maxissueqty => undef, maxonsiteissueqty => undef },
152 "Without parameter, GetBranchBorrower returns undef (unilimited) for maxissueqty and maxonsiteissueqty if no rules defined"
156 INSERT INTO branch_borrower_circ_rules
157 (branchcode, categorycode, maxissueqty, maxonsiteissueqty)
163 $samplebranch1->{branchcode},
164 $samplecat->{categorycode}, 5, 6
168 INSERT INTO default_branch_circ_rules
169 (branchcode, maxissueqty, maxonsiteissueqty, holdallowed, returnbranch)
170 VALUES( ?, ?, ?, ?, ? )
172 $dbh->do( $query, {}, $samplebranch2->{branchcode},
173 3, 2, 1, 'holdingbranch' );
175 INSERT INTO default_circ_rules
176 (singleton, maxissueqty, maxonsiteissueqty, holdallowed, returnbranch)
177 VALUES( ?, ?, ?, ?, ? )
179 $dbh->do( $query, {}, 'singleton', 4, 5, 3, 'homebranch' );
182 "INSERT INTO branch_item_rules (branchcode,itemtype,holdallowed,returnbranch) VALUES( ?,?,?,?)";
183 my $sth = $dbh->prepare($query);
185 $samplebranch1->{branchcode},
186 $sampleitemtype1->{itemtype},
190 $samplebranch2->{branchcode},
191 $sampleitemtype1->{itemtype},
195 $samplebranch2->{branchcode},
196 $sampleitemtype2->{itemtype},
200 #Test GetBranchBorrowerCircRule
202 GetBranchBorrowerCircRule(),
203 { maxissueqty => 4, maxonsiteissueqty => 5 },
204 "Without parameter, GetBranchBorrower returns the maxissueqty and maxonsiteissueqty of default_circ_rules"
207 GetBranchBorrowerCircRule( $samplebranch2->{branchcode} ),
208 { maxissueqty => 3, maxonsiteissueqty => 2 },
209 "Without only the branchcode specified, GetBranchBorrower returns the maxissueqty and maxonsiteissueqty corresponding"
212 GetBranchBorrowerCircRule(
213 $samplebranch1->{branchcode},
214 $samplecat->{categorycode}
216 { maxissueqty => 5, maxonsiteissueqty => 6 },
217 "GetBranchBorrower returns the maxissueqty and maxonsiteissueqty of the branch1 and the category1"
220 GetBranchBorrowerCircRule( -1, -1 ),
221 { maxissueqty => 4, maxonsiteissueqty => 5 },
222 "GetBranchBorrower with wrong parameters returns the maxissueqty and maxonsiteissueqty of default_circ_rules"
225 #Test GetBranchItemRule
226 my @lazy_any = ( 'hold_fulfillment_policy' => 'any' );
229 $samplebranch1->{branchcode},
230 $sampleitemtype1->{itemtype},
232 { returnbranch => 'homebranch', holdallowed => 5, @lazy_any },
233 "GetBranchitem returns holdallowed and return branch"
237 { returnbranch => 'homebranch', holdallowed => 3, @lazy_any },
238 "Without parameters GetBranchItemRule returns the values in default_circ_rules"
241 GetBranchItemRule( $samplebranch2->{branchcode} ),
242 { returnbranch => 'holdingbranch', holdallowed => 1, @lazy_any },
243 "With only a branchcode GetBranchItemRule returns values in default_branch_circ_rules"
246 GetBranchItemRule( -1, -1 ),
247 { returnbranch => 'homebranch', holdallowed => 3, @lazy_any },
248 "With only one parametern GetBranchItemRule returns default values"
251 # Test return policies
252 t::lib::Mocks::mock_preference('AutomaticItemReturn','0');
254 # item1 returned at branch2 should trigger transfer to homebranch
256 "INSERT INTO issues (borrowernumber,itemnumber,branchcode) VALUES( ?,?,? )";
257 $dbh->do( $query, {}, $borrower_id1, $item_id1, $samplebranch1->{branchcode} );
259 my ($doreturn, $messages, $iteminformation, $borrower) = AddReturn('barcode_1',
260 $samplebranch2->{branchcode});
261 is( $messages->{NeedsTransfer}, $samplebranch1->{branchcode}, "AddReturn respects default return policy - return to homebranch" );
263 # item2 returned at branch2 should trigger transfer to holding branch
265 "INSERT INTO issues (borrowernumber,itemnumber,branchcode) VALUES( ?,?,? )";
266 $dbh->do( $query, {}, $borrower_id1, $item_id2, $samplebranch2->{branchcode} );
267 ($doreturn, $messages, $iteminformation, $borrower) = AddReturn('barcode_2',
268 $samplebranch2->{branchcode});
269 is( $messages->{NeedsTransfer}, $samplebranch1->{branchcode}, "AddReturn respects branch return policy - item2->homebranch policy = 'holdingbranch'" );
271 # item3 should not trigger transfer - floating collection
273 "INSERT INTO issues (borrowernumber,itemnumber,branchcode) VALUES( ?,?,? )";
274 $dbh->do( $query, {}, $borrower_id1, $item_id3, $samplebranch1->{branchcode} );
275 ($doreturn, $messages, $iteminformation, $borrower) = AddReturn('barcode_3',
276 $samplebranch1->{branchcode});
277 is($messages->{NeedsTransfer},undef,"AddReturn respects branch item return policy - noreturn");
279 $schema->storage->txn_rollback;