Search moodle.org's
Developer Documentation

See Release Notes

  • Bug fixes for general core bugs in 4.0.x will end 8 May 2023 (12 months).
  • Bug fixes for security issues in 4.0.x will end 13 November 2023 (18 months).
  • PHP version: minimum PHP 7.3.0 Note: the minimum PHP version has increased since Moodle 3.10. PHP 7.4.x is also supported.

Differences Between: [Versions 310 and 400] [Versions 311 and 400] [Versions 39 and 400] [Versions 400 and 402] [Versions 400 and 403]

   1  <?php
   2  // This file is part of Moodle - http://moodle.org/
   3  //
   4  // Moodle is free software: you can redistribute it and/or modify
   5  // it under the terms of the GNU General Public License as published by
   6  // the Free Software Foundation, either version 3 of the License, or
   7  // (at your option) any later version.
   8  //
   9  // Moodle is distributed in the hope that it will be useful,
  10  // but WITHOUT ANY WARRANTY; without even the implied warranty of
  11  // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  12  // GNU General Public License for more details.
  13  //
  14  // You should have received a copy of the GNU General Public License
  15  // along with Moodle.  If not, see <http://www.gnu.org/licenses/>.
  16  
  17  /**
  18   * A {@link qubaid_condition} representing all the attempts by one user at a given quiz.
  19   *
  20   * @package   mod_quiz
  21   * @category  question
  22   * @copyright 2015 The Open University
  23   * @license   http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
  24   */
  25  
  26  namespace mod_quiz\question;
  27  
  28  defined('MOODLE_INTERNAL') || die();
  29  
  30  require_once($CFG->dirroot.'/mod/quiz/attemptlib.php');
  31  
  32  /**
  33   * A {@link qubaid_condition} representing all the attempts by one user at a given quiz.
  34   *
  35   * @copyright 2015 The Open University
  36   * @license   http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
  37   */
  38  class qubaids_for_users_attempts extends \qubaid_join {
  39      /**
  40       * Constructor.
  41       *
  42       * This takes the same arguments as {@link quiz_get_user_attempts()}.
  43       *
  44       * @param int $quizid the quiz id.
  45       * @param int $userid the userid.
  46       * @param string $status 'all', 'finished' or 'unfinished' to control
  47       * @param bool $includepreviews defaults to false.
  48       */
  49      public function __construct($quizid, $userid, $status = 'finished', $includepreviews = false) {
  50          $where = 'quiza.quiz = :quizaquiz AND quiza.userid = :userid';
  51          $params = array('quizaquiz' => $quizid, 'userid' => $userid);
  52  
  53          if (!$includepreviews) {
  54              $where .= ' AND preview = 0';
  55          }
  56  
  57          switch ($status) {
  58              case 'all':
  59                  break;
  60  
  61              case 'finished':
  62                  $where .= ' AND state IN (:state1, :state2)';
  63                  $params['state1'] = \quiz_attempt::FINISHED;
  64                  $params['state2'] = \quiz_attempt::ABANDONED;
  65                  break;
  66  
  67              case 'unfinished':
  68                  $where .= ' AND state IN (:state1, :state2)';
  69                  $params['state1'] = \quiz_attempt::IN_PROGRESS;
  70                  $params['state2'] = \quiz_attempt::OVERDUE;
  71                  break;
  72          }
  73  
  74          parent::__construct('{quiz_attempts} quiza', 'quiza.uniqueid', $where, $params);
  75      }
  76  }