Bug 20936: (follow-up) add biblio and item relation to old holds and set a limit...
[koha.git] / opac / opac-holdshistory.pl
blob67ecae864edec215f3c965fed653a32ca45803ee
1 #!/usr/bin/perl
3 # This file is part of Koha.
5 # Koha is free software; you can redistribute it and/or modify it
6 # under the terms of the GNU General Public License as published by
7 # the Free Software Foundation; either version 3 of the License, or
8 # (at your option) any later version.
10 # Koha is distributed in the hope that it will be useful, but
11 # WITHOUT ANY WARRANTY; without even the implied warranty of
12 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
13 # GNU General Public License for more details.
15 # You should have received a copy of the GNU General Public License
16 # along with Koha; if not, see <http://www.gnu.org/licenses>.
19 use Modern::Perl;
21 use CGI qw ( -utf8 );
23 use C4::Auth;
24 use C4::Output;
26 use Koha::Patrons;
27 use Koha::Holds;
28 use Koha::Old::Holds;
30 my $query = CGI->new;
31 my @all_holds;
33 # if opacreadinghistory is disabled, leave immediately
34 unless ( C4::Context->preference('OPACHoldsHistory') ) {
35 print $query->redirect("/cgi-bin/koha/errors/404.pl");
36 exit;
39 my ( $template, $patron_id, $cookie ) = get_template_and_user(
41 template_name => "opac-holdshistory.tt",
42 query => $query,
43 type => "opac"
47 my $patron = Koha::Patrons->find($patron_id);
49 my $sort = $query->param('sort');
50 $sort = 'reservedate' unless $sort;
52 my $unlimit = $query->param('unlimit');
53 my $ops = {
54 prefetch => ['biblio', 'item'],
55 order_by => $sort
58 $ops->{rows} = 50 unless $unlimit;
60 my $holds = Koha::Holds->search({
61 borrowernumber => $patron_id
62 }, $ops);
64 my $old_holds = Koha::Old::Holds->search({
65 borrowernumber => $patron_id
66 }, $ops);
68 while (my $hold = $holds->next) {
69 push @all_holds, $hold;
72 while (my $hold = $old_holds->next) {
73 push @all_holds, $hold;
76 if($sort eq 'reservedate') {
77 @all_holds = sort {$b->$sort cmp $a->$sort} @all_holds;
78 } else {
79 my ($obj, $col) = split /\./, $sort;
80 @all_holds = sort { ( $a->$obj && $a->$obj->$col || '' ) cmp ( $b->$obj && $b->$obj->$col || '' ) } @all_holds;
83 unless($unlimit) {
84 @all_holds = splice(@all_holds, 0, 50);
87 $template->param(
88 holdshistoryview => 1,
89 patron => $patron,
90 holds => \@all_holds,
91 unlimit => $unlimit,
92 sort => $sort
95 output_html_with_http_headers $query, $cookie, $template->output, undef, { force_no_caching => 1 };