#!/usr/bin/perl
-# $Id$
# Copyright 2000-2002 Katipo Communications
+# Parts Copyright Catalyst IT 2011
#
# This file is part of Koha.
#
-# Koha is free software; you can redistribute it and/or modify it under the
-# terms of the GNU General Public License as published by the Free Software
-# Foundation; either version 2 of the License, or (at your option) any later
-# version.
+# Koha is free software; you can redistribute it and/or modify it
+# under the terms of the GNU General Public License as published by
+# the Free Software Foundation; either version 3 of the License, or
+# (at your option) any later version.
#
-# Koha is distributed in the hope that it will be useful, but WITHOUT ANY
-# WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
-# A PARTICULAR PURPOSE. See the GNU General Public License for more details.
+# Koha is distributed in the hope that it will be useful, but
+# WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+# GNU General Public License for more details.
#
-# You should have received a copy of the GNU General Public License along with
-# Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
-# Suite 330, Boston, MA 02111-1307 USA
+# You should have received a copy of the GNU General Public License
+# along with Koha; if not, see <http://www.gnu.org/licenses>.
-use strict;
-use CGI;
+use Modern::Perl;
+
+use CGI qw ( -utf8 );
use C4::Auth;
use C4::Context;
+use C4::Languages;
use C4::Search;
use C4::Output;
use C4::Koha;
-use C4::Branch;
+use C4::Circulation;
use Date::Manip;
=head1 NAME
=head1 DESCRIPTION
-=over 2
-
=cut
my $input = new CGI;
-my $branches = GetBranches();
-my $itemtypes = GetItemTypes();
-
-my ($template, $borrowernumber, $cookie)
- = get_template_and_user({template_name => 'opac-topissues.tmpl',
- query => $input,
- type => "opac",
- authnotrequired => 1,
- debug => 1,
- });
+
+# if OpacTopissue is disabled, leave immediately
+if ( ! C4::Context->preference('OpacTopissue') ) {
+ print $input->redirect("/cgi-bin/koha/errors/404.pl");
+ exit;
+}
+
+my ($template, $borrowernumber, $cookie) = get_template_and_user(
+ {
+ template_name => 'opac-topissues.tt',
+ query => $input,
+ type => "opac",
+ authnotrequired => ( C4::Context->preference("OpacPublic") ? 1 : 0 ),
+ debug => 1,
+ }
+);
my $dbh = C4::Context->dbh;
# Displaying results
-my $limit = $input->param('limit') || 10;
-my $branch = $input->param('branch');
-my $itemtype = $input->param('itemtype');
+my $do_it = $input->param('do_it') || 0; # as form been posted
+my $limit = $input->param('limit');
+$limit = 10 unless ($limit && $limit =~ /^\d+$/); # control user input for SQL query
+$limit = 100 if $limit > 100;
+my $branch = $input->param('branch') || '';
+if (!$do_it && C4::Context->userenv && C4::Context->userenv->{'branch'} ) {
+ $branch = C4::Context->userenv->{'branch'}; # select user branch by default
+}
+my $itemtype = $input->param('itemtype') || '';
my $timeLimit = $input->param('timeLimit') || 3;
-my $whereclause;
-$whereclause .= 'items.homebranch='.$dbh->quote($branch)." AND " if ($branch);
-$whereclause .= 'biblioitems.itemtype='.$dbh->quote($itemtype)." AND " if $itemtype;
-$whereclause .= ' TO_DAYS(NOW()) - TO_DAYS(biblio.datecreated) <= '.($timeLimit*30).' AND ' if $timeLimit < 999;
-$whereclause =~ s/ AND $//;
-$whereclause = " WHERE ".$whereclause if $whereclause;
-
-my $query = "SELECT datecreated, biblio.biblionumber, title,
- author, sum( items.issues ) AS tot, biblioitems.itemtype,
- biblioitems.publishercode,biblioitems.publicationyear,
- itemtypes.description
- FROM biblio
- LEFT JOIN items USING (biblionumber)
- LEFT JOIN biblioitems USING (biblionumber)
- LEFT JOIN itemtypes ON itemtypes.itemtype = biblioitems.itemtype
- $whereclause
- GROUP BY biblio.biblionumber
- HAVING tot >0
- ORDER BY tot DESC
- LIMIT $limit
- ";
-
-my $sth = $dbh->prepare($query);
-$sth->execute();
-my @results;
-while (my $line= $sth->fetchrow_hashref) {
- push @results, $line;
+my $advanced_search_types = C4::Context->preference('AdvancedSearchTypes');
+my @advanced_search_types = split /\|/, $advanced_search_types;
+
+my $params = {
+ count => $limit,
+ branch => $branch,
+ newness => $timeLimit < 999 ? $timeLimit * 30 : undef,
+};
+
+@advanced_search_types = grep /^(ccode|itemtypes)$/, @advanced_search_types;
+foreach my $type (@advanced_search_types) {
+ if ($type eq 'itemtypes') {
+ $type = 'itemtype';
+ }
+ $params->{$type} = $input->param($type);
+ $template->param('selected_' . $type => scalar $input->param($type));
}
-$template->param(do_it => 1,
- limit => $limit,
- branch => $branches->{$branch}->{branchname},
- itemtype => $itemtypes->{$itemtype}->{description},
- timeLimit => $timeLimit,
- results_loop => \@results,
- );
-
-# load the branches
-my $branches = GetBranches();
-my @branch_loop;
-for my $branch_hash (sort keys %$branches ) {
- my $selected=(C4::Context->userenv && ($branch_hash eq C4::Context->userenv->{branch})) if (C4::Context->preference('SearchMyLibraryFirst'));
- push @branch_loop,
- {
- value => "$branch_hash",
- branchname => $branches->{$branch_hash}->{'branchname'},
- selected => $selected
- };
-}
-$template->param( branchloop => \@branch_loop, "mylibraryfirst"=>C4::Context->preference("SearchMyLibraryFirst"));
-
-#doctype
-my $itemtypes = GetItemTypes;
-my @itemtypeloop;
-foreach my $thisitemtype (keys %$itemtypes) {
- my %row =(value => $thisitemtype,
- description => $itemtypes->{$thisitemtype}->{'description'},
- );
- push @itemtypeloop, \%row;
-}
+my @results = GetTopIssues($params);
$template->param(
- itemtypeloop =>\@itemtypeloop,
- );
-output_html_with_http_headers $input, $cookie, $template->output;
+ limit => $limit,
+ branch => $branch,
+ timeLimit => $timeLimit,
+ results => \@results,
+);
+output_html_with_http_headers $input, $cookie, $template->output;