5 # Copyright 2000-2002 Katipo Communications
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 with
19 # Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
20 # Suite 330, Boston, MA 02111-1307 USA
26 use C4::Interface::CGI::Output;
28 use C4::Search; # also includes Biblio.pm, Search is used to FindDuplicate
30 use C4::Koha; # XXX subfield_is_koha_internal_p
32 use MARC::File::USMARC;
34 $format="UNIMARC" if (C4::Context->preference('marcflavour') eq 'UNIMARC');
35 use MARC::File::XML(RecordFormat =>$format);
37 use vars qw( $tagslib);
38 use vars qw( $authorised_values_sth);
39 use vars qw( $is_a_modif );
41 my $z3950 = $input->param('z3950');
42 my $logstatus=C4::Context->preference('Activate_log');
44 my $itemtype; # created here because it can be used in build_authorized_values_list sub
46 ###Find related tags for Z3950 searches- required by template
47 my($isbntag,$isbnsub)=MARCfind_marc_from_kohafield("isbn","biblios");
48 my($issntag,$issnsub)=MARCfind_marc_from_kohafield("issn","biblios");
49 my($titletag,$titlesub)=MARCfind_marc_from_kohafield("title","biblios");
50 my($authortag,$authorsub)=MARCfind_marc_from_kohafield("author","biblios");
51 =item MARCfindbreeding
53 $record = MARCfindbreeding($dbh, $breedingid,$frameworkcode);
55 Look up the breeding farm with database handle $dbh, for the
56 record with id $breedingid. If found, returns the decoded
57 MARC::Record; otherwise, -1 is returned (FIXME).
58 Returns as second parameter the character encoding.
62 sub MARCfindbreeding {
63 my ($dbh,$id,$oldbiblionumber) = @_;
64 my $sth = $dbh->prepare("select marc,encoding from marc_breeding where id=?");
66 my ($marc,$encoding) = $sth->fetchrow;
69 my $record = MARC::File::USMARC::decode($marc);
70 if (ref($record) eq undef) {
73 if (C4::Context->preference("z3950NormalizeAuthor") and C4::Context->preference("z3950AuthorAuthFields")){
74 my ($tag,$subfield) = MARCfind_marc_from_kohafield("author","biblios");
75 my $auth_fields = C4::Context->preference("z3950AuthorAuthFields");
76 my @auth_fields= split /,/,$auth_fields;
78 if ($record->field($tag)){
79 foreach my $tmpfield ($record->field($tag)->subfields){
80 my $subfieldcode=shift @$tmpfield;
81 my $subfieldvalue=shift @$tmpfield;
83 $field->add_subfields("$subfieldcode"=>$subfieldvalue) if ($subfieldcode ne $subfield);
85 $field=MARC::Field->new($tag,"","",$subfieldcode=>$subfieldvalue) if ($subfieldcode ne $subfield);
89 $record->delete_field($record->field($tag));
90 foreach my $fieldtag (@auth_fields){
91 next unless ($record->field($fieldtag));
92 my $lastname = $record->field($fieldtag)->subfield('a');
93 my $firstname= $record->field($fieldtag)->subfield('b');
94 my $title = $record->field($fieldtag)->subfield('c');
95 my $number= $record->field($fieldtag)->subfield('d');
97 $field->add_subfields("$subfield"=>ucfirst($title)." ".ucfirst($firstname)." ".$number);
99 $field->add_subfields("$subfield"=>ucfirst($firstname).", ".ucfirst($lastname));
102 $record->insert_fields_ordered($field);
104 ##Delete biblionumber tag in case a similar tag is used in imported MARC ##
105 my ( $tagfield, $tagsubfield ) =MARCfind_marc_from_kohafield("biblionumber","biblios");
106 my $old_field = $record->field($tagfield);
107 $record->delete_field($old_field);
108 ##add the old biblionumber if a modif but coming from breedingfarm
109 if ($oldbiblionumber){
112 $newfield = MARC::Field->new($tagfield, $oldbiblionumber);
114 $newfield = MARC::Field->new($tagfield, '', '', "$tagsubfield" => $oldbiblionumber);
116 $record->insert_fields_ordered($newfield);
118 my $xml= $record->as_xml_record();
119 $xml=Encode::encode('utf8',$xml);
120 my $xmlhash=XML_xml2hash_onerecord($xml);
121 return $xmlhash,$encoding;
128 =item build_authorized_values_list
132 sub build_authorized_values_list ($$$$$) {
133 my($tag, $subfield, $value, $dbh,$authorised_values_sth) = @_;
135 my @authorised_values;
138 # builds list, depending on authorised value...
141 if ($tagslib->{$tag}->{$subfield}->{'authorised_value'} eq "branches" ) {
142 my $sth=$dbh->prepare("select branchcode,branchname from branches order by branchname");
144 push @authorised_values, ""
145 unless ($tagslib->{$tag}->{$subfield}->{mandatory});
147 while (my ($branchcode,$branchname) = $sth->fetchrow_array) {
148 push @authorised_values, $branchcode;
149 $authorised_lib{$branchcode}=$branchname;
153 } elsif ($tagslib->{$tag}->{$subfield}->{authorised_value} eq "itemtypes") {
154 my $sth=$dbh->prepare("select itemtype,description from itemtypes order by description");
156 push @authorised_values, "" unless ($tagslib->{$tag}->{$subfield}->{mandatory});
158 while (my ($itemtype,$description) = $sth->fetchrow_array) {
159 push @authorised_values, $itemtype;
160 $authorised_lib{$itemtype}=$description;
162 $value=$itemtype unless ($value);
164 #---- "true" authorised value
166 $authorised_values_sth->execute($tagslib->{$tag}->{$subfield}->{authorised_value});
168 push @authorised_values, "" unless ($tagslib->{$tag}->{$subfield}->{mandatory});
170 while (my ($value,$lib) = $authorised_values_sth->fetchrow_array) {
171 push @authorised_values, $value;
172 $authorised_lib{$value}=$lib;
175 return CGI::scrolling_list( -name => 'field_value',
176 -values => \@authorised_values,
178 -labels => \%authorised_lib,
185 builds the <input ...> entry for a subfield.
187 sub create_input () {
188 my ($tag,$subfield,$value,$i,$tabloop,$rec,$authorised_values_sth,$id) = @_;
189 my $dbh=C4::Context->dbh;
190 $value =~ s/"/"/g;
192 $subfield_data{id}=$id;
193 $subfield_data{tag}=$tag;
194 $subfield_data{subfield}=$subfield;
195 $subfield_data{marc_lib}="<span id=\"error$i\">".$tagslib->{$tag}->{$subfield}->{lib}."</span>";
196 $subfield_data{marc_lib_plain}=$tagslib->{$tag}->{$subfield}->{lib};
197 $subfield_data{tag_mandatory}=$tagslib->{$tag}->{mandatory};
198 $subfield_data{mandatory}=$tagslib->{$tag}->{$subfield}->{mandatory};
199 $subfield_data{repeatable}=$tagslib->{$tag}->{$subfield}->{repeatable};
200 $subfield_data{index} = $i;
201 $subfield_data{visibility} = "display:none" if (substr($tagslib->{$tag}->{$subfield}->{hidden},2,1) gt "0") ; #check parity
202 if ($tagslib->{$tag}->{$subfield}->{authorised_value}) {
203 $subfield_data{marc_value}= build_authorized_values_list($tag, $subfield, $value, $dbh,$authorised_values_sth);
204 # it's an authority field
205 } elsif ($tagslib->{$tag}->{$subfield}->{authtypecode}) {
207 $subfield_data{marc_value}="<input onblur=\"this.style.backgroundColor='#ffffff';\" onfocus=\"this.style.backgroundColor='#ffffff;'\"\" tabindex=\"1\" type=\"text\" name=\"field_value\" id=\"field_value$id\" value=\"$value\" size=\"40\" maxlength=\"255\" DISABLE READONLY> <a style=\"cursor: help;\" href=\"javascript:Dopop('../authorities/auth_finder.pl?authtypecode=".$tagslib->{$tag}->{$subfield}->{authtypecode}."&index=$id',$id);\">...</a>";
208 # it's a plugin field
209 } elsif ($tagslib->{$tag}->{$subfield}->{'value_builder'}) {
210 # opening plugin. Just check wether we are on a developper computer on a production one
211 # (the cgidir differs)
212 my $cgidir = C4::Context->intranetdir ."/cgi-bin/value_builder";
213 unless (opendir(DIR, "$cgidir")) {
214 $cgidir = C4::Context->intranetdir."/value_builder";
216 my $plugin=$cgidir."/".$tagslib->{$tag}->{$subfield}->{'value_builder'};
218 my $extended_param = plugin_parameters($dbh,$rec,$tagslib,$i,$tabloop);
219 my ($function_name,$javascript) = plugin_javascript($dbh,$rec,$tagslib,$i,$tabloop);
220 $subfield_data{marc_value}="<input tabindex=\"1\" type=\"text\" name=\"field_value\" id=\"field_value$id\" value=\"$value\" size=\"40\" maxlength=\"255\" DISABLE READONLY OnFocus=\"javascript:Focus$function_name($i)\" OnBlur=\"javascript:Blur$function_name($i); \"> <a style=\"cursor: help;\" href=\"javascript:Clic$function_name($i)\">...</a> $javascript";
221 # it's an hidden field
222 } elsif ($tag eq '') {
223 $subfield_data{marc_value}="<input onblur=\"this.style.backgroundColor='#ffffff';\" onfocus=\"this.style.backgroundColor='#ffffff'; \" tabindex=\"1\" type=\"hidden\" name=\"field_value\" id=\"field_value$id\" value=\"$value\">";
224 } elsif (substr($tagslib->{$tag}->{$subfield}->{'hidden'},2,1) gt "1") {
226 $subfield_data{marc_value}="<input onblur=\"this.style.backgroundColor='#ffffff';\" onfocus=\"this.style.backgroundColor='#ffffff'; \" tabindex=\"1\" type=\"text\" name=\"field_value\" id=\"field_value$id\" value=\"$value\" size=\"40\" maxlength=\"255\" >";
227 # it's a standard field
229 if (length($value) >100) {
230 $subfield_data{marc_value}="<textarea tabindex=\"1\" name=\"field_value\" id=\"field_value$id\" cols=\"40\" rows=\"5\" >$value</textarea>";
232 $subfield_data{marc_value}="<input onblur=\"this.style.backgroundColor='#ffffff';\" onfocus=\"this.style.backgroundColor='#ffffff'; \" tabindex=\"1\" type=\"text\" name=\"field_value\" id=\"field_value$id\" value=\"$value\" size=\"50\">"; #"
235 return \%subfield_data;
238 sub build_tabs ($$$;$){
239 my($template, $xmlhash, $dbh,$addedfield) = @_;
245 my $authorised_values_sth = $dbh->prepare("select authorised_value,lib
246 from authorised_values
247 where category=? order by lib");
252 $biblio=$xmlhash->{'datafield'};
253 $controlfields=$xmlhash->{'controlfield'};
254 $leader=$xmlhash->{'leader'};
259 # loop through each tab 0 through 9
260 for (my $tabloop = 0; $tabloop <= 9; $tabloop++) {
263 foreach my $tag (sort(keys (%{$tagslib}))) {
265 # if MARC::Record is not empty => use it as master loop, then add missing subfields that should be in the tab.
266 # if MARC::Record is empty => use tab as master loop.
273 my %definedsubfields;
278 foreach my $data (@$biblio){
281 undef %definedsubfields;
282 if ($data->{'tag'} eq $tag){
283 $tagdefined{$tag}=1 ;
284 if ($built{$tag}==1){
289 foreach my $subfieldcode ( $data->{'subfield'}){
290 foreach my $code ( @$subfieldcode){
291 next if ($tagslib->{$tag}->{$code->{'code'}}->{tab} ne $tabloop);
292 my $subfield=$code->{'code'} ;
293 my $value=$code->{'content'};
294 $definedsubfields{$tag.$subfield}=1 ;
296 push(@subfields_data, &create_input($tag,$subfield,$value,$i,$tabloop,$xmlhash,$authorised_values_sth,$id)) ;
300 $ind1=$data->{'ind1'};
301 $ind2= $data->{'ind2'};
303 if ($hiddenrequired && $#loop_data >=0 && $loop_data[$#loop_data]->{'tag'} eq $tag) {
304 my @hiddensubfields_data;
306 push(@hiddensubfields_data, &create_input('','','',$i,$tabloop,$xmlhash,$authorised_values_sth,$id));
308 $tag_data{tag_lib} = '';
309 $tag_data{indicator} = '';
310 $tag_data{subfield_loop} = \@hiddensubfields_data;
311 push (@loop_data, \%tag_data);
314 # now, loop again to add parameter subfield that are not in the MARC::Record
316 foreach my $subfield (sort( keys %{$tagslib->{$tag}})) {
317 next if (length $subfield !=1);
318 next if ($tagslib->{$tag}->{$subfield}->{tab} ne $tabloop);
319 next if ((substr($tagslib->{$tag}->{$subfield}->{hidden},2,1) gt "1") ); #check for visibility flag
320 next if ($definedsubfields{$tag.$subfield} );
321 push(@subfields_data, &create_input($tag,$subfield,'',$i,$tabloop,$xmlhash,$authorised_values_sth,$id));
322 $definedsubfields{$tag.$subfield}=1;
325 if ($#subfields_data >= 0) {
327 $tag_data{tag} = $tag;
328 $tag_data{tag_lib} = $tagslib->{$tag}->{lib};
329 $tag_data{repeatable} = $tagslib->{$tag}->{repeatable};
330 $tag_data{indicator} = $ind1.$ind2 if ($tag>=10);
331 $tag_data{subfield_loop} = \@subfields_data;
332 push (@loop_data, \%tag_data);
340 if ($tag eq "000" || $tag eq "LDR"){
342 next if ($tagslib->{$tag}->{$subfield}->{tab} ne $tabloop);
344 my $value=$leader->[0] if $leader->[0];
345 $tagdefined{$tag}=1 ;
346 push(@subfields_data, &create_input($tag,$subfield,$value,$i,$tabloop,$xmlhash,$authorised_values_sth,$id));
348 if ($#subfields_data >= 0) {
350 $tag_data{tag} = $tag;
351 $tag_data{tag_lib} = $tagslib->{$tag}->{lib};
352 $tag_data{repeatable} = $tagslib->{$tag}->{repeatable};
353 $tag_data{subfield_loop} = \@subfields_data;
354 $tag_data{fixedfield} = 1;
355 push (@loop_data, \%tag_data);
358 foreach my $control (@$controlfields){
360 next if ($tagslib->{$tag}->{$subfield}->{tab} ne $tabloop);
362 if ($control->{'tag'} eq $tag){
364 $tagdefined{$tag}=1 ;
365 if ($built{$tag}==1){$hiddenrequired=1;}
366 my $value=$control->{'content'} ;
367 $definedsubfields{$tag.'@'}=1;
368 push(@subfields_data, &create_input($tag,$subfield,$value,$i,$tabloop,$xmlhash,$authorised_values_sth,$id));
372 if ($hiddenrequired && $#loop_data >=0 && $loop_data[$#loop_data]->{'tag'} eq $tag) {
373 my @hiddensubfields_data;
375 push(@hiddensubfields_data, &create_input('','','',$i,$tabloop,$xmlhash,$authorised_values_sth,$id));
377 $tag_data{tag_lib} = '';
378 $tag_data{subfield_loop} = \@hiddensubfields_data;
379 $tag_data{fixedfield} = 1;
380 push (@loop_data, \%tag_data);
383 if ($#subfields_data >= 0) {
385 $tag_data{tag} = $tag;
386 $tag_data{tag_lib} = $tagslib->{$tag}->{lib};
387 $tag_data{repeatable} = $tagslib->{$tag}->{repeatable};
388 $tag_data{subfield_loop} = \@subfields_data;
389 $tag_data{fixedfield} = 1;
390 push (@loop_data, \%tag_data);
399 ##### Any remaining tag
401 # now, loop again to add parameter subfield that are not in the MARC::Record
402 foreach my $subfield (sort( keys %{$tagslib->{$tag}})) {
403 next if ($tagdefined{$tag} );
404 next if (length $subfield !=1);
405 next if ($tagslib->{$tag}->{$subfield}->{tab} ne $tabloop);
406 next if ((substr($tagslib->{$tag}->{$subfield}->{hidden},2,1) gt "1") ); #check for visibility flag
408 push(@subfields_data, &create_input($tag,$subfield,'',$i,$tabloop,$xmlhash,$authorised_values_sth,$id));
409 $tagdefined{$tag.$subfield}=1;
412 if ($#subfields_data >= 0) {
414 $tag_data{tag} = $tag;
415 $tag_data{tag_lib} = $tagslib->{$tag}->{lib};
416 $tag_data{repeatable} = $tagslib->{$tag}->{repeatable};
417 $tag_data{indicator} = $ind1.$ind2 if ($tag>=10);
418 $tag_data{subfield_loop} = \@subfields_data;
420 $tag_data{fixedfield} = 1;
423 push (@loop_data, \%tag_data);
427 if ($addedfield eq $tag) {
431 $tagdefined{$tag}=1 ;
432 foreach my $subfield (sort( keys %{$tagslib->{$tag}})) {
433 next if (length $subfield !=1);
434 next if ($tagslib->{$tag}->{$subfield}->{tab} ne $tabloop);
435 next if ((substr($tagslib->{$tag}->{$subfield}->{hidden},2,1) gt "1") ); #check for visibility flag
437 push(@subfields_data, &create_input($tag,$subfield,'',$i,$tabloop,$xmlhash,$authorised_values_sth,$id));
440 if ($#subfields_data >= 0) {
441 $tag_data{tag} = $tag;
442 $tag_data{tag_lib} = $tagslib->{$tag}->{lib};
443 $tag_data{repeatable} = $tagslib->{$tag}->{repeatable};
444 $tag_data{indicator} = ' ' if ($tag>=10);
445 $tag_data{subfield_loop} = \@subfields_data;
447 $tag_data{fixedfield} = 1;
449 push (@loop_data, \%tag_data);
455 # if breeding is empty
458 foreach my $subfield (sort(keys %{$tagslib->{$tag}})) {
459 next if (length $subfield !=1);
460 next if ((substr($tagslib->{$tag}->{$subfield}->{hidden},2,1) gt "1") ); #check for visibility flag
461 next if ($tagslib->{$tag}->{$subfield}->{tab} ne $tabloop);
462 push(@subfields_data, &create_input($tag,$subfield,'',$i,$tabloop,$xmlhash,$authorised_values_sth,$id));
465 if ($#subfields_data >= 0) {
467 $tag_data{tag} = $tag;
468 $tag_data{tag_lib} = $tagslib->{$tag}->{lib};
469 $tag_data{repeatable} = $tagslib->{$tag}->{repeatable};
470 $tag_data{indicator} = $indicator;
471 $tag_data{subfield_loop} = \@subfields_data;
472 $tag_data{tagfirstsubfield} = $tag_data{subfield_loop}[0];
474 $tag_data{fixedfield} = 1;
476 push (@loop_data, \%tag_data);
481 if ($#loop_data >=0) {
483 $big_loop_line{number}=$tabloop;
484 $big_loop_line{innerloop}=\@loop_data;
485 push @BIG_LOOP,\%big_loop_line;
487 $template->param(BIG_LOOP => \@BIG_LOOP);
492 sub build_hidden_data () {
493 # build hidden data =>
494 # we store everything, even if we show only requested subfields.
498 foreach my $tag (keys %{$tagslib}) {
499 my $previous_tag = '';
501 # loop through each subfield
502 foreach my $subfield (keys %{$tagslib->{$tag}}) {
503 next if ($subfield eq 'lib');
504 next if ($subfield eq 'tab');
505 next if ($subfield eq 'mandatory');
506 next if ($subfield eq 'repeatable');
507 next if ($tagslib->{$tag}->{$subfield}->{'tab'} ne "-1");
509 $subfield_data{marc_lib}=$tagslib->{$tag}->{$subfield}->{lib};
510 $subfield_data{marc_mandatory}=$tagslib->{$tag}->{$subfield}->{mandatory};
511 $subfield_data{marc_repeatable}=$tagslib->{$tag}->{$subfield}->{repeatable};
512 $subfield_data{marc_value}="<input type=\"hidden\" name=\"field_value[]\">";
513 push(@loop_data, \%subfield_data);
520 # ========================
522 #=========================
524 my $error = $input->param('error');
525 my $oldbiblionumber=$input->param('oldbiblionumber'); # if bib exists, it's a modif, not a new biblio.
526 my $breedingid = $input->param('breedingid');
527 my $z3950 = $input->param('z3950');
528 my $op = $input->param('op');
529 my $duplicateok = $input->param('duplicateok');
531 my $frameworkcode = $input->param('frameworkcode');
532 my $dbh = C4::Context->dbh;
535 $biblionumber=$oldbiblionumber if $oldbiblionumber;
537 $frameworkcode='' if ($frameworkcode eq 'Default');
538 my ($template, $loggedinuser, $cookie)
539 = get_template_and_user({template_name => "cataloguing/addbiblio.tmpl",
542 authnotrequired => 0,
543 flagsrequired => {editcatalogue => 1},
547 #Getting the list of all frameworks
548 my $queryfwk =$dbh->prepare("select frameworktext, frameworkcode from biblios_framework");
553 push @select_fwk,"Default";
554 $select_fwk{"Default"} = "Default";
555 while (my ($description, $fwk) =$queryfwk->fetchrow) {
556 push @select_fwk, $fwk;
557 $select_fwk{$fwk} = $description;
559 $curfwk=$frameworkcode;
560 my $framework=CGI::scrolling_list( -name => 'Frameworks',
563 -OnChange => 'Changefwk(this);',
564 -values => \@select_fwk,
565 -labels => \%select_fwk,
568 $template->param( framework => $framework);
571 #####DO NOT RETRIVE FROM ZEBRA######
572 my $record =XMLgetbiblio($dbh,$biblionumber) if ($biblionumber);
573 $xmlhash=XML_xml2hash_onerecord($record) if ($biblionumber);
574 $frameworkcode=MARCfind_frameworkcode( $dbh, $biblionumber );
576 $tagslib = &MARCgettagslib($dbh,1,$frameworkcode);
579 ($xmlhash,$encoding) = MARCfindbreeding($dbh,$breedingid,$oldbiblionumber) if ($breedingid);
582 $is_a_modif=1 if $oldbiblionumber;
583 my ($oldbiblionumtagfield,$oldbiblionumtagsubfield);
584 if ($biblionumber && !$z3950) {
586 # if it's a modif, retrieve old biblionumber for the future modification of old-DB.
587 ($oldbiblionumtagfield,$oldbiblionumtagsubfield) = &MARCfind_marc_from_kohafield($dbh,"biblionumber","biblios");
591 #------------------------------------------------------------------------------------------------------------------------------
592 if ($op eq "addbiblio") {
593 #------------------------------------------------------------------------------------------------------------------------------
595 my @tags = $input->param('tag');
596 my @subfields =$input->param('subfield');
597 my @values=$input->param('field_value');
598 # build indicator hash.
599 my @ind_tag = $input->param('ind_tag');
600 my @indicator = $input->param('indicator');
604 ## check for malformed xml -- non UTF-8 like (MARC8) will break xml without warning
605 ### This usually happens with data coming from other Z3950 servers
606 ## Slows the saving process so comment out at your own risk
608 $xml = MARChtml2xml(\@tags,\@subfields,\@values,\@indicator,\@ind_tag);
612 $template->param(error =>1,xmlerror=>1,);
615 my $xmlhash=XML_xml2hash_onerecord($xml);
616 my ($duplicatebiblionumber,$duplicatetitle) = FindDuplicate($xmlhash) if (($op eq "addbiblio") && (!$is_a_modif) && (!$duplicateok));
617 my $confirm_not_duplicate = $input->param('confirm_not_duplicate');
618 # it is not a duplicate (determined either by Koha itself or by user checking it's not a duplicate)
619 if (!$duplicatebiblionumber or $confirm_not_duplicate) {
620 # MARC::Record built => now, record in DB
624 NEWmodbiblio($dbh,$biblionumber,$xmlhash,$frameworkcode);
628 ($biblionumber) = NEWnewbiblio($dbh,$xmlhash,$frameworkcode);
631 # now, redirect to additem page
632 print $input->redirect("additem.pl?biblionumber=$biblionumber&frameworkcode=$frameworkcode");
636 # it may be a duplicate, warn the user and do nothing
637 build_tabs ($template, $xmlhash, $dbh);
640 oldbiblionumber => $oldbiblionumber,
641 biblionumber => $biblionumber,
642 oldbiblionumtagfield => $oldbiblionumtagfield,
643 oldbiblionumtagsubfield => $oldbiblionumtagsubfield,
644 duplicatebiblionumber => $duplicatebiblionumber,
645 duplicatetitle => $duplicatetitle,
648 #------------------------------------------------------------------------------------------------------------------------------
649 } elsif ($op eq "addfield") {
650 #------------------------------------------------------------------------------------------------------------------------------
651 my $addedfield = $input->param('addfield_field');
652 my @tags = $input->param('tag');
653 my @subfields = $input->param('subfield');
654 my @values = $input->param('field_value');
655 # build indicator hash.
656 my @ind_tag = $input->param('ind_tag');
657 my @indicator = $input->param('indicator');
658 my $xml = MARChtml2xml(\@tags,\@subfields,\@values,\@indicator,\@ind_tag);
659 my $xmlhash=XML_xml2hash_onerecord($xml);
660 # adding an empty field
661 build_tabs ($template, $xmlhash, $dbh,$addedfield);
664 oldbiblionumber => $oldbiblionumber,
665 biblionumber => $biblionumber,
666 oldbiblionumtagfield => $oldbiblionumtagfield,
667 oldbiblionumtagsubfield => $oldbiblionumtagsubfield,
669 } elsif ($op eq "delete") {
670 #------------------------------------------------------------------------------------------------------------------------------
671 my $sth=$dbh->prepare("select iss.itemnumber from items i ,issues iss where iss.itemnumber=i.itemnumber and iss.returndate is null and i.biblionumber=?");
672 $sth->execute($biblionumber);
673 my $onloan=$sth->fetchrow;
676 NEWdelbiblio($dbh,$biblionumber);
677 print $input->redirect("/cgi-bin/koha/catalogue/catalogue-search.pl");
681 $template->param(error => 1, onloan=>1,);
685 #------------------------------------------------------------------------------------------------------------------------------
686 #------------------------------------------------------------------------------------------------------------------------------
688 #------------------------------------------------------------------------------------------------------------------------------
690 # If we're in a duplication case, we have to set to "" the biblionumber
691 # as we'll save the biblio as a new one.
692 if ($op eq "duplicate")
695 $oldbiblionumber= "";
696 $template->param(duplicateok => 1);
698 build_tabs ($template, $xmlhash, $dbh);
701 oldbiblionumber => $oldbiblionumber,
702 biblionumber => $biblionumber,
703 oldbiblionumtagfield => $oldbiblionumtagfield,
704 oldbiblionumtagsubfield => $oldbiblionumtagsubfield
712 titletag => $titletag,
713 titlesub => $titlesub,
714 authortag => $authortag,
715 authorsub => $authorsub,
719 frameworkcode => $frameworkcode,
720 itemtype => $frameworkcode, # HINT: if the library has itemtype = framework, itemtype is auto filled !
721 hide_marc => C4::Context->preference('hide_marc'),
722 intranetcolorstylesheet => C4::Context->preference("intranetcolorstylesheet"),
723 intranetstylesheet => C4::Context->preference("intranetstylesheet"),
724 IntranetNav => C4::Context->preference("IntranetNav"),
725 advancedMARCEditor => C4::Context->preference("advancedMARCEditor"),
728 output_html_with_http_headers $input, $cookie, $template->output;