diff options
| author | Imbasaur <yarrusg@gmail.com> | 2016-04-13 17:05:59 +0200 |
|---|---|---|
| committer | Imbasaur <yarrusg@gmail.com> | 2016-04-13 17:05:59 +0200 |
| commit | 99f275e5bb033cca33eee87b0e914645730f13d1 (patch) | |
| tree | ad845419d56304f2bf014744f0878186f7155a3c /app/Model/ProjectGroupRoleFilter.php | |
| parent | 13d5bd8e48bd6c0109d1272da58a8879bf9a6737 (diff) | |
| parent | cd5bf9d4d214ec9282b706c26bb27cabf150ee63 (diff) | |
Merge pull request #1 from fguillot/master
Diffstat (limited to 'app/Model/ProjectGroupRoleFilter.php')
| -rw-r--r-- | app/Model/ProjectGroupRoleFilter.php | 89 |
1 files changed, 0 insertions, 89 deletions
diff --git a/app/Model/ProjectGroupRoleFilter.php b/app/Model/ProjectGroupRoleFilter.php deleted file mode 100644 index 989d3073..00000000 --- a/app/Model/ProjectGroupRoleFilter.php +++ /dev/null @@ -1,89 +0,0 @@ -<?php - -namespace Kanboard\Model; - -/** - * Project Group Role Filter - * - * @package model - * @author Frederic Guillot - */ -class ProjectGroupRoleFilter extends Base -{ - /** - * Query - * - * @access protected - * @var \PicoDb\Table - */ - protected $query; - - /** - * Initialize filter - * - * @access public - * @return UserFilter - */ - public function create() - { - $this->query = $this->db->table(ProjectGroupRole::TABLE); - return $this; - } - - /** - * Get all results of the filter - * - * @access public - * @param string $column - * @return array - */ - public function findAll($column = '') - { - if ($column !== '') { - return $this->query->asc($column)->findAllByColumn($column); - } - - return $this->query->findAll(); - } - - /** - * Get the PicoDb query - * - * @access public - * @return \PicoDb\Table - */ - public function getQuery() - { - return $this->query; - } - - /** - * Filter by project id - * - * @access public - * @param integer $project_id - * @return ProjectUserRoleFilter - */ - public function filterByProjectId($project_id) - { - $this->query->eq(ProjectGroupRole::TABLE.'.project_id', $project_id); - return $this; - } - - /** - * Filter by username - * - * @access public - * @param string $input - * @return ProjectUserRoleFilter - */ - public function startWithUsername($input) - { - $this->query - ->join(GroupMember::TABLE, 'group_id', 'group_id', ProjectGroupRole::TABLE) - ->join(User::TABLE, 'id', 'user_id', GroupMember::TABLE) - ->ilike(User::TABLE.'.username', $input.'%'); - - return $this; - } -} |
