/** * Get all the projects a user is associated with * * @return array|Project */ public function getAssociatedProjects() { if ($this->_associated_projects === null) { $this->_associated_projects = array(); $projects = tables\ProjectAssignedUsers::getTable()->getProjectsByUserID($this->getID()); $lo_projects = tables\Projects::getTable()->getByUserID($this->getID()); $project_ids = array_merge(array_keys($projects), array_keys($lo_projects)); foreach ($this->getTeams() as $team) { $project_ids = array_merge($project_ids, array_keys($team->getAssociatedProjects())); } $project_ids = array_unique($project_ids); foreach ($project_ids as $project_id) { try { $this->_associated_projects[$project_id] = tables\Projects::getTable()->selectById($project_id); } catch (\Exception $e) { } } } return $this->_associated_projects; }
protected function _preDelete() { tables\RolePermissions::getTable()->clearPermissionsForRole($this->getID()); tables\ProjectAssignedTeams::getTable()->deleteByRoleID($this->getID()); tables\ProjectAssignedUsers::getTable()->deleteByRoleID($this->getID()); }
protected function _populateUserRoles() { if ($this->_user_roles === null) { $this->_user_roles = tables\ProjectAssignedUsers::getTable()->getRolesForProject($this->getID()); } }
public function addRolePermission(\thebuggenie\core\entities\Role $role, \thebuggenie\core\entities\RolePermission $rolepermission) { $role_id = $role->getID(); $crit = $this->getCriteria(); $crit->addWhere(self::ROLE_ID, $role_id); $existing_identifiables = array(self::UID => array(), self::TID => array()); $target_id = $rolepermission->getExpandedTargetID($role); if ($res = $this->doSelect($crit)) { while ($row = $res->getNextRow()) { $key = $row->get(self::UID) ? self::UID : self::TID; if (!isset($existing_identifiables[$key][$row->get($key)])) { $existing_identifiables[$key][$row->get($key)] = array('id' => $row->get($key), 'target_id' => $target_id, 'permission_type_module' => array()); } $existing_identifiables[$key][$row->get($key)]['permission_type_module'][] = $row->get(self::PERMISSION_TYPE) . ';' . $row->get(self::MODULE); } } foreach (ProjectAssignedUsers::getTable()->getUsersByRoleID($role_id) as $uid => $assigned_user) { if (!isset($existing_identifiables[self::UID][$uid])) { $existing_identifiables[self::UID][$uid] = array('id' => $uid, 'target_id' => $target_id, 'permission_type_module' => array()); } } foreach (ProjectAssignedTeams::getTable()->getTeamsByRoleID($role_id) as $tid => $assigned_team) { if (!isset($existing_identifiables[self::TID][$tid])) { $existing_identifiables[self::TID][$tid] = array('id' => $tid, 'target_id' => $target_id, 'permission_type_module' => array()); } } foreach ($existing_identifiables as $key => $identifiables) { foreach ($identifiables as $identifiable) { if (in_array($rolepermission->getPermission() . ';' . $rolepermission->getModule(), $identifiable['permission_type_module'])) { continue; } $crit = $this->getCriteria(); $crit->addInsert(self::SCOPE, framework\Context::getScope()->getID()); $crit->addInsert(self::PERMISSION_TYPE, $rolepermission->getPermission()); $crit->addInsert(self::TARGET_ID, $identifiable['target_id']); $crit->addInsert($key, $identifiable['id']); $crit->addInsert(self::ALLOWED, true); $crit->addInsert(self::MODULE, $rolepermission->getModule()); $crit->addInsert(self::ROLE_ID, $role_id); $res = $this->doInsert($crit); } } }