4 # Copyright 2009 BibLibre
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 2 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 with
18 # Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
19 # Suite 330, Boston, MA 02111-1307 USA
31 my @biblionumber = $input->param('biblionumber');
32 my $merge = $input->param('merge');
36 my ( $template, $loggedinuser, $cookie ) = get_template_and_user
(
38 template_name
=> "cataloguing/merge.tmpl",
42 flagsrequired
=> { editcatalogue
=> 'edit_catalogue' },
46 #------------------------
48 #------------------------
51 my @params = $input->param();
52 my $dbh = C4
::Context
->dbh;
55 # Creating a new record from the html code
56 my $record = TransformHtmlToMarc
( \
@params , $input );
57 my $tobiblio = $input->param('biblio1');
58 my $frombiblio = $input->param('biblio2');
60 # Rewriting the leader
61 $record->leader(GetMarcBiblio
($tobiblio)->leader());
63 my $frameworkcode = &GetFrameworkCode
($tobiblio);
66 # Modifying the reference record
67 ModBiblio
($record, $tobiblio, $frameworkcode);
69 # Moving items from the other record to the reference record
70 my $itemnumbers = get_itemnumbers_of
($frombiblio);
72 foreach my $itloop ($itemnumbers->{$frombiblio}) {
73 foreach my $itemnumber (@
$itloop) {
74 my $res = MoveItemFromBiblio
($itemnumber, $frombiblio, $tobiblio);
75 if (not defined $res) {
76 push @notmoveditems, $itemnumber;
80 # If some items could not be moved :
81 if (scalar(@notmoveditems) > 0) {
82 my $itemlist = join(' ',@notmoveditems);
83 push @errors, "The following items could not be moved from the old record to the new one: $itemlist";
86 # Moving subscriptions from the other record to the reference record
87 my $subcount = CountSubscriptionFromBiblionumber
($frombiblio);
89 $sth = $dbh->prepare("UPDATE subscription SET biblionumber = ? WHERE biblionumber = ?");
90 $sth->execute($tobiblio, $frombiblio);
92 $sth = $dbh->prepare("UPDATE subscriptionhistory SET biblionumber = ? WHERE biblionumber = ?");
93 $sth->execute($tobiblio, $frombiblio);
98 $sth = $dbh->prepare("UPDATE serial SET biblionumber = ? WHERE biblionumber = ?");
99 $sth->execute($tobiblio, $frombiblio);
101 # TODO : Moving reserves
103 # Deleting the other record
104 if (scalar(@errors) == 0) {
105 my $error = DelBiblio
($frombiblio);
106 push @errors, $error if ($error);
110 my @errors_loop = map{{error
=> $_}}@errors;
114 errors
=> \
@errors_loop,
116 biblio1
=> $input->param('biblio1')
120 #-------------------------
121 # Show records to merge
122 #-------------------------
125 my $mergereference = $input->param('mergereference');
126 my $biblionumber = $input->param('biblionumber');
128 my $data1 = GetBiblioData
($biblionumber[0]);
129 my $data2 = GetBiblioData
($biblionumber[1]);
131 # Ask the user to choose which record will be the kept
132 if (not $mergereference) {
134 choosereference
=> 1,
135 biblio1
=> $biblionumber[0],
136 biblio2
=> $biblionumber[1],
137 title1
=> $data1->{'title'},
138 title2
=> $data2->{'title'}
142 if (scalar(@biblionumber) != 2) {
143 push @errors, "An unexpected number of records was provided for merging. Currently only two records at a time can be merged.";
146 # Checks if both records use the same framework
147 my $frameworkcode1 = &GetFrameworkCode
($biblionumber[0]);
148 my $frameworkcode2 = &GetFrameworkCode
($biblionumber[1]);
150 if ($frameworkcode1 ne $frameworkcode2) {
151 push @errors, "The records selected for merging are using different frameworks. Currently merging is only available for records using the same framework.";
153 $framework = $frameworkcode1;
156 # Getting MARC Structure
157 my $tagslib = GetMarcStructure
(1, $framework);
159 my $notreference = ($biblionumber[0] == $mergereference) ?
$biblionumber[1] : $biblionumber[0];
161 # Creating a loop for display
162 my @record1 = _createMarcHash
(GetMarcBiblio
($mergereference), $tagslib);
163 my @record2 = _createMarcHash
(GetMarcBiblio
($notreference), $tagslib);
166 my @errors_loop = map{{error
=> $_}}@errors;
170 errors
=> \
@errors_loop,
171 biblio1
=> $mergereference,
172 biblio2
=> $notreference,
173 mergereference
=> $mergereference,
176 framework
=> $framework
180 output_html_with_http_headers
$input, $cookie, $template->output;
184 # ------------------------
186 # ------------------------
187 sub _createMarcHash
{
191 my @fields = $record->fields();
194 foreach my $field (@fields) {
195 my $fieldtag = $field->tag();
196 if ($fieldtag < 10) {
197 if ($tagslib->{$fieldtag}->{'@'}->{'tab'} >= 0) {
203 value
=> $field->data(),
209 my @subfields = $field->subfields();
211 foreach my $subfield (@subfields) {
212 if ($tagslib->{$fieldtag}->{@
$subfield[0]}->{'tab'} >= 0) {
213 push @subfield_array, {
214 subtag
=> @
$subfield[0],
215 subkey
=> createKey
(),
216 value
=> @
$subfield[1],
222 if ($tagslib->{$fieldtag}->{'tab'} >= 0 && $fieldtag ne '995') {
228 indicator1
=> $field->indicator(1),
229 indicator2
=> $field->indicator(2),
230 subfield
=> [@subfield_array],
244 Create a random value to set it into the input name
249 return int(rand(1000000));