From 4ae4d6132f104317e1cca3800fe036163d0108ad Mon Sep 17 00:00:00 2001
From: David Gustafsson <david.gustafsson@ub.gu.se>
Date: Mon, 10 Oct 2022 17:18:03 +0200
Subject: [PATCH] Bug 31735: Optimize OPAC checkouts view

---
 .../bootstrap/en/modules/opac-user.tt         |  2 +-
 opac/opac-renew.pl                            | 20 ++++++++++++-------
 2 files changed, 14 insertions(+), 8 deletions(-)

diff --git a/koha-tmpl/opac-tmpl/bootstrap/en/modules/opac-user.tt b/koha-tmpl/opac-tmpl/bootstrap/en/modules/opac-user.tt
index bfae9990aa..c9e5125b2e 100644
--- a/koha-tmpl/opac-tmpl/bootstrap/en/modules/opac-user.tt
+++ b/koha-tmpl/opac-tmpl/bootstrap/en/modules/opac-user.tt
@@ -405,7 +405,7 @@
                                                         [% IF ISSUE.renewed %]<span class="blabel label-success">Renewed!</span><br />[% END %]
                                                         [% IF ( ISSUE.status ) %]
                                                             [% IF ( canrenew ) %]
-                                                                <input type="checkbox" name="item" value="[% ISSUE.itemnumber | uri %]"/> <a href="/cgi-bin/koha/opac-renew.pl?from=opac_user&amp;item=[% ISSUE.itemnumber | uri %]&amp;borrowernumber=[% ISSUE.borrowernumber | uri %]">Renew</a>
+                                                                <input type="checkbox" name="issue" value="[% ISSUE.issue_id | uri %]"/> <a href="/cgi-bin/koha/opac-renew.pl?from=opac_user&amp;issue=[% ISSUE.issue_id | uri %]&amp;borrowernumber=[% ISSUE.borrowernumber | uri %]">Renew</a>
                                                             [% END %]
                                                             [% IF ISSUE.renewalfee > 0 %]
                                                                 <span class="renewalfee label label-warning">Fee for item type '[% ItemTypes.GetDescription( ISSUE.renewalitemtype) | html %]': [% ISSUE.renewalfee | $Price %]</span>
diff --git a/opac/opac-renew.pl b/opac/opac-renew.pl
index 9e8efa0c5e..cb7f253290 100755
--- a/opac/opac-renew.pl
+++ b/opac/opac-renew.pl
@@ -38,8 +38,8 @@ my ( $template, $borrowernumber, $cookie ) = get_template_and_user(
         query           => $query,
         type            => "opac",
 	}
-); 
-my @items = $query->multi_param('item');
+);
+my @issues = $query->multi_param('issue');
 
 my $opacrenew = C4::Context->preference("OpacRenewalAllowed");
 
@@ -55,13 +55,19 @@ if (   $patron->category->effective_BlockExpiredPatronOpacActions
 }
 else {
     my @renewed;
-    for my $itemnumber (@items) {
-        my $item = Koha::Items->find($itemnumber);
+    my $issues = Koha::Checkouts->search(
+        {
+            issue_id => { -in => @issues }
+        }, {
+            prefetch => 'item'
+        }
+    );
+    while( my $issue = $issues->next) {
         my ( $status, $error ) =
-          CanBookBeRenewed( $patron, $item->checkout ); #TODO: Pass issue numbers instead
+          CanBookBeRenewed( $patron, $issue );
         if ( $status == 1 && $opacrenew == 1 ) {
-            AddRenewal( $borrowernumber, $itemnumber, undef, undef, undef, undef, 0 );
-            push( @renewed, $itemnumber );
+            AddRenewal( $borrowernumber, $issue->itemnumber, undef, undef, undef, undef, 0 );
+            push( @renewed, $issue->itemnumber );
         }
         else {
             $errorstring .= $error . "|";
-- 
2.35.1