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