Revert "Bug 10606: Remove MySQLism in GetUpcomingDueIssues"
[koha.git] / opac / opac-basket.pl
blob2b345e1cbf808b089a4a04b01b2152799851bc47
1 #!/usr/bin/perl
3 # This file is part of Koha.
5 # Koha is free software; you can redistribute it and/or modify it under the
6 # terms of the GNU General Public License as published by the Free Software
7 # Foundation; either version 2 of the License, or (at your option) any later
8 # version.
10 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
11 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
12 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
14 # You should have received a copy of the GNU General Public License along
15 # with Koha; if not, write to the Free Software Foundation, Inc.,
16 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
19 use strict;
20 use warnings;
21 use CGI qw ( -utf8 );
22 use C4::Koha;
23 use C4::Biblio;
24 use C4::Branch;
25 use C4::Items;
26 use C4::Circulation;
27 use C4::Auth;
28 use C4::Output;
30 my $query = new CGI;
32 my ( $template, $borrowernumber, $cookie ) = get_template_and_user (
34 template_name => "opac-basket.tt",
35 query => $query,
36 type => "opac",
37 authnotrequired => ( C4::Context->preference("OpacPublic") ? 1 : 0 ),
38 flagsrequired => { borrow => 1 },
42 my $bib_list = $query->param('bib_list');
43 my $print_basket = $query->param('print');
44 my $verbose = $query->param('verbose');
46 if ($verbose) { $template->param( verbose => 1 ); }
47 if ($print_basket) { $template->param( print_basket => 1 ); }
49 my @bibs = split( /\//, $bib_list );
50 my @results;
52 my $num = 1;
53 my $marcflavour = C4::Context->preference('marcflavour');
54 if (C4::Context->preference('TagsEnabled')) {
55 $template->param(TagsEnabled => 1);
56 foreach (qw(TagsShowOnList TagsInputOnList)) {
57 C4::Context->preference($_) and $template->param($_ => 1);
62 foreach my $biblionumber ( @bibs ) {
63 $template->param( biblionumber => $biblionumber );
65 my $dat = &GetBiblioData($biblionumber);
66 my $record = &GetMarcBiblio($biblionumber);
67 next unless $record;
68 my $marcnotesarray = GetMarcNotes( $record, $marcflavour );
69 my $marcauthorsarray = GetMarcAuthors( $record, $marcflavour );
70 my $marcsubjctsarray = GetMarcSubjects( $record, $marcflavour );
71 my $marcseriesarray = GetMarcSeries ($record,$marcflavour);
72 my $marcurlsarray = GetMarcUrls ($record,$marcflavour);
73 my @items = &GetItemsInfo( $biblionumber );
74 my $subtitle = GetRecordValue('subtitle', $record, GetFrameworkCode($biblionumber));
76 my $hasauthors = 0;
77 if($dat->{'author'} || @$marcauthorsarray) {
78 $hasauthors = 1;
80 my $collections = GetKohaAuthorisedValues('items.ccode',$dat->{'frameworkcode'}, 'opac');
81 my $shelflocations =GetKohaAuthorisedValues('items.location',$dat->{'frameworkcode'}, 'opac');
83 # COinS format FIXME: for books Only
84 my $coins_format;
85 my $fmt = substr $record->leader(), 6,2;
86 my $fmts;
87 $fmts->{'am'} = 'book';
88 $dat->{ocoins_format} = $fmts->{$fmt};
90 if ( $num % 2 == 1 ) {
91 $dat->{'even'} = 1;
94 my $branches = GetBranches();
95 for my $itm (@items) {
96 if ($itm->{'location'}){
97 $itm->{'location_opac'} = $shelflocations->{$itm->{'location'} };
99 my ( $transfertwhen, $transfertfrom, $transfertto ) = GetTransfers($itm->{itemnumber});
100 if ( defined( $transfertwhen ) && $transfertwhen ne '' ) {
101 $itm->{transfertwhen} = $transfertwhen;
102 $itm->{transfertfrom} = $branches->{$transfertfrom}{branchname};
103 $itm->{transfertto} = $branches->{$transfertto}{branchname};
106 $num++;
107 $dat->{biblionumber} = $biblionumber;
108 $dat->{ITEM_RESULTS} = \@items;
109 $dat->{MARCNOTES} = $marcnotesarray;
110 $dat->{MARCSUBJCTS} = $marcsubjctsarray;
111 $dat->{MARCAUTHORS} = $marcauthorsarray;
112 $dat->{MARCSERIES} = $marcseriesarray;
113 $dat->{MARCURLS} = $marcurlsarray;
114 $dat->{HASAUTHORS} = $hasauthors;
115 $dat->{subtitle} = $subtitle;
117 if ( C4::Context->preference("BiblioDefaultView") eq "normal" ) {
118 $dat->{dest} = "opac-detail.pl";
120 elsif ( C4::Context->preference("BiblioDefaultView") eq "marc" ) {
121 $dat->{dest} = "opac-MARCdetail.pl";
123 else {
124 $dat->{dest} = "opac-ISBDdetail.pl";
126 push( @results, $dat );
129 my $resultsarray = \@results;
131 # my $itemsarray=\@items;
133 $template->param(
134 bib_list => $bib_list,
135 BIBLIO_RESULTS => $resultsarray,
138 output_html_with_http_headers $query, $cookie, $template->output;