Bug 21573: Move lists barcode and biblionumber entry form to modal
[koha.git] / patroncards / image-manage.pl
1 #!/usr/bin/perl
2
3 use Modern::Perl;
4
5 use CGI qw ( -utf8 );
6 use Graphics::Magick;
7 use POSIX qw(ceil);
8
9 use C4::Context;
10 use C4::Auth;
11 use C4::Output;
12 use C4::Debug;
13 use C4::Creators;
14 use C4::Patroncards;
15
16 my $cgi = CGI->new;
17
18 my ($template, $loggedinuser, $cookie) = get_template_and_user({
19                     template_name       => "patroncards/image-manage.tt",
20                     query               => $cgi,
21                     type                => "intranet",
22                     authnotrequired     => 0,
23                     flagsrequired       => {tools => 'batch_upload_patron_images'}, # FIXME: establish flag for patron card creator
24                     debug               => 0,
25                     });
26
27 my $file_name = $cgi->param('uploadfile') || '';
28 my $image_name = $cgi->param('image_name') || $file_name;
29 my $upload_file = $cgi->upload('uploadfile') || '';
30 my $op = $cgi->param('op') || 'none';
31 my @image_ids = $cgi->multi_param('image_id') if $cgi->param('image_id');
32
33 my $source_file = "$file_name"; # otherwise we end up with what amounts to a pointer to a filehandle rather than a user-friendly filename
34
35 my $display_columns = { image =>    [  #{db column      => {label => 'col label', is link?          }},
36                                         {image_id       => {label => 'ID',      link_field      => 0}},
37                                         {image_name     => {label => 'Name',    link_field      => 0}},
38                                         {_delete        => {label => 'Delete', link_field => 0}},
39                                         {select         => {label => 'Select',  value           => 'image_id'}},
40                                     ],
41 };
42 my $table = html_table($display_columns->{'image'}, get_image(undef, "image_id, image_name"));
43
44 my $image_limit = C4::Context->preference('ImageLimit') || '';
45 my $errstr = '';        # NOTE: For error codes see error-messages.inc
46
47 if ($op eq 'upload') {
48     # Checking for duplicate image name
49     my $dbh = C4::Context->dbh;
50     my $query = "SELECT COUNT(*) FROM creator_images WHERE image_name=?";
51     my ( $exists ) = $dbh->selectrow_array( $query, undef, $image_name );
52     if ( $exists ) {
53         $errstr = 304;
54         $template->param(
55             IMPORT_SUCCESSFUL => 0,
56             SOURCE_FILE => $source_file,
57             IMAGE_NAME => $image_name,
58             TABLE => $table,
59             error => $errstr,
60         );
61     } else {
62         if (!$upload_file) {
63             warn sprintf('An error occurred while attempting to upload file %s.', $source_file);
64             $errstr = 301;
65             $template->param(
66                 IMPORT_SUCCESSFUL => 0,
67                 SOURCE_FILE => $source_file,
68                 IMAGE_NAME => $image_name,
69                 TABLE => $table,
70                 error => $errstr,
71             );
72         }
73         else {
74             my $image = Graphics::Magick->new;
75             eval{$image->Read($cgi->tmpFileName($file_name));};
76             if ($@) {
77                 warn sprintf('An error occurred while creating the image object: %s',$@);
78                 $errstr = 202;
79                 $template->param(
80                     IMPORT_SUCCESSFUL => 0,
81                     SOURCE_FILE => $source_file,
82                     IMAGE_NAME => $image_name,
83                     TABLE => $table,
84                     error => $errstr,
85                 );
86             }
87             else {
88                 my $errstr = '';
89                 my $size = $image->Get('filesize');
90                 $errstr =  302 if $size > 500000;
91                 $image->Set(magick => 'png'); # convert all images to png as this is a lossless format which is important for resizing operations later on
92                 my $err = put_image($image_name, $image->ImageToBlob()) || '0';
93                 $errstr = 101 if $err == 1;
94                 $errstr = 303 if $err == 202;
95                 if ($errstr) {
96                     $template->param(
97                         IMPORT_SUCCESSFUL => 0,
98                         SOURCE_FILE => $source_file,
99                         IMAGE_NAME => $image_name,
100                         TABLE => $table,
101                         error => $errstr,
102                         image_limit => $image_limit,
103                     );
104                 }
105                 else {
106                     $table = html_table($display_columns->{'image'}, get_image(undef, "image_id, image_name"));  # refresh table data after successfully performing save operation
107                     $template->param(
108                         IMPORT_SUCCESSFUL => 1,
109                         SOURCE_FILE => $source_file,
110                         IMAGE_NAME => $image_name,
111                         TABLE => $table,
112                     );
113                 }
114             }
115         }
116     }
117 }
118 elsif ($op eq 'delete') {
119     my $err = '';
120     my $errstr = '';
121     if (@image_ids) {
122         $err = rm_image(\@image_ids);
123         $errstr = 102 if $err;
124     }
125     else {
126         warn sprintf('No image ids passed in to delete.');
127         $errstr = 202;
128     }
129     if ($errstr) {
130         $template->param(
131             DELETE_SUCCESSFULL => 0,
132             IMAGE_IDS => join(', ', @image_ids),
133             TABLE => $table,
134             error => $errstr,
135             image_ids => join(',',@image_ids),
136         );
137     }
138     else {
139         $table = html_table($display_columns->{'image'}, get_image(undef, "image_id, image_name"));  # refresh table data after successfully performing delete operation
140         $template->param(
141             DELETE_SUCCESSFULL => 1,
142             TABLE => $table,
143         );
144     }
145 }
146 elsif ($op eq 'none') {
147     $template->param(
148         IMPORT_SUCCESSFUL => 0,
149         SOURCE_FILE => $source_file,
150         IMAGE_NAME => $image_name,
151         TABLE => $table,
152     );
153 }
154 else { # to trap unsupported operations
155     warn sprintf('Image upload interface called an unsupported operation: %s',$op);
156     $errstr = 201;
157     $template->param(
158         IMPORT_SUCCESSFUL => 0,
159         SOURCE_FILE => $source_file,
160         IMAGE_NAME => $image_name,
161         TABLE => $table,
162         error => $errstr,
163     );
164 }
165
166 output_html_with_http_headers $cgi, $cookie, $template->output;
167
168 __END__
169
170 =head1 NAME
171
172 image-upload.pl - Script for handling uploading of single images and importing them into the database.
173
174 =head1 SYNOPSIS
175
176 image-upload.pl
177
178 =head1 DESCRIPTION
179
180 This script is called and presents the user with an interface allowing him/her to upload a single image file. Files greater than 500K will be refused.
181
182 =head1 AUTHOR
183
184 Chris Nighswonger <cnighswonger AT foundations DOT edu>
185
186 =head1 COPYRIGHT
187
188 Copyright 2009 Foundations Bible College.
189
190 =head1 LICENSE
191
192 This file is part of Koha.
193
194 Koha is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software
195 Foundation; either version 2 of the License, or (at your option) any later version.
196
197 You should have received a copy of the GNU General Public License along with Koha; if not, write to the Free Software Foundation, Inc., 51 Franklin Street,
198 Fifth Floor, Boston, MA 02110-1301 USA.
199
200 =head1 DISCLAIMER OF WARRANTY
201
202 Koha is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
203 A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
204
205 =cut