Bug 16573: change created_on type - atomic update
[koha.git] / cataloguing / merge.pl
blob09517edb0c0bd27a92b8b61a21f849409d0308a3
1 #!/usr/bin/perl
3 # Copyright 2009 BibLibre
4 # Parts Copyright Catalyst IT 2011
6 # This file is part of Koha.
8 # Koha is free software; you can redistribute it and/or modify it
9 # under the terms of the GNU General Public License as published by
10 # the Free Software Foundation; either version 3 of the License, or
11 # (at your option) any later version.
13 # Koha is distributed in the hope that it will be useful, but
14 # WITHOUT ANY WARRANTY; without even the implied warranty of
15 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
16 # GNU General Public License for more details.
18 # You should have received a copy of the GNU General Public License
19 # along with Koha; if not, see <http://www.gnu.org/licenses>.
21 use Modern::Perl;
22 use CGI qw ( -utf8 );
24 use C4::Output;
25 use C4::Auth;
26 use C4::Items;
27 use C4::Biblio;
28 use C4::Serials;
29 use C4::Koha;
30 use C4::Reserves qw/MergeHolds/;
31 use C4::Acquisition qw/ModOrder GetOrdersByBiblionumber/;
32 use Koha::MetadataRecord;
34 my $input = new CGI;
35 my @biblionumbers = $input->multi_param('biblionumber');
36 my $merge = $input->param('merge');
38 my @errors;
40 my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
42 template_name => "cataloguing/merge.tt",
43 query => $input,
44 type => "intranet",
45 authnotrequired => 0,
46 flagsrequired => { editcatalogue => 'edit_catalogue' },
50 #------------------------
51 # Merging
52 #------------------------
53 if ($merge) {
55 my $dbh = C4::Context->dbh;
57 # Creating a new record from the html code
58 my $record = TransformHtmlToMarc( $input, 1 );
59 my $ref_biblionumber = $input->param('ref_biblionumber');
60 @biblionumbers = grep { $_ != $ref_biblionumber } @biblionumbers;
62 # prepare report
63 my @report_records;
64 my $report_fields_str = $input->param('report_fields');
65 $report_fields_str ||= C4::Context->preference('MergeReportFields');
66 my @report_fields;
67 foreach my $field_str (split /,/, $report_fields_str) {
68 if ($field_str =~ /(\d{3})([0-9a-z]*)/) {
69 my ($field, $subfields) = ($1, $2);
70 push @report_fields, {
71 tag => $field,
72 subfields => [ split //, $subfields ]
77 # Rewriting the leader
78 $record->leader(GetMarcBiblio($ref_biblionumber)->leader());
80 my $frameworkcode = $input->param('frameworkcode');
81 my @notmoveditems;
83 # Modifying the reference record
84 ModBiblio($record, $ref_biblionumber, $frameworkcode);
86 # Moving items from the other record to the reference record
87 foreach my $biblionumber (@biblionumbers) {
88 my $itemnumbers = get_itemnumbers_of($biblionumber);
89 foreach my $itemnumber (@{ $itemnumbers->{$biblionumber} }) {
90 my $res = MoveItemFromBiblio($itemnumber, $biblionumber, $ref_biblionumber);
91 if (not defined $res) {
92 push @notmoveditems, $itemnumber;
96 # If some items could not be moved :
97 if (scalar(@notmoveditems) > 0) {
98 my $itemlist = join(' ',@notmoveditems);
99 push @errors, { code => "CANNOT_MOVE", value => $itemlist };
102 my $sth_subscription = $dbh->prepare("
103 UPDATE subscription SET biblionumber = ? WHERE biblionumber = ?
105 my $sth_subscriptionhistory = $dbh->prepare("
106 UPDATE subscriptionhistory SET biblionumber = ? WHERE biblionumber = ?
108 my $sth_serial = $dbh->prepare("
109 UPDATE serial SET biblionumber = ? WHERE biblionumber = ?
112 my $report_header = {};
113 foreach my $biblionumber ($ref_biblionumber, @biblionumbers) {
114 # build report
115 my $marcrecord = GetMarcBiblio($biblionumber);
116 my %report_record = (
117 biblionumber => $biblionumber,
118 fields => {},
120 foreach my $field (@report_fields) {
121 my @marcfields = $marcrecord->field($field->{tag});
122 foreach my $marcfield (@marcfields) {
123 my $tag = $marcfield->tag();
124 if (scalar @{$field->{subfields}}) {
125 foreach my $subfield (@{$field->{subfields}}) {
126 my @values = $marcfield->subfield($subfield);
127 $report_header->{ $tag . $subfield } = 1;
128 push @{ $report_record{fields}->{$tag . $subfield} }, @values;
130 } elsif ($field->{tag} gt '009') {
131 my @marcsubfields = $marcfield->subfields();
132 foreach my $marcsubfield (@marcsubfields) {
133 my ($code, $value) = @$marcsubfield;
134 $report_header->{ $tag . $code } = 1;
135 push @{ $report_record{fields}->{ $tag . $code } }, $value;
137 } else {
138 $report_header->{ $tag . '@' } = 1;
139 push @{ $report_record{fields}->{ $tag .'@' } }, $marcfield->data();
143 push @report_records, \%report_record;
146 foreach my $biblionumber (@biblionumbers) {
147 # Moving subscriptions from the other record to the reference record
148 my $subcount = CountSubscriptionFromBiblionumber($biblionumber);
149 if ($subcount > 0) {
150 $sth_subscription->execute($ref_biblionumber, $biblionumber);
151 $sth_subscriptionhistory->execute($ref_biblionumber, $biblionumber);
154 # Moving serials
155 $sth_serial->execute($ref_biblionumber, $biblionumber);
157 # Moving orders (orders linked to items of frombiblio have already been moved by MoveItemFromBiblio)
158 my @allorders = GetOrdersByBiblionumber($biblionumber);
159 my @tobiblioitem = GetBiblioItemByBiblioNumber ($ref_biblionumber);
160 my $tobiblioitem_biblioitemnumber = $tobiblioitem [0]-> {biblioitemnumber };
161 foreach my $myorder (@allorders) {
162 $myorder->{'biblionumber'} = $ref_biblionumber;
163 ModOrder ($myorder);
164 # TODO : add error control (in ModOrder?)
167 # Deleting the other records
168 if (scalar(@errors) == 0) {
169 # Move holds
170 MergeHolds($dbh, $ref_biblionumber, $biblionumber);
171 my $error = DelBiblio($biblionumber);
172 push @errors, $error if ($error);
176 # Parameters
177 $template->param(
178 result => 1,
179 report_records => \@report_records,
180 report_header => $report_header,
181 ref_biblionumber => scalar $input->param('ref_biblionumber')
184 #-------------------------
185 # Show records to merge
186 #-------------------------
187 } else {
188 my $ref_biblionumber = $input->param('ref_biblionumber');
190 if ($ref_biblionumber) {
191 my $framework = $input->param('frameworkcode');
192 $framework //= GetFrameworkCode($ref_biblionumber);
194 # Getting MARC Structure
195 my $tagslib = GetMarcStructure(1, $framework);
197 my $marcflavour = lc(C4::Context->preference('marcflavour'));
199 # Creating a loop for display
200 my @records;
201 foreach my $biblionumber (@biblionumbers) {
202 my $marcrecord = GetMarcBiblio($biblionumber);
203 my $frameworkcode = GetFrameworkCode($biblionumber);
204 my $recordObj = new Koha::MetadataRecord({'record' => $marcrecord, schema => $marcflavour});
205 my $record = {
206 recordid => $biblionumber,
207 record => $marcrecord,
208 frameworkcode => $frameworkcode,
209 display => $recordObj->createMergeHash($tagslib),
211 if ($ref_biblionumber and $ref_biblionumber == $biblionumber) {
212 $record->{reference} = 1;
213 $template->param(ref_record => $record);
214 unshift @records, $record;
215 } else {
216 push @records, $record;
220 my ($biblionumbertag) = GetMarcFromKohaField('biblio.biblionumber');
222 # Parameters
223 $template->param(
224 ref_biblionumber => $ref_biblionumber,
225 records => \@records,
226 ref_record => $records[0],
227 framework => $framework,
228 biblionumbertag => $biblionumbertag,
229 MergeReportFields => C4::Context->preference('MergeReportFields'),
231 } else {
232 my @records;
233 foreach my $biblionumber (@biblionumbers) {
234 my $frameworkcode = GetFrameworkCode($biblionumber);
235 my $record = {
236 biblionumber => $biblionumber,
237 data => GetBiblioData($biblionumber),
238 frameworkcode => $frameworkcode,
240 push @records, $record;
242 # Ask the user to choose which record will be the kept
243 $template->param(
244 choosereference => 1,
245 records => \@records,
248 my $frameworks = getframeworks;
249 my @frameworkselect;
250 foreach my $thisframeworkcode ( keys %$frameworks ) {
251 my %row = (
252 value => $thisframeworkcode,
253 frameworktext => $frameworks->{$thisframeworkcode}->{'frameworktext'},
255 push @frameworkselect, \%row;
257 $template->param(
258 frameworkselect => \@frameworkselect,
263 if (@errors) {
264 # Errors
265 $template->param( errors => \@errors );
268 output_html_with_http_headers $input, $cookie, $template->output;
269 exit;