|
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 |
- |
|
|