. /** * A {@link qubaid_condition} representing all the attempts by one user at a given quiz. * * @package mod_quiz * @category question * @copyright 2015 The Open University * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later */ namespace mod_quiz\question; defined('MOODLE_INTERNAL') || die(); /** * A {@link qubaid_condition} representing all the attempts by one user at a given quiz. * * @copyright 2015 The Open University * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later */ class qubaids_for_users_attempts extends \qubaid_join { /** * Constructor. * * This takes the same arguments as {@link quiz_get_user_attempts()}. * * @param int $quizid the quiz id. * @param int $userid the userid. * @param string $status 'all', 'finished' or 'unfinished' to control * @param bool $includepreviews defaults to false. */ public function __construct($quizid, $userid, $status = 'finished', $includepreviews = false) { $where = 'quiza.quiz = :quizaquiz AND quiza.userid = :userid'; $params = array('quizaquiz' => $quizid, 'userid' => $userid); if (!$includepreviews) { $where .= ' AND preview = 0'; } switch ($status) { case 'all': break; case 'finished': $where .= ' AND state IN (:state1, :state2)'; $params['state1'] = \quiz_attempt::FINISHED; $params['state2'] = \quiz_attempt::ABANDONED; break; case 'unfinished': $where .= ' AND state IN (:state1, :state2)'; $params['state1'] = \quiz_attempt::IN_PROGRESS; $params['state2'] = \quiz_attempt::OVERDUE; break; } parent::__construct('{quiz_attempts} quiza', 'quiza.uniqueid', $where, $params); } }