adding the User collection and linking it to the Group model

2 files changed, 35 insertions, 0 deletions

diff --git a/src/Psecio/Gatekeeper/GroupModel.php b/src/Psecio/Gatekeeper/GroupModel.php
index 137f00c..69d37d8 100644
--- a/src/Psecio/Gatekeeper/GroupModel.php
+++ b/src/Psecio/Gatekeeper/GroupModel.php
@@ -34,6 +34,15 @@ class GroupModel extends \Psecio\Gatekeeper\Model\Mysql
             'description' => 'Date Updated',
             'column' => 'updated',
             'type' => 'datetime'
+        ),
+        'users' => array(
+            'description' => 'Users belonging to this group',
+            'type' => 'relation',
+            'relation' => array(
+                'model' => '\\Psecio\\Gatekeeper\\UserCollection',
+                'method' => 'findByGroupId',
+                'local' => 'id'
+            )
         )
     );
 
diff --git a/src/Psecio/Gatekeeper/UserCollection.php b/src/Psecio/Gatekeeper/UserCollection.php
new file mode 100644
index 0000000..74c2488
--- /dev/null
+++ b/src/Psecio/Gatekeeper/UserCollection.php
@@ -0,0 +1,26 @@
+<?php
+
+namespace Psecio\Gatekeeper;
+
+class UserCollection extends \Psecio\Gatekeeper\Collection\Mysql
+{
+    /**
+     * Find the users belonging to the given group
+     *
+     * @param integer $group Group ID
+     */
+    public function findByGroupId($groupId)
+    {
+        $data = array('groupId' => $groupId);
+        $sql = 'select u.* from users u, user_group ug'
+            .' where ug.group_id = :groupId'
+            .' and ug.user_id = u.id';
+
+        $results = $this->fetch($sql, $data);
+
+        foreach ($results as $result) {
+            $user = new UserModel($this->getDb(), $result);
+            $this->add($user);
+        }
+    }
+}
\ No newline at end of file