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>.
26 use Try::Tiny qw( catch try );
27 use URI::Escape qw( uri_escape_utf8 );
29 use C4::Auth qw( get_template_and_user );
30 use C4::Output qw( output_and_exit_if_error output_and_exit output_html_with_http_headers );
40 use Koha::Old::Checkouts;
42 use Koha::Patron::Categories;
43 use Koha::Account::DebitTypes;
44 use Koha::AdditionalFields;
47 my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
49 template_name => "members/maninvoice.tt",
53 borrowers => 'edit_borrowers',
54 updatecharges => 'manual_invoice'
59 my $borrowernumber = $input->param('borrowernumber');
60 my $patron = Koha::Patrons->find($borrowernumber);
62 print $input->redirect(
63 "/cgi-bin/koha/circ/circulation.pl?borrowernumber=$borrowernumber");
67 my $logged_in_user = Koha::Patrons->find($loggedinuser);
68 output_and_exit_if_error(
73 logged_in_user => $logged_in_user,
74 current_patron => $patron
78 my $library_id = C4::Context->userenv->{'branch'};
79 my $desc = $input->param('desc');
80 my $amount = $input->param('amount');
81 my $note = $input->param('note');
82 my $debit_type = $input->param('type');
83 my $barcode = $input->param('barcode');
92 my $add = $input->param('add');
94 output_and_exit( $input, $cookie, $template, 'wrong_csrf_token' )
95 unless Koha::Token->new->check_csrf(
97 session_id => scalar $input->cookie('CGISESSID'),
98 token => scalar $input->param('csrf_token'),
102 # Note: If the logged in user is not allowed to see this patron an invoice can be forced
103 # Here we are trusting librarians not to hack the system
104 my $desc = $input->param('desc');
105 my $amount = $input->param('amount');
106 my $note = $input->param('note');
107 my $debit_type = $input->param('type');
109 # If barcode is passed, attempt to find the associated item
112 my $olditem; # FIXME: When items and deleted_items are merged, we can remove this
115 my $item = Koha::Items->find( { barcode => $barcode } );
117 $item_id = $item->itemnumber;
120 $item = Koha::Old::Items->search( { barcode => $barcode },
121 { order_by => { -desc => 'timestamp' }, rows => 1 } );
123 $item_id = $item->next->itemnumber;
127 $template->param( error => 'itemnumber' );
132 if ( ( $debit_type eq 'LOST' ) && $item_id ) {
133 my $checkouts = Koha::Checkouts->search(
135 itemnumber => $item_id,
136 borrowernumber => $borrowernumber
142 : Koha::Old::Checkouts->search(
144 itemnumber => $item_id,
145 borrowernumber => $borrowernumber
147 { order_by => { -desc => 'returndate' }, rows => 1 }
149 $issue_id = $checkout ? $checkout->issue_id : undef;
155 my $line = $patron->account->add_debit(
158 description => $desc,
160 user_id => $logged_in_user->borrowernumber,
161 interface => 'intranet',
162 library_id => $library_id,
164 ( $olditem ? () : ( item_id => $item_id ) ),
165 issue_id => $issue_id
169 my @additional_fields;
170 my $accountline_fields = Koha::AdditionalFields->search({ tablename => 'accountlines:debit' });
171 while ( my $field = $accountline_fields->next ) {
172 my $value = $input->param('additional_field_' . $field->id);
173 if (defined $value) {
174 push @additional_fields, {
180 if (@additional_fields) {
181 $line->set_additional_fields(\@additional_fields);
184 if ( C4::Context->preference('AccountAutoReconcile') ) {
185 $patron->account->reconcile_balance;
188 if ( $add eq 'save and pay' ) {
190 '/cgi-bin/koha/members/paycollect.pl?borrowernumber=%s&pay_individual=1&debit_type_code=%s&amount=%s&amountoutstanding=%s&description=%s&itemnumber=%s&accountlines_id=%s',
191 map { uri_escape_utf8($_) } (
193 $line->debit_type_code,
195 $line->amountoutstanding,
202 print $input->redirect($url);
205 print $input->redirect(
206 "/cgi-bin/koha/members/boraccount.pl?borrowernumber=$borrowernumber"
214 if ( ref($error) eq 'Koha::Exceptions::Object::FKConstraint' ) {
215 $template->param( error => $error->broken_fk );
218 $template->param( error => $error );
224 my $debit_types = Koha::Account::DebitTypes->search_with_library_limits(
225 { can_be_invoiced => 1, archived => 0 },
229 debit_types => $debit_types,
230 csrf_token => Koha::Token->new->generate_csrf(
231 { session_id => scalar $input->cookie('CGISESSID') }
235 available_additional_fields => [ Koha::AdditionalFields->search({ tablename => 'accountlines:debit' })->as_list ],
237 output_html_with_http_headers $input, $cookie, $template->output;