From 9d7681389d8d40db940ce94835ec6620348f8192 Mon Sep 17 00:00:00 2001 From: Owen Leonard Date: Thu, 13 Jan 2011 22:53:51 +0100 Subject: [PATCH] Fix for Bug 3459, topissues doesn't take care of ccode - Change conditional to display filter in sidebar without EXPR - Enhance switch between ccode default and itemtype default searches - Enable preselect of submitted collection code in filter form, stealing code from opac-search.pl Signed-off-by: Katrin Fischer Signed-off-by: Chris Cormack (cherry picked from commit f45969422c55f34edec3145b7e2fa1a85222932f) Signed-off-by: Chris Nighswonger --- .../prog/en/includes/opac-topissues.inc | 4 +- .../prog/en/modules/opac-topissues.tmpl | 40 +++++--- opac/opac-topissues.pl | 95 +++++++++++++------ 3 files changed, 98 insertions(+), 41 deletions(-) diff --git a/koha-tmpl/opac-tmpl/prog/en/includes/opac-topissues.inc b/koha-tmpl/opac-tmpl/prog/en/includes/opac-topissues.inc index 20eba4998e..b96b8d3f9a 100644 --- a/koha-tmpl/opac-tmpl/prog/en/includes/opac-topissues.inc +++ b/koha-tmpl/opac-tmpl/prog/en/includes/opac-topissues.inc @@ -25,9 +25,9 @@
  • - - - - - - - + + +
  • @@ -126,11 +136,19 @@ function Dopop(link) { - + + +
    + + +
    + +
    -
    + + diff --git a/opac/opac-topissues.pl b/opac/opac-topissues.pl index 70b712ede9..b4b83f1458 100755 --- a/opac/opac-topissues.pl +++ b/opac/opac-topissues.pl @@ -55,27 +55,52 @@ my $limit = $input->param('limit') || 10; my $branch = $input->param('branch') || ''; my $itemtype = $input->param('itemtype') || ''; my $timeLimit = $input->param('timeLimit') || 3; +my $advanced_search_types = C4::Context->preference('AdvancedSearchTypes'); + 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 .= ' AND items.homebranch='.$dbh->quote($branch) if ($branch); +$whereclause .= ' AND TO_DAYS(NOW()) - TO_DAYS(biblio.datecreated) <= '.($timeLimit*30) if $timeLimit < 999; $whereclause =~ s/ AND $// if $whereclause; -$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 $query; + +if($advanced_search_types eq 'ccode'){ + $whereclause .= ' AND authorised_values.authorised_value='.$dbh->quote($itemtype) if $itemtype; + $query = "SELECT datecreated, biblio.biblionumber, title, + author, sum( items.issues ) AS tot, biblioitems.itemtype, + biblioitems.publishercode,biblioitems.publicationyear, + authorised_values.lib as description + FROM biblio + LEFT JOIN items USING (biblionumber) + LEFT JOIN biblioitems USING (biblionumber) + LEFT JOIN authorised_values ON items.ccode = authorised_values.authorised_value + WHERE 1 + $whereclause + AND authorised_values.category = 'ccode' + GROUP BY biblio.biblionumber + HAVING tot >0 + ORDER BY tot DESC + LIMIT $limit + "; + $template->param(ccodesearch => 1); +}else{ + $whereclause .= ' AND biblioitems.itemtype='.$dbh->quote($itemtype) if $itemtype; + $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 + WHERE 1 + $whereclause + GROUP BY biblio.biblionumber + HAVING tot >0 + ORDER BY tot DESC + LIMIT $limit + "; + $template->param(itemtypesearch => 1); +} my $sth = $dbh->prepare($query); $sth->execute(); @@ -98,20 +123,34 @@ $template->param(do_it => 1, $template->param( branchloop => GetBranchesLoop(C4::Context->userenv->{'branch'})); -#doctype +# the index parameter is different for item-level itemtypes +my $itype_or_itemtype = (C4::Context->preference("item-level_itypes"))?'itype':'itemtype'; $itemtypes = GetItemTypes; -my @itemtypeloop; -foreach my $thisitemtype (sort {$itemtypes->{$a}->{'description'} cmp $itemtypes->{$b}->{'description'}} keys %$itemtypes) { +my @itemtypesloop; +my $selected=1; +if (!$advanced_search_types or $advanced_search_types eq 'itemtypes') { + foreach my $thisitemtype ( sort {$itemtypes->{$a}->{'description'} cmp $itemtypes->{$b}->{'description'} } keys %$itemtypes ) { my $selected = 1 if $thisitemtype eq $itemtype; - my %row =(value => $thisitemtype, - description => $itemtypes->{$thisitemtype}->{'description'}, - selected => $selected, - ); - push @itemtypeloop, \%row; + my %row =( value => $thisitemtype, + description => $itemtypes->{$thisitemtype}->{'description'}, + selected => $selected, + ); + push @itemtypesloop, \%row; + } +} else { + my $advsearchtypes = GetAuthorisedValues($advanced_search_types, '', 'opac'); + for my $thisitemtype (@$advsearchtypes) { + my $selected = 1 if $thisitemtype->{authorised_value} eq $itemtype; + my %row =( value => $thisitemtype->{authorised_value}, + selected => $selected, + description => $thisitemtype->{'lib'}, + ); + push @itemtypesloop, \%row; + } } $template->param( - itemtypeloop =>\@itemtypeloop, + itemtypeloop =>\@itemtypesloop, dateformat => C4::Context->preference("dateformat"), ); output_html_with_http_headers $input, $cookie, $template->output; -- 2.39.5