4 # Copyright 2000-2002 Katipo Communications
6 # This file is part of Koha.
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
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.
17 # You should have received a copy of the GNU General Public License along
18 # with Koha; if not, write to the Free Software Foundation, Inc.,
19 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
22 #use warnings; FIXME - Bug 2505
29 use vars qw( $tagslib);
30 use vars qw( $authorised_values_sth);
31 use vars qw( $is_a_modif );
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) = @_;
44 sub plugin_javascript {
45 my ($dbh,$record,$tagslib,$field_number,$tabloop) = @_;
46 my $function_name= "macles".(int(rand(100000))+1);
48 <script type=\"text/javascript\">
51 function Focus$function_name(subfield_managed) {
55 function Blur$function_name(subfield_managed) {
59 function Clic$function_name(i) {
60 newin=window.open(\"../cataloguing/plugin_launcher.pl?plugin_name=macles.pl&index=\"+i,\"MACLES\",',toolbar=false,scrollbars=yes');
67 return ($function_name,$res);
74 # my $input = new CGI;
75 my $index= $input->param('index');
78 my $dbh = C4::Context->dbh;
79 my $rq=$dbh->prepare("SELECT authorised_value, lib from authorised_values where category=\"MACLES\" order by authorised_value DESC");
84 my (%numbers,%cells,@colhdr,@rowhdr,@multiplelines,@lists,$table);
85 while (my $tab = $rq->fetchrow_hashref){
86 # if (! utf8::is_utf8($tab->{lib})) {
87 # utf8::decode($tab->{lib});
90 my $number=substr($tab->{authorised_value},0,1);
91 if ($tab->{authorised_value}=~/[0-9]XX/){
92 $numbers{$number}->{'hdr_tab'}=$tab->{lib};
93 $numbers{$number}->{'Table'}=($number=~/[1-7]/);
94 } elsif ($tab->{authorised_value}=~/.X./){
95 $tab->{authorised_value}=~s/X/\./;
97 unshift @{$numbers{$number}->{"col_hdr"}},{"colvalue"=>$tab->{authorised_value},"collib"=>$tab->{lib}};
98 } elsif ($tab->{authorised_value}=~/..X/){
99 $tab->{authorised_value}=~s/X/\./;
100 unshift @{$numbers{$number}->{"row_hdr"}},{"rowvalue"=>$tab->{authorised_value},"rowlib"=>$tab->{lib}}
101 } elsif ($tab->{'authorised_value'}=~/,/){
102 my @listval=split /,/,$tab->{'authorised_value'};
103 # $tab->{authorised_value}=~s/,/","/g;
104 # $tab->{authorised_value}="(".$tab->{authorised_value}.")";
106 foreach my $val (@listval){
107 unshift @{$numbers{$number}->{$val}},$tab->{'lib'};
108 my $mulrow=substr($val,0,2);
111 foreach my $mulrow (sort keys %mulrows){
112 unshift @{$numbers{$number}->{$mulrow}},{'listlib' => $tab->{'lib'},'listvalue' => $tab->{'authorised_value'}};
115 unshift @{$numbers{$number}->{$tab->{'authorised_value'}}},$tab->{'lib'};
117 # use Data::Dumper;warn "BIGLOOP IN".Dumper(@BIGLOOP);
119 foreach my $num (sort keys %numbers){
120 my @tmpcolhdr = @{$numbers{$num}->{'col_hdr'}} if ($numbers{$num}->{'col_hdr'});
121 my @tmprowhdr = @{$numbers{$num}->{"row_hdr"}} if ($numbers{$num}->{'row_hdr'});
125 foreach my $row (@tmprowhdr){
126 my $tmprowvalue=$row->{rowvalue};
127 my $rowcode=$1 if $tmprowvalue=~/[0-9]([0-9])\./;
129 if (scalar(@tmpcolhdr)>0){
130 #cas du tableau bidim
131 foreach my $col (@tmpcolhdr){
132 my $tmpcolvalue=$col->{colvalue};
133 my $colcode=$1 if $tmpcolvalue=~/[0-9]\.([0-9])/;
135 $cell{celvalue}=$num.$rowcode.$colcode;
136 $cell{rowvalue}=$tmprowvalue;
137 $cell{colvalue}=$tmpcolvalue;
138 if ($numbers{$num}->{$num.$rowcode.$colcode}){
139 foreach (@{$numbers{$num}->{$num.$rowcode.$colcode}}){
140 push @{$cell{libs}},{'lib'=>$_};
143 push @{$cell{libs}},{'lib'=>$num.$rowcode.$colcode};
147 if ($numbers{$num}->{$num.$rowcode}){
148 my @tmpliblist=@{$numbers{$num}->{$num.$rowcode}};
149 push @lists,{'lib'=>$row->{rowlib},'liblist'=>\@tmpliblist};
152 #Cas de la liste simple
153 foreach my $key (sort keys %{$numbers{$num}}){
155 if ($key=~/$num$rowcode[0-9]/){
156 $cell{celvalue}=$key;
157 foreach my $lib (@{$numbers{$num}->{$key}}){
158 push @{$cell{'libs'}},{'lib'=>$lib};
164 push @lines,{'cells'=>\@cells,'rowvalue'=>$row->{rowvalue},'rowlib'=>$row->{rowlib}};
166 $BIGLOOPcell{'Lists'}=\@lists if (scalar(@lists)>0);
167 $BIGLOOPcell{'lines'}=\@lines if (scalar(@lines)>0);
168 $BIGLOOPcell{'col_hdr'}=\@tmpcolhdr if (scalar(@tmpcolhdr)>0);
169 $BIGLOOPcell{'Table'}=$numbers{$num}->{'Table'};
170 $BIGLOOPcell{'hdr_tab'}=$numbers{$num}->{'hdr_tab'};
171 $BIGLOOPcell{'number'}=$num;
172 push @BIGLOOP,\%BIGLOOPcell;
174 # warn "BIGLOOP OUT".Dumper(@BIGLOOP);
175 my ($template, $loggedinuser, $cookie)
176 = get_template_and_user({template_name => "cataloguing/value_builder/macles.tmpl",
179 authnotrequired => 0,
180 flagsrequired => {editcatalogue => '*'},
183 $template->param(BIGLOOP=>\@BIGLOOP);
184 $template->param("index"=>$index);
185 output_html_with_http_headers $input, $cookie, $template->output;