3 # This file is part of Koha.
5 # Copyright 2013 BibLibre
7 # Koha is free software; you can redistribute it and/or modify
8 # it under the terms of the GNU General Public License as
9 # published by the Free Software Foundation; either version 3
10 # of the License, or (at your option) any later version.
12 # Koha is distributed in the hope that it will be useful, but
13 # WITHOUT ANY WARRANTY; without even the implied warranty of
14 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 # GNU General Public License for more details.
17 # You should have received a copy of the GNU General
18 # Public License along with Koha; if not, see
19 # <http://www.gnu.org/licenses>
24 use List::MoreUtils qw( uniq );
28 use C4::AuthoritiesMarc;
30 use Koha::Virtualshelves;
32 use Koha::Authorities;
37 my $op = $input->param('op') // q|form|;
38 my $recordtype = $input->param('recordtype') // 'biblio';
40 my ($template, $loggedinuser, $cookie) = get_template_and_user({
41 template_name => 'tools/batch_delete_records.tt',
45 flagsrequired => { tools => 'records_batchdel' },
48 my @lists = Koha::Virtualshelves->search({});
49 $template->param( lists => \@lists );
53 if ( $op eq 'form' ) {
55 $template->param( op => 'form' );
56 } elsif ( $op eq 'list' ) {
57 # List all records to process
59 if ( my $bib_list = $input->param('bib_list') ) {
60 # Come from the basket
61 @record_ids = split /\//, $bib_list;
62 $recordtype = 'biblio';
63 } elsif ( my $uploadfile = $input->param('uploadfile') ) {
64 # A file of id is given
65 binmode $uploadfile, ':encoding(UTF-8)';
66 while ( my $content = <$uploadfile> ) {
68 $content =~ s/[\r\n]*$//;
69 push @record_ids, $content if $content;
71 } elsif ( my $shelf_number = $input->param('shelf_number') ) {
72 my $shelf = Koha::Virtualshelves->find($shelf_number);
73 my $contents = $shelf->get_contents;
74 while ( my $content = $contents->next ) {
75 my $biblionumber = $content->biblionumber;
76 push @record_ids, $biblionumber;
79 # The user enters manually the list of id
80 push @record_ids, split( /\s\n/, $input->param('recordnumber_list') );
83 for my $record_id ( uniq @record_ids ) {
84 if ( $recordtype eq 'biblio' ) {
85 # Retrieve biblio information
86 my $biblio = Koha::Biblios->find( $record_id );
90 code => 'biblio_not_exists',
91 biblionumber => $record_id,
95 my $holds_count = $biblio->holds->count;
96 $biblio = $biblio->unblessed;
97 my $record = &GetMarcBiblio({ biblionumber => $record_id });
98 $biblio->{subtitle} = GetRecordValue( 'subtitle', $record, GetFrameworkCode( $record_id ) );
99 $biblio->{itemnumbers} = [Koha::Items->search({ biblionumber => $record_id })->get_column('itemnumber')];
100 $biblio->{holds_count} = $holds_count;
101 $biblio->{issues_count} = C4::Biblio::CountItemsIssued( $record_id );
102 push @records, $biblio;
104 # Retrieve authority information
105 my $authority = C4::AuthoritiesMarc::GetAuthority( $record_id );
106 unless ( $authority ) {
109 code => 'authority_not_exists',
110 authid => $record_id,
116 authid => $record_id,
117 summary => C4::AuthoritiesMarc::BuildSummary( $authority, $record_id ),
118 count_usage => Koha::Authorities->get_usage_count({ authid => $record_id }),
120 push @records, $authority;
124 records => \@records,
127 } elsif ( $op eq 'delete' ) {
128 # We want to delete selected records!
129 my @record_ids = $input->multi_param('record_id');
130 my $schema = Koha::Database->new->schema;
137 RECORD_IDS: for my $record_id ( sort { $a <=> $b } @record_ids ) {
138 $report->{total_records}++;
139 next unless $record_id;
140 $schema->storage->txn_begin;
142 if ( $recordtype eq 'biblio' ) {
144 my $biblionumber = $record_id;
145 # First, checking if issues exist.
146 # If yes, nothing to do
147 my $biblio = Koha::Biblios->find( $biblionumber );
149 # TODO Replace with $biblio->get_issues->count
150 if ( C4::Biblio::CountItemsIssued( $biblionumber ) ) {
153 code => 'item_issued',
154 biblionumber => $biblionumber,
156 $schema->storage->txn_rollback;
161 my $holds = $biblio->holds;
162 while ( my $hold = $holds->next ) {
169 code => 'reserve_not_cancelled',
170 biblionumber => $biblionumber,
171 reserve_id => $hold->reserve_id,
174 $schema->storage->txn_rollback;
180 my @itemnumbers = Koha::Items->search({ biblionumber => $biblionumber })->get_column('itemnumber');
181 ITEMNUMBER: for my $itemnumber ( @itemnumbers ) {
182 my $error = eval { C4::Items::DelItemCheck( $biblionumber, $itemnumber ) };
183 if ( $error != 1 or $@ ) {
186 code => 'item_not_deleted',
187 biblionumber => $biblionumber,
188 itemnumber => $itemnumber,
189 error => ($@ ? $@ : $error),
191 $schema->storage->txn_rollback;
196 # Finally, delete the biblio
198 C4::Biblio::DelBiblio( $biblionumber );
200 if ( $error or $@ ) {
203 code => 'biblio_not_deleted',
204 biblionumber => $biblionumber,
205 error => ($@ ? $@ : $error),
207 $schema->storage->txn_rollback;
213 code => 'biblio_deleted',
214 biblionumber => $biblionumber,
216 $report->{total_success}++;
217 $schema->storage->txn_commit;
220 my $authid = $record_id;
221 eval { C4::AuthoritiesMarc::DelAuthority({ authid => $authid }) };
225 code => 'authority_not_deleted',
227 error => ($@ ? $@ : 0),
229 $schema->storage->txn_rollback;
234 code => 'authority_deleted',
237 $report->{total_success}++;
238 $schema->storage->txn_commit;
249 messages => \@messages,
250 recordtype => $recordtype,
253 output_html_with_http_headers $input, $cookie, $template->output;