adding findUsersByPermissionId to user model to get users with a given permission

2 files changed, 31 insertions, 0 deletions

diff --git a/src/Psecio/Gatekeeper/PermissionModel.php b/src/Psecio/Gatekeeper/PermissionModel.php
index 581e815..eccb355 100644
--- a/src/Psecio/Gatekeeper/PermissionModel.php
+++ b/src/Psecio/Gatekeeper/PermissionModel.php
@@ -63,6 +63,15 @@ class PermissionModel extends \Psecio\Gatekeeper\Model\Mysql
                 'local' => 'id'
             )
         ),
+        'users' => array(
+            'description' => 'Users that have the permission',
+            'type' => 'relation',
+            'relation' => array(
+                'model' => '\\Psecio\\Gatekeeper\\UserCollection',
+                'method' => 'findUsersByPermissionId',
+                'local' => 'id'
+            )
+        ),
         'children' => array(
             'description' => 'Child Permissions',
             'type' => 'relation',
diff --git a/src/Psecio/Gatekeeper/UserCollection.php b/src/Psecio/Gatekeeper/UserCollection.php
index 805ad52..ba9f9df 100644
--- a/src/Psecio/Gatekeeper/UserCollection.php
+++ b/src/Psecio/Gatekeeper/UserCollection.php
@@ -24,4 +24,26 @@ class UserCollection extends \Psecio\Gatekeeper\Collection\Mysql
             $this->add($user);
         }
     }
+
+    /**
+     * Find the users that have a permission defined by the
+     *     given ID
+     *
+     * @param integer $permId Permission ID
+     */
+    public function findUsersByPermissionId($permId)
+    {
+        $prefix = $this->getPrefix();
+        $data = array('permId' => $permId);
+        $sql = 'select u.* from '.$prefix.'users u, '.$prefix.'user_permission up'
+            .' where up.permission_id = :permId'
+            .' and up.user_id = u.id';
+
+        $results = $this->getDb()->fetch($sql, $data);
+
+        foreach ($results as $result) {
+            $user = new UserModel($this->getDb(), $result);
+            $this->add($user);
+        }
+    }
 }
\ No newline at end of file