public function run() { DB::table('project_members')->truncate(); ProjectMembers::create(['user_id' => 1, 'project_id' => 1, 'access' => 3]); ProjectMembers::create(['user_id' => 2, 'project_id' => 1, 'access' => 2]); ProjectMembers::create(['user_id' => 1, 'project_id' => 2, 'access' => 3]); ProjectMembers::create(['user_id' => 3, 'project_id' => 2, 'access' => 1]); }
private function _getUserSyllabaryRole($user_id, $syllabary_id) { $project = Project::where('syllabary_id', '=', $syllabary_id)->first(); if ($project == NULL) { return -1; } $membership = ProjectMembers::where('project_id', '=', $project->project_id)->where('user_id', '=', $user_id)->first(); if ($membership == NULL) { return -1; } return $membership->access; }
public function ChangeRole($project, $user, $role) { $entry = ProjectMembers::where('project_id', '=', $project)->where('user_id', '=', $user)->firstOrFail(); $entry['access'] = $role; $entry->save(); }