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::AuthoritiesMarc;
28 use C4::Koha; # XXX subfield_is_koha_internal_p
29 use Date::Calc qw(Today);
30 use MARC::File::USMARC;
33 use vars qw( $tagslib);
34 use vars qw( $authorised_values_sth);
35 use vars qw( $is_a_modif );
37 my $itemtype; # created here because it can be used in build_authorized_values_list sub
38 our($authorised_values_sth,$is_a_modif,$usedTagsLib,$mandatory_z3950);
41 ($indicators, $value) = find_value($tag, $subfield, $record,$encoding);
43 Find the given $subfield in the given $tag in the given
44 MARC::Record $record. If the subfield is found, returns
45 the (indicators, value) pair; otherwise, (undef, undef) is
51 my ($tagfield,$insubfield,$record,$encoding) = @_;
55 if ($record->field($tagfield)) {
56 push @result, $record->field($tagfield)->data();
61 foreach my $field ($record->field($tagfield)) {
62 my @subfields = $field->subfields();
63 foreach my $subfield (@subfields) {
64 if (@$subfield[0] eq $insubfield) {
65 push @result,@$subfield[1];
66 $indicator = $field->indicator(1).$field->indicator(2);
71 return($indicator,@result);
75 =item build_authorized_values_list
79 sub build_authorized_values_list ($$$$$$$) {
80 my ( $tag, $subfield, $value, $dbh, $authorised_values_sth,$index_tag,$index_subfield ) = @_;
82 my @authorised_values;
85 # builds list, depending on authorised value...
88 if ( $tagslib->{$tag}->{$subfield}->{'authorised_value'} eq "branches" ) {
91 "select branchcode,branchname from branches order by branchname");
93 push @authorised_values, ""
94 unless ( $tagslib->{$tag}->{$subfield}->{mandatory} );
96 while ( my ( $branchcode, $branchname ) = $sth->fetchrow_array ) {
97 push @authorised_values, $branchcode;
98 $authorised_lib{$branchcode} = $branchname;
103 elsif ( $tagslib->{$tag}->{$subfield}->{authorised_value} eq "itemtypes" ) {
106 "select itemtype,description from itemtypes order by description");
108 push @authorised_values, ""
109 unless ( $tagslib->{$tag}->{$subfield}->{mandatory} );
113 while ( my ( $itemtype, $description ) = $sth->fetchrow_array ) {
114 push @authorised_values, $itemtype;
115 $authorised_lib{$itemtype} = $description;
117 $value = $itemtype unless ($value);
119 #---- "true" authorised value
122 $authorised_values_sth->execute(
123 $tagslib->{$tag}->{$subfield}->{authorised_value} );
125 push @authorised_values, ""
126 unless ( $tagslib->{$tag}->{$subfield}->{mandatory} );
128 while ( my ( $value, $lib ) = $authorised_values_sth->fetchrow_array ) {
129 push @authorised_values, $value;
130 $authorised_lib{$value} = $lib;
133 return CGI::scrolling_list(
134 -name => "tag_".$tag."_subfield_".$subfield."_".$index_tag."_".$index_subfield,
135 -values => \@authorised_values,
137 -labels => \%authorised_lib,
142 -id => "tag_".$tag."_subfield_".$subfield."_".$index_tag."_".$index_subfield,
143 -class => "input_marceditor",
149 builds the <input ...> entry for a subfield.
153 my ( $tag, $subfield, $value, $index_tag, $tabloop, $rec, $authorised_values_sth,$cgi ) = @_;
155 my $index_subfield = CreateKey(); # create a specifique key for each subfield
157 $value =~ s/"/"/g;
159 # if there is no value provided but a default value in parameters, get it
161 $value = $tagslib->{$tag}->{$subfield}->{defaultvalue};
163 # get today date & replace YYYY, MM, DD if provided in the default value
164 my ( $year, $month, $day ) = Today();
165 $month = sprintf( "%02d", $month );
166 $day = sprintf( "%02d", $day );
167 $value =~ s/YYYY/$year/g;
168 $value =~ s/MM/$month/g;
169 $value =~ s/DD/$day/g;
171 my $dbh = C4::Context->dbh;
172 my %subfield_data = (
174 subfield => $subfield,
175 marc_lib => substr( $tagslib->{$tag}->{$subfield}->{lib}, 0, 22 ),
176 marc_lib_plain => $tagslib->{$tag}->{$subfield}->{lib},
177 tag_mandatory => $tagslib->{$tag}->{mandatory},
178 mandatory => $tagslib->{$tag}->{$subfield}->{mandatory},
179 repeatable => $tagslib->{$tag}->{$subfield}->{repeatable},
180 kohafield => $tagslib->{$tag}->{$subfield}->{kohafield},
182 id => "tag_".$tag."_subfield_".$subfield."_".$index_tag."_".$index_subfield,
185 if($subfield eq '@'){
186 $subfield_data{id} = "tag_".$tag."_subfield_00_".$index_tag."_".$index_subfield;
188 $subfield_data{id} = "tag_".$tag."_subfield_".$subfield."_".$index_tag."_".$index_subfield;
191 if(exists $mandatory_z3950->{$tag.$subfield}){
192 $subfield_data{z3950_mandatory} = $mandatory_z3950->{$tag.$subfield};
195 $subfield_data{visibility} = "display:none;"
196 if ( ($tagslib->{$tag}->{$subfield}->{hidden} % 2 == 1) and $value ne ''
197 or ($value eq '' and !$tagslib->{$tag}->{$subfield}->{mandatory})
200 # it's an authorised field
201 if ( $tagslib->{$tag}->{$subfield}->{authorised_value} ) {
202 $subfield_data{marc_value} =
203 build_authorized_values_list( $tag, $subfield, $value, $dbh,
204 $authorised_values_sth,$index_tag,$index_subfield );
206 # it's a thesaurus / authority field
208 elsif ( $tagslib->{$tag}->{$subfield}->{authtypecode} ) {
209 $subfield_data{marc_value} =
210 "<input type=\"text\"
211 id=\"".$subfield_data{id}."\"
212 name=\"".$subfield_data{id}."\"
214 class=\"input_marceditor\"
217 <span class=\"buttonDot\"
218 onclick=\"Dopop('/cgi-bin/koha/authorities/auth_finder.pl?authtypecode=".$tagslib->{$tag}->{$subfield}->{authtypecode}."&index=$subfield_data{id}','$subfield_data{id}')\">...</span>
220 # it's a plugin field
222 elsif ( $tagslib->{$tag}->{$subfield}->{'value_builder'} ) {
224 # opening plugin. Just check wether we are on a developper computer on a production one
225 # (the cgidir differs)
226 my $cgidir = C4::Context->intranetdir . "/cgi-bin/cataloguing/value_builder";
227 unless ( opendir( DIR, "$cgidir" ) ) {
228 $cgidir = C4::Context->intranetdir . "/cataloguing/value_builder";
230 my $plugin = $cgidir . "/" . $tagslib->{$tag}->{$subfield}->{'value_builder'};
231 do $plugin || die "Plugin Failed: ".$plugin;
232 my $extended_param = plugin_parameters( $dbh, $rec, $tagslib, $subfield_data{id}, $tabloop );
233 my ( $function_name, $javascript ) = plugin_javascript( $dbh, $rec, $tagslib, $subfield_data{id}, $tabloop );
234 # my ( $function_name, $javascript,$extended_param );
236 $subfield_data{marc_value} =
237 "<input tabindex=\"1\"
239 id=".$subfield_data{id}."
240 name=".$subfield_data{id}."
242 class=\"input_marceditor\"
243 onfocus=\"javascript:Focus$function_name($index_tag)\"
244 onblur=\"javascript:Blur$function_name($index_tag); \" \/>
245 <span class=\"buttonDot\"
246 onclick=\"Clic$function_name('$subfield_data{id}')\">...</a>
248 # it's an hidden field
250 elsif ( $tag eq '' ) {
251 $subfield_data{marc_value} =
252 "<input tabindex=\"1\"
254 id=".$subfield_data{id}."
255 name=".$subfield_data{id}."
259 elsif ( $tagslib->{$tag}->{$subfield}->{'hidden'} ) {
260 $subfield_data{marc_value} =
261 "<input type=\"text\"
262 id=".$subfield_data{id}."
263 name=".$subfield_data{id}."
264 class=\"input_marceditor\"
269 # it's a standard field
275 ( C4::Context->preference("marcflavour") eq "UNIMARC" && $tag >= 300
276 and $tag < 400 && $subfield eq 'a' )
279 && C4::Context->preference("marcflavour") eq "MARC21" )
282 $subfield_data{marc_value} =
283 "<textarea cols=\"70\"
285 id=".$subfield_data{id}."
286 name=".$subfield_data{id}."
287 class=\"input_marceditor\"
293 $subfield_data{marc_value} =
294 "<input type=\"text\"
295 id=".$subfield_data{id}."
296 name=".$subfield_data{id}."
299 class=\"input_marceditor\"
304 $subfield_data{'index_subfield'} = $index_subfield;
305 return \%subfield_data;
310 Create a random value to set it into the input name
315 return int(rand(1000000));
318 sub build_tabs ($$$$$) {
319 my ( $template, $record, $dbh, $encoding,$input ) = @_;
325 my $authorised_values_sth = $dbh->prepare(
326 "select authorised_value,lib
327 from authorised_values
328 where category=? order by lib"
331 # in this array, we will push all the 10 tabs
332 # to avoid having 10 tabs in the template : they will all be in the same BIG_LOOP
335 my @tab_data; # all tags to display
337 foreach my $used ( keys %$tagslib ){
338 push @tab_data,$used if not $seen{$used};
343 # loop through each tab 0 through 9
344 for ( my $tabloop = 0 ; $tabloop <= $max_num_tab ; $tabloop++ ) {
345 my @loop_data = (); #innerloop in the template.
347 foreach my $tag (@tab_data) {
351 my $index_tag = CreateKey;
353 # if MARC::Record is not empty =>use it as master loop, then add missing subfields that should be in the tab.
354 # if MARC::Record is empty => use tab as master loop.
355 if ( $record ne -1 && ( $record->field($tag) || $tag eq '000' ) ) {
357 if ( $tag ne '000' ) {
358 @fields = $record->field($tag);
361 push @fields, $record->leader(); # if tag == 000
363 # loop through each field
364 foreach my $field (@fields) {
368 my ( $value, $subfield );
369 if ( $tag ne '000' ) {
370 $value = $field->data();
377 next if ( $tagslib->{$tag}->{$subfield}->{tab} ne $tabloop );
379 if ( $tagslib->{$tag}->{$subfield}->{kohafield} eq
380 'biblio.biblionumber' );
384 $tag, $subfield, $value, $index_tag, $tabloop, $record,
385 $authorised_values_sth,$input
390 my @subfields = $field->subfields();
391 foreach my $subfieldcount ( 0 .. $#subfields ) {
392 my $subfield = $subfields[$subfieldcount][0];
393 my $value = $subfields[$subfieldcount][1];
394 next if ( length $subfield != 1 );
395 next if ( $tagslib->{$tag}->{$subfield}->{tab} ne $tabloop );
399 $tag, $subfield, $value, $index_tag, $tabloop,
400 $record, $authorised_values_sth,$input
406 # now, loop again to add parameter subfield that are not in the MARC::Record
407 foreach my $subfield ( sort( keys %{ $tagslib->{$tag} } ) )
409 next if ( length $subfield != 1 );
410 next if ( $tagslib->{$tag}->{$subfield}->{tab} ne $tabloop );
411 next if ( $tag < 10 );
413 if ( ( $tagslib->{$tag}->{$subfield}->{hidden} <= -4 )
414 or ( $tagslib->{$tag}->{$subfield}->{hidden} >= 5 )
415 ); #check for visibility flag
416 next if ( defined( $field->subfield($subfield) ) );
420 $tag, $subfield, '', $index_tag, $tabloop, $record,
421 $authorised_values_sth,$input
425 if ( $#subfields_data >= 0 ) {
426 # build the tag entry.
427 # note that the random() field is mandatory. Otherwise, on repeated fields, you'll
428 # have twice the same "name" value, and cgi->param() will return only one, making
429 # all subfields to be merged in a single field.
433 tag_lib => $tagslib->{$tag}->{lib},
434 repeatable => $tagslib->{$tag}->{repeatable},
435 subfield_loop => \@subfields_data,
436 fixedfield => ($tag < 10)?(1):(0),
439 if ($tag >= 010){ # no indicator for theses tag
440 $tag_data{indicator} = $field->indicator(1).$field->indicator(2);
442 push( @loop_data, \%tag_data );
444 } # foreach $field end
446 # if breeding is empty
450 foreach my $subfield ( sort( keys %{ $tagslib->{$tag} } ) ) {
451 next if ( length $subfield != 1 );
453 if ( ( $tagslib->{$tag}->{$subfield}->{hidden} <= -5 )
454 or ( $tagslib->{$tag}->{$subfield}->{hidden} >= 4 ) )
455 ; #check for visibility flag
457 if ( $tagslib->{$tag}->{$subfield}->{tab} ne $tabloop );
461 $tag, $subfield, '', $index_tag, $tabloop, $record,
462 $authorised_values_sth,$input
466 if ( $#subfields_data >= 0 ) {
470 tag_lib => $tagslib->{$tag}->{lib},
471 repeatable => $tagslib->{$tag}->{repeatable},
472 indicator => $indicator,
473 subfield_loop => \@subfields_data,
474 tagfirstsubfield => $subfields_data[0],
475 fixedfield => ($tag < 10)?(1):(0)
478 push @loop_data, \%tag_data ;
482 if ( $#loop_data >= 0 ) {
485 innerloop => \@loop_data,
489 $template->param( singletab => (scalar(@BIG_LOOP)==1), BIG_LOOP => \@BIG_LOOP );
493 sub build_hidden_data () {
494 # build hidden data =>
495 # we store everything, even if we show only requested subfields.
499 foreach my $tag (keys %{$tagslib}) {
500 my $previous_tag = '';
502 # loop through each subfield
503 foreach my $subfield (keys %{$tagslib->{$tag}}) {
504 next if ($subfield eq 'lib');
505 next if ($subfield eq 'tab');
506 next if ($subfield eq 'mandatory');
507 next if ($subfield eq 'repeatable');
508 next if ($tagslib->{$tag}->{$subfield}->{'tab'} ne "-1");
510 $subfield_data{marc_lib}=$tagslib->{$tag}->{$subfield}->{lib};
511 $subfield_data{marc_mandatory}=$tagslib->{$tag}->{$subfield}->{mandatory};
512 $subfield_data{marc_repeatable}=$tagslib->{$tag}->{$subfield}->{repeatable};
513 $subfield_data{marc_value}="<input type=\"hidden\" name=\"field_value[]\">";
514 push(@loop_data, \%subfield_data);
520 # ========================
522 #=========================
524 my $z3950 = $input->param('z3950');
525 my $error = $input->param('error');
526 my $authid=$input->param('authid'); # if authid exists, it's a modif, not a new authority.
527 my $op = $input->param('op');
528 my $nonav = $input->param('nonav');
529 my $myindex = $input->param('index');
530 my $linkid=$input->param('linkid');
531 my $authtypecode = $input->param('authtypecode');
533 my $dbh = C4::Context->dbh;
534 $authtypecode = &GetAuthTypeCode($authid) if !$authtypecode;
536 my ($template, $loggedinuser, $cookie)
537 = get_template_and_user({template_name => "authorities/authorities.tmpl",
540 authnotrequired => 0,
541 flagsrequired => {editauthorities => 1},
544 $template->param(nonav => $nonav,index=>$myindex,authtypecode=>$authtypecode,);
545 $tagslib = GetTagsLabels(1,$authtypecode);
548 $record = GetAuthority($authid) if ($authid);
549 my ($oldauthnumtagfield,$oldauthnumtagsubfield);
550 my ($oldauthtypetagfield,$oldauthtypetagsubfield);
554 ($oldauthnumtagfield,$oldauthnumtagsubfield) = &GetAuthMARCFromKohaField("auth_header.authid",$authtypecode);
555 ($oldauthtypetagfield,$oldauthtypetagsubfield) = &GetAuthMARCFromKohaField("auth_header.authtypecode",$authtypecode);
558 #------------------------------------------------------------------------------------------------------------------------------
560 #------------------------------------------------------------------------------------------------------------------------------
562 my @tags = $input->param('tag');
563 my @subfields = $input->param('subfield');
564 my @values = $input->param('field_value');
565 # build indicator hash.
566 my @ind_tag = $input->param('ind_tag');
567 my @indicator = $input->param('indicator');
568 my @params = $input->param();
569 my $record = TransformHtmlToMarc(\@params,$input);
570 if (C4::Context->preference("marcflavour") eq "UNIMARC"){
571 unless ($record->field('100')){
572 use POSIX qw(strftime);
573 my $string = strftime( "%Y%m%d", localtime(time) );
574 # set 50 to position 26 is biblios, 13 if authorities
576 $string = sprintf( "%-*s", 35, $string );
577 substr( $string, $pos , 2, "50" );
578 $record->append_fields(MARC::Field->new('100','','',"a"=>$string));
582 # warn $record->as_formatted;
583 # my $record=MARC::Record->new_from_xml($xml,'UTF-8',(C4::Context->preference("marcflavour") eq "UNIMARC"?"UNIMARCAUTH":C4::Context->preference("marcflavour")));
584 # $record->encoding('UTF-8');
585 #warn $record->as_formatted;
586 # check for a duplicate
587 my ($duplicateauthid,$duplicateauthvalue) = FindDuplicateAuthority($record,$authtypecode) if ($op eq "add") && (!$is_a_modif);
588 my $confirm_not_duplicate = $input->param('confirm_not_duplicate');
589 # it is not a duplicate (determined either by Koha itself or by user checking it's not a duplicate)
590 if (!$duplicateauthid or $confirm_not_duplicate) {
591 # warn "noduplicate";
593 ModAuthority($authid,$record,$authtypecode,1);
595 ($authid) = AddAuthority($record,$authid,$authtypecode);
597 print $input->redirect("detail.pl?authid=$authid");
600 # it may be a duplicate, warn the user and do nothing
601 build_tabs($template, $record, $dbh, $encoding,$input);
603 $template->param(authid =>$authid,
604 duplicateauthid => $duplicateauthid,
605 duplicateauthvalue => $duplicateauthvalue,
608 # #------------------------------------------------------------------------------------------------------------------------------
609 # } elsif ($op eq "addfield") {
610 # #------------------------------------------------------------------------------------------------------------------------------
611 # my $addedfield = $input->param('addfield_field');
612 # my $tagaddfield_subfield = $input->param('addfield_subfield');
613 # my @tags = $input->param('tag');
614 # my @subfields = $input->param('subfield');
615 # my @values = $input->param('field_value');
616 # # build indicator hash.
617 # my @ind_tag = $input->param('ind_tag');
618 # my @indicator = $input->param('indicator');
619 # my $xml = TransformHtmlToXml(\@tags,\@subfields,\@values,\@indicator,\@ind_tag);
620 # my $record=MARC::Record->new_from_xml($xml,'UTF-8');
621 # $record->encoding('UTF-8');
622 # # adding an empty field
623 # my $field = MARC::Field->new("$addedfield",'','','$tagaddfield_subfield' => "");
624 # $record->append_fields($field);
625 # build_tabs ($template, $record, $dbh,$encoding,$input);
628 # authid => $authid,);
630 } elsif ($op eq "delete") {
631 #------------------------------------------------------------------------------------------------------------------------------
632 &AUTHdelauthority($authid);
634 print $input->redirect("auth_finder.pl");
636 print $input->redirect("authorities-home.pl?authid=0");
640 if ($op eq "duplicate")
644 build_tabs ($template, $record, $dbh,$encoding,$input);
646 $template->param(oldauthtypetagfield=>$oldauthtypetagfield, oldauthtypetagsubfield=>$oldauthtypetagsubfield,
647 oldauthnumtagfield=>$oldauthnumtagfield, oldauthnumtagsubfield=>$oldauthnumtagsubfield,
648 authid => $authid , authtypecode=>$authtypecode, );
653 authtypecode => $authtypecode,
657 my $authtypes = getauthtypes;
659 foreach my $thisauthtype (keys %$authtypes) {
660 my $selected = 1 if $thisauthtype eq $authtypecode;
661 my %row =(value => $thisauthtype,
662 selected => $selected,
663 authtypetext => $authtypes->{$thisauthtype}{'authtypetext'},
665 push @authtypesloop, \%row;
668 $template->param(authtypesloop => \@authtypesloop,
669 authtypetext => $authtypes->{$authtypecode}{'authtypetext'},
670 hide_marc => C4::Context->preference('hide_marc'),
671 intranetcolorstylesheet => C4::Context->preference("intranetcolorstylesheet"),
672 intranetstylesheet => C4::Context->preference("intranetstylesheet"),
673 IntranetNav => C4::Context->preference("IntranetNav"),
675 output_html_with_http_headers $input, $cookie, $template->output;