public function run()
{
DB::table('projects')->truncate();
Project::create(['project_id' => 1, 'name' => 'Demo Project 1', 'syllabary_id' => 1]);
Project::create(['project_id' => 2, 'name' => 'Demo Project 2', 'syllabary_id' => 2]);
Project::create(['project_id' => 2, 'name' => 'Demo Project 2', 'syllabary_id' => 3]);
}
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 NewSyllabary($project, $name)
{
$syllabary = $this->CreateSyllabary($name);
$projectName = Project::where('project_id', '=', $project)->firstOrFail()['name'];
Project::create(array('project_id' => $project, 'name' => $projectName, 'syllabary_id' => $syllabary->id));
}
