Search moodle.org's
Developer Documentation

See Release Notes

  • Bug fixes for general core bugs in 4.3.x will end 7 October 2024 (12 months).
  • Bug fixes for security issues in 4.3.x will end 21 April 2025 (18 months).
  • PHP version: minimum PHP 8.0.0 Note: minimum PHP version has increased since Moodle 4.1. PHP 8.2.x is supported too.

Differences Between: [Versions 310 and 403] [Versions 311 and 403] [Versions 39 and 403] [Versions 400 and 403] [Versions 401 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  namespace mod_quiz\question;
  18  
  19  use mod_quiz\quiz_attempt;
  20  
  21  defined('MOODLE_INTERNAL') || die();
  22  
  23  require_once($CFG->dirroot . '/question/engine/datalib.php');
  24  
  25  /**
  26   * A {@see qubaid_condition} representing all the attempts by one user at a given quiz.
  27   *
  28   * @package   mod_quiz
  29   * @category  question
  30   * @copyright 2015 The Open University
  31   * @license   http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
  32   */
  33  class qubaids_for_users_attempts extends \qubaid_join {
  34      /**
  35       * Constructor.
  36       *
  37       * This takes the same arguments as {@link quiz_get_user_attempts()}.
  38       *
  39       * @param int $quizid the quiz id.
  40       * @param int $userid the userid.
  41       * @param string $status 'all', 'finished' or 'unfinished' to control
  42       * @param bool $includepreviews defaults to false.
  43       */
  44      public function __construct($quizid, $userid, $status = 'finished', $includepreviews = false) {
  45          $where = 'quiza.quiz = :quizaquiz AND quiza.userid = :userid';
  46          $params = ['quizaquiz' => $quizid, 'userid' => $userid];
  47  
  48          if (!$includepreviews) {
  49              $where .= ' AND preview = 0';
  50          }
  51  
  52          switch ($status) {
  53              case 'all':
  54                  break;
  55  
  56              case 'finished':
  57                  $where .= ' AND state IN (:state1, :state2)';
  58                  $params['state1'] = quiz_attempt::FINISHED;
  59                  $params['state2'] = quiz_attempt::ABANDONED;
  60                  break;
  61  
  62              case 'unfinished':
  63                  $where .= ' AND state IN (:state1, :state2)';
  64                  $params['state1'] = quiz_attempt::IN_PROGRESS;
  65                  $params['state2'] = quiz_attempt::OVERDUE;
  66                  break;
  67          }
  68  
  69          parent::__construct('{quiz_attempts} quiza', 'quiza.uniqueid', $where, $params);
  70      }
  71  }