Bug 24488: perf - Group by at DBMS level

[srvgit] / opac / opac-account.pl

diff --git a/opac/opac-account.pl b/opac/opac-account.pl
index d5677fc..8442281 100755 (executable)
--- a/opac/opac-account.pl
+++ b/opac/opac-account.pl
@@ -28,13 +28,12 @@ use Koha::Account::Lines;
 use Koha::Patrons;
 use Koha::Plugins;
 
-my $query = new CGI;
+my $query = CGI->new;
 my ( $template, $borrowernumber, $cookie ) = get_template_and_user(
     {
         template_name   => "opac-account.tt",
         query           => $query,
         type            => "opac",
-        authnotrequired => 0,
         debug           => 1,
     }
 );
@@ -45,6 +44,34 @@ my $accountlines = $account->lines->search({ amountoutstanding => { '>=' => 0 }}
 my $total_outstanding = $accountlines->total_outstanding;
 my $outstanding_credits = $account->outstanding_credits;
 
+if ( C4::Context->preference('AllowPatronToSetFinesVisibilityForGuarantor')
+    || C4::Context->preference('AllowStaffToSetFinesVisibilityForGuarantor')
+  )
+{
+    my @relatives;
+
+    # Filter out guarantees that don't want guarantor to see checkouts
+    foreach my $gr ( $patron->guarantee_relationships() ) {
+        my $g = $gr->guarantee;
+        if ( $g->privacy_guarantor_fines ) {
+
+            my $relatives_accountlines = Koha::Account::Lines->search(
+                { borrowernumber => $g->borrowernumber },
+                { order_by       => { -desc => 'accountlines_id' } }
+            );
+            push(
+                @relatives,
+                {
+                    patron       => $g,
+                    accountlines => $relatives_accountlines,
+                }
+            );
+        }
+    }
+    $template->param( relatives => \@relatives );
+}
+
+
 $template->param(
     ACCOUNT_LINES       => $accountlines,
     total               => $total_outstanding,
@@ -56,8 +83,7 @@ $template->param(
     payment_error       => scalar $query->param('payment-error') || q{},
 );
 
-my $plugins_enabled = C4::Context->preference('UseKohaPlugins') && C4::Context->config("enable_plugins");
-if ( $plugins_enabled ) {
+if ( C4::Context->config("enable_plugins") ) {
     my @plugins = Koha::Plugins->new()->GetPlugins({
         method => 'opac_online_payment',
     });