adding method to get the groups a permission belongs to

1 files changed, 21 insertions, 0 deletions

diff --git a/src/Psecio/Gatekeeper/GroupCollection.php b/src/Psecio/Gatekeeper/GroupCollection.php
index 13c7808..90e8b07 100644
--- a/src/Psecio/Gatekeeper/GroupCollection.php
+++ b/src/Psecio/Gatekeeper/GroupCollection.php
@@ -24,4 +24,25 @@ class GroupCollection extends \Psecio\Gatekeeper\Collection\Mysql
             $this->add($group);
         }
     }
+
+    /**
+     * Find the groups that a permission belongs to
+     *
+     * @param integer $permId Permission ID
+     */
+    public function findGroupsByPermissionId($permId)
+    {
+        $prefix = $this->getPrefix();
+        $data = array('permId' => $permId);
+        $sql = 'select g.* from '.$prefix.'groups g, '.$prefix.'group_permission gp'
+            .' where gp.permission_id = :permId'
+            .' and gp.group_id = g.id';
+
+        $results = $this->getDb()->fetch($sql, $data);
+
+        foreach ($results as $result) {
+            $group = new GroupModel($this->getDb(), $result);
+            $this->add($group);
+        }
+    }
 }
\ No newline at end of file