Since: 3.0.0
Author: Jack P.
Inheritance: extends Traq\Models\Model
Example #1
0
 /**
  * Insert project roles.
  */
 public function insertProjectRoles()
 {
     $roles = [['name' => "Manager", 'is_assignable' => true, 'project_id' => 0], ['name' => "Developer", 'is_assignable' => true, 'project_id' => 0], ['name' => "Tester", 'is_assignable' => true, 'project_id' => 0]];
     foreach ($roles as $role) {
         $model = new ProjectRole($role);
         $model->save();
     }
 }
Example #2
0
 /**
  * Add project member.
  *
  * @return \Avalon\Http\RedirectResponse|\Avalon\Http\Response
  */
 public function createAction()
 {
     $errors = [];
     $user = User::find('username', Request::$post->get('username'));
     $role = ProjectRole::find(Request::$post->get('role_id'));
     // Check if they entered a username
     if (!Request::$post->has('username') || Request::$post->get('username') == '') {
         $errors['username'] = $this->translate('errors.validations.required', ['field' => $this->translate('username')]);
     } elseif (!$user) {
         $errors['username'] = $this->translate('errors.users.doesnt_exist');
     }
     // Check if the user is already a member of the project
     if ($user) {
         $member = UserRole::select('id')->where('project_id = ?')->setParameter(0, $this->currentProject['id'])->andWhere('user_id = ?')->setParameter(1, $user->id)->execute();
     }
     if ($user && isset($member) && $member->rowCount() > 0) {
         $errors['username'] = $this->translate('errors.users.already_a_project_member');
     }
     // Check if they chose a role
     if (Request::$post->get('role_id', '') == '') {
         $errors['role_id'] = $this->translate('errors.validations.required', ['field' => $this->translate('role')]);
     }
     // Check if the role exists
     if (!$role) {
         $errors['role'] = $this->translate('errors.roles.doesnt_exist');
     }
     // Check if the role belongs to the project
     if ($role && ($role->project_id != 0 && $role->project_id != $this->currentProject['id'])) {
         $errors['role'] = $this->translate('errors.roles.invalid_role');
     }
     if (count($errors)) {
         return $this->render('project_settings/members/new.phtml', ['errors' => $errors]);
     } else {
         $userRole = new UserRole(['project_id' => $this->currentProject['id'], 'project_role_id' => $role->id, 'user_id' => $user->id]);
         $userRole->save();
         return $this->redirectTo('project_settings_members');
     }
 }
Example #3
0
 /**
  * Fetches all the data for the permission listing page.
  */
 private function permissions_for($type)
 {
     // Fetch groups, set permissions and actions arrays
     if ($type == 'usergroup') {
         $groups = Group::select()->where('is_admin', 1, '!=')->exec()->fetch_all();
         $groups = array_merge(array(new Group(array('id' => 0, 'name' => l('defaults')))), $groups);
     } elseif ($type == 'role') {
         $groups = ProjectRole::select()->custom_sql("WHERE project_id = 0 OR project_id = {$this->project->id}")->exec()->fetch_all();
         $groups = array_merge(array(new ProjectRole(array('id' => 0, 'name' => l('defaults'), 'project_id' => 0))), $groups);
     }
     $permissions = array();
     // Loop over the groups
     foreach ($groups as $group) {
         // Set the group array in the permissions array
         if (!isset($permissions[$group->id])) {
             $permissions[$group->id] = array();
         }
         // Loop over the permissions for the group
         foreach (Permission::get_permissions($this->project->id, $group->id, $type) as $action => $perm) {
             // Add the permission object to the permissions array
             $permissions[$group->id][$action] = $perm;
         }
     }
     // Send it all the to view.
     View::set('groups', $groups);
     View::set('permissions', $permissions);
     View::set('actions', permission_actions());
 }
Example #4
0
 protected function getAllRows()
 {
     return ProjectRole::select('project_role.*', 'project.name AS project_name')->leftJoin('project_role', PREFIX . 'projects', 'project', 'project.id = project_role.project_id')->execute()->fetchAll();
 }
Example #5
0
function createProjectManager($project = null, $user = null)
{
    if (!$project) {
        $project = createProject();
    }
    if (!$user) {
        $user = createUser();
    }
    $role = ProjectRole::find(1);
    $relation = new UserRole(['user_id' => $user['id'], 'project_id' => $project['id'], 'project_role_id' => $role['id']]);
    $relation->save();
    return $relation;
}