adding permission collection

1 files changed, 21 insertions, 0 deletions

diff --git a/src/Psecio/Gatekeeper/PermissionCollection.php b/src/Psecio/Gatekeeper/PermissionCollection.php
new file mode 100644
index 0000000..414e670
--- /dev/null
+++ b/src/Psecio/Gatekeeper/PermissionCollection.php
@@ -0,0 +1,21 @@
+<?php
+
+namespace Psecio\Gatekeeper;
+
+class PermissionCollection extends \Psecio\Gatekeeper\Collection\Mysql
+{
+	public function findByUserId($userId)
+	{
+		$data = array('userId' => $userId);
+		$sql = 'select p.* from permissions p, user_permission up'
+			.' where p.id = up.permission_id'
+			.' and up.userId = :userId';
+
+		$results = $this->fetch($sql, $data);
+
+        foreach ($results as $result) {
+            $perm = new PermissionModel($this->getDb(), $result);
+            $this->add($perm);
+        }
+	}
+}
\ No newline at end of file