Bug 25184: (RM follow-up) Make DB update idempotent
[koha.git] / members / maninvoice.pl
blobc39a323cae31f7f44f19c690974bd92ffb8ca8f1
1 #!/usr/bin/perl
3 #written 11/1/2000 by chris@katipo.oc.nz
4 #script to display borrowers account details
6 # Copyright 2000-2002 Katipo Communications
7 # Copyright 2010 BibLibre
8 # Copyright 2019 PTFS Europe
10 # This file is part of Koha.
12 # Koha is free software; you can redistribute it and/or modify it
13 # under the terms of the GNU General Public License as published by
14 # the Free Software Foundation; either version 3 of the License, or
15 # (at your option) any later version.
17 # Koha is distributed in the hope that it will be useful, but
18 # WITHOUT ANY WARRANTY; without even the implied warranty of
19 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
20 # GNU General Public License for more details.
22 # You should have received a copy of the GNU General Public License
23 # along with Koha; if not, see <http://www.gnu.org/licenses>.
25 use Modern::Perl;
27 use C4::Auth;
28 use C4::Output;
29 use CGI qw ( -utf8 );
30 use C4::Members;
31 use C4::Accounts;
32 use C4::Items;
33 use Koha::Token;
35 use Koha::Items;
36 use Koha::Patrons;
38 use Koha::Patron::Categories;
39 use Koha::Account::DebitTypes;
41 my $input = new CGI;
42 my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
44 template_name => "members/maninvoice.tt",
45 query => $input,
46 type => "intranet",
47 authnotrequired => 0,
48 flagsrequired => {
49 borrowers => 'edit_borrowers',
50 updatecharges => 'remaining_permissions'
55 my $borrowernumber = $input->param('borrowernumber');
56 my $patron = Koha::Patrons->find($borrowernumber);
57 unless ($patron) {
58 print $input->redirect(
59 "/cgi-bin/koha/circ/circulation.pl?borrowernumber=$borrowernumber");
60 exit;
63 my $library_id = C4::Context->userenv->{'branch'};
65 my $add = $input->param('add');
66 if ($add) {
67 output_and_exit( $input, $cookie, $template, 'wrong_csrf_token' )
68 unless Koha::Token->new->check_csrf(
70 session_id => scalar $input->cookie('CGISESSID'),
71 token => scalar $input->param('csrf_token'),
75 # Note: If the logged in user is not allowed to see this patron an invoice can be forced
76 # Here we are trusting librarians not to hack the system
77 my $barcode = $input->param('barcode');
78 my $itemnum;
79 if ($barcode) {
80 my $item = Koha::Items->find( { barcode => $barcode } );
81 $itemnum = $item->itemnumber if $item;
83 my $desc = $input->param('desc');
84 my $amount = $input->param('amount');
85 my $type = $input->param('type');
86 my $note = $input->param('note');
87 my $error =
88 C4::Accounts::manualinvoice( $borrowernumber, $itemnum, $desc, $type,
89 $amount, $note );
90 if ($error) {
91 if ( $error =~ /FOREIGN KEY/ && $error =~ /itemnumber/ ) {
92 $template->param( 'ITEMNUMBER' => 1 );
94 $template->param(
95 csrf_token => Koha::Token->new->generate_csrf(
96 { session_id => scalar $input->cookie('CGISESSID') }
99 $template->param( 'ERROR' => $error );
100 output_html_with_http_headers $input, $cookie, $template->output;
102 else {
104 if ( C4::Context->preference('AccountAutoReconcile') ) {
105 $patron->account->reconcile_balance;
108 if ($add eq 'save and pay') {
109 print $input->redirect(
110 "/cgi-bin/koha/members/pay.pl?borrowernumber=$borrowernumber"
112 } else {
113 print $input->redirect(
114 "/cgi-bin/koha/members/boraccount.pl?borrowernumber=$borrowernumber"
118 exit;
121 else {
123 my $logged_in_user = Koha::Patrons->find($loggedinuser)
124 or die "Not logged in";
125 output_and_exit_if_error(
126 $input, $cookie,
127 $template,
129 module => 'members',
130 logged_in_user => $logged_in_user,
131 current_patron => $patron
135 my @debit_types = Koha::Account::DebitTypes->search_with_library_limits(
136 { can_be_invoiced => 1, archived => 0 },
137 {}, $library_id );
138 $template->param( debit_types => \@debit_types );
139 $template->param(
140 csrf_token => Koha::Token->new->generate_csrf(
141 { session_id => scalar $input->cookie('CGISESSID') }
143 patron => $patron,
144 finesview => 1,
146 output_html_with_http_headers $input, $cookie, $template->output;