public function create() { $elements = EvaluationElement::paginate(20); // $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(); $subjects = Subject::where('is_quran', 1)->pluck('name', 'id')->toArray(); // dd($subjects); return view('quran::elements.create', compact('elements', 'subjects')); }