5 use Pod::Usage qw( pod2usage );
6 use Getopt::Long qw( GetOptions );
8 use Koha::Script -cron;
9 use C4::Members qw( GetBorrowersToExpunge );
10 use Koha::DateUtils qw( dt_from_string );
12 use C4::Log qw( cronlogaction );
14 my ( $help, $verbose, $not_borrowed_since, $expired_before, $last_seen,
15 @category_code, $branchcode, $file, $confirm );
17 my $command_line_options = join(" ",@ARGV);
21 'v|verbose' => \$verbose,
22 'not_borrowed_since:s' => \$not_borrowed_since,
23 'expired_before:s' => \$expired_before,
24 'last_seen:s' => \$last_seen,
25 'category_code:s' => \@category_code,
26 'library:s' => \$branchcode,
28 'c|confirm' => \$confirm,
35 $not_borrowed_since = dt_from_string( $not_borrowed_since, 'iso' )
36 if $not_borrowed_since;
38 $expired_before = dt_from_string( $expired_before, 'iso' )
41 if ( $last_seen and not C4::Context->preference('TrackLastPatronActivity') ) {
42 pod2usage(q{The --last_seen option cannot be used with TrackLastPatronActivity turned off});
45 unless ( $not_borrowed_since or $expired_before or $last_seen or @category_code or $branchcode or $file ) {
46 pod2usage(q{At least one filter is mandatory});
49 cronlogaction({ info => $command_line_options });
53 open(my $fh, '<:encoding(UTF-8)', $file) or die "Could not open file $file' $!";
54 while (my $line = <$fh>) {
56 my %fm = ('borrowernumber' => $line);
58 push @file_members, $fm_ref;
64 if ( $not_borrowed_since or $expired_before or $last_seen or @category_code or $branchcode ) {
65 $members = GetBorrowersToExpunge(
67 not_borrowed_since => $not_borrowed_since,
68 expired_before => $expired_before,
69 last_seen => $last_seen,
70 category_code => \@category_code,
71 branchcode => $branchcode,
76 if ($members and @file_members) {
78 for my $member (@$members) {
79 for my $fm (@file_members) {
80 if ($member->{borrowernumber} eq $fm->{borrowernumber}) {
81 push @filtered_members, $fm;
85 $members = \@filtered_members;
88 if (!defined $members and @file_members) {
89 $members = \@file_members;
93 say "Doing a dry run; no patron records will actually be deleted.";
94 say "Run again with --confirm to delete the records.";
98 say scalar(@$members) . " patrons match conditions" if $verbose;;
100 my $anonymous_patron = C4::Context->preference("AnonymousPatron");
102 for my $member (@$members) {
103 print "Testing that we can delete patron $member->{borrowernumber}... "
106 my $borrowernumber = $member->{borrowernumber};
107 my $patron = Koha::Patrons->find( $borrowernumber );
109 say "Cannot delete: Patron with borrowernumber $borrowernumber does not exist";
112 if ( my $charges = $patron->account->non_issues_charges ) { # And what if we owe to this patron?
113 say "Cannot delete patron $borrowernumber: patron has $charges in fines" if $verbose;
117 if ( $anonymous_patron ) {
118 if ( $patron->id eq $anonymous_patron ) {
119 say "Cannot delete patron $borrowernumber: patron is AnonymousPatron";
125 my $deleted = eval { $patron->move_to_deleted; };
126 if ($@ or not $deleted) {
127 say "Cannot delete patron $borrowernumber, cannot move it" . ( $@ ? ": ($@)" : "" ) if $verbose;
131 eval { $patron->delete };
133 say "Cannot delete patron $borrowernumber: $@)";
138 say "OK" if $verbose;
142 say $confirm ? "$deleted patrons deleted" : "$deleted patrons would have been deleted" if $verbose;
144 cronlogaction({ action => 'End', info => "COMPLETED" });
148 delete_patrons - This script deletes patrons
152 delete_patrons.pl [-h|--help] [-v|--verbose] [-c|--confirm] [--not_borrowed_since=DATE] [--expired_before=DATE] [--last-seen=DATE] [--category_code=CAT] [--category_code=CAT ...] [--library=LIBRARY] [--file=FILE]
154 Dates should be in ISO format, e.g., 2013-07-19, and can be generated
155 with `date -d '-3 month' --iso-8601`.
157 The options to select the patron records to delete are cumulative. For
158 example, supplying both --expired_before and --library specifies that
159 that patron records must meet both conditions to be selected for deletion.
167 Print a brief help message
169 =item B<--not_borrowed_since>
171 Delete patrons who have not borrowed since this date.
173 =item B<--expired_before>
175 Delete patrons with an account expired before this date.
179 Delete patrons who have not been connected since this date.
181 The system preference TrackLastPatronActivity must be enabled to use this option.
183 =item B<--category_code>
185 Delete patrons who have this category code.
187 Can be used multiple times for additional category codes.
191 Delete patrons in this library.
195 Delete patrons whose borrower numbers are in this file. If other criteria are defined
196 it will only delete those in the file that match those criteria.
198 =item B<-c|--confirm>
200 This flag must be provided in order for the script to actually
201 delete patron records. If it is not supplied, the script will
202 only report on the patron records it would have deleted.
204 =item B<-v|--verbose>
212 Jonathan Druart <jonathan.druart@biblibre.com>
216 Copyright 2013 BibLibre
220 This file is part of Koha.
222 # Koha is free software; you can redistribute it and/or modify it
223 # under the terms of the GNU General Public License as published by
224 # the Free Software Foundation; either version 3 of the License, or
225 # (at your option) any later version.
227 # Koha is distributed in the hope that it will be useful, but
228 # WITHOUT ANY WARRANTY; without even the implied warranty of
229 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
230 # GNU General Public License for more details.
232 # You should have received a copy of the GNU General Public License
233 # along with Koha; if not, see <http://www.gnu.org/licenses>.