View | Details | Raw Unified | Return to bug 10895
Collapse All | Expand All

(-)a/t/db_dependent/GetHiddenItems_PatronCategory.t (-1 / +237 lines)
Line 0 Link Here
0
- 
1
#!/usr/bin/perl
2
3
# This file is part of Koha.
4
#
5
# Copyright (C) 2013  Mark Tompsett
6
#
7
# This Koha test module is intended for Patron Category
8
# tweaks to the OpacHiddenItems system preference.
9
# Related to Bug 10859
10
#
11
# Koha is free software; you can redistribute it and/or modify it
12
# under the terms of the GNU General Public License as published by
13
# the Free Software Foundation; either version 3 of the License, or
14
# (at your option) any later version.
15
#
16
# Koha is distributed in the hope that it will be useful, but
17
# WITHOUT ANY WARRANTY; without even the implied warranty of
18
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
19
# GNU General Public License for more details.
20
#
21
# You should have received a copy of the GNU General Public License
22
# along with Koha; if not, see <http://www.gnu.org/licenses>.
23
#
24
25
use Modern::Perl;
26
use MARC::Record;
27
use Carp;
28
use C4::Biblio;
29
use C4::Context;
30
use C4::Members;
31
use Data::Dumper;
32
use YAML qw/Load/; # due to bug 10872 not being in master yet.
33
use Test::More tests => 22;
34
35
BEGIN {
36
    use_ok('C4::Items');
37
}
38
39
my $dbh = C4::Context->dbh;
40
# Start transaction
41
$dbh->{AutoCommit} = 0;
42
$dbh->{RaiseError} = 1;
43
 
44
# Helper biblio.
45
my ($bibnum, $bibitemnum) = get_biblio();
46
47
# Add dummy branches.
48
$dbh->do('INSERT INTO branches (branchcode,branchname) VALUES ("LIB1","LIB1");');
49
$dbh->do('INSERT INTO branches (branchcode,branchname) VALUES ("LIB2","LIB2");');
50
51
# Add dummy patron categories
52
$dbh->do("INSERT INTO categories (categorycode, description) VALUES ('SPT','Sample Patron Code');");
53
$dbh->do("INSERT INTO categories (categorycode, description) VALUES ('SS','Sample Staff Code');");
54
55
# Add same item for two branches.
56
my ($item_bibnum, $item_bibitemnum, $itemnumber) = AddItem({ homebranch => 'LIB1', holdingbranch => 'LIB1' } , $bibnum);
57
cmp_ok($item_bibnum, '==', $bibnum, "LIB1 Item linked to correct biblionumber.");
58
cmp_ok($item_bibitemnum, '==', $bibitemnum, "LIB1 Item linked to correct biblioitemnumber.");
59
($item_bibnum, $item_bibitemnum, $itemnumber) = AddItem({ homebranch => 'LIB2', holdingbranch => 'LIB2' } , $bibnum);
60
cmp_ok($item_bibnum, '==', $bibnum, "LIB2 Item linked to correct biblionumber.");
61
cmp_ok($item_bibitemnum, '==', $bibitemnum, "LIB2 Item linked to correct biblioitemnumber.");
62
63
# Add dummy patron.
64
C4::Context->set_preference('PatronSelfRegistrationDefaultCategory','PT');
65
my %borrower;
66
my $cardnumber = fixup_cardnumber();
67
$borrower{'cardnumber'} = $cardnumber;
68
$borrower{'surname'} = 'Borrower';
69
$borrower{'firstname'} = 'Sample';
70
$borrower{'address'} = '123 Bogus Street';
71
$borrower{'city'} = 'Bogusville';
72
$borrower{'branchcode'} = 'LIB1';
73
$borrower{'categorycode'} = 'PT';
74
$borrower{'zipcode'} = 'H0H 0H0';
75
$borrower{'userid'} = 'Sample.Borrower';
76
$borrower{'email'} = 'santa@northpole.com';
77
$borrower{'phone'} = '967-1111';
78
my ( $borrowernumber, $password ) = AddMember_Opac(%borrower) or
79
                                    croak "AddMember_Opac failed.\n";
