Revert "Bug 10606: Remove MySQLism in GetUpcomingDueIssues"
[koha.git] / opac / opac-search.pl
blobcdf0fbb4771457f342e245e1d957d09c07fb62da
1 #!/usr/bin/perl
3 # Copyright 2008 Garry Collum and the Koha Development team
4 # Copyright 2010 BibLibre
5 # Copyright 2011 KohaAloha, NZ
7 # This file is part of Koha.
9 # Koha is free software; you can redistribute it and/or modify it under the
10 # terms of the GNU General Public License as published by the Free Software
11 # Foundation; either version 2 of the License, or (at your option) any later
12 # version.
14 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
15 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
16 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
18 # You should have received a copy of the GNU General Public License along
19 # with Koha; if not, write to the Free Software Foundation, Inc.,
20 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
22 # Script to perform searching
23 # Mostly copied from search.pl, see POD there
24 use Modern::Perl;
26 ## STEP 1. Load things that are used in both search page and
27 # results page and decide which template to load, operations
28 # to perform, etc.
29 ## load Koha modules
30 use C4::Context;
31 use List::MoreUtils q/any/;
33 use C4::Output;
34 use C4::Auth qw(:DEFAULT get_session);
35 use C4::Languages qw(getLanguages);
36 use C4::Search;
37 use C4::Search::History;
38 use C4::Biblio; # GetBiblioData
39 use C4::Koha;
40 use C4::Tags qw(get_tags);
41 use C4::Branch; # GetBranches
42 use C4::SocialData;
43 use C4::Ratings;
44 use C4::External::OverDrive;
45 use C4::Members;
46 use C4::Reserves;
48 use POSIX qw(ceil floor strftime);
49 use URI::Escape;
50 use JSON qw/decode_json encode_json/;
51 use Business::ISBN;
53 my $DisplayMultiPlaceHold = C4::Context->preference("DisplayMultiPlaceHold");
54 # create a new CGI object
55 # FIXME: no_undef_params needs to be tested
56 use CGI qw('-no_undef_params' -utf8);
57 my $cgi = new CGI;
59 my $branch_group_limit = $cgi->param("branch_group_limit");
60 if ( $branch_group_limit ) {
61 if ( $branch_group_limit =~ /^multibranchlimit-/ ) {
62 # For search groups we are going to convert this branch_group_limit CGI
63 # parameter into a multibranchlimit CGI parameter for the purposes of
64 # actually performing the query
65 $cgi->param(
66 -name => 'multibranchlimit',
67 -values => substr($branch_group_limit, 17)
69 } else {
70 $cgi->append(
71 -name => 'limit',
72 -values => [ $branch_group_limit ]
77 BEGIN {
78 if (C4::Context->preference('BakerTaylorEnabled')) {
79 require C4::External::BakerTaylor;
80 import C4::External::BakerTaylor qw(&image_url &link_url);
84 my ($template,$borrowernumber,$cookie);
85 # decide which template to use
86 my $template_name;
87 my $template_type = 'basic';
88 my @params = $cgi->param("limit");
91 my $format = $cgi->param("format") || '';
92 my $build_grouped_results = C4::Context->preference('OPACGroupResults');
93 if ($format =~ /(rss|atom|opensearchdescription)/) {
94 $template_name = 'opac-opensearch.tt';
96 elsif (@params && $build_grouped_results) {
97 $template_name = 'opac-results-grouped.tt';
99 elsif ((@params>=1) || ($cgi->param("q")) || ($cgi->param('multibranchlimit')) || ($cgi->param('limit-yr')) ) {
100 $template_name = 'opac-results.tt';
102 else {
103 $template_name = 'opac-advsearch.tt';
104 $template_type = 'advsearch';
106 # load the template
107 ($template, $borrowernumber, $cookie) = get_template_and_user({
108 template_name => $template_name,
109 query => $cgi,
110 type => "opac",
111 authnotrequired => ( C4::Context->preference("OpacPublic") ? 1 : 0 ),
115 my $lang = C4::Languages::getlanguage($cgi);
117 if ($template_name eq 'opac-results.tt') {
118 $template->param('COinSinOPACResults' => C4::Context->preference('COinSinOPACResults'));
121 # get biblionumbers stored in the cart
122 my @cart_list;
124 if($cgi->cookie("bib_list")){
125 my $cart_list = $cgi->cookie("bib_list");
126 @cart_list = split(/\//, $cart_list);
129 if ($format eq 'rss2' or $format eq 'opensearchdescription' or $format eq 'atom') {
130 $template->param($format => 1);
131 $template->param(timestamp => strftime("%Y-%m-%dT%H:%M:%S-00:00", gmtime)) if ($format eq 'atom');
132 # FIXME - the timestamp is a hack - the biblio update timestamp should be used for each
133 # entry, but not sure if that's worth an extra database query for each bib
135 if (C4::Context->preference("marcflavour") eq "UNIMARC" ) {
136 $template->param('UNIMARC' => 1);
138 elsif (C4::Context->preference("marcflavour") eq "MARC21" ) {
139 $template->param('usmarc' => 1);
142 $template->param( 'OPACNoResultsFound' => C4::Context->preference('OPACNoResultsFound') );
144 $template->param(
145 OpacStarRatings => C4::Context->preference("OpacStarRatings") );
147 if (C4::Context->preference('BakerTaylorEnabled')) {
148 $template->param(
149 BakerTaylorEnabled => 1,
150 BakerTaylorImageURL => &image_url(),
151 BakerTaylorLinkURL => &link_url(),
152 BakerTaylorBookstoreURL => C4::Context->preference('BakerTaylorBookstoreURL'),
156 if (C4::Context->preference('TagsEnabled')) {
157 $template->param(TagsEnabled => 1);
158 foreach (qw(TagsShowOnList TagsInputOnList)) {
159 C4::Context->preference($_) and $template->param($_ => 1);
163 ## URI Re-Writing
164 # Deprecated, but preserved because it's interesting :-)
165 # The same thing can be accomplished with mod_rewrite in
166 # a more elegant way
168 #my $rewrite_flag;
169 #my $uri = $cgi->url(-base => 1);
170 #my $relative_url = $cgi->url(-relative=>1);
171 #$uri.="/".$relative_url."?";
172 #warn "URI:$uri";
173 #my @cgi_params_list = $cgi->param();
174 #my $url_params = $cgi->Vars;
176 #for my $each_param_set (@cgi_params_list) {
177 # $uri.= join "", map "\&$each_param_set=".$_, split("\0",$url_params->{$each_param_set}) if $url_params->{$each_param_set};
179 #warn "New URI:$uri";
180 # Only re-write a URI if there are params or if it already hasn't been re-written
181 #unless (($cgi->param('r')) || (!$cgi->param()) ) {
182 # print $cgi->redirect( -uri=>$uri."&r=1",
183 # -cookie => $cookie);
184 # exit;
187 # load the branches
189 my $branches = GetBranches(); # used later in *getRecords, probably should be internalized by those functions after caching in C4::Branch is established
190 $template->param(
191 searchdomainloop => GetBranchCategories('searchdomain'),
194 # load the language limits (for search)
195 my $languages_limit_loop = getLanguages($lang, 1);
196 $template->param(search_languages_loop => $languages_limit_loop,);
198 # load the Type stuff
199 my $itemtypes = GetItemTypes;
200 # the index parameter is different for item-level itemtypes
201 my $itype_or_itemtype = (C4::Context->preference("item-level_itypes"))?'itype':'itemtype';
202 my @advancedsearchesloop;
203 my $cnt;
204 my $advanced_search_types = C4::Context->preference("AdvancedSearchTypes") || "itemtypes";
205 my @advanced_search_types = split(/\|/, $advanced_search_types);
207 my $hidingrules = {};
208 my $yaml = C4::Context->preference('OpacHiddenItems');
209 if ( $yaml =~ /\S/ ) {
210 $yaml = "$yaml\n\n"; # YAML expects trailing newline. Surplus does not hurt.
211 eval {
212 $hidingrules = YAML::Load($yaml);
214 if ($@) {
215 warn "Unable to parse OpacHiddenItems syspref : $@";
219 foreach my $advanced_srch_type (@advanced_search_types) {
220 $advanced_srch_type =~ s/^\s*//;
221 $advanced_srch_type =~ s/\s*$//;
222 if ($advanced_srch_type eq 'itemtypes') {
223 # itemtype is a special case, since it's not defined in authorized values
224 my @itypesloop;
225 foreach my $thisitemtype ( sort {$itemtypes->{$a}->{'description'} cmp $itemtypes->{$b}->{'description'} } keys %$itemtypes ) {
226 next if $hidingrules->{itype} && any { $_ eq $thisitemtype } @{$hidingrules->{itype}};
227 next if $hidingrules->{itemtype} && any { $_ eq $thisitemtype } @{$hidingrules->{itemtype}};
228 my %row =( number=>$cnt++,
229 ccl => "$itype_or_itemtype,phr",
230 code => $thisitemtype,
231 description => $itemtypes->{$thisitemtype}->{'description'},
232 imageurl=> getitemtypeimagelocation( 'opac', $itemtypes->{$thisitemtype}->{'imageurl'} ),
234 push @itypesloop, \%row;
236 my %search_code = ( advanced_search_type => $advanced_srch_type,
237 code_loop => \@itypesloop );
238 push @advancedsearchesloop, \%search_code;
239 } else {
240 # covers all the other cases: non-itemtype authorized values
241 my $advsearchtypes = GetAuthorisedValues($advanced_srch_type, '', 'opac');
242 my @authvalueloop;
243 for my $thisitemtype (@$advsearchtypes) {
244 my $hiding_key = lc $thisitemtype->{category};
245 $hiding_key = "location" if $hiding_key eq 'loc';
246 next if $hidingrules->{$hiding_key} && any { $_ eq $thisitemtype->{authorised_value} } @{$hidingrules->{$hiding_key}};
247 my %row =(
248 number=>$cnt++,
249 ccl => $advanced_srch_type,
250 code => $thisitemtype->{authorised_value},
251 description => $thisitemtype->{'lib_opac'} || $thisitemtype->{'lib'},
252 imageurl => getitemtypeimagelocation( 'opac', $thisitemtype->{'imageurl'} ),
254 push @authvalueloop, \%row;
256 my %search_code = ( advanced_search_type => $advanced_srch_type,
257 code_loop => \@authvalueloop );
258 push @advancedsearchesloop, \%search_code;
261 $template->param(advancedsearchesloop => \@advancedsearchesloop);
263 # The following should only be loaded if we're bringing up the advanced search template
264 if ( $template_type && $template_type eq 'advsearch' ) {
265 # load the servers (used for searching -- to do federated searching, etc.)
266 my $primary_servers_loop;# = displayPrimaryServers();
267 $template->param(outer_servers_loop => $primary_servers_loop,);
269 my $secondary_servers_loop;
270 $template->param(outer_sup_servers_loop => $secondary_servers_loop,);
272 # set the default sorting
273 if ( C4::Context->preference('OPACdefaultSortField')
274 && C4::Context->preference('OPACdefaultSortOrder') ) {
275 my $default_sort_by =
276 C4::Context->preference('OPACdefaultSortField') . '_'
277 . C4::Context->preference('OPACdefaultSortOrder');
278 $template->param( sort_by => $default_sort_by );
281 # determine what to display next to the search boxes (ie, boolean option
282 # shouldn't appear on the first one, scan indexes should, adding a new
283 # box should only appear on the last, etc.
284 my @search_boxes_array;
285 my $search_boxes_count = 3; # begin whith 3 boxes
286 for (my $i=1;$i<=$search_boxes_count;$i++) {
287 # if it's the first one, don't display boolean option, but show scan indexes
288 if ($i==1) {
289 push @search_boxes_array,
291 scan_index => 1,
295 # if it's the last one, show the 'add field' box
296 elsif ($i==$search_boxes_count) {
297 push @search_boxes_array,
299 boolean => 1,
300 add_field => 1,
303 else {
304 push @search_boxes_array,
306 boolean => 1,
312 my @advsearch_limits = split /,/, C4::Context->preference('OpacAdvSearchOptions');
313 my @advsearch_more_limits = split /,/,
314 C4::Context->preference('OpacAdvSearchMoreOptions');
315 $template->param(
316 uc( C4::Context->preference("marcflavour") ) => 1, # we already did this for UNIMARC
317 advsearch => 1,
318 search_boxes_loop => \@search_boxes_array,
319 OpacAdvSearchOptions => \@advsearch_limits,
320 OpacAdvSearchMoreOptions => \@advsearch_more_limits,
323 # use the global setting by default
324 if ( C4::Context->preference("expandedSearchOption") == 1 ) {
325 $template->param( expanded_options => C4::Context->preference("expandedSearchOption") );
327 # but let the user override it
328 if (defined $cgi->param('expanded_options')) {
329 if ( ($cgi->param('expanded_options') == 0) || ($cgi->param('expanded_options') == 1 ) ) {
330 $template->param( expanded_options => $cgi->param('expanded_options'));
334 if (C4::Context->preference('OPACNumbersPreferPhrase')) {
335 $template->param('numbersphr' => 1);
338 output_html_with_http_headers $cgi, $cookie, $template->output;
339 exit;
342 ### OK, if we're this far, we're performing an actual search
344 # Fetch the paramater list as a hash in scalar context:
345 # * returns paramater list as tied hash ref
346 # * we can edit the values by changing the key
347 # * multivalued CGI paramaters are returned as a packaged string separated by "\0" (null)
348 my $params = $cgi->Vars;
349 my $tag;
350 $tag = $params->{tag} if $params->{tag};
353 # String with params with the search criteria for the paging in opac-detail
354 # param value is URI encoded and params separator is HTML encode (&amp;)
355 my $pasarParams = '';
356 my $j = 0;
357 for (keys %$params) {
358 my @pasarParam = $cgi->param($_);
359 for my $paramValue(@pasarParam) {
360 $pasarParams .= '&amp;' if ($j > 0);
361 $pasarParams .= $_ . '=' . uri_escape_utf8($paramValue);
362 $j++;
366 # Params that can have more than one value
367 # sort by is used to sort the query
368 # in theory can have more than one but generally there's just one
369 my @sort_by;
370 my $default_sort_by;
371 if ( C4::Context->preference('OPACdefaultSortField')
372 && C4::Context->preference('OPACdefaultSortOrder') ) {
373 $default_sort_by =
374 C4::Context->preference('OPACdefaultSortField') . '_'
375 . C4::Context->preference('OPACdefaultSortOrder');
378 my @allowed_sortby = qw /acqdate_asc acqdate_dsc author_az author_za call_number_asc call_number_dsc popularity_asc popularity_dsc pubdate_asc pubdate_dsc relevance title_az title_za/;
379 @sort_by = $cgi->param('sort_by');
380 $sort_by[0] = $default_sort_by if !$sort_by[0] && defined($default_sort_by);
381 foreach my $sort (@sort_by) {
382 if ( grep { /^$sort$/ } @allowed_sortby ) {
383 $template->param($sort => 1);
386 $template->param('sort_by' => $sort_by[0]);
388 # Use the servers defined, or just search our local catalog(default)
389 my @servers = $cgi->param('server');
390 unless (@servers) {
391 #FIXME: this should be handled using Context.pm
392 @servers = ("biblioserver");
393 # @servers = C4::Context->config("biblioserver");
396 # operators include boolean and proximity operators and are used
397 # to evaluate multiple operands
398 my @operators = $cgi->param('op');
399 @operators = map { uri_unescape($_) } @operators;
401 # indexes are query qualifiers, like 'title', 'author', etc. They
402 # can be single or multiple parameters separated by comma: kw,right-Truncation
403 my @indexes = $cgi->param('idx');
404 @indexes = map { uri_unescape($_) } @indexes;
406 # if a simple index (only one) display the index used in the top search box
407 if ($indexes[0] && !$indexes[1]) {
408 $template->param("ms_".$indexes[0] => 1);
410 # an operand can be a single term, a phrase, or a complete ccl query
411 my @operands = $cgi->param('q');
412 @operands = map { uri_unescape($_) } @operands;
414 $template->{VARS}->{querystring} = join(' ', @operands);
416 # if a simple search, display the value in the search box
417 if ($operands[0] && !$operands[1]) {
418 my $ms_query = $operands[0];
419 $ms_query =~ s/ #\S+//;
420 $template->param(ms_value => $ms_query);
423 # limits are use to limit to results to a pre-defined category such as branch or language
424 my @limits = $cgi->param('limit');
425 @limits = map { uri_unescape($_) } @limits;
426 my @nolimits = $cgi->param('nolimit');
427 @nolimits = map { uri_unescape($_) } @nolimits;
428 my %is_nolimit = map { $_ => 1 } @nolimits;
429 @limits = grep { not $is_nolimit{$_} } @limits;
431 if($params->{'multibranchlimit'}) {
432 my $multibranch = '('.join( " or ", map { "branch: $_ " } @{ GetBranchesInCategory( $params->{'multibranchlimit'} ) } ).')';
433 push @limits, $multibranch if ($multibranch ne '()');
436 my $available;
437 foreach my $limit(@limits) {
438 if ($limit =~/available/) {
439 $available = 1;
442 $template->param(available => $available);
444 # append year limits if they exist
445 if ($params->{'limit-yr'}) {
446 if ($params->{'limit-yr'} =~ /\d{4}-\d{4}/) {
447 my ($yr1,$yr2) = split(/-/, $params->{'limit-yr'});
448 push @limits, "yr,st-numeric,ge=$yr1 and yr,st-numeric,le=$yr2";
450 elsif ($params->{'limit-yr'} =~ /\d{4}/) {
451 push @limits, "yr,st-numeric=$params->{'limit-yr'}";
453 else {
454 #FIXME: Should return a error to the user, incorect date format specified
458 # Params that can only have one value
459 my $scan = $params->{'scan'};
460 my $count = C4::Context->preference('OPACnumSearchResults') || 20;
461 my $countRSS = C4::Context->preference('numSearchRSSResults') || 50;
462 my $results_per_page = $params->{'count'} || $count;
463 my $offset = $params->{'offset'} || 0;
464 my $page = $cgi->param('page') || 1;
465 $offset = ($page-1)*$results_per_page if $page>1;
466 my $hits;
467 my $expanded_facet = $params->{'expand'};
469 # Define some global variables
470 my ($error,$query,$simple_query,$query_cgi,$query_desc,$limit,$limit_cgi,$limit_desc,$stopwords_removed,$query_type);
472 my @results;
474 ## I. BUILD THE QUERY
475 ( $error,$query,$simple_query,$query_cgi,$query_desc,$limit,$limit_cgi,$limit_desc,$stopwords_removed,$query_type) = buildQuery(\@operators,\@operands,\@indexes,\@limits,\@sort_by, 0, $lang);
477 sub _input_cgi_parse {
478 my @elements;
479 for my $this_cgi ( split('&',shift) ) {
480 next unless $this_cgi;
481 $this_cgi =~ /(.*?)=(.*)/;
482 push @elements, { input_name => $1, input_value => Encode::decode_utf8( uri_unescape($2) ) };
484 return @elements;
487 ## parse the query_cgi string and put it into a form suitable for <input>s
488 my @query_inputs = _input_cgi_parse($query_cgi);
489 $template->param ( QUERY_INPUTS => \@query_inputs );
491 ## parse the limit_cgi string and put it into a form suitable for <input>s
492 my @limit_inputs = $limit_cgi ? _input_cgi_parse($limit_cgi) : ();
494 # add OPAC 'hidelostitems'
495 #if (C4::Context->preference('hidelostitems') == 1) {
496 # # either lost ge 0 or no value in the lost register
497 # $query ="($query) and ( (lost,st-numeric <= 0) or ( allrecords,AlwaysMatches='' not lost,AlwaysMatches='') )";
500 # add OPAC suppression - requires at least one item indexed with Suppress
501 if (C4::Context->preference('OpacSuppression')) {
502 # OPAC suppression by IP address
503 if (C4::Context->preference('OpacSuppressionByIPRange')) {
504 my $IPAddress = $ENV{'REMOTE_ADDR'};
505 my $IPRange = C4::Context->preference('OpacSuppressionByIPRange');
506 if ($IPAddress !~ /^$IPRange/) {
507 if ( $query_type eq 'pqf' ) {
508 $query = '@not '.$query.' @attr 1=9011 1';
509 } else {
510 $query = "($query) not Suppress=1";
514 else {
515 if ( $query_type eq 'pqf' ) {
516 #$query = "($query) && -(suppress:1)"; #QP syntax
517 $query = '@not '.$query.' @attr 1=9011 1'; #PQF syntax
518 } else {
519 $query = "($query) not Suppress=1";
524 $template->param ( LIMIT_INPUTS => \@limit_inputs );
525 $template->param ( OPACResultsSidebar => C4::Context->preference('OPACResultsSidebar'));
527 ## II. DO THE SEARCH AND GET THE RESULTS
528 my $total = 0; # the total results for the whole set
529 my $facets; # this object stores the faceted results that display on the left-hand of the results page
530 my @results_array;
531 my $results_hashref;
532 my @coins;
534 if ($tag) {
535 $query_cgi = "tag=" .$tag . "&" . $query_cgi;
536 my $taglist = get_tags({term=>$tag, approved=>1});
537 $results_hashref->{biblioserver}->{hits} = scalar (@$taglist);
538 my @biblist = (map {GetBiblioData($_->{biblionumber})} @$taglist);
539 my @marclist = (map { (C4::Context->config('zebra_bib_index_mode') eq 'dom')? $_->{marcxml}: $_->{marc}; } @biblist);
540 $DEBUG and printf STDERR "taglist (%s biblionumber)\nmarclist (%s records)\n", scalar(@$taglist), scalar(@marclist);
541 $results_hashref->{biblioserver}->{RECORDS} = \@marclist;
542 # FIXME: tag search and standard search should work together, not exclusively
543 # FIXME: No facets for tags search.
544 } elsif ($build_grouped_results) {
545 eval {
546 ($error, $results_hashref, $facets) = C4::Search::pazGetRecords($query,$simple_query,\@sort_by,\@servers,$results_per_page,$offset,$expanded_facet,$branches,$query_type,$scan);
548 } else {
549 $pasarParams .= '&amp;query=' . uri_escape_utf8($query);
550 $pasarParams .= '&amp;count=' . uri_escape_utf8($results_per_page);
551 $pasarParams .= '&amp;simple_query=' . uri_escape_utf8($simple_query);
552 $pasarParams .= '&amp;query_type=' . uri_escape_utf8($query_type) if ($query_type);
553 eval {
554 ($error, $results_hashref, $facets) = getRecords($query,$simple_query,\@sort_by,\@servers,$results_per_page,$offset,$expanded_facet,$branches,$itemtypes,$query_type,$scan,1);
557 # This sorts the facets into alphabetical order
558 if ($facets) {
559 foreach my $f (@$facets) {
560 $f->{facets} = [ sort { uc($a->{facet_title_value}) cmp uc($b->{facet_title_value}) } @{ $f->{facets} } ];
562 @$facets = sort {$a->{expand} cmp $b->{expand}} @$facets;
565 # use Data::Dumper; print STDERR "-" x 25, "\n", Dumper($results_hashref);
566 if ($@ || $error) {
567 $template->param(query_error => $error.$@);
568 output_html_with_http_headers $cgi, $cookie, $template->output;
569 exit;
572 my $borrower = $borrowernumber ? GetMember( borrowernumber => $borrowernumber ) : undef;
574 # At this point, each server has given us a result set
575 # now we build that set for template display
576 my %allow_onshelf_holds;
577 my @sup_results_array;
578 for (my $i=0;$i<@servers;$i++) {
579 my $server = $servers[$i];
580 if ($server && $server =~/biblioserver/) { # this is the local bibliographic server
581 $hits = $results_hashref->{$server}->{"hits"};
582 my $page = $cgi->param('page') || 0;
583 my @newresults;
584 if ($build_grouped_results) {
585 foreach my $group (@{ $results_hashref->{$server}->{"GROUPS"} }) {
586 # because pazGetRecords handles retieving only the records
587 # we want as specified by $offset and $results_per_page,
588 # we need to set the offset parameter of searchResults to 0
589 my @group_results = searchResults( 'opac', $query_desc, $group->{'group_count'},$results_per_page, 0, $scan,
590 $group->{"RECORDS"});
591 if ($borrower) {
592 $_->{holdable} =
593 IsAvailableForItemLevelRequest($_, $borrower) &&
594 OPACItemHoldsAllowed($_, $borrower)
595 foreach @group_results;
597 push @newresults, { group_label => $group->{'group_label'}, GROUP_RESULTS => \@group_results };
599 } else {
600 @newresults = searchResults('opac', $query_desc, $hits, $results_per_page, $offset, $scan,
601 $results_hashref->{$server}->{"RECORDS"});
602 if ($borrower) {
603 $_->{holdable} =
604 IsAvailableForItemLevelRequest($_, $borrower) &&
605 OPACItemHoldsAllowed($_, $borrower)
606 foreach @newresults;
609 $hits = 0 unless @newresults;
611 foreach my $res (@newresults) {
613 # must define a value for size if not present in DB
614 # in order to avoid problems generated by the default size value in TT
615 if ( not exists $res->{'size'} ) { $res->{'size'} = "" }
616 # while we're checking each line, see if item is in the cart
617 if ( grep {$_ eq $res->{'biblionumber'}} @cart_list) {
618 $res->{'incart'} = 1;
621 if (C4::Context->preference('COinSinOPACResults')) {
622 my $record = GetMarcBiblio($res->{'biblionumber'});
623 $res->{coins} = GetCOinSBiblio($record);
625 if ( C4::Context->preference( "Babeltheque" ) and $res->{normalized_isbn} ) {
626 if( my $isbn = Business::ISBN->new( $res->{normalized_isbn} ) ) {
627 $isbn = $isbn->as_isbn13->as_string;
628 $isbn =~ s/-//g;
629 my $social_datas = C4::SocialData::get_data( $isbn );
630 if ( $social_datas ) {
631 for my $key ( keys %$social_datas ) {
632 $res->{$key} = $$social_datas{$key};
633 if ( $key eq 'score_avg' ){
634 $res->{score_int} = sprintf("%.0f", $$social_datas{score_avg} );
641 if (C4::Context->preference('TagsEnabled') and
642 C4::Context->preference('TagsShowOnList')) {
643 if ( my $bibnum = $res->{biblionumber} ) {
644 $res->{itemsissued} = CountItemsIssued( $bibnum );
645 $res->{'TagLoop'} = get_tags({
646 biblionumber => $bibnum,
647 approved => 1,
648 sort => '-weight',
649 limit => C4::Context->preference('TagsShowOnList')
654 if ( C4::Context->preference('OpacStarRatings') eq 'all' ) {
655 my $rating = GetRating( $res->{'biblionumber'}, $borrowernumber );
656 $res->{'rating_value'} = $rating->{'rating_value'};
657 $res->{'rating_total'} = $rating->{'rating_total'};
658 $res->{'rating_avg'} = $rating->{'rating_avg'};
659 $res->{'rating_avg_int'} = $rating->{'rating_avg_int'};
663 if ($results_hashref->{$server}->{"hits"}){
664 $total = $total + $hits;
667 # Opac search history
668 if (C4::Context->preference('EnableOpacSearchHistory')) {
669 unless ( $offset ) {
670 my $path_info = $cgi->url(-path_info=>1);
671 my $query_cgi_history = $cgi->url(-query=>1);
672 $query_cgi_history =~ s/^$path_info\?//;
673 $query_cgi_history =~ s/;/&/g;
674 my $query_desc_history = join ", ", grep { defined $_ } $query_desc, $limit_desc;
676 unless ( $borrowernumber ) {
677 my $new_searches = C4::Search::History::add_to_session({
678 cgi => $cgi,
679 query_desc => $query_desc_history,
680 query_cgi => $query_cgi_history,
681 total => $total,
682 type => "biblio",
684 } else {
685 # To the session (the user is logged in)
686 C4::Search::History::add({
687 userid => $borrowernumber,
688 sessionid => $cgi->cookie("CGISESSID"),
689 query_desc => $query_desc_history,
690 query_cgi => $query_cgi_history,
691 total => $total,
692 type => "biblio",
696 $template->param( EnableOpacSearchHistory => 1 );
699 ## If there's just one result, redirect to the detail page
700 if ($total == 1 && $format ne 'rss2'
701 && $format ne 'opensearchdescription' && $format ne 'atom') {
702 my $biblionumber=$newresults[0]->{biblionumber};
703 if (C4::Context->preference('BiblioDefaultView') eq 'isbd') {
704 print $cgi->redirect("/cgi-bin/koha/opac-ISBDdetail.pl?biblionumber=$biblionumber");
705 } elsif (C4::Context->preference('BiblioDefaultView') eq 'marc') {
706 print $cgi->redirect("/cgi-bin/koha/opac-MARCdetail.pl?biblionumber=$biblionumber");
707 } else {
708 print $cgi->redirect("/cgi-bin/koha/opac-detail.pl?biblionumber=$biblionumber");
710 exit;
712 if ($hits) {
713 if ( !$build_grouped_results ) {
714 # We build the encrypted list of first OPACnumSearchResults biblios to pass with the search criteria for paging on opac-detail
715 $pasarParams .= '&amp;listBiblios=';
716 my $j = 0;
717 foreach (@newresults) {
718 my $bibnum = ($_->{biblionumber})?$_->{biblionumber}:0;
719 $pasarParams .= uri_escape_utf8($bibnum) . ',';
720 $j++;
721 last if ($j == $results_per_page);
723 chop $pasarParams if ($pasarParams =~ /,$/);
724 $pasarParams .= '&amp;total=' . uri_escape_utf8( int($total) ) if ($pasarParams !~ /total=(?:[0-9]+)?/);
725 if ($pasarParams) {
726 my $session = get_session($cgi->cookie("CGISESSID"));
727 $session->param('busc' => $pasarParams);
731 $template->param(total => $hits);
732 my $limit_cgi_not_availablity = $limit_cgi;
733 $limit_cgi_not_availablity =~ s/&limit=available//g if defined $limit_cgi_not_availablity;
734 $template->param(limit_cgi_not_availablity => $limit_cgi_not_availablity);
735 $template->param(limit_cgi => $limit_cgi);
736 $template->param(countrss => $countRSS );
737 $template->param(query_cgi => $query_cgi);
738 $template->param(query_desc => $query_desc);
739 $template->param(limit_desc => $limit_desc);
740 $template->param(offset => $offset);
741 $template->param(DisplayMultiPlaceHold => $DisplayMultiPlaceHold);
742 if ($query_desc || $limit_desc) {
743 $template->param(searchdesc => 1);
745 $template->param(stopwords_removed => "@$stopwords_removed") if $stopwords_removed;
746 $template->param(results_per_page => $results_per_page);
747 my $hide = C4::Context->preference('OpacHiddenItems');
748 $hide = ($hide =~ m/\S/) if $hide; # Just in case it has some spaces/new lines
749 my $branch = '';
750 if (C4::Context->userenv){
751 $branch = C4::Context->userenv->{branch};
753 if ( C4::Context->preference('HighlightOwnItemsOnOPAC') ) {
754 if (
755 ( ( C4::Context->preference('HighlightOwnItemsOnOPACWhich') eq 'PatronBranch' ) && $branch )
757 C4::Context->preference('HighlightOwnItemsOnOPACWhich') eq 'OpacURLBranch'
759 my $branchname;
760 if ( C4::Context->preference('HighlightOwnItemsOnOPACWhich') eq 'PatronBranch' ) {
761 $branchname = $branches->{$branch}->{'branchname'};
763 elsif ( C4::Context->preference('HighlightOwnItemsOnOPACWhich') eq 'OpacURLBranch' ) {
764 $branchname = $branches->{ $ENV{'BRANCHCODE'} }->{'branchname'};
767 foreach my $res ( @newresults ) {
768 my @new_loop;
769 my @top_loop;
770 my @old_loop = @{$res->{'available_items_loop'}};
771 foreach my $item ( @old_loop ) {
772 if ( $item->{'branchname'} eq $branchname ) {
773 $item->{'this_branch'} = 1;
774 push( @top_loop, $item );
775 } else {
776 push( @new_loop, $item );
779 my @complete_loop = ( @top_loop, @new_loop );
780 $res->{'available_items_loop'} = \@complete_loop;
785 $template->param(
786 SEARCH_RESULTS => \@newresults,
787 OPACItemsResultsDisplay => (C4::Context->preference("OPACItemsResultsDisplay")),
788 suppress_result_number => $hide,
790 if (C4::Context->preference("OPACLocalCoverImages")){
791 $template->param(OPACLocalCoverImages => 1);
792 $template->param(OPACLocalCoverImagesPriority => C4::Context->preference("OPACLocalCoverImagesPriority"));
794 ## Build the page numbers on the bottom of the page
795 my @page_numbers;
796 # total number of pages there will be
797 my $pages = ceil($hits / $results_per_page);
798 # default page number
799 my $current_page_number = 1;
800 if ($offset) {
801 $current_page_number = ( $offset / $results_per_page + 1 );
803 my $previous_page_offset;
804 if ( $offset >= $results_per_page ) {
805 $previous_page_offset = $offset - $results_per_page;
807 my $next_page_offset = $offset + $results_per_page;
808 # If we're within the first 10 pages, keep it simple
809 #warn "current page:".$current_page_number;
810 if ($current_page_number < 10) {
811 # just show the first 10 pages
812 # Loop through the pages
813 my $pages_to_show = 10;
814 $pages_to_show = $pages if $pages<10;
815 for ($i=1; $i<=$pages_to_show;$i++) {
816 # the offset for this page
817 my $this_offset = (($i*$results_per_page)-$results_per_page);
818 # the page number for this page
819 my $this_page_number = $i;
820 # put it in the array
821 push @page_numbers,
822 { offset => $this_offset,
823 pg => $this_page_number,
824 highlight => $this_page_number == $current_page_number,
825 sort_by => join ' ', @sort_by
831 # now, show twenty pages, with the current one smack in the middle
832 else {
833 for ($i=$current_page_number; $i<=($current_page_number + 20 );$i++) {
834 my $this_offset = ((($i-9)*$results_per_page)-$results_per_page);
835 my $this_page_number = $i-9;
836 if ( $this_page_number <= $pages ) {
837 push @page_numbers,
838 { offset => $this_offset,
839 pg => $this_page_number,
840 highlight => $this_page_number == $current_page_number,
841 sort_by => join ' ', @sort_by
847 $template->param( PAGE_NUMBERS => \@page_numbers,
848 previous_page_offset => $previous_page_offset) unless $pages < 2;
849 $template->param(next_page_offset => $next_page_offset) unless $pages eq $current_page_number;
851 # no hits
852 else {
853 my $nohits = C4::Context->preference('OPACNoResultsFound');
854 if ($nohits and $nohits=~/{QUERY_KW}/){
855 # extracting keywords in case of relaunching search
856 (my $query_kw=$query_desc)=~s/ and|or / /g;
857 $query_kw = Encode::decode_utf8($query_kw);
858 my @query_kw=($query_kw=~ /([-\w]+\b)(?:[^,:]|$)/g);
859 $query_kw=join('+',@query_kw);
860 $nohits=~s/{QUERY_KW}/$query_kw/g;
861 $template->param('OPACNoResultsFound' =>$nohits);
863 $template->param(
864 searchdesc => 1,
865 query_desc => $query_desc,
866 limit_desc => $limit_desc,
867 query_cgi => $query_cgi,
868 limit_cgi => $limit_cgi
871 } # end of the if local
872 # asynchronously search the authority server
873 elsif ($server && $server =~/authorityserver/) { # this is the local authority server
874 my @inner_sup_results_array;
875 for my $sup_record ( @{$results_hashref->{$server}->{"RECORDS"}} ) {
876 my $marc_record_object = MARC::Record->new_from_usmarc($sup_record);
877 my $title_field = $marc_record_object->field(100);
878 push @inner_sup_results_array, {
879 'title' => $title_field->subfield('a'),
880 'link' => "&amp;idx=an&amp;q=".$marc_record_object->field('001')->as_string(),
883 my $servername = $server;
884 push @sup_results_array, { servername => $servername,
885 inner_sup_results_loop => \@inner_sup_results_array} if @inner_sup_results_array;
887 # FIXME: can add support for other targets as needed here
888 $template->param( outer_sup_results_loop => \@sup_results_array);
889 } #/end of the for loop
890 #$template->param(FEDERATED_RESULTS => \@results_array);
892 for my $facet ( @$facets ) {
893 for my $entry ( @{ $facet->{facets} } ) {
894 my $index = $entry->{type_link_value};
895 my $value = $entry->{facet_link_value};
896 $entry->{active} = grep { $_->{input_value} eq qq{$index:$value} } @limit_inputs;
901 $template->param(
902 #classlist => $classlist,
903 total => $total,
904 opacfacets => 1,
905 facets_loop => $facets,
906 displayFacetCount=> C4::Context->preference('displayFacetCount')||0,
907 scan => $scan,
908 search_error => $error,
911 if ($query_desc || $limit_desc) {
912 $template->param(searchdesc => 1);
915 # VI. BUILD THE TEMPLATE
916 # Build drop-down list for 'Add To:' menu...
917 my ($totalref, $pubshelves, $barshelves)=
918 C4::VirtualShelves::GetSomeShelfNames($borrowernumber,'COMBO',1);
919 $template->param(
920 addbarshelves => $totalref->{bartotal},
921 addbarshelvesloop => $barshelves,
922 addpubshelves => $totalref->{pubtotal},
923 addpubshelvesloop => $pubshelves,
926 my $content_type = ($format eq 'rss' or $format eq 'atom') ? $format : 'html';
928 # If GoogleIndicTransliteration system preference is On Set paramter to load Google's javascript in OPAC search screens
929 if (C4::Context->preference('GoogleIndicTransliteration')) {
930 $template->param('GoogleIndicTransliteration' => 1);
933 $template->{VARS}->{DidYouMean} =
934 ( defined C4::Context->preference('OPACdidyoumean')
935 && C4::Context->preference('OPACdidyoumean') =~ m/enable/ );
936 $template->{VARS}->{IDreamBooksReviews} = C4::Context->preference('IDreamBooksReviews');
937 $template->{VARS}->{IDreamBooksReadometer} = C4::Context->preference('IDreamBooksReadometer');
938 $template->{VARS}->{IDreamBooksResults} = C4::Context->preference('IDreamBooksResults');
940 if ($offset == 0 && IsOverDriveEnabled()) {
941 $template->param(OverDriveEnabled => 1);
942 $template->param(OverDriveLibraryID => C4::Context->preference('OverDriveLibraryID'));
945 $template->param( borrowernumber => $borrowernumber);
946 output_with_http_headers $cgi, $cookie, $template->output, $content_type;