Add suggest menu for task ID

2 files changed, 86 insertions, 5 deletions

diff --git a/app/Formatter/TaskAutoCompleteFormatter.php b/app/Formatter/TaskAutoCompleteFormatter.php
index 2d9f7341..3a4f1e1a 100644
--- a/app/Formatter/TaskAutoCompleteFormatter.php
+++ b/app/Formatter/TaskAutoCompleteFormatter.php
@@ -14,6 +14,20 @@ use Kanboard\Model\TaskModel;
  */
 class TaskAutoCompleteFormatter extends BaseFormatter implements FormatterInterface
 {
+    protected $limit = 25;
+
+    /**
+     * Limit number of results
+     *
+     * @param  $limit
+     * @return $this
+     */
+    public function withLimit($limit)
+    {
+        $this->limit = $limit;
+        return $this;
+    }
+
     /**
      * Apply formatter
      *
@@ -22,11 +36,15 @@ class TaskAutoCompleteFormatter extends BaseFormatter implements FormatterInterf
      */
     public function format()
     {
-        $tasks = $this->query->columns(
-            TaskModel::TABLE.'.id',
-            TaskModel::TABLE.'.title',
-            ProjectModel::TABLE.'.name AS project_name'
-        )->asc(TaskModel::TABLE.'.id')->findAll();
+        $tasks = $this->query
+            ->columns(
+                TaskModel::TABLE.'.id',
+                TaskModel::TABLE.'.title',
+                ProjectModel::TABLE.'.name AS project_name'
+            )
+            ->asc(TaskModel::TABLE.'.id')
+            ->limit($this->limit)
+            ->findAll();
 
         foreach ($tasks as &$task) {
             $task['value'] = $task['title'];
diff --git a/app/Formatter/TaskSuggestMenuFormatter.php b/app/Formatter/TaskSuggestMenuFormatter.php
new file mode 100644
index 00000000..518f99e6
--- /dev/null
+++ b/app/Formatter/TaskSuggestMenuFormatter.php
@@ -0,0 +1,63 @@
+<?php
+
+namespace Kanboard\Formatter;
+
+use Kanboard\Core\Filter\FormatterInterface;
+use Kanboard\Model\ProjectModel;
+use Kanboard\Model\TaskModel;
+
+/**
+ * Class TaskSuggestMenuFormatter
+ *
+ * @package Kanboard\Formatter
+ * @author  Frederic Guillot
+ */
+class TaskSuggestMenuFormatter extends BaseFormatter implements FormatterInterface
+{
+    protected $limit = 25;
+
+    /**
+     * Limit number of results
+     *
+     * @param  $limit
+     * @return $this
+     */
+    public function withLimit($limit)
+    {
+        $this->limit = $limit;
+        return $this;
+    }
+
+    /**
+     * Apply formatter
+     *
+     * @access public
+     * @return mixed
+     */
+    public function format()
+    {
+        $result = array();
+        $tasks = $this->query
+            ->columns(
+                TaskModel::TABLE.'.id',
+                TaskModel::TABLE.'.title',
+                ProjectModel::TABLE.'.name AS project_name'
+            )
+            ->asc(TaskModel::TABLE.'.id')
+            ->limit($this->limit)
+            ->findAll();
+
+        foreach ($tasks as $task) {
+            $html = '#'.$task['id'].' ';
+            $html .= $this->helper->text->e($task['title']).' ';
+            $html .= '<small>'.$this->helper->text->e($task['project_name']).'</small>';
+
+            $result[] = array(
+                'value' => (string) $task['id'],
+                'html' => $html,
+            );
+        }
+
+        return $result;
+    }
+}