Revert "Bug 10606: Remove MySQLism in GetUpcomingDueIssues"
[koha.git] / opac / opac-MARCdetail.pl
blob6a5e8a602a6cbcc442a2702fa46004e50766a000
1 #!/usr/bin/perl
3 # This file is part of Koha.
5 # Copyright (C) 2000-2002 Katipo Communications
6 # Parts Copyright (C) 2010 BibLibre
7 # Parts Copyright (C) 2013 Mark Tompsett
9 # Koha is free software; you can redistribute it and/or modify it
10 # under the terms of the GNU General Public License as published by
11 # the Free Software Foundation; either version 3 of the License, or
12 # (at your option) any later version.
14 # Koha is distributed in the hope that it will be useful, but
15 # WITHOUT ANY WARRANTY; without even the implied warranty of
16 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
17 # GNU General Public License for more details.
19 # You should have received a copy of the GNU General Public License
20 # along with Koha; if not, see <http://www.gnu.org/licenses>.
23 =head1 NAME
25 opac-MARCdetail.pl : script to show a biblio in MARC format
27 =head1 SYNOPSIS
29 =cut
31 =head1 DESCRIPTION
33 This script needs a biblionumber as parameter
35 It shows the biblio in a (nice) MARC format depending on MARC
36 parameters tables.
38 The template is in <templates_dir>/catalogue/MARCdetail.tt.
39 this template must be divided into 11 "tabs".
41 The first 10 tabs present the biblio, the 11th one presents
42 the items attached to the biblio
44 =cut
46 use Modern::Perl;
48 use C4::Auth;
49 use C4::Context;
50 use C4::Output;
51 use CGI qw ( -utf8 );
52 use MARC::Record;
53 use C4::Biblio;
54 use C4::Items;
55 use C4::Reserves;
56 use C4::Members;
57 use C4::Acquisition;
58 use C4::Koha;
59 use List::MoreUtils qw/any/;
61 my $query = new CGI;
63 my $dbh = C4::Context->dbh;
65 my $biblionumber = $query->param('biblionumber');
66 if ( ! $biblionumber ) {
67 print $query->redirect("/cgi-bin/koha/errors/404.pl");
68 exit;
71 my @all_items = GetItemsInfo($biblionumber);
72 my @items2hide;
73 if (scalar @all_items >= 1) {
74 push @items2hide, GetHiddenItemnumbers(@all_items);
76 if (scalar @items2hide == scalar @all_items ) {
77 print $query->redirect("/cgi-bin/koha/errors/404.pl");
78 exit;
82 my $itemtype = &GetFrameworkCode($biblionumber);
83 my $tagslib = &GetMarcStructure( 0, $itemtype );
84 my ($tag_itemnumber,$subtag_itemnumber) = &GetMarcFromKohaField('items.itemnumber',$itemtype);
85 my $biblio = GetBiblioData($biblionumber);
86 $biblionumber = $biblio->{biblionumber};
87 my $record = GetMarcBiblio($biblionumber, 1);
88 if ( ! $record ) {
89 print $query->redirect("/cgi-bin/koha/errors/404.pl");
90 exit;
92 # open template
93 my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
95 template_name => "opac-MARCdetail.tt",
96 query => $query,
97 type => "opac",
98 authnotrequired => ( C4::Context->preference("OpacPublic") ? 1 : 0 ),
99 debug => 1,
103 $template->param(
104 bibliotitle => $biblio->{title},
107 # get biblionumbers stored in the cart
108 if(my $cart_list = $query->cookie("bib_list")){
109 my @cart_list = split(/\//, $cart_list);
110 if ( grep {$_ eq $biblionumber} @cart_list) {
111 $template->param( incart => 1 );
115 my $allow_onshelf_holds;
116 my $borrower = GetMember( 'borrowernumber' => $loggedinuser );
117 for my $itm (@all_items) {
118 $allow_onshelf_holds = C4::Reserves::OnShelfHoldsAllowed($itm, $borrower);
119 last if $allow_onshelf_holds;
122 $template->param( 'AllowOnShelfHolds' => $allow_onshelf_holds );
123 $template->param( 'ItemsIssued' => CountItemsIssued( $biblionumber ) );
125 # adding the $RequestOnOpac param
126 my $RequestOnOpac;
127 if (C4::Context->preference("RequestOnOpac")) {
128 $RequestOnOpac = 1;
131 # fill arrays
132 my @loop_data = ();
133 my $tag;
135 # loop through each tab 0 through 9
136 for ( my $tabloop = 0 ; $tabloop <= 9 ; $tabloop++ ) {
138 # loop through each tag
139 my @loop_data = ();
140 my @subfields_data;
142 # deal with leader
143 unless ( $tagslib->{'000'}->{'@'}->{tab} ne $tabloop
144 or $tagslib->{'000'}->{'@'}->{hidden} > 0 )
146 my %subfield_data;
147 $subfield_data{marc_lib} = $tagslib->{'000'}->{'@'}->{lib};
148 $subfield_data{marc_value} = $record->leader();
149 $subfield_data{marc_subfield} = '@';
150 $subfield_data{marc_tag} = '000';
151 push( @subfields_data, \%subfield_data );
152 my %tag_data;
153 $tag_data{tag} = '000 -' . $tagslib->{'000'}->{lib};
154 my @tmp = @subfields_data;
155 $tag_data{subfield} = \@tmp;
156 push( @loop_data, \%tag_data );
157 undef @subfields_data;
159 my @fields = $record->fields();
160 for ( my $x_i = 0 ; $x_i <= $#fields ; $x_i++ ) {
162 # if tag <10, there's no subfield, use the "@" trick
163 if ( $fields[$x_i]->tag() < 10 ) {
164 next
165 if (
166 $tagslib->{ $fields[$x_i]->tag() }->{'@'}->{tab} ne $tabloop );
167 next if ( $tagslib->{ $fields[$x_i]->tag() }->{'@'}->{hidden} > 0 );
168 my %subfield_data;
169 $subfield_data{marc_lib} =
170 $tagslib->{ $fields[$x_i]->tag() }->{'@'}->{lib};
171 $subfield_data{marc_value} = $fields[$x_i]->data();
172 $subfield_data{marc_subfield} = '@';
173 $subfield_data{marc_tag} = $fields[$x_i]->tag();
174 push( @subfields_data, \%subfield_data );
176 else {
177 my @subf = $fields[$x_i]->subfields;
178 my $previous = '';
179 # loop through each subfield
180 for my $i ( 0 .. $#subf ) {
181 $subf[$i][0] = "@" unless defined($subf[$i][0]);
182 my $sf_def = $tagslib->{ $fields[$x_i]->tag() };
183 $sf_def = $sf_def->{ $subf[$i][0] } if defined($sf_def);
184 my ($tab,$hidden,$lib);
185 $tab = $sf_def->{tab} if defined($sf_def);
186 $tab = $tab // int($fields[$x_i]->tag()/100);
187 $hidden = $sf_def->{hidden} if defined($sf_def);
188 $hidden = $hidden // 0;
189 next if ( $tab != $tabloop );
190 next if ( $hidden > 0 );
191 my %subfield_data;
192 $lib = $sf_def->{lib} if defined($sf_def);
193 $lib = $lib // '--';
194 $subfield_data{marc_lib} = ($lib eq $previous) ? '--' : $lib;
195 $previous = $lib;
196 $subfield_data{link} = $sf_def->{link};
197 $subf[$i][1] =~ s/\n/<br\/>/g;
198 if ( $sf_def->{isurl} ) {
199 $subfield_data{marc_value} = "<a href=\"$subf[$i][1]\">$subf[$i][1]</a>";
201 elsif ( defined($sf_def->{kohafield}) && $sf_def->{kohafield} eq "biblioitems.isbn" ) {
202 $subfield_data{marc_value} = $subf[$i][1];
204 else {
205 if ( $sf_def->{authtypecode} ) {
206 $subfield_data{authority} = $fields[$x_i]->subfield(9);
208 $subfield_data{marc_value} = GetAuthorisedValueDesc( $fields[$x_i]->tag(),
209 $subf[$i][0], $subf[$i][1], '', $tagslib, '', 'opac' );
211 $subfield_data{marc_subfield} = $subf[$i][0];
212 $subfield_data{marc_tag} = $fields[$x_i]->tag();
213 push( @subfields_data, \%subfield_data );
216 if ( $#subfields_data >= 0 ) {
217 my %tag_data;
218 if ( ( $fields[$x_i]->tag() eq $fields[ $x_i - 1 ]->tag() )
219 && ( C4::Context->preference('LabelMARCView') eq 'economical' )
222 $tag_data{tag} = "";
224 else {
225 if ( C4::Context->preference('hide_marc') ) {
226 $tag_data{tag} = $tagslib->{ $fields[$x_i]->tag() }->{lib};
228 else {
229 my $sf_def = $tagslib->{ $fields[$x_i]->tag() };
230 my $lib;
231 $lib = $sf_def->{lib} if defined($sf_def);
232 $lib = $lib // '';
233 $tag_data{tag} = $fields[$x_i]->tag() . ' '
234 . C4::Koha::display_marc_indicators($fields[$x_i])
235 . " - $lib";
238 my @tmp = @subfields_data;
239 $tag_data{subfield} = \@tmp;
240 push( @loop_data, \%tag_data );
241 undef @subfields_data;
244 $template->param( "tab" . $tabloop . "XX" => \@loop_data );
248 # now, build item tab !
249 # the main difference is that datas are in lines and not in columns : thus, we build the <th> first, then the values...
250 # loop through each tag
251 # warning : we may have differents number of columns in each row. Thus, we first build a hash, complete it if necessary
252 # then construct template.
253 my @fields = $record->fields();
254 my %witness
255 ; #---- stores the list of subfields used at least once, with the "meaning" of the code
256 my @big_array;
257 foreach my $field (@fields) {
258 next if ( $field->tag() < 10 );
259 next if ( ( $field->tag() eq $tag_itemnumber ) &&
260 ( any { $field->subfield($subtag_itemnumber) eq $_ }
261 @items2hide) );
262 my @subf = $field->subfields;
263 my %this_row;
265 # loop through each subfield
266 for my $i ( 0 .. $#subf ) {
267 my $sf_def = $tagslib->{ $field->tag() }->{ $subf[$i][0] };
268 next if ( ($sf_def->{tab}||0) != 10 );
269 next if ( ($sf_def->{hidden}||0) > 0 );
270 $witness{ $subf[$i][0] } = $sf_def->{lib};
272 if ( $sf_def->{isurl} ) {
273 $this_row{ $subf[$i][0] } = "<a href=\"$subf[$i][1]\">$subf[$i][1]</a>";
275 elsif ( $sf_def->{kohafield} eq "biblioitems.isbn" ) {
276 $this_row{ $subf[$i][0] } = $subf[$i][1];
278 else {
279 $this_row{ $subf[$i][0] } = GetAuthorisedValueDesc( $field->tag(), $subf[$i][0],
280 $subf[$i][1], '', $tagslib, '', 'opac' );
283 if (%this_row) {
284 push( @big_array, \%this_row );
287 my ( $holdingbrtagf, $holdingbrtagsubf ) =
288 &GetMarcFromKohaField( "items.holdingbranch", $itemtype );
289 @big_array =
290 sort { ($a->{$holdingbrtagsubf}||'') cmp ($b->{$holdingbrtagsubf}||'') } @big_array;
292 #fill big_row with missing datas
293 foreach my $subfield_code ( keys(%witness) ) {
294 for ( my $i = 0 ; $i <= $#big_array ; $i++ ) {
295 $big_array[$i]{$subfield_code} = "&nbsp;"
296 unless ( $big_array[$i]{$subfield_code} );
300 # now, construct template !
301 my @item_value_loop;
302 my @header_value_loop;
303 for ( my $i = 0 ; $i <= $#big_array ; $i++ ) {
304 my $items_data;
305 foreach my $subfield_code ( keys(%witness) ) {
306 $items_data .= "<td>" . $big_array[$i]{$subfield_code} . "</td>";
308 my %row_data;
309 $row_data{item_value} = $items_data;
310 push( @item_value_loop, \%row_data );
313 foreach my $subfield_code ( keys(%witness) ) {
314 my %header_value;
315 $header_value{header_value} = $witness{$subfield_code};
316 push( @header_value_loop, \%header_value );
319 if(C4::Context->preference("ISBD")) {
320 $template->param(ISBD => 1);
323 #Search for title in links
324 my $marcflavour = C4::Context->preference("marcflavour");
325 my $dat = TransformMarcToKoha( $dbh, $record );
326 my $isbn = GetNormalizedISBN(undef,$record,$marcflavour);
327 my $marccontrolnumber = GetMarcControlnumber ($record, $marcflavour);
328 my $marcissns = GetMarcISSN( $record, $marcflavour );
329 my $issn = $marcissns->[0] || '';
331 if (my $search_for_title = C4::Context->preference('OPACSearchForTitleIn')){
332 $dat->{title} =~ s/\/+$//; # remove trailing slash
333 $dat->{title} =~ s/\s+$//; # remove trailing space
334 $search_for_title = parametrized_url(
335 $search_for_title,
337 TITLE => $dat->{title},
338 AUTHOR => $dat->{author},
339 ISBN => $isbn,
340 ISSN => $issn,
341 CONTROLNUMBER => $marccontrolnumber,
342 BIBLIONUMBER => $biblionumber,
345 $template->param('OPACSearchForTitleIn' => $search_for_title);
348 $template->param(
349 item_loop => \@item_value_loop,
350 item_header_loop => \@header_value_loop,
351 biblionumber => $biblionumber,
354 output_html_with_http_headers $query, $cookie, $template->output;