4 # Copyright 2009 BibLibre
5 # Parts Copyright Catalyst IT 2011
7 # This file is part of Koha.
9 # Koha is free software; you can redistribute it and/or modify it under the
10 # terms of the GNU General Public License as published by the Free Software
11 # Foundation; either version 2 of the License, or (at your option) any later
14 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
15 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
16 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
18 # You should have received a copy of the GNU General Public License along
19 # with Koha; if not, write to the Free Software Foundation, Inc.,
20 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
23 #use warnings; FIXME - Bug 2505
31 use C4::Reserves qw/MergeHolds/;
34 my @biblionumber = $input->param('biblionumber');
35 my $merge = $input->param('merge');
39 my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
41 template_name => "cataloguing/merge.tmpl",
45 flagsrequired => { editcatalogue => 'edit_catalogue' },
49 #------------------------
51 #------------------------
54 my $dbh = C4::Context->dbh;
57 # Creating a new record from the html code
58 my $record = TransformHtmlToMarc( $input );
59 my $tobiblio = $input->param('biblio1');
60 my $frombiblio = $input->param('biblio2');
62 # Rewriting the leader
63 $record->leader(GetMarcBiblio($tobiblio)->leader());
65 my $frameworkcode = $input->param('frameworkcode');
68 # Modifying the reference record
69 ModBiblio($record, $tobiblio, $frameworkcode);
71 # Moving items from the other record to the reference record
72 my $itemnumbers = get_itemnumbers_of($frombiblio);
73 foreach my $itloop ($itemnumbers->{$frombiblio}) {
74 foreach my $itemnumber (@$itloop) {
75 my $res = MoveItemFromBiblio($itemnumber, $frombiblio, $tobiblio);
76 if (not defined $res) {
77 push @notmoveditems, $itemnumber;
81 # If some items could not be moved :
82 if (scalar(@notmoveditems) > 0) {
83 my $itemlist = join(' ',@notmoveditems);
84 push @errors, "The following items could not be moved from the old record to the new one: $itemlist";
87 # Moving subscriptions from the other record to the reference record
88 my $subcount = CountSubscriptionFromBiblionumber($frombiblio);
90 $sth = $dbh->prepare("UPDATE subscription SET biblionumber = ? WHERE biblionumber = ?");
91 $sth->execute($tobiblio, $frombiblio);
93 $sth = $dbh->prepare("UPDATE subscriptionhistory SET biblionumber = ? WHERE biblionumber = ?");
94 $sth->execute($tobiblio, $frombiblio);
99 $sth = $dbh->prepare("UPDATE serial SET biblionumber = ? WHERE biblionumber = ?");
100 $sth->execute($tobiblio, $frombiblio);
102 # TODO : Moving reserves
104 # Deleting the other record
105 if (scalar(@errors) == 0) {
107 MergeHolds($dbh,$tobiblio,$frombiblio);
108 my $error = DelBiblio($frombiblio);
109 push @errors, $error if ($error);
115 biblio1 => $input->param('biblio1')
118 #-------------------------
119 # Show records to merge
120 #-------------------------
122 my $mergereference = $input->param('mergereference');
123 my $biblionumber = $input->param('biblionumber');
125 if (scalar(@biblionumber) != 2) {
126 push @errors, "An unexpected number of records was provided for merging. Currently only two records at a time can be merged.";
129 my $data1 = GetBiblioData($biblionumber[0]);
130 my $record1 = GetMarcBiblio($biblionumber[0]);
132 my $data2 = GetBiblioData($biblionumber[1]);
133 my $record2 = GetMarcBiblio($biblionumber[1]);
135 # Checks if both records use the same framework
136 my $frameworkcode1 = &GetFrameworkCode($biblionumber[0]);
137 my $frameworkcode2 = &GetFrameworkCode($biblionumber[1]);
140 my $subtitle1 = GetRecordValue('subtitle', $record1, $frameworkcode1);
141 my $subtitle2 = GetRecordValue('subtitle', $record2, $frameworkcode1);
143 if ($mergereference) {
146 if ($frameworkcode1 ne $frameworkcode2) {
147 $framework = $input->param('frameworkcode')
148 or push @errors, "Famework not selected.";
150 $framework = $frameworkcode1;
153 # Getting MARC Structure
154 my $tagslib = GetMarcStructure(1, $framework);
156 my $notreference = ($biblionumber[0] == $mergereference) ? $biblionumber[1] : $biblionumber[0];
158 # Creating a loop for display
159 my @record1 = _createMarcHash(GetMarcBiblio($mergereference), $tagslib);
160 my @record2 = _createMarcHash(GetMarcBiblio($notreference), $tagslib);
164 biblio1 => $mergereference,
165 biblio2 => $notreference,
166 mergereference => $mergereference,
169 framework => $framework,
174 # Ask the user to choose which record will be the kept
176 choosereference => 1,
177 biblio1 => $biblionumber[0],
178 biblio2 => $biblionumber[1],
179 title1 => $data1->{'title'},
180 subtitle1 => $subtitle1,
181 title2 => $data2->{'title'},
182 subtitle2 => $subtitle2
184 if ($frameworkcode1 ne $frameworkcode2) {
185 my $frameworks = getframeworks;
187 foreach my $thisframeworkcode ( keys %$frameworks ) {
189 value => $thisframeworkcode,
190 frameworktext => $frameworks->{$thisframeworkcode}->{'frameworktext'},
192 if ($frameworkcode1 eq $thisframeworkcode){
193 $row{'selected'} = 1;
195 push @frameworkselect, \%row;
198 frameworkselect => \@frameworkselect,
199 frameworkcode1 => $frameworkcode1,
200 frameworkcode2 => $frameworkcode2,
209 my @errors_loop = map{{error => $_}}@errors;
210 $template->param( errors => \@errors_loop );
213 output_html_with_http_headers $input, $cookie, $template->output;
220 # ------------------------
222 # ------------------------
223 sub _createMarcHash {
227 my @fields = $record->fields();
230 foreach my $field (@fields) {
231 my $fieldtag = $field->tag();
232 if ($fieldtag < 10) {
233 if ($tagslib->{$fieldtag}->{'@'}->{'tab'} >= 0) {
239 value => $field->data(),
245 my @subfields = $field->subfields();
247 foreach my $subfield (@subfields) {
248 if ($tagslib->{$fieldtag}->{@$subfield[0]}->{'tab'} >= 0) {
249 push @subfield_array, {
250 subtag => @$subfield[0],
251 subkey => createKey(),
252 value => @$subfield[1],
258 if ($tagslib->{$fieldtag}->{'tab'} >= 0 && $fieldtag ne '995') {
264 indicator1 => $field->indicator(1),
265 indicator2 => $field->indicator(2),
266 subfield => [@subfield_array],
280 Create a random value to set it into the input name
285 return int(rand(1000000));