Add filter tag:none

1 files changed, 25 insertions, 6 deletions

diff --git a/app/Filter/TaskTagFilter.php b/app/Filter/TaskTagFilter.php
index 01b6f625..98be5554 100644
--- a/app/Filter/TaskTagFilter.php
+++ b/app/Filter/TaskTagFilter.php
@@ -56,12 +56,11 @@ class TaskTagFilter extends BaseFilter implements FilterInterface
      */
     public function apply()
     {
-        $task_ids = $this->db
-            ->table(TagModel::TABLE)
-            ->ilike(TagModel::TABLE.'.name', $this->value)
-            ->asc(TagModel::TABLE.'.project_id')
-            ->join(TaskTagModel::TABLE, 'tag_id', 'id')
-            ->findAllByColumn(TaskTagModel::TABLE.'.task_id');
+        if ($this->value === 'none') {
+            $task_ids = $this->getTaskIdsWithoutTags();
+        } else {
+            $task_ids = $this->getTaskIdsWithGivenTag();
+        }
 
         if (empty($task_ids)) {
             $task_ids = array(-1);
@@ -71,4 +70,24 @@ class TaskTagFilter extends BaseFilter implements FilterInterface
 
         return $this;
     }
+
+    protected function getTaskIdsWithoutTags()
+    {
+        return $this->db
+            ->table(TaskModel::TABLE)
+            ->asc(TaskModel::TABLE . '.project_id')
+            ->left(TaskTagModel::TABLE, 'tg', 'task_id', TaskModel::TABLE, 'id')
+            ->isNull('tg.tag_id')
+            ->findAllByColumn(TaskModel::TABLE . '.id');
+    }
+
+    protected function getTaskIdsWithGivenTag()
+    {
+        return $this->db
+            ->table(TagModel::TABLE)
+            ->ilike(TagModel::TABLE.'.name', $this->value)
+            ->asc(TagModel::TABLE.'.project_id')
+            ->join(TaskTagModel::TABLE, 'tag_id', 'id')
+            ->findAllByColumn(TaskTagModel::TABLE.'.task_id');
+    }
 }