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();
}
