1 files changed, 19 insertions, 2 deletions
diff --git a/app/Model/ProjectPermission.php b/app/Model/ProjectPermission.php
index 02f3b428..352677d9 100644
--- a/app/Model/ProjectPermission.php
+++ b/app/Model/ProjectPermission.php
@@ -315,10 +315,27 @@ class ProjectPermission extends Base
     public function getMemberProjects($user_id)
     {
         return $this->db
-                    ->table(Project::TABLE)
+                    ->hashtable(Project::TABLE)
+                    ->eq('user_id', $user_id)
+                    ->join(self::TABLE, 'project_id', 'id')
+                    ->getAll('projects.id', 'name');
+    }
+
+    /**
+     * Return a list of active projects where the user is member
+     *
+     * @access public
+     * @param  integer   $user_id      User id
+     * @return array
+     */
+    public function getActiveMemberProjects($user_id)
+    {
+        return $this->db
+                    ->hashtable(Project::TABLE)
                     ->eq('user_id', $user_id)
+                    ->eq(Project::TABLE.'.is_active', Project::ACTIVE)
                     ->join(self::TABLE, 'project_id', 'id')
-                    ->listing('projects.id', 'name');
+                    ->getAll('projects.id', 'name');
     }
 
     /**