2 // This file is part of Moodle - http://moodle.org/
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.
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.
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/>.
18 * This is filter is used to see which students are enroled on any courses
21 * @copyright 2014 Krister Viirsaar
22 * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
25 defined('MOODLE_INTERNAL') ||
die();
28 * User filter to distinguish users with no or any enroled courses.
29 * @copyright 2014 Krister Viirsaar
30 * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
32 class user_filter_anycourses
extends user_filter_yesno
{
35 * Returns the condition to be used with SQL
37 * @param array $data filter settings
38 * @return array sql string and $params
40 public function get_sql_filter($data) {
41 $value = $data['value'];
43 $not = $value ?
'' : 'NOT';
45 return array("EXISTS ( SELECT userid FROM {user_enrolments} ) AND " .
46 " id $not IN ( SELECT userid FROM {user_enrolments} )", array());