db = $DB; } /** * @param $qid * @param $slot * @return mixed */ public function get_question_attempts($qid, $slot) { return $this->db->get_recordset( 'question_attempts', [ 'questionid' => $qid, 'slot' => $slot ], '', '*' ); } /** * @param $qid * @return mixed */ public function get_reference_answer($qid) { return $this->db->get_record( 'qtype_essay_options', [ 'questionid' => $qid ], '*', MUST_EXIST )->graderinfo; } /** * @param $question_attempt_id * @return mixed */ public function get_attempt_steps($question_attempt_id) { return $this->db->get_recordset( 'question_attempt_steps', [ 'questionattemptid' => $question_attempt_id ], '', '*' ); } /** * @param $attemptstepid * @return mixed */ public function get_student_answer($attemptstepid) { return $this->db->get_record( 'question_attempt_step_data', [ 'attemptstepid' => $attemptstepid, 'name' => 'answer' ], '*', MUST_EXIST )->value; } /** * Checks if scores exist for a given quizid and userid. * * * * @param int $quizid quiz ID. * * @param int $userid user ID. * * @return bool Returns true if scores exist for a given quizid and userid, otherwise false. */ public function gradesExist(int $quizid, int $userid): bool { global $DB; // Check for the presence of an entry in the mdl_quiz_grades table for this quizid and userid return $DB->record_exists( 'quiz_grades', [ 'quiz' => $quizid, 'userid' => $userid ] ); } }