/**
* 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);
}
}
}
