3 #-----------------------------------
4 # Copyright 2013 ByWater Solutions
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.
20 #-----------------------------------
24 binmode( STDOUT, ":utf8" );
28 # find Koha's Perl modules
29 # test carefully before changing this
31 eval { require "$FindBin::Bin/../kohalib.pl" };
47 'i|di|delete-items' => \$delete_items,
48 'c|confirm' => \$confirm,
50 'v|verbose' => \$verbose,
54 if ( $help || !$confirm ) {
56 delete_records_via_leader.pl - Attempt to delete any MARC records where the leader character 5 equals 'd'
57 usage: delete_records_via_leader.pl --confirm --verbose [--test]
58 This script has the following parameters :
59 -h --help: Prints this message
60 -c --confirm: Script will do nothing without this parameter
61 -v --verbose: Be verbose
62 -t --test: Test mode, does not delete records
63 -i --delete-items: Try deleting items before deleting record.
64 Records with items cannot be deleted.
69 my $schema = Koha::Database->new()->schema();
71 $schema->resultset('Biblioitem')->search( { marc => { LIKE => '_____d%' } } );
73 my $total_records_count = @biblioitems;
74 my $deleted_records_count = 0;
75 my $total_items_count = 0;
76 my $deleted_items_count = 0;
78 foreach my $biblioitem (@biblioitems) {
79 my $biblionumber = $biblioitem->get_column('biblionumber');
81 say "RECORD: $biblionumber" if $verbose;
84 my $deleted_count = 0;
85 foreach my $item ( $biblioitem->items() ) {
86 my $itemnumber = $item->itemnumber();
88 my $error = $test ? "Test mode enabled" : DelItemCheck( undef, $biblionumber, $itemnumber );
89 $error = undef if $error eq '1';
92 say "ERROR DELETING ITEM $itemnumber: $error";
95 say "DELETED ITEM $itemnumber" if $verbose;
96 $deleted_items_count++;
104 my $error = $test ? q{Test mode enabled} : DelBiblio($biblionumber);
106 say "ERROR DELETING BIBLIO $biblionumber: $error";
108 say "DELETED BIBLIO $biblionumber" if $verbose;
109 $deleted_records_count++;
116 say "DELETED $deleted_records_count OF $total_records_count RECORDS";
117 say "DELETED $deleted_items_count OF $total_items_count ITEMS" if $delete_items;