/** * Display the specified resource. * * @param int $id * @return Response */ public function show($id) { $course = Course::findOrFail($id); if (\Auth::user()->role_id == 3) { $is_professor = true; $professor = DB::table('professors')->join('users', 'professors.user_id', '=', 'users.id')->where('users.id', '=', \Auth::user()->id)->first(); $lectures = DB::table('lectures')->where('course_id', '=', $id)->get(); return view('shared.course_detail', compact('course', 'is_professor', 'professor', 'course', 'lectures')); } if (\Auth::user()->role_id == 4) { $courses = DB::table('courses')->join('institutions', 'institutions.id', '=', 'courses.inst_id')->join('professors', 'professors.prof_id', '=', 'courses.prof_id')->where('courses.id', '=', $id)->first(); $student_id = Student::where('user_id', '=', \Auth::user()->id)->first()->id; $student_course = StudentCourses::where('student_id', '=', $student_id)->where('course_id', '=', $id)->first(); if ($student_course) { $is_enrolled = true; } else { $is_enrolled = false; } $lectures = DB::table('lectures')->where('course_id', '=', $id)->get(); $is_student = true; return view('course.view_one', compact('courses', 'is_student', 'is_enrolled', 'lectures')); } }
public function enroll(Request $request) { $student_id = Student::where('user_id', '=', \Auth::user()->id)->first()->id; $query = StudentCourses::create(['student_id' => $student_id, 'course_id' => $request->course_id]); return redirect('course/' . $request->course_id); }