X-Git-Url: http://git.rot13.org/?a=blobdiff_plain;f=catalogue%2FMARCdetail.pl;h=04900764029f3c7ad7d503592d3da8756ed8422e;hb=bd28b8d6c3ab15ae278d7d9eddc73e3af786e87f;hp=6cd9c05cb512abb0928e5ef3d867c1245ec4a4e8;hpb=77dc2a7f7971bcf17464876aef0e20321db7ae7d;p=koha.git diff --git a/catalogue/MARCdetail.pl b/catalogue/MARCdetail.pl index 6cd9c05cb5..0490076402 100755 --- a/catalogue/MARCdetail.pl +++ b/catalogue/MARCdetail.pl @@ -1,6 +1,7 @@ #!/usr/bin/perl # Copyright 2000-2002 Katipo Communications +# Copyright 2010 BibLibre # # This file is part of Koha. # @@ -13,9 +14,9 @@ # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR # A PARTICULAR PURPOSE. See the GNU General Public License for more details. # -# You should have received a copy of the GNU General Public License along with -# Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place, -# Suite 330, Boston, MA 02111-1307 USA +# You should have received a copy of the GNU General Public License along +# with Koha; if not, write to the Free Software Foundation, Inc., +# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. =head1 NAME @@ -23,11 +24,11 @@ MARCdetail.pl : script to show a biblio in MARC format =head1 SYNOPSIS +=cut =head1 DESCRIPTION -This script needs a biblionumber in bib parameter (bibnumber -from koha style DB. Automaticaly maps to marc biblionumber). +This script needs a biblionumber as parameter It shows the biblio in a (nice) MARC format depending on MARC parameters tables. @@ -40,224 +41,298 @@ the items attached to the biblio =head1 FUNCTIONS -=over 2 - =cut - use strict; -require Exporter; +#use warnings; FIXME - Bug 2505 + use C4::Auth; use C4::Context; use C4::Output; -use C4::Interface::CGI::Output; use CGI; use C4::Koha; use MARC::Record; use C4::Biblio; +use C4::Items; use C4::Acquisition; -use C4::Serials; #uses getsubscriptionsfrombiblionumber -use HTML::Template; -use C4::Search; +use C4::Members; # to use GetMember +use C4::Serials; #uses getsubscriptionsfrombiblionumber GetSubscriptionsFromBiblionumber +use C4::Search; # enabled_staff_search_views + -my $query=new CGI; +my $query = new CGI; +my $dbh = C4::Context->dbh; +my $biblionumber = $query->param('biblionumber'); +my $frameworkcode = $query->param('frameworkcode'); +$frameworkcode = GetFrameworkCode( $biblionumber ) unless ($frameworkcode); +my $popup = + $query->param('popup') + ; # if set to 1, then don't insert links, it's just to show the biblio +my $subscriptionid = $query->param('subscriptionid'); -my $dbh=C4::Context->dbh; +# open template +my ( $template, $loggedinuser, $cookie ) = get_template_and_user( + { + template_name => "catalogue/MARCdetail.tmpl", + query => $query, + type => "intranet", + authnotrequired => 0, + flagsrequired => { catalogue => 1 }, + debug => 1, + } +); + +my $record = GetMarcBiblio($biblionumber); +$template->param( ocoins => GetCOinSBiblio($record) ); -my $biblionumber=$query->param('biblionumber'); -if (!$biblionumber){ - $biblionumber = $query->param('bib'); +if ( not defined $record ) { + # biblionumber invalid -> report and exit + $template->param( unknownbiblionumber => 1, + biblionumber => $biblionumber + ); + output_html_with_http_headers $query, $cookie, $template->output; + exit; } -# my $bibid = $query->param('bibid'); -my $itemtype = $query->param('frameworkcode'); -my $popup = $query->param('popup'); # if set to 1, then don't insert links, it's just to show the biblio -# $bibid = &MARCfind_MARCbibid_from_oldbiblionumber($dbh,$biblionumber) unless $bibid; -# $biblionumber = &MARCfind_oldbiblionumber_from_MARCbibid($dbh,$bibid) unless $biblionumber; -# $itemtype = &MARCfind_frameworkcode($dbh,$biblionumber) if not ($itemtype); -# $itemtype = '' if ($itemtype eq 'Default'); -# warn "itemtype :".$itemtype; +my $tagslib = &GetMarcStructure(1,$frameworkcode); +my $biblio = GetBiblioData($biblionumber); -my $tagslib = &MARCgettagslib($dbh,1,$itemtype); -my $record = get_record($biblionumber); +if($query->cookie("holdfor")){ + my $holdfor_patron = GetMember('borrowernumber' => $query->cookie("holdfor")); + $template->param( + holdfor => $query->cookie("holdfor"), + holdfor_surname => $holdfor_patron->{'surname'}, + holdfor_firstname => $holdfor_patron->{'firstname'}, + holdfor_cardnumber => $holdfor_patron->{'cardnumber'}, + ); +} -# my $record =MARCgetbiblio($dbh,$biblionumber); -# open template -my ($template, $loggedinuser, $cookie) - = get_template_and_user({template_name => "catalogue/MARCdetail.tmpl", - query => $query, - type => "intranet", - authnotrequired => 0, - flagsrequired => {catalogue => 1}, - debug => 1, - }); - -#Getting the list of all frameworks -my $queryfwk =$dbh->prepare("select frameworktext, frameworkcode from biblio_framework"); -$queryfwk->execute; -my %select_fwk; -my @select_fwk; -my $curfwk; -push @select_fwk,"Default"; -$select_fwk{"Default"} = "Default"; -while (my ($description, $fwk) =$queryfwk->fetchrow) { - push @select_fwk, $fwk; - $select_fwk{$fwk} = $description; +#count of item linked +my $itemcount = GetItemsCount($biblionumber); +$template->param( count => $itemcount, + bibliotitle => $biblio->{title}, ); + +# Getting the list of all frameworks +# get framework list +my $frameworks = getframeworks; +my @frameworkcodeloop; +foreach my $thisframeworkcode ( keys %$frameworks ) { + my %row = ( + value => $thisframeworkcode, + frameworktext => $frameworks->{$thisframeworkcode}->{'frameworktext'}, + ); + if ($frameworkcode eq $thisframeworkcode){ + $row{'selected'}= 1; + } + push @frameworkcodeloop, \%row; } -$curfwk=$itemtype; -my $framework=CGI::scrolling_list( -name => 'Frameworks', - -id => 'Frameworks', - -default => $curfwk, - -OnChange => 'Changefwk(this);', - -values => \@select_fwk, - -labels => \%select_fwk, - -size => 1, - -multiple => 0 ); - -$template->param( framework => $framework); +$template->param( frameworkcodeloop => \@frameworkcodeloop, ); # fill arrays -my @loop_data =(); +my @loop_data = (); my $tag; + # loop through each tab 0 through 9 -for (my $tabloop = 0; $tabloop<=10;$tabloop++) { -# loop through each tag - my @fields = $record->fields(); - my @loop_data =(); -# foreach my $field (@fields) { - my @subfields_data; - for (my $x_i=0;$x_i<=$#fields;$x_i++) { -# warn "$tabloop => $x_i"; - # if tag <10, there's no subfield, use the "@" trick - if ($fields[$x_i]->tag()<10) { - next if ($tagslib->{$fields[$x_i]->tag()}->{'@'}->{tab} ne $tabloop); - next if ($tagslib->{$fields[$x_i]->tag()}->{'@'}->{hidden}); - my %subfield_data; - $subfield_data{marc_lib}=$tagslib->{$fields[$x_i]->tag()}->{'@'}->{lib}; - $subfield_data{marc_value}=$fields[$x_i]->data(); - $subfield_data{marc_subfield}='@'; - $subfield_data{marc_tag}=$fields[$x_i]->tag(); - push(@subfields_data, \%subfield_data); - } else { - my @subf=$fields[$x_i]->subfields; - # loop through each subfield - for my $i (0..$#subf) { - $subf[$i][0] = "@" unless $subf[$i][0]; - next if ($tagslib->{$fields[$x_i]->tag()}->{$subf[$i][0]}->{tab} ne $tabloop); - next if ($tagslib->{$fields[$x_i]->tag()}->{$subf[$i][0]}->{hidden}); - my %subfield_data; - $subfield_data{marc_lib}=$tagslib->{$fields[$x_i]->tag()}->{$subf[$i][0]}->{lib}; - $subfield_data{link}=$tagslib->{$fields[$x_i]->tag()}->{$subf[$i][0]}->{link}; -# warn "tag : ".$tagslib->{$fields[$x_i]->tag()}." subfield :".$tagslib->{$fields[$x_i]->tag()}->{$subf[$i][0]}."lien koha? : "$subfield_data{link}; - if ($tagslib->{$fields[$x_i]->tag()}->{$subf[$i][0]}->{isurl}) { - $subfield_data{marc_value}="$subf[$i][1]"; - } elsif ($tagslib->{$fields[$x_i]->tag()}->{$subf[$i][0]}->{kohafield} eq "biblioitems.isbn") { -# warn " tag : ".$tagslib->{$fields[$x_i]->tag()}." subfield :".$tagslib->{$fields[$x_i]->tag()}->{$subf[$i][0]}. "ISBN : ".$subf[$i][1]."PosttraitementISBN :".DisplayISBN($subf[$i][1]); - $subfield_data{marc_value}=DisplayISBN($subf[$i][1]); - } else { - if ($tagslib->{$fields[$x_i]->tag()}->{$subf[$i][0]}->{authtypecode}) { - $subfield_data{authority}=$fields[$x_i]->subfield(9); - } - $subfield_data{marc_value}=get_authorised_value_desc($fields[$x_i]->tag(), $subf[$i][0], $subf[$i][1], '', $dbh); - } - $subfield_data{marc_subfield}=$subf[$i][0]; - $subfield_data{marc_tag}=$fields[$x_i]->tag(); - push(@subfields_data, \%subfield_data); - } - } - if ($#subfields_data>=0) { - my %tag_data; - if ($fields[$x_i]->tag() eq $fields[$x_i-1]->tag()) { - $tag_data{tag}=""; - } else { - $tag_data{tag}=$fields[$x_i]->tag().' -'. $tagslib->{$fields[$x_i]->tag()}->{lib}; - } - my @tmp = @subfields_data; - $tag_data{subfield} = \@tmp; - push (@loop_data, \%tag_data); - undef @subfields_data; - } - } - $template->param($tabloop."XX" =>\@loop_data); +for ( my $tabloop = 0 ; $tabloop <= 10 ; $tabloop++ ) { + + # loop through each tag + my @fields = $record->fields(); + my @loop_data = (); + my @subfields_data; + + # deal with leader + unless ( $tagslib->{'000'}->{'@'}->{tab} ne $tabloop ) + { # or ($tagslib->{'000'}->{'@'}->{hidden} =~ /-7|-4|-3|-2|2|3|5|8/ )) { + my %subfield_data; + $subfield_data{marc_lib} = $tagslib->{'000'}->{'@'}->{lib}; + $subfield_data{marc_value} = $record->leader(); + $subfield_data{marc_subfield} = '@'; + $subfield_data{marc_tag} = '000'; + push( @subfields_data, \%subfield_data ); + my %tag_data; + $tag_data{tag} = '000 -' . $tagslib->{'000'}->{lib}; + my @tmp = @subfields_data; + $tag_data{subfield} = \@tmp; + push( @loop_data, \%tag_data ); + undef @subfields_data; + } + @fields = $record->fields(); + for ( my $x_i = 0 ; $x_i <= $#fields ; $x_i++ ) { + + # if tag <10, there's no subfield, use the "@" trick + if ( $fields[$x_i]->tag() < 10 ) { + next + if ( + $tagslib->{ $fields[$x_i]->tag() }->{'@'}->{tab} ne $tabloop ); + next if ( $tagslib->{ $fields[$x_i]->tag() }->{'@'}->{hidden} =~ /-7|-4|-3|-2|2|3|5|8/); + my %subfield_data; + $subfield_data{marc_lib} = + $tagslib->{ $fields[$x_i]->tag() }->{'@'}->{lib}; + $subfield_data{marc_value} = $fields[$x_i]->data(); + $subfield_data{marc_subfield} = '@'; + $subfield_data{marc_tag} = $fields[$x_i]->tag(); + push( @subfields_data, \%subfield_data ); + } + else { + my @subf = $fields[$x_i]->subfields; + + # loop through each subfield + for my $i ( 0 .. $#subf ) { + $subf[$i][0] = "@" unless $subf[$i][0]; + next + if ( + $tagslib->{ $fields[$x_i]->tag() }->{ $subf[$i][0] }->{tab} + ne $tabloop ); + next + if ( $tagslib->{ $fields[$x_i]->tag() }->{ $subf[$i][0] } + ->{hidden} =~ /-7|-4|-3|-2|2|3|5|8/); + my %subfield_data; + $subfield_data{short_desc} = $tagslib->{ $fields[$x_i]->tag() }->{ $subf[$i][0] }->{lib}; + $subfield_data{long_desc} = + $tagslib->{ $fields[$x_i]->tag() }->{ $subf[$i][0] }->{lib}; + $subfield_data{link} = + $tagslib->{ $fields[$x_i]->tag() }->{ $subf[$i][0] }->{link}; + +# warn "tag : ".$tagslib->{$fields[$x_i]->tag()}." subfield :".$tagslib->{$fields[$x_i]->tag()}->{$subf[$i][0]}."lien koha? : "$subfield_data{link}; + if ( $tagslib->{ $fields[$x_i]->tag() }->{ $subf[$i][0] } + ->{isurl} ) + { + $subfield_data{marc_value} = $subf[$i][1]; + $subfield_data{is_url} = 1; + } + elsif ( $tagslib->{ $fields[$x_i]->tag() }->{ $subf[$i][0] } + ->{kohafield} eq "biblioitems.isbn" ) + { + +# warn " tag : ".$tagslib->{$fields[$x_i]->tag()}." subfield :".$tagslib->{$fields[$x_i]->tag()}->{$subf[$i][0]}. "ISBN : ".$subf[$i][1]."PosttraitementISBN :".DisplayISBN($subf[$i][1]); + $subfield_data{marc_value} = $subf[$i][1]; + } + else { + if ( $tagslib->{ $fields[$x_i]->tag() }->{ $subf[$i][0] } + ->{authtypecode} ) + { + $subfield_data{authority} = $fields[$x_i]->subfield(9); + } + $subfield_data{marc_value} = + GetAuthorisedValueDesc( $fields[$x_i]->tag(), + $subf[$i][0], $subf[$i][1], '', $tagslib) || $subf[$i][1]; + + } + $subfield_data{marc_subfield} = $subf[$i][0]; + $subfield_data{marc_tag} = $fields[$x_i]->tag(); + push( @subfields_data, \%subfield_data ); + } + } + if ( $#subfields_data == 0 ) { + $subfields_data[0]->{marc_lib} = ''; +# $subfields_data[0]->{marc_subfield} = ''; + } + if ( $#subfields_data >= 0) { + my %tag_data; + if ( $fields[$x_i]->tag() eq $fields[ $x_i - 1 ]->tag() && (C4::Context->preference('LabelMARCView') eq 'economical')) { + $tag_data{tag} = ""; + } + else { + if ( C4::Context->preference('hide_marc') ) { + $tag_data{tag} = $tagslib->{ $fields[$x_i]->tag() }->{lib}; + } + else { + $tag_data{tag} = + $fields[$x_i]->tag() + . ' ' + . C4::Koha::display_marc_indicators($fields[$x_i]) + . ' - ' + . $tagslib->{ $fields[$x_i]->tag() }->{lib}; + } + } + my @tmp = @subfields_data; + $tag_data{subfield} = \@tmp; + push( @loop_data, \%tag_data ); + undef @subfields_data; + } + } + $template->param( "tab" . $tabloop . "XX" => \@loop_data ); } + # now, build item tab ! # the main difference is that datas are in lines and not in columns : thus, we build the first, then the values... # loop through each tag # warning : we may have differents number of columns in each row. Thus, we first build a hash, complete it if necessary # then construct template. my @fields = $record->fields(); -my %witness; #---- stores the list of subfields used at least once, with the "meaning" of the code +my %witness + ; #---- stores the list of subfields used at least once, with the "meaning" of the code my @big_array; +my $norequests = 1; foreach my $field (@fields) { - next if ($field->tag()<10); - my @subf=$field->subfields; - my %this_row; -# loop through each subfield - for my $i (0..$#subf) { - next if ($tagslib->{$field->tag()}->{$subf[$i][0]}->{tab} ne 10); - next if ($tagslib->{$field->tag()}->{$subf[$i][0]}->{hidden}); - $witness{$subf[$i][0]} = $tagslib->{$field->tag()}->{$subf[$i][0]}->{lib}; - $this_row{$subf[$i][0]} =$subf[$i][1]; - } - if (%this_row) { - push(@big_array, \%this_row); - } + next if ( $field->tag() < 10 ); + my @subf = $field->subfields; + my %this_row; + + # loop through each subfield + for my $i ( 0 .. $#subf ) { + next if ( $tagslib->{ $field->tag() }->{ $subf[$i][0] }->{tab} ne 10 ); + next if ( $tagslib->{ $field->tag() }->{ $subf[$i][0] }->{hidden} =~ /-7|-4|-3|-2|2|3|5|8/); + $witness{ $subf[$i][0] } = + $tagslib->{ $field->tag() }->{ $subf[$i][0] }->{lib}; + $this_row{ $subf[$i][0] } = GetAuthorisedValueDesc( $field->tag(), + $subf[$i][0], $subf[$i][1], '', $tagslib) || $subf[$i][1]; + $norequests = 0 if $subf[$i][1] ==0 and $tagslib->{ $field->tag() }->{ $subf[$i][0] }->{kohafield} eq 'items.notforloan'; + } + if (%this_row) { + push( @big_array, \%this_row ); + } } + +my ($holdingbrtagf,$holdingbrtagsubf) = &GetMarcFromKohaField("items.holdingbranch",$frameworkcode); +@big_array = sort {$a->{$holdingbrtagsubf} cmp $b->{$holdingbrtagsubf}} @big_array; + #fill big_row with missing datas -foreach my $subfield_code (keys(%witness)) { - for (my $i=0;$i<=$#big_array;$i++) { - $big_array[$i]{$subfield_code}=" " unless ($big_array[$i]{$subfield_code}); - } +foreach my $subfield_code ( keys(%witness) ) { + for ( my $i = 0 ; $i <= $#big_array ; $i++ ) { + $big_array[$i]{$subfield_code} = " " + unless ( $big_array[$i]{$subfield_code} ); + } } + # now, construct template ! my @item_value_loop; my @header_value_loop; -for (my $i=0;$i<=$#big_array; $i++) { - my $items_data; - foreach my $subfield_code (keys(%witness)) { - $items_data .="".$big_array[$i]{$subfield_code}.""; - } - my %row_data; - $row_data{item_value} = $items_data; - push(@item_value_loop,\%row_data); +for ( my $i = 0 ; $i <= $#big_array ; $i++ ) { + my $items_data; + foreach my $subfield_code ( keys(%witness) ) { + $items_data .= "" . $big_array[$i]{$subfield_code} . ""; + } + my %row_data; + $row_data{item_value} = $items_data; + push( @item_value_loop, \%row_data ); } -foreach my $subfield_code (keys(%witness)) { - my %header_value; - $header_value{header_value} = $witness{$subfield_code}; - push(@header_value_loop, \%header_value); +foreach my $subfield_code ( keys(%witness) ) { + my %header_value; + $header_value{header_value} = $witness{$subfield_code}; + push( @header_value_loop, \%header_value ); } -my $subscriptionsnumber = CountSubscriptionFromBiblionumber($biblionumber); -$template->param(item_loop => \@item_value_loop, - item_header_loop => \@header_value_loop, - biblionumber => $biblionumber, - subscriptionsnumber => $subscriptionsnumber, - popup => $popup, - ); -output_html_with_http_headers $query, $cookie, $template->output; +my $subscriptionscount = CountSubscriptionFromBiblionumber($biblionumber); -sub get_authorised_value_desc ($$$$$) { - my($tag, $subfield, $value, $framework, $dbh) = @_; - - #---- branch - if ($tagslib->{$tag}->{$subfield}->{'authorised_value'} eq "branches" ) { -# return getbranchdetail($value)->{branchname}; - } +if ($subscriptionscount) { + my $subscriptions = GetSubscriptionsFromBiblionumber($biblionumber); + my $subscriptiontitle = $subscriptions->[0]{'bibliotitle'}; + $template->param( + subscriptiontitle => $subscriptiontitle, + subscriptionsnumber => $subscriptionscount, + ); +} - #---- itemtypes - if ($tagslib->{$tag}->{$subfield}->{'authorised_value'} eq "itemtypes" ) { - # my $itemtypedef = getitemtypeinfo($itemtype); - # return $itemtypedef->{description}; - } +$template->param ( + norequests => $norequests, + item_loop => \@item_value_loop, + item_header_loop => \@header_value_loop, + biblionumber => $biblionumber, + popup => $popup, + hide_marc => C4::Context->preference('hide_marc'), + marcview => 1, + z3950_search_params => C4::Search::z3950_search_args($biblio), + C4::Search::enabled_staff_search_views, +); - #---- "true" authorized value - my $category = $tagslib->{$tag}->{$subfield}->{'authorised_value'}; - - if ($category ne "") { - my $sth = $dbh->prepare("select lib from authorised_values where category = ? and authorised_value = ?"); - $sth->execute($category, $value); - my $data = $sth->fetchrow_hashref; - return $data->{'lib'}; - } else { - return $value; # if nothing is found return the original value - } -} +output_html_with_http_headers $query, $cookie, $template->output;