3 # Copyright 2011 C & P Bibliography Services
5 # This file is part of Koha.
7 # Koha is free software; you can redistribute it and/or modify it
8 # under the terms of the GNU General Public License as published by
9 # the Free Software Foundation; either version 3 of the License, or
10 # (at your option) any later version.
12 # Koha is distributed in the hope that it will be useful, but
13 # WITHOUT ANY WARRANTY; without even the implied warranty of
14 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 # GNU General Public License for more details.
17 # You should have received a copy of the GNU General Public License
18 # along with Koha; if not, see <http://www.gnu.org/licenses>.
25 upload-cover-image.pl - Script for handling uploading of both single and bulk coverimages and importing them into the database.
33 This script is called and presents the user with an interface allowing him/her to upload a single cover image or bulk cover images via a zip file.
34 Images will be resized into thumbnails of 140x200 pixels and larger images of
35 800x600 pixels. If the images that are uploaded are larger, they will be
36 resized, maintaining aspect ratio.
47 use C4::Auth qw( get_template_and_user );
48 use C4::Output qw( output_html_with_http_headers );
50 use Koha::CoverImages;
52 use Koha::UploadedFiles;
53 use C4::Log qw( logaction );
57 my $fileID = $input->param('uploadedfileid');
58 my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
60 template_name => "tools/upload-images.tt",
63 flagsrequired => { tools => 'upload_local_cover_images' },
67 my $filetype = $input->param('filetype');
68 my $biblionumber = $input->param('biblionumber');
69 my $itemnumber = $input->param('itemnumber');
70 my $replace = !C4::Context->preference("AllowMultipleCovers")
71 || $input->param('replace');
72 my $op = $input->param('op') // q{};
81 $item = Koha::Items->find($itemnumber);
82 $biblionumber = $item->biblionumber;
83 $biblio = Koha::Biblios->find( $biblionumber );
84 $cover_images = $item->cover_images->as_list;
85 } elsif ( $biblionumber ){
86 $biblio = Koha::Biblios->find( $biblionumber );
87 $cover_images = $biblio->cover_images->as_list;
91 filetype => $filetype,
93 biblionumber => $biblionumber,
94 itemnumber => $itemnumber,
95 cover_images => $cover_images,
101 if ( $op eq 'cud-process' && $fileID ) {
102 my $upload = Koha::UploadedFiles->find( $fileID );
103 if ( $filetype eq 'image' ) {
104 my $fh = $upload->file_handle;
105 my $srcimage = GD::Image->new($fh);
107 if ( defined $srcimage ) {
111 Koha::Items->find($itemnumber)->cover_images->delete;
112 } elsif ( $biblionumber ) {
113 Koha::Biblios->find($biblionumber)->cover_images->search({ itemnumber => undef })->delete;
117 Koha::CoverImage->new(
119 biblionumber => $biblionumber,
120 itemnumber => $itemnumber,
121 src_image => $srcimage
140 my $filename = $upload->full_path;
141 my $dirname = File::Temp::tempdir( CLEANUP => 1 );
142 qx/unzip $filename -d $dirname/;
144 unless ( $exit_code == 0 ) {
149 push @directories, "$dirname";
150 foreach my $recursive_dir (@directories) {
152 opendir $dir, $recursive_dir;
153 while ( my $entry = readdir $dir ) {
154 push @directories, "$recursive_dir/$entry"
155 if ( -d "$recursive_dir/$entry" and $entry !~ /^[._]/ );
159 foreach my $dir (@directories) {
161 my $idlink = "$dir/idlink.txt";
162 my $datalink = "$dir/datalink.txt";
163 if ( -e $idlink && !-l $idlink ) {
165 } elsif ( -e $datalink && !-l $datalink ) {
171 if ( open( my $fh, '<', $file ) ) {
172 while ( my $line = <$fh> ) {
174 ( $line =~ /\t/ ) ? "\t"
175 : ( $line =~ /,/ ) ? ","
178 unless ( $delim eq "," || $delim eq "\t" ) {
179 warn "Unrecognized or missing field delimeter. Please verify that you are using either a ',' or a 'tab'";
184 ( $biblionumber, $filename ) = split $delim, $line, 2;
186 s/[\"\r\n]//g; # remove offensive characters
187 $filename =~ s/[\"\r\n]//g;
188 $filename =~ s/^\s+//;
189 $filename =~ s/\s+$//;
190 my $full_filename = Cwd::abs_path("$dir/$filename"); #Resolve any relative filepath references
192 if ( $full_filename =~ /^\Q$dir\E/ ){
193 $srcimage = GD::Image->new($full_filename);
197 if ( defined $srcimage ) {
201 if ( $biblionumber ) {
202 $biblio = Koha::Biblios->find( $biblionumber );
203 $biblio->cover_images->delete;
204 } elsif ( $itemnumber ) {
205 $item = Koha::Items->find($itemnumber);
206 $item->cover_images->delete;
207 $biblio = Koha::Biblios->find( $item->{biblionumber} );
211 $biblio = Koha::Biblios->find( $biblionumber );
212 } elsif ( $itemnumber ){
213 $item = Koha::Items->find($itemnumber);
214 $biblio = Koha::Biblios->find( $item->{biblionumber} );
221 biblionumber => $biblionumber,
222 itemnumber => $itemnumber,
223 title => $biblio->title
226 Koha::CoverImage->new(
228 biblionumber => $biblionumber,
229 itemnumber => $itemnumber,
230 src_image => $srcimage
244 if ( !$error && C4::Context->preference("CataloguingLog") ) {
245 logaction( 'CATALOGUING', 'MODIFY', $biblionumber, "biblio cover image: $filename" );
263 biblionumber => $biblionumber || Koha::Items->find($itemnumber)->biblionumber,
264 itemnumber => $itemnumber,
266 } elsif ( @results ){
273 print $input->redirect("/cgi-bin/koha/tools/upload-cover-image.pl?biblionumber=$biblionumber&itemnumber=$itemnumber");
277 output_html_with_http_headers $input, $cookie, $template->output;
283 Written by Jared Camins-Esakov of C & P Bibliography Services, in part based on
284 code by Koustubha Kale of Anant Corporation and Chris Nighswonger of Foundation