search.marc/dictionary.pl

   1 #!/usr/bin/perl
   2
   3
   4 # Copyright 2000-2002 Katipo Communications
   5 #
   6 # This file is part of Koha.
   7 #
   8 # Koha is free software; you can redistribute it and/or modify it under the
   9 # terms of the GNU General Public License as published by the Free Software
  10 # Foundation; either version 2 of the License, or (at your option) any later
  11 # version.
  12 #
  13 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
  14 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
  15 # A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
  16 #
  17 # You should have received a copy of the GNU General Public License along with
  18 # Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
  19 # Suite 330, Boston, MA  02111-1307 USA
  20
  21 use strict;
  22 use C4::Output;
  23 use C4::Interface::CGI::Output;
  24 use C4::Auth;
  25 use CGI;
  26 use C4::Search;
  27 use C4::SearchMarc;
  28 use C4::AuthoritiesMarc;
  29 use C4::Context;
  30 use C4::Biblio;
  31 use HTML::Template;
  32
  33 my $input = new CGI;
  34 my $field =$input->param('marclist');
  35 #warn "field :$field";
  36 my ($tablename, $kohafield)=split /./,$field;
  37 #my $tablename=$input->param('tablename');
  38 $tablename="biblio" unless ($tablename);
  39 #my $kohafield = $input->param('kohafield');
  40 my @search = $input->param('search');
  41 #warn " ".$search[0];
  42 my $op=$input->param('op');
  43 if (($search[0]) and not ($op eq 'do_search')){
  44         $op='do_search';
  45 }
  46 my $script_name = 'search.marc/dictionary.pl';
  47 my $query;
  48 my $type=$input->param('type');
  49 #warn " ".$type;
  50
  51 my $dbh = C4::Context->dbh;
  52 my ($template, $loggedinuser, $cookie);
  53
  54 my $env;
  55
  56 my $startfrom=$input->param('startfrom');
  57 $startfrom=0 if(!defined $startfrom);
  58 my $searchdesc;
  59 my $resultsperpage;
  60
  61 #warn "Starting process";
  62
  63 if ($op eq "do_search") {
  64         ($template, $loggedinuser, $cookie)
  65                         = get_template_and_user({template_name => "search.marc/dictionary.tmpl",
  66                                         query => $input,
  67                                         type => $type,
  68                                         authnotrequired => 0,
  69                                         flagsrequired => {catalogue => 1},
  70                                         debug => 1,
  71                                         });
  72         my $sth=$dbh->prepare("Select distinct tagfield,tagsubfield from marc_subfield_structure where kohafield = ?");
  73         $sth->execute("$field");
  74         my (@tags, @and_or, @operator, @excluding,@value);
  75
  76         while ((my $tagfield,my $tagsubfield,my $liblibrarian) = $sth->fetchrow) {
  77                 push @tags, $dbh->quote("$tagfield$tagsubfield");
  78                 push @and_or, "";
  79                 push @operator, "contains";
  80                 push @excluding, "";
  81                 push @value, @search ;
  82         }
  83
  84         $resultsperpage= $input->param('resultsperpage');
  85         $resultsperpage = 19 if(!defined $resultsperpage);
  86         my $orderby = $input->param('orderby');
  87
  88         findseealso($dbh,\@tags);
  89 #       select distinct m1.bibid from biblio,biblioitems,marc_biblio,marc_word as m1 where biblio.biblionumber=marc_biblio.biblionumber and biblio.biblionumber=biblioitems.biblionumber and m1.bibid=marc_biblio.bibid and (m1.word  like 'Paul' and m1.tagsubfield in ('200f','710a','711a','712a','701a','702a','700a')) order by biblio.title
  90
  91
  92         my ($results,$total) = catalogsearch($dbh,\@tags ,\@and_or,
  93                                                                                 \@excluding, \@operator,  \@value,
  94                                                                                 $startfrom*$resultsperpage, $resultsperpage,$orderby);
  95
  96         my $strsth="Select distinct authtypecode from marc_subfield_structure where ";
  97         my $strtagfields="tagfield in (";
  98         my $strtagsubfields=" and tagsubfield in (";
  99         foreach my $listtags (@tags){
 100                 my @taglist=split /,/,$listtags;
 101                 foreach my $curtag (@taglist){
 102                         $strtagfields=$strtagfields."'".substr($curtag,1,3)."',";
 103                         $strtagsubfields=$strtagsubfields."'".substr($curtag,4,1)."',";
 104                 }
 105         }
 106         $strtagfields=~s/,$/)/;
 107         $strtagsubfields=~s/,$/)/;
 108         my $strsth = $strsth.$strtagfields.$strtagsubfields." and authtypecode is not NULL";
 109         warn $strsth;
 110         my $sth=$dbh->prepare($strsth);
 111         $sth->execute;
 112
 113         my @authresults;
 114         my $authnbresults;
 115         while ((my $authtypecode) = $sth->fetchrow) {
 116                 my ($curauthresults,$nbresults) = authoritysearch($dbh,[''],[''],[''],['contains'],
 117                                                                                                                 \@search,$startfrom*$resultsperpage, $resultsperpage,$authtypecode);
 118                 push @authresults, @$curauthresults;
 119                 $authnbresults+=$nbresults;
 120 #               warn "auth : $authtypecode nbauthresults : $nbresults";
 121         }
 122
 123         ($template, $loggedinuser, $cookie)
 124                 = get_template_and_user({template_name => "search.marc/dictionary.tmpl",
 125                                 query => $input,
 126                                 type => $type,
 127                                 authnotrequired => 0,
 128                                 flagsrequired => {borrowers => 1},
 129                                 flagsrequired => {catalogue => 1},
 130                                 debug => 1,
 131                                 });
 132
 133         # multi page display gestion
 134         my $displaynext=0;
 135         my $displayprev=$startfrom;
 136         if(($total - (($startfrom+1)*($resultsperpage))) > 0 ) {
 137                 $displaynext = 1;
 138         }
 139
 140         my @field_data = ();
 141
 142         for(my $i = 0 ; $i <= $#tags ; $i++) {
 143                 push @field_data, { term => "marclist", val=>$tags[$i] };
 144                 push @field_data, { term => "and_or", val=>$and_or[$i] };
 145                 push @field_data, { term => "excluding", val=>$excluding[$i] };
 146                 push @field_data, { term => "operator", val=>$operator[$i] };
 147                 push @field_data, { term => "value", val=>$value[$i] };
 148         }
 149
 150         my @numbers = ();
 151
 152         if ($total>$resultsperpage) {
 153                 for (my $i=1; $i<$total/$resultsperpage+1; $i++) {
 154                         if ($i<16) {
 155                         my $highlight=0;
 156                         ($startfrom==($i-1)) && ($highlight=1);
 157                         push @numbers, { number => $i,
 158                                         highlight => $highlight ,
 159                                         searchdata=> \@field_data,
 160                                         startfrom => ($i-1)};
 161                         }
 162         }
 163         }
 164
 165         my $from = $startfrom*$resultsperpage+1;
 166         my $to;
 167
 168         if($total < (($startfrom+1)*$resultsperpage))
 169         {
 170                 $to = $total;
 171         } else {
 172                 $to = (($startfrom+1)*$resultsperpage);
 173         }
 174         $template->param(result => $results,
 175                                                 search => $search[0],
 176                                                 marclist =>$field,
 177                                                 authresult => \@authresults,
 178                                                 nbresults => $authnbresults,
 179                                                 startfrom=> $startfrom,
 180                                                 displaynext=> $displaynext,
 181                                                 displayprev=> $displayprev,
 182                                                 resultsperpage => $resultsperpage,
 183                                                 startfromnext => $startfrom+1,
 184                                                 startfromprev => $startfrom-1,
 185                                                 searchdata=>\@field_data,
 186                                                 total=>$total,
 187                                                 from=>$from,
 188                                                 to=>$to,
 189                                                 numbers=>\@numbers,
 190                                                 MARC_ON => C4::Context->preference("marc"),
 191                                                 );
 192
 193  } else {
 194         ($template, $loggedinuser, $cookie)
 195                 = get_template_and_user({template_name => "search.marc/dictionary.tmpl",
 196                                 query => $input,
 197                                 type => $type,
 198                                 authnotrequired => 0,
 199                                 flagsrequired => {catalogue => 1},
 200                                 debug => 1,
 201                                 search => $search[0],
 202                                 marclist =>$field,
 203                                 });
 204 #warn "type : $type";
 205
 206  }
 207 $template->param(search => $search[0],
 208                                         marclist =>$field,
 209                                         type=>$type);
 210
 211 # Print the page
 212 output_html_with_http_headers $input, $cookie, $template->output;
 213
 214 # Local Variables:
 215 # tab-width: 4
 216 # End: