/**
* Show the form for creating a new resource.
* @return Response
*/
public function create()
{
$classrooms = Classroom::inCurrentSemester()->pluck('code', 'id')->toArray();
$subjects = Subject::isCurrent()->pluck('name', 'id')->toArray();
$years = Year::leftJoin('academystructure_terms as acaterm', 'acaterm.year_id', '=', 'ay.id')->leftJoin('academystructure_departments as acadep', 'acadep.term_id', '=', 'acaterm.id')->Leftjoin('students as s', 's.academystructure_department_id', '=', 'acadep.id')->groupBy('ay.id')->from('academystructure_years as ay')->havingRaw('COUNT(s.id)>0')->pluck('ay.name', 'ay.id')->toArray();
return view('exams::Extend.create', compact('years', 'subjects', 'classrooms'));
}
public function edit($id = 0)
{
$elements = EvaluationElement::findOrFail($id);
$years = Year::leftJoin('academystructure_terms as acaterm', 'acaterm.year_id', '=', 'ay.id')->leftJoin('academystructure_departments as acadep', 'acadep.term_id', '=', 'acaterm.id')->Leftjoin('students as s', 's.academystructure_department_id', '=', 'acadep.id')->groupBy('ay.id')->from('academystructure_years as ay')->havingRaw('COUNT(s.id)>0')->pluck('ay.name', 'ay.id')->toArray();
return view('quran::elements.edit', compact('elements', 'years'));
}
