3 # This file is part of Koha.
5 # Koha is free software; you can redistribute it and/or modify it under the
6 # terms of the GNU General Public License as published by the Free Software
7 # Foundation; either version 2 of the License, or (at your option) any later
10 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
11 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
12 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
14 # You should have received a copy of the GNU General Public License along with
15 # Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
16 # Suite 330, Boston, MA 02111-1307 USA
19 # use warnings; # FIXME
22 use C4::Biblio; # GetMarcFromKohaField, GetBiblioData
23 use C4::Koha; # getFacets
24 use C4::Search::PazPar2;
26 use C4::Dates qw(format_date);
31 use vars qw($VERSION @ISA @EXPORT @EXPORT_OK %EXPORT_TAGS $DEBUG);
33 # set the version for version checking
36 $DEBUG = ($ENV{DEBUG}) ? 1 : 0;
41 C4::Search - Functions for searching the Koha catalog.
45 See opac/opac-search.pl or catalogue/search.pl for example of usage
49 This module provides searching functions for Koha's bibliographic databases
66 # make all your functions, whether exported or not;
68 =head2 GetDistinctValues($field);
70 C<$field> is a reference to the fields array
74 sub GetDistinctValues {
75 my ($fieldname,$string)=@_;
76 # returns a reference to a hash of references to branches...
77 if ($fieldname=~/\./){
78 my ($table,$column)=split /\./, $fieldname;
79 my $dbh = C4::Context->dbh;
80 warn "select DISTINCT($column) as value, count(*) as cnt from $table group by lib order by $column ";
81 my $sth = $dbh->prepare("select DISTINCT($column) as value, count(*) as cnt from $table ".($string?" where $column like \"$string%\"":"")."group by value order by $column ");
83 my $elements=$sth->fetchall_arrayref({});
88 my @servers=qw<biblioserver authorityserver>;
89 my (@zconns,@results);
90 for ( my $i = 0 ; $i < @servers ; $i++ ) {
91 $zconns[$i] = C4::Context->Zconn( $servers[$i], 1 );
94 ZOOM::Query::CCL2RPN->new( qq"$fieldname $string", $zconns[$i])
97 # The big moment: asynchronously retrieve results from all servers
99 while ( ( my $i = ZOOM::event( \@zconns ) ) != 0 ) {
100 my $ev = $zconns[ $i - 1 ]->last_event();
101 if ( $ev == ZOOM::Event::ZEND ) {
102 next unless $results[ $i - 1 ];
103 my $size = $results[ $i - 1 ]->size();
105 for (my $j=0;$j<$size;$j++){
107 @hashscan{qw(value cnt)}=$results[ $i - 1 ]->display_term($j);
108 push @elements, \%hashscan;
119 ($biblionumber,$biblionumber,$title) = FindDuplicate($record);
121 This function attempts to find duplicate records using a hard-coded, fairly simplistic algorithm
127 my $dbh = C4::Context->dbh;
128 my $result = TransformMarcToKoha( $dbh, $record, '' );
133 my ( $biblionumber, $title );
135 # search duplicate on ISBN, easy and fast..
136 # ... normalize first
137 if ( $result->{isbn} ) {
138 $result->{isbn} =~ s/\(.*$//;
139 $result->{isbn} =~ s/\s+$//;
140 $query = "isbn=$result->{isbn}";
143 $result->{title} =~ s /\\//g;
144 $result->{title} =~ s /\"//g;
145 $result->{title} =~ s /\(//g;
146 $result->{title} =~ s /\)//g;
148 # FIXME: instead of removing operators, could just do
149 # quotes around the value
150 $result->{title} =~ s/(and|or|not)//g;
151 $query = "ti,ext=$result->{title}";
152 $query .= " and itemtype=$result->{itemtype}"
153 if ( $result->{itemtype} );
154 if ( $result->{author} ) {
155 $result->{author} =~ s /\\//g;
156 $result->{author} =~ s /\"//g;
157 $result->{author} =~ s /\(//g;
158 $result->{author} =~ s /\)//g;
160 # remove valid operators
161 $result->{author} =~ s/(and|or|not)//g;
162 $query .= " and au,ext=$result->{author}";
166 # FIXME: add error handling
167 my ( $error, $searchresults ) = SimpleSearch($query); # FIXME :: hardcoded !
169 foreach my $possible_duplicate_record (@$searchresults) {
171 MARC::Record->new_from_usmarc($possible_duplicate_record);
172 my $result = TransformMarcToKoha( $dbh, $marcrecord, '' );
174 # FIXME :: why 2 $biblionumber ?
176 push @results, $result->{'biblionumber'};
177 push @results, $result->{'title'};
185 ( $error, $results, $total_hits ) = SimpleSearch( $query, $offset, $max_results, [@servers] );
187 This function provides a simple search API on the bibliographic catalog
193 * $query can be a simple keyword or a complete CCL query
194 * @servers is optional. Defaults to biblioserver as found in koha-conf.xml
195 * $offset - If present, represents the number of records at the beggining to omit. Defaults to 0
196 * $max_results - if present, determines the maximum number of records to fetch. undef is All. defaults to undef.
201 * $error is a empty unless an error is detected
202 * \@results is an array of records.
203 * $total_hits is the number of hits that would have been returned with no limit
205 =item C<usage in the script:>
209 my ( $error, $marcresults, $total_hits ) = SimpleSearch($query);
211 if (defined $error) {
212 $template->param(query_error => $error);
213 warn "error: ".$error;
214 output_html_with_http_headers $input, $cookie, $template->output;
218 my $hits = scalar @$marcresults;
221 for my $i (0..$hits) {
223 my $marcrecord = MARC::File::USMARC::decode($marcresults->[$i]);
224 my $biblio = TransformMarcToKoha(C4::Context->dbh,$marcrecord,'');
226 #build the hash for the template.
227 $resultsloop{highlight} = ($i % 2)?(1):(0);
228 $resultsloop{title} = $biblio->{'title'};
229 $resultsloop{subtitle} = $biblio->{'subtitle'};
230 $resultsloop{biblionumber} = $biblio->{'biblionumber'};
231 $resultsloop{author} = $biblio->{'author'};
232 $resultsloop{publishercode} = $biblio->{'publishercode'};
233 $resultsloop{publicationyear} = $biblio->{'publicationyear'};
235 push @results, \%resultsloop;
238 $template->param(result=>\@results);
243 my ( $query, $offset, $max_results, $servers ) = @_;
245 if ( C4::Context->preference('NoZebra') ) {
246 my $result = NZorder( NZanalyse($query) )->{'biblioserver'};
249 && $result->{hits} > 0 ? $result->{'RECORDS'} : [] );
250 return ( undef, $search_result, scalar($result->{hits}) );
253 # FIXME hardcoded value. See catalog/search.pl & opac-search.pl too.
254 my @servers = defined ( $servers ) ? @$servers : ( "biblioserver" );
260 return ( "No query entered", undef, undef ) unless $query;
262 # Initialize & Search Zebra
263 for ( my $i = 0 ; $i < @servers ; $i++ ) {
265 $zconns[$i] = C4::Context->Zconn( $servers[$i], 1 );
266 $zoom_queries[$i] = new ZOOM::Query::CCL2RPN( $query, $zconns[$i]);
267 $tmpresults[$i] = $zconns[$i]->search( $zoom_queries[$i] );
271 $zconns[$i]->errmsg() . " ("
272 . $zconns[$i]->errcode() . ") "
273 . $zconns[$i]->addinfo() . " "
274 . $zconns[$i]->diagset();
276 return ( $error, undef, undef ) if $zconns[$i]->errcode();
280 # caught a ZOOM::Exception
284 . $@->addinfo() . " "
287 return ( $error, undef, undef );
290 while ( ( my $i = ZOOM::event( \@zconns ) ) != 0 ) {
291 my $event = $zconns[ $i - 1 ]->last_event();
292 if ( $event == ZOOM::Event::ZEND ) {
294 my $first_record = defined( $offset ) ? $offset+1 : 1;
295 my $hits = $tmpresults[ $i - 1 ]->size();
296 $total_hits += $hits;
297 my $last_record = $hits;
298 if ( defined $max_results && $offset + $max_results < $hits ) {
299 $last_record = $offset + $max_results;
302 for my $j ( $first_record..$last_record ) {
303 my $record = $tmpresults[ $i - 1 ]->record( $j-1 )->raw(); # 0 indexed
304 push @results, $record;
309 foreach my $result (@tmpresults) {
312 foreach my $zoom_query (@zoom_queries) {
313 $zoom_query->destroy();
316 return ( undef, \@results, $total_hits );
322 ( undef, $results_hashref, \@facets_loop ) = getRecords (
324 $koha_query, $simple_query, $sort_by_ref, $servers_ref,
325 $results_per_page, $offset, $expanded_facet, $branches,
329 The all singing, all dancing, multi-server, asynchronous, scanning,
330 searching, record nabbing, facet-building
332 See verbse embedded documentation.
338 $koha_query, $simple_query, $sort_by_ref, $servers_ref,
339 $results_per_page, $offset, $expanded_facet, $branches,
343 my @servers = @$servers_ref;
344 my @sort_by = @$sort_by_ref;
346 # Initialize variables for the ZOOM connection and results object
350 my $results_hashref = ();
352 # Initialize variables for the faceted results objects
353 my $facets_counter = ();
354 my $facets_info = ();
355 my $facets = getFacets();
357 my @facets_loop; # stores the ref to array of hashes for template facets loop
359 ### LOOP THROUGH THE SERVERS
360 for ( my $i = 0 ; $i < @servers ; $i++ ) {
361 $zconns[$i] = C4::Context->Zconn( $servers[$i], 1 );
363 # perform the search, create the results objects
364 # if this is a local search, use the $koha-query, if it's a federated one, use the federated-query
365 my $query_to_use = ($servers[$i] =~ /biblioserver/) ? $koha_query : $simple_query;
367 #$query_to_use = $simple_query if $scan;
368 warn $simple_query if ( $scan and $DEBUG );
370 # Check if we've got a query_type defined, if so, use it
374 if ( $query_type =~ /^ccl/ ) {
376 s/\:/\=/g; # change : to = last minute (FIXME)
379 new ZOOM::Query::CCL2RPN( $query_to_use, $zconns[$i] )
382 elsif ( $query_type =~ /^cql/ ) {
385 new ZOOM::Query::CQL( $query_to_use, $zconns[$i] ) );
387 elsif ( $query_type =~ /^pqf/ ) {
390 new ZOOM::Query::PQF( $query_to_use, $zconns[$i] ) );
397 new ZOOM::Query::CCL2RPN( $query_to_use, $zconns[$i] )
403 new ZOOM::Query::CCL2RPN( $query_to_use, $zconns[$i] )
409 warn "WARNING: query problem with $query_to_use " . $@;
412 # Concatenate the sort_by limits and pass them to the results object
413 # Note: sort will override rank
415 foreach my $sort (@sort_by) {
416 if ( $sort eq "author_az" ) {
417 $sort_by .= "1=1003 <i ";
419 elsif ( $sort eq "author_za" ) {
420 $sort_by .= "1=1003 >i ";
422 elsif ( $sort eq "popularity_asc" ) {
423 $sort_by .= "1=9003 <i ";
425 elsif ( $sort eq "popularity_dsc" ) {
426 $sort_by .= "1=9003 >i ";
428 elsif ( $sort eq "call_number_asc" ) {
429 $sort_by .= "1=20 <i ";
431 elsif ( $sort eq "call_number_dsc" ) {
432 $sort_by .= "1=20 >i ";
434 elsif ( $sort eq "pubdate_asc" ) {
435 $sort_by .= "1=31 <i ";
437 elsif ( $sort eq "pubdate_dsc" ) {
438 $sort_by .= "1=31 >i ";
440 elsif ( $sort eq "acqdate_asc" ) {
441 $sort_by .= "1=32 <i ";
443 elsif ( $sort eq "acqdate_dsc" ) {
444 $sort_by .= "1=32 >i ";
446 elsif ( $sort eq "title_az" ) {
447 $sort_by .= "1=4 <i ";
449 elsif ( $sort eq "title_za" ) {
450 $sort_by .= "1=4 >i ";
453 warn "Ignoring unrecognized sort '$sort' requested" if $sort_by;
457 if ( $results[$i]->sort( "yaz", $sort_by ) < 0 ) {
458 warn "WARNING sort $sort_by failed";
461 } # finished looping through servers
463 # The big moment: asynchronously retrieve results from all servers
464 while ( ( my $i = ZOOM::event( \@zconns ) ) != 0 ) {
465 my $ev = $zconns[ $i - 1 ]->last_event();
466 if ( $ev == ZOOM::Event::ZEND ) {
467 next unless $results[ $i - 1 ];
468 my $size = $results[ $i - 1 ]->size();
472 # loop through the results
473 $results_hash->{'hits'} = $size;
475 if ( $offset + $results_per_page <= $size ) {
476 $times = $offset + $results_per_page;
481 for ( my $j = $offset ; $j < $times ; $j++ ) {
486 ## Check if it's an index scan
488 my ( $term, $occ ) = $results[ $i - 1 ]->term($j);
490 # here we create a minimal MARC record and hand it off to the
491 # template just like a normal result ... perhaps not ideal, but
493 my $tmprecord = MARC::Record->new();
494 $tmprecord->encoding('UTF-8');
498 # the minimal record in author/title (depending on MARC flavour)
499 if (C4::Context->preference("marcflavour") eq "UNIMARC") {
500 $tmptitle = MARC::Field->new('200',' ',' ', a => $term, f => $occ);
501 $tmprecord->append_fields($tmptitle);
503 $tmptitle = MARC::Field->new('245',' ',' ', a => $term,);
504 $tmpauthor = MARC::Field->new('100',' ',' ', a => $occ,);
505 $tmprecord->append_fields($tmptitle);
506 $tmprecord->append_fields($tmpauthor);
508 $results_hash->{'RECORDS'}[$j] = $tmprecord->as_usmarc();
513 $record = $results[ $i - 1 ]->record($j)->raw();
515 # warn "RECORD $j:".$record;
516 $results_hash->{'RECORDS'}[$j] = $record;
518 # Fill the facets while we're looping, but only for the biblioserver
519 $facet_record = MARC::Record->new_from_usmarc($record)
520 if $servers[ $i - 1 ] =~ /biblioserver/;
522 #warn $servers[$i-1]."\n".$record; #.$facet_record->title();
524 for ( my $k = 0 ; $k <= @$facets ; $k++ ) {
525 ($facets->[$k]) or next;
526 my @fields = map {$facet_record->field($_)} @{$facets->[$k]->{'tags'}} ;
527 for my $field (@fields) {
528 my @subfields = $field->subfields();
529 for my $subfield (@subfields) {
530 my ( $code, $data ) = @$subfield;
531 ($code eq $facets->[$k]->{'subfield'}) or next;
532 $facets_counter->{ $facets->[$k]->{'link_value'} }->{$data}++;
535 $facets_info->{ $facets->[$k]->{'link_value'} }->{'label_value'} =
536 $facets->[$k]->{'label_value'};
537 $facets_info->{ $facets->[$k]->{'link_value'} }->{'expanded'} =
538 $facets->[$k]->{'expanded'};
543 $results_hashref->{ $servers[ $i - 1 ] } = $results_hash;
546 # warn "connection ", $i-1, ": $size hits";
547 # warn $results[$i-1]->record(0)->render() if $size > 0;
550 if ( $servers[ $i - 1 ] =~ /biblioserver/ ) {
552 sort { $facets_counter->{$b} <=> $facets_counter->{$a} }
553 keys %$facets_counter )
556 my $number_of_facets;
557 my @this_facets_array;
560 $facets_counter->{$link_value}
561 ->{$b} <=> $facets_counter->{$link_value}->{$a}
562 } keys %{ $facets_counter->{$link_value} }
566 if ( ( $number_of_facets < 6 )
567 || ( $expanded_facet eq $link_value )
568 || ( $facets_info->{$link_value}->{'expanded'} ) )
571 # Sanitize the link value ), ( will cause errors with CCL,
572 my $facet_link_value = $one_facet;
573 $facet_link_value =~ s/(\(|\))/ /g;
575 # fix the length that will display in the label,
576 my $facet_label_value = $one_facet;
578 substr( $one_facet, 0, 20 ) . "..."
579 unless length($facet_label_value) <= 20;
581 # if it's a branch, label by the name, not the code,
582 if ( $link_value =~ /branch/ ) {
584 $branches->{$one_facet}->{'branchname'};
587 # but we're down with the whole label being in the link's title.
588 my $facet_title_value = $one_facet;
590 push @this_facets_array,
594 $facets_counter->{$link_value}
596 facet_label_value => $facet_label_value,
597 facet_title_value => $facet_title_value,
598 facet_link_value => $facet_link_value,
599 type_link_value => $link_value,
605 # handle expanded option
606 unless ( $facets_info->{$link_value}->{'expanded'} ) {
608 if ( ( $number_of_facets > 6 )
609 && ( $expanded_facet ne $link_value ) );
614 type_link_value => $link_value,
615 type_id => $link_value . "_id",
616 "type_label_" . $facets_info->{$link_value}->{'label_value'} => 1,
617 facets => \@this_facets_array,
618 expandable => $expandable,
619 expand => $link_value,
621 ) unless ( ($facets_info->{$link_value}->{'label_value'} =~ /Libraries/) and (C4::Context->preference('singleBranchMode')) );
626 return ( undef, $results_hashref, \@facets_loop );
631 $koha_query, $simple_query, $sort_by_ref, $servers_ref,
632 $results_per_page, $offset, $expanded_facet, $branches,
636 my $paz = C4::Search::PazPar2->new(C4::Context->config('pazpar2url'));
638 $paz->search($simple_query);
639 sleep 1; # FIXME: WHY?
642 my $results_hashref = {};
643 my $stats = XMLin($paz->stat);
644 my $results = XMLin($paz->show($offset, $results_per_page, 'work-title:1'), forcearray => 1);
646 # for a grouped search result, the number of hits
647 # is the number of groups returned; 'bib_hits' will have
648 # the total number of bibs.
649 $results_hashref->{'biblioserver'}->{'hits'} = $results->{'merged'}->[0];
650 $results_hashref->{'biblioserver'}->{'bib_hits'} = $stats->{'hits'};
652 HIT: foreach my $hit (@{ $results->{'hit'} }) {
653 my $recid = $hit->{recid}->[0];
655 my $work_title = $hit->{'md-work-title'}->[0];
657 if (exists $hit->{'md-work-author'}) {
658 $work_author = $hit->{'md-work-author'}->[0];
660 my $group_label = (defined $work_author) ? "$work_title / $work_author" : $work_title;
662 my $result_group = {};
663 $result_group->{'group_label'} = $group_label;
664 $result_group->{'group_merge_key'} = $recid;
667 if (exists $hit->{count}) {
668 $count = $hit->{count}->[0];
670 $result_group->{'group_count'} = $count;
672 for (my $i = 0; $i < $count; $i++) {
673 # FIXME -- may need to worry about diacritics here
674 my $rec = $paz->record($recid, $i);
675 push @{ $result_group->{'RECORDS'} }, $rec;
678 push @{ $results_hashref->{'biblioserver'}->{'GROUPS'} }, $result_group;
681 # pass through facets
682 my $termlist_xml = $paz->termlist('author,subject');
683 my $terms = XMLin($termlist_xml, forcearray => 1);
684 my @facets_loop = ();
685 #die Dumper($results);
686 # foreach my $list (sort keys %{ $terms->{'list'} }) {
688 # foreach my $facet (sort @{ $terms->{'list'}->{$list}->{'term'} } ) {
690 # facet_label_value => $facet->{'name'}->[0],
693 # push @facets_loop, ( {
694 # type_label => $list,
695 # facets => \@facets,
699 return ( undef, $results_hashref, \@facets_loop );
703 sub _remove_stopwords {
704 my ( $operand, $index ) = @_;
705 my @stopwords_removed;
707 # phrase and exact-qualified indexes shouldn't have stopwords removed
708 if ( $index !~ m/phr|ext/ ) {
710 # remove stopwords from operand : parse all stopwords & remove them (case insensitive)
711 # we use IsAlpha unicode definition, to deal correctly with diacritics.
712 # otherwise, a French word like "leçon" woudl be split into "le" "çon", "le"
713 # is a stopword, we'd get "çon" and wouldn't find anything...
714 foreach ( keys %{ C4::Context->stopwords } ) {
715 next if ( $_ =~ /(and|or|not)/ ); # don't remove operators
717 /(\P{IsAlpha}$_\P{IsAlpha}|^$_\P{IsAlpha}|\P{IsAlpha}$_$|^$_$)/ )
719 $operand =~ s/\P{IsAlpha}$_\P{IsAlpha}/ /gi;
720 $operand =~ s/^$_\P{IsAlpha}/ /gi;
721 $operand =~ s/\P{IsAlpha}$_$/ /gi;
722 $operand =~ s/$1//gi;
723 push @stopwords_removed, $_;
727 return ( $operand, \@stopwords_removed );
731 sub _detect_truncation {
732 my ( $operand, $index ) = @_;
733 my ( @nontruncated, @righttruncated, @lefttruncated, @rightlefttruncated,
736 my @wordlist = split( /\s/, $operand );
737 foreach my $word (@wordlist) {
738 if ( $word =~ s/^\*([^\*]+)\*$/$1/ ) {
739 push @rightlefttruncated, $word;
741 elsif ( $word =~ s/^\*([^\*]+)$/$1/ ) {
742 push @lefttruncated, $word;
744 elsif ( $word =~ s/^([^\*]+)\*$/$1/ ) {
745 push @righttruncated, $word;
747 elsif ( index( $word, "*" ) < 0 ) {
748 push @nontruncated, $word;
751 push @regexpr, $word;
755 \@nontruncated, \@righttruncated, \@lefttruncated,
756 \@rightlefttruncated, \@regexpr
761 sub _build_stemmed_operand {
762 my ($operand, $lang) = @_;
765 require Lingua::Stem::Snowball;
767 # If operand contains a digit, it is almost certainly an identifier, and should
768 # not be stemmed. This is particularly relevant for ISBNs and ISSNs, which
769 # can contain the letter "X" - for example, _build_stemmend_operand would reduce
770 # "014100018X" to "x ", which for a MARC21 database would bring up irrelevant
771 # results (e.g., "23 x 29 cm." from the 300$c). Bug 2098.
772 return $operand if $operand =~ /\d/;
774 my $stemmer = Lingua::Stem::Snowball->new( lang => $lang,
775 encoding => "UTF-8" );
777 my @words = split( / /, $operand );
779 for my $word (@words) {
780 my $stem = $stemmer->stem($word);
781 $stemmed_operand .= "$stem";
782 $stemmed_operand .= "?"
783 unless ( $stem =~ /(and$|or$|not$)/ ) || ( length($stem) < 3 );
784 $stemmed_operand .= " ";
786 warn "STEMMED OPERAND: $stemmed_operand" if $DEBUG;
787 return $stemmed_operand;
791 sub _build_weighted_query {
793 # FIELD WEIGHTING - This is largely experimental stuff. What I'm committing works
794 # pretty well but could work much better if we had a smarter query parser
795 my ( $operand, $stemmed_operand, $index ) = @_;
796 my $stemming = C4::Context->preference("QueryStemming") || 0;
797 my $weight_fields = C4::Context->preference("QueryWeightFields") || 0;
798 my $fuzzy_enabled = C4::Context->preference("QueryFuzzy") || 0;
800 my $weighted_query .= "(rk=("; # Specifies that we're applying rank
802 # Keyword, or, no index specified
803 if ( ( $index eq 'kw' ) || ( !$index ) ) {
805 "Title-cover,ext,r1=\"$operand\""; # exact title-cover
806 $weighted_query .= " or ti,ext,r2=\"$operand\""; # exact title
807 $weighted_query .= " or ti,phr,r3=\"$operand\""; # phrase title
808 #$weighted_query .= " or any,ext,r4=$operand"; # exact any
809 #$weighted_query .=" or kw,wrdl,r5=\"$operand\""; # word list any
810 $weighted_query .= " or wrdl,fuzzy,r8=\"$operand\""
811 if $fuzzy_enabled; # add fuzzy, word list
812 $weighted_query .= " or wrdl,right-Truncation,r9=\"$stemmed_operand\""
813 if ( $stemming and $stemmed_operand )
814 ; # add stemming, right truncation
815 $weighted_query .= " or wrdl,r9=\"$operand\"";
817 # embedded sorting: 0 a-z; 1 z-a
818 # $weighted_query .= ") or (sort1,aut=1";
821 # Barcode searches should skip this process
822 elsif ( $index eq 'bc' ) {
823 $weighted_query .= "bc=\"$operand\"";
826 # Authority-number searches should skip this process
827 elsif ( $index eq 'an' ) {
828 $weighted_query .= "an=\"$operand\"";
831 # If the index already has more than one qualifier, wrap the operand
832 # in quotes and pass it back (assumption is that the user knows what they
833 # are doing and won't appreciate us mucking up their query
834 elsif ( $index =~ ',' ) {
835 $weighted_query .= " $index=\"$operand\"";
838 #TODO: build better cases based on specific search indexes
840 $weighted_query .= " $index,ext,r1=\"$operand\""; # exact index
841 #$weighted_query .= " or (title-sort-az=0 or $index,startswithnt,st-word,r3=$operand #)";
842 $weighted_query .= " or $index,phr,r3=\"$operand\""; # phrase index
844 " or $index,rt,wrdl,r3=\"$operand\""; # word list index
847 $weighted_query .= "))"; # close rank specification
848 return $weighted_query;
854 $simple_query, $query_cgi,
856 $limit_cgi, $limit_desc,
857 $stopwords_removed, $query_type ) = getRecords ( $operators, $operands, $indexes, $limits, $sort_by, $scan);
859 Build queries and limits in CCL, CGI, Human,
860 handle truncation, stemming, field weighting, stopwords, fuzziness, etc.
862 See verbose embedded documentation.
868 my ( $operators, $operands, $indexes, $limits, $sort_by, $scan, $lang ) = @_;
870 warn "---------\nEnter buildQuery\n---------" if $DEBUG;
873 my @operators = @$operators if $operators;
874 my @indexes = @$indexes if $indexes;
875 my @operands = @$operands if $operands;
876 my @limits = @$limits if $limits;
877 my @sort_by = @$sort_by if $sort_by;
879 my $stemming = C4::Context->preference("QueryStemming") || 0;
880 my $auto_truncation = C4::Context->preference("QueryAutoTruncate") || 0;
881 my $weight_fields = C4::Context->preference("QueryWeightFields") || 0;
882 my $fuzzy_enabled = C4::Context->preference("QueryFuzzy") || 0;
883 my $remove_stopwords = C4::Context->preference("QueryRemoveStopwords") || 0;
885 # no stemming/weight/fuzzy in NoZebra
886 if ( C4::Context->preference("NoZebra") ) {
892 my $query = $operands[0];
893 my $simple_query = $operands[0];
895 # initialize the variables we're passing back
904 my $stopwords_removed; # flag to determine if stopwords have been removed
906 # for handling ccl, cql, pqf queries in diagnostic mode, skip the rest of the steps
908 if ( $query =~ /^ccl=/ ) {
909 return ( undef, $', $', "q=ccl=$'", $', '', '', '', '', 'ccl' );
911 if ( $query =~ /^cql=/ ) {
912 return ( undef, $', $', "q=cql=$'", $', '', '', '', '', 'cql' );
914 if ( $query =~ /^pqf=/ ) {
915 return ( undef, $', $', "q=pqf=$'", $', '', '', '', '', 'pqf' );
918 # pass nested queries directly
919 # FIXME: need better handling of some of these variables in this case
920 if ( $query =~ /(\(|\))/ ) {
922 undef, $query, $simple_query, $query_cgi,
923 $query, $limit, $limit_cgi, $limit_desc,
924 $stopwords_removed, 'ccl'
928 # Form-based queries are non-nested and fixed depth, so we can easily modify the incoming
929 # query operands and indexes and add stemming, truncation, field weighting, etc.
930 # Once we do so, we'll end up with a value in $query, just like if we had an
931 # incoming $query from the user
934 ; # clear it out so we can populate properly with field-weighted, stemmed, etc. query
936 ; # a flag used to keep track if there was a previous query
937 # if there was, we can apply the current operator
939 for ( my $i = 0 ; $i <= @operands ; $i++ ) {
941 # COMBINE OPERANDS, INDEXES AND OPERATORS
942 if ( $operands[$i] ) {
944 # A flag to determine whether or not to add the index to the query
947 # If the user is sophisticated enough to specify an index, turn off field weighting, stemming, and stopword handling
948 if ( $operands[$i] =~ /(:|=)/ || $scan ) {
951 $remove_stopwords = 0;
953 my $operand = $operands[$i];
954 my $index = $indexes[$i];
956 # Add index-specific attributes
957 # Date of Publication
958 if ( $index eq 'yr' ) {
959 $index .= ",st-numeric";
961 $stemming = $auto_truncation = $weight_fields = $fuzzy_enabled = $remove_stopwords = 0;
964 # Date of Acquisition
965 elsif ( $index eq 'acqdate' ) {
966 $index .= ",st-date-normalized";
968 $stemming = $auto_truncation = $weight_fields = $fuzzy_enabled = $remove_stopwords = 0;
970 # ISBN,ISSN,Standard Number, don't need special treatment
971 elsif ( $index eq 'nb' || $index eq 'ns' ) {
974 $stemming, $auto_truncation,
975 $weight_fields, $fuzzy_enabled,
977 ) = ( 0, 0, 0, 0, 0 );
980 # Set default structure attribute (word list)
982 unless ( $indexes_set || !$index || $index =~ /(st-|phr|ext|wrdl)/ ) {
983 $struct_attr = ",wrdl";
986 # Some helpful index variants
987 my $index_plus = $index . $struct_attr . ":" if $index;
988 my $index_plus_comma = $index . $struct_attr . "," if $index;
989 if ($auto_truncation){
990 # FIXME Auto Truncation is only valid for LTR languages
992 # use C4::Languages qw(regex_lang_subtags get_bidi);
993 # $lang = $query->cookie('KohaOpacLanguage') if (defined $query && $query->cookie('KohaOpacLanguage'));
994 # my $current_lang = regex_lang_subtags($lang);
996 # $bidi = get_bidi($current_lang->{script}) if $current_lang->{script};
997 $index_plus_comma .= "rtrn:";
1001 if ($remove_stopwords) {
1002 ( $operand, $stopwords_removed ) =
1003 _remove_stopwords( $operand, $index );
1004 warn "OPERAND w/out STOPWORDS: >$operand<" if $DEBUG;
1005 warn "REMOVED STOPWORDS: @$stopwords_removed"
1006 if ( $stopwords_removed && $DEBUG );
1010 my $truncated_operand;
1011 my( $nontruncated, $righttruncated, $lefttruncated,
1012 $rightlefttruncated, $regexpr
1013 ) = _detect_truncation( $operand, $index );
1015 "TRUNCATION: NON:>@$nontruncated< RIGHT:>@$righttruncated< LEFT:>@$lefttruncated< RIGHTLEFT:>@$rightlefttruncated< REGEX:>@$regexpr<"
1020 scalar(@$righttruncated) + scalar(@$lefttruncated) +
1021 scalar(@$rightlefttruncated) > 0 )
1024 # Don't field weight or add the index to the query, we do it here
1026 undef $weight_fields;
1027 my $previous_truncation_operand;
1028 if ( scalar(@$nontruncated) > 0 ) {
1029 $truncated_operand .= "$index_plus @$nontruncated ";
1030 $previous_truncation_operand = 1;
1032 if ( scalar(@$righttruncated) > 0 ) {
1033 $truncated_operand .= "and "
1034 if $previous_truncation_operand;
1035 $truncated_operand .=
1036 "$index_plus_comma" . "rtrn:@$righttruncated ";
1037 $previous_truncation_operand = 1;
1039 if ( scalar(@$lefttruncated) > 0 ) {
1040 $truncated_operand .= "and "
1041 if $previous_truncation_operand;
1042 $truncated_operand .=
1043 "$index_plus_comma" . "ltrn:@$lefttruncated ";
1044 $previous_truncation_operand = 1;
1046 if ( scalar(@$rightlefttruncated) > 0 ) {
1047 $truncated_operand .= "and "
1048 if $previous_truncation_operand;
1049 $truncated_operand .=
1050 "$index_plus_comma" . "rltrn:@$rightlefttruncated ";
1051 $previous_truncation_operand = 1;
1054 $operand = $truncated_operand if $truncated_operand;
1055 warn "TRUNCATED OPERAND: >$truncated_operand<" if $DEBUG;
1058 my $stemmed_operand;
1059 $stemmed_operand = _build_stemmed_operand($operand, $lang)
1061 warn "STEMMED OPERAND: >$stemmed_operand<" if $DEBUG;
1063 # Handle Field Weighting
1064 my $weighted_operand;
1066 _build_weighted_query( $operand, $stemmed_operand, $index )
1068 warn "FIELD WEIGHTED OPERAND: >$weighted_operand<" if $DEBUG;
1069 $operand = $weighted_operand if $weight_fields;
1070 $indexes_set = 1 if $weight_fields;
1072 # If there's a previous operand, we need to add an operator
1073 if ($previous_operand) {
1075 # User-specified operator
1076 if ( $operators[ $i - 1 ] ) {
1077 $query .= " $operators[$i-1] ";
1078 $query .= " $index_plus " unless $indexes_set;
1079 $query .= " $operand";
1080 $query_cgi .= "&op=$operators[$i-1]";
1081 $query_cgi .= "&idx=$index" if $index;
1082 $query_cgi .= "&q=$operands[$i]" if $operands[$i];
1084 " $operators[$i-1] $index_plus $operands[$i]";
1087 # Default operator is and
1090 $query .= "$index_plus " unless $indexes_set;
1091 $query .= "$operand";
1092 $query_cgi .= "&op=and&idx=$index" if $index;
1093 $query_cgi .= "&q=$operands[$i]" if $operands[$i];
1094 $query_desc .= " and $index_plus $operands[$i]";
1098 # There isn't a pervious operand, don't need an operator
1101 # Field-weighted queries already have indexes set
1102 $query .= " $index_plus " unless $indexes_set;
1104 $query_desc .= " $index_plus $operands[$i]";
1105 $query_cgi .= "&idx=$index" if $index;
1106 $query_cgi .= "&q=$operands[$i]" if $operands[$i];
1107 $previous_operand = 1;
1112 warn "QUERY BEFORE LIMITS: >$query<" if $DEBUG;
1115 my $group_OR_limits;
1116 my $availability_limit;
1117 foreach my $this_limit (@limits) {
1118 if ( $this_limit =~ /available/ ) {
1120 # 'available' is defined as (items.onloan is NULL) and (items.itemlost = 0)
1122 # all records not indexed in the onloan register (zebra) and all records with a value of lost equal to 0
1123 $availability_limit .=
1124 "( ( allrecords,AlwaysMatches='' not onloan,AlwaysMatches='') and (lost,st-numeric=0) )"; #or ( allrecords,AlwaysMatches='' not lost,AlwaysMatches='')) )";
1125 $limit_cgi .= "&limit=available";
1129 # group_OR_limits, prefixed by mc-
1130 # OR every member of the group
1131 elsif ( $this_limit =~ /mc/ ) {
1132 $group_OR_limits .= " or " if $group_OR_limits;
1133 $limit_desc .= " or " if $group_OR_limits;
1134 $group_OR_limits .= "$this_limit";
1135 $limit_cgi .= "&limit=$this_limit";
1136 $limit_desc .= " $this_limit";
1139 # Regular old limits
1142 $limit .= " and " if $limit || $query;
1143 $limit .= "$this_limit";
1144 $limit_cgi .= "&limit=$this_limit";
1145 $limit_desc .= " $this_limit";
1146 if ($this_limit =~ /^branch:(.+)/) {
1147 my $branchcode = $1;
1148 my $branchname = GetBranchName($branchcode);
1149 if (defined $branchname) {
1150 $limit_desc .= " branch:$branchname";
1152 $limit_desc .= " $this_limit";
1155 $limit_desc .= " $this_limit";
1161 if ($group_OR_limits) {
1162 $limit .= " and " if ( $query || $limit );
1163 $limit .= "($group_OR_limits)";
1165 if ($availability_limit) {
1166 $limit .= " and " if ( $query || $limit );
1167 $limit .= "($availability_limit)";
1170 # Normalize the query and limit strings
1173 for ( $query, $query_desc, $limit, $limit_desc ) {
1174 $_ =~ s/ / /g; # remove extra spaces
1175 $_ =~ s/^ //g; # remove any beginning spaces
1176 $_ =~ s/ $//g; # remove any ending spaces
1177 $_ =~ s/==/=/g; # remove double == from query
1179 $query_cgi =~ s/^&//; # remove unnecessary & from beginning of the query cgi
1181 for ($query_cgi,$simple_query) {
1184 # append the limit to the query
1185 $query .= " " . $limit;
1189 warn "QUERY:" . $query;
1190 warn "QUERY CGI:" . $query_cgi;
1191 warn "QUERY DESC:" . $query_desc;
1192 warn "LIMIT:" . $limit;
1193 warn "LIMIT CGI:" . $limit_cgi;
1194 warn "LIMIT DESC:" . $limit_desc;
1195 warn "---------\nLeave buildQuery\n---------";
1198 undef, $query, $simple_query, $query_cgi,
1199 $query_desc, $limit, $limit_cgi, $limit_desc,
1200 $stopwords_removed, $query_type
1204 =head2 searchResults
1206 Format results in a form suitable for passing to the template
1210 # IMO this subroutine is pretty messy still -- it's responsible for
1211 # building the HTML output for the template
1213 my ( $searchdesc, $hits, $results_per_page, $offset, $scan, @marcresults ) = @_;
1214 my $dbh = C4::Context->dbh;
1218 # add search-term highlighting via <span>s on the search terms
1219 my $span_terms_hashref;
1220 for my $span_term ( split( / /, $searchdesc ) ) {
1221 $span_term =~ s/(.*=|\)|\(|\+|\.|\*)//g;
1222 $span_terms_hashref->{$span_term}++;
1225 #Build branchnames hash
1227 #get branch information.....
1230 $dbh->prepare("SELECT branchcode,branchname FROM branches")
1231 ; # FIXME : use C4::Koha::GetBranches
1233 while ( my $bdata = $bsth->fetchrow_hashref ) {
1234 $branches{ $bdata->{'branchcode'} } = $bdata->{'branchname'};
1236 # FIXME - We build an authorised values hash here, using the default framework
1237 # though it is possible to have different authvals for different fws.
1239 my $shelflocations =GetKohaAuthorisedValues('items.location','');
1241 # get notforloan authorised value list (see $shelflocations FIXME)
1242 my $notforloan_authorised_value = GetAuthValCode('items.notforloan','');
1244 #Build itemtype hash
1245 #find itemtype & itemtype image
1249 "SELECT itemtype,description,imageurl,summary,notforloan FROM itemtypes"
1252 while ( my $bdata = $bsth->fetchrow_hashref ) {
1253 foreach (qw(description imageurl summary notforloan)) {
1254 $itemtypes{ $bdata->{'itemtype'} }->{$_} = $bdata->{$_};
1258 #search item field code
1261 "SELECT tagfield FROM marc_subfield_structure WHERE kohafield LIKE 'items.itemnumber'"
1264 my ($itemtag) = $sth->fetchrow;
1266 ## find column names of items related to MARC
1267 my $sth2 = $dbh->prepare("SHOW COLUMNS FROM items");
1269 my %subfieldstosearch;
1270 while ( ( my $column ) = $sth2->fetchrow ) {
1271 my ( $tagfield, $tagsubfield ) =
1272 &GetMarcFromKohaField( "items." . $column, "" );
1273 $subfieldstosearch{$column} = $tagsubfield;
1276 # handle which records to actually retrieve
1278 if ( $hits && $offset + $results_per_page <= $hits ) {
1279 $times = $offset + $results_per_page;
1282 $times = $hits; # FIXME: if $hits is undefined, why do we want to equal it?
1285 my $marcflavour = C4::Context->preference("marcflavour");
1286 # loop through all of the records we've retrieved
1287 for ( my $i = $offset ; $i <= $times - 1 ; $i++ ) {
1288 my $marcrecord = MARC::File::USMARC::decode( $marcresults[$i] );
1289 my $oldbiblio = TransformMarcToKoha( $dbh, $marcrecord, '' );
1290 $oldbiblio->{subtitle} = C4::Biblio::get_koha_field_from_marc('bibliosubtitle', 'subtitle', $marcrecord, '');
1291 $oldbiblio->{result_number} = $i + 1;
1293 # add imageurl to itemtype if there is one
1294 $oldbiblio->{imageurl} = getitemtypeimagelocation( 'opac', $itemtypes{ $oldbiblio->{itemtype} }->{imageurl} );
1296 $oldbiblio->{'authorised_value_images'} = C4::Items::get_authorised_value_images( C4::Biblio::get_biblio_authorised_values( $oldbiblio->{'biblionumber'}, $marcrecord ) );
1297 $oldbiblio->{normalized_upc} = GetNormalizedUPC($marcrecord,$marcflavour);
1298 $oldbiblio->{normalized_ean} = GetNormalizedEAN($marcrecord,$marcflavour);
1299 $oldbiblio->{normalized_oclc} = GetNormalizedOCLCNumber($marcrecord,$marcflavour);
1300 $oldbiblio->{normalized_isbn} = GetNormalizedISBN(undef,$marcrecord,$marcflavour);
1301 $oldbiblio->{content_identifier_exists} = 1 if ($oldbiblio->{normalized_isbn} or $oldbiblio->{normalized_oclc} or $oldbiblio->{normalized_ean} or $oldbiblio->{normalized_upc});
1303 # edition information, if any
1304 $oldbiblio->{edition} = $oldbiblio->{editionstatement};
1305 $oldbiblio->{description} = $itemtypes{ $oldbiblio->{itemtype} }->{description};
1306 # Build summary if there is one (the summary is defined in the itemtypes table)
1307 # FIXME: is this used anywhere, I think it can be commented out? -- JF
1308 if ( $itemtypes{ $oldbiblio->{itemtype} }->{summary} ) {
1309 my $summary = $itemtypes{ $oldbiblio->{itemtype} }->{summary};
1310 my @fields = $marcrecord->fields();
1311 foreach my $field (@fields) {
1312 my $tag = $field->tag();
1313 my $tagvalue = $field->as_string();
1314 if (! utf8::is_utf8($tagvalue)) {
1315 utf8::decode($tagvalue);
1319 s/\[(.?.?.?.?)$tag\*(.*?)]/$1$tagvalue$2\[$1$tag$2]/g;
1320 unless ( $tag < 10 ) {
1321 my @subf = $field->subfields;
1322 for my $i ( 0 .. $#subf ) {
1323 my $subfieldcode = $subf[$i][0];
1324 my $subfieldvalue = $subf[$i][1];
1325 if (! utf8::is_utf8($subfieldvalue)) {
1326 utf8::decode($subfieldvalue);
1328 my $tagsubf = $tag . $subfieldcode;
1330 s/\[(.?.?.?.?)$tagsubf(.*?)]/$1$subfieldvalue$2\[$1$tagsubf$2]/g;
1335 $summary =~ s/\[(.*?)]//g;
1336 $summary =~ s/\n/<br\/>/g;
1337 $oldbiblio->{summary} = $summary;
1340 # save an author with no <span> tag, for the <a href=search.pl?q=<!--tmpl_var name="author"-->> link
1341 $oldbiblio->{'author_nospan'} = $oldbiblio->{'author'};
1342 $oldbiblio->{'title_nospan'} = $oldbiblio->{'title'};
1343 $oldbiblio->{'subtitle_nospan'} = $oldbiblio->{'subtitle'};
1344 # Add search-term highlighting to the whole record where they match using <span>s
1345 if (C4::Context->preference("OpacHighlightedWords")){
1346 my $searchhighlightblob;
1347 for my $highlight_field ( $marcrecord->fields ) {
1349 # FIXME: need to skip title, subtitle, author, etc., as they are handled below
1350 next if $highlight_field->tag() =~ /(^00)/; # skip fixed fields
1351 for my $subfield ($highlight_field->subfields()) {
1353 next if $subfield->[0] eq '9';
1354 my $field = $subfield->[1];
1355 for my $term ( keys %$span_terms_hashref ) {
1356 if ( ( $field =~ /$term/i ) && (( length($term) > 3 ) || ($field =~ / $term /i)) ) {
1357 $field =~ s/$term/<span class=\"term\">$&<\/span>/gi;
1361 $searchhighlightblob .= $field . " ... " if $match;
1365 $searchhighlightblob = ' ... '.$searchhighlightblob if $searchhighlightblob;
1366 $oldbiblio->{'searchhighlightblob'} = $searchhighlightblob;
1369 # Add search-term highlighting to the title, subtitle, etc. fields
1370 for my $term ( keys %$span_terms_hashref ) {
1371 my $old_term = $term;
1372 if ( length($term) > 3 ) {
1373 $term =~ s/(.*=|\)|\(|\+|\.|\?|\[|\]|\\|\*)//g;
1374 foreach(qw(title subtitle author publishercode place pages notes size)) {
1375 $oldbiblio->{$_} =~ s/$term/<span class=\"term\">$&<\/span>/gi;
1380 ($i % 2) and $oldbiblio->{'toggle'} = 1;
1382 # Pull out the items fields
1383 my @fields = $marcrecord->field($itemtag);
1385 # Setting item statuses for display
1386 my @available_items_loop;
1387 my @onloan_items_loop;
1388 my @notforloan_items_loop;
1389 my @other_items_loop;
1391 my $available_items;
1393 my $notforloan_items;
1396 my $ordered_count = 0;
1397 my $available_count = 0;
1398 my $onloan_count = 0;
1399 my $notforloan_count = 0;
1400 my $longoverdue_count = 0;
1401 my $other_count = 0;
1402 my $wthdrawn_count = 0;
1403 my $itemlost_count = 0;
1404 my $itembinding_count = 0;
1405 my $itemdamaged_count = 0;
1406 my $item_in_transit_count = 0;
1407 my $can_place_holds = 0;
1408 my $items_count = scalar(@fields);
1410 ( C4::Context->preference('maxItemsinSearchResults') )
1411 ? C4::Context->preference('maxItemsinSearchResults') - 1
1414 # loop through every item
1415 foreach my $field (@fields) {
1418 # populate the items hash
1419 foreach my $code ( keys %subfieldstosearch ) {
1420 $item->{$code} = $field->subfield( $subfieldstosearch{$code} );
1422 my $hbranch = C4::Context->preference('HomeOrHoldingBranch') eq 'homebranch' ? 'homebranch' : 'holdingbranch';
1423 my $otherbranch = C4::Context->preference('HomeOrHoldingBranch') eq 'homebranch' ? 'holdingbranch' : 'homebranch';
1424 # set item's branch name, use HomeOrHoldingBranch syspref first, fall back to the other one
1425 if ($item->{$hbranch}) {
1426 $item->{'branchname'} = $branches{$item->{$hbranch}};
1428 elsif ($item->{$otherbranch}) { # Last resort
1429 $item->{'branchname'} = $branches{$item->{$otherbranch}};
1432 my $prefix = $item->{$hbranch} . '--' . $item->{location} . $item->{itype} . $item->{itemcallnumber};
1433 # For each grouping of items (onloan, available, unavailable), we build a key to store relevant info about that item
1434 if ( $item->{onloan} ) {
1436 my $key = $prefix . $item->{due_date};
1437 $onloan_items->{$key}->{due_date} = format_date($item->{onloan});
1438 $onloan_items->{$key}->{count}++ if $item->{$hbranch};
1439 $onloan_items->{$key}->{branchname} = $item->{branchname};
1440 $onloan_items->{$key}->{location} = $shelflocations->{ $item->{location} };
1441 $onloan_items->{$key}->{itemcallnumber} = $item->{itemcallnumber};
1442 $onloan_items->{$key}->{imageurl} = getitemtypeimagelocation( 'opac', $itemtypes{ $item->{itype} }->{imageurl} );
1443 $onloan_items->{$key}->{barcode} = $item->{barcode};
1444 # if something's checked out and lost, mark it as 'long overdue'
1445 if ( $item->{itemlost} ) {
1446 $onloan_items->{$prefix}->{longoverdue}++;
1447 $longoverdue_count++;
1448 } else { # can place holds as long as item isn't lost
1449 $can_place_holds = 1;
1453 # items not on loan, but still unavailable ( lost, withdrawn, damaged )
1457 if ( $item->{notforloan} == -1 ) {
1461 # is item in transit?
1462 my $transfertwhen = '';
1463 my ($transfertfrom, $transfertto);
1465 unless ($item->{wthdrawn}
1466 || $item->{itemlost}
1468 || $item->{notforloan}
1469 || $items_count > 20) {
1471 # A couple heuristics to limit how many times
1472 # we query the database for item transfer information, sacrificing
1473 # accuracy in some cases for speed;
1475 # 1. don't query if item has one of the other statuses
1476 # 2. don't check transit status if the bib has
1477 # more than 20 items
1479 # FIXME: to avoid having the query the database like this, and to make
1480 # the in transit status count as unavailable for search limiting,
1481 # should map transit status to record indexed in Zebra.
1483 ($transfertwhen, $transfertfrom, $transfertto) = C4::Circulation::GetTransfers($item->{itemnumber});
1486 # item is withdrawn, lost or damaged
1487 if ( $item->{wthdrawn}
1488 || $item->{itemlost}
1490 || $item->{notforloan}
1491 || ($transfertwhen ne ''))
1493 $wthdrawn_count++ if $item->{wthdrawn};
1494 $itemlost_count++ if $item->{itemlost};
1495 $itemdamaged_count++ if $item->{damaged};
1496 $item_in_transit_count++ if $transfertwhen ne '';
1497 $item->{status} = $item->{wthdrawn} . "-" . $item->{itemlost} . "-" . $item->{damaged} . "-" . $item->{notforloan};
1500 my $key = $prefix . $item->{status};
1502 foreach (qw(wthdrawn itemlost damaged branchname itemcallnumber)) {
1503 $other_items->{$key}->{$_} = $item->{$_};
1505 $other_items->{$key}->{intransit} = ($transfertwhen ne '') ? 1 : 0;
1506 $other_items->{$key}->{notforloan} = GetAuthorisedValueDesc('','',$item->{notforloan},'','',$notforloan_authorised_value) if $notforloan_authorised_value;
1507 $other_items->{$key}->{count}++ if $item->{$hbranch};
1508 $other_items->{$key}->{location} = $shelflocations->{ $item->{location} };
1509 $other_items->{$key}->{imageurl} = getitemtypeimagelocation( 'opac', $itemtypes{ $item->{itype} }->{imageurl} );
1513 $can_place_holds = 1;
1515 $available_items->{$prefix}->{count}++ if $item->{$hbranch};
1516 foreach (qw(branchname itemcallnumber barcode)) {
1517 $available_items->{$prefix}->{$_} = $item->{$_};
1519 $available_items->{$prefix}->{location} = $shelflocations->{ $item->{location} };
1520 $available_items->{$prefix}->{imageurl} = getitemtypeimagelocation( 'opac', $itemtypes{ $item->{itype} }->{imageurl} );
1523 } # notforloan, item level and biblioitem level
1524 my ( $availableitemscount, $onloanitemscount, $notforloanitemscount,$otheritemscount );
1526 ( C4::Context->preference('maxItemsinSearchResults') )
1527 ? C4::Context->preference('maxItemsinSearchResults') - 1
1529 for my $key ( sort keys %$onloan_items ) {
1530 (++$onloanitemscount > $maxitems) and last;
1531 push @onloan_items_loop, $onloan_items->{$key};
1533 for my $key ( sort keys %$other_items ) {
1534 (++$otheritemscount > $maxitems) and last;
1535 push @other_items_loop, $other_items->{$key};
1537 for my $key ( sort keys %$notforloan_items ) {
1538 (++$notforloanitemscount > $maxitems) and last;
1539 push @notforloan_items_loop, $notforloan_items->{$key};
1541 for my $key ( sort keys %$available_items ) {
1542 (++$availableitemscount > $maxitems) and last;
1543 push @available_items_loop, $available_items->{$key}
1546 # XSLT processing of some stuff
1547 if (C4::Context->preference("XSLTResultsDisplay") && !$scan) {
1548 $oldbiblio->{XSLTResultsRecord} = XSLTParse4Display(
1549 $oldbiblio->{biblionumber}, $marcrecord, 'Results' );
1552 # last check for norequest : if itemtype is notforloan, it can't be reserved either, whatever the items
1553 $can_place_holds = 0 if $itemtypes{ $oldbiblio->{itemtype} }->{notforloan};
1554 $oldbiblio->{norequests} = 1 unless $can_place_holds;
1555 $oldbiblio->{itemsplural} = 1 if $items_count > 1;
1556 $oldbiblio->{items_count} = $items_count;
1557 $oldbiblio->{available_items_loop} = \@available_items_loop;
1558 $oldbiblio->{notforloan_items_loop}= \@notforloan_items_loop;
1559 $oldbiblio->{onloan_items_loop} = \@onloan_items_loop;
1560 $oldbiblio->{other_items_loop} = \@other_items_loop;
1561 $oldbiblio->{availablecount} = $available_count;
1562 $oldbiblio->{availableplural} = 1 if $available_count > 1;
1563 $oldbiblio->{onloancount} = $onloan_count;
1564 $oldbiblio->{onloanplural} = 1 if $onloan_count > 1;
1565 $oldbiblio->{notforloancount} = $notforloan_count;
1566 $oldbiblio->{othercount} = $other_count;
1567 $oldbiblio->{otherplural} = 1 if $other_count > 1;
1568 $oldbiblio->{wthdrawncount} = $wthdrawn_count;
1569 $oldbiblio->{itemlostcount} = $itemlost_count;
1570 $oldbiblio->{damagedcount} = $itemdamaged_count;
1571 $oldbiblio->{intransitcount} = $item_in_transit_count;
1572 $oldbiblio->{orderedcount} = $ordered_count;
1573 push( @newresults, $oldbiblio );
1578 #----------------------------------------------------------------------
1580 # Non-Zebra GetRecords#
1581 #----------------------------------------------------------------------
1585 NZgetRecords has the same API as zera getRecords, even if some parameters are not managed
1591 $query, $simple_query, $sort_by_ref, $servers_ref,
1592 $results_per_page, $offset, $expanded_facet, $branches,
1595 warn "query =$query" if $DEBUG;
1596 my $result = NZanalyse($query);
1597 warn "results =$result" if $DEBUG;
1599 NZorder( $result, @$sort_by_ref[0], $results_per_page, $offset ),
1605 NZanalyse : get a CQL string as parameter, and returns a list of biblionumber;title,biblionumber;title,...
1606 the list is built from an inverted index in the nozebra SQL table
1607 note that title is here only for convenience : the sorting will be very fast when requested on title
1608 if the sorting is requested on something else, we will have to reread all results, and that may be longer.
1613 my ( $string, $server ) = @_;
1614 # warn "---------" if $DEBUG;
1615 warn " NZanalyse" if $DEBUG;
1616 # warn "---------" if $DEBUG;
1618 # $server contains biblioserver or authorities, depending on what we search on.
1619 #warn "querying : $string on $server";
1620 $server = 'biblioserver' unless $server;
1622 # if we have a ", replace the content to discard temporarily any and/or/not inside
1624 if ( $string =~ /"/ ) {
1625 $string =~ s/"(.*?)"/__X__/;
1627 warn "commacontent : $commacontent" if $DEBUG;
1630 # split the query string in 3 parts : X AND Y means : $left="X", $operand="AND" and $right="Y"
1631 # then, call again NZanalyse with $left and $right
1632 # (recursive until we find a leaf (=> something without and/or/not)
1633 # delete repeated operator... Would then go in infinite loop
1634 while ( $string =~ s/( and| or| not| AND| OR| NOT)\1/$1/g ) {
1637 #process parenthesis before.
1638 if ( $string =~ /^\s*\((.*)\)(( and | or | not | AND | OR | NOT )(.*))?/ ) {
1641 my $operator = lc($3); # FIXME: and/or/not are operators, not operands
1643 "dealing w/parenthesis before recursive sub call. left :$left operator:$operator right:$right"
1645 my $leftresult = NZanalyse( $left, $server );
1647 my $rightresult = NZanalyse( $right, $server );
1649 # OK, we have the results for right and left part of the query
1650 # depending of operand, intersect, union or exclude both lists
1651 # to get a result list
1652 if ( $operator eq ' and ' ) {
1653 return NZoperatorAND($leftresult,$rightresult);
1655 elsif ( $operator eq ' or ' ) {
1657 # just merge the 2 strings
1658 return $leftresult . $rightresult;
1660 elsif ( $operator eq ' not ' ) {
1661 return NZoperatorNOT($leftresult,$rightresult);
1665 # this error is impossible, because of the regexp that isolate the operand, but just in case...
1669 warn "string :" . $string if $DEBUG;
1673 if ($string =~ /(.*?)( and | or | not | AND | OR | NOT )(.*)/) {
1676 $operator = lc($2); # FIXME: and/or/not are operators, not operands
1678 warn "no parenthesis. left : $left operator: $operator right: $right"
1681 # it's not a leaf, we have a and/or/not
1684 # reintroduce comma content if needed
1685 $right =~ s/__X__/"$commacontent"/ if $commacontent;
1686 $left =~ s/__X__/"$commacontent"/ if $commacontent;
1687 warn "node : $left / $operator / $right\n" if $DEBUG;
1688 my $leftresult = NZanalyse( $left, $server );
1689 my $rightresult = NZanalyse( $right, $server );
1690 warn " leftresult : $leftresult" if $DEBUG;
1691 warn " rightresult : $rightresult" if $DEBUG;
1692 # OK, we have the results for right and left part of the query
1693 # depending of operand, intersect, union or exclude both lists
1694 # to get a result list
1695 if ( $operator eq ' and ' ) {
1697 return NZoperatorAND($leftresult,$rightresult);
1699 elsif ( $operator eq ' or ' ) {
1701 # just merge the 2 strings
1702 return $leftresult . $rightresult;
1704 elsif ( $operator eq ' not ' ) {
1705 return NZoperatorNOT($leftresult,$rightresult);
1709 # this error is impossible, because of the regexp that isolate the operand, but just in case...
1710 die "error : operand unknown : $operator for $string";
1713 # it's a leaf, do the real SQL query and return the result
1716 $string =~ s/__X__/"$commacontent"/ if $commacontent;
1717 $string =~ s/-|\.|\?|,|;|!|'|\(|\)|\[|\]|{|}|"|&|\+|\*|\// /g;
1718 #remove trailing blank at the beginning
1720 warn "leaf:$string" if $DEBUG;
1722 # parse the string in in operator/operand/value again
1726 if ($string =~ /(.*)(>=|<=)(.*)/) {
1733 # warn "handling leaf... left:$left operator:$operator right:$right"
1735 unless ($operator) {
1736 if ($string =~ /(.*)(>|<|=)(.*)/) {
1741 "handling unless (operator)... left:$left operator:$operator right:$right"
1749 # strip adv, zebra keywords, currently not handled in nozebra: wrdl, ext, phr...
1752 # automatic replace for short operators
1753 $left = 'title' if $left =~ '^ti$';
1754 $left = 'author' if $left =~ '^au$';
1755 $left = 'publisher' if $left =~ '^pb$';
1756 $left = 'subject' if $left =~ '^su$';
1757 $left = 'koha-Auth-Number' if $left =~ '^an$';
1758 $left = 'keyword' if $left =~ '^kw$';
1759 warn "handling leaf... left:$left operator:$operator right:$right" if $DEBUG;
1760 if ( $operator && $left ne 'keyword' ) {
1762 #do a specific search
1763 my $dbh = C4::Context->dbh;
1764 $operator = 'LIKE' if $operator eq '=' and $right =~ /%/;
1767 "SELECT biblionumbers,value FROM nozebra WHERE server=? AND indexname=? AND value $operator ?"
1769 warn "$left / $operator / $right\n" if $DEBUG;
1771 # split each word, query the DB and build the biblionumbers result
1772 #sanitizing leftpart
1773 $left =~ s/^\s+|\s+$//;
1774 foreach ( split / /, $right ) {
1776 $_ =~ s/^\s+|\s+$//;
1778 warn "EXECUTE : $server, $left, $_" if $DEBUG;
1779 $sth->execute( $server, $left, $_ )
1780 or warn "execute failed: $!";
1781 while ( my ( $line, $value ) = $sth->fetchrow ) {
1783 # if we are dealing with a numeric value, use only numeric results (in case of >=, <=, > or <)
1784 # otherwise, fill the result
1785 $biblionumbers .= $line
1786 unless ( $right =~ /^\d+$/ && $value =~ /\D/ );
1787 warn "result : $value "
1788 . ( $right =~ /\d/ ) . "=="
1789 . ( $value =~ /\D/?$line:"" ) if $DEBUG; #= $line";
1792 # do a AND with existing list if there is one, otherwise, use the biblionumbers list as 1st result list
1794 warn "NZAND" if $DEBUG;
1795 $results = NZoperatorAND($biblionumbers,$results);
1798 $results = $biblionumbers;
1804 #do a complete search (all indexes), if index='kw' do complete search too.
1805 my $dbh = C4::Context->dbh;
1808 "SELECT biblionumbers FROM nozebra WHERE server=? AND value LIKE ?"
1811 # split each word, query the DB and build the biblionumbers result
1812 foreach ( split / /, $string ) {
1813 next if C4::Context->stopwords->{ uc($_) }; # skip if stopword
1814 warn "search on all indexes on $_" if $DEBUG;
1817 $sth->execute( $server, $_ );
1818 while ( my $line = $sth->fetchrow ) {
1819 $biblionumbers .= $line;
1822 # do a AND with existing list if there is one, otherwise, use the biblionumbers list as 1st result list
1824 $results = NZoperatorAND($biblionumbers,$results);
1827 warn "NEW RES for $_ = $biblionumbers" if $DEBUG;
1828 $results = $biblionumbers;
1832 warn "return : $results for LEAF : $string" if $DEBUG;
1835 warn "---------\nLeave NZanalyse\n---------" if $DEBUG;
1839 my ($rightresult, $leftresult)=@_;
1841 my @leftresult = split /;/, $leftresult;
1842 warn " @leftresult / $rightresult \n" if $DEBUG;
1844 # my @rightresult = split /;/,$leftresult;
1847 # parse the left results, and if the biblionumber exist in the right result, save it in finalresult
1848 # the result is stored twice, to have the same weight for AND than OR.
1849 # example : TWO : 61,61,64,121 (two is twice in the biblio #61) / TOWER : 61,64,130
1850 # result : 61,61,61,61,64,64 for two AND tower : 61 has more weight than 64
1851 foreach (@leftresult) {
1854 ( $value, $countvalue ) = ( $1, $2 ) if ($value=~/(.*)-(\d+)$/);
1855 if ( $rightresult =~ /\Q$value\E-(\d+);/ ) {
1856 $countvalue = ( $1 > $countvalue ? $countvalue : $1 );
1858 "$value-$countvalue;$value-$countvalue;";
1861 warn "NZAND DONE : $finalresult \n" if $DEBUG;
1862 return $finalresult;
1866 my ($rightresult, $leftresult)=@_;
1867 return $rightresult.$leftresult;
1871 my ($leftresult, $rightresult)=@_;
1873 my @leftresult = split /;/, $leftresult;
1875 # my @rightresult = split /;/,$leftresult;
1877 foreach (@leftresult) {
1879 $value=$1 if $value=~m/(.*)-\d+$/;
1880 unless ($rightresult =~ "$value-") {
1881 $finalresult .= "$_;";
1884 return $finalresult;
1889 $finalresult = NZorder($biblionumbers, $ordering,$results_per_page,$offset);
1896 my ( $biblionumbers, $ordering, $results_per_page, $offset ) = @_;
1897 warn "biblionumbers = $biblionumbers and ordering = $ordering\n" if $DEBUG;
1899 # order title asc by default
1900 # $ordering = '1=36 <i' unless $ordering;
1901 $results_per_page = 20 unless $results_per_page;
1902 $offset = 0 unless $offset;
1903 my $dbh = C4::Context->dbh;
1906 # order by POPULARITY
1908 if ( $ordering =~ /popularity/ ) {
1912 # popularity is not in MARC record, it's builded from a specific query
1914 $dbh->prepare("select sum(issues) from items where biblionumber=?");
1915 foreach ( split /;/, $biblionumbers ) {
1916 my ( $biblionumber, $title ) = split /,/, $_;
1917 $result{$biblionumber} = GetMarcBiblio($biblionumber);
1918 $sth->execute($biblionumber);
1919 my $popularity = $sth->fetchrow || 0;
1921 # hint : the key is popularity.title because we can have
1922 # many results with the same popularity. In this cas, sub-ordering is done by title
1923 # we also have biblionumber to avoid bug for 2 biblios with the same title & popularity
1924 # (un-frequent, I agree, but we won't forget anything that way ;-)
1925 $popularity{ sprintf( "%10d", $popularity ) . $title
1926 . $biblionumber } = $biblionumber;
1929 # sort the hash and return the same structure as GetRecords (Zebra querying)
1932 if ( $ordering eq 'popularity_dsc' ) { # sort popularity DESC
1933 foreach my $key ( sort { $b cmp $a } ( keys %popularity ) ) {
1934 $result_hash->{'RECORDS'}[ $numbers++ ] =
1935 $result{ $popularity{$key} }->as_usmarc();
1938 else { # sort popularity ASC
1939 foreach my $key ( sort ( keys %popularity ) ) {
1940 $result_hash->{'RECORDS'}[ $numbers++ ] =
1941 $result{ $popularity{$key} }->as_usmarc();
1944 my $finalresult = ();
1945 $result_hash->{'hits'} = $numbers;
1946 $finalresult->{'biblioserver'} = $result_hash;
1947 return $finalresult;
1953 elsif ( $ordering =~ /author/ ) {
1955 foreach ( split /;/, $biblionumbers ) {
1956 my ( $biblionumber, $title ) = split /,/, $_;
1957 my $record = GetMarcBiblio($biblionumber);
1959 if ( C4::Context->preference('marcflavour') eq 'UNIMARC' ) {
1960 $author = $record->subfield( '200', 'f' );
1961 $author = $record->subfield( '700', 'a' ) unless $author;
1964 $author = $record->subfield( '100', 'a' );
1967 # hint : the result is sorted by title.biblionumber because we can have X biblios with the same title
1968 # and we don't want to get only 1 result for each of them !!!
1969 $result{ $author . $biblionumber } = $record;
1972 # sort the hash and return the same structure as GetRecords (Zebra querying)
1975 if ( $ordering eq 'author_za' ) { # sort by author desc
1976 foreach my $key ( sort { $b cmp $a } ( keys %result ) ) {
1977 $result_hash->{'RECORDS'}[ $numbers++ ] =
1978 $result{$key}->as_usmarc();
1981 else { # sort by author ASC
1982 foreach my $key ( sort ( keys %result ) ) {
1983 $result_hash->{'RECORDS'}[ $numbers++ ] =
1984 $result{$key}->as_usmarc();
1987 my $finalresult = ();
1988 $result_hash->{'hits'} = $numbers;
1989 $finalresult->{'biblioserver'} = $result_hash;
1990 return $finalresult;
1993 # ORDER BY callnumber
1996 elsif ( $ordering =~ /callnumber/ ) {
1998 foreach ( split /;/, $biblionumbers ) {
1999 my ( $biblionumber, $title ) = split /,/, $_;
2000 my $record = GetMarcBiblio($biblionumber);
2002 my $frameworkcode = GetFrameworkCode($biblionumber);
2003 my ( $callnumber_tag, $callnumber_subfield ) = GetMarcFromKohaField( 'items.itemcallnumber', $frameworkcode);
2004 ( $callnumber_tag, $callnumber_subfield ) = GetMarcFromKohaField('biblioitems.callnumber', $frameworkcode)
2005 unless $callnumber_tag;
2006 if ( C4::Context->preference('marcflavour') eq 'UNIMARC' ) {
2007 $callnumber = $record->subfield( '200', 'f' );
2010 $callnumber = $record->subfield( '100', 'a' );
2013 # hint : the result is sorted by title.biblionumber because we can have X biblios with the same title
2014 # and we don't want to get only 1 result for each of them !!!
2015 $result{ $callnumber . $biblionumber } = $record;
2018 # sort the hash and return the same structure as GetRecords (Zebra querying)
2021 if ( $ordering eq 'call_number_dsc' ) { # sort by title desc
2022 foreach my $key ( sort { $b cmp $a } ( keys %result ) ) {
2023 $result_hash->{'RECORDS'}[ $numbers++ ] =
2024 $result{$key}->as_usmarc();
2027 else { # sort by title ASC
2028 foreach my $key ( sort { $a cmp $b } ( keys %result ) ) {
2029 $result_hash->{'RECORDS'}[ $numbers++ ] =
2030 $result{$key}->as_usmarc();
2033 my $finalresult = ();
2034 $result_hash->{'hits'} = $numbers;
2035 $finalresult->{'biblioserver'} = $result_hash;
2036 return $finalresult;
2038 elsif ( $ordering =~ /pubdate/ ) { #pub year
2040 foreach ( split /;/, $biblionumbers ) {
2041 my ( $biblionumber, $title ) = split /,/, $_;
2042 my $record = GetMarcBiblio($biblionumber);
2043 my ( $publicationyear_tag, $publicationyear_subfield ) =
2044 GetMarcFromKohaField( 'biblioitems.publicationyear', '' );
2045 my $publicationyear =
2046 $record->subfield( $publicationyear_tag,
2047 $publicationyear_subfield );
2049 # hint : the result is sorted by title.biblionumber because we can have X biblios with the same title
2050 # and we don't want to get only 1 result for each of them !!!
2051 $result{ $publicationyear . $biblionumber } = $record;
2054 # sort the hash and return the same structure as GetRecords (Zebra querying)
2057 if ( $ordering eq 'pubdate_dsc' ) { # sort by pubyear desc
2058 foreach my $key ( sort { $b cmp $a } ( keys %result ) ) {
2059 $result_hash->{'RECORDS'}[ $numbers++ ] =
2060 $result{$key}->as_usmarc();
2063 else { # sort by pub year ASC
2064 foreach my $key ( sort ( keys %result ) ) {
2065 $result_hash->{'RECORDS'}[ $numbers++ ] =
2066 $result{$key}->as_usmarc();
2069 my $finalresult = ();
2070 $result_hash->{'hits'} = $numbers;
2071 $finalresult->{'biblioserver'} = $result_hash;
2072 return $finalresult;
2078 elsif ( $ordering =~ /title/ ) {
2080 # the title is in the biblionumbers string, so we just need to build a hash, sort it and return
2082 foreach ( split /;/, $biblionumbers ) {
2083 my ( $biblionumber, $title ) = split /,/, $_;
2085 # hint : the result is sorted by title.biblionumber because we can have X biblios with the same title
2086 # and we don't want to get only 1 result for each of them !!!
2087 # hint & speed improvement : we can order without reading the record
2088 # so order, and read records only for the requested page !
2089 $result{ $title . $biblionumber } = $biblionumber;
2092 # sort the hash and return the same structure as GetRecords (Zebra querying)
2095 if ( $ordering eq 'title_az' ) { # sort by title desc
2096 foreach my $key ( sort ( keys %result ) ) {
2097 $result_hash->{'RECORDS'}[ $numbers++ ] = $result{$key};
2100 else { # sort by title ASC
2101 foreach my $key ( sort { $b cmp $a } ( keys %result ) ) {
2102 $result_hash->{'RECORDS'}[ $numbers++ ] = $result{$key};
2106 # limit the $results_per_page to result size if it's more
2107 $results_per_page = $numbers - 1 if $numbers < $results_per_page;
2109 # for the requested page, replace biblionumber by the complete record
2110 # speed improvement : avoid reading too much things
2112 my $counter = $offset ;
2113 $counter <= $offset + $results_per_page ;
2117 $result_hash->{'RECORDS'}[$counter] =
2118 GetMarcBiblio( $result_hash->{'RECORDS'}[$counter] )->as_usmarc;
2120 my $finalresult = ();
2121 $result_hash->{'hits'} = $numbers;
2122 $finalresult->{'biblioserver'} = $result_hash;
2123 return $finalresult;
2130 # we need 2 hashes to order by ranking : the 1st one to count the ranking, the 2nd to order by ranking
2133 foreach ( split /;/, $biblionumbers ) {
2134 my ( $biblionumber, $title ) = split /,/, $_;
2135 $title =~ /(.*)-(\d)/;
2140 # note that we + the ranking because ranking is calculated on weight of EACH term requested.
2141 # if we ask for "two towers", and "two" has weight 2 in biblio N, and "towers" has weight 4 in biblio N
2142 # biblio N has ranking = 6
2143 $count_ranking{$biblionumber} += $ranking;
2146 # build the result by "inverting" the count_ranking hash
2147 # hing : as usual, we don't order by ranking only, to avoid having only 1 result for each rank. We build an hash on concat(ranking,biblionumber) instead
2149 foreach ( keys %count_ranking ) {
2150 $result{ sprintf( "%10d", $count_ranking{$_} ) . '-' . $_ } = $_;
2153 # sort the hash and return the same structure as GetRecords (Zebra querying)
2156 foreach my $key ( sort { $b cmp $a } ( keys %result ) ) {
2157 $result_hash->{'RECORDS'}[ $numbers++ ] = $result{$key};
2160 # limit the $results_per_page to result size if it's more
2161 $results_per_page = $numbers - 1 if $numbers < $results_per_page;
2163 # for the requested page, replace biblionumber by the complete record
2164 # speed improvement : avoid reading too much things
2166 my $counter = $offset ;
2167 $counter <= $offset + $results_per_page ;
2171 $result_hash->{'RECORDS'}[$counter] =
2172 GetMarcBiblio( $result_hash->{'RECORDS'}[$counter] )->as_usmarc
2173 if $result_hash->{'RECORDS'}[$counter];
2175 my $finalresult = ();
2176 $result_hash->{'hits'} = $numbers;
2177 $finalresult->{'biblioserver'} = $result_hash;
2178 return $finalresult;
2182 =head2 enabled_staff_search_views
2184 %hash = enabled_staff_search_views()
2186 This function returns a hash that contains three flags obtained from the system
2187 preferences, used to determine whether a particular staff search results view
2192 =item C<Output arg:>
2194 * $hash{can_view_MARC} is true only if the MARC view is enabled
2195 * $hash{can_view_ISBD} is true only if the ISBD view is enabled
2196 * $hash{can_view_labeledMARC} is true only if the Labeled MARC view is enabled
2198 =item C<usage in the script:>
2202 $template->param ( C4::Search::enabled_staff_search_views );
2206 sub enabled_staff_search_views
2209 can_view_MARC => C4::Context->preference('viewMARC'), # 1 if the staff search allows the MARC view
2210 can_view_ISBD => C4::Context->preference('viewISBD'), # 1 if the staff search allows the ISBD view
2211 can_view_labeledMARC => C4::Context->preference('viewLabeledMARC'), # 1 if the staff search allows the Labeled MARC view
2216 =head2 z3950_search_args
2218 $arrayref = z3950_search_args($matchpoints)
2220 This function returns an array reference that contains the search parameters to be
2221 passed to the Z39.50 search script (z3950_search.pl). The array elements
2222 are hash refs whose keys are name, value and encvalue, and whose values are the
2223 name of a search parameter, the value of that search parameter and the URL encoded
2224 value of that parameter.
2226 The search parameter names are lccn, isbn, issn, title, author, dewey and subject.
2228 The search parameter values are obtained from the bibliographic record whose
2229 data is in a hash reference in $matchpoints, as returned by Biblio::GetBiblioData().
2231 If $matchpoints is a scalar, it is assumed to be an unnamed query descriptor, e.g.
2232 a general purpose search argument. In this case, the returned array contains only
2233 entry: the key is 'title' and the value and encvalue are derived from $matchpoints.
2235 If a search parameter value is undefined or empty, it is not included in the returned
2238 The returned array reference may be passed directly to the template parameters.
2242 =item C<Output arg:>
2244 * $array containing hash refs as described above
2246 =item C<usage in the script:>
2250 $data = Biblio::GetBiblioData($bibno);
2251 $template->param ( MYLOOP => C4::Search::z3950_search_args($data) )
2255 $template->param ( MYLOOP => C4::Search::z3950_search_args($searchscalar) )
2259 sub z3950_search_args {
2261 $bibrec = { title => $bibrec } if !ref $bibrec;
2263 for my $field (qw/ lccn isbn issn title author dewey subject /)
2265 my $encvalue = URI::Escape::uri_escape_utf8($bibrec->{$field});
2266 push @$array, { name=>$field, value=>$bibrec->{$field}, encvalue=>$encvalue } if defined $bibrec->{$field};
2272 END { } # module clean-up code here (global destructor)
2279 Koha Developement team <info@koha.org>