NoZebra                     => C4::Context->preference('NoZebra'),

                $newline{authtype}     = defined($thisauthtype) ?

                                            $thisauthtype->{'authtypetext'} : '';

                $newline{summary}      = $summary;

                $newline{even}         = $counter % 2;

                $newline{reported_tag} = $reported_tag;

    if (C4::Context->preference('NoZebra')) {

        # Read the index Koha-Auth-Number for this authid and count the lines

        my $result = C4::Search::NZanalyse("an=$authid");

        my @tab = split /;/,$result;

        return scalar @tab;

    } else {

        ### ZOOM search here

        my $query;

        $query= "an=".$authid;

  		my ($err,$res,$result) = C4::Search::SimpleSearch($query,0,10);

        if ($err) {

            warn "Error: $err from search $query";

            $result = 0;

        }

  my $oldRecord;

      $oldRecord=GetAuthority($authid);

      &GetNoZebraIndexes

    # - we need to read the biblio if NoZebra is set (to remove it from the indexes

$oldRecord is the MARC::Record containing the previous version of the record.  This is used only when 

NoZebra=1, as NoZebra indexing needs to know the previous version of a record in order to

do an update.

$newRecord is the MARC::Record containing the new record. It is usefull only when NoZebra=1, and is used to know what to add to the nozebra database. (the record in mySQL being, if it exist, the previous record, the one just before the modif. We need both : the previous and the new one.

=head2 GetNoZebraIndexes

  %indexes = GetNoZebraIndexes;

return the data from NoZebraIndexes syspref.

=cut

sub GetNoZebraIndexes {

    my $no_zebra_indexes = C4::Context->preference('NoZebraIndexes');

    my %indexes;

  INDEX: foreach my $line ( split /['"],[\n\r]*/, $no_zebra_indexes ) {

        $line =~ /(.*)=>(.*)/;

        my $index  = $1;    # initial ' or " is removed afterwards

        my $fields = $2;

        $index  =~ s/'|"|\s//g;

        $fields =~ s/'|"|\s//g;

        $indexes{$index} = $fields;

    }

    return %indexes;

}

=head2 _DelBiblioNoZebra($biblionumber,$record,$server);

function to delete a biblio in NoZebra indexes

This function does NOT delete anything in database : it reads all the indexes entries

that have to be deleted & delete them in the hash

The SQL part is done either :

 - after the Add if we are modifying a biblio (delete + add again)

 - immediatly after this sub if we are doing a true deletion.

$server can be 'biblioserver' or 'authorityserver' : it indexes biblios or authorities (in the same table, $server being part of the table itself

=cut

sub _DelBiblioNoZebra {

    my ( $biblionumber, $record, $server ) = @_;

    # Get the indexes

    my $dbh = C4::Context->dbh;

    # Get the indexes

    my %index;

    my $title;

    if ( $server eq 'biblioserver' ) {

        %index = GetNoZebraIndexes;

        # get title of the record (to store the 10 first letters with the index)

        my ( $titletag, $titlesubfield ) = GetMarcFromKohaField( 'biblio.title', '' );    # FIXME: should be GetFrameworkCode($biblionumber) ??

        $title = lc( $record->subfield( $titletag, $titlesubfield ) );

    } else {

        # for authorities, the "title" is the $a mainentry

        my ( $auth_type_tag, $auth_type_sf ) = C4::AuthoritiesMarc::get_auth_type_location();

        my $authref = C4::AuthoritiesMarc::GetAuthType( $record->subfield( $auth_type_tag, $auth_type_sf ) );

        warn "ERROR : authtype undefined for " . $record->as_formatted unless $authref;

        $title = $record->subfield( $authref->{auth_tag_to_report}, 'a' );

        $index{'mainmainentry'} = $authref->{'auth_tag_to_report'} . 'a';

        $index{'mainentry'}     = $authref->{'auth_tag_to_report'} . '*';

        $index{'auth_type'}     = "${auth_type_tag}${auth_type_sf}";

    }

    my %result;

    # remove blancks comma (that could cause problem when decoding the string for CQL retrieval) and regexp specific values

    $title =~ s/ |,|;|\[|\]|\(|\)|\*|-|'|=//g;

    # limit to 10 char, should be enough, and limit the DB size

    $title = substr( $title, 0, 10 );

    #parse each field

    my $sth2 = $dbh->prepare('SELECT biblionumbers FROM nozebra WHERE server=? AND indexname=? AND value=?');

    foreach my $field ( $record->fields() ) {

        #parse each subfield

        next if $field->tag < 10;

        foreach my $subfield ( $field->subfields() ) {

            my $tag          = $field->tag();

            my $subfieldcode = $subfield->[0];

            my $indexed      = 0;

            # check each index to see if the subfield is stored somewhere

            # otherwise, store it in __RAW__ index

            foreach my $key ( keys %index ) {

                #                 warn "examining $key index : ".$index{$key}." for $tag $subfieldcode";

                if ( $index{$key} =~ /$tag\*/ or $index{$key} =~ /$tag$subfieldcode/ ) {

                    $indexed = 1;

                    my $line = lc $subfield->[1];

                    # remove meaningless value in the field...

                    $line =~ s/-|\.|\?|,|;|!|'|\(|\)|\[|\]|{|}|"|<|>|&|\+|\*|\/|=|:/ /g;

                    # ... and split in words

                    foreach ( split / /, $line ) {

                        next unless $_;    # skip  empty values (multiple spaces)

                                           # if the entry is already here, do nothing, the biblionumber has already be removed

                        unless ( defined( $result{$key}->{$_} ) && ( $result{$key}->{$_} =~ /$biblionumber,$title\-(\d);/ ) ) {

                            # get the index value if it exist in the nozebra table and remove the entry, otherwise, do nothing

                            $sth2->execute( $server, $key, $_ );

                            my $existing_biblionumbers = $sth2->fetchrow;

                            # it exists

                            if ($existing_biblionumbers) {

                                #                                 warn " existing for $key $_: $existing_biblionumbers";

                                $result{$key}->{$_} = $existing_biblionumbers;

                                $result{$key}->{$_} =~ s/$biblionumber,$title\-(\d);//;

                            }

                        }

                    }

                }

            }

            # the subfield is not indexed, store it in __RAW__ index anyway

            unless ($indexed) {

                my $line = lc $subfield->[1];

                $line =~ s/-|\.|\?|,|;|!|'|\(|\)|\[|\]|{|}|"|<|>|&|\+|\*|\/|=|:/ /g;

                # ... and split in words

                foreach ( split / /, $line ) {

                    next unless $_;    # skip  empty values (multiple spaces)

                                       # if the entry is already here, do nothing, the biblionumber has already be removed

                    unless ( $result{'__RAW__'}->{$_} =~ /$biblionumber,$title\-(\d);/ ) {

                        # get the index value if it exist in the nozebra table and remove the entry, otherwise, do nothing

                        $sth2->execute( $server, '__RAW__', $_ );

                        my $existing_biblionumbers = $sth2->fetchrow;

                        # it exists

                        if ($existing_biblionumbers) {

                            $result{'__RAW__'}->{$_} = $existing_biblionumbers;

                            $result{'__RAW__'}->{$_} =~ s/$biblionumber,$title\-(\d);//;

                        }

                    }

                }

            }

        }

    }

    return %result;

}

=head2 _AddBiblioNoZebra

  _AddBiblioNoZebra($biblionumber, $record, $server, %result);

function to add a biblio in NoZebra indexes

=cut

sub _AddBiblioNoZebra {

    my ( $biblionumber, $record, $server, %result ) = @_;

    my $dbh = C4::Context->dbh;

    # Get the indexes

    my %index;

    my $title;

    if ( $server eq 'biblioserver' ) {

        %index = GetNoZebraIndexes;

        # get title of the record (to store the 10 first letters with the index)

        my ( $titletag, $titlesubfield ) = GetMarcFromKohaField( 'biblio.title', '' );    # FIXME: should be GetFrameworkCode($biblionumber) ??

        $title = lc( $record->subfield( $titletag, $titlesubfield ) );

    } else {

        # warn "server : $server";

        # for authorities, the "title" is the $a mainentry

        my ( $auth_type_tag, $auth_type_sf ) = C4::AuthoritiesMarc::get_auth_type_location();

        my $authref = C4::AuthoritiesMarc::GetAuthType( $record->subfield( $auth_type_tag, $auth_type_sf ) );

        warn "ERROR : authtype undefined for " . $record->as_formatted unless $authref;

        $title = $record->subfield( $authref->{auth_tag_to_report}, 'a' );

        $index{'mainmainentry'} = $authref->{auth_tag_to_report} . 'a';

        $index{'mainentry'}     = $authref->{auth_tag_to_report} . '*';

        $index{'auth_type'}     = "${auth_type_tag}${auth_type_sf}";

    }

    # remove blancks comma (that could cause problem when decoding the string for CQL retrieval) and regexp specific values

    $title =~ s/ |\.|,|;|\[|\]|\(|\)|\*|-|'|:|=|\r|\n//g;

    # limit to 10 char, should be enough, and limit the DB size

    $title = substr( $title, 0, 10 );

    #parse each field

    my $sth2 = $dbh->prepare('SELECT biblionumbers FROM nozebra WHERE server=? AND indexname=? AND value=?');

    foreach my $field ( $record->fields() ) {

        #parse each subfield

        ###FIXME: impossible to index a 001-009 value with NoZebra

        next if $field->tag < 10;

        foreach my $subfield ( $field->subfields() ) {

            my $tag          = $field->tag();

            my $subfieldcode = $subfield->[0];

            my $indexed      = 0;

            #             warn "INDEXING :".$subfield->[1];

            # check each index to see if the subfield is stored somewhere

            # otherwise, store it in __RAW__ index

            foreach my $key ( keys %index ) {

                #                 warn "examining $key index : ".$index{$key}." for $tag $subfieldcode";

                if ( $index{$key} =~ /$tag\*/ or $index{$key} =~ /$tag$subfieldcode/ ) {

                    $indexed = 1;

                    my $line = lc $subfield->[1];

                    # remove meaningless value in the field...

                    $line =~ s/-|\.|\?|,|;|!|'|\(|\)|\[|\]|{|}|"|<|>|&|\+|\*|\/|=|:|\r|\n/ /g;

                    # ... and split in words

                    foreach ( split / /, $line ) {

                        next unless $_;    # skip  empty values (multiple spaces)

                                           # if the entry is already here, improve weight

                        #                         warn "managing $_";

                        if ( exists $result{$key}->{$_} && $result{$key}->{"$_"} =~ /$biblionumber,\Q$title\E\-(\d+);/ ) {

                            my $weight = $1 + 1;

                            $result{$key}->{"$_"} =~ s/$biblionumber,\Q$title\E\-(\d+);//g;

                            $result{$key}->{"$_"} .= "$biblionumber,$title-$weight;";

                        } else {

                            # get the value if it exist in the nozebra table, otherwise, create it

                            $sth2->execute( $server, $key, $_ );

                            my $existing_biblionumbers = $sth2->fetchrow;

                            # it exists

                            if ($existing_biblionumbers) {

                                $result{$key}->{"$_"} = $existing_biblionumbers;

                                my $weight = defined $1 ? $1 + 1 : 1;

                                $result{$key}->{"$_"} =~ s/$biblionumber,\Q$title\E\-(\d+);//g;

                                $result{$key}->{"$_"} .= "$biblionumber,$title-$weight;";

                                # create a new ligne for this entry

                            } else {

                                #                             warn "INSERT : $server / $key / $_";

                                $dbh->do( 'INSERT INTO nozebra SET server=' . $dbh->quote($server) . ', indexname=' . $dbh->quote($key) . ',value=' . $dbh->quote($_) );

                                $result{$key}->{"$_"} .= "$biblionumber,$title-1;";

                            }

                        }

                    }

                }

            }

            # the subfield is not indexed, store it in __RAW__ index anyway

            unless ($indexed) {

                my $line = lc $subfield->[1];

                $line =~ s/-|\.|\?|,|;|!|'|\(|\)|\[|\]|{|}|"|<|>|&|\+|\*|\/|=|:|\r|\n/ /g;

                # ... and split in words

                foreach ( split / /, $line ) {

                    next unless $_;    # skip  empty values (multiple spaces)

                                       # if the entry is already here, improve weight

                    my $tmpstr = $result{'__RAW__'}->{"$_"} || "";

                    if ( $tmpstr =~ /$biblionumber,\Q$title\E\-(\d+);/ ) {

                        my $weight = $1 + 1;

                        $result{'__RAW__'}->{"$_"} =~ s/$biblionumber,\Q$title\E\-(\d+);//;

                        $result{'__RAW__'}->{"$_"} .= "$biblionumber,$title-$weight;";

                    } else {

                        # get the value if it exist in the nozebra table, otherwise, create it

                        $sth2->execute( $server, '__RAW__', $_ );

                        my $existing_biblionumbers = $sth2->fetchrow;

                        # it exists

                        if ($existing_biblionumbers) {

                            $result{'__RAW__'}->{"$_"} = $existing_biblionumbers;

                            my $weight = ( $1 ? $1 : 0 ) + 1;

                            $result{'__RAW__'}->{"$_"} =~ s/$biblionumber,\Q$title\E\-(\d+);//;

                            $result{'__RAW__'}->{"$_"} .= "$biblionumber,$title-$weight;";

                            # create a new ligne for this entry

                        } else {

                            $dbh->do( 'INSERT INTO nozebra SET server=' . $dbh->quote($server) . ',  indexname="__RAW__",value=' . $dbh->quote($_) );

                            $result{'__RAW__'}->{"$_"} .= "$biblionumber,$title-1;";

                        }

                    }

                }

            }

        }

    }

    return %result;

}

    my $oldRecord;

    if ( C4::Context->preference("NoZebra") ) {

        # only NoZebra indexing needs to have

        # the previous version of the record

        $oldRecord = GetMarcBiblio($biblionumber);

    }

 $installer->set_indexing_engine(0);

=head2 set_indexing_engine

  $installer->set_indexing_engine($nozebra);

Sets system preferences related to the indexing

engine.  The C<$nozebra> argument is a boolean;

if true, turn on NoZebra mode and turn off QueryFuzzy,

QueryWeightFields, and QueryStemming.  If false, turn

off NoZebra mode (i.e., use the Zebra search engine).

=cut

sub set_indexing_engine {

    my $self = shift;

    my $nozebra = shift;

    if ($nozebra) {

        $self->{'dbh'}->do("UPDATE systempreferences SET value=1 WHERE variable='NoZebra'");

        $self->{'dbh'}->do("UPDATE systempreferences SET value=0 WHERE variable in ('QueryFuzzy','QueryWeightFields','QueryStemming')");

    } else {

        $self->{'dbh'}->do("UPDATE systempreferences SET value=0 WHERE variable='NoZebra'");

    }

}

  &NZgetRecords

        );

    # no stemming/weight/fuzzy in NoZebra

    if ( C4::Context->preference("NoZebra") ) {

        $stemming         = 0;

        $weight_fields    = 0;

        $fuzzy_enabled    = 0;

    	$auto_truncation  = 0;

    }

#----------------------------------------------------------------------

#

# Non-Zebra GetRecords#

#----------------------------------------------------------------------

=head2 NZgetRecords

  NZgetRecords has the same API as zera getRecords, even if some parameters are not managed

=cut

sub NZgetRecords {

    my (

        $query,            $simple_query, $sort_by_ref,    $servers_ref,

        $results_per_page, $offset,       $expanded_facet, $branches,

        $query_type,       $scan

    ) = @_;

    warn "query =$query" if $DEBUG;

    my $result = NZanalyse($query);

    warn "results =$result" if $DEBUG;

    return ( undef,

        NZorder( $result, @$sort_by_ref[0], $results_per_page, $offset ),

        undef );

}

=head2 NZanalyse

  NZanalyse : get a CQL string as parameter, and returns a list of biblionumber;title,biblionumber;title,...

  the list is built from an inverted index in the nozebra SQL table

  note that title is here only for convenience : the sorting will be very fast when requested on title

  if the sorting is requested on something else, we will have to reread all results, and that may be longer.

=cut

sub NZanalyse {

    my ( $string, $server ) = @_;

#     warn "---------"       if $DEBUG;

    warn " NZanalyse" if $DEBUG;

#     warn "---------"       if $DEBUG;

 # $server contains biblioserver or authorities, depending on what we search on.

 #warn "querying : $string on $server";

    $server = 'biblioserver' unless $server;

# if we have a ", replace the content to discard temporarily any and/or/not inside

    my $commacontent;

    if ( $string =~ /"/ ) {

        $string =~ s/"(.*?)"/__X__/;

        $commacontent = $1;

        warn "commacontent : $commacontent" if $DEBUG;

    }

# split the query string in 3 parts : X AND Y means : $left="X", $operand="AND" and $right="Y"

# then, call again NZanalyse with $left and $right

# (recursive until we find a leaf (=> something without and/or/not)

# delete repeated operator... Would then go in infinite loop

    while ( $string =~ s/( and| or| not| AND| OR| NOT)\1/$1/g ) {

    }

    #process parenthesis before.

    if ( $string =~ /^\s*\((.*)\)(( and | or | not | AND | OR | NOT )(.*))?/ ) {

        my $left     = $1;

        my $right    = $4;

        my $operator = lc($3);   # FIXME: and/or/not are operators, not operands

        warn

"dealing w/parenthesis before recursive sub call. left :$left operator:$operator right:$right"

          if $DEBUG;

        my $leftresult = NZanalyse( $left, $server );

        if ($operator) {

            my $rightresult = NZanalyse( $right, $server );

            # OK, we have the results for right and left part of the query

            # depending of operand, intersect, union or exclude both lists

            # to get a result list

            if ( $operator eq ' and ' ) {

                return NZoperatorAND($leftresult,$rightresult);

            }

            elsif ( $operator eq ' or ' ) {

                # just merge the 2 strings

                return $leftresult . $rightresult;

            }

            elsif ( $operator eq ' not ' ) {

                return NZoperatorNOT($leftresult,$rightresult);

            }

        }

        else {

# this error is impossible, because of the regexp that isolate the operand, but just in case...

            return $leftresult;

        }

    }

    warn "string :" . $string if $DEBUG;

    my $left = "";

    my $right = "";

    my $operator = "";

    if ($string =~ /(.*?)( and | or | not | AND | OR | NOT )(.*)/) {

        $left     = $1;

        $right    = $3;

        $operator = lc($2);    # FIXME: and/or/not are operators, not operands

    }

    warn "no parenthesis. left : $left operator: $operator right: $right"

      if $DEBUG;

    # it's not a leaf, we have a and/or/not

    if ($operator) {

        # reintroduce comma content if needed

        $right =~ s/__X__/"$commacontent"/ if $commacontent;

        $left  =~ s/__X__/"$commacontent"/ if $commacontent;

        warn "node : $left / $operator / $right\n" if $DEBUG;

        my $leftresult  = NZanalyse( $left,  $server );

        my $rightresult = NZanalyse( $right, $server );

        warn " leftresult : $leftresult" if $DEBUG;

        warn " rightresult : $rightresult" if $DEBUG;

        # OK, we have the results for right and left part of the query

        # depending of operand, intersect, union or exclude both lists

        # to get a result list

        if ( $operator eq ' and ' ) {

            return NZoperatorAND($leftresult,$rightresult);

        }

        elsif ( $operator eq ' or ' ) {

            # just merge the 2 strings

            return $leftresult . $rightresult;

        }

        elsif ( $operator eq ' not ' ) {

            return NZoperatorNOT($leftresult,$rightresult);

        }

        else {

# this error is impossible, because of the regexp that isolate the operand, but just in case...

            die "error : operand unknown : $operator for $string";

        }

        # it's a leaf, do the real SQL query and return the result

    }

    else {

        $string =~ s/__X__/"$commacontent"/ if $commacontent;

        $string =~ s/-|\.|\?|,|;|!|'|\(|\)|\[|\]|{|}|"|&|\+|\*|\// /g;

        #remove trailing blank at the beginning

        $string =~ s/^ //g;

        warn "leaf:$string" if $DEBUG;

        # parse the string in in operator/operand/value again

        my $left = "";

        my $operator = "";

        my $right = "";

        if ($string =~ /(.*)(>=|<=)(.*)/) {

            $left     = $1;

            $operator = $2;

            $right    = $3;

        } else {

            $left = $string;

        }

#         warn "handling leaf... left:$left operator:$operator right:$right"

#           if $DEBUG;

        unless ($operator) {

            if ($string =~ /(.*)(>|<|=)(.*)/) {

                $left     = $1;

                $operator = $2;

                $right    = $3;

                warn

    "handling unless (operator)... left:$left operator:$operator right:$right"

                if $DEBUG;

            } else {

                $left = $string;

            }

        }

        my $results;

# strip adv, zebra keywords, currently not handled in nozebra: wrdl, ext, phr...

        $left =~ s/ .*$//;

        # automatic replace for short operators

        $left = 'title'            if $left =~ '^ti$';

        $left = 'author'           if $left =~ '^au$';

        $left = 'publisher'        if $left =~ '^pb$';

        $left = 'subject'          if $left =~ '^su$';

        $left = 'koha-Auth-Number' if $left =~ '^an$';

        $left = 'keyword'          if $left =~ '^kw$';

        $left = 'itemtype'         if $left =~ '^mc$'; # Fix for Bug 2599 - Search limits not working for NoZebra

        warn "handling leaf... left:$left operator:$operator right:$right" if $DEBUG;

        my $dbh = C4::Context->dbh;

        if ( $operator && $left ne 'keyword' ) {

            #do a specific search

            $operator = 'LIKE' if $operator eq '=' and $right =~ /%/;

            my $sth = $dbh->prepare(

"SELECT biblionumbers,value FROM nozebra WHERE server=? AND indexname=? AND value $operator ?"

            );

            warn "$left / $operator / $right\n" if $DEBUG;

            # split each word, query the DB and build the biblionumbers result

            #sanitizing leftpart

            $left =~ s/^\s+|\s+$//;

            foreach ( split / /, $right ) {

                my $biblionumbers;

                $_ =~ s/^\s+|\s+$//;

                next unless $_;

                warn "EXECUTE : $server, $left, $_" if $DEBUG;

                $sth->execute( $server, $left, $_ )

                  or warn "execute failed: $!";

                while ( my ( $line, $value ) = $sth->fetchrow ) {

# if we are dealing with a numeric value, use only numeric results (in case of >=, <=, > or <)

# otherwise, fill the result

                    $biblionumbers .= $line

                      unless ( $right =~ /^\d+$/ && $value =~ /\D/ );

                    warn "result : $value "

                      . ( $right  =~ /\d/ ) . "=="

                      . ( $value =~ /\D/?$line:"" ) if $DEBUG;         #= $line";

                }

# do a AND with existing list if there is one, otherwise, use the biblionumbers list as 1st result list

                if ($results) {

                    warn "NZAND" if $DEBUG;

                    $results = NZoperatorAND($biblionumbers,$results);

                } else {

                    $results = $biblionumbers;

                }

            }

        }

        else {

      #do a complete search (all indexes), if index='kw' do complete search too.

            my $sth = $dbh->prepare(

"SELECT biblionumbers FROM nozebra WHERE server=? AND value LIKE ?"

            );

            # split each word, query the DB and build the biblionumbers result

            foreach ( split / /, $string ) {

                next if C4::Context->stopwords->{ uc($_) };   # skip if stopword

                warn "search on all indexes on $_" if $DEBUG;

                my $biblionumbers;

                next unless $_;

                $sth->execute( $server, $_ );

                while ( my $line = $sth->fetchrow ) {

                    $biblionumbers .= $line;

                }

# do a AND with existing list if there is one, otherwise, use the biblionumbers list as 1st result list

                if ($results) {

                    $results = NZoperatorAND($biblionumbers,$results);

                }

                else {

                    warn "NEW RES for $_ = $biblionumbers" if $DEBUG;

                    $results = $biblionumbers;

                }

            }

        }

        warn "return : $results for LEAF : $string" if $DEBUG;

        return $results;

    }

    warn "---------\nLeave NZanalyse\n---------" if $DEBUG;

}

sub NZoperatorAND{

    my ($rightresult, $leftresult)=@_;

    my @leftresult = split /;/, $leftresult;

    warn " @leftresult / $rightresult \n" if $DEBUG;

    #             my @rightresult = split /;/,$leftresult;

    my $finalresult;

# parse the left results, and if the biblionumber exist in the right result, save it in finalresult

# the result is stored twice, to have the same weight for AND than OR.

# example : TWO : 61,61,64,121 (two is twice in the biblio #61) / TOWER : 61,64,130

# result : 61,61,61,61,64,64 for two AND tower : 61 has more weight than 64

    foreach (@leftresult) {

        my $value = $_;

        my $countvalue;

        ( $value, $countvalue ) = ( $1, $2 ) if ($value=~/(.*)-(\d+)$/);

        if ( $rightresult =~ /\Q$value\E-(\d+);/ ) {

            $countvalue = ( $1 > $countvalue ? $countvalue : $1 );

            $finalresult .=

                "$value-$countvalue;$value-$countvalue;";

        }

    }

    warn "NZAND DONE : $finalresult \n" if $DEBUG;

    return $finalresult;

}

sub NZoperatorOR{

    my ($rightresult, $leftresult)=@_;

    return $rightresult.$leftresult;

}

sub NZoperatorNOT{

    my ($leftresult, $rightresult)=@_;

    my @leftresult = split /;/, $leftresult;

    #             my @rightresult = split /;/,$leftresult;

    my $finalresult;

    foreach (@leftresult) {

        my $value=$_;

        $value=$1 if $value=~m/(.*)-\d+$/;

        unless ($rightresult =~ "$value-") {

            $finalresult .= "$_;";

        }

    }

    return $finalresult;

}

=head2 NZorder

  $finalresult = NZorder($biblionumbers, $ordering,$results_per_page,$offset);

  TODO :: Description

=cut

sub NZorder {

    my ( $biblionumbers, $ordering, $results_per_page, $offset ) = @_;

    warn "biblionumbers = $biblionumbers and ordering = $ordering\n" if $DEBUG;

    # order title asc by default

    #     $ordering = '1=36 <i' unless $ordering;

    $results_per_page = 20 unless $results_per_page;

    $offset           = 0  unless $offset;

    my $dbh = C4::Context->dbh;

    #

    # order by POPULARITY

    #

    if ( $ordering =~ /popularity/ ) {

        my %result;

        my %popularity;

        # popularity is not in MARC record, it's builded from a specific query

        my $sth =

          $dbh->prepare("select sum(issues) from items where biblionumber=?");

        foreach ( split /;/, $biblionumbers ) {

            my ( $biblionumber, $title ) = split /,/, $_;

            $result{$biblionumber} = GetMarcBiblio($biblionumber);

            $sth->execute($biblionumber);

            my $popularity = $sth->fetchrow || 0;

# hint : the key is popularity.title because we can have

# many results with the same popularity. In this case, sub-ordering is done by title

# we also have biblionumber to avoid bug for 2 biblios with the same title & popularity

# (un-frequent, I agree, but we won't forget anything that way ;-)

            $popularity{ sprintf( "%10d", $popularity ) . $title

                  . $biblionumber } = $biblionumber;

        }

    # sort the hash and return the same structure as GetRecords (Zebra querying)

        my $result_hash;

        my $numbers = 0;

        if ( $ordering eq 'popularity_dsc' ) {    # sort popularity DESC

            foreach my $key ( sort { $b cmp $a } ( keys %popularity ) ) {

                $result_hash->{'RECORDS'}[ $numbers++ ] =

                  $result{ $popularity{$key} }->as_usmarc();

            }

        }

        else {                                    # sort popularity ASC

            foreach my $key ( sort ( keys %popularity ) ) {

                $result_hash->{'RECORDS'}[ $numbers++ ] =

                  $result{ $popularity{$key} }->as_usmarc();

            }

        }

        my $finalresult = ();

        $result_hash->{'hits'}         = $numbers;

        $finalresult->{'biblioserver'} = $result_hash;

        return $finalresult;

        #

        # ORDER BY author

        #

    }

    elsif ( $ordering =~ /author/ ) {

        my %result;

        foreach ( split /;/, $biblionumbers ) {

            my ( $biblionumber, $title ) = split /,/, $_;

            my $record = GetMarcBiblio($biblionumber);

            my $author;

            if ( C4::Context->preference('marcflavour') eq 'UNIMARC' ) {

                $author = $record->subfield( '200', 'f' );

                $author = $record->subfield( '700', 'a' ) unless $author;

            }

            else {

                $author = $record->subfield( '100', 'a' );

            }

# hint : the result is sorted by title.biblionumber because we can have X biblios with the same title

# and we don't want to get only 1 result for each of them !!!

            $result{ $author . $biblionumber } = $record;

        }

    # sort the hash and return the same structure as GetRecords (Zebra querying)

        my $result_hash;

        my $numbers = 0;

        if ( $ordering eq 'author_za' || $ordering eq 'author_dsc' ) {    # sort by author desc

            foreach my $key ( sort { $b cmp $a } ( keys %result ) ) {

                $result_hash->{'RECORDS'}[ $numbers++ ] =

                  $result{$key}->as_usmarc();

            }

        }

        else {                               # sort by author ASC

            foreach my $key ( sort ( keys %result ) ) {

                $result_hash->{'RECORDS'}[ $numbers++ ] =

                  $result{$key}->as_usmarc();

            }

        }

        my $finalresult = ();

        $result_hash->{'hits'}         = $numbers;

        $finalresult->{'biblioserver'} = $result_hash;

        return $finalresult;

        #

        # ORDER BY callnumber

        #

    }

    elsif ( $ordering =~ /callnumber/ ) {

        my %result;

        foreach ( split /;/, $biblionumbers ) {

            my ( $biblionumber, $title ) = split /,/, $_;

            my $record = GetMarcBiblio($biblionumber);

            my $callnumber;

            my $frameworkcode = GetFrameworkCode($biblionumber);

            my ( $callnumber_tag, $callnumber_subfield ) = GetMarcFromKohaField(  'items.itemcallnumber', $frameworkcode);

               ( $callnumber_tag, $callnumber_subfield ) = GetMarcFromKohaField('biblioitems.callnumber', $frameworkcode)

                unless $callnumber_tag;

            if ( C4::Context->preference('marcflavour') eq 'UNIMARC' ) {

                $callnumber = $record->subfield( '200', 'f' );

            } else {

                $callnumber = $record->subfield( '100', 'a' );

            }

# hint : the result is sorted by title.biblionumber because we can have X biblios with the same title

# and we don't want to get only 1 result for each of them !!!

            $result{ $callnumber . $biblionumber } = $record;

        }

    # sort the hash and return the same structure as GetRecords (Zebra querying)

        my $result_hash;

        my $numbers = 0;

        if ( $ordering eq 'call_number_dsc' ) {    # sort by title desc

            foreach my $key ( sort { $b cmp $a } ( keys %result ) ) {

                $result_hash->{'RECORDS'}[ $numbers++ ] =

                  $result{$key}->as_usmarc();

            }

        }

        else {                                     # sort by title ASC

            foreach my $key ( sort { $a cmp $b } ( keys %result ) ) {

                $result_hash->{'RECORDS'}[ $numbers++ ] =

                  $result{$key}->as_usmarc();

            }

        }

        my $finalresult = ();

        $result_hash->{'hits'}         = $numbers;

        $finalresult->{'biblioserver'} = $result_hash;

        return $finalresult;

    }

    elsif ( $ordering =~ /pubdate/ ) {             #pub year

        my %result;

        foreach ( split /;/, $biblionumbers ) {

            my ( $biblionumber, $title ) = split /,/, $_;

            my $record = GetMarcBiblio($biblionumber);

            my ( $publicationyear_tag, $publicationyear_subfield ) =

              GetMarcFromKohaField( 'biblioitems.publicationyear', '' );

            my $publicationyear =

              $record->subfield( $publicationyear_tag,

                $publicationyear_subfield );

# hint : the result is sorted by title.biblionumber because we can have X biblios with the same title

# and we don't want to get only 1 result for each of them !!!

            $result{ $publicationyear . $biblionumber } = $record;

        }

    # sort the hash and return the same structure as GetRecords (Zebra querying)

        my $result_hash;

        my $numbers = 0;

        if ( $ordering eq 'pubdate_dsc' ) {    # sort by pubyear desc

            foreach my $key ( sort { $b cmp $a } ( keys %result ) ) {

                $result_hash->{'RECORDS'}[ $numbers++ ] =

                  $result{$key}->as_usmarc();

            }

        }

        else {                                 # sort by pub year ASC

            foreach my $key ( sort ( keys %result ) ) {

                $result_hash->{'RECORDS'}[ $numbers++ ] =

                  $result{$key}->as_usmarc();

            }

        }

        my $finalresult = ();

        $result_hash->{'hits'}         = $numbers;

        $finalresult->{'biblioserver'} = $result_hash;

        return $finalresult;

        #

        # ORDER BY title

        #

    }

    elsif ( $ordering =~ /title/ ) {

# the title is in the biblionumbers string, so we just need to build a hash, sort it and return

        my %result;

        foreach ( split /;/, $biblionumbers ) {

            my ( $biblionumber, $title ) = split /,/, $_;

# hint : the result is sorted by title.biblionumber because we can have X biblios with the same title

# and we don't want to get only 1 result for each of them !!!

# hint & speed improvement : we can order without reading the record

# so order, and read records only for the requested page !

            $result{ $title . $biblionumber } = $biblionumber;

        }

    # sort the hash and return the same structure as GetRecords (Zebra querying)

        my $result_hash;

        my $numbers = 0;

        if ( $ordering eq 'title_az' ) {    # sort by title desc

            foreach my $key ( sort ( keys %result ) ) {

                $result_hash->{'RECORDS'}[ $numbers++ ] = $result{$key};

            }

        }

        else {                              # sort by title ASC

            foreach my $key ( sort { $b cmp $a } ( keys %result ) ) {

                $result_hash->{'RECORDS'}[ $numbers++ ] = $result{$key};

            }

        }

        # limit the $results_per_page to result size if it's more

        $results_per_page = $numbers - 1 if $numbers < $results_per_page;

        # for the requested page, replace biblionumber by the complete record

        # speed improvement : avoid reading too much things

        for (

            my $counter = $offset ;

            $counter <= $offset + $results_per_page ;

            $counter++

          )

        {

            $result_hash->{'RECORDS'}[$counter] =

              GetMarcBiblio( $result_hash->{'RECORDS'}[$counter] )->as_usmarc;

        }

        my $finalresult = ();

        $result_hash->{'hits'}         = $numbers;

        $finalresult->{'biblioserver'} = $result_hash;

        return $finalresult;

    }