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::Accounts;
  29 use C4::Koha;
  30
  31 use Koha::Cash::Registers;
  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 $payment_id          = $input->param('payment_id');
  41 my $writeoff_individual = $input->param('writeoff_individual');
  42 my $change_given        = $input->param('change_given');
  43 my $type                = scalar $input->param('type') || 'PAYMENT';
  44
  45 my $updatecharges_permissions = ($writeoff_individual || $type eq 'writeoff') ? 'writeoff' : 'remaining_permissions';
  46 my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
  47     {   template_name   => 'members/paycollect.tt',
  48         query           => $input,
  49         type            => 'intranet',
  50         authnotrequired => 0,
  51         flagsrequired   => { borrowers => 'edit_borrowers', updatecharges => $updatecharges_permissions },
  52         debug           => 1,
  53     }
  54 );
  55
  56 # get borrower details
  57 my $borrowernumber = $input->param('borrowernumber');
  58 my $logged_in_user = Koha::Patrons->find( $loggedinuser );
  59 my $patron         = Koha::Patrons->find( $borrowernumber );
  60 output_and_exit_if_error( $input, $cookie, $template, { module => 'members', logged_in_user => $logged_in_user, current_patron => $patron } );
  61
  62 my $borrower       = $patron->unblessed;
  63 my $account        = $patron->account;
  64 my $category       = $patron->category;
  65 my $user           = $input->remote_user;
  66
  67 my $library_id = C4::Context->userenv->{'branch'};
  68 my $total_due  = $account->outstanding_debits->total_outstanding;
  69
  70 my $total_paid      = $input->param('paid');
  71 my $total_collected = $input->param('collected');
  72
  73 my $selected_lines = $input->param('selected'); # comes from pay.pl
  74 my $pay_individual   = $input->param('pay_individual');
  75 my $selected_accts   = $input->param('selected_accts'); # comes from paycollect.pl
  76 my $payment_note = uri_unescape scalar $input->param('payment_note');
  77 my $payment_type = scalar $input->param('payment_type');
  78 my $accountlines_id;
  79
  80 my $registerid;
  81 if ( C4::Context->preference('UseCashRegisters') ) {
  82     $registerid = $input->param('registerid');
  83     my $registers  = Koha::Cash::Registers->search(
  84         { branch   => $library_id, archived => 0 },
  85         { order_by => { '-asc' => 'name' } }
  86     );
  87
  88     if ( !$registers->count ) {
  89         $template->param( error_registers => 1 );
  90     }
  91     else {
  92
  93         if ( !$registerid ) {
  94             my $default_register = Koha::Cash::Registers->find(
  95                 { branch => $library_id, branch_default => 1 } );
  96             $registerid = $default_register->id if $default_register;
  97         }
  98         $registerid = $registers->next->id if !$registerid;
  99
 100         $template->param(
 101             registerid => $registerid,
 102             registers  => $registers,
 103         );
 104     }
 105 }
 106
 107 if ( $pay_individual || $writeoff_individual ) {
 108     if ($pay_individual) {
 109         $template->param( pay_individual => 1 );
 110     } elsif ($writeoff_individual) {
 111         $template->param( writeoff_individual => 1 );
 112     }
 113     my $debit_type_code   = $input->param('debit_type_code');
 114     $accountlines_id      = $input->param('accountlines_id');
 115     my $amount            = $input->param('amount');
 116     my $amountoutstanding = $input->param('amountoutstanding');
 117     my $itemnumber  = $input->param('itemnumber');
 118     my $description  = $input->param('description');
 119     my $title        = $input->param('title');
 120     $total_due = $amountoutstanding;
 121     $template->param(
 122         debit_type_code    => $debit_type_code,
 123         accountlines_id    => $accountlines_id,
 124         amount            => $amount,
 125         amountoutstanding => $amountoutstanding,
 126         title             => $title,
 127         itemnumber        => $itemnumber,
 128         individual_description => $description,
 129         payment_note    => $payment_note,
 130     );
 131 } elsif ($selected_lines) {
 132     $total_due = $input->param('amt');
 133     $template->param(
 134         selected_accts => $selected_lines,
 135         amt            => $total_due,
 136         selected_accts_notes => scalar $input->param('notes'),
 137     );
 138 }
 139
 140 my @selected_accountlines;
 141 if ( $selected_accts ) {
 142     if ( $selected_accts =~ /^([\d,]*).*/ ) {
 143         $selected_accts = $1;    # ensure passing no junk
 144     }
 145     my @acc = split /,/, $selected_accts;
 146
 147     @selected_accountlines = Koha::Account::Lines->search(
 148         {
 149             borrowernumber    => $borrowernumber,
 150             amountoutstanding => { '<>' => 0 },
 151             accountlines_id   => { 'in' => \@acc },
 152         },
 153         { order_by => 'date' }
 154     );
 155
 156     $total_due = 0; # Reset and recalculate total due
 157     map { $total_due += $_->amountoutstanding } @selected_accountlines;
 158 }
 159
 160
 161 if ( $total_paid and $total_paid ne '0.00' ) {
 162     $total_paid = $total_due if (abs($total_paid - $total_due) < 0.01) && C4::Context->preference('RoundFinesAtPayment');
 163     if ( $total_paid < 0 or $total_paid > $total_due ) {
 164         $template->param(
 165             error_over => 1,
 166             total_due => $total_due
 167         );
 168     } elsif ( $total_collected < $total_paid && !( $writeoff_individual || $type eq 'writeoff') ) {
 169         $template->param(
 170             error_under => 1,
 171             total_paid => $total_paid
 172         );
 173     } else {
 174         output_and_exit( $input, $cookie, $template,  'wrong_csrf_token' )
 175             unless Koha::Token->new->check_csrf( {
 176                 session_id => $input->cookie('CGISESSID'),
 177                 token  => scalar $input->param('csrf_token'),
 178             });
 179
 180         if ($pay_individual) {
 181             my $line = Koha::Account::Lines->find($accountlines_id);
 182             $payment_id = $account->pay(
 183                 {
 184                     lines        => [$line],
 185                     amount       => $total_paid,
 186                     library_id   => $library_id,
 187                     note         => $payment_note,
 188                     interface    => C4::Context->interface,
 189                     payment_type => $payment_type,
 190                     cash_register => $registerid
 191                 }
 192             );
 193             print $input->redirect(
 194                 "/cgi-bin/koha/members/pay.pl?borrowernumber=$borrowernumber&payment_id=$payment_id&change_given=$change_given");
 195         } else {
 196             if ($selected_accts) {
 197                 if ( $total_paid > $total_due ) {
 198                     $template->param(
 199                         error_over => 1,
 200                         total_due => $total_due
 201                     );
 202                 } else {
 203                     my $note = $input->param('selected_accts_notes');
 204
 205                     $payment_id = $account->pay(
 206                         {
 207                             type         => $type,
 208                             amount       => $total_paid,
 209                             library_id   => $library_id,
 210                             lines        => \@selected_accountlines,
 211                             note         => $note,
 212                             interface    => C4::Context->interface,
 213                             payment_type => $payment_type,
 214                             cash_register => $registerid
 215                         }
 216                       );
 217                 }
 218             }
 219             else {
 220                 my $note = $input->param('selected_accts_notes');
 221                 $payment_id = $account->pay(
 222                     {
 223                         amount       => $total_paid,
 224                         library_id   => $library_id,
 225                         note         => $note,
 226                         payment_type => $payment_type,
 227                         interface    => C4::Context->interface,
 228                         payment_type => $payment_type,
 229                         cash_register => $registerid
 230                     }
 231                 );
 232             }
 233
 234             print $input->redirect("/cgi-bin/koha/members/boraccount.pl?borrowernumber=$borrowernumber&payment_id=$payment_id&change_given=$change_given");
 235         }
 236     }
 237 } else {
 238     $total_paid = '0.00';    #TODO not right with pay_individual
 239 }
 240
 241 $template->param(%$borrower);
 242
 243 if ( $input->param('error_over') ) {
 244     $template->param( error_over => 1, total_due => scalar $input->param('amountoutstanding') );
 245 }
 246
 247 $template->param(
 248     payment_id => $payment_id,
 249
 250     type           => $type,
 251     borrowernumber => $borrowernumber,    # some templates require global
 252     patron         => $patron,
 253     total          => $total_due,
 254
 255     csrf_token => Koha::Token->new->generate_csrf( { session_id => scalar $input->cookie('CGISESSID') } ),
 256 );
 257
 258 output_html_with_http_headers $input, $cookie, $template->output;