From 72fef528ec477ca2774c1c8e1bc0c9aae3083f1f Mon Sep 17 00:00:00 2001
From: Johan Cwiklinski <johan@x-tnd.be>
Date: Sat, 16 Oct 2021 07:36:30 +0200
Subject: [PATCH] Fix transaction loading query

---
 galette/lib/Galette/Entity/Transaction.php | 9 +++++++--
 1 file changed, 7 insertions(+), 2 deletions(-)

diff --git a/galette/lib/Galette/Entity/Transaction.php b/galette/lib/Galette/Entity/Transaction.php
index 7f9fff60f..5f2eec303 100644
--- a/galette/lib/Galette/Entity/Transaction.php
+++ b/galette/lib/Galette/Entity/Transaction.php
@@ -152,8 +152,13 @@ class Transaction
     public function load($id)
     {
         try {
-            $select = $this->zdb->select(self::TABLE);
+            $select = $this->zdb->select(self::TABLE, 't');
             $select->where(self::PK . ' = ' . $id);
+            $select->join(
+                array('a' => PREFIX_DB . Adherent::TABLE),
+                't.' . Adherent::PK . '=a.' . Adherent::PK,
+                array()
+            );
 
             //restrict query on current member id if he's not admin nor staff member
             if (!$this->login->isAdmin() && !$this->login->isStaff() && !$this->login->isGroupManager()) {
@@ -164,7 +169,7 @@ class Transaction
                         ->equalTo('a.parent_id', $this->login->id)
                     ->unnest()
                     ->and
-                    ->equalTo('c.' . self::PK, $id)
+                    ->equalTo('t.' . self::PK, $id)
                 ;
             } else {
                 $select->where->equalTo(self::PK, $id);
-- 
2.39.2