Bug 9455: Remove unnecessary quoting from sql
[koha.git] / members / files.pl
blob84bc41edd4393d6b46a4432f418fff444c9e3faf
1 #!/usr/bin/perl
3 # Copyright 2012 ByWater Solutions
5 # This file is part of Koha.
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.
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.
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.
20 use strict;
21 use warnings;
23 use CGI;
25 use C4::Auth;
26 use C4::Branch;
27 use C4::Output;
28 use C4::Members;
29 use C4::Members::Attributes qw(GetBorrowerAttributes);
30 use C4::Debug;
32 use Koha::DateUtils;
33 use Koha::Borrower::Files;
35 my $cgi = CGI->new;
37 my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
39 template_name => "members/files.tmpl",
40 query => $cgi,
41 type => "intranet",
42 authnotrequired => 0,
43 flagsrequired => { borrowers => 1 },
44 debug => 1,
47 $template->param( 'borrower_files' => 1 );
49 my $borrowernumber = $cgi->param('borrowernumber');
50 my $bf = Koha::Borrower::Files->new( borrowernumber => $borrowernumber );
52 my $op = $cgi->param('op') || '';
54 if ( $op eq 'download' ) {
55 my $file_id = $cgi->param('file_id');
56 my $file = $bf->GetFile( id => $file_id );
58 print $cgi->header(
59 -type => $file->{'file_type'},
60 -charset => 'utf-8',
61 -attachment => $file->{'file_name'}
63 print $file->{'file_content'};
65 else {
66 my $data = GetMember( borrowernumber => $borrowernumber );
67 $template->param(%$data);
69 my %errors;
71 if ( $op eq 'upload' ) {
72 my $uploaded_file = $cgi->upload('uploadfile');
74 if ($uploaded_file) {
75 my $filename = $cgi->param('uploadfile');
76 my $mimetype = $cgi->uploadInfo($filename)->{'Content-Type'};
78 $errors{'empty_upload'} = 1 if ( -z $uploaded_file );
80 if (%errors) {
81 $template->param( errors => %errors );
83 else {
84 my $file_content;
85 while (<$uploaded_file>) {
86 $file_content .= $_;
89 $bf->AddFile(
90 name => $filename,
91 type => $mimetype,
92 content => $file_content,
93 description => $cgi->param('description'),
97 else {
98 $errors{'no_file'} = 1;
100 } elsif ( $op eq 'delete' ) {
101 $bf->DelFile( id => $cgi->param('file_id') );
104 $template->param(
105 categoryname => $data->{'description'},
106 branchname => GetBranchName($data->{'branchcode'}),
109 if (C4::Context->preference('ExtendedPatronAttributes')) {
110 my $attributes = GetBorrowerAttributes($borrowernumber);
111 $template->param(
112 ExtendedPatronAttributes => 1,
113 extendedattributes => $attributes
117 my ($picture, $dberror) = GetPatronImage($data->{'cardnumber'});
118 $template->param( picture => 1 ) if $picture;
120 $template->param(
121 files => Koha::Borrower::Files->new( borrowernumber => $borrowernumber )
122 ->GetFilesInfo(),
124 errors => \%errors
126 output_html_with_http_headers $cgi, $cookie, $template->output;
129 =head1 AUTHOR
131 Kyle M Hall <kyle@bywatersolutions.com>
133 =cut