/**
* Show the form for creating a new resource.
*
* @return Response
*/
public function create($subject_id, $class_id)
{
$exams = \App\Exam::all();
$subject = \App\Subject::find($subject_id);
$class = \App\Grade::find($class_id);
return view('reports.create')->with('title', 'SMS|REPORT')->with('class', $class)->with('subject', $subject)->with('exams', $exams);
}
public function listOfstudentsAndMarks()
{
$marksheets = Marksheet::all();
$exams = Exam::all();
return view('marksheet/listOfstudentsAndMarks', compact('marksheets', 'exams'));
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$exams = Exam::all()->sortByDesc('id');
return view('exam.index', compact('exams'));
}
public function listOfstudentsAndMarks($courseId)
{
// dd($courseId);
$marksheets = DB::table('marksheets')->join('users', 'marksheets.trainee_id', '=', 'users.id')->join('role_user', 'marksheets.trainee_id', '=', 'role_user.user_id')->select('marksheets.id', 'marksheets.course_id', 'marksheets.exam_id', 'marksheets.trainee_id', 'marksheets.mark', 'users.name')->where('role_user.role_id', 3)->where('marksheets.course_id', $courseId)->get();
//dd($marksheets);
//$marksheets=Marksheet::all();
$exams = Exam::all();
return view('marksheet/listOfstudentsAndMarks', compact('marksheets', 'exams'));
}
public function index()
{
$exams = $this->exam->all();
return view('exams.index')->with(compact('exams'));
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$exams = Exam::all();
return view('admin/exams/index', compact('exams'));
}