File size: 1,055 Bytes
e4f4821 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 |
<?php
namespace Kanboard\Filter;
use Kanboard\Core\Filter\FilterInterface;
use Kanboard\Model\ProjectModel;
use Kanboard\Model\TaskModel;
/**
* Filter tasks by project
*
* @package filter
* @author Frederic Guillot
*/
class TaskProjectFilter extends BaseFilter implements FilterInterface
{
/**
* Get search attribute
*
* @access public
* @return string[]
*/
public function getAttributes()
{
return array('project');
}
/**
* Apply filter
*
* @access public
* @return FilterInterface
*/
public function apply()
{
// Max integer value for Postgres is +2147483647
// See https://www.postgresql.org/docs/current/datatype-numeric.html
if (is_int($this->value) || ctype_digit((string) $this->value) && $this->value < 2147483647) {
$this->query->eq(TaskModel::TABLE.'.project_id', $this->value);
} else {
$this->query->ilike(ProjectModel::TABLE.'.name', $this->value);
}
return $this;
}
}
|