Merge remote branch 'kc/new/bug_3072' 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     if(checkauth($input)) {
46         #  print $input->header;
47         my $barcode=$input->param('barcode');
48         my $itemnum = GetItemnumberFromBarcode($barcode) if $barcode;
49         my $desc=$input->param('desc');
50         my $amount=$input->param('amount');
51         my $type=$input->param('type');
52         my $note    = $input->param('note');
53         my $error   = manualinvoice( $borrowernumber, $itemnum, $desc, $type, $amount, $note );
54         if ($error) {
55             my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
56                 {   template_name   => "members/maninvoice.tmpl",
57                     query           => $input,
58                     type            => "intranet",
59                     authnotrequired => 0,
60                     flagsrequired   => { borrowers => 1 },
61                     debug           => 1,
62                 }
63             );
64             if ( $error =~ /FOREIGN KEY/ && $error =~ /itemnumber/ ) {
65                 $template->param( 'ITEMNUMBER' => 1 );
66             }
67             $template->param( 'ERROR' => $error );
68             output_html_with_http_headers $input, $cookie, $template->output;
69         } else {
70             print $input->redirect("/cgi-bin/koha/members/boraccount.pl?borrowernumber=$borrowernumber");
71             exit;
72         }
73     }
74 } else {
75
76         my ($template, $loggedinuser, $cookie)
77         = get_template_and_user({template_name => "members/maninvoice.tmpl",
78                                         query => $input,
79                                         type => "intranet",
80                                         authnotrequired => 0,
81                                         flagsrequired => {borrowers => 1, updatecharges => 1},
82                                         debug => 1,
83                                         });
84                                         
85   # get authorised values with type of MANUAL_INV
86   my @invoice_types;
87   my $dbh = C4::Context->dbh;
88   my $sth = $dbh->prepare('SELECT * FROM authorised_values WHERE category = "MANUAL_INV"');
89   $sth->execute();
90   while ( my $row = $sth->fetchrow_hashref() ) {
91     push @invoice_types, $row;
92   }
93   $template->param( invoice_types_loop => \@invoice_types );
94
95     if ( $data->{'category_type'} eq 'C') {
96         my  ( $catcodes, $labels ) =  GetborCatFromCatType( 'A', 'WHERE category_type = ?' );
97         my $cnt = scalar(@$catcodes);
98         $template->param( 'CATCODE_MULTI' => 1) if $cnt > 1;
99         $template->param( 'catcode' =>    $catcodes->[0])  if $cnt == 1;
100     }
101
102     $template->param( adultborrower => 1 ) if ( $data->{'category_type'} eq 'A' );
103     my ($picture, $dberror) = GetPatronImage($data->{'cardnumber'});
104     $template->param( picture => 1 ) if $picture;
105
106         $template->param(
107                 borrowernumber => $borrowernumber,
108                 firstname => $data->{'firstname'},
109                 surname  => $data->{'surname'},
110                 cardnumber => $data->{'cardnumber'},
111                 categorycode => $data->{'categorycode'},
112                 category_type => $data->{'category_type'},
113                 categoryname  => $data->{'description'},
114                 address => $data->{'address'},
115                 address2 => $data->{'address2'},
116                 city => $data->{'city'},
117                 state => $data->{'state'},
118                 zipcode => $data->{'zipcode'},
119                 country => $data->{'country'},
120                 phone => $data->{'phone'},
121                 email => $data->{'email'},
122                 branchcode => $data->{'branchcode'},
123                 branchname => GetBranchName($data->{'branchcode'}),
124                 is_child        => ($data->{'category_type'} eq 'C'),
125     );
126     output_html_with_http_headers $input, $cookie, $template->output;
127 }