/**
* Check if a quiz has stored grades
*
* @return boolean
*/
public function noGrades()
{
if (Grade::where('quiz_id', '=', $this->id)->get()->count() == 0) {
return TRUE;
} else {
return FALSE;
}
}
public function upload_grade(Request $request)
{
$this->validate($request, Grade::rules());
$grade = Grade::where('user_id', $request->user_id)->first();
$grade->math = $request->math;
$grade->english = $request->english;
$grade->c = $request->c;
$grade->sport = $request->sport;
$grade->think = $request->think;
$grade->soft = $request->soft;
$grade->save();
session()->flash('message', '成绩提交成功');
return Redirect::back();
}
/**
* Responds to request to GET /status/{id}
*/
public function getStatus($id)
{
$quiz = Quiz::find($id);
if ($quiz->ready) {
if (Grade::where('quiz_id', '=', $quiz->id)->get()->count() != 0) {
\Session::flash('flash_message', 'Quiz has stored grades!');
}
$quiz->ready = FALSE;
} else {
// check quiz for warnings
$warnings = $quiz->warnings();
if ($warnings->count() == 0) {
$quiz->ready = TRUE;
} else {
return view('edit.quiz')->with('quiz', $quiz)->with('warnings', $warnings);
}
}
$quiz->save();
return redirect('/edit/' . $quiz->id);
}
public function getclassforcreche()
{
if (\Request::ajax()) {
$grade_id = \Input::get('grade_id');
$grade = Grade::where('id', $grade_id)->first();
foreach ($grade->classrooms as $cr) {
echo '<option value="' . $cr->id . '">' . $cr->nom_classe . '</option>';
}
}
}
/**
* Delete a student registration request
*
* @param Request $request
* @return \Illuminate\Http\RedirectResponse
*/
public function deleteRequest(Request $request)
{
$rollNo = $request['rollNo'];
// Delete the request from all associated tables
AllocatedElective::where('rollNo', $rollNo)->delete();
Grade::where('rollNo', $rollNo)->delete();
HostelStaffRequest::destroy($rollNo);
TeacherRequest::destroy($rollNo);
AdminStaffRequest::destroy($rollNo);
LibraryStaffRequest::destroy($rollNo);
ChiefWardenStaffRequest::destroy($rollNo);
// If the student has been verified, then decrement his/her semester
if (CurrentStudentState::find($rollNo)->approved == true) {
$student = Student::find($rollNo);
$student->semNo = $student->semNo - 1;
$student->save();
}
CurrentStudentState::destroy($rollNo);
return redirect('/teachers/semesterRegistration/studentRequests/all');
}
public function show()
{
$grade = Grade::where('school_id', '=', Input::get('school_id'))->get();
return json_encode($grade);
}
public function index()
{
$subjects = Subject::where('department_id', Auth::user()->department_id)->lists('id');
$grades = Grade::where('approved_status', 0)->whereIn('subject_id', $subjects)->get();
return view('programhead.index', compact('grades'));
}
/**
* Responds to requests to POST /quizzes/{id}
*/
public function postQuizzesResult($id, Request $request)
{
// delete zero grade for validation
$grade = Grade::where('quiz_id', $id)->where('user_id', Auth::user()->id)->first();
$grade->taken = FALSE;
$grade->save();
$request->all();
// get quiz for validation
$quiz = Quiz::find($id);
// custom message
$messages = array('required' => 'You must answer all questions!');
// make sure each question that is part of the quiz is in the request
foreach ($quiz->question as $question) {
$this->validate($request, ['answer_for_question.' . $question->id => 'required'], $messages);
}
// Grades quiz
$correct_answers = 0;
foreach ($request['answer_for_question'] as $answer) {
$correct = Answer::find($answer);
if ($correct->correct) {
$correct_answers++;
}
}
$score = $correct_answers / $quiz->numberOfQuestions() * 100;
// store grade in grades_table
$grade = Grade::where('quiz_id', $id)->where('user_id', Auth::user()->id)->first();
$grade->grade = $score;
$grade->taken = TRUE;
$grade->save();
return view('quiz.result')->with('quiz', $quiz)->with('score', $score);
}
