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;
59 use C4::Serials; #uses getsubscriptionsfrombiblionumber
65 my $dbh=C4::Context->dbh;
67 my $biblionumber=$query->param('biblionumber');
69 $biblionumber = $query->param('bib');
71 # my $bibid = $query->param('bibid');
72 my $itemtype = $query->param('frameworkcode');
73 my $popup = $query->param('popup'); # if set to 1, then don't insert links, it's just to show the biblio
75 # $bibid = &MARCfind_MARCbibid_from_oldbiblionumber($dbh,$biblionumber) unless $bibid;
76 # $biblionumber = &MARCfind_oldbiblionumber_from_MARCbibid($dbh,$bibid) unless $biblionumber;
77 # $itemtype = &MARCfind_frameworkcode($dbh,$biblionumber) if not ($itemtype);
78 # $itemtype = '' if ($itemtype eq 'Default');
79 # warn "itemtype :".$itemtype;
81 my $tagslib = &MARCgettagslib($dbh,1,$itemtype);
82 #my $record = C4::Search::get_record($biblionumber);
84 my $record =MARCgetbiblio($dbh,$biblionumber);
86 my ($template, $loggedinuser, $cookie)
87 = get_template_and_user({template_name => "catalogue/MARCdetail.tmpl",
91 flagsrequired => {catalogue => 1},
95 #Getting the list of all frameworks
96 my $queryfwk =$dbh->prepare("select frameworktext, frameworkcode from biblio_framework");
101 push @select_fwk,"Default";
102 $select_fwk{"Default"} = "Default";
103 while (my ($description, $fwk) =$queryfwk->fetchrow) {
104 push @select_fwk, $fwk;
105 $select_fwk{$fwk} = $description;
108 my $framework=CGI::scrolling_list( -name => 'Frameworks',
111 -OnChange => 'Changefwk(this);',
112 -values => \@select_fwk,
113 -labels => \%select_fwk,
117 $template->param( framework => $framework);
121 # loop through each tab 0 through 9
122 for (my $tabloop = 0; $tabloop<=10;$tabloop++) {
123 # loop through each tag
124 my @fields = $record->fields();
128 unless ($tagslib->{'000'}->{'@'}->{tab} ne $tabloop) { # or ($tagslib->{'000'}->{'@'}->{hidden}==(-7|-4|-3|-2|2|3|5|8))) {
130 $subfield_data{marc_lib}=$tagslib->{'000'}->{'@'}->{lib};
131 $subfield_data{marc_value}=$record->leader();
132 $subfield_data{marc_subfield}='@';
133 $subfield_data{marc_tag}='000';
134 push(@subfields_data, \%subfield_data);
136 $tag_data{tag}='000 -'. $tagslib->{'000'}->{lib};
137 my @tmp = @subfields_data;
138 $tag_data{subfield} = \@tmp;
139 push (@loop_data, \%tag_data);
140 undef @subfields_data;
142 my @fields = $record->fields();
143 for (my $x_i=0;$x_i<=$#fields;$x_i++) {
144 # if tag <10, there's no subfield, use the "@" trick
145 if ($fields[$x_i]->tag()<10) {
146 next if ($tagslib->{$fields[$x_i]->tag()}->{'@'}->{tab} ne $tabloop);
147 next if ($tagslib->{$fields[$x_i]->tag()}->{'@'}->{hidden});
149 $subfield_data{marc_lib}=$tagslib->{$fields[$x_i]->tag()}->{'@'}->{lib};
150 $subfield_data{marc_value}=$fields[$x_i]->data();
151 $subfield_data{marc_subfield}='@';
152 $subfield_data{marc_tag}=$fields[$x_i]->tag();
153 push(@subfields_data, \%subfield_data);
155 my @subf=$fields[$x_i]->subfields;
156 # loop through each subfield
157 for my $i (0..$#subf) {
158 $subf[$i][0] = "@" unless $subf[$i][0];
159 next if ($tagslib->{$fields[$x_i]->tag()}->{$subf[$i][0]}->{tab} ne $tabloop);
160 next if ($tagslib->{$fields[$x_i]->tag()}->{$subf[$i][0]}->{hidden});
162 $subfield_data{marc_lib}=$tagslib->{$fields[$x_i]->tag()}->{$subf[$i][0]}->{lib};
163 $subfield_data{link}=$tagslib->{$fields[$x_i]->tag()}->{$subf[$i][0]}->{link};
164 # warn "tag : ".$tagslib->{$fields[$x_i]->tag()}." subfield :".$tagslib->{$fields[$x_i]->tag()}->{$subf[$i][0]}."lien koha? : "$subfield_data{link};
165 if ($tagslib->{$fields[$x_i]->tag()}->{$subf[$i][0]}->{isurl}) {
166 $subfield_data{marc_value}="<a href=\"$subf[$i][1]\">$subf[$i][1]</a>";
167 } elsif ($tagslib->{$fields[$x_i]->tag()}->{$subf[$i][0]}->{kohafield} eq "biblioitems.isbn") {
168 # 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]);
169 $subfield_data{marc_value}=DisplayISBN($subf[$i][1]);
171 if ($tagslib->{$fields[$x_i]->tag()}->{$subf[$i][0]}->{authtypecode}) {
172 $subfield_data{authority}=$fields[$x_i]->subfield(9);
174 $subfield_data{marc_value}=get_authorised_value_desc($fields[$x_i]->tag(), $subf[$i][0], $subf[$i][1], '', $dbh);
176 $subfield_data{marc_subfield}=$subf[$i][0];
177 $subfield_data{marc_tag}=$fields[$x_i]->tag();
178 push(@subfields_data, \%subfield_data);
181 if ($#subfields_data==0) {
182 $subfields_data[0]->{marc_lib}='';
183 $subfields_data[0]->{marc_subfield}='';
185 if ($#subfields_data>=0) {
187 if ($fields[$x_i]->tag() eq $fields[$x_i-1]->tag()) {
190 if (C4::Context->preference('hide_marc')) {
191 $tag_data{tag}=$tagslib->{$fields[$x_i]->tag()}->{lib};
193 $tag_data{tag}=$fields[$x_i]->tag().' -'. $tagslib->{$fields[$x_i]->tag()}->{lib};
196 my @tmp = @subfields_data;
197 $tag_data{subfield} = \@tmp;
198 push (@loop_data, \%tag_data);
199 undef @subfields_data;
202 $template->param($tabloop."XX" =>\@loop_data);
204 # now, build item tab !
205 # the main difference is that datas are in lines and not in columns : thus, we build the <th> first, then the values...
206 # loop through each tag
207 # warning : we may have differents number of columns in each row. Thus, we first build a hash, complete it if necessary
208 # then construct template.
209 my @fields = $record->fields();
210 my %witness; #---- stores the list of subfields used at least once, with the "meaning" of the code
212 foreach my $field (@fields) {
213 next if ($field->tag()<10);
214 my @subf=$field->subfields;
216 # loop through each subfield
217 for my $i (0..$#subf) {
218 next if ($tagslib->{$field->tag()}->{$subf[$i][0]}->{tab} ne 10);
219 next if ($tagslib->{$field->tag()}->{$subf[$i][0]}->{hidden});
220 $witness{$subf[$i][0]} = $tagslib->{$field->tag()}->{$subf[$i][0]}->{lib};
221 $this_row{$subf[$i][0]} =$subf[$i][1];
224 push(@big_array, \%this_row);
227 my ($holdingbrtagf,$holdingbrtagsubf) = &MARCfind_marc_from_kohafield($dbh,"items.holdingbranch",$itemtype);
228 @big_array = sort {$a->{$holdingbrtagsubf} cmp $b->{$holdingbrtagsubf}} @big_array;
230 #fill big_row with missing datas
231 foreach my $subfield_code (keys(%witness)) {
232 for (my $i=0;$i<=$#big_array;$i++) {
233 $big_array[$i]{$subfield_code}=" " unless ($big_array[$i]{$subfield_code});
236 # now, construct template !
238 my @header_value_loop;
239 for (my $i=0;$i<=$#big_array; $i++) {
241 foreach my $subfield_code (keys(%witness)) {
242 $items_data .="<td>".$big_array[$i]{$subfield_code}."</td>";
245 $row_data{item_value} = $items_data;
246 push(@item_value_loop,\%row_data);
248 foreach my $subfield_code (keys(%witness)) {
250 $header_value{header_value} = $witness{$subfield_code};
251 push(@header_value_loop, \%header_value);
254 my $subscriptionsnumber = CountSubscriptionFromBiblionumber($biblionumber);
255 $template->param(item_loop => \@item_value_loop,
256 item_header_loop => \@header_value_loop,
257 biblionumber => $biblionumber,
258 subscriptionsnumber => $subscriptionsnumber,
260 hide_marc => C4::Context->preference('hide_marc'),
261 intranetcolorstylesheet => C4::Context->preference("intranetcolorstylesheet"),
262 intranetstylesheet => C4::Context->preference("intranetstylesheet"),
263 IntranetNav => C4::Context->preference("IntranetNav"),
265 output_html_with_http_headers $query, $cookie, $template->output;
267 sub get_authorised_value_desc ($$$$$) {
268 my($tag, $subfield, $value, $framework, $dbh) = @_;
271 if ($tagslib->{$tag}->{$subfield}->{'authorised_value'} eq "branches" ) {
272 # return getbranchdetail($value)->{branchname};
276 if ($tagslib->{$tag}->{$subfield}->{'authorised_value'} eq "itemtypes" ) {
277 # my $itemtypedef = getitemtypeinfo($itemtype);
278 # return $itemtypedef->{description};
281 #---- "true" authorized value
282 my $category = $tagslib->{$tag}->{$subfield}->{'authorised_value'};
284 if ($category ne "") {
285 my $sth = $dbh->prepare("select lib from authorised_values where category = ? and authorised_value = ?");
286 $sth->execute($category, $value);
287 my $data = $sth->fetchrow_hashref;
288 return $data->{'lib'};
290 return $value; # if nothing is found return the original value