From 6551609d1b248011d301080c1be7c48085dc5d55 Mon Sep 17 00:00:00 2001 From: Frédéric Guillot Date: Sat, 26 Apr 2014 20:04:39 -0400 Subject: Add a filter by user and due date + minor changes --- models/task.php | 10 +++++++++- 1 file changed, 9 insertions(+), 1 deletion(-) (limited to 'models/task.php') 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(); } -- cgit v1.2.3