/**
* @desc get all question per subject
* @parm $id int = subject id
* @return list of q view
**/
public function question($subjectid = 0, Request $request)
{
$exams = Exam::where('subject_id', $subjectid)->where('semester_id', semester()->id)->pluck('name', 'id')->toArray();
$questions = Question::select('exam_questions.id as is_attached', 'question', 'questionbank_questions.type', 'difficulty', 'level', 'questionbank_questions.id', 'subject_lessons.name as lesson_name')->join('subject_lessons', 'subject_lessons.id', '=', 'questionbank_questions.lesson_id')->join('subject_subjects', 'subject_subjects.id', '=', 'subject_lessons.subject_subject_id')->leftJoin('exam_questions', 'exam_questions.question_id', '=', 'questionbank_questions.id')->where('subject_subjects.id', $subjectid)->orderBy('id', 'desc');
$per_page = request('per_page') ? request('per_page') : 10;
if ($request->has('from_date')) {
$questions->whereDate('questionbank_questions.created_at', '>=', $request->input('from_date'));
}
if ($request->has('to_date')) {
$questions->whereDate('questionbank_questions.created_at', '<=', $request->input('to_date'));
}
if ($request->has('question')) {
$questions->where('questionbank_questions.question', 'LIKE', '%' . $request->input('question') . '%');
}
$questions = $questions->paginate($per_page);
$questions->appends($request->except("page"));
$Subject = Subject::findOrFail($subjectid);
return view('questionbank::subject.question', compact('questions', 'subjectid', 'Subject', 'exams'));
}
public function activitiessubject()
{
# code...
//$subject_name=Subject::findOrFail($subject_id)->toArray();
$activities = Exam::where('creatable_id', teacher()->id)->where('creatable_type', 'teachers')->where('type', 'activity')->where('semester_id', semester()->id)->get();
return view('teachers::profile.activitiessubject', compact('activities'));
}
