[Summary view] [Print] [Text view]

   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   * Course role filter
  19   *
  20   * @package   core_user
  21   * @category  user
  22   * @copyright 1999 Martin Dougiamas  http://dougiamas.com
  23   * @license   http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
  24   */
  25  
  26  require_once($CFG->dirroot .'/user/filters/lib.php');
  27  
  28  /**
  29   * User filter based on roles in a course identified by its shortname.
  30   * @copyright 1999 Martin Dougiamas  http://dougiamas.com
  31   * @license   http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
  32   */
  33  class user_filter_courserole extends user_filter_type {
  34      /**
  35       * Constructor
  36       * @param string $name the name of the filter instance
  37       * @param string $label the label of the filter instance
  38       * @param boolean $advanced advanced form element flag
  39       */
  40      public function __construct($name, $label, $advanced) {
  41          parent::__construct($name, $label, $advanced);
  42      }
  43  
  44      /**
  45       * Old syntax of class constructor. Deprecated in PHP7.
  46       *
  47       * @deprecated since Moodle 3.1
  48       */
  49      public function user_filter_courserole($name, $label, $advanced) {
  50          debugging('Use of class name as constructor is deprecated', DEBUG_DEVELOPER);
  51          self::__construct($name, $label, $advanced);
  52      }
  53  
  54      /**
  55       * Returns an array of available roles
  56       * @return array of availble roles
  57       */
  58      public function get_roles() {
  59          $context = context_system::instance();
  60          $roles = array(0 => get_string('anyrole', 'filters')) + get_default_enrol_roles($context);
  61          return $roles;
  62      }
  63  
  64      /**
  65       * Returns an array of course categories
  66       * @return array of course categories
  67       */
  68      public function get_course_categories() {
  69          global $CFG;
  70          require_once($CFG->libdir.'/coursecatlib.php');
  71          return array(0 => get_string('anycategory', 'filters')) + coursecat::make_categories_list();
  72      }
  73  
  74      /**
  75       * Adds controls specific to this filter in the form.
  76       * @param moodleform $mform a MoodleForm object to setup
  77       */
  78      public function setupForm(&$mform) {
  79          $objs = array();
  80          $objs['role'] = $mform->createElement('select', $this->_name .'_rl', null, $this->get_roles());
  81          $objs['role']->setLabel(get_string('courserole', 'filters'));
  82          $objs['category'] = $mform->createElement('select', $this->_name .'_ct', null, $this->get_course_categories());
  83          $objs['category']->setLabel(get_string('coursecategory', 'filters'));
  84          $objs['value'] = $mform->createElement('text', $this->_name, null);
  85          $objs['value']->setLabel(get_string('coursevalue', 'filters'));
  86          $grp =& $mform->addElement('group', $this->_name.'_grp', $this->_label, $objs, '', false);
  87          $mform->setType($this->_name, PARAM_TEXT);
  88          if ($this->_advanced) {
  89              $mform->setAdvanced($this->_name.'_grp');
  90          }
  91      }
  92  
  93      /**
  94       * Retrieves data from the form data
  95       * @param stdClass $formdata data submited with the form
  96       * @return mixed array filter data or false when filter not set
  97       */
  98      public function check_data($formdata) {
  99          $field    = $this->_name;
 100          $role     = $field .'_rl';
 101          $category = $field .'_ct';
 102  
 103          if (array_key_exists($field, $formdata)) {
 104              if (empty($formdata->$field) and empty($formdata->$role) and empty($formdata->$category)) {
 105                  // Nothing selected.
 106                  return false;
 107              }
 108              return array('value'      => (string)$formdata->$field,
 109                           'roleid'     => (int)$formdata->$role,
 110                           'categoryid' => (int)$formdata->$category);
 111          }
 112          return false;
 113      }
 114  
 115      /**
 116       * Returns the condition to be used with SQL where
 117       * @param array $data filter settings
 118       * @return array sql string and $params
 119       */
 120      public function get_sql_filter($data) {
 121          global $CFG, $DB;
 122          static $counter = 0;
 123          $pref = 'ex_courserole'.($counter++).'_';
 124  
 125          $value      = $data['value'];
 126          $roleid     = $data['roleid'];
 127          $categoryid = $data['categoryid'];
 128  
 129          $params = array();
 130  
 131          if (empty($value) and empty($roleid) and empty($categoryid)) {
 132              return array('', $params);
 133          }
 134  
 135          $where = "b.contextlevel=50";
 136          if ($roleid) {
 137              $where .= " AND a.roleid = :{$pref}roleid";
 138              $params[$pref.'roleid'] = $roleid;
 139          }
 140          if ($categoryid) {
 141              $where .= " AND c.category = :{$pref}categoryid";
 142              $params[$pref.'categoryid'] = $categoryid;
 143          }
 144          if ($value) {
 145              $where .= " AND c.shortname = :{$pref}course";
 146              $params[$pref.'course'] = $value;
 147          }
 148          return array("id IN (SELECT userid
 149                                 FROM {role_assignments} a
 150                           INNER JOIN {context} b ON a.contextid=b.id
 151                           INNER JOIN {course} c ON b.instanceid=c.id
 152                                WHERE $where)", $params);
 153      }
 154  
 155      /**
 156       * Returns a human friendly description of the filter used as label.
 157       * @param array $data filter settings
 158       * @return string active filter label
 159       */
 160      public function get_label($data) {
 161          global $DB;
 162  
 163          $value      = $data['value'];
 164          $roleid     = $data['roleid'];
 165          $categoryid = $data['categoryid'];
 166  
 167          $a = new stdClass();
 168          $a->label = $this->_label;
 169  
 170          if ($roleid) {
 171              $role = $DB->get_record('role', array('id' => $roleid));
 172              $a->rolename = '"'.role_get_name($role).'"';
 173          } else {
 174              $a->rolename = get_string('anyrole', 'filters');
 175          }
 176  
 177          if ($categoryid) {
 178              $catname = $DB->get_field('course_categories', 'name', array('id' => $categoryid));
 179              $a->categoryname = '"'.format_string($catname).'"';
 180          } else {
 181              $a->categoryname = get_string('anycategory', 'filters');
 182          }
 183  
 184          if ($value) {
 185              $a->coursename = '"'.s($value).'"';
 186              if (!$DB->record_exists('course', array('shortname' => $value))) {
 187                  return '<span class="notifyproblem">'.get_string('courserolelabelerror', 'filters', $a).'</span>';
 188              }
 189          } else {
 190              $a->coursename = get_string('anycourse', 'filters');
 191          }
 192  
 193          return get_string('courserolelabel', 'filters', $a);
 194      }
 195  }