public function edit($id)
{
$project = Project::findOrFail($id);
$tags = Tag::all()->pluck('name', 'id');
$self_tags = DB::table('tags')->select('tags.id', 'tags.name')->join('project_tags', 'tags.id', '=', 'project_tags.tag_id')->join('projects', 'projects.id', '=', 'project_tags.project_id')->get();
$self_students = DB::table('students')->select('students.id', 'students.name', 'promos.year')->join('project_students', 'students.id', '=', 'project_students.student_id')->join('projects', 'projects.id', '=', 'project_students.project_id')->join('promos', 'promos.id', '=', 'students.promo')->get();
$old_date = Carbon::createFromFormat('Y-m-d H:i:s', $project->date)->format('Y-m-d');
return view('admin.project.edit', compact('project', 'old_date', 'tags', 'self_tags', 'self_students'));
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$tags = Tag::all();
return view('admin.tag.list', compact('tags'));
}
