cataloguing/value_builder/labs_theses.pl

   1 #!/usr/bin/perl
   2
   3 # Copyright 2000-2002 Katipo Communications
   4 #
   5 # This file is part of Koha.
   6 #
   7 # Koha is free software; you can redistribute it and/or modify it under the
   8 # terms of the GNU General Public License as published by the Free Software
   9 # Foundation; either version 2 of the License, or (at your option) any later
  10 # version.
  11 #
  12 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
  13 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
  14 # A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
  15 #
  16 # You should have received a copy of the GNU General Public License along
  17 # with Koha; if not, write to the Free Software Foundation, Inc.,
  18 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
  19
  20 use strict;
  21 #use warnings; FIXME - Bug 2505
  22
  23 use CGI;
  24
  25 use C4::Output;
  26 use C4::Context;
  27 use C4::Auth;
  28 use C4::Output;
  29
  30 use C4::Koha;
  31
  32 sub plugin_parameters {
  33 my ($dbh,$record,$tagslib,$i,$tabloop) = @_;
  34 return "";
  35 }
  36
  37 sub plugin_javascript {
  38 my ($dbh,$record,$tagslib,$field_number,$tabloop) = @_;
  39 my $function_name= "328".(int(rand(100000))+1);
  40 my $res="
  41 <script type=\"text/javascript\">
  42 //<![CDATA[
  43
  44 function Focus$function_name(subfield_managed) {
  45 return 1;
  46 }
  47
  48 function Blur$function_name(subfield_managed) {
  49         return 1;
  50 }
  51
  52 function Clic$function_name(i) {
  53         defaultvalue=document.f.field_value[i].value;
  54         newin=window.open(\"../cataloguing/plugin_launcher.pl?plugin_name=labs_theses.pl&cat_auth=LABTHE&index=\"+i+\"&result=\"+defaultvalue,\"unimarc field 328\",'width=700,height=700,toolbar=false,scrollbars=yes');
  55
  56 }
  57 //]]>
  58 </script>
  59 ";
  60
  61 return ($function_name,$res);
  62 }
  63
  64 sub plugin {
  65         my ($input) = @_;
  66         my $dbh=C4::Context->dbh;
  67         my $query = new CGI;
  68         my $op = $query->param('op');
  69         my $cat_auth=$query->param('cat_auth');
  70
  71         my $startfrom=$query->param('startfrom');
  72         $startfrom=0 if(!defined $startfrom);
  73         my ($template, $loggedinuser, $cookie);
  74         my $resultsperpage;
  75         my $search = $query->param('search');
  76
  77         if ($op eq "do_search") {
  78
  79                 $resultsperpage= $query->param('resultsperpage');
  80                 $resultsperpage = 19 if(!defined $resultsperpage);
  81 #               my $upperlimit=$startfrom+$resultsperpage;
  82                 # builds tag and subfield arrays
  83                 my $strquery = "SELECT authorised_value, lib from authorised_values where category = ? and lib like ?";
  84 #               $strquery .= " LIMIT $startfrom,$upperlimit";
  85
  86                 warn 'category : '.$cat_auth.' recherche :'.$search;
  87                 warn "$strquery";
  88                 $search=~s/\*/%/g;
  89                 my $sth = $dbh->prepare($strquery);
  90                 $sth->execute($cat_auth,$search);
  91                 $search=~s/%/\*/g;
  92
  93
  94                 my @results;
  95                 my $total;
  96                 while (my $data = $sth->fetchrow_hashref){
  97                         my $libjs=$data->{'lib'};
  98                         $libjs=~s#\'#\\\'#g;
  99                         my $authjs=$data->{'authorised_value'};
 100                         $authjs=~s#\'#\\\'#g;
 101                         push @results, {'libjs'=>$libjs,
 102                                                         'lib'=>$data->{'lib'},
 103                                                         'authjs'=>$authjs,
 104                                                         'auth_value'=>$data->{'authorised_value'}}
 105                                                         unless (($total<$startfrom) or ($total>$startfrom+$resultsperpage));
 106                         $total++;
 107                 }
 108
 109                 ($template, $loggedinuser, $cookie)
 110                         = get_template_and_user({template_name => "value_builder/labs_theses.tmpl",
 111                                         query => $query,
 112                                         type => 'intranet',
 113                                         authnotrequired => 1,
 114                                         debug => 1,
 115                                         });
 116
 117                 # multi page display gestion
 118                 my $displaynext=0;
 119                 my $displayprev=$startfrom;
 120                 if(($total - (($startfrom+1)*($resultsperpage))) > 0 ){
 121                         $displaynext = 1;
 122                 }
 123
 124                 my @numbers = ();
 125
 126                 if ($total>$resultsperpage)
 127                 {
 128                         for (my $i=1; (($i<$total/$resultsperpage+1) && ($i<16)); $i++)
 129                         {
 130                                         my $highlight=0;
 131                                         ($startfrom==($i-1)) && ($highlight=1);
 132                                         push @numbers, { number => $i,
 133                                                 highlight => $highlight ,
 134                                                 search=> $search,
 135                                                 startfrom => $resultsperpage*($i-1)};
 136                         }
 137                 }
 138
 139                 my $from = $startfrom+1;
 140                 my $to;
 141
 142                 if($total < (($startfrom+1)*$resultsperpage))
 143                 {
 144                         $to = $total;
 145                 } else {
 146                         $to = (($startfrom+1)*$resultsperpage);
 147                 }
 148                 $template->param(catresult => \@results,
 149                                                 cat_auth=>$cat_auth,
 150                                                 index => $query->param('index')."",
 151                                                                 startfrom=> $startfrom,
 152                                                                 displaynext=> $displaynext,
 153                                                                 displayprev=> $displayprev,
 154                                                                 resultsperpage => $resultsperpage,
 155                                                                 startfromnext => $startfrom+$resultsperpage,
 156                                                                 startfromprev => $startfrom-$resultsperpage,
 157                                                                 search=>$search,
 158                                                                 total=>$total,
 159                                                                 from=>$from,
 160                                                                 to=>$to,
 161                                                                 numbers=>\@numbers,
 162                                                                 resultlist=>1
 163                                                                 );
 164
 165         } else {
 166                 ($template, $loggedinuser, $cookie)
 167                         = get_template_and_user({template_name => "value_builder/labs_theses.tmpl",
 168                                                 query => $query,
 169                                                 type => "intranet",
 170                                                 authnotrequired => 1,
 171                                         });
 172
 173                 $template->param(
 174                                                 'search'=>$query->param('search'),
 175                 );
 176                 $template->param(
 177                                                 'index'=>''.$query->param('index')
 178                 ) if ($query->param('index'));
 179                 warn 'index : '.$query->param('index');
 180                 $template->param(
 181                                                 'cat_auth'=>$cat_auth
 182                 ) if ($cat_auth);
 183         }
 184         output_html_with_http_headers $query, $cookie, $template->output ;
 185 }
 186
 187 1;