Bug 35579: Cache authorised value lookup by MARC field
[koha.git] / pos / register.pl
1 #!/usr/bin/perl
2
3 # Copyright 2020 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 CGI;
22 use C4::Auth qw( get_template_and_user );
23 use C4::Output qw( output_html_with_http_headers );
24 use C4::Context;
25
26 use Koha::Account::Lines;
27 use Koha::Cash::Registers;
28 use Koha::Database;
29 use Koha::DateUtils qw( dt_from_string );
30
31 my $input = CGI->new();
32
33 my ( $template, $loggedinuser, $cookie, $user_flags ) = get_template_and_user(
34     {
35         template_name   => 'pos/register.tt',
36         query           => $input,
37         type            => 'intranet',
38         authnotrequired => 0,
39         flagsrequired   => { cash_management => [ 'cashup', 'anonymous_refund' ] },
40     }
41 );
42 my $logged_in_user = Koha::Patrons->find($loggedinuser) or die "Not logged in";
43 my $schema = Koha::Database->new->schema;
44
45 my $library_id = C4::Context->userenv->{'branch'};
46 my $registerid = $input->param('registerid') // C4::Context->userenv->{'register_id'};
47 my $registers  = Koha::Cash::Registers->search(
48     { branch   => $library_id, archived => 0 },
49     { order_by => { '-asc' => 'name' } }
50 );
51
52 if ( !$registers->count ) {
53     $template->param( error_registers => 1 );
54 }
55 else {
56     if ( !$registerid ) {
57         my $default_register = Koha::Cash::Registers->find(
58             { branch => $library_id, branch_default => 1 } );
59         $registerid = $default_register->id if $default_register;
60     }
61     $registerid = $registers->next->id if !$registerid;
62
63     $template->param(
64         registerid => $registerid,
65         registers  => $registers,
66     );
67
68     my $cash_register = Koha::Cash::Registers->find( { id => $registerid } );
69     my $accountlines = $cash_register->outstanding_accountlines();
70     $template->param(
71         register     => $cash_register,
72         accountlines => $accountlines
73     );
74
75     my $transactions_range_from = $input->param('trange_f');
76     my $last_cashup             = $cash_register->last_cashup;
77     my $transactions_range_to =
78         $input->param('trange_t') ? $input->param('trange_t')
79       : $last_cashup              ? $last_cashup->timestamp
80       :                             '';
81     my $end = dt_from_string($transactions_range_to);
82     $end = $end->set( { hour => 23, minute => 59, second => 59 } );    # To should be 'inclusive'
83
84     if ($transactions_range_from) {
85
86         my $dtf               = $schema->storage->datetime_parser;
87         my $start             = dt_from_string($transactions_range_from);
88         my $past_accountlines = Koha::Account::Lines->search(
89             {
90                 register_id => $registerid,
91                 timestamp   => {
92                     -between => [
93                         $dtf->format_datetime($start),
94                         $dtf->format_datetime($end)
95                     ]
96                 }
97             }
98         );
99         $template->param(
100             past_accountlines => $past_accountlines,
101             trange_f          => $start,
102         );
103     }
104     $template->param( trange_t => $end, );
105
106     my $op = $input->param('op') // '';
107     if ( $op eq 'cashup' ) {
108         if ( $logged_in_user->has_permission( { cash_management => 'cashup' } ) ) {
109             $cash_register->add_cashup(
110                 {
111                     manager_id => $logged_in_user->id,
112                     amount     => $cash_register->outstanding_accountlines->total
113                 }
114             );
115         }
116         else {
117             $template->param( error_cashup_permission => 1 );
118         }
119     }
120     elsif ( $op eq 'refund' ) {
121         if ( $logged_in_user->has_permission( { cash_management => 'anonymous_refund' } ) ) {
122             my $amount           = $input->param('amount');
123             my $quantity         = $input->param('quantity');
124             my $accountline_id   = $input->param('accountline');
125             my $refund_type      = $input->param('refund_type');
126
127             my $accountline = Koha::Account::Lines->find($accountline_id);
128             $schema->txn_do(
129                 sub {
130
131                     my $refund = $accountline->reduce(
132                         {
133                             reduction_type => 'REFUND',
134                             branch         => $library_id,
135                             staff_id       => $logged_in_user->id,
136                             interface      => 'intranet',
137                             amount         => $amount
138                         }
139                     );
140                     my $payout = $refund->payout(
141                         {
142                             payout_type   => $refund_type,
143                             branch        => $library_id,
144                             staff_id      => $logged_in_user->id,
145                             cash_register => $cash_register->id,
146                             interface     => 'intranet',
147                             amount        => $amount
148                         }
149                     );
150
151                 }
152             );
153         }
154         else {
155             $template->param( error_refund_permission => 1 );
156         }
157     }
158 }
159
160 output_html_with_http_headers( $input, $cookie, $template->output );