Revert "Bug 10606: Remove MySQLism in GetUpcomingDueIssues"
[koha.git] / opac / opac-renew.pl
blob3a64ccfc9846173cc245679cb6207698baf527d8
1 #!/usr/bin/perl
3 #written 18/1/2000 by chris@katipo.co.nz
4 # adapted for use in the hlt opac by finlay@katipo.co.nz 29/11/2002
5 # script to renew items from the web
6 # Parts Copyright 2010,2011 Catalyst IT
8 # This file is part of Koha.
10 # Koha is free software; you can redistribute it and/or modify it under the
11 # terms of the GNU General Public License as published by the Free Software
12 # Foundation; either version 2 of the License, or (at your option) any later
13 # version.
15 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
16 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
17 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
19 # You should have received a copy of the GNU General Public License along
20 # with Koha; if not, write to the Free Software Foundation, Inc.,
21 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
24 use strict;
25 use warnings;
27 use CGI qw ( -utf8 );
28 use C4::Circulation;
29 use C4::Auth;
30 use C4::Context;
31 use C4::Items;
32 use C4::Members;
33 use Date::Calc qw( Today Date_to_Days );
34 my $query = new CGI;
36 my ( $template, $borrowernumber, $cookie ) = get_template_and_user(
38 template_name => "opac-user.tt",
39 query => $query,
40 type => "opac",
41 authnotrequired => 0,
42 flagsrequired => { borrow => 1 },
43 debug => 1,
45 );
46 my @items = $query->param('item');
48 my $opacrenew = C4::Context->preference("OpacRenewalAllowed");
50 my $errorstring = q{};
51 my $renewed = q{};
53 my $member_details = GetMemberDetails($borrowernumber);
55 if ( $member_details->{'BlockExpiredPatronOpacActions'}
56 && $member_details->{'is_expired'} )
58 $errorstring = 'card_expired';
60 else {
61 my @renewed;
62 for my $itemnumber (@items) {
63 my ( $status, $error ) =
64 CanBookBeRenewed( $borrowernumber, $itemnumber );
65 if ( $status == 1 && $opacrenew == 1 ) {
66 my $renewalbranch = C4::Context->preference('OpacRenewalBranch');
67 my $branchcode;
68 if ( $renewalbranch eq 'itemhomebranch' ) {
69 my $item = GetItem($itemnumber);
70 $branchcode = $item->{'homebranch'};
72 elsif ( $renewalbranch eq 'patronhomebranch' ) {
73 my $borrower = GetMemberDetails($borrowernumber);
74 $branchcode = $borrower->{'branchcode'};
76 elsif ( $renewalbranch eq 'checkoutbranch' ) {
77 my $issue = GetOpenIssue($itemnumber);
78 $branchcode = $issue->{'branchcode'};
80 elsif ( $renewalbranch eq 'NULL' ) {
81 $branchcode = '';
83 else {
84 $branchcode = 'OPACRenew';
86 AddRenewal( $borrowernumber, $itemnumber, $branchcode );
87 push( @renewed, $itemnumber );
89 else {
90 $errorstring .= $error . "|";
93 $renewed = join( ':', @renewed );
96 print $query->redirect("/cgi-bin/koha/opac-user.pl?renew_error=$errorstring&renewed=$renewed");