Fix missing priorite_statut column in groups members/managers

diff --git a/galette/lib/Galette/Entity/Group.php b/galette/lib/Galette/Entity/Group.php
index dd4324fc52d7a6a5b38d5fbcb1ffe33cf6d928e9..b50d33b526a868acf90c7f1ed3fc1f6c447335ab 100644 (file)
--- a/galette/lib/Galette/Entity/Group.php
+++ b/galette/lib/Galette/Entity/Group.php
@@ -178,6 +178,11 @@ class Group
                 }
 
                 $select = $zdb->select(Adherent::TABLE, 'a');
+                $select->join(
+                    array('status' => PREFIX_DB . Status::TABLE),
+                    'a.' . Status::PK . '=status.' . Status::PK,
+                    array('priorite_statut')
+                );
                 $select->join(
                     array('g' => $join),
                     'g.' . Adherent::PK . '=a.' . Adherent::PK,

diff --git a/galette/lib/Galette/Repository/Groups.php b/galette/lib/Galette/Repository/Groups.php
index e9419a110e509943fe4c4034bf257acb65b3c9f0..52bc49a2a7049a12f3ba359cdc05bcc3454f74e5 100644 (file)
--- a/galette/lib/Galette/Repository/Groups.php
+++ b/galette/lib/Galette/Repository/Groups.php
@@ -37,6 +37,7 @@
 namespace Galette\Repository;
 
 use ArrayObject;
+use Galette\Entity\Status;
 use Throwable;
 use Analog\Analog;
 use Laminas\Db\Sql\Expression;
@@ -476,6 +477,10 @@ class Groups
         $select = $this->zdb->select(Adherent::TABLE, 'adh');
         $select->columns(
             [Adherent::PK]
+        )->join(
+            array('status' => PREFIX_DB . Status::TABLE),
+            'a.' . Status::PK . '=status.' . Status::PK,
+            array('priorite_statut')
         )->join(
             array('b' => PREFIX_DB . Group::GROUPSUSERS_TABLE),
             'adh.' . Adherent::PK . '=b.' . Adherent::PK,