3 # Copyright 2014 ByWater Solutions
4 # Copyright 2016 Koha Development Team
6 # This file is part of Koha.
8 # Koha is free software; you can redistribute it and/or modify it under the
9 # terms of the GNU General Public License as published by the Free Software
10 # Foundation; either version 3 of the License, or (at your option) any later
13 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
14 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
15 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
17 # You should have received a copy of the GNU General Public License along
18 # with Koha; if not, write to the Free Software Foundation, Inc.,
19 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
28 use Koha::ArticleRequests;
29 use Koha::ArticleRequest::Status;
31 use Koha::Exceptions::Patron;
33 use base qw(Koha::Objects);
37 Koha::Patron - Koha Patron Object class
47 my $patrons = Koha::Patrons->search_limit( $params, $attributes );
49 Returns all the patrons the logged in user is allowed to see
54 my ( $self, $params, $attributes ) = @_;
56 my $userenv = C4::Context->userenv;
57 my @restricted_branchcodes;
58 if ( $userenv and $userenv->{number} ) {
59 my $logged_in_user = Koha::Patrons->find( $userenv->{number} );
60 @restricted_branchcodes = $logged_in_user->libraries_where_can_see_patrons;
62 $params->{'me.branchcode'} = { -in => \@restricted_branchcodes } if @restricted_branchcodes;
63 return $self->search( $params, $attributes );
66 =head3 search_housebound_choosers
68 Returns all Patrons which are Housebound choosers.
72 sub search_housebound_choosers {
74 my $cho = $self->_resultset
75 ->search_related('housebound_role', {
76 housebound_chooser => 1,
77 })->search_related('borrowernumber');
78 return Koha::Patrons->_new_from_dbic($cho);
81 =head3 search_housebound_deliverers
83 Returns all Patrons which are Housebound deliverers.
87 sub search_housebound_deliverers {
89 my $del = $self->_resultset
90 ->search_related('housebound_role', {
91 housebound_deliverer => 1,
92 })->search_related('borrowernumber');
93 return Koha::Patrons->_new_from_dbic($del);
96 =head3 search_upcoming_membership_expires
98 my $patrons = Koha::Patrons->search_upcoming_membership_expires();
100 The 'before' and 'after' represent the number of days before/after the date
101 that is set by the preference MembershipExpiryDaysNotice.
102 If the pref is 14, before 2 and after 3 then you will get all expires
107 sub search_upcoming_membership_expires {
108 my ( $self, $params ) = @_;
109 my $before = $params->{before} || 0;
110 my $after = $params->{after} || 0;
111 delete $params->{before};
112 delete $params->{after};
114 my $days = C4::Context->preference("MembershipExpiryDaysNotice") || 0;
115 my $date_before = dt_from_string->add( days => $days - $before );
116 my $date_after = dt_from_string->add( days => $days + $after );
117 my $dtf = Koha::Database->new->schema->storage->datetime_parser;
119 $params->{dateexpiry} = {
120 ">=" => $dtf->format_date( $date_before ),
121 "<=" => $dtf->format_date( $date_after ),
123 return $self->SUPER::search(
124 $params, { join => ['branchcode', 'categorycode'] }
130 Returns a Koha::Patron object for this borrower's guarantor
137 return Koha::Patrons->find( $self->guarantorid() );
140 =head3 search_patrons_to_anonymise
142 my $patrons = Koha::Patrons->search_patrons_to_anonymise( { before => $older_than_date, [ library => $library ] } );
144 This method returns all patrons who has an issue history older than a given date.
148 sub search_patrons_to_anonymise {
149 my ( $class, $params ) = @_;
150 my $older_than_date = $params->{before};
151 my $library = $params->{library};
152 $older_than_date = $older_than_date ? dt_from_string($older_than_date) : dt_from_string;
154 ( C4::Context->preference('IndependentBranches') && C4::Context->userenv && !C4::Context->IsSuperLibrarian() && C4::Context->userenv->{branch} )
155 ? C4::Context->userenv->{branch}
157 my $anonymous_patron = C4::Context->preference('AnonymousPatron') || undef;
159 my $dtf = Koha::Database->new->schema->storage->datetime_parser;
160 my $rs = $class->_resultset->search(
161 { returndate => { '<' => $dtf->format_datetime($older_than_date), },
162 'old_issues.borrowernumber' => { 'not' => undef },
163 privacy => { '<>' => 0 }, # Keep forever
164 ( $library ? ( 'old_issues.branchcode' => $library ) : () ),
165 ( $anonymous_patron ? ( 'old_issues.borrowernumber' => { '!=' => $anonymous_patron } ) : () ),
167 { join => ["old_issues"],
171 return Koha::Patrons->_new_from_dbic($rs);
174 =head3 anonymise_issue_history
176 Koha::Patrons->search->anonymise_issue_history( { [ before => $older_than_date ] } );
178 Anonymise issue history (old_issues) for all patrons older than the given date (optional).
179 To make sure all the conditions are met, the caller has the responsibility to
180 call search_patrons_to_anonymise to filter the Koha::Patrons set
184 sub anonymise_issue_history {
185 my ( $self, $params ) = @_;
187 my $older_than_date = $params->{before};
189 $older_than_date = dt_from_string $older_than_date if $older_than_date;
191 # The default of 0 does not work due to foreign key constraints
192 # The anonymisation should not fail quietly if AnonymousPatron is not a valid entry
193 # Set it to undef (NULL)
194 my $dtf = Koha::Database->new->schema->storage->datetime_parser;
196 while ( my $patron = $self->next ) {
197 my $old_issues_to_anonymise = $patron->old_checkouts->search(
202 { '<' => $dtf->format_datetime($older_than_date) } )
207 my $anonymous_patron = C4::Context->preference('AnonymousPatron') || undef;
208 $nb_rows += $old_issues_to_anonymise->update( { 'old_issues.borrowernumber' => $anonymous_patron } );
215 Koha::Patrons->search({ some filters here })->delete({ move => 1 });
217 Delete passed set of patron objects.
218 Wrapper for Koha::Patron->delete. (We do not want to bypass Koha::Patron
219 and let DBIx do the job without further housekeeping.)
220 Includes a move to deletedborrowers if move flag set.
222 Just like DBIx, the delete will only succeed when all entries could be
223 deleted. Returns true or throws an exception.
228 my ( $self, $params ) = @_;
230 $self->_resultset->result_source->schema->txn_do( sub {
231 my ( $set, $params ) = @_;
232 my $count = $set->count;
233 while( my $patron = $set->next ) {
234 $patron->move_to_deleted if $params->{move};
235 $patron->delete == 1 || Koha::Exceptions::Patron::FailedDelete->throw;
239 return $patrons_deleted;
242 =head3 search_unsubscribed
244 Koha::Patrons->search_unsubscribed;
246 Returns a set of Koha patron objects for patrons that recently
247 unsubscribed and are not locked (candidates for locking).
248 Depends on UnsubscribeReflectionDelay.
252 sub search_unsubscribed {
255 my $delay = C4::Context->preference('UnsubscribeReflectionDelay');
256 if( !defined($delay) || $delay eq q{} ) {
258 return $class->search({ borrowernumber => undef });
260 my $parser = Koha::Database->new->schema->storage->datetime_parser;
261 my $dt = dt_from_string()->subtract( days => $delay );
262 my $str = $parser->format_datetime($dt);
263 my $fails = C4::Context->preference('FailedLoginAttempts') || 0;
264 my $cond = [ undef, 0, 1..$fails-1 ]; # NULL, 0, 1..fails-1 (if fails>0)
265 return $class->search(
267 'patron_consents.refused_on' => { '<=' => $str },
268 'login_attempts' => $cond,
270 { join => 'patron_consents' },
274 =head3 search_anonymize_candidates
276 Koha::Patrons->search_anonymize_candidates({ locked => 1 });
278 Returns a set of Koha patron objects for patrons whose account is expired
279 and locked (if parameter set). These are candidates for anonymizing.
280 Depends on PatronAnonymizeDelay.
284 sub search_anonymize_candidates {
285 my ( $class, $params ) = @_;
287 my $delay = C4::Context->preference('PatronAnonymizeDelay');
288 if( !defined($delay) || $delay eq q{} ) {
290 return $class->search({ borrowernumber => undef });
293 my $parser = Koha::Database->new->schema->storage->datetime_parser;
294 my $dt = dt_from_string()->subtract( days => $delay );
295 my $str = $parser->format_datetime($dt);
296 $cond->{dateexpiry} = { '<=' => $str };
297 $cond->{anonymized} = 0; # not yet done
298 if( $params->{locked} ) {
299 my $fails = C4::Context->preference('FailedLoginAttempts') || 0;
300 $cond->{login_attempts} = [ -and => { '!=' => undef }, { -not_in => [0, 1..$fails-1 ] } ]; # -not_in does not like undef
302 return $class->search( $cond );
305 =head3 search_anonymized
307 Koha::Patrons->search_anonymized;
309 Returns a set of Koha patron objects for patron accounts that have been
310 anonymized before and could be removed.
311 Depends on PatronRemovalDelay.
315 sub search_anonymized {
318 my $delay = C4::Context->preference('PatronRemovalDelay');
319 if( !defined($delay) || $delay eq q{} ) {
321 return $class->search({ borrowernumber => undef });
324 my $parser = Koha::Database->new->schema->storage->datetime_parser;
325 my $dt = dt_from_string()->subtract( days => $delay );
326 my $str = $parser->format_datetime($dt);
327 $cond->{dateexpiry} = { '<=' => $str };
328 $cond->{anonymized} = 1;
329 return $class->search( $cond );
334 Koha::Patrons->search({ some filters })->lock({ expire => 1, remove => 1 })
336 Lock the passed set of patron objects. Optionally expire and remove holds.
337 Wrapper around Koha::Patron->lock.
342 my ( $self, $params ) = @_;
343 my $count = $self->count;
344 while( my $patron = $self->next ) {
345 $patron->lock($params);
351 Koha::Patrons->search({ some filters })->anonymize();
353 Anonymize passed set of patron objects.
354 Wrapper around Koha::Patron->anonymize.
360 my $count = $self->count;
361 while( my $patron = $self->next ) {
375 return 'Koha::Patron';
380 Kyle M Hall <kyle@bywatersolutions.com>