Bug 20568: (QA follow-up) Get rid of the id column
[koha.git] / members / paycollect.pl
1 #!/usr/bin/perl
2 # Copyright 2009,2010 PTFS Inc.
3 # Copyright 2011 PTFS-Europe Ltd
4 #
5 # This file is part of Koha.
6 #
7 # Koha is free software; you can redistribute it and/or modify it
8 # under the terms of the GNU General Public License as published by
9 # the Free Software Foundation; either version 3 of the License, or
10 # (at your option) any later version.
11 #
12 # Koha is distributed in the hope that it will be useful, but
13 # WITHOUT ANY WARRANTY; without even the implied warranty of
14 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 # GNU General Public License for more details.
16 #
17 # You should have received a copy of the GNU General Public License
18 # along with Koha; if not, see <http://www.gnu.org/licenses>.
19
20 use Modern::Perl;
21 use URI::Escape;
22 use CGI qw ( -utf8 );
23
24 use C4::Context;
25 use C4::Auth;
26 use C4::Output;
27 use C4::Members;
28 use C4::Members::Attributes qw(GetBorrowerAttributes);
29 use C4::Accounts;
30 use C4::Koha;
31
32 use Koha::Patrons;
33 use Koha::Patron::Categories;
34 use Koha::AuthorisedValues;
35 use Koha::Account;
36 use Koha::Token;
37
38 my $input = CGI->new();
39
40 my $updatecharges_permissions = $input->param('writeoff_individual') ? 'writeoff' : 'remaining_permissions';
41 my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
42     {   template_name   => 'members/paycollect.tt',
43         query           => $input,
44         type            => 'intranet',
45         authnotrequired => 0,
46         flagsrequired   => { borrowers => 'edit_borrowers', updatecharges => $updatecharges_permissions },
47         debug           => 1,
48     }
49 );
50
51 # get borrower details
52 my $borrowernumber = $input->param('borrowernumber');
53 my $logged_in_user = Koha::Patrons->find( $loggedinuser ) or die "Not logged in";
54 my $patron         = Koha::Patrons->find( $borrowernumber );
55 output_and_exit_if_error( $input, $cookie, $template, { module => 'members', logged_in_user => $logged_in_user, current_patron => $patron } );
56
57 my $borrower       = $patron->unblessed;
58 my $category       = $patron->category;
59 my $user           = $input->remote_user;
60
61 my $branch         = C4::Context->userenv->{'branch'};
62
63 my $total_due = $patron->account->balance;
64 my $total_paid = $input->param('paid');
65
66 my $individual   = $input->param('pay_individual');
67 my $writeoff     = $input->param('writeoff_individual');
68 my $select_lines = $input->param('selected');
69 my $select       = $input->param('selected_accts');
70 my $payment_note = uri_unescape scalar $input->param('payment_note');
71 my $payment_type = scalar $input->param('payment_type');
72 my $accountlines_id;
73
74 if ( $individual || $writeoff ) {
75     if ($individual) {
76         $template->param( pay_individual => 1 );
77     } elsif ($writeoff) {
78         $template->param( writeoff_individual => 1 );
79     }
80     my $accounttype       = $input->param('accounttype');
81     $accountlines_id       = $input->param('accountlines_id');
82     my $amount            = $input->param('amount');
83     my $amountoutstanding = $input->param('amountoutstanding');
84     my $itemnumber  = $input->param('itemnumber');
85     my $description  = $input->param('description');
86     my $title        = $input->param('title');
87     $total_due = $amountoutstanding;
88     $template->param(
89         accounttype       => $accounttype,
90         accountlines_id    => $accountlines_id,
91         amount            => $amount,
92         amountoutstanding => $amountoutstanding,
93         title             => $title,
94         itemnumber        => $itemnumber,
95         individual_description => $description,
96         payment_note    => $payment_note,
97     );
98 } elsif ($select_lines) {
99     $total_due = $input->param('amt');
100     $template->param(
101         selected_accts => $select_lines,
102         amt            => $total_due,
103         selected_accts_notes => scalar $input->param('notes'),
104     );
105 }
106
107 if ( $total_paid and $total_paid ne '0.00' ) {
108     if ( $total_paid < 0 or $total_paid > $total_due ) {
109         $template->param(
110             error_over => 1,
111             total_due => $total_due
112         );
113     } else {
114         die "Wrong CSRF token"
115             unless Koha::Token->new->check_csrf( {
116                 session_id => $input->cookie('CGISESSID'),
117                 token  => scalar $input->param('csrf_token'),
118             });
119
120         if ($individual) {
121             my $line = Koha::Account::Lines->find($accountlines_id);
122             Koha::Account->new( { patron_id => $borrowernumber } )->pay(
123                 {
124                     lines        => [$line],
125                     amount       => $total_paid,
126                     library_id   => $branch,
127                     note         => $payment_note,
128                     payment_type => $payment_type,
129                 }
130             );
131             print $input->redirect(
132                 "/cgi-bin/koha/members/pay.pl?borrowernumber=$borrowernumber");
133         } else {
134             if ($select) {
135                 if ( $select =~ /^([\d,]*).*/ ) {
136                     $select = $1;    # ensure passing no junk
137                 }
138                 my @acc = split /,/, $select;
139                 my $note = $input->param('selected_accts_notes');
140
141                 my @lines = Koha::Account::Lines->search(
142                     {
143                         borrowernumber    => $borrowernumber,
144                         amountoutstanding => { '<>' => 0 },
145                         accountlines_id   => { 'IN' => \@acc },
146                     },
147                     { order_by => 'date' }
148                 );
149
150                 Koha::Account->new(
151                     {
152                         patron_id => $borrowernumber,
153                     }
154                   )->pay(
155                     {
156                         amount       => $total_paid,
157                         lines        => \@lines,
158                         note         => $note,
159                         payment_type => $payment_type,
160                     }
161                   );
162             }
163             else {
164                 my $note = $input->param('selected_accts_notes');
165                 Koha::Account->new( { patron_id => $borrowernumber } )->pay(
166                     {
167                         amount       => $total_paid,
168                         note         => $note,
169                         payment_type => $payment_type,
170                     }
171                 );
172             }
173
174             print $input->redirect("/cgi-bin/koha/members/boraccount.pl?borrowernumber=$borrowernumber");
175         }
176     }
177 } else {
178     $total_paid = '0.00';    #TODO not right with pay_individual
179 }
180
181 borrower_add_additional_fields($borrower, $template);
182
183 $template->param(%$borrower);
184
185 $template->param(
186     borrowernumber => $borrowernumber,    # some templates require global
187     patron        => $patron,
188     total         => $total_due,
189     ExtendedPatronAttributes => C4::Context->preference('ExtendedPatronAttributes'),
190
191     csrf_token => Koha::Token->new->generate_csrf({ session_id => scalar $input->cookie('CGISESSID') }),
192 );
193
194 output_html_with_http_headers $input, $cookie, $template->output;
195
196 sub borrower_add_additional_fields {
197     my ( $b_ref, $template ) = @_;
198
199 # some borrower info is not returned in the standard call despite being assumed
200 # in a number of templates. It should not be the business of this script but in lieu of
201 # a revised api here it is ...
202     if ( $b_ref->{category_type} eq 'C' ) {
203         my $patron_categories = Koha::Patron::Categories->search_limited({ category_type => 'A' }, {order_by => ['categorycode']});
204         $template->param( 'CATCODE_MULTI' => 1) if $patron_categories->count > 1;
205         $template->param( 'catcode' => $patron_categories->next->categorycode )  if $patron_categories->count == 1;
206     }
207
208     if (C4::Context->preference('ExtendedPatronAttributes')) {
209         $b_ref->{extendedattributes} = GetBorrowerAttributes($b_ref->{borrowernumber});
210     }
211
212     return;
213 }