80
diag("Sample Borrower added.\n");
81
82
# Get an array of hashes of Item information.
83
my @all_items = C4::Items::GetItemsInfo($bibnum);
84
diag($all_items[0]->{'itemnumber'} . " - " . $all_items[0]->{'homebranch'});
85
diag($all_items[1]->{'itemnumber'} . " - " . $all_items[1]->{'homebranch'});
86
87
# Hide everything for this record.
88
C4::Context->set_preference('OpacHiddenItems',"homebranch: [LIB1,LIB2]\n");
89
90
# Check what's hidden when a user isn't logged in.
91
my @items2hide = C4::Items::GetHiddenItemnumbers(@all_items);
92
cmp_ok( scalar @items2hide, '==', 2, "OpacHiddenItems hid everything correctly.");
93
diag(join(',',@items2hide));
94
95
# Set up dummy patron as if logged in.
96
my @USERENV = (
97
    $borrowernumber,
98
    'Sample.Borrower',
99
    $cardnumber,
100
    'Test',
101
    'Test',
102
    'LIB1',
103
    'LIB1',
104
    0,
105
);
106
C4::Context->_new_userenv('DUMMY_SESSION_ID');
107
C4::Context->set_userenv( @USERENV );
108
diag("Sample Borrower environment variables set up.\n");
109
110
# 4 blocks of 4 cases: 'SPT','SS','','SS|SPT'
111
C4::Context->set_preference('PatronSingleBranch','SPT');
112
C4::Context->set_preference('PatronEveryBranch','SPT');
113
my $sql = "UPDATE borrowers SET categorycode='SPT' WHERE borrowernumber=?;";
114
my $sth = $dbh->prepare($sql);
115
$sth->execute($borrowernumber);
116
117
@items2hide = C4::Items::GetHiddenItemnumbers(@all_items);
118
cmp_ok( scalar @items2hide, '==', 0, "OpacHiddenItems unhid everything correctly.");
119
diag(join(',',@items2hide));
120
121
# PatronSingleBranch toggle
122
C4::Context->set_preference('PatronSingleBranch','SPT');
123
C4::Context->set_preference('PatronEveryBranch','SS');
124
@items2hide = C4::Items::GetHiddenItemnumbers(@all_items);
125
cmp_ok( scalar @items2hide, '==', 1, "OpacHiddenItems hid LIB2 correctly.");
126
diag(join(',',@items2hide));
127
128
# PatronSingleBranch toggle
129
C4::Context->set_preference('PatronSingleBranch','SPT');
130
C4::Context->set_preference('PatronEveryBranch','');
131
@items2hide = C4::Items::GetHiddenItemnumbers(@all_items);
132
cmp_ok( scalar @items2hide, '==', 1, "OpacHiddenItems hid LIB2 correctly.");
133
diag(join(',',@items2hide));
134
135
# PatronSingleBranch toggle
136
C4::Context->set_preference('PatronSingleBranch','SPT');
137
C4::Context->set_preference('PatronEveryBranch','SS|SPT');
138
@items2hide = C4::Items::GetHiddenItemnumbers(@all_items);
139
cmp_ok( scalar @items2hide, '==', 0, "OpacHiddenItems unhid everything correctly.");
140
diag(join(',',@items2hide));
141
142
# PatronSingleBranch toggle
143
C4::Context->set_preference('PatronSingleBranch','SS');
144
C4::Context->set_preference('PatronEveryBranch','SPT');
145
@items2hide = C4::Items::GetHiddenItemnumbers(@all_items);
146
cmp_ok( scalar @items2hide, '==', 0, "OpacHiddenItems unhid everything correctly.");
147
diag(join(',',@items2hide));
148
149
# PatronSingleBranch toggle
150
C4::Context->set_preference('PatronSingleBranch','SS');
151
C4::Context->set_preference('PatronEveryBranch','SS');
152
@items2hide = C4::Items::GetHiddenItemnumbers(@all_items);
153
cmp_ok( scalar @items2hide, '==', 2, "OpacHiddenItems hid everything correctly.");
154
diag(join(',',@items2hide));
155
156
# PatronSingleBranch toggle
157
C4::Context->set_preference('PatronSingleBranch','SS');
158
C4::Context->set_preference('PatronEveryBranch','');
159
@items2hide = C4::Items::GetHiddenItemnumbers(@all_items);
160
cmp_ok( scalar @items2hide, '==', 2, "OpacHiddenItems hid everything correctly.");
161
diag(join(',',@items2hide));
162
163
# PatronSingleBranch toggle
164
C4::Context->set_preference('PatronSingleBranch','SS');
165
C4::Context->set_preference('PatronEveryBranch','SS|SPT');
166
@items2hide = C4::Items::GetHiddenItemnumbers(@all_items);
167
cmp_ok( scalar @items2hide, '==', 0, "OpacHiddenItems unhid everything correctly.");
168
diag(join(',',@items2hide));
169
170
# PatronSingleBranch toggle
171
C4::Context->set_preference('PatronSingleBranch','');
172
C4::Context->set_preference('PatronEveryBranch','SPT');
173
@items2hide = C4::Items::GetHiddenItemnumbers(@all_items);
174
cmp_ok( scalar @items2hide, '==', 0, "OpacHiddenItems unhid everything correctly.");
175
diag(join(',',@items2hide));
176
177
# PatronSingleBranch toggle
178
C4::Context->set_preference('PatronSingleBranch','');
179
C4::Context->set_preference('PatronEveryBranch','SS');
180
@items2hide = C4::Items::GetHiddenItemnumbers(@all_items);
181
cmp_ok( scalar @items2hide, '==', 2, "OpacHiddenItems hid everything correctly.");
182
diag(join(',',@items2hide));
183
184
# PatronSingleBranch toggle
185
C4::Context->set_preference('PatronSingleBranch','');
186
C4::Context->set_preference('PatronEveryBranch','');
187
@items2hide = C4::Items::GetHiddenItemnumbers(@all_items);
188
cmp_ok( scalar @items2hide, '==', 2, "OpacHiddenItems hid everything correctly.");
189
diag(join(',',@items2hide));
190
191
# PatronSingleBranch toggle
192
C4::Context->set_preference('PatronSingleBranch','');
193
C4::Context->set_preference('PatronEveryBranch','SS|SPT');
194
@items2hide = C4::Items::GetHiddenItemnumbers(@all_items);
195
cmp_ok( scalar @items2hide, '==', 0, "OpacHiddenItems unhid everything correctly.");
196
diag(join(',',@items2hide));
197
198
# PatronSingleBranch toggle
199
C4::Context->set_preference('PatronSingleBranch','SS|SPT');
200
C4::Context->set_preference('PatronEveryBranch','SPT');
201
@items2hide = C4::Items::GetHiddenItemnumbers(@all_items);
202
cmp_ok( scalar @items2hide, '==', 0, "OpacHiddenItems unhid everything correctly.");
203
diag(join(',',@items2hide));
204
205
# PatronSingleBranch toggle
206
C4::Context->set_preference('PatronSingleBranch','SS|SPT');
207
C4::Context->set_preference('PatronEveryBranch','SS');
208
@items2hide = C4::Items::GetHiddenItemnumbers(@all_items);
209
cmp_ok( scalar @items2hide, '==', 1, "OpacHiddenItems hid LIB2 correctly.");
210
diag(join(',',@items2hide));
211
212
# PatronSingleBranch toggle
213
C4::Context->set_preference('PatronSingleBranch','SS|SPT');
214
C4::Context->set_preference('PatronEveryBranch','');
215
@items2hide = C4::Items::GetHiddenItemnumbers(@all_items);
216
cmp_ok( scalar @items2hide, '==', 1, "OpacHiddenItems hid LIB2 correctly.");
217
diag(join(',',@items2hide));
218
219
# PatronSingleBranch toggle
220
C4::Context->set_preference('PatronSingleBranch','SS|SPT');
221
C4::Context->set_preference('PatronEveryBranch','SS|SPT');
222
@items2hide = C4::Items::GetHiddenItemnumbers(@all_items);
223
cmp_ok( scalar @items2hide, '==', 0, "OpacHiddenItems unhid everything correctly.");
224
diag(join(',',@items2hide));
225
226
# Nothing wrong with being explicit. :)
227
$dbh->rollback();
228
229
# Helper method to set up a Biblio.
230
sub get_biblio {
231
    my $bib = MARC::Record->new();
232
    $bib->append_fields(
233
        MARC::Field->new('100', ' ', ' ', a => 'Moffat, Steven'),
234
        MARC::Field->new('245', ' ', ' ', a => 'Silence in the library'),
235
    );
236
    return ($bibnum, $bibitemnum) = AddBiblio($bib, '');
237
}

Return to bug 10895