[Summary view]

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