From 23d862aef8891130bc7eaeaa25513a9895b44c95 Mon Sep 17 00:00:00 2001
From: Frederic Guillot <fred@kanboard.net>
Date: Sat, 3 Dec 2016 12:56:12 -0500
Subject: Add suggest menu for task ID

---
 app/Formatter/TaskSuggestMenuFormatter.php | 63 ++++++++++++++++++++++++++++++
 1 file changed, 63 insertions(+)
 create mode 100644 app/Formatter/TaskSuggestMenuFormatter.php

(limited to 'app/Formatter/TaskSuggestMenuFormatter.php')

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;
+    }
+}
-- 
cgit v1.2.3