3 # Copyright ByWater Solutions 2014
4 # Copyright PTFS Europe 2016
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.
24 use List::MoreUtils qw( any uniq );
25 use JSON qw( to_json );
26 use Text::Unaccent qw( unac_string );
33 use Koha::Club::Enrollments;
36 use Koha::Exceptions::Password;
38 use Koha::Old::Checkouts;
39 use Koha::Patron::Attributes;
40 use Koha::Patron::Categories;
41 use Koha::Patron::HouseboundProfile;
42 use Koha::Patron::HouseboundRole;
43 use Koha::Patron::Images;
44 use Koha::Patron::Relationships;
47 use Koha::Subscription::Routinglists;
49 use Koha::Virtualshelves;
51 use base qw(Koha::Object);
53 use constant ADMINISTRATIVE_LOCKOUT => -1;
55 our $RESULTSET_PATRON_ID_MAPPING = {
56 Accountline => 'borrowernumber',
57 Aqbasketuser => 'borrowernumber',
58 Aqbudget => 'budget_owner_id',
59 Aqbudgetborrower => 'borrowernumber',
60 ArticleRequest => 'borrowernumber',
61 BorrowerAttribute => 'borrowernumber',
62 BorrowerDebarment => 'borrowernumber',
63 BorrowerFile => 'borrowernumber',
64 BorrowerModification => 'borrowernumber',
65 ClubEnrollment => 'borrowernumber',
66 Issue => 'borrowernumber',
67 ItemsLastBorrower => 'borrowernumber',
68 Linktracker => 'borrowernumber',
69 Message => 'borrowernumber',
70 MessageQueue => 'borrowernumber',
71 OldIssue => 'borrowernumber',
72 OldReserve => 'borrowernumber',
73 Rating => 'borrowernumber',
74 Reserve => 'borrowernumber',
75 Review => 'borrowernumber',
76 SearchHistory => 'userid',
77 Statistic => 'borrowernumber',
78 Suggestion => 'suggestedby',
79 TagAll => 'borrowernumber',
80 Virtualshelfcontent => 'borrowernumber',
81 Virtualshelfshare => 'borrowernumber',
82 Virtualshelve => 'owner',
87 Koha::Patron - Koha Patron Object class
98 my ( $class, $params ) = @_;
100 return $class->SUPER::new($params);
103 =head3 fixup_cardnumber
105 Autogenerate next cardnumber from highest value found in database
109 sub fixup_cardnumber {
111 my $max = Koha::Patrons->search({
112 cardnumber => {-regexp => '^-?[0-9]+$'}
114 select => \'CAST(cardnumber AS SIGNED)',
115 as => ['cast_cardnumber']
116 })->_resultset->get_column('cast_cardnumber')->max;
117 $self->cardnumber(($max || 0) +1);
120 =head3 trim_whitespace
122 trim whitespace from data which has some non-whitespace in it.
123 Could be moved to Koha::Object if need to be reused
127 sub trim_whitespaces {
130 my $schema = Koha::Database->new->schema;
131 my @columns = $schema->source($self->_type)->columns;
133 for my $column( @columns ) {
134 my $value = $self->$column;
135 if ( defined $value ) {
136 $value =~ s/^\s*|\s*$//g;
137 $self->$column($value);
143 =head3 plain_text_password
145 $patron->plain_text_password( $password );
147 stores a copy of the unencrypted password in the object
148 for use in code before encrypting for db
152 sub plain_text_password {
153 my ( $self, $password ) = @_;
155 $self->{_plain_text_password} = $password;
158 return $self->{_plain_text_password}
159 if $self->{_plain_text_password};
166 Patron specific store method to cleanup record
167 and do other necessary things before saving
175 $self->_result->result_source->schema->txn_do(
178 C4::Context->preference("autoMemberNum")
179 and ( not defined $self->cardnumber
180 or $self->cardnumber eq '' )
183 # Warning: The caller is responsible for locking the members table in write
184 # mode, to avoid database corruption.
185 # We are in a transaction but the table is not locked
186 $self->fixup_cardnumber;
189 unless( $self->category->in_storage ) {
190 Koha::Exceptions::Object::FKConstraint->throw(
191 broken_fk => 'categorycode',
192 value => $self->categorycode,
196 $self->trim_whitespaces;
198 # Set surname to uppercase if uppercasesurname is true
199 $self->surname( uc($self->surname) )
200 if C4::Context->preference("uppercasesurnames");
202 unless ( $self->in_storage ) { #AddMember
204 # Generate a valid userid/login if needed
205 $self->generate_userid
206 if not $self->userid or not $self->has_valid_userid;
208 # Add expiration date if it isn't already there
209 unless ( $self->dateexpiry ) {
210 $self->dateexpiry( $self->category->get_expiry_date );
213 # Add enrollment date if it isn't already there
214 unless ( $self->dateenrolled ) {
215 $self->dateenrolled(dt_from_string);
218 # Set the privacy depending on the patron's category
219 my $default_privacy = $self->category->default_privacy || q{};
221 $default_privacy eq 'default' ? 1
222 : $default_privacy eq 'never' ? 2
223 : $default_privacy eq 'forever' ? 0
225 $self->privacy($default_privacy);
227 # Make a copy of the plain text password for later use
228 $self->plain_text_password( $self->password );
230 if ( C4::Context->preference('UseKohaPlugins') && C4::Context->config("enable_plugins") ) {
231 # Call any check_password plugins
232 my @plugins = Koha::Plugins->new()->GetPlugins({
233 method => 'check_password',
235 foreach my $plugin ( @plugins ) {
236 # This plugin hook will also be used by a plugin for the Norwegian national
237 # patron database. This is why we need to pass both the password and the
238 # borrowernumber to the plugin.
239 my $ret = $plugin->check_password(
241 password => $self->plain_text_password,
242 borrowernumber => $self->borrowernumber
245 if ( $ret->{'error'} == 1 ) {
246 Koha::Exceptions::Password::Plugin->throw();
251 # Create a disabled account if no password provided
252 $self->password( $self->password
253 ? Koha::AuthUtils::hash_password( $self->password )
256 $self->borrowernumber(undef);
258 $self = $self->SUPER::store;
260 $self->add_enrolment_fee_if_needed(0);
262 logaction( "MEMBERS", "CREATE", $self->borrowernumber, "" )
263 if C4::Context->preference("BorrowersLog");
267 my $self_from_storage = $self->get_from_storage;
268 # FIXME We should not deal with that here, callers have to do this job
269 # Moved from ModMember to prevent regressions
270 unless ( $self->userid ) {
271 my $stored_userid = $self_from_storage->userid;
272 $self->userid($stored_userid);
275 # Password must be updated using $self->set_password
276 $self->password($self_from_storage->password);
278 if ( $self->category->categorycode ne
279 $self_from_storage->category->categorycode )
281 # Add enrolement fee on category change if required
282 $self->add_enrolment_fee_if_needed(1)
283 if C4::Context->preference('FeeOnChangePatronCategory');
285 # Clean up guarantors on category change if required
286 $self->guarantor_relationships->delete
287 if ( $self->category->category_type ne 'C'
288 && $self->category->category_type ne 'P' );
293 if ( C4::Context->preference("BorrowersLog") ) {
295 my $from_storage = $self_from_storage->unblessed;
296 my $from_object = $self->unblessed;
297 my @skip_fields = (qw/lastseen updated_on/);
298 for my $key ( keys %{$from_storage} ) {
299 next if any { /$key/ } @skip_fields;
302 !defined( $from_storage->{$key} )
303 && defined( $from_object->{$key} )
305 || ( defined( $from_storage->{$key} )
306 && !defined( $from_object->{$key} ) )
308 defined( $from_storage->{$key} )
309 && defined( $from_object->{$key} )
310 && ( $from_storage->{$key} ne
311 $from_object->{$key} )
316 before => $from_storage->{$key},
317 after => $from_object->{$key}
322 if ( defined($info) ) {
326 $self->borrowernumber,
329 { utf8 => 1, pretty => 1, canonical => 1 }
336 $self = $self->SUPER::store;
347 Delete patron's holds, lists and finally the patron.
349 Lists owned by the borrower are deleted, but entries from the borrower to
350 other lists are kept.
358 $self->_result->result_source->schema->txn_do(
360 # Cancel Patron's holds
361 my $holds = $self->holds;
362 while( my $hold = $holds->next ){
366 # Delete all lists and all shares of this borrower
367 # Consistent with the approach Koha uses on deleting individual lists
368 # Note that entries in virtualshelfcontents added by this borrower to
369 # lists of others will be handled by a table constraint: the borrower
370 # is set to NULL in those entries.
372 # We could handle the above deletes via a constraint too.
373 # But a new BZ report 11889 has been opened to discuss another approach.
374 # Instead of deleting we could also disown lists (based on a pref).
375 # In that way we could save shared and public lists.
376 # The current table constraints support that idea now.
377 # This pref should then govern the results of other routines/methods such as
378 # Koha::Virtualshelf->new->delete too.
379 # FIXME Could be $patron->get_lists
380 $_->delete for Koha::Virtualshelves->search( { owner => $self->borrowernumber } );
382 $deleted = $self->SUPER::delete;
384 logaction( "MEMBERS", "DELETE", $self->borrowernumber, "" ) if C4::Context->preference("BorrowersLog");
393 my $patron_category = $patron->category
395 Return the patron category for this patron
401 return Koha::Patron::Category->_new_from_dbic( $self->_result->categorycode );
411 return scalar Koha::Patron::Images->find( $self->borrowernumber );
416 Returns a Koha::Library object representing the patron's home library.
422 return Koha::Library->_new_from_dbic($self->_result->branchcode);
425 =head3 guarantor_relationships
427 Returns Koha::Patron::Relationships object for this patron's guarantors
429 Returns the set of relationships for the patrons that are guarantors for this patron.
431 This is returned instead of a Koha::Patron object because the guarantor
432 may not exist as a patron in Koha. If this is true, the guarantors name
433 exists in the Koha::Patron::Relationship object and will have no guarantor_id.
437 sub guarantor_relationships {
440 return Koha::Patron::Relationships->search( { guarantee_id => $self->id } );
443 =head3 guarantee_relationships
445 Returns Koha::Patron::Relationships object for this patron's guarantors
447 Returns the set of relationships for the patrons that are guarantees for this patron.
449 The method returns Koha::Patron::Relationship objects for the sake
450 of consistency with the guantors method.
451 A guarantee by definition must exist as a patron in Koha.
455 sub guarantee_relationships {
458 return Koha::Patron::Relationships->search(
459 { guarantor_id => $self->id },
461 prefetch => 'guarantee',
462 order_by => { -asc => [ 'guarantee.surname', 'guarantee.firstname' ] },
467 =head3 housebound_profile
469 Returns the HouseboundProfile associated with this patron.
473 sub housebound_profile {
475 my $profile = $self->_result->housebound_profile;
476 return Koha::Patron::HouseboundProfile->_new_from_dbic($profile)
481 =head3 housebound_role
483 Returns the HouseboundRole associated with this patron.
487 sub housebound_role {
490 my $role = $self->_result->housebound_role;
491 return Koha::Patron::HouseboundRole->_new_from_dbic($role) if ( $role );
497 Returns the siblings of this patron.
504 my @guarantors = $self->guarantor_relationships()->guarantors();
506 return unless @guarantors;
509 map { $_->guarantee_relationships()->guarantees() } @guarantors;
511 return unless @siblings;
515 grep { !$seen{ $_->id }++ && ( $_->id != $self->id ) } @siblings;
517 return wantarray ? @siblings : Koha::Patrons->search( { borrowernumber => { -in => [ map { $_->id } @siblings ] } } );
522 my $patron = Koha::Patrons->find($id);
523 $patron->merge_with( \@patron_ids );
525 This subroutine merges a list of patrons into the patron record. This is accomplished by finding
526 all related patron ids for the patrons to be merged in other tables and changing the ids to be that
527 of the keeper patron.
532 my ( $self, $patron_ids ) = @_;
534 my @patron_ids = @{ $patron_ids };
536 # Ensure the keeper isn't in the list of patrons to merge
537 @patron_ids = grep { $_ ne $self->id } @patron_ids;
539 my $schema = Koha::Database->new()->schema();
543 $self->_result->result_source->schema->txn_do( sub {
544 foreach my $patron_id (@patron_ids) {
545 my $patron = Koha::Patrons->find( $patron_id );
549 # Unbless for safety, the patron will end up being deleted
550 $results->{merged}->{$patron_id}->{patron} = $patron->unblessed;
552 while (my ($r, $field) = each(%$RESULTSET_PATRON_ID_MAPPING)) {
553 my $rs = $schema->resultset($r)->search({ $field => $patron_id });
554 $results->{merged}->{ $patron_id }->{updated}->{$r} = $rs->count();
555 $rs->update({ $field => $self->id });
558 $patron->move_to_deleted();
568 =head3 wants_check_for_previous_checkout
570 $wants_check = $patron->wants_check_for_previous_checkout;
572 Return 1 if Koha needs to perform PrevIssue checking, else 0.
576 sub wants_check_for_previous_checkout {
578 my $syspref = C4::Context->preference("checkPrevCheckout");
581 ## Hard syspref trumps all
582 return 1 if ($syspref eq 'hardyes');
583 return 0 if ($syspref eq 'hardno');
584 ## Now, patron pref trumps all
585 return 1 if ($self->checkprevcheckout eq 'yes');
586 return 0 if ($self->checkprevcheckout eq 'no');
588 # More complex: patron inherits -> determine category preference
589 my $checkPrevCheckoutByCat = $self->category->checkprevcheckout;
590 return 1 if ($checkPrevCheckoutByCat eq 'yes');
591 return 0 if ($checkPrevCheckoutByCat eq 'no');
593 # Finally: category preference is inherit, default to 0
594 if ($syspref eq 'softyes') {
601 =head3 do_check_for_previous_checkout
603 $do_check = $patron->do_check_for_previous_checkout($item);
605 Return 1 if the bib associated with $ITEM has previously been checked out to
606 $PATRON, 0 otherwise.
610 sub do_check_for_previous_checkout {
611 my ( $self, $item ) = @_;
614 my $biblio = Koha::Biblios->find( $item->{biblionumber} );
615 if ( $biblio->is_serial ) {
616 push @item_nos, $item->{itemnumber};
618 # Get all itemnumbers for given bibliographic record.
619 @item_nos = $biblio->items->get_column( 'itemnumber' );
622 # Create (old)issues search criteria
624 borrowernumber => $self->borrowernumber,
625 itemnumber => \@item_nos,
628 # Check current issues table
629 my $issues = Koha::Checkouts->search($criteria);
630 return 1 if $issues->count; # 0 || N
632 # Check old issues table
633 my $old_issues = Koha::Old::Checkouts->search($criteria);
634 return $old_issues->count; # 0 || N
639 my $debarment_expiration = $patron->is_debarred;
641 Returns the date a patron debarment will expire, or undef if the patron is not
649 return unless $self->debarred;
650 return $self->debarred
651 if $self->debarred =~ '^9999'
652 or dt_from_string( $self->debarred ) > dt_from_string;
658 my $is_expired = $patron->is_expired;
660 Returns 1 if the patron is expired or 0;
666 return 0 unless $self->dateexpiry;
667 return 0 if $self->dateexpiry =~ '^9999';
668 return 1 if dt_from_string( $self->dateexpiry ) < dt_from_string->truncate( to => 'day' );
672 =head3 is_going_to_expire
674 my $is_going_to_expire = $patron->is_going_to_expire;
676 Returns 1 if the patron is going to expired, depending on the NotifyBorrowerDeparture pref or 0
680 sub is_going_to_expire {
683 my $delay = C4::Context->preference('NotifyBorrowerDeparture') || 0;
685 return 0 unless $delay;
686 return 0 unless $self->dateexpiry;
687 return 0 if $self->dateexpiry =~ '^9999';
688 return 1 if dt_from_string( $self->dateexpiry, undef, 'floating' )->subtract( days => $delay ) < dt_from_string(undef, undef, 'floating')->truncate( to => 'day' );
694 $patron->set_password({ password => $plain_text_password [, skip_validation => 1 ] });
696 Set the patron's password.
700 The passed string is validated against the current password enforcement policy.
701 Validation can be skipped by passing the I<skip_validation> parameter.
703 Exceptions are thrown if the password is not good enough.
707 =item Koha::Exceptions::Password::TooShort
709 =item Koha::Exceptions::Password::WhitespaceCharacters
711 =item Koha::Exceptions::Password::TooWeak
713 =item Koha::Exceptions::Password::Plugin (if a "check password" plugin is enabled)
720 my ( $self, $args ) = @_;
722 my $password = $args->{password};
724 unless ( $args->{skip_validation} ) {
725 my ( $is_valid, $error ) = Koha::AuthUtils::is_password_valid( $password );
728 if ( $error eq 'too_short' ) {
729 my $min_length = C4::Context->preference('minPasswordLength');
730 $min_length = 3 if not $min_length or $min_length < 3;
732 my $password_length = length($password);
733 Koha::Exceptions::Password::TooShort->throw(
734 length => $password_length, min_length => $min_length );
736 elsif ( $error eq 'has_whitespaces' ) {
737 Koha::Exceptions::Password::WhitespaceCharacters->throw();
739 elsif ( $error eq 'too_weak' ) {
740 Koha::Exceptions::Password::TooWeak->throw();
745 if ( C4::Context->preference('UseKohaPlugins') && C4::Context->config("enable_plugins") ) {
746 # Call any check_password plugins
747 my @plugins = Koha::Plugins->new()->GetPlugins({
748 method => 'check_password',
750 foreach my $plugin ( @plugins ) {
751 # This plugin hook will also be used by a plugin for the Norwegian national
752 # patron database. This is why we need to pass both the password and the
753 # borrowernumber to the plugin.
754 my $ret = $plugin->check_password(
756 password => $password,
757 borrowernumber => $self->borrowernumber
760 # This plugin hook will also be used by a plugin for the Norwegian national
761 # patron database. This is why we need to call the actual plugins and then
762 # check skip_validation afterwards.
763 if ( $ret->{'error'} == 1 && !$args->{skip_validation} ) {
764 Koha::Exceptions::Password::Plugin->throw();
769 my $digest = Koha::AuthUtils::hash_password($password);
771 { password => $digest,
776 logaction( "MEMBERS", "CHANGE PASS", $self->borrowernumber, "" )
777 if C4::Context->preference("BorrowersLog");
785 my $new_expiry_date = $patron->renew_account
787 Extending the subscription to the expiry date.
794 if ( C4::Context->preference('BorrowerRenewalPeriodBase') eq 'combination' ) {
795 $date = ( dt_from_string gt dt_from_string( $self->dateexpiry ) ) ? dt_from_string : dt_from_string( $self->dateexpiry );
798 C4::Context->preference('BorrowerRenewalPeriodBase') eq 'dateexpiry'
799 ? dt_from_string( $self->dateexpiry )
802 my $expiry_date = $self->category->get_expiry_date($date);
804 $self->dateexpiry($expiry_date);
805 $self->date_renewed( dt_from_string() );
808 $self->add_enrolment_fee_if_needed(1);
810 logaction( "MEMBERS", "RENEW", $self->borrowernumber, "Membership renewed" ) if C4::Context->preference("BorrowersLog");
811 return dt_from_string( $expiry_date )->truncate( to => 'day' );
816 my $has_overdues = $patron->has_overdues;
818 Returns the number of patron's overdues
824 my $dtf = Koha::Database->new->schema->storage->datetime_parser;
825 return $self->_result->issues->search({ date_due => { '<' => $dtf->format_datetime( dt_from_string() ) } })->count;
830 $patron->track_login;
831 $patron->track_login({ force => 1 });
833 Tracks a (successful) login attempt.
834 The preference TrackLastPatronActivity must be enabled. Or you
835 should pass the force parameter.
840 my ( $self, $params ) = @_;
843 !C4::Context->preference('TrackLastPatronActivity');
844 $self->lastseen( dt_from_string() )->store;
847 =head3 move_to_deleted
849 my $is_moved = $patron->move_to_deleted;
851 Move a patron to the deletedborrowers table.
852 This can be done before deleting a patron, to make sure the data are not completely deleted.
856 sub move_to_deleted {
858 my $patron_infos = $self->unblessed;
859 delete $patron_infos->{updated_on}; #This ensures the updated_on date in deletedborrowers will be set to the current timestamp
860 return Koha::Database->new->schema->resultset('Deletedborrower')->create($patron_infos);
863 =head3 article_requests
865 my @requests = $borrower->article_requests();
866 my $requests = $borrower->article_requests();
868 Returns either a list of ArticleRequests objects,
869 or an ArtitleRequests object, depending on the
874 sub article_requests {
877 $self->{_article_requests} ||= Koha::ArticleRequests->search({ borrowernumber => $self->borrowernumber() });
879 return $self->{_article_requests};
882 =head3 article_requests_current
884 my @requests = $patron->article_requests_current
886 Returns the article requests associated with this patron that are incomplete
890 sub article_requests_current {
893 $self->{_article_requests_current} ||= Koha::ArticleRequests->search(
895 borrowernumber => $self->id(),
897 { status => Koha::ArticleRequest::Status::Pending },
898 { status => Koha::ArticleRequest::Status::Processing }
903 return $self->{_article_requests_current};
906 =head3 article_requests_finished
908 my @requests = $biblio->article_requests_finished
910 Returns the article requests associated with this patron that are completed
914 sub article_requests_finished {
915 my ( $self, $borrower ) = @_;
917 $self->{_article_requests_finished} ||= Koha::ArticleRequests->search(
919 borrowernumber => $self->id(),
921 { status => Koha::ArticleRequest::Status::Completed },
922 { status => Koha::ArticleRequest::Status::Canceled }
927 return $self->{_article_requests_finished};
930 =head3 add_enrolment_fee_if_needed
932 my $enrolment_fee = $patron->add_enrolment_fee_if_needed($renewal);
934 Add enrolment fee for a patron if needed.
936 $renewal - boolean denoting whether this is an account renewal or not
940 sub add_enrolment_fee_if_needed {
941 my ($self, $renewal) = @_;
942 my $enrolment_fee = $self->category->enrolmentfee;
943 if ( $enrolment_fee && $enrolment_fee > 0 ) {
944 my $type = $renewal ? 'ACCOUNT_RENEW' : 'ACCOUNT';
945 $self->account->add_debit(
947 amount => $enrolment_fee,
948 user_id => C4::Context->userenv ? C4::Context->userenv->{'number'} : undef,
949 interface => C4::Context->interface,
950 library_id => C4::Context->userenv ? C4::Context->userenv->{'branch'} : undef,
955 return $enrolment_fee || 0;
960 my $checkouts = $patron->checkouts
966 my $checkouts = $self->_result->issues;
967 return Koha::Checkouts->_new_from_dbic( $checkouts );
970 =head3 pending_checkouts
972 my $pending_checkouts = $patron->pending_checkouts
974 This method will return the same as $self->checkouts, but with a prefetch on
975 items, biblio and biblioitems.
977 It has been introduced to replaced the C4::Members::GetPendingIssues subroutine
979 It should not be used directly, prefer to access fields you need instead of
980 retrieving all these fields in one go.
984 sub pending_checkouts {
986 my $checkouts = $self->_result->issues->search(
990 { -desc => 'me.timestamp' },
991 { -desc => 'issuedate' },
992 { -desc => 'issue_id' }, # Sort by issue_id should be enough
994 prefetch => { item => { biblio => 'biblioitems' } },
997 return Koha::Checkouts->_new_from_dbic( $checkouts );
1000 =head3 old_checkouts
1002 my $old_checkouts = $patron->old_checkouts
1008 my $old_checkouts = $self->_result->old_issues;
1009 return Koha::Old::Checkouts->_new_from_dbic( $old_checkouts );
1014 my $overdue_items = $patron->get_overdues
1016 Return the overdue items
1022 my $dtf = Koha::Database->new->schema->storage->datetime_parser;
1023 return $self->checkouts->search(
1025 'me.date_due' => { '<' => $dtf->format_datetime(dt_from_string) },
1028 prefetch => { item => { biblio => 'biblioitems' } },
1033 =head3 get_routing_lists
1035 my @routinglists = $patron->get_routing_lists
1037 Returns the routing lists a patron is subscribed to.
1041 sub get_routing_lists {
1043 my $routing_list_rs = $self->_result->subscriptionroutinglists;
1044 return Koha::Subscription::Routinglists->_new_from_dbic($routing_list_rs);
1049 my $age = $patron->get_age
1051 Return the age of the patron
1057 my $today_str = dt_from_string->strftime("%Y-%m-%d");
1058 return unless $self->dateofbirth;
1059 my $dob_str = dt_from_string( $self->dateofbirth )->strftime("%Y-%m-%d");
1061 my ( $dob_y, $dob_m, $dob_d ) = split /-/, $dob_str;
1062 my ( $today_y, $today_m, $today_d ) = split /-/, $today_str;
1064 my $age = $today_y - $dob_y;
1065 if ( $dob_m . $dob_d > $today_m . $today_d ) {
1074 my $is_valid = $patron->is_valid_age
1076 Return 1 if patron's age is between allowed limits, returns 0 if it's not.
1082 my $age = $self->get_age;
1084 my $patroncategory = $self->category;
1085 my ($low,$high) = ($patroncategory->dateofbirthrequired, $patroncategory->upperagelimit);
1087 return (defined($age) && (($high && ($age > $high)) or ($age < $low))) ? 0 : 1;
1092 my $account = $patron->account
1098 return Koha::Account->new( { patron_id => $self->borrowernumber } );
1103 my $holds = $patron->holds
1105 Return all the holds placed by this patron
1111 my $holds_rs = $self->_result->reserves->search( {}, { order_by => 'reservedate' } );
1112 return Koha::Holds->_new_from_dbic($holds_rs);
1117 my $old_holds = $patron->old_holds
1119 Return all the historical holds for this patron
1125 my $old_holds_rs = $self->_result->old_reserves->search( {}, { order_by => 'reservedate' } );
1126 return Koha::Old::Holds->_new_from_dbic($old_holds_rs);
1129 =head3 notice_email_address
1131 my $email = $patron->notice_email_address;
1133 Return the email address of patron used for notices.
1134 Returns the empty string if no email address.
1138 sub notice_email_address{
1141 my $which_address = C4::Context->preference("AutoEmailPrimaryAddress");
1142 # if syspref is set to 'first valid' (value == OFF), look up email address
1143 if ( $which_address eq 'OFF' ) {
1144 return $self->first_valid_email_address;
1147 return $self->$which_address || '';
1150 =head3 first_valid_email_address
1152 my $first_valid_email_address = $patron->first_valid_email_address
1154 Return the first valid email address for a patron.
1155 For now, the order is defined as email, emailpro, B_email.
1156 Returns the empty string if the borrower has no email addresses.
1160 sub first_valid_email_address {
1163 return $self->email() || $self->emailpro() || $self->B_email() || q{};
1166 =head3 get_club_enrollments
1170 sub get_club_enrollments {
1171 my ( $self, $return_scalar ) = @_;
1173 my $e = Koha::Club::Enrollments->search( { borrowernumber => $self->borrowernumber(), date_canceled => undef } );
1175 return $e if $return_scalar;
1177 return wantarray ? $e->as_list : $e;
1180 =head3 get_enrollable_clubs
1184 sub get_enrollable_clubs {
1185 my ( $self, $is_enrollable_from_opac, $return_scalar ) = @_;
1188 $params->{is_enrollable_from_opac} = $is_enrollable_from_opac
1189 if $is_enrollable_from_opac;
1190 $params->{is_email_required} = 0 unless $self->first_valid_email_address();
1192 $params->{borrower} = $self;
1194 my $e = Koha::Clubs->get_enrollable($params);
1196 return $e if $return_scalar;
1198 return wantarray ? $e->as_list : $e;
1201 =head3 account_locked
1203 my $is_locked = $patron->account_locked
1205 Return true if the patron has reached the maximum number of login attempts
1206 (see pref FailedLoginAttempts). If login_attempts is < 0, this is interpreted
1207 as an administrative lockout (independent of FailedLoginAttempts; see also
1208 Koha::Patron->lock).
1209 Otherwise return false.
1210 If the pref is not set (empty string, null or 0), the feature is considered as
1215 sub account_locked {
1217 my $FailedLoginAttempts = C4::Context->preference('FailedLoginAttempts');
1218 return 1 if $FailedLoginAttempts
1219 and $self->login_attempts
1220 and $self->login_attempts >= $FailedLoginAttempts;
1221 return 1 if ($self->login_attempts || 0) < 0; # administrative lockout
1225 =head3 can_see_patron_infos
1227 my $can_see = $patron->can_see_patron_infos( $patron );
1229 Return true if the patron (usually the logged in user) can see the patron's infos for a given patron
1233 sub can_see_patron_infos {
1234 my ( $self, $patron ) = @_;
1235 return unless $patron;
1236 return $self->can_see_patrons_from( $patron->library->branchcode );
1239 =head3 can_see_patrons_from
1241 my $can_see = $patron->can_see_patrons_from( $branchcode );
1243 Return true if the patron (usually the logged in user) can see the patron's infos from a given library
1247 sub can_see_patrons_from {
1248 my ( $self, $branchcode ) = @_;
1250 if ( $self->branchcode eq $branchcode ) {
1252 } elsif ( $self->has_permission( { borrowers => 'view_borrower_infos_from_any_libraries' } ) ) {
1254 } elsif ( my $library_groups = $self->library->library_groups ) {
1255 while ( my $library_group = $library_groups->next ) {
1256 if ( $library_group->parent->has_child( $branchcode ) ) {
1265 =head3 libraries_where_can_see_patrons
1267 my $libraries = $patron-libraries_where_can_see_patrons;
1269 Return the list of branchcodes(!) of libraries the patron is allowed to see other patron's infos.
1270 The branchcodes are arbitrarily returned sorted.
1271 We are supposing here that the object is related to the logged in patron (use of C4::Context::only_my_library)
1273 An empty array means no restriction, the patron can see patron's infos from any libraries.
1277 sub libraries_where_can_see_patrons {
1279 my $userenv = C4::Context->userenv;
1281 return () unless $userenv; # For tests, but userenv should be defined in tests...
1283 my @restricted_branchcodes;
1284 if (C4::Context::only_my_library) {
1285 push @restricted_branchcodes, $self->branchcode;
1289 $self->has_permission(
1290 { borrowers => 'view_borrower_infos_from_any_libraries' }
1294 my $library_groups = $self->library->library_groups({ ft_hide_patron_info => 1 });
1295 if ( $library_groups->count )
1297 while ( my $library_group = $library_groups->next ) {
1298 my $parent = $library_group->parent;
1299 if ( $parent->has_child( $self->branchcode ) ) {
1300 push @restricted_branchcodes, $parent->children->get_column('branchcode');
1305 @restricted_branchcodes = ( $self->branchcode ) unless @restricted_branchcodes;
1309 @restricted_branchcodes = grep { defined $_ } @restricted_branchcodes;
1310 @restricted_branchcodes = uniq(@restricted_branchcodes);
1311 @restricted_branchcodes = sort(@restricted_branchcodes);
1312 return @restricted_branchcodes;
1315 sub has_permission {
1316 my ( $self, $flagsrequired ) = @_;
1317 return unless $self->userid;
1318 # TODO code from haspermission needs to be moved here!
1319 return C4::Auth::haspermission( $self->userid, $flagsrequired );
1324 my $is_adult = $patron->is_adult
1326 Return true if the patron has a category with a type Adult (A) or Organization (I)
1332 return $self->category->category_type =~ /^(A|I)$/ ? 1 : 0;
1337 my $is_child = $patron->is_child
1339 Return true if the patron has a category with a type Child (C)
1345 return $self->category->category_type eq 'C' ? 1 : 0;
1348 =head3 has_valid_userid
1350 my $patron = Koha::Patrons->find(42);
1351 $patron->userid( $new_userid );
1352 my $has_a_valid_userid = $patron->has_valid_userid
1354 my $patron = Koha::Patron->new( $params );
1355 my $has_a_valid_userid = $patron->has_valid_userid
1357 Return true if the current userid of this patron is valid/unique, otherwise false.
1359 Note that this should be done in $self->store instead and raise an exception if needed.
1363 sub has_valid_userid {
1366 return 0 unless $self->userid;
1368 return 0 if ( $self->userid eq C4::Context->config('user') ); # DB user
1370 my $already_exists = Koha::Patrons->search(
1372 userid => $self->userid,
1375 ? ( borrowernumber => { '!=' => $self->borrowernumber } )
1380 return $already_exists ? 0 : 1;
1383 =head3 generate_userid
1385 my $patron = Koha::Patron->new( $params );
1386 $patron->generate_userid
1388 Generate a userid using the $surname and the $firstname (if there is a value in $firstname).
1390 Set a generated userid ($firstname.$surname if there is a $firstname, or $surname if there is no value in $firstname) plus offset (0 if the $userid is unique, or a higher numeric value if not unique).
1394 sub generate_userid {
1397 my $firstname = $self->firstname // q{};
1398 my $surname = $self->surname // q{};
1399 #The script will "do" the following code and increment the $offset until the generated userid is unique
1401 $firstname =~ s/[[:digit:][:space:][:blank:][:punct:][:cntrl:]]//g;
1402 $surname =~ s/[[:digit:][:space:][:blank:][:punct:][:cntrl:]]//g;
1403 my $userid = lc(($firstname)? "$firstname.$surname" : $surname);
1404 $userid = unac_string('utf-8',$userid);
1405 $userid .= $offset unless $offset == 0;
1406 $self->userid( $userid );
1408 } while (! $self->has_valid_userid );
1416 my $attributes = $patron->attributes
1418 Return object of Koha::Patron::Attributes type with all attributes set for this patron
1424 return Koha::Patron::Attributes->search({
1425 borrowernumber => $self->borrowernumber,
1426 branchcode => $self->branchcode,
1432 Koha::Patrons->find($id)->lock({ expire => 1, remove => 1 });
1434 Lock and optionally expire a patron account.
1435 Remove holds and article requests if remove flag set.
1436 In order to distinguish from locking by entering a wrong password, let's
1437 call this an administrative lockout.
1442 my ( $self, $params ) = @_;
1443 $self->login_attempts( ADMINISTRATIVE_LOCKOUT );
1444 if( $params->{expire} ) {
1445 $self->dateexpiry( dt_from_string->subtract(days => 1) );
1448 if( $params->{remove} ) {
1449 $self->holds->delete;
1450 $self->article_requests->delete;
1457 Koha::Patrons->find($id)->anonymize;
1459 Anonymize or clear borrower fields. Fields in BorrowerMandatoryField
1460 are randomized, other personal data is cleared too.
1461 Patrons with issues are skipped.
1467 if( $self->_result->issues->count ) {
1468 warn "Exiting anonymize: patron ".$self->borrowernumber." still has issues";
1471 # Mandatory fields come from the corresponding pref, but email fields
1472 # are removed since scrambled email addresses only generate errors
1473 my $mandatory = { map { (lc $_, 1); } grep { !/email/ }
1474 split /\s*\|\s*/, C4::Context->preference('BorrowerMandatoryField') };
1475 $mandatory->{userid} = 1; # needed since sub store does not clear field
1476 my @columns = $self->_result->result_source->columns;
1477 @columns = grep { !/borrowernumber|branchcode|categorycode|^date|password|flags|updated_on|lastseen|lang|login_attempts|anonymized/ } @columns;
1478 push @columns, 'dateofbirth'; # add this date back in
1479 foreach my $col (@columns) {
1480 $self->_anonymize_column($col, $mandatory->{lc $col} );
1482 $self->anonymized(1)->store;
1485 sub _anonymize_column {
1486 my ( $self, $col, $mandatory ) = @_;
1487 my $col_info = $self->_result->result_source->column_info($col);
1488 my $type = $col_info->{data_type};
1489 my $nullable = $col_info->{is_nullable};
1491 if( $type =~ /char|text/ ) {
1493 ? Koha::Token->new->generate({ pattern => '\w{10}' })
1497 } elsif( $type =~ /integer|int$|float|dec|double/ ) {
1498 $val = $nullable ? undef : 0;
1499 } elsif( $type =~ /date|time/ ) {
1500 $val = $nullable ? undef : dt_from_string;
1505 =head3 add_guarantor
1507 my @relationships = $patron->add_guarantor(
1509 borrowernumber => $borrowernumber,
1510 relationships => $relationship,
1514 Adds a new guarantor to a patron.
1519 my ( $self, $params ) = @_;
1521 my $guarantor_id = $params->{guarantor_id};
1522 my $relationship = $params->{relationship};
1524 return Koha::Patron::Relationship->new(
1526 guarantee_id => $self->id,
1527 guarantor_id => $guarantor_id,
1528 relationship => $relationship
1535 my $json = $patron->to_api;
1537 Overloaded method that returns a JSON representation of the Koha::Patron object,
1538 suitable for API output.
1545 my $json_patron = $self->SUPER::to_api;
1547 $json_patron->{restricted} = ( $self->is_debarred )
1549 : Mojo::JSON->false;
1551 return $json_patron;
1554 =head3 to_api_mapping
1556 This method returns the mapping for representing a Koha::Patron object
1561 sub to_api_mapping {
1563 borrowernotes => 'staff_notes',
1564 borrowernumber => 'patron_id',
1565 branchcode => 'library_id',
1566 categorycode => 'category_id',
1567 checkprevcheckout => 'check_previous_checkout',
1568 contactfirstname => undef, # Unused
1569 contactname => undef, # Unused
1570 contactnote => 'altaddress_notes',
1571 contacttitle => undef, # Unused
1572 dateenrolled => 'date_enrolled',
1573 dateexpiry => 'expiry_date',
1574 dateofbirth => 'date_of_birth',
1575 debarred => undef, # replaced by 'restricted'
1576 debarredcomment => undef, # calculated, API consumers will use /restrictions instead
1577 emailpro => 'secondary_email',
1578 flags => undef, # permissions manipulation handled in /permissions
1579 gonenoaddress => 'incorrect_address',
1580 guarantorid => 'guarantor_id',
1581 lastseen => 'last_seen',
1582 lost => 'patron_card_lost',
1583 opacnote => 'opac_notes',
1584 othernames => 'other_name',
1585 password => undef, # password manipulation handled in /password
1586 phonepro => 'secondary_phone',
1587 relationship => 'relationship_type',
1589 smsalertnumber => 'sms_number',
1590 sort1 => 'statistics_1',
1591 sort2 => 'statistics_2',
1592 streetnumber => 'street_number',
1593 streettype => 'street_type',
1594 zipcode => 'postal_code',
1595 B_address => 'altaddress_address',
1596 B_address2 => 'altaddress_address2',
1597 B_city => 'altaddress_city',
1598 B_country => 'altaddress_country',
1599 B_email => 'altaddress_email',
1600 B_phone => 'altaddress_phone',
1601 B_state => 'altaddress_state',
1602 B_streetnumber => 'altaddress_street_number',
1603 B_streettype => 'altaddress_street_type',
1604 B_zipcode => 'altaddress_postal_code',
1605 altcontactaddress1 => 'altcontact_address',
1606 altcontactaddress2 => 'altcontact_address2',
1607 altcontactaddress3 => 'altcontact_city',
1608 altcontactcountry => 'altcontact_country',
1609 altcontactfirstname => 'altcontact_firstname',
1610 altcontactphone => 'altcontact_phone',
1611 altcontactsurname => 'altcontact_surname',
1612 altcontactstate => 'altcontact_state',
1613 altcontactzipcode => 'altcontact_postal_code'
1617 =head2 Internal methods
1629 Kyle M Hall <kyle@bywatersolutions.com>
1630 Alex Sassmannshausen <alex.sassmannshausen@ptfs-europe.com>
1631 Martin Renvoize <martin.renvoize@ptfs-europe.com>