[Summary view]

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  /**
  18   * Potential admin user selector.
  19   *
  20   * @package    core_role
  21   * @copyright  2010 Petr Skoda {@link http://skodak.org}
  22   * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
  23   */
  24  
  25  defined('MOODLE_INTERNAL') || die();
  26  
  27  require_once($CFG->dirroot.'/user/selector/lib.php');
  28  
  29  class core_role_admins_potential_selector extends user_selector_base {
  30      /**
  31       * Create instance.
  32       *
  33       * @param string $name control name
  34       * @param array $options should have two elements with keys groupid and courseid.
  35       */
  36      public function __construct($name = null, $options = array()) {
  37          global $CFG;
  38          if (is_null($name)) {
  39              $name = 'addselect';
  40          }
  41          $options['includecustomfields'] = true;
  42          $options['exclude'] = explode(',', $CFG->siteadmins);
  43          parent::__construct($name, $options);
  44      }
  45  
  46      public function find_users($search) {
  47          global $CFG, $DB;
  48  
  49          [$wherecondition, $params] = $this->search_sql($search, 'u');
  50          $params = array_merge($params, $this->userfieldsparams);
  51  
  52          $fields = 'SELECT u.id, ' . $this->userfieldsselects;
  53          $countfields = 'SELECT COUNT(1)';
  54  
  55          $sql = " FROM {user} u
  56                        $this->userfieldsjoin
  57                  WHERE $wherecondition AND mnethostid = :localmnet";
  58  
  59          // It could be dangerous to make remote users admins and also this could lead to other problems.
  60          $params['localmnet'] = $CFG->mnet_localhost_id;
  61  
  62          [$sort, $sortparams] = users_order_by_sql('u', $search, $this->accesscontext, $this->userfieldsmappings);
  63          $order = ' ORDER BY ' . $sort;
  64  
  65          // Check to see if there are too many to show sensibly.
  66          if (!$this->is_validating()) {
  67              $potentialcount = $DB->count_records_sql($countfields . $sql, $params);
  68              if ($potentialcount > $this->maxusersperpage) {
  69                  return $this->too_many_results($search, $potentialcount);
  70              }
  71          }
  72  
  73          $availableusers = $DB->get_records_sql($fields . $sql . $order, array_merge($params, $sortparams));
  74  
  75          if (empty($availableusers)) {
  76              return array();
  77          }
  78  
  79          if ($search) {
  80              $groupname = get_string('potusersmatching', 'core_role', $search);
  81          } else {
  82              $groupname = get_string('potusers', 'core_role');
  83          }
  84  
  85          return array($groupname => $availableusers);
  86      }
  87  
  88      protected function get_options() {
  89          global $CFG;
  90          $options = parent::get_options();
  91          $options['file'] = $CFG->admin . '/roles/lib.php';
  92          return $options;
  93      }
  94  }