Merge remote branch 'kc/new/enh/bug_5547' into kcmaster
[wip/koha-chris_n.git] / members / maninvoice.pl
1 #!/usr/bin/perl
2
3 #written 11/1/2000 by chris@katipo.oc.nz
4 #script to display borrowers account details
5
6
7 # Copyright 2000-2002 Katipo Communications
8 # Copyright 2010 BibLibre
9 #
10 # This file is part of Koha.
11 #
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.
16 #
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.
20 #
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.
24
25 use strict;
26 use warnings;
27
28 use C4::Auth;
29 use C4::Output;
30 use CGI;
31 use C4::Members;
32 use C4::Accounts;
33 use C4::Items;
34 use C4::Branch;
35
36 my $input=new CGI;
37
38 my $borrowernumber=$input->param('borrowernumber');
39
40
41 # get borrower details
42 my $data=GetMember('borrowernumber'=>$borrowernumber);
43 my $add=$input->param('add');
44 if ($add){
45 #  print $input->header;
46     my $barcode=$input->param('barcode');
47     my $itemnum = GetItemnumberFromBarcode($barcode) if $barcode;
48     my $desc=$input->param('desc');
49     my $amount=$input->param('amount');
50     my $type=$input->param('type');
51     my $error=manualinvoice($borrowernumber,$itemnum,$desc,$type,$amount);
52         if ($error){
53                 my ($template, $loggedinuser, $cookie)
54                   = get_template_and_user({template_name => "members/maninvoice.tmpl",
55                                         query => $input,
56                                         type => "intranet",
57                                         authnotrequired => 0,
58                                         flagsrequired => {borrowers => 1},
59                                         debug => 1,
60                                         });
61                 if ($error =~ /FOREIGN KEY/ && $error =~ /itemnumber/){
62                         $template->param('ITEMNUMBER' => 1);
63                 }
64                 $template->param('ERROR' => $error);
65         output_html_with_http_headers $input, $cookie, $template->output;
66         }
67         else {
68                 print $input->redirect("/cgi-bin/koha/members/boraccount.pl?borrowernumber=$borrowernumber");
69                 exit;
70         }
71 } else {
72
73         my ($template, $loggedinuser, $cookie)
74         = get_template_and_user({template_name => "members/maninvoice.tmpl",
75                                         query => $input,
76                                         type => "intranet",
77                                         authnotrequired => 0,
78                                         flagsrequired => {borrowers => 1, updatecharges => 1},
79                                         debug => 1,
80                                         });
81                                         
82   # get authorised values with type of MANUAL_INV
83   my @invoice_types;
84   my $dbh = C4::Context->dbh;
85   my $sth = $dbh->prepare('SELECT * FROM authorised_values WHERE category = "MANUAL_INV"');
86   $sth->execute();
87   while ( my $row = $sth->fetchrow_hashref() ) {
88     push @invoice_types, $row;
89   }
90   $template->param( invoice_types_loop => \@invoice_types );
91
92     if ( $data->{'category_type'} eq 'C') {
93         my  ( $catcodes, $labels ) =  GetborCatFromCatType( 'A', 'WHERE category_type = ?' );
94         my $cnt = scalar(@$catcodes);
95         $template->param( 'CATCODE_MULTI' => 1) if $cnt > 1;
96         $template->param( 'catcode' =>    $catcodes->[0])  if $cnt == 1;
97     }
98
99     $template->param( adultborrower => 1 ) if ( $data->{'category_type'} eq 'A' );
100     my ($picture, $dberror) = GetPatronImage($data->{'cardnumber'});
101     $template->param( picture => 1 ) if $picture;
102
103         $template->param(
104                 borrowernumber => $borrowernumber,
105                 firstname => $data->{'firstname'},
106                 surname  => $data->{'surname'},
107                 cardnumber => $data->{'cardnumber'},
108                 categorycode => $data->{'categorycode'},
109                 category_type => $data->{'category_type'},
110                 categoryname  => $data->{'description'},
111                 address => $data->{'address'},
112                 address2 => $data->{'address2'},
113                 city => $data->{'city'},
114                 zipcode => $data->{'zipcode'},
115                 country => $data->{'country'},
116                 phone => $data->{'phone'},
117                 email => $data->{'email'},
118                 branchcode => $data->{'branchcode'},
119                 branchname => GetBranchName($data->{'branchcode'}),
120                 is_child        => ($data->{'category_type'} eq 'C'),
121     );
122     output_html_with_http_headers $input, $cookie, $template->output;
123 }