Bug 9455: Remove unnecessary quoting from sql
[koha.git] / members / mancredit.pl
blob88200d0e20b6a99b4010f65d3a2007391119e3fb
1 #!/usr/bin/perl
3 #written 11/1/2000 by chris@katipo.oc.nz
4 #script to display borrowers account details
7 # Copyright 2000-2002 Katipo Communications
8 # Copyright 2010 BibLibre
10 # This file is part of Koha.
12 # Koha is free software; you can redistribute it and/or modify it under the
13 # terms of the GNU General Public License as published by the Free Software
14 # Foundation; either version 2 of the License, or (at your option) any later
15 # version.
17 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
18 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
19 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
21 # You should have received a copy of the GNU General Public License along
22 # with Koha; if not, write to the Free Software Foundation, Inc.,
23 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
25 use strict;
26 use warnings;
28 use C4::Auth;
29 use C4::Output;
30 use CGI;
32 use C4::Members;
33 use C4::Branch;
34 use C4::Accounts;
35 use C4::Items;
36 use C4::Members::Attributes qw(GetBorrowerAttributes);
38 my $input=new CGI;
40 my $borrowernumber=$input->param('borrowernumber');
42 #get borrower details
43 my $data=GetMember('borrowernumber' => $borrowernumber);
44 my $add=$input->param('add');
46 if ($add){
47 if(checkauth($input)) {
48 my $barcode = $input->param('barcode');
49 my $itemnum;
50 if ($barcode) {
51 $itemnum = GetItemnumberFromBarcode($barcode);
53 my $desc = $input->param('desc');
54 my $note = $input->param('note');
55 my $amount = $input->param('amount') || 0;
56 $amount = -$amount;
57 my $type = $input->param('type');
58 manualinvoice( $borrowernumber, $itemnum, $desc, $type, $amount, $note );
59 print $input->redirect("/cgi-bin/koha/members/boraccount.pl?borrowernumber=$borrowernumber");
61 } else {
62 my ($template, $loggedinuser, $cookie)
63 = get_template_and_user({template_name => "members/mancredit.tmpl",
64 query => $input,
65 type => "intranet",
66 authnotrequired => 0,
67 flagsrequired => {borrowers => 1, updatecharges => 1},
68 debug => 1,
69 });
71 if ( $data->{'category_type'} eq 'C') {
72 my ( $catcodes, $labels ) = GetborCatFromCatType( 'A', 'WHERE category_type = ?' );
73 my $cnt = scalar(@$catcodes);
74 $template->param( 'CATCODE_MULTI' => 1) if $cnt > 1;
75 $template->param( 'catcode' => $catcodes->[0]) if $cnt == 1;
78 $template->param( adultborrower => 1 ) if ( $data->{category_type} eq 'A' );
79 my ($picture, $dberror) = GetPatronImage($data->{'cardnumber'});
80 $template->param( picture => 1 ) if $picture;
82 if (C4::Context->preference('ExtendedPatronAttributes')) {
83 my $attributes = GetBorrowerAttributes($borrowernumber);
84 $template->param(
85 ExtendedPatronAttributes => 1,
86 extendedattributes => $attributes
90 $template->param(
91 borrowernumber => $borrowernumber,
92 firstname => $data->{'firstname'},
93 surname => $data->{'surname'},
94 cardnumber => $data->{'cardnumber'},
95 categorycode => $data->{'categorycode'},
96 category_type => $data->{'category_type'},
97 categoryname => $data->{'description'},
98 address => $data->{'address'},
99 address2 => $data->{'address2'},
100 city => $data->{'city'},
101 state => $data->{'state'},
102 zipcode => $data->{'zipcode'},
103 country => $data->{'country'},
104 phone => $data->{'phone'},
105 email => $data->{'email'},
106 branchcode => $data->{'branchcode'},
107 branchname => GetBranchName($data->{'branchcode'}),
108 is_child => ($data->{'category_type'} eq 'C'),
109 activeBorrowerRelationship => (C4::Context->preference('borrowerRelationship') ne ''),
111 output_html_with_http_headers $input, $cookie, $template->output;