Lines 17-23
Link Here
|
17 |
|
17 |
|
18 |
use Modern::Perl; |
18 |
use Modern::Perl; |
19 |
|
19 |
|
20 |
use Test::More tests => 17; |
20 |
use Test::More tests => 18; |
21 |
use Test::Warn; |
21 |
use Test::Warn; |
22 |
|
22 |
|
23 |
use C4::Context; |
23 |
use C4::Context; |
Lines 104-108
foreach my $b ( $patrons->as_list() ) {
Link Here
|
104 |
is( $b->categorycode(), $categorycode, "Iteration returns a patron object" ); |
104 |
is( $b->categorycode(), $categorycode, "Iteration returns a patron object" ); |
105 |
} |
105 |
} |
106 |
|
106 |
|
|
|
107 |
subtest "Update patron categories" => sub { |
108 |
plan tests => 23; |
109 |
$builder->schema->resultset( 'Issue' )->delete_all; |
110 |
$builder->schema->resultset( 'Borrower' )->delete_all; |
111 |
$builder->schema->resultset( 'Category' )->delete_all; |
112 |
my $c_categorycode = $builder->build({ source => 'Category', value => { |
113 |
category_type=>'C', |
114 |
upperagelimit=>17, |
115 |
dateofbirthrequired=>5, |
116 |
} })->{categorycode}; |
117 |
my $a_categorycode = $builder->build({ source => 'Category', value => {category_type=>'A'} })->{categorycode}; |
118 |
my $p_categorycode = $builder->build({ source => 'Category', value => {category_type=>'P'} })->{categorycode}; |
119 |
my $i_categorycode = $builder->build({ source => 'Category', value => {category_type=>'I'} })->{categorycode}; |
120 |
my $branchcode1 = $builder->build({ source => 'Branch' })->{branchcode}; |
121 |
my $branchcode2 = $builder->build({ source => 'Branch' })->{branchcode}; |
122 |
my $adult1 = $builder->build({source => 'Borrower', value => { |
123 |
categorycode=>$a_categorycode, |
124 |
branchcode=>$branchcode1, |
125 |
dateenrolled=>'2018-01-01', |
126 |
sort1 =>'quack', |
127 |
} |
128 |
}); |
129 |
my $adult2 = $builder->build({source => 'Borrower', value => { |
130 |
categorycode=>$a_categorycode, |
131 |
branchcode=>$branchcode2, |
132 |
dateenrolled=>'2017-01-01', |
133 |
} |
134 |
}); |
135 |
my $inst = $builder->build({source => 'Borrower', value => { |
136 |
categorycode=>$i_categorycode, |
137 |
branchcode=>$branchcode2, |
138 |
} |
139 |
}); |
140 |
my $prof = $builder->build({source => 'Borrower', value => { |
141 |
categorycode=>$p_categorycode, |
142 |
branchcode=>$branchcode2, |
143 |
guarantorid=>$inst->{borrowernumber}, |
144 |
} |
145 |
}); |
146 |
my $child1 = $builder->build({source => 'Borrower', value => { |
147 |
dateofbirth => dt_from_string->add(years=>-4), |
148 |
categorycode=>$c_categorycode, |
149 |
guarantorid=>$adult1->{borrowernumber}, |
150 |
branchcode=>$branchcode1, |
151 |
} |
152 |
}); |
153 |
my $child2 = $builder->build({source => 'Borrower', value => { |
154 |
dateofbirth => dt_from_string->add(years=>-8), |
155 |
categorycode=>$c_categorycode, |
156 |
guarantorid=>$adult1->{borrowernumber}, |
157 |
branchcode=>$branchcode1, |
158 |
} |
159 |
}); |
160 |
my $child3 = $builder->build({source => 'Borrower', value => { |
161 |
dateofbirth => dt_from_string->add(years=>-18), |
162 |
categorycode=>$c_categorycode, |
163 |
guarantorid=>$adult1->{borrowernumber}, |
164 |
branchcode=>$branchcode1, |
165 |
} |
166 |
}); |
167 |
$builder->build({source=>'Accountline',value => {amountoutstanding=>4.99,borrowernumber=>$adult1->{borrowernumber}}}); |
168 |
$builder->build({source=>'Accountline',value => {amountoutstanding=>5.01,borrowernumber=>$adult2->{borrowernumber}}}); |
169 |
|
170 |
is( Koha::Patrons->search_patrons_to_update({from=>$c_categorycode})->count,3,'Three patrons in child category'); |
171 |
is( Koha::Patrons->search_patrons_to_update({from=>$c_categorycode,au=>1})->count,1,'One under age patron in child category'); |
172 |
is( Koha::Patrons->search_patrons_to_update({from=>$c_categorycode,au=>1})->next->borrowernumber,$child1->{borrowernumber},'Under age patron in child category is expected one'); |
173 |
is( Koha::Patrons->search_patrons_to_update({from=>$c_categorycode,ao=>1})->count,1,'One over age patron in child category'); |
174 |
is( Koha::Patrons->search_patrons_to_update({from=>$c_categorycode,ao=>1})->next->borrowernumber,$child3->{borrowernumber},'Over age patron in child category is expected one'); |
175 |
is( Koha::Patrons->search_patrons_to_update({from=>$a_categorycode,search_params=>{branchcode=>$branchcode2}})->count,1,'One patron in branch 2'); |
176 |
is( Koha::Patrons->search_patrons_to_update({from=>$a_categorycode,search_params=>{branchcode=>$branchcode2}})->next->borrowernumber,$adult2->{borrowernumber},'Adult patron in branch 2 is expected one'); |
177 |
is( Koha::Patrons->search_patrons_to_update({from=>$a_categorycode,fine_min=>5})->count,1,'One patron with fines over $5'); |
178 |
is( Koha::Patrons->search_patrons_to_update({from=>$a_categorycode,fine_min=>5})->next->borrowernumber,$adult2->{borrowernumber},'One patron with fines over $5 is expected one'); |
179 |
is( Koha::Patrons->search_patrons_to_update({from=>$a_categorycode,fine_max=>5})->count,1,'One patron with fines under $5'); |
180 |
is( Koha::Patrons->search_patrons_to_update({from=>$a_categorycode,fine_max=>5})->next->borrowernumber,$adult1->{borrowernumber},'One patron with fines under $5 is expected one'); |
181 |
|
182 |
is( Koha::Patrons->search_patrons_to_update({from=>$a_categorycode,search_params=>{dateenrolled=>{'<'=>'2018-01-01'}}})->count,1,'One adult patron enrolled before date'); |
183 |
is( Koha::Patrons->search_patrons_to_update({from=>$a_categorycode,search_params=>{dateenrolled=>{'<'=>'2018-01-01'}}})->next->borrowernumber,$adult2->{borrowernumber},'One adult patron enrolled before date is expected one'); |
184 |
is( Koha::Patrons->search_patrons_to_update({from=>$a_categorycode,search_params=>{dateenrolled=>{'>'=>'2017-01-01'}}})->count,1,'One adult patron enrolled after date'); |
185 |
is( Koha::Patrons->search_patrons_to_update({from=>$a_categorycode,search_params=>{dateenrolled=>{'>'=>'2017-01-01'}}})->next->borrowernumber,$adult1->{borrowernumber},'One adult patron enrolled after date is expected one'); |
186 |
is( Koha::Patrons->search_patrons_to_update({from=>$a_categorycode,search_params=>{'sort1'=>'quack'}})->count,1,'One adult patron has a quack'); |
187 |
is( Koha::Patrons->search_patrons_to_update({from=>$a_categorycode,search_params=>{'sort1'=>'quack'}})->next->borrowernumber,$adult1->{borrowernumber},'One adult patron with a quack is expected one'); |
188 |
|
189 |
is( Koha::Patrons->find($adult1->{borrowernumber})->guarantees->count,3,'Guarantor has 3 guarantees'); |
190 |
is( Koha::Patrons->search_patrons_to_update({from=>$c_categorycode,au=>1})->update_category({to=>$a_categorycode}),1,'One child patron updated to adult category'); |
191 |
is( Koha::Patrons->find($adult1->{borrowernumber})->guarantees->count,2,'Guarantee was removed when made adult'); |
192 |
|
193 |
is( Koha::Patrons->find($inst->{borrowernumber})->guarantees->count,1,'Guarantor has 1 guarantees'); |
194 |
is( Koha::Patrons->search_patrons_to_update({from=>$p_categorycode})->update_category({to=>$a_categorycode}),1,'One professional patron updated to adult category'); |
195 |
is( Koha::Patrons->find($inst->{borrowernumber})->guarantees->count,0,'Guarantee was removed when made adult'); |
196 |
|
197 |
}; |
198 |
|
199 |
|
200 |
|
107 |
$schema->storage->txn_rollback(); |
201 |
$schema->storage->txn_rollback(); |
108 |
|
202 |
|
109 |
- |
|
|