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
28 use C4::AuthoritiesMarc;
32 use C4::Koha; # XXX subfield_is_koha_internal_p
33 use Date::Calc qw(Today);
34 use MARC::File::USMARC;
37 if ( C4::Context->preference('marcflavour') eq 'UNIMARC' ) {
38 MARC::File::XML->default_record_format('UNIMARC');
41 our($tagslib,$authorised_values_sth,$is_a_modif,$usedTagsLib,$mandatory_z3950);
43 =item MARCfindbreeding
45 $record = MARCfindbreeding($dbh, $breedingid);
47 Look up the breeding farm with database handle $dbh, for the
48 record with id $breedingid. If found, returns the decoded
49 MARC::Record; otherwise, -1 is returned (FIXME).
50 Returns as second parameter the character encoding.
54 sub MARCfindbreeding {
55 my ( $dbh, $id ) = @_;
57 $dbh->prepare("select file,marc,encoding from marc_breeding where id=?");
59 my ( $file, $marc, $encoding ) = $sth->fetchrow;
61 my $record = MARC::Record->new_from_usmarc($marc);
62 if ( $record->field('010') ) {
63 foreach my $field ( $record->field('010') ) {
64 foreach my $subfield ( $field->subfield('a') ) {
65 my $newisbn = $field->subfield('a');
67 $field->update( 'a' => $newisbn );
69 # record->insert_fields_ordered($record->field('010'));
73 if ($record->subfield(100,'a')) {
74 my $f100a=$record->subfield(100,'a');
75 my $f100 = $record->field(100);
76 my $f100temp = $f100->as_string;
77 $record->delete_field($f100);
78 if ( length($f100temp) > 28 ) {
79 substr( $f100temp, 26, 2, "50" );
80 $f100->update( 'a' => $f100temp );
81 my $f100 = MARC::Field->new( '100', '', '', 'a' => $f100temp );
82 $record->insert_fields_ordered($f100);
86 if ( ref($record) eq undef ) {
90 if ( C4::Context->preference("z3950NormalizeAuthor")
91 and C4::Context->preference("z3950AuthorAuthFields") )
93 my ( $tag, $subfield ) = GetMarcFromKohaField("biblio.author");
95 # my $summary = C4::Context->preference("z3950authortemplate");
97 C4::Context->preference("z3950AuthorAuthFields");
98 my @auth_fields = split /,/, $auth_fields;
101 if ( $record->field($tag) ) {
102 foreach my $tmpfield ( $record->field($tag)->subfields ) {
104 # foreach my $subfieldcode ($tmpfield->subfields){
105 my $subfieldcode = shift @$tmpfield;
106 my $subfieldvalue = shift @$tmpfield;
108 $field->add_subfields(
109 "$subfieldcode" => $subfieldvalue )
110 if ( $subfieldcode ne $subfield );
114 MARC::Field->new( $tag, "", "",
115 $subfieldcode => $subfieldvalue )
116 if ( $subfieldcode ne $subfield );
120 $record->delete_field( $record->field($tag) );
121 foreach my $fieldtag (@auth_fields) {
122 next unless ( $record->field($fieldtag) );
123 my $lastname = $record->field($fieldtag)->subfield('a');
124 my $firstname = $record->field($fieldtag)->subfield('b');
125 my $title = $record->field($fieldtag)->subfield('c');
126 my $number = $record->field($fieldtag)->subfield('d');
129 # $field->add_subfields("$subfield"=>"[ ".ucfirst($title).ucfirst($firstname)." ".$number." ]");
130 $field->add_subfields(
131 "$subfield" => ucfirst($title) . " "
132 . ucfirst($firstname) . " "
137 # $field->add_subfields("$subfield"=>"[ ".ucfirst($firstname).", ".ucfirst($lastname)." ]");
138 $field->add_subfields(
139 "$subfield" => ucfirst($firstname) . ", "
140 . ucfirst($lastname) );
143 $record->insert_fields_ordered($field);
145 return $record, $encoding;
151 =item build_authorized_values_list
155 sub build_authorized_values_list ($$$$$$$) {
156 my ( $tag, $subfield, $value, $dbh, $authorised_values_sth,$index_tag,$index_subfield ) = @_;
158 my @authorised_values;
161 # builds list, depending on authorised value...
164 if ( $tagslib->{$tag}->{$subfield}->{'authorised_value'} eq "branches" ) {
167 "select branchcode,branchname from branches order by branchname");
169 push @authorised_values, ""
170 unless ( $tagslib->{$tag}->{$subfield}->{mandatory} );
172 while ( my ( $branchcode, $branchname ) = $sth->fetchrow_array ) {
173 push @authorised_values, $branchcode;
174 $authorised_lib{$branchcode} = $branchname;
179 elsif ( $tagslib->{$tag}->{$subfield}->{authorised_value} eq "itemtypes" ) {
182 "select itemtype,description from itemtypes order by description");
184 push @authorised_values, ""
185 unless ( $tagslib->{$tag}->{$subfield}->{mandatory} );
189 while ( my ( $itemtype, $description ) = $sth->fetchrow_array ) {
190 push @authorised_values, $itemtype;
191 $authorised_lib{$itemtype} = $description;
193 $value = $itemtype unless ($value);
195 #---- "true" authorised value
198 $authorised_values_sth->execute(
199 $tagslib->{$tag}->{$subfield}->{authorised_value} );
201 push @authorised_values, ""
202 unless ( $tagslib->{$tag}->{$subfield}->{mandatory} );
204 while ( my ( $value, $lib ) = $authorised_values_sth->fetchrow_array ) {
205 push @authorised_values, $value;
206 $authorised_lib{$value} = $lib;
209 return CGI::scrolling_list(
210 -name => "tag_".$tag."_subfield_".$subfield."_".$index_tag."_".$index_subfield,
211 -values => \@authorised_values,
213 -labels => \%authorised_lib,
218 -id => "tag_".$tag."_subfield_".$subfield."_".$index_tag."_".$index_subfield,
219 -class => "input_marceditor",
225 Create a random value to set it into the input name
230 return int(rand(1000000));
233 =item GetMandatoryFieldZ3950
235 This function return an hashref which containts all mandatory field
236 to search with z3950 server.
240 sub GetMandatoryFieldZ3950($){
241 my $frameworkcode = shift;
242 my @isbn = GetMarcFromKohaField('biblioitems.isbn',$frameworkcode);
243 my @title = GetMarcFromKohaField('biblio.title',$frameworkcode);
244 my @author = GetMarcFromKohaField('biblio.author',$frameworkcode);
245 my @issn = GetMarcFromKohaField('biblioitems.issn',$frameworkcode);
248 $isbn[0].$isbn[1] => 'isbn',
249 $title[0].$title[1] => 'title',
250 $author[0].$author[1] => 'author',
251 $issn[0].$issn[1] => 'issn',
257 builds the <input ...> entry for a subfield.
262 my ( $tag, $subfield, $value, $index_tag, $tabloop, $rec, $authorised_values_sth,$cgi ) = @_;
264 my $index_subfield = CreateKey(); # create a specifique key for each subfield
266 $value =~ s/"/"/g;
268 # if there is no value provided but a default value in parameters, get it
270 $value = $tagslib->{$tag}->{$subfield}->{defaultvalue};
272 # get today date & replace YYYY, MM, DD if provided in the default value
273 my ( $year, $month, $day ) = Today();
274 $month = sprintf( "%02d", $month );
275 $day = sprintf( "%02d", $day );
276 $value =~ s/YYYY/$year/g;
277 $value =~ s/MM/$month/g;
278 $value =~ s/DD/$day/g;
280 my $dbh = C4::Context->dbh;
281 my %subfield_data = (
283 subfield => $subfield,
284 marc_lib => substr( $tagslib->{$tag}->{$subfield}->{lib}, 0, 22 ),
285 marc_lib_plain => $tagslib->{$tag}->{$subfield}->{lib},
286 tag_mandatory => $tagslib->{$tag}->{mandatory},
287 mandatory => $tagslib->{$tag}->{$subfield}->{mandatory},
288 repeatable => $tagslib->{$tag}->{$subfield}->{repeatable},
289 kohafield => $tagslib->{$tag}->{$subfield}->{kohafield},
291 id => "tag_".$tag."_subfield_".$subfield."_".$index_tag."_".$index_subfield,
294 if($subfield eq '@'){
295 $subfield_data{id} = "tag_".$tag."_subfield_00_".$index_tag."_".$index_subfield;
297 $subfield_data{id} = "tag_".$tag."_subfield_".$subfield."_".$index_tag."_".$index_subfield;
300 if(exists $mandatory_z3950->{$tag.$subfield}){
301 $subfield_data{z3950_mandatory} = $mandatory_z3950->{$tag.$subfield};
304 $subfield_data{visibility} = "display:none;"
305 if ( ($tagslib->{$tag}->{$subfield}->{hidden} % 2 == 1) and $value ne ''
306 or ($value eq '' and !$tagslib->{$tag}->{$subfield}->{mandatory})
309 # it's an authorised field
310 if ( $tagslib->{$tag}->{$subfield}->{authorised_value} ) {
311 $subfield_data{marc_value} =
312 build_authorized_values_list( $tag, $subfield, $value, $dbh,
313 $authorised_values_sth,$index_tag,$index_subfield );
315 # it's a thesaurus / authority field
317 elsif ( $tagslib->{$tag}->{$subfield}->{authtypecode} ) {
318 $subfield_data{marc_value} =
319 "<input type=\"text\"
320 id=".$subfield_data{id}."
321 name=".$subfield_data{id}."
323 class=\"input_marceditor\"
326 <span class=\"buttonDot\"
327 onclick=\"Dopop('/cgi-bin/koha/authorities/auth_finder.pl?authtypecode=".$tagslib->{$tag}->{$subfield}->{authtypecode}."&index=$subfield_data{id}','$subfield_data{id}')\">...</span>
329 # it's a plugin field
331 elsif ( $tagslib->{$tag}->{$subfield}->{'value_builder'} ) {
333 # opening plugin. Just check wether we are on a developper computer on a production one
334 # (the cgidir differs)
335 my $cgidir = C4::Context->intranetdir . "/cgi-bin/cataloguing/value_builder";
336 unless ( opendir( DIR, "$cgidir" ) ) {
337 $cgidir = C4::Context->intranetdir . "/cataloguing/value_builder";
339 my $plugin = $cgidir . "/" . $tagslib->{$tag}->{$subfield}->{'value_builder'};
340 do $plugin || die "Plugin Failed: ".$plugin;
341 my $extended_param = plugin_parameters( $dbh, $rec, $tagslib, $subfield_data{id}, $tabloop );
342 my ( $function_name, $javascript ) = plugin_javascript( $dbh, $rec, $tagslib, $subfield_data{id}, $tabloop );
343 # my ( $function_name, $javascript,$extended_param );
345 $subfield_data{marc_value} =
346 "<input tabindex=\"1\"
348 id=".$subfield_data{id}."
349 name=".$subfield_data{id}."
351 class=\"input_marceditor\"
352 onfocus=\"javascript:Focus$function_name($index_tag)\"
353 onblur=\"javascript:Blur$function_name($index_tag); \" \/>
354 <span class=\"buttonDot\"
355 onclick=\"Clic$function_name('$subfield_data{id}')\">...</a>
357 # it's an hidden field
359 elsif ( $tag eq '' ) {
360 $subfield_data{marc_value} =
361 "<input tabindex=\"1\"
363 id=".$subfield_data{id}."
364 name=".$subfield_data{id}."
368 elsif ( $tagslib->{$tag}->{$subfield}->{'hidden'} ) {
369 $subfield_data{marc_value} =
370 "<input type=\"text\"
371 id=".$subfield_data{id}."
372 name=".$subfield_data{id}."
373 class=\"input_marceditor\"
378 # it's a standard field
384 ( C4::Context->preference("marcflavour") eq "UNIMARC" && $tag >= 300
385 and $tag < 400 && $subfield eq 'a' )
388 && C4::Context->preference("marcflavour") eq "MARC21" )
391 $subfield_data{marc_value} =
392 "<textarea cols=\"70\"
394 id=".$subfield_data{id}."
395 name=".$subfield_data{id}."
396 class=\"input_marceditor\"
402 $subfield_data{marc_value} =
403 "<input type=\"text\"
404 id=".$subfield_data{id}."
405 name=".$subfield_data{id}."
408 class=\"input_marceditor\"
413 $subfield_data{'index_subfield'} = $index_subfield;
414 return \%subfield_data;
417 sub build_tabs ($$$$$) {
418 my ( $template, $record, $dbh, $encoding,$input ) = @_;
424 my $authorised_values_sth = $dbh->prepare(
425 "select authorised_value,lib
426 from authorised_values
427 where category=? order by lib"
430 # in this array, we will push all the 10 tabs
431 # to avoid having 10 tabs in the template : they will all be in the same BIG_LOOP
434 my @tab_data; # all tags to display
436 foreach my $used ( @$usedTagsLib ){
437 push @tab_data,$used->{tagfield} if not $seen{$used->{tagfield}};
438 $seen{$used->{tagfield}}++;
442 foreach(@$usedTagsLib){
443 if($_->{tab} > -1 && $_->{tab} >= $max_num_tab && $_->{tagfield} != '995'){ # FIXME : MARC21 ?
444 $max_num_tab = $_->{tab};
447 if($max_num_tab >= 9){
450 # loop through each tab 0 through 9
451 for ( my $tabloop = 0 ; $tabloop <= $max_num_tab ; $tabloop++ ) {
452 my @loop_data = (); #innerloop in the template.
454 foreach my $tag (@tab_data) {
458 my $index_tag = CreateKey;
460 # if MARC::Record is not empty =>use it as master loop, then add missing subfields that should be in the tab.
461 # if MARC::Record is empty => use tab as master loop.
462 if ( $record ne -1 && ( $record->field($tag) || $tag eq '000' ) ) {
464 if ( $tag ne '000' ) {
465 @fields = $record->field($tag);
468 push @fields, $record->leader(); # if tag == 000
470 foreach my $field (@fields) {
474 my ( $value, $subfield );
475 if ( $tag ne '000' ) {
476 $value = $field->data();
483 next if ( $tagslib->{$tag}->{$subfield}->{tab} ne $tabloop );
485 if ( $tagslib->{$tag}->{$subfield}->{kohafield} eq
486 'biblio.biblionumber' );
490 $tag, $subfield, $value, $index_tag, $tabloop, $record,
491 $authorised_values_sth,$input
496 my @subfields = $field->subfields();
497 foreach my $subfieldcount ( 0 .. $#subfields ) {
498 my $subfield = $subfields[$subfieldcount][0];
499 my $value = $subfields[$subfieldcount][1];
500 next if ( length $subfield != 1 );
501 next if ( $tagslib->{$tag}->{$subfield}->{tab} ne $tabloop );
505 $tag, $subfield, $value, $index_tag, $tabloop,
506 $record, $authorised_values_sth,$input
512 # now, loop again to add parameter subfield that are not in the MARC::Record
513 foreach my $subfield ( sort( keys %{ $tagslib->{$tag} } ) )
515 next if ( length $subfield != 1 );
516 next if ( $tagslib->{$tag}->{$subfield}->{tab} ne $tabloop );
517 next if ( $tag < 10 );
519 if ( ( $tagslib->{$tag}->{$subfield}->{hidden} <= -4 )
520 or ( $tagslib->{$tag}->{$subfield}->{hidden} >= 5 )
521 ); #check for visibility flag
522 next if ( defined( $field->subfield($subfield) ) );
526 $tag, $subfield, '', $index_tag, $tabloop, $record,
527 $authorised_values_sth,$input
531 if ( $#subfields_data >= 0 ) {
535 tag_lib => $tagslib->{$tag}->{lib},
536 subfield_loop => \@subfields_data,
537 fixedfield => ($tag < 10)?(1):(0),
539 if ($tag >= 010){ # no indicator for theses tag
540 $tag_data{indicator} = $field->indicator(1).$field->indicator(2);
542 push( @loop_data, \%tag_data );
544 } # foreach $field end
546 # if breeding is empty
550 foreach my $subfield ( sort( keys %{ $tagslib->{$tag} } ) ) {
551 next if ( length $subfield != 1 );
553 if ( ( $tagslib->{$tag}->{$subfield}->{hidden} <= -5 )
554 or ( $tagslib->{$tag}->{$subfield}->{hidden} >= 4 ) )
555 ; #check for visibility flag
557 if ( $tagslib->{$tag}->{$subfield}->{tab} ne $tabloop );
561 $tag, $subfield, '', $index_tag, $tabloop, $record,
562 $authorised_values_sth,$input
566 if ( $#subfields_data >= 0 ) {
570 tag_lib => $tagslib->{$tag}->{lib},
571 repeatable => $tagslib->{$tag}->{repeatable},
572 indicator => $indicator,
573 subfield_loop => \@subfields_data,
574 tagfirstsubfield => $subfields_data[0],
575 fixedfield => ($tag < 10)?(1):(0)
578 push @loop_data, \%tag_data ;
582 if ( $#loop_data >= 0 ) {
585 innerloop => \@loop_data,
589 $template->param( BIG_LOOP => \@BIG_LOOP );
592 # ========================
594 #=========================
596 my $error = $input->param('error');
597 my $biblionumber = $input->param('biblionumber'); # if biblionumber exists, it's a modif, not a new biblio.
598 my $breedingid = $input->param('breedingid');
599 my $z3950 = $input->param('z3950');
600 my $op = $input->param('op');
601 my $mode = $input->param('mode');
602 my $frameworkcode = $input->param('frameworkcode');
603 my $dbh = C4::Context->dbh;
605 $frameworkcode = &GetFrameworkCode($biblionumber)
606 if ( $biblionumber and not($frameworkcode) );
608 $frameworkcode = '' if ( $frameworkcode eq 'Default' );
609 my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
611 template_name => "cataloguing/addbiblio.tmpl",
614 authnotrequired => 0,
615 flagsrequired => { editcatalogue => 1 },
619 #Getting the list of all frameworks
620 my $queryfwk = $dbh->prepare("select frameworktext, frameworkcode from biblio_framework");
625 push @select_fwk, "Default";
626 $select_fwk{"Default"} = "Default";
628 while ( my ( $description, $fwk ) = $queryfwk->fetchrow ) {
629 push @select_fwk, $fwk;
630 $select_fwk{$fwk} = $description;
632 $curfwk = $frameworkcode;
633 my $framework = CGI::scrolling_list(
634 -name => 'Frameworks',
637 -OnChange => 'Changefwk(this);',
638 -values => \@select_fwk,
639 -labels => \%select_fwk,
643 $template->param( framework => $framework, breedingid => $breedingid );
646 $tagslib = &GetMarcStructure( 1, $frameworkcode );
647 $usedTagsLib = &GetUsedMarcStructure( $frameworkcode );
648 $mandatory_z3950 = GetMandatoryFieldZ3950($frameworkcode);
655 $biblionumtagsubfield,
656 $biblioitemnumtagfield,
657 $biblioitemnumtagsubfield,
662 if (($biblionumber) && !($breedingid)){
663 $record = GetMarcBiblio($biblionumber);
666 ( $record, $encoding ) = MARCfindbreeding( $dbh, $breedingid ) ;
674 # if it's a modif, retrieve bibli and biblioitem numbers for the future modification of old-DB.
675 ( $biblionumtagfield, $biblionumtagsubfield ) =
676 &GetMarcFromKohaField( "biblio.biblionumber", $frameworkcode );
677 ( $biblioitemnumtagfield, $biblioitemnumtagsubfield ) =
678 &GetMarcFromKohaField( "biblioitems.biblioitemnumber", $frameworkcode );
680 # search biblioitems value
681 my $sth = $dbh->prepare("select biblioitemnumber from biblioitems where biblionumber=?");
682 $sth->execute($biblionumber);
683 ($biblioitemnumber) = $sth->fetchrow;
686 #-------------------------------------------------------------------------------------
687 if ( $op eq "addbiblio" ) {
688 #-------------------------------------------------------------------------------------
690 my @params = $input->param();
691 $record = TransformHtmlToMarc( \@params , $input );
692 # check for a duplicate
693 my ($duplicatebiblionumber,$duplicatetitle) = FindDuplicate($record) if (!$is_a_modif);
694 my $confirm_not_duplicate = $input->param('confirm_not_duplicate');
695 # it is not a duplicate (determined either by Koha itself or by user checking it's not a duplicate)
696 if ( !$duplicatebiblionumber or $confirm_not_duplicate ) {
700 ModBiblioframework( $biblionumber, $frameworkcode );
701 ModBiblio( $record, $biblionumber, $frameworkcode );
704 ( $biblionumber, $oldbibitemnum ) = AddBiblio( $record, $frameworkcode );
707 if (C4::Context->preference("BiblioAddsAuthorities")){
708 my ($countlinked,$countcreated)=BiblioAddAuthorities($record,$frameworkcode);
711 if ($mode ne "popup"){
712 print $input->redirect(
713 "/cgi-bin/koha/cataloguing/additem.pl?biblionumber=$biblionumber&frameworkcode=$frameworkcode"
718 biblionumber => $biblionumber,
722 $template->param( title => $record->subfield('200',"a") ) if ($record ne "-1" && C4::Context->preference('marcflavour') =~/unimarc/i);
723 $template->param( title => $record->title() ) if ($record ne "-1" && C4::Context->preference('marcflavour') eq "usmarc");
726 itemtype => $frameworkcode,
728 output_html_with_http_headers $input, $cookie, $template->output;
732 # it may be a duplicate, warn the user and do nothing
733 build_tabs ($template, $record, $dbh,$encoding,$input);
735 biblionumber => $biblionumber,
736 biblionumtagfield => $biblionumtagfield,
737 biblionumtagsubfield => $biblionumtagsubfield,
738 biblioitemnumtagfield => $biblioitemnumtagfield,
739 biblioitemnumtagsubfield => $biblioitemnumtagsubfield,
740 biblioitemnumber => $biblioitemnumber,
741 duplicatebiblionumber => $duplicatebiblionumber,
742 duplicatebibid => $duplicatebiblionumber,
743 duplicatetitle => $duplicatetitle,
747 elsif ( $op eq "delete" ) {
749 my $error = &DelBiblio($biblionumber);
751 warn "ERROR when DELETING BIBLIO $biblionumber : $error";
752 print "Content-Type: text/html\n\n<html><body><h1>ERROR when DELETING BIBLIO $biblionumber : $error</h1></body></html>";
756 print $input->redirect('/cgi-bin/koha/catalogue/search.pl');
760 #----------------------------------------------------------------------------
761 # If we're in a duplication case, we have to set to "" the biblionumber
762 # as we'll save the biblio as a new one.
763 if ( $op eq "duplicate" ) {
767 #FIXME: it's kind of silly to go from MARC::Record to MARC::File::XML and then back again just to fix the encoding
769 my $uxml = $record->as_xml;
770 MARC::Record::default_record_format("UNIMARC")
771 if ( C4::Context->preference("marcflavour") eq "UNIMARC" );
772 my $urecord = MARC::Record::new_from_xml( $uxml, 'UTF-8' );
775 build_tabs( $template, $record, $dbh, $encoding,$input );
777 biblionumber => $biblionumber,
778 biblionumtagfield => $biblionumtagfield,
779 biblionumtagsubfield => $biblionumtagsubfield,
780 biblioitemnumtagfield => $biblioitemnumtagfield,
781 biblioitemnumtagsubfield => $biblioitemnumtagsubfield,
782 biblioitemnumber => $biblioitemnumber,
786 $template->param( title => $record->title() ) if ( $record ne "-1" );
789 frameworkcode => $frameworkcode,
790 itemtype => $frameworkcode,
793 output_html_with_http_headers $input, $cookie, $template->output;