From 286b1935663ef3071ad6a0aae3078ad3a42b48e4 Mon Sep 17 00:00:00 2001
From: Frédéric Guillot <fred@kanboard.net>
Date: Tue, 14 Oct 2014 22:02:35 -0400
Subject: Add a dashboard (first version)

---
 app/Model/TaskFinder.php | 27 +++++++++++++++++++++++++++
 1 file changed, 27 insertions(+)

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

diff --git a/app/Model/TaskFinder.php b/app/Model/TaskFinder.php
index 5bf8c139..56795152 100644
--- a/app/Model/TaskFinder.php
+++ b/app/Model/TaskFinder.php
@@ -111,6 +111,33 @@ class TaskFinder extends Base
                     ->findAll();
     }
 
+    /**
+     * Get all open tasks for a given user
+     *
+     * @access public
+     * @param  integer    $user_id    User id
+     * @return array
+     */
+    public function getAllTasksByUser($user_id)
+    {
+        return $this->db
+                    ->table(Task::TABLE)
+                    ->columns(
+                        'tasks.id',
+                        'tasks.title',
+                        'tasks.date_due',
+                        'tasks.date_creation',
+                        'tasks.project_id',
+                        'tasks.color_id',
+                        'projects.name AS project_name'
+                    )
+                    ->join(Project::TABLE, 'id', 'project_id')
+                    ->eq('tasks.owner_id', $user_id)
+                    ->eq('tasks.is_active', Task::STATUS_OPEN)
+                    ->asc('tasks.id')
+                    ->findAll();
+    }
+
     /**
      * Get all tasks for a given project and status
      *
-- 
cgit v1.2.3