[Summary view]

   1  <?php
   2  // This file is part of Moodle - https://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   * Provides {@link testable_user_selector} class.
  19   *
  20   * @package     core_user
  21   * @subpackage  fixtures
  22   * @category    test
  23   * @copyright   2018 David Mudrák <david@moodle.com>
  24   * @license     http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
  25   */
  26  
  27  defined('MOODLE_INTERNAL') || die();
  28  
  29  /**
  30   * Testable subclass of the user selector base class.
  31   *
  32   * @copyright 2018 David Mudrák <david@moodle.com>
  33   * @license   http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
  34   */
  35  class testable_user_selector extends user_selector_base {
  36  
  37      /**
  38       * Basic implementation of the users finder.
  39       *
  40       * @param string $search
  41       * @return array of (string)optgroupname => array of users
  42       */
  43      public function find_users($search) {
  44          global $DB;
  45  
  46          list($wherecondition, $whereparams) = $this->search_sql($search, 'u');
  47          list($sort, $sortparams) = users_order_by_sql('u', $search, $this->accesscontext);
  48          $params = array_merge($whereparams, $sortparams);
  49          $fields = $this->required_fields_sql('u');
  50  
  51          $sql = "SELECT $fields
  52                    FROM {user} u
  53                   WHERE $wherecondition
  54                ORDER BY $sort";
  55  
  56          $found = $DB->get_records_sql($sql, $params);
  57  
  58          if (empty($found)) {
  59              return [];
  60          }
  61  
  62          return [get_string('potusers', 'core_role') => $found];
  63      }
  64  
  65  }