/** * Display a listing of the resource. * @return Response */ public function index(Request $request) { $excuses = ExamExcuse::where('semester_id', semester()->id)->with('student', 'subject', 'exam'); if (request('subject_id')) { $subject_id = request('subject_id'); $excuses->whereHas('exam.subject', function ($q) use($subject_id) { $q->where('subject_subjects.id', $subject_id); }); } if (request('exam_year_term')) { $excuses->whereIn('subject_id', explode(',', request('exam_year_term'))); } $per_page = request('per_page') ? request('per_page') : 50; $excuses = $excuses->paginate($per_page); $excuses->appends($request->except("page")); $subjects = Subject::lists('name', 'id')->toArray(); $year_term = Year::join('academystructure_terms', 'academystructure_years.id', '=', 'academystructure_terms.year_id')->join('academystructure_departments', 'academystructure_terms.id', '=', 'academystructure_departments.term_id')->select(\DB::raw('CONCAT(academystructure_years.name, "-", academystructure_terms.name) as name, GROUP_CONCAT(DISTINCT(academystructure_departments.subject_ids)) as sid'))->groupBy('academystructure_terms.name', 'academystructure_years.name')->get()->toArray(); $year_term_options; foreach ($year_term as $key => &$aa) { $a = implode(',', array_unique(array_merge(json_decode(str_replace('],[', ',', $aa['sid']), TRUE)))); $year_term_options[$a] = $aa['name']; } return view('exams::excuses.index', compact('excuses', 'subjects', 'year_term_options')); }
/** * @desc Edit Department * @Edit function Open Edit From view * @param Department $department (get department data from provider route model binding $router->model) * @param Specialty $specialty for parent specialty list * @param Subject $subject for parent subject list **/ public function edit(Department $department, Specialty $specialty, Subject $subject) { $subjects = $subject->lists('name', 'id')->toArray(); $menu = $department->menu()->get(); $specialties = $specialty->get(); return view('academystructure::departments.edit', compact('department', 'menu', 'specialties', 'subjects')); }
/** * @desc get all subjects * @parm $id int = subject id * @return list of subjects view **/ public function index() { $subjects = Subject::select('*'); if (request('QB_subject')) { $subjects->where('id', request('QB_subject')); } if (request('QB_year_term')) { $subjects->whereIn('id', explode(',', request('QB_year_term'))); } $subjects = $subjects->get(); $year_term = year::join('academystructure_terms', 'academystructure_years.id', '=', 'academystructure_terms.year_id')->join('academystructure_departments', 'academystructure_terms.id', '=', 'academystructure_departments.term_id')->select(\DB::raw('CONCAT(academystructure_years.name, "-", academystructure_terms.name) as name, GROUP_CONCAT(DISTINCT(academystructure_departments.subject_ids)) as sid'))->groupBy('academystructure_terms.name', 'academystructure_years.name')->orderBy('academystructure_terms.id', 'desc')->get()->toArray(); $year_term_options; foreach ($year_term as $key => &$aa) { $a = implode(',', array_unique(array_merge(json_decode(str_replace('],[', ',', $aa['sid']), TRUE)))); $year_term_options[$a] = $aa['name']; } $subject_list = Subject::lists('name', 'id')->toArray(); return view('questionbank::subject.index', compact('subjects', 'subject_list', 'year_term_options')); }
public function priorexam(Request $request) { $statistics = ExamResult::whereHas('Exam', function ($q) { $q->whereRaw('exams.start_at > exam_results.enter_at'); })->with('student', 'exam'); if (request('student_id')) { $statistics->whereHas('student', function ($q) use($request) { $q->where('students.id', request('student_id')); }); } if (request('exam_subject')) { $statistics->whereHas('exam', function ($q) use($request) { $q->where('subject_id', request('exam_subject')); }); } if (request('exam_type')) { $statistics->whereHas('exam', function ($q) use($request) { $q->where('type', request('exam_type')); }); } $per_page = request('per_page') ? request('per_page') : 100; $statistics = $statistics->paginate($per_page); $statistics->appends($request->except("page")); $subjects = Subject::lists('name', 'id')->toArray(); return view('exams::reports.priorexam', compact('statistics', 'subjects')); }
public function edit($id) { $exam = Exam::findOrFail($id); $subjects = Subject::lists('name', 'id')->toArray(); $types = config('exams.types'); return view('exams::exams.edit', compact('exam', 'types', 'subjects')); }
public function create(Term $term) { $types = config('subject.types'); $pre_request = Subject::lists('name', 'id')->toArray(); return view('subject::subjects.create', compact('types', 'pre_request')); }