/** * 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')); }