5 # Copyright 2000-2002 Katipo Communications
7 # This file is part of Koha.
9 # Koha is free software; you can redistribute it and/or modify it under the
10 # terms of the GNU General Public License as published by the Free Software
11 # Foundation; either version 2 of the License, or (at your option) any later
14 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
15 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
16 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
18 # You should have received a copy of the GNU General Public License along with
19 # Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
20 # Suite 330, Boston, MA 02111-1307 USA
23 use C4::AuthoritiesMarc;
27 use C4::Interface::CGI::Output;
36 plugin_parameters : other parameters added when the plugin is called by the dopop function
39 sub plugin_parameters {
40 my ($dbh,$record,$tagslib,$i,$tabloop) = @_;
46 plugin_javascript : the javascript function called when the user enters the subfield.
47 contain 3 javascript functions :
48 * one called when the field is entered (OnFocus). Named FocusXXX
49 * one called when the field is leaved (onBlur). Named BlurXXX
50 * one called when the ... link is clicked (<a href="javascript:function">) named ClicXXX
54 * a variable containing the 3 scripts.
55 the 3 scripts are inserted after the <input> in the html code
58 sub plugin_javascript {
59 my ($dbh,$record,$tagslib,$field_number,$tabloop) = @_;
60 my $function_name= "210c".(int(rand(100000))+1);
61 #---- build editors list.
62 #---- the editor list is built from the "EDITORS" thesaurus
63 #---- this thesaurus category must be filled as follow :
65 #---- 200$b for editor
66 #---- 200$c (repeated) for collections
67 my $sth = $dbh->prepare("select auth_subfield_table.authid,subfieldvalue from auth_subfield_table
68 left join auth_header on auth_subfield_table.authid=auth_header.authid
69 where authtypecode='EDITORS' and tag='200' and subfieldcode='a'");
70 my $sth2 = $dbh->prepare("select subfieldvalue from auth_subfield_table where tag='200' and subfieldcode='b' and authid=?");
73 my $authoritysep = C4::Context->preference("authoritysep");
74 while (my ($authid,$isbn) = $sth->fetchrow) {
75 $sth2->execute($authid);
76 my ($editor) = $sth2->fetchrow;
77 push(@editors,"$isbn $authoritysep $editor");
81 function Focus$function_name(index) {
83 foreach my $editor (@editors) {
84 my @arr = split (/ $authoritysep /,$editor);
85 $res .='["'.$arr[0].'","'.$arr[1].'","'.$arr[2].'"],';
90 // search isbn subfield. it''s 010a
92 for (i=0 ; i<document.f.field_value.length ; i++) {
93 if (document.f.tag[i].value == '010' && document.f.subfield[i].value == 'a') {
94 isbn_found=document.f.field_value[i].value;
97 for (i=0;i<=isbn_array.length;i++) {
98 if (isbn_found.substr(0,isbn_array[i][0].length) == isbn_array[i][0]) {
99 document.f.field_value[index].value =isbn_array[i][1];
104 function Blur$function_name(subfield_managed) {
108 function Clic$function_name(subfield_managed) {
109 defaultvalue=escape(document.forms[0].field_value[subfield_managed].value);
110 newin=window.open(\"../plugin_launcher.pl?plugin_name=unimarc_field_210c.pl&index=\"+subfield_managed,\"unimarc 225a\",'width=500,height=600,toolbar=false,scrollbars=yes');
114 return ($function_name,$res);
119 plugin : the true value_builded. The screen that is open in the popup window.
125 my $index = $input->param("index");
126 my $result = $input->param("result");
129 my $op = $query->param('op');
130 my $authtypecode = $query->param('authtypecode');
131 my $index = $query->param('index');
132 my $category = $query->param('category');
133 my $resultstring = $query->param('result');
134 my $dbh = C4::Context->dbh;
136 my $startfrom=$query->param('startfrom');
137 $startfrom=0 if(!defined $startfrom);
138 my ($template, $loggedinuser, $cookie);
141 my $authtypes = getauthtypes;
143 foreach my $thisauthtype (keys %$authtypes) {
144 my $selected = 1 if $thisauthtype eq $authtypecode;
145 my %row =(value => $thisauthtype,
146 selected => $selected,
147 authtypetext => $authtypes->{$thisauthtype}{'authtypetext'},
150 push @authtypesloop, \%row;
153 if ($op eq "do_search") {
154 my @marclist = $query->param('marclist');
155 my @and_or = $query->param('and_or');
156 my @excluding = $query->param('excluding');
157 my @operator = $query->param('operator');
158 my @value = $query->param('value');
160 $resultsperpage= $query->param('resultsperpage');
161 $resultsperpage = 19 if(!defined $resultsperpage);
163 # builds tag and subfield arrays
166 my ($results,$total) = authoritysearch($dbh, \@tags,\@and_or,
167 \@excluding, \@operator, \@value,
168 $startfrom*$resultsperpage, $resultsperpage,$authtypecode);# $orderby);
170 ($template, $loggedinuser, $cookie)
171 = get_template_and_user({template_name => "value_builder/unimarc_field_210c.tmpl",
174 authnotrequired => 0,
175 flagsrequired => {editcatalogue => 1},
179 # multi page display gestion
181 my $displayprev=$startfrom;
182 if(($total - (($startfrom+1)*($resultsperpage))) > 0 ) {
188 if ($total>$resultsperpage) {
189 for (my $i=1; $i<$total/$resultsperpage+1; $i++) {
192 ($startfrom==($i-1)) && ($highlight=1);
193 push @numbers, { number => $i,
194 highlight => $highlight ,
195 startfrom => ($i-1)};
200 my $from = $startfrom*$resultsperpage+1;
203 if($total < (($startfrom+1)*$resultsperpage)) {
206 $to = (($startfrom+1)*$resultsperpage);
208 $template->param(result => $results) if $results;
209 $template->param(index => $query->param('index'));
210 $template->param(startfrom=> $startfrom,
211 displaynext=> $displaynext,
212 displayprev=> $displayprev,
213 resultsperpage => $resultsperpage,
214 startfromnext => $startfrom+1,
215 startfromprev => $startfrom-1,
221 authtypecode =>$authtypecode,
222 resultstring =>$value[0],
225 ($template, $loggedinuser, $cookie)
226 = get_template_and_user({template_name => "value_builder/unimarc_field_210c.tmpl",
229 authnotrequired => 0,
230 flagsrequired => {catalogue => 1},
234 $template->param(index => $index,
235 resultstring => $resultstring
239 $template->param(authtypesloop => \@authtypesloop);
240 $template->param(category => $category);
243 output_html_with_http_headers $query, $cookie, $template->output;