9 use C4::VirtualShelves;
12 my ( $help, $verbose, $not_borrowed_since, $expired_before, $category_code,
13 $branchcode, $confirm );
16 'v|verbose' => \$verbose,
17 'not_borrowed_since:s' => \$not_borrowed_since,
18 'expired_before:s' => \$expired_before,
19 'category_code:s' => \$category_code,
20 'library:s' => \$branchcode,
21 'c|confirm' => \$confirm,
28 $not_borrowed_since = dt_from_string( $not_borrowed_since, 'iso' )
29 if $not_borrowed_since;
31 $expired_before = dt_from_string( $expired_before, 'iso' )
34 unless ( $not_borrowed_since or $expired_before or $category_code or $branchcode ) {
35 pod2usage(q{At least one filter is mandatory});
39 my $members = GetBorrowersToExpunge(
41 not_borrowered_since => $not_borrowed_since,
42 expired_before => $expired_before,
43 category_code => $category_code,
44 branchcode => $branchcode,
49 say "Doing a dry run; no patron records will actually be deleted.";
50 say "Run again with --confirm to delete the records.";
53 say scalar(@$members) . " patrons to delete";
55 my $dbh = C4::Context->dbh;
56 $dbh->{RaiseError} = 1;
57 $dbh->{PrintError} = 0;
59 @$members = ( { borrowernumber => 19 } );
61 $dbh->{AutoCommit} = 0; # use transactions to avoid partial deletes
62 for my $member (@$members) {
63 print "Trying to delete patron $member->{borrowernumber}... "
66 C4::Members::MoveMemberToDeleted( $member->{borrowernumber} )
70 say "Failed to delete patron $member->{borrowernumber}, cannot move it: ($@)";
75 C4::VirtualShelves::HandleDelBorrower( $member->{borrowernumber} )
79 say "Failed to delete patron $member->{borrowernumber}, error handling its lists: ($@)";
83 eval { C4::Members::DelMember( $member->{borrowernumber} ) if $confirm; };
85 say "Failed to delete patron $member->{borrowernumber}: $@)";
95 delete_patrons - This script deletes patrons
99 delete_patrons.pl [-h -v -c] --not_borrowed_since=2013-07-21 --expired_before=2013-07-21 --category_code=CAT --branchcode=CPL
101 dates can be generated with `date -d '-3 month' "+%Y-%m-%d"`
103 Options are cumulatives.
111 Print a brief help message
113 =item B<--not_borrowed_since>
115 Delete patrons who have not borrowed since this date.
117 =item B<--expired_date>
119 Delete patrons with an account expired before this date.
121 =item B<--category_code>
123 Delete patrons who have this category code.
125 =item B<--branchcode>
127 Delete patrons in this library.
129 =item B<-c|--confirm>
131 Without this flag set, this script will do nothing.
133 =item B<-v|--verbose>
141 Jonathan Druart <jonathan.druart@biblibre.com>
145 Copyright 2013 BibLibre
149 This file is part of Koha.
151 Koha is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software
152 Foundation; either version 3 of the License, or (at your option) any later version.
154 You should have received a copy of the GNU General Public License along
155 with Koha; if not, write to the Free Software Foundation, Inc.,
156 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.