summaryrefslogtreecommitdiff
path: root/app/Model/ProjectGroupRole.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/ProjectGroupRole.php
parent936376ffe74c583d3cb819e98f53a85137fdf8bc (diff)
Rename all models
Diffstat (limited to 'app/Model/ProjectGroupRole.php')
-rw-r--r--app/Model/ProjectGroupRole.php191
1 files changed, 0 insertions, 191 deletions
diff --git a/app/Model/ProjectGroupRole.php b/app/Model/ProjectGroupRole.php
deleted file mode 100644
index 3ce2b1dc..00000000
--- a/app/Model/ProjectGroupRole.php
+++ /dev/null
@@ -1,191 +0,0 @@
-<?php
-
-namespace Kanboard\Model;
-
-use Kanboard\Core\Base;
-use Kanboard\Core\Security\Role;
-
-/**
- * Project Group Role
- *
- * @package model
- * @author Frederic Guillot
- */
-class ProjectGroupRole extends Base
-{
- /**
- * SQL table name
- *
- * @var string
- */
- const TABLE = 'project_has_groups';
-
- /**
- * Get the list of project visible by the given user according to groups
- *
- * @access public
- * @param integer $user_id
- * @param array $status
- * @return array
- */
- public function getProjectsByUser($user_id, $status = array(Project::ACTIVE, Project::INACTIVE))
- {
- return $this->db
- ->hashtable(Project::TABLE)
- ->join(self::TABLE, 'project_id', 'id')
- ->join(GroupMember::TABLE, 'group_id', 'group_id', self::TABLE)
- ->eq(GroupMember::TABLE.'.user_id', $user_id)
- ->in(Project::TABLE.'.is_active', $status)
- ->getAll(Project::TABLE.'.id', Project::TABLE.'.name');
- }
-
- /**
- * For a given project get the role of the specified user
- *
- * @access public
- * @param integer $project_id
- * @param integer $user_id
- * @return string
- */
- public function getUserRole($project_id, $user_id)
- {
- $roles = $this->db->table(self::TABLE)
- ->join(GroupMember::TABLE, 'group_id', 'group_id', self::TABLE)
- ->eq(GroupMember::TABLE.'.user_id', $user_id)
- ->eq(self::TABLE.'.project_id', $project_id)
- ->findAllByColumn('role');
-
- return $this->projectAccessMap->getHighestRole($roles);
- }
-
- /**
- * Get all groups associated directly to the project
- *
- * @access public
- * @param integer $project_id
- * @return array
- */
- public function getGroups($project_id)
- {
- return $this->db->table(self::TABLE)
- ->columns(Group::TABLE.'.id', Group::TABLE.'.name', self::TABLE.'.role')
- ->join(Group::TABLE, 'id', 'group_id')
- ->eq('project_id', $project_id)
- ->asc('name')
- ->findAll();
- }
-
- /**
- * From groups get all users associated to the project
- *
- * @access public
- * @param integer $project_id
- * @return array
- */
- public function getUsers($project_id)
- {
- return $this->db->table(self::TABLE)
- ->columns(User::TABLE.'.id', User::TABLE.'.username', User::TABLE.'.name', self::TABLE.'.role')
- ->join(GroupMember::TABLE, 'group_id', 'group_id', self::TABLE)
- ->join(User::TABLE, 'id', 'user_id', GroupMember::TABLE)
- ->eq(self::TABLE.'.project_id', $project_id)
- ->asc(User::TABLE.'.username')
- ->findAll();
- }
-
- /**
- * From groups get all users assignable to tasks
- *
- * @access public
- * @param integer $project_id
- * @return array
- */
- public function getAssignableUsers($project_id)
- {
- return $this->db->table(User::TABLE)
- ->columns(User::TABLE.'.id', User::TABLE.'.username', User::TABLE.'.name')
- ->join(GroupMember::TABLE, 'user_id', 'id', User::TABLE)
- ->join(self::TABLE, 'group_id', 'group_id', GroupMember::TABLE)
- ->eq(self::TABLE.'.project_id', $project_id)
- ->eq(User::TABLE.'.is_active', 1)
- ->in(self::TABLE.'.role', array(Role::PROJECT_MANAGER, Role::PROJECT_MEMBER))
- ->asc(User::TABLE.'.username')
- ->findAll();
- }
-
- /**
- * Add a group to the project
- *
- * @access public
- * @param integer $project_id
- * @param integer $group_id
- * @param string $role
- * @return boolean
- */
- public function addGroup($project_id, $group_id, $role)
- {
- return $this->db->table(self::TABLE)->insert(array(
- 'group_id' => $group_id,
- 'project_id' => $project_id,
- 'role' => $role,
- ));
- }
-
- /**
- * Remove a group from the project
- *
- * @access public
- * @param integer $project_id
- * @param integer $group_id
- * @return boolean
- */
- public function removeGroup($project_id, $group_id)
- {
- return $this->db->table(self::TABLE)->eq('group_id', $group_id)->eq('project_id', $project_id)->remove();
- }
-
- /**
- * Change a group role for the project
- *
- * @access public
- * @param integer $project_id
- * @param integer $group_id
- * @param string $role
- * @return boolean
- */
- public function changeGroupRole($project_id, $group_id, $role)
- {
- return $this->db->table(self::TABLE)
- ->eq('group_id', $group_id)
- ->eq('project_id', $project_id)
- ->update(array(
- 'role' => $role,
- ));
- }
-
- /**
- * Copy group access from a project to another one
- *
- * @param integer $project_src_id Project Template
- * @param integer $project_dst_id Project that receives the copy
- * @return boolean
- */
- public function duplicate($project_src_id, $project_dst_id)
- {
- $rows = $this->db->table(self::TABLE)->eq('project_id', $project_src_id)->findAll();
-
- foreach ($rows as $row) {
- $result = $this->db->table(self::TABLE)->save(array(
- 'project_id' => $project_dst_id,
- 'group_id' => $row['group_id'],
- 'role' => $row['role'],
- ));
-
- if (! $result) {
- return false;
- }
- }
-
- return true;
- }
-}