3 # Copyright 2000-2002 Katipo Communications
5 # This file is part of Koha.
7 # Koha is free software; you can redistribute it and/or modify it under the
8 # terms of the GNU General Public License as published by the Free Software
9 # Foundation; either version 2 of the License, or (at your option) any later
12 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
13 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
14 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
16 # You should have received a copy of the GNU General Public License along with
17 # Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
18 # Suite 330, Boston, MA 02111-1307 USA
22 MARCdetail.pl : script to show a biblio in MARC format
29 This script needs a biblionumber in bib parameter (bibnumber
30 from koha style DB. Automaticaly maps to marc biblionumber).
32 It shows the biblio in a (nice) MARC format depending on MARC
35 The template is in <templates_dir>/catalogue/MARCdetail.tmpl.
36 this template must be divided into 11 "tabs".
38 The first 10 tabs present the biblio, the 11th one presents
39 the items attached to the biblio
53 use C4::Interface::CGI::Output;
63 my $dbh=C4::Context->dbh;
65 my $biblionumber=$query->param('bib');
66 my $bibid = $query->param('bibid');
67 $bibid = &MARCfind_MARCbibid_from_oldbiblionumber($dbh,$biblionumber) unless $bibid;
68 $biblionumber = &MARCfind_oldbiblionumber_from_MARCbibid($dbh,$bibid) unless $biblionumber;
69 my $itemtype = &MARCfind_frameworkcode($dbh,$bibid);
70 my $tagslib = &MARCgettagslib($dbh,1,$itemtype);
72 my $record =MARCgetbiblio($dbh,$bibid);
74 my ($template, $loggedinuser, $cookie)
75 = get_template_and_user({template_name => "opac-MARCdetail.tmpl",
85 # loop through each tab 0 through 9
86 for (my $tabloop = 0; $tabloop<=10;$tabloop++) {
87 # loop through each tag
88 my @fields = $record->fields();
90 foreach my $field (@fields) {
92 # if tag <10, there's no subfield, use the "@" trick
93 if ($field->tag()<10) {
94 next if ($tagslib->{$field->tag()}->{'@'}->{tab} ne $tabloop);
95 next if ($tagslib->{$field->tag()}->{'@'}->{hidden});
97 $subfield_data{marc_lib}=$tagslib->{$field->tag()}->{'@'}->{lib};
98 $subfield_data{marc_value}=$field->data();
99 $subfield_data{marc_subfield}='@';
100 $subfield_data{marc_tag}=$field->tag();
101 push(@subfields_data, \%subfield_data);
103 my @subf=$field->subfields;
104 # loop through each subfield
105 for my $i (0..$#subf) {
106 $subf[$i][0] = "@" unless $subf[$i][0];
107 next if ($tagslib->{$field->tag()}->{$subf[$i][0]}->{tab} ne $tabloop);
108 next if ($tagslib->{$field->tag()}->{$subf[$i][0]}->{hidden});
110 $subfield_data{marc_lib}=$tagslib->{$field->tag()}->{$subf[$i][0]}->{lib};
111 if ($tagslib->{$field->tag()}->{$subf[$i][0]}->{isurl}) {
112 $subfield_data{marc_value}="<a href=\"$subf[$i][1]\">$subf[$i][1]</a>";
114 $subfield_data{marc_value}=get_authorised_value_desc($field->tag(), $subf[$i][0], $subf[$i][1], '', $dbh);
116 $subfield_data{marc_subfield}=$subf[$i][0];
117 $subfield_data{marc_tag}=$field->tag();
118 push(@subfields_data, \%subfield_data);
121 if ($#subfields_data>=0) {
123 $tag_data{tag}=$field->tag().' -'. $tagslib->{$field->tag()}->{lib};
124 $tag_data{subfield} = \@subfields_data;
125 push (@loop_data, \%tag_data);
128 $template->param($tabloop."XX" =>\@loop_data);
130 # now, build item tab !
131 # the main difference is that datas are in lines and not in columns : thus, we build the <th> first, then the values...
132 # loop through each tag
133 # warning : we may have differents number of columns in each row. Thus, we first build a hash, complete it if necessary
134 # then construct template.
135 my @fields = $record->fields();
136 my %witness; #---- stores the list of subfields used at least once, with the "meaning" of the code
138 foreach my $field (@fields) {
139 next if ($field->tag()<10);
140 my @subf=$field->subfields;
142 # loop through each subfield
143 for my $i (0..$#subf) {
144 next if ($tagslib->{$field->tag()}->{$subf[$i][0]}->{tab} ne 10);
145 $witness{$subf[$i][0]} = $tagslib->{$field->tag()}->{$subf[$i][0]}->{lib};
146 $this_row{$subf[$i][0]} =$subf[$i][1];
149 push(@big_array, \%this_row);
152 #fill big_row with missing datas
153 foreach my $subfield_code (keys(%witness)) {
154 for (my $i=0;$i<=$#big_array;$i++) {
155 $big_array[$i]{$subfield_code}=" " unless ($big_array[$i]{$subfield_code});
158 # now, construct template !
160 my @header_value_loop;
161 for (my $i=0;$i<=$#big_array; $i++) {
163 foreach my $subfield_code (keys(%witness)) {
164 $items_data .="<td>".$big_array[$i]{$subfield_code}."</td>";
167 $row_data{item_value} = $items_data;
168 push(@item_value_loop,\%row_data);
170 foreach my $subfield_code (keys(%witness)) {
172 $header_value{header_value} = $witness{$subfield_code};
173 push(@header_value_loop, \%header_value);
176 $template->param(item_loop => \@item_value_loop,
177 item_header_loop => \@header_value_loop,
178 biblionumber => $biblionumber,
180 biblionumber => $biblionumber);
181 output_html_with_http_headers $query, $cookie, $template->output;
183 sub get_authorised_value_desc ($$$$$) {
184 my($tag, $subfield, $value, $framework, $dbh) = @_;
187 if ($tagslib->{$tag}->{$subfield}->{'authorised_value'} eq "branches" ) {
188 return getbranchname($value);
192 if ($tagslib->{$tag}->{$subfield}->{'authorised_value'} eq "itemtypes" ) {
193 return ItemType($value);
196 #---- "true" authorized value
197 my $category = $tagslib->{$tag}->{$subfield}->{'authorised_value'};
199 if ($category ne "") {
200 my $sth = $dbh->prepare("select lib from authorised_values where category = ? and authorised_value = ?");
201 $sth->execute($category, $value);
202 my $data = $sth->fetchrow_hashref;
203 return $data->{'lib'};
205 return $value; # if nothing is found return the original value