Revert "Bug 10606: Remove MySQLism in GetUpcomingDueIssues"
[koha.git] / opac / opac-showreviews.pl
blob2bca5d69295fd50a18bdee8b1954839fd78919fd
1 #!/usr/bin/perl
3 # Copyright 2000-2002 Katipo Communications
4 # Parts copyright 2010 Nelsonville Public Library
6 # This file is part of Koha.
8 # Koha is free software; you can redistribute it and/or modify it under the
9 # terms of the GNU General Public License as published by the Free Software
10 # Foundation; either version 2 of the License, or (at your option) any later
11 # version.
13 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
14 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
15 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
17 # You should have received a copy of the GNU General Public License along
18 # with Koha; if not, write to the Free Software Foundation, Inc.,
19 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
21 use strict;
22 use warnings;
24 use CGI qw ( -utf8 );
25 use C4::Auth;
26 use C4::Koha;
27 use C4::Output;
28 use C4::Circulation;
29 use C4::Review;
30 use C4::Biblio;
31 use C4::Dates;
32 use C4::Members qw/GetMemberDetails/;
33 use POSIX qw(ceil strftime);
35 my $template_name;
36 my $query = new CGI;
37 my $format = $query->param("format") || '';
38 my $count = C4::Context->preference('OPACnumSearchResults') || 20;
39 my $results_per_page = $query->param('count') || $count;
40 my $offset = $query->param('offset') || 0;
41 my $page = $query->param('page') || 1;
42 $offset = ($page-1)*$results_per_page if $page>1;
44 if ($format eq "rss") {
45 $template_name = "opac-showreviews-rss.tt";
46 } else {
47 $template_name = "opac-showreviews.tt",
50 my ( $template, $borrowernumber, $cookie ) = &get_template_and_user(
52 template_name => $template_name,
53 query => $query,
54 type => "opac",
55 authnotrequired => ( C4::Context->preference("OpacPublic") ? 1 : 0 ),
59 if($format eq "rss"){
60 my $lastbuilddate = C4::Dates->new();
61 my $lastbuilddate_output = $lastbuilddate->output("rfc822");
62 $template->param(
63 rss => 1,
64 timestamp => $lastbuilddate_output
68 my $libravatar_enabled = 0;
69 if ( C4::Context->preference('ShowReviewer') and C4::Context->preference('ShowReviewerPhoto')) {
70 eval {
71 require Libravatar::URL;
72 Libravatar::URL->import();
74 if ( !$@ ) {
75 $libravatar_enabled = 1;
79 my $reviews = getallreviews(1,$offset,$results_per_page);
80 my $marcflavour = C4::Context->preference("marcflavour");
81 my $hits = numberofreviews(1);
82 my $i = 0;
83 my $latest_comment_date;
84 for my $result (@$reviews){
85 my $biblionumber = $result->{biblionumber};
86 my $bib = &GetBiblioData($biblionumber);
87 my $record = GetMarcBiblio($biblionumber);
88 my $frameworkcode = GetFrameworkCode($biblionumber);
89 my ( $borr ) = GetMemberDetails( $result->{borrowernumber} );
90 $result->{normalized_upc} = GetNormalizedUPC($record,$marcflavour);
91 $result->{normalized_ean} = GetNormalizedEAN($record,$marcflavour);
92 $result->{normalized_oclc} = GetNormalizedOCLCNumber($record,$marcflavour);
93 $result->{normalized_isbn} = GetNormalizedISBN(undef,$record,$marcflavour);
94 $result->{title} = $bib->{'title'};
95 $result->{subtitle} = GetRecordValue('subtitle', $record, $frameworkcode);
96 $result->{author} = $bib->{'author'};
97 $result->{place} = $bib->{'place'};
98 $result->{publishercode} = $bib->{'publishercode'};
99 $result->{copyrightdate} = $bib->{'copyrightdate'};
100 $result->{pages} = $bib->{'pages'};
101 $result->{size} = $bib->{'size'};
102 $result->{notes} = $bib->{'notes'};
103 $result->{timestamp} = $bib->{'timestamp'};
104 $result->{borrtitle} = $borr->{'title'};
105 $result->{firstname} = $borr->{'firstname'};
106 $result->{surname} = $borr->{'surname'};
107 $result->{userid} = $borr->{'userid'};
108 if ($libravatar_enabled and $borr->{'email'}) {
109 $result->{avatarurl} = libravatar_url(email => $borr->{'email'}, size => 40, https => $ENV{HTTPS});
112 if ($result->{borrowernumber} eq $borrowernumber) {
113 $result->{your_comment} = 1;
116 if($format eq "rss"){
117 my $rsstimestamp = C4::Dates->new($result->{datereviewed},"iso");
118 my $rsstimestamp_output = $rsstimestamp->output("rfc822");
119 $result->{timestamp} = $rsstimestamp_output;
122 ## Build the page numbers on the bottom of the page
123 my @page_numbers;
124 my $previous_page_first;
125 my $previous_page_offset;
126 # total number of pages there will be
127 my $pages = ceil($hits / $results_per_page);
128 # default page number
129 my $current_page_number = 1;
130 $current_page_number = ($offset / $results_per_page + 1) if $offset;
131 if($offset - $results_per_page == 0){
132 $previous_page_first = 1;
133 } elsif ($offset - $results_per_page > 0){
134 $previous_page_offset = $offset - $results_per_page;
136 my $next_page_offset = $offset + $results_per_page;
137 # If we're within the first 10 pages, keep it simple
138 if ($current_page_number < 10) {
139 # just show the first 10 pages
140 # Loop through the pages
141 my $pages_to_show = 10;
142 $pages_to_show = $pages if $pages<10;
143 for ($i=1; $i<=$pages_to_show;$i++) {
144 # the offset for this page
145 my $this_offset = (($i*$results_per_page)-$results_per_page);
146 # the page number for this page
147 my $this_page_number = $i;
148 # it should only be highlighted if it's the current page
149 my $highlight;
150 $highlight = 1 if ($this_page_number == $current_page_number);
151 # put it in the array
152 push @page_numbers, { offset => $this_offset, pg => $this_page_number, highlight => $highlight };
157 # now, show twenty pages, with the current one smack in the middle
158 else {
159 for ($i=$current_page_number; $i<=($current_page_number + 20 );$i++) {
160 my $this_offset = ((($i-9)*$results_per_page)-$results_per_page);
161 my $this_page_number = $i-9;
162 my $highlight;
163 $highlight = 1 if ($this_page_number == $current_page_number);
164 if ($this_page_number <= $pages) {
165 push @page_numbers, { offset => $this_offset, pg => $this_page_number, highlight => $highlight };
169 $template->param( PAGE_NUMBERS => \@page_numbers,
170 previous_page_first => $previous_page_first,
171 previous_page_offset => $previous_page_offset) unless $pages < 2;
172 $template->param(next_page_offset => $next_page_offset) unless $pages eq $current_page_number;
174 $template->param(
175 reviews => $reviews,
178 output_html_with_http_headers $query, $cookie, $template->output;