summaryrefslogtreecommitdiff
path: root/app/Model/GroupMember.php
diff options
context:
space:
mode:
authorFrederic Guillot <fred@kanboard.net>2016-05-28 19:48:22 -0400
committerFrederic Guillot <fred@kanboard.net>2016-05-28 19:48:22 -0400
commit14713b0ec7ed93ca45578da069ad4e19a7d8addf (patch)
tree79972d53f6091a1ddb17f64a6a05a5523f5d5168 /app/Model/GroupMember.php
parent936376ffe74c583d3cb819e98f53a85137fdf8bc (diff)
Rename all models
Diffstat (limited to 'app/Model/GroupMember.php')
-rw-r--r--app/Model/GroupMember.php130
1 files changed, 0 insertions, 130 deletions
diff --git a/app/Model/GroupMember.php b/app/Model/GroupMember.php
deleted file mode 100644
index a0bbb9f8..00000000
--- a/app/Model/GroupMember.php
+++ /dev/null
@@ -1,130 +0,0 @@
-<?php
-
-namespace Kanboard\Model;
-
-use Kanboard\Core\Base;
-
-/**
- * Group Member Model
- *
- * @package model
- * @author Frederic Guillot
- */
-class GroupMember extends Base
-{
- /**
- * SQL table name
- *
- * @var string
- */
- const TABLE = 'group_has_users';
-
- /**
- * Get query to fetch all users
- *
- * @access public
- * @param integer $group_id
- * @return \PicoDb\Table
- */
- public function getQuery($group_id)
- {
- return $this->db->table(self::TABLE)
- ->join(User::TABLE, 'id', 'user_id')
- ->eq('group_id', $group_id);
- }
-
- /**
- * Get all users
- *
- * @access public
- * @param integer $group_id
- * @return array
- */
- public function getMembers($group_id)
- {
- return $this->getQuery($group_id)->findAll();
- }
-
- /**
- * Get all not members
- *
- * @access public
- * @param integer $group_id
- * @return array
- */
- public function getNotMembers($group_id)
- {
- $subquery = $this->db->table(self::TABLE)
- ->columns('user_id')
- ->eq('group_id', $group_id);
-
- return $this->db->table(User::TABLE)
- ->notInSubquery('id', $subquery)
- ->findAll();
- }
-
- /**
- * Add user to a group
- *
- * @access public
- * @param integer $group_id
- * @param integer $user_id
- * @return boolean
- */
- public function addUser($group_id, $user_id)
- {
- return $this->db->table(self::TABLE)->insert(array(
- 'group_id' => $group_id,
- 'user_id' => $user_id,
- ));
- }
-
- /**
- * Remove user from a group
- *
- * @access public
- * @param integer $group_id
- * @param integer $user_id
- * @return boolean
- */
- public function removeUser($group_id, $user_id)
- {
- return $this->db->table(self::TABLE)
- ->eq('group_id', $group_id)
- ->eq('user_id', $user_id)
- ->remove();
- }
-
- /**
- * Check if a user is member
- *
- * @access public
- * @param integer $group_id
- * @param integer $user_id
- * @return boolean
- */
- public function isMember($group_id, $user_id)
- {
- return $this->db->table(self::TABLE)
- ->eq('group_id', $group_id)
- ->eq('user_id', $user_id)
- ->exists();
- }
-
- /**
- * Get all groups for a given user
- *
- * @access public
- * @param integer $user_id
- * @return array
- */
- public function getGroups($user_id)
- {
- return $this->db->table(self::TABLE)
- ->columns(Group::TABLE.'.id', Group::TABLE.'.external_id', Group::TABLE.'.name')
- ->join(Group::TABLE, 'id', 'group_id')
- ->eq(self::TABLE.'.user_id', $user_id)
- ->asc(Group::TABLE.'.name')
- ->findAll();
- }
-}