From a43f71dda953ab1ca130af875b221569e4767f05 Mon Sep 17 00:00:00 2001
From: Frederic Guillot <fred@kanboard.net>
Date: Sun, 19 Feb 2017 18:27:57 -0500
Subject: Redesign project list view

---
 app/Model/ProjectModel.php | 20 ++++++++++++++++++++
 1 file changed, 20 insertions(+)

(limited to 'app/Model/ProjectModel.php')

diff --git a/app/Model/ProjectModel.php b/app/Model/ProjectModel.php
index b88a8c8b..aa7c002d 100644
--- a/app/Model/ProjectModel.php
+++ b/app/Model/ProjectModel.php
@@ -317,6 +317,26 @@ class ProjectModel extends Base
                     ->callback(array($this, 'applyColumnStats'));
     }
 
+    /**
+     * Get query for list of project without column statistics
+     *
+     * @access public
+     * @param  array $projectIds
+     * @return \PicoDb\Table
+     */
+    public function getQueryByProjectIds(array $projectIds)
+    {
+        if (empty($projectIds)) {
+            return $this->db->table(ProjectModel::TABLE)->eq(ProjectModel::TABLE.'.id', 0);
+        }
+
+        return $this->db
+            ->table(ProjectModel::TABLE)
+            ->columns(self::TABLE.'.*', UserModel::TABLE.'.username AS owner_username', UserModel::TABLE.'.name AS owner_name')
+            ->join(UserModel::TABLE, 'id', 'owner_id')
+            ->in(self::TABLE.'.id', $projectIds);
+    }
+
     /**
      * Create a project
      *
-- 
cgit v1.2.3