diff options
Diffstat (limited to 'app/Filter')
-rw-r--r-- | app/Filter/BaseDateRangeFilter.php | 54 | ||||
-rw-r--r-- | app/Filter/TaskCreationDateRangeFilter.php | 38 | ||||
-rw-r--r-- | app/Filter/TaskMovedDateRangeFilter.php | 38 |
3 files changed, 130 insertions, 0 deletions
diff --git a/app/Filter/BaseDateRangeFilter.php b/app/Filter/BaseDateRangeFilter.php new file mode 100644 index 00000000..336f8c8e --- /dev/null +++ b/app/Filter/BaseDateRangeFilter.php @@ -0,0 +1,54 @@ +<?php + +namespace Kanboard\Filter; + +use Kanboard\Core\DateParser; + +/** + * Base date filter class + * + * @package filter + * @author Kamil Ściana + */ +abstract class BaseDateRangeFilter extends BaseFilter +{ + /** + * DateParser object + * + * @access protected + * @var DateParser + */ + protected $dateParser; + + /** + * Set DateParser object + * + * @access public + * @param DateParser $dateParser + * @return $this + */ + public function setDateParser(DateParser $dateParser) + { + $this->dateParser = $dateParser; + return $this; + } + + /** + * Apply a date filter + * + * @access protected + * @param string $field + */ + protected function applyDateFilter($field) + { + $dates = explode('..', $this->value); + + if(count($dates)=== 2){ + $timestampFrom = $this->dateParser->getTimestamp($dates[0]); + $timestampTo = $this->dateParser->getTimestamp($dates[1]); + + $this->query->gte($field, $timestampFrom); + $this->query->lte($field, $timestampTo + 86399); + } + } +} diff --git a/app/Filter/TaskCreationDateRangeFilter.php b/app/Filter/TaskCreationDateRangeFilter.php new file mode 100644 index 00000000..7696af07 --- /dev/null +++ b/app/Filter/TaskCreationDateRangeFilter.php @@ -0,0 +1,38 @@ +<?php + +namespace Kanboard\Filter; + +use Kanboard\Core\Filter\FilterInterface; +use Kanboard\Model\TaskModel; + +/** + * Filter tasks by creation date + * + * @package filter + * @author Kamil Ściana + */ +class TaskCreationDateRangeFilter extends BaseDateRangeFilter implements FilterInterface +{ + /** + * Get search attribute + * + * @access public + * @return string[] + */ + public function getAttributes() + { + return array('createdRange'); + } + + /** + * Apply filter + * + * @access public + * @return FilterInterface + */ + public function apply() + { + $this->applyDateFilter(TaskModel::TABLE.'.date_creation'); + return $this; + } +} diff --git a/app/Filter/TaskMovedDateRangeFilter.php b/app/Filter/TaskMovedDateRangeFilter.php new file mode 100644 index 00000000..b5b826b0 --- /dev/null +++ b/app/Filter/TaskMovedDateRangeFilter.php @@ -0,0 +1,38 @@ +<?php + +namespace Kanboard\Filter; + +use Kanboard\Core\Filter\FilterInterface; +use Kanboard\Model\TaskModel; + +/** + * Filter tasks by creation date + * + * @package filter + * @author Kamil Ściana + */ +class TaskMovedDateRangeFilter extends BaseDateRangeFilter implements FilterInterface +{ + /** + * Get search attribute + * + * @access public + * @return string[] + */ + public function getAttributes() + { + return array('movedRange'); + } + + /** + * Apply filter + * + * @access public + * @return FilterInterface + */ + public function apply() + { + $this->applyDateFilter(TaskModel::TABLE.'.date_moved'); + return $this; + } +} |