public function index()
{
$user = Auth::guard('api_student')->user();
$lessons = Lesson::select('sl.id', 'sl.name', 'sl.subject_subject_id', 'sl.lesson_order', 'sl.type', 'sl.state')->join('subject_subjects as ss', 'ss.id', '=', 'sl.subject_subject_id')->join('student_subjects as stusub', function ($j) use($user) {
$j->on('stusub.subject_id', '=', 'ss.id')->where('student_id', '=', $user->id)->where('semester_id', '=', semester()->id);
})->from('subject_lessons as sl')->groupBy('sl.id')->get();
return response()->json($lessons, 200, [], JSON_NUMERIC_CHECK);
}
public function subjectlesson($subject_id = 0, $lesson_id = 0)
{
# code...
$subject_name = Subject::findOrFail($subject_id)->toArray();
//$lessons = Subject::findOrFail($subject_id)->lessons()->with('elements')->get();
$lessons = Lesson::select('id', 'name', 'subject_subject_id')->from('subject_lessons as sl')->where('subject_subject_id', $subject_id)->orderBy('lesson_order')->get();
$lesson_active = Lesson::select('id', 'name', 'subject_subject_id')->from('subject_lessons as sl')->where('subject_subject_id', $subject_id)->where('id', $lesson_id)->orderBy('lesson_order')->with('elements')->get();
return view('teachers::profile.subjectlessons', compact('lessons', 'subject_id', 'subject_name', 'lesson_active'));
}
