quizquery.php

<?php
namespace local_asystgrade\db;

class quizquery implements quizquery_interface
{
    private $db;

    public function __construct() {
        global $DB;
        $this->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
            ]
        );
    }

    public function get_attempts_and_steps($qid, $slot) {
        return $this->db->get_records_sql("
       SELECT qa.*, qs.*, qasd.*
       FROM {question_attempts} qa
       JOIN {question_attempt_steps} qs ON qa.id = qs.questionattemptid
       LEFT JOIN {question_attempt_step_data} qasd ON qs.id = qasd.attemptstepid
       WHERE qa.questionid = :qid AND qa.slot = :slot
       AND qasd.name = 'answer' AND qs.state = 'complete'", ['qid' => $qid, 'slot' => $slot]);
    }
}