Bug 25184: (RM follow-up) Make DB update idempotent
[koha.git] / members / printinvoice.pl
blob38950e364792e50b08f082f3208b938d8dd802f1
1 #!/usr/bin/perl
3 #written 3rd May 2010 by kmkale@anantcorp.com adapted from boraccount.pl by chris@katipo.oc.nz
4 #script to print fee receipts
6 # Copyright Koustubha Kale
8 # This file is part of Koha.
10 # Koha is free software; you can redistribute it and/or modify it
11 # under the terms of the GNU General Public License as published by
12 # the Free Software Foundation; either version 3 of the License, or
13 # (at your option) any later version.
15 # Koha is distributed in the hope that it will be useful, but
16 # WITHOUT ANY WARRANTY; without even the implied warranty of
17 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
18 # GNU General Public License for more details.
20 # You should have received a copy of the GNU General Public License
21 # along with Koha; if not, see <http://www.gnu.org/licenses>.
23 use Modern::Perl;
25 use C4::Auth;
26 use C4::Output;
27 use Koha::DateUtils;
28 use CGI qw ( -utf8 );
29 use C4::Members;
30 use C4::Accounts;
32 use Koha::Account::Lines;
33 use Koha::Patrons;
34 use Koha::Patron::Categories;
36 my $input = new CGI;
38 my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
39 { template_name => "members/printinvoice.tt",
40 query => $input,
41 type => "intranet",
42 authnotrequired => 0,
43 flagsrequired => { borrowers => 'edit_borrowers', updatecharges => 'remaining_permissions' },
44 debug => 1,
48 my $borrowernumber = $input->param('borrowernumber');
49 my $action = $input->param('action') || '';
50 my $accountlines_id = $input->param('accountlines_id');
52 my $logged_in_user = Koha::Patrons->find( $loggedinuser );
53 my $patron = Koha::Patrons->find( $borrowernumber );
54 output_and_exit_if_error( $input, $cookie, $template, { module => 'members', logged_in_user => $logged_in_user, current_patron => $patron } );
56 #get account details
57 my $total = $patron->account->balance;
58 my $accountline_object = Koha::Account::Lines->find($accountlines_id);
59 my $accountline = $accountline_object->unblessed;
61 my $totalcredit;
62 if ( $total <= 0 ) {
63 $totalcredit = 1;
67 $accountline->{'amount'} += 0.00;
68 if ( $accountline->{'amount'} <= 0 ) {
69 $accountline->{'amountcredit'} = 1;
70 $accountline->{'amount'} *= -1.00;
72 $accountline->{'amountoutstanding'} += 0.00;
73 if ( $accountline->{'amountoutstanding'} <= 0 ) {
74 $accountline->{'amountoutstandingcredit'} = 1;
77 my @account_offsets = Koha::Account::Offsets->search( { debit_id => $accountline_object->id } );
79 my $letter = C4::Letters::getletter( 'circulation', 'ACCOUNT_DEBIT', C4::Context::mybranch, 'print', $patron->lang );
81 $template->param(
82 letter => $letter,
83 patron => $patron,
84 library => C4::Context::mybranch,
85 offsets => \@account_offsets,
86 debit => $accountline_object,
88 finesview => 1,
89 total => sprintf( "%.2f", $total ),
90 totalcredit => $totalcredit,
91 accounts => [$accountline], # FIXME There is always only 1 row!
94 output_html_with_http_headers $input, $cookie, $template->output;