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