From e5dcf0a01c3e1c0aee485b2b3a3d5a103c1cd453 Mon Sep 17 00:00:00 2001 From: Chris Cormack Date: Sat, 29 Oct 2011 08:49:20 +1300 Subject: [PATCH] Bug 6947 : opac-topissues.pl wasn't respecting item live itemtypes --- opac/opac-topissues.pl | 10 +++++++++- 1 files changed, 9 insertions(+), 1 deletions(-) diff --git a/opac/opac-topissues.pl b/opac/opac-topissues.pl index 6899215..05b7a27 100755 --- a/opac/opac-topissues.pl +++ b/opac/opac-topissues.pl @@ -2,6 +2,7 @@ # Copyright 2000-2002 Katipo Communications +# Parts Copyright Catalyst IT 2011 # # This file is part of Koha. # @@ -83,7 +84,14 @@ if($advanced_search_types eq 'ccode'){ "; $template->param(ccodesearch => 1); }else{ - $whereclause .= ' AND biblioitems.itemtype='.$dbh->quote($itemtype) if $itemtype; + if ($itemtype){ + if (C4::Context->preference('item-level_itypes')){ + $whereclause .= ' AND items.itype = ' . $dbh->quote($itemtype); + } + else { + $whereclause .= ' AND biblioitems.itemtype='.$dbh->quote($itemtype); + } + } $query = "SELECT datecreated, biblio.biblionumber, title, author, sum( items.issues ) AS tot, biblioitems.itemtype, biblioitems.publishercode,biblioitems.publicationyear, -- 1.7.5.4