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'));
}
public function projects()
{
$projects = Project::all();
$tags = Tag::orderBy('name', 'asc')->get();
$years = Project::getArrayDates();
//Get projects tag
foreach ($projects as &$project) {
$link_tags = Project::findOrFail($project->id)->project_tag;
$project_self_tags = array();
foreach ($link_tags as $link_tag) {
array_push($project_self_tags, Tag::findOrFail($link_tag->tag_id));
}
$project->tags = $project_self_tags;
}
//$project = $project->first();
//$project->date = Carbon::createFromFormat('Y-m-d H:i:s',$project->date)->format('Y');
return view('pages.projects', compact('projects', 'tags', 'years'));
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$tag = Tag::findOrFail($id);
$tag->delete();
return redirect('admin/Tag');
}
