Add a filter by user and due date + minor changes

1 files changed, 9 insertions, 1 deletions

diff --git a/models/task.php b/models/task.php
index c54e0cbc..b61fb13f 100644
--- a/models/task.php
+++ b/models/task.php
@@ -127,9 +127,10 @@ class Task extends Base
      *
      * @access public
      * @param  array    $filters   Filters: [ ['column' => '...', 'operator' => '...', 'value' => '...'], ... ]
+     * @param  array    $sorting   Sorting: [ 'column' => 'date_creation', 'direction' => 'asc']
      * @return array
      */
-    public function find(array $filters)
+    public function find(array $filters, array $sorting = array())
     {
         $table = $this->db
                     ->table(self::TABLE)
@@ -155,6 +156,13 @@ class Task extends Base
             $table->$filter['operator']($filter['column'], $filter['value']);
         }
 
+        if (empty($sorting)) {
+            $table->orderBy('tasks.position', 'ASC');
+        }
+        else {
+            $table->orderBy($sorting['column'], $sorting['direction']);
+        }
+
         return $table->findAll();
     }