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