From f7e4c3928aba9cb7f5222cb4af67846312bbb435 Mon Sep 17 00:00:00 2001
From: Frederic Guillot <fred@kanboard.net>
Date: Sat, 14 Feb 2015 16:11:13 -0500
Subject: Refactoring/simplification of the pull-request about links

---
 app/Model/TaskFilter.php | 32 ++++++++++++++++++++++++++++++++
 1 file changed, 32 insertions(+)

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

diff --git a/app/Model/TaskFilter.php b/app/Model/TaskFilter.php
index b5a90154..31de2795 100644
--- a/app/Model/TaskFilter.php
+++ b/app/Model/TaskFilter.php
@@ -18,6 +18,24 @@ class TaskFilter extends Base
         return $this;
     }
 
+    public function excludeTasks(array $task_ids)
+    {
+        $this->query->notin('id', $task_ids);
+        return $this;
+    }
+
+    public function filterByTitle($title)
+    {
+        $this->query->ilike('title', '%'.$title.'%');
+        return $this;
+    }
+
+    public function filterByProjects(array $project_ids)
+    {
+        $this->query->in('project_id', $project_ids);
+        return $this;
+    }
+
     public function filterByProject($project_id)
     {
         if ($project_id > 0) {
@@ -94,6 +112,20 @@ class TaskFilter extends Base
         return $this->query->findAll();
     }
 
+    public function toAutoCompletion()
+    {
+        return $this->query->columns('id', 'title')->filter(function(array $results) {
+
+            foreach ($results as &$result) {
+                $result['value'] = $result['title'];
+                $result['label'] = '#'.$result['id'].' - '.$result['title'];
+            }
+
+            return $results;
+
+        })->findAll();
+    }
+
     public function toCalendarEvents()
     {
         $events = array();
-- 
cgit v1.2.3