Start to implement advanced search query language

2 files changed, 163 insertions, 0 deletions

diff --git a/app/Model/Color.php b/app/Model/Color.php
index 9a21f691..a35aff8f 100644
--- a/app/Model/Color.php
+++ b/app/Model/Color.php
@@ -100,6 +100,29 @@ class Color extends Base
     );
 
     /**
+     * Find a color id from the name or the id
+     *
+     * @access public
+     * @param  string  $color
+     * @return string
+     */
+    public function find($color)
+    {
+        $color = strtolower($color);
+
+        foreach ($this->default_colors as $color_id => $params) {
+            if ($color_id === $color) {
+                return $color_id;
+            }
+            else if ($color === strtolower($params['name'])) {
+                return $color_id;
+            }
+        }
+
+        return '';
+    }
+
+    /**
      * Get available colors
      *
      * @access public
diff --git a/app/Model/TaskFilter.php b/app/Model/TaskFilter.php
index bd03a8bc..4f306b14 100644
--- a/app/Model/TaskFilter.php
+++ b/app/Model/TaskFilter.php
@@ -24,6 +24,42 @@ class TaskFilter extends Base
     public $query;
 
     /**
+     * Apply filters according to the search input
+     *
+     * @access public
+     * @param  string   $input
+     * @return TaskFilter
+     */
+    public function search($input)
+    {
+        $tree = $this->lexer->map($this->lexer->tokenize($input));
+        $this->query = $this->taskFinder->getExtendedQuery();
+
+        if (empty($tree)) {
+            $this->query->addCondition('1 = 0');
+        }
+
+        foreach ($tree as $filter => $value) {
+            switch ($filter) {
+                case 'T_ASSIGNEE':
+                    $this->filterByAssignee($value);
+                    break;
+                case 'T_COLOR':
+                    $this->filterByColors($value);
+                    break;
+                case 'T_DUE':
+                    $this->filterByDueDate($value);
+                    break;
+                case 'T_TITLE':
+                    $this->filterByTitle($value);
+                    break;
+            }
+        }
+
+        return $this;
+    }
+
+    /**
      * Create a new query
      *
      * @access public
@@ -164,6 +200,35 @@ class TaskFilter extends Base
     }
 
     /**
+     * Filter by assignee names
+     *
+     * @access public
+     * @param  array    $values   List of assignees
+     * @return TaskFilter
+     */
+    public function filterByAssignee(array $values)
+    {
+        $this->query->beginOr();
+
+        foreach ($values as $assignee) {
+
+            switch ($assignee) {
+                case 'me':
+                    $this->query->eq('owner_id', $this->userSession->getId());
+                    break;
+                case 'nobody':
+                    $this->query->eq('owner_id', 0);
+                    break;
+                default:
+                    $this->query->ilike(User::TABLE.'.username', '%'.$assignee.'%');
+                    $this->query->ilike(User::TABLE.'.name', '%'.$assignee.'%');
+            }
+        }
+
+        $this->query->closeOr();
+    }
+
+    /**
      * Filter by color
      *
      * @access public
@@ -180,6 +245,26 @@ class TaskFilter extends Base
     }
 
     /**
+     * Filter by colors
+     *
+     * @access public
+     * @param  array   $colors
+     * @return TaskFilter
+     */
+    public function filterByColors(array $colors)
+    {
+        $this->query->beginOr();
+
+        foreach ($colors as $color) {
+            $this->filterByColor($this->color->find($color));
+        }
+
+        $this->query->closeOr();
+
+        return $this;
+    }
+
+    /**
      * Filter by column
      *
      * @access public
@@ -228,6 +313,18 @@ class TaskFilter extends Base
     }
 
     /**
+     * Filter by due date
+     *
+     * @access public
+     * @param  string      $date      ISO8601 date format
+     * @return TaskFilter
+     */
+    public function filterByDueDate($date)
+    {
+        return $this->filterWithOperator('date_due', $date, true);
+    }
+
+    /**
      * Filter by due date (range)
      *
      * @access public
@@ -295,6 +392,17 @@ class TaskFilter extends Base
     }
 
     /**
+     * Get the PicoDb query
+     *
+     * @access public
+     * @return \PicoDb\Table
+     */
+    public function getQuery()
+    {
+        return $this->query;
+    }
+
+    /**
      * Format the results to the ajax autocompletion
      *
      * @access public
@@ -465,4 +573,36 @@ class TaskFilter extends Base
 
         return $vEvent;
     }
+
+    /**
+     * Filter with an operator
+     *
+     * @access public
+     * @param  string    $field
+     * @param  string    $value
+     * @param  boolean   $is_date
+     * @return TaskFilter
+     */
+    private function filterWithOperator($field, $value, $is_date)
+    {
+        $operators = array(
+            '<=' => 'lte',
+            '>=' => 'gte',
+            '<' => 'lt',
+            '>' => 'gt',
+        );
+
+        foreach ($operators as $operator => $method) {
+
+            if (strpos($value, $operator) === 0) {
+                $value = substr($value, strlen($operator));
+                $this->query->$method($field, $is_date ? $this->dateParser->getTimestampFromIsoFormat($value) : $value);
+                return $this;
+            }
+        }
+
+        $this->query->eq($field, $is_date ? $this->dateParser->getTimestampFromIsoFormat($value) : $value);
+
+        return $this;
+    }
 }