Bug 23390: Introduce placeholder syntax for report column names
[koha.git] / C4 / XSLT.pm
blob648bab28abb34b84bca925612252d5314c2f0e35
1 package C4::XSLT;
3 # Copyright (C) 2006 LibLime
4 # <jmf at liblime dot com>
5 # Parts Copyright Katrin Fischer 2011
6 # Parts Copyright ByWater Solutions 2011
7 # Parts Copyright Biblibre 2012
9 # This file is part of Koha.
11 # Koha is free software; you can redistribute it and/or modify it
12 # under the terms of the GNU General Public License as published by
13 # the Free Software Foundation; either version 3 of the License, or
14 # (at your option) any later version.
16 # Koha is distributed in the hope that it will be useful, but
17 # WITHOUT ANY WARRANTY; without even the implied warranty of
18 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
19 # GNU General Public License for more details.
21 # You should have received a copy of the GNU General Public License
22 # along with Koha; if not, see <http://www.gnu.org/licenses>.
24 use Modern::Perl;
26 use C4::Context;
27 use C4::Items;
28 use C4::Koha;
29 use C4::Biblio;
30 use C4::Circulation;
31 use C4::Reserves;
32 use Koha::AuthorisedValues;
33 use Koha::ItemTypes;
34 use Koha::XSLT_Handler;
35 use Koha::Libraries;
37 use Encode;
39 use vars qw(@ISA @EXPORT);
41 my $engine; #XSLT Handler object
42 my %authval_per_framework;
43 # Cache for tagfield-tagsubfield to decode per framework.
44 # Should be preferably be placed in Koha-core...
46 BEGIN {
47 require Exporter;
48 @ISA = qw(Exporter);
49 @EXPORT = qw(
50 &XSLTParse4Display
52 $engine=Koha::XSLT_Handler->new( { do_not_return_source => 1 } );
55 =head1 NAME
57 C4::XSLT - Functions for displaying XSLT-generated content
59 =head1 FUNCTIONS
61 =head2 transformMARCXML4XSLT
63 Replaces codes with authorized values in a MARC::Record object
64 Is only used in this module currently.
66 =cut
68 sub transformMARCXML4XSLT {
69 my ($biblionumber, $record) = @_;
70 my $frameworkcode = GetFrameworkCode($biblionumber) || '';
71 my $tagslib = &GetMarcStructure(1, $frameworkcode, { unsafe => 1 });
72 my @fields;
73 # FIXME: wish there was a better way to handle exceptions
74 eval {
75 @fields = $record->fields();
77 if ($@) { warn "PROBLEM WITH RECORD"; next; }
78 my $marcflavour = C4::Context->preference('marcflavour');
79 my $av = getAuthorisedValues4MARCSubfields($frameworkcode);
80 foreach my $tag ( keys %$av ) {
81 foreach my $field ( $record->field( $tag ) ) {
82 if ( $av->{ $tag } ) {
83 my @new_subfields = ();
84 for my $subfield ( $field->subfields() ) {
85 my ( $letter, $value ) = @$subfield;
86 # Replace the field value with the authorised value *except* for MARC21/NORMARC field 942$n (suppression in opac)
87 if ( !( $tag eq '942' && $subfield eq 'n' ) || $marcflavour eq 'UNIMARC' ) {
88 $value = GetAuthorisedValueDesc( $tag, $letter, $value, '', $tagslib )
89 if $av->{ $tag }->{ $letter };
91 push( @new_subfields, $letter, $value );
93 $field ->replace_with( MARC::Field->new(
94 $tag,
95 $field->indicator(1),
96 $field->indicator(2),
97 @new_subfields
98 ) );
102 return $record;
105 =head2 getAuthorisedValues4MARCSubfields
107 Returns a ref of hash of ref of hash for tag -> letter controlled by authorised values
108 Is only used in this module currently.
110 =cut
112 sub getAuthorisedValues4MARCSubfields {
113 my ($frameworkcode) = @_;
114 unless ( $authval_per_framework{ $frameworkcode } ) {
115 my $dbh = C4::Context->dbh;
116 my $sth = $dbh->prepare("SELECT DISTINCT tagfield, tagsubfield
117 FROM marc_subfield_structure
118 WHERE authorised_value IS NOT NULL
119 AND authorised_value!=''
120 AND frameworkcode=?");
121 $sth->execute( $frameworkcode );
122 my $av = { };
123 while ( my ( $tag, $letter ) = $sth->fetchrow() ) {
124 $av->{ $tag }->{ $letter } = 1;
126 $authval_per_framework{ $frameworkcode } = $av;
128 return $authval_per_framework{ $frameworkcode };
131 =head2 XSLTParse4Display
133 Returns xml for biblionumber and requested XSLT transformation.
134 Returns undef if the transform fails.
136 Used in OPAC results and detail, intranet results and detail, list display.
137 (Depending on the settings of your XSLT preferences.)
139 The helper function _get_best_default_xslt_filename is used in a unit test.
141 =cut
143 sub _get_best_default_xslt_filename {
144 my ($htdocs, $theme, $lang, $base_xslfile) = @_;
146 my @candidates = (
147 "$htdocs/$theme/$lang/xslt/${base_xslfile}", # exact match
148 "$htdocs/$theme/en/xslt/${base_xslfile}", # if not, preferred theme in English
149 "$htdocs/prog/$lang/xslt/${base_xslfile}", # if not, 'prog' theme in preferred language
150 "$htdocs/prog/en/xslt/${base_xslfile}", # otherwise, prog theme in English; should always
151 # exist
153 my $xslfilename;
154 foreach my $filename (@candidates) {
155 $xslfilename = $filename;
156 if (-f $filename) {
157 last; # we have a winner!
160 return $xslfilename;
163 sub get_xslt_sysprefs {
164 my $sysxml = "<sysprefs>\n";
165 foreach my $syspref ( qw/ hidelostitems OPACURLOpenInNewWindow
166 DisplayOPACiconsXSLT URLLinkText viewISBD
167 OPACBaseURL TraceCompleteSubfields UseICU
168 UseAuthoritiesForTracings TraceSubjectSubdivisions
169 Display856uAsImage OPACDisplay856uAsImage
170 UseControlNumber IntranetBiblioDefaultView BiblioDefaultView
171 OPACItemLocation DisplayIconsXSLT
172 AlternateHoldingsField AlternateHoldingsSeparator
173 TrackClicks opacthemes IdRef OpacSuppression
174 OPACResultsLibrary OPACShowOpenURL
175 OpenURLResolverURL OpenURLImageLocation
176 OpenURLText / )
178 my $sp = C4::Context->preference( $syspref );
179 next unless defined($sp);
180 $sysxml .= "<syspref name=\"$syspref\">$sp</syspref>\n";
183 # singleBranchMode was a system preference, but no longer is
184 # we can retain it here for compatibility
185 my $singleBranchMode = Koha::Libraries->search->count == 1 ? 1 : 0;
186 $sysxml .= "<syspref name=\"singleBranchMode\">$singleBranchMode</syspref>\n";
188 $sysxml .= "</sysprefs>\n";
189 return $sysxml;
192 sub XSLTParse4Display {
193 my ( $biblionumber, $orig_record, $xslsyspref, $fixamps, $hidden_items, $sysxml, $xslfilename, $lang, $variables ) = @_;
195 $sysxml ||= C4::Context->preference($xslsyspref);
196 $xslfilename ||= C4::Context->preference($xslsyspref);
197 $lang ||= C4::Languages::getlanguage();
199 if ( $xslfilename =~ /^\s*"?default"?\s*$/i ) {
200 my $htdocs;
201 my $theme;
202 my $xslfile;
203 if ($xslsyspref eq "XSLTDetailsDisplay") {
204 $htdocs = C4::Context->config('intrahtdocs');
205 $theme = C4::Context->preference("template");
206 $xslfile = C4::Context->preference('marcflavour') .
207 "slim2intranetDetail.xsl";
208 } elsif ($xslsyspref eq "XSLTResultsDisplay") {
209 $htdocs = C4::Context->config('intrahtdocs');
210 $theme = C4::Context->preference("template");
211 $xslfile = C4::Context->preference('marcflavour') .
212 "slim2intranetResults.xsl";
213 } elsif ($xslsyspref eq "OPACXSLTDetailsDisplay") {
214 $htdocs = C4::Context->config('opachtdocs');
215 $theme = C4::Context->preference("opacthemes");
216 $xslfile = C4::Context->preference('marcflavour') .
217 "slim2OPACDetail.xsl";
218 } elsif ($xslsyspref eq "OPACXSLTResultsDisplay") {
219 $htdocs = C4::Context->config('opachtdocs');
220 $theme = C4::Context->preference("opacthemes");
221 $xslfile = C4::Context->preference('marcflavour') .
222 "slim2OPACResults.xsl";
223 } elsif ($xslsyspref eq 'XSLTListsDisplay') {
224 # Lists default to *Results.xslt
225 $htdocs = C4::Context->config('intrahtdocs');
226 $theme = C4::Context->preference("template");
227 $xslfile = C4::Context->preference('marcflavour') .
228 "slim2intranetResults.xsl";
229 } elsif ($xslsyspref eq 'OPACXSLTListsDisplay') {
230 # Lists default to *Results.xslt
231 $htdocs = C4::Context->config('opachtdocs');
232 $theme = C4::Context->preference("opacthemes");
233 $xslfile = C4::Context->preference('marcflavour') .
234 "slim2OPACResults.xsl";
236 $xslfilename = _get_best_default_xslt_filename($htdocs, $theme, $lang, $xslfile);
239 if ( $xslfilename =~ m/\{langcode\}/ ) {
240 $xslfilename =~ s/\{langcode\}/$lang/;
243 # grab the XML, run it through our stylesheet, push it out to the browser
244 my $record = transformMARCXML4XSLT($biblionumber, $orig_record);
245 my $itemsxml = buildKohaItemsNamespace($biblionumber, $hidden_items);
246 my $xmlrecord = $record->as_xml(C4::Context->preference('marcflavour'));
248 $variables ||= {};
249 if (C4::Context->preference('OPACShowOpenURL')) {
250 my @biblio_itemtypes;
251 my $biblio = Koha::Biblios->find($biblionumber);
252 if (C4::Context->preference('item-level_itypes')) {
253 @biblio_itemtypes = $biblio->items->get_column("itype");
254 } else {
255 push @biblio_itemtypes, $biblio->itemtype;
257 my @itypes = split( /\s/, C4::Context->preference('OPACOpenURLItemTypes') );
258 my %original = ();
259 map { $original{$_} = 1 } @biblio_itemtypes;
260 if ( grep { $original{$_} } @itypes ) {
261 $variables->{OpenURLResolverURL} = $biblio->get_openurl;
264 my $varxml = "<variables>\n";
265 while (my ($key, $value) = each %$variables) {
266 $varxml .= "<variable name=\"$key\">$value</variable>\n";
268 $varxml .= "</variables>\n";
270 $xmlrecord =~ s/\<\/record\>/$itemsxml$sysxml$varxml\<\/record\>/;
271 if ($fixamps) { # We need to correct the ampersand entities that Zebra outputs
272 $xmlrecord =~ s/\&amp;amp;/\&amp;/g;
273 $xmlrecord =~ s/\&amp\;lt\;/\&lt\;/g;
274 $xmlrecord =~ s/\&amp\;gt\;/\&gt\;/g;
276 $xmlrecord =~ s/\& /\&amp\; /;
277 $xmlrecord =~ s/\&amp\;amp\; /\&amp\; /;
279 #If the xslt should fail, we will return undef (old behavior was
280 #raw MARC)
281 #Note that we did set do_not_return_source at object construction
282 return $engine->transform($xmlrecord, $xslfilename ); #file or URL
285 =head2 buildKohaItemsNamespace
287 Returns XML for items.
288 Is only used in this module currently.
290 =cut
292 sub buildKohaItemsNamespace {
293 my ($biblionumber, $hidden_items) = @_;
295 my @items = C4::Items::GetItemsInfo($biblionumber);
296 if ($hidden_items && @$hidden_items) {
297 my %hi = map {$_ => 1} @$hidden_items;
298 @items = grep { !$hi{$_->{itemnumber}} } @items;
301 my $shelflocations =
302 { map { $_->{authorised_value} => $_->{opac_description} } Koha::AuthorisedValues->get_descriptions_by_koha_field( { frameworkcode => GetFrameworkCode($biblionumber), kohafield => 'items.location' } ) };
303 my $ccodes =
304 { map { $_->{authorised_value} => $_->{opac_description} } Koha::AuthorisedValues->get_descriptions_by_koha_field( { frameworkcode => GetFrameworkCode($biblionumber), kohafield => 'items.ccode' } ) };
306 my %branches = map { $_->branchcode => $_->branchname } Koha::Libraries->search({}, { order_by => 'branchname' });
308 my $itemtypes = { map { $_->{itemtype} => $_ } @{ Koha::ItemTypes->search->unblessed } };
309 my $location = "";
310 my $ccode = "";
311 my $xml = '';
312 for my $item (@items) {
313 my $status;
315 my ( $transfertwhen, $transfertfrom, $transfertto ) = C4::Circulation::GetTransfers($item->{itemnumber});
317 my $reservestatus = C4::Reserves::GetReserveStatus( $item->{itemnumber} );
319 if ( ( $item->{itype} && $itemtypes->{ $item->{itype} }->{notforloan} ) || $item->{notforloan} || $item->{onloan} || $item->{withdrawn} || $item->{itemlost} || $item->{damaged} ||
320 (defined $transfertwhen && $transfertwhen ne '') || $item->{itemnotforloan} || (defined $reservestatus && $reservestatus eq "Waiting") || $item->{has_pending_hold} ){
321 if ( $item->{notforloan} < 0) {
322 $status = "On order";
324 if ( $item->{itemnotforloan} && $item->{itemnotforloan} > 0 || $item->{notforloan} && $item->{notforloan} > 0 || $item->{itype} && $itemtypes->{ $item->{itype} }->{notforloan} && $itemtypes->{ $item->{itype} }->{notforloan} == 1 ) {
325 $status = "reference";
327 if ($item->{onloan}) {
328 $status = "Checked out";
330 if ( $item->{withdrawn}) {
331 $status = "Withdrawn";
333 if ($item->{itemlost}) {
334 $status = "Lost";
336 if ($item->{damaged}) {
337 $status = "Damaged";
339 if (defined $transfertwhen && $transfertwhen ne '') {
340 $status = 'In transit';
342 if (defined $reservestatus && $reservestatus eq "Waiting") {
343 $status = 'Waiting';
345 if ($item->{has_pending_hold}) {
346 $status = 'Pending hold';
348 } else {
349 $status = "available";
351 my $homebranch = $item->{homebranch}? xml_escape($branches{$item->{homebranch}}):'';
352 my $holdingbranch = $item->{holdingbranch}? xml_escape($branches{$item->{holdingbranch}}):'';
353 $location = $item->{location}? xml_escape($shelflocations->{$item->{location}}||$item->{location}):'';
354 $ccode = $item->{ccode}? xml_escape($ccodes->{$item->{ccode}}||$item->{ccode}):'';
355 my $itemcallnumber = xml_escape($item->{itemcallnumber});
356 my $stocknumber = $item->{stocknumber}? xml_escape($item->{stocknumber}):'';
357 $xml .=
358 "<item>"
359 . "<homebranch>$homebranch</homebranch>"
360 . "<holdingbranch>$holdingbranch</holdingbranch>"
361 . "<location>$location</location>"
362 . "<ccode>$ccode</ccode>"
363 . "<status>".( $status // q{} )."</status>"
364 . "<itemcallnumber>$itemcallnumber</itemcallnumber>"
365 . "<stocknumber>$stocknumber</stocknumber>"
366 . "</item>";
368 $xml = "<items xmlns=\"http://www.koha-community.org/items\">".$xml."</items>";
369 return $xml;
372 =head2 engine
374 Returns reference to XSLT handler object.
376 =cut
378 sub engine {
379 return $engine;
384 __END__
386 =head1 AUTHOR
388 Joshua Ferraro <jmf@liblime.com>
390 Koha Development Team <http://koha-community.org/>
392 =cut