user/filters/lib.php

   1 <?php //$Id$
   2
   3 require_once($CFG->dirroot.'/user/filters/text.php');
   4 require_once($CFG->dirroot.'/user/filters/date.php');
   5 require_once($CFG->dirroot.'/user/filters/select.php');
   6 require_once($CFG->dirroot.'/user/filters/simpleselect.php');
   7 require_once($CFG->dirroot.'/user/filters/courserole.php');
   8 require_once($CFG->dirroot.'/user/filters/globalrole.php');
   9 require_once($CFG->dirroot.'/user/filters/profilefield.php');
  10 require_once($CFG->dirroot.'/user/filters/yesno.php');
  11 require_once($CFG->dirroot.'/user/filters/user_filter_forms.php');
  12
  13
  14 /**
  15  * User filtering wrapper class.
  16  */
  17 class user_filtering {
  18     var $_fields;
  19     var $_addform;
  20     var $_activeform;
  21
  22     /**
  23      * Contructor
  24      * @param array array of visible user fields
  25      * @param string base url used for submission/return, null if the same of current page
  26      * @param array extra page parameters
  27      */
  28     function user_filtering($fieldnames=null, $baseurl=null, $extraparams=null) {
  29         global $SESSION;
  30
  31         if (!isset($SESSION->user_filtering)) {
  32             $SESSION->user_filtering = array();
  33         }
  34
  35         if (empty($fieldnames)) {
  36             $fieldnames = array('realname'=>0, 'lastname'=>1, 'firstname'=>1, 'email'=>1, 'city'=>1, 'country'=>1,
  37                                 'confirmed'=>1, 'profile'=>1, 'courserole'=>1, 'systemrole'=>1,
  38                                 'firstaccess'=>1, 'lastaccess'=>1, 'lastlogin'=>1, 'username'=>1, 'auth'=>1, 'mnethostid'=>1);
  39         }
  40
  41         $this->_fields  = array();
  42
  43         foreach ($fieldnames as $fieldname=>$advanced) {
  44             if ($field = $this->get_field($fieldname, $advanced)) {
  45                 $this->_fields[$fieldname] = $field;
  46             }
  47         }
  48
  49         // fist the new filter form
  50         $this->_addform = new user_add_filter_form($baseurl, array('fields'=>$this->_fields, 'extraparams'=>$extraparams));
  51         if ($adddata = $this->_addform->get_data(false)) {
  52             foreach($this->_fields as $fname=>$field) {
  53                 $data = $field->check_data($adddata);
  54                 if ($data === false) {
  55                     continue; // nothing new
  56                 }
  57                 if (!array_key_exists($fname, $SESSION->user_filtering)) {
  58                     $SESSION->user_filtering[$fname] = array();
  59                 }
  60                 $SESSION->user_filtering[$fname][] = $data;
  61             }
  62             // clear the form
  63             $_POST = array();
  64             $this->_addform = new user_add_filter_form($baseurl, array('fields'=>$this->_fields, 'extraparams'=>$extraparams));
  65         }
  66
  67         // now the active filters
  68         $this->_activeform = new user_active_filter_form($baseurl, array('fields'=>$this->_fields, 'extraparams'=>$extraparams));
  69         if ($adddata = $this->_activeform->get_data(false)) {
  70             if (!empty($adddata->removeall)) {
  71                 $SESSION->user_filtering = array();
  72
  73             } else if (!empty($adddata->removeselected) and !empty($adddata->filter)) {
  74                 foreach($adddata->filter as $fname=>$instances) {
  75                     foreach ($instances as $i=>$val) {
  76                         if (empty($val)) {
  77                             continue;
  78                         }
  79                         unset($SESSION->user_filtering[$fname][$i]);
  80                     }
  81                     if (empty($SESSION->user_filtering[$fname])) {
  82                         unset($SESSION->user_filtering[$fname]);
  83                     }
  84                 }
  85             }
  86             // clear+reload the form
  87             $_POST = array();
  88             $this->_activeform = new user_active_filter_form($baseurl, array('fields'=>$this->_fields, 'extraparams'=>$extraparams));
  89         }
  90         // now the active filters
  91     }
  92
  93     /**
  94      * Creates known user filter if present
  95      * @param string $fieldname
  96      * @param boolean $advanced
  97      * @return object filter
  98      */
  99     function get_field($fieldname, $advanced) {
 100         global $USER, $CFG, $SITE;
 101
 102         switch ($fieldname) {
 103             case 'username':    return new user_filter_text('username', get_string('username'), $advanced, 'username');
 104             case 'realname':    return new user_filter_text('realname', get_string('fullname'), $advanced, sql_fullname());
 105             case 'lastname':    return new user_filter_text('lastname', get_string('lastname'), $advanced, 'lastname');
 106             case 'firstname':    return new user_filter_text('firstname', get_string('firstname'), $advanced, 'firstname');
 107             case 'email':       return new user_filter_text('email', get_string('email'), $advanced, 'email');
 108             case 'city':        return new user_filter_text('city', get_string('city'), $advanced, 'city');
 109             case 'country':     return new user_filter_select('country', get_string('country'), $advanced, 'country', get_list_of_countries(), $USER->country);
 110             case 'confirmed':   return new user_filter_yesno('confirmed', get_string('confirmed', 'admin'), $advanced, 'confirmed');
 111             case 'profile':     return new user_filter_profilefield('profile', get_string('profile'), $advanced);
 112             case 'courserole':  return new user_filter_courserole('courserole', get_string('courserole', 'filters'), $advanced);
 113             case 'systemrole':  return new user_filter_globalrole('systemrole', get_string('globalrole', 'role'), $advanced);
 114             case 'firstaccess': return new user_filter_date('firstaccess', get_string('firstaccess', 'filters'), $advanced, 'firstaccess');
 115             case 'lastaccess':  return new user_filter_date('lastaccess', get_string('lastaccess'), $advanced, 'lastaccess');
 116             case 'lastlogin':   return new user_filter_date('lastlogin', get_string('lastlogin'), $advanced, 'lastlogin');
 117             case 'auth':
 118                 $plugins = get_list_of_plugins('auth');
 119                 $choices = array();
 120                 foreach ($plugins as $auth) {
 121                     $choices[$auth] = auth_get_plugin_title ($auth);
 122                 }
 123                 return new user_filter_simpleselect('auth', get_string('authentication'), $advanced, 'auth', $choices);
 124
 125             case 'mnethostid':
 126                 // include all hosts even those deleted or otherwise problematic
 127                 if (!$hosts = get_records('mnet_host', '', '', 'id', 'id, wwwroot, name')) {
 128                     $hosts = array();
 129                 }
 130                 $choices = array();
 131                 foreach ($hosts as $host) {
 132                     if ($host->id == $CFG->mnet_localhost_id) {
 133                         $choices[$host->id] =  format_string($SITE->fullname).' ('.get_string('local').')';
 134                     } else if (empty($host->wwwroot)) {
 135                         // All hosts
 136                         continue;
 137                     } else {
 138                         $choices[$host->id] = $host->name.' ('.$host->wwwroot.')';
 139                     }
 140                 }
 141                 if ($usedhosts = get_fieldset_sql("SELECT DISTINCT mnethostid FROM {$CFG->prefix}user WHERE deleted=0")) {
 142                     foreach ($usedhosts as $hostid) {
 143                         if (empty($hosts[$hostid])) {
 144                             $choices[$hostid] = 'id: '.$hostid.' ('.get_string('error').')';
 145                         }
 146                     }
 147                 }
 148                 if (count($choices) < 2) {
 149                     return null; // filter not needed
 150                 }
 151                 return new user_filter_simpleselect('mnethostid', 'mnethostid', $advanced, 'mnethostid', $choices);
 152
 153             default:            return null;
 154         }
 155     }
 156
 157     /**
 158      * Returns sql where statement based on active user filters
 159      * @param string $extra sql
 160      * @return string
 161      */
 162     function get_sql_filter($extra='') {
 163         global $SESSION;
 164
 165         $sqls = array();
 166         if ($extra != '') {
 167             $sqls[] = $extra;
 168         }
 169
 170         if (!empty($SESSION->user_filtering)) {
 171             foreach ($SESSION->user_filtering as $fname=>$datas) {
 172                 if (!array_key_exists($fname, $this->_fields)) {
 173                     continue; // filter not used
 174                 }
 175                 $field = $this->_fields[$fname];
 176                 foreach($datas as $i=>$data) {
 177                     $sqls[] = $field->get_sql_filter($data);
 178                 }
 179             }
 180         }
 181
 182         if (empty($sqls)) {
 183             return '';
 184         } else {
 185             return implode(' AND ', $sqls);
 186         }
 187     }
 188
 189     /**
 190      * Print the add filter form.
 191      */
 192     function display_add() {
 193         $this->_addform->display();
 194     }
 195
 196     /**
 197      * Print the active filter form.
 198      */
 199     function display_active() {
 200         $this->_activeform->display();
 201     }
 202
 203 }
 204
 205 /**
 206  * The base user filter class. All abstract classes must be implemented.
 207  */
 208 class user_filter_type {
 209     /**
 210      * The name of this filter instance.
 211      */
 212     var $_name;
 213
 214     /**
 215      * The label of this filter instance.
 216      */
 217     var $_label;
 218
 219     /**
 220      * Advanced form element flag
 221      */
 222     var $_advanced;
 223
 224     /**
 225      * Constructor
 226      * @param string $name the name of the filter instance
 227      * @param string $label the label of the filter instance
 228      * @param boolean $advanced advanced form element flag
 229      */
 230     function user_filter_type($name, $label, $advanced) {
 231         $this->_name     = $name;
 232         $this->_label    = $label;
 233         $this->_advanced = $advanced;
 234     }
 235
 236     /**
 237      * Returns the condition to be used with SQL where
 238      * @param array $data filter settings
 239      * @return string the filtering condition or null if the filter is disabled
 240      */
 241     function get_sql_filter($data) {
 242         error('Abstract method get_sql_filter() called - must be implemented');
 243     }
 244
 245     /**
 246      * Retrieves data from the form data
 247      * @param object $formdata data submited with the form
 248      * @return mixed array filter data or false when filter not set
 249      */
 250     function check_data($formdata) {
 251         error('Abstract method check_data() called - must be implemented');
 252     }
 253
 254     /**
 255      * Adds controls specific to this filter in the form.
 256      * @param object $mform a MoodleForm object to setup
 257      */
 258     function setupForm(&$mform) {
 259         error('Abstract method setupForm() called - must be implemented');
 260     }
 261
 262     /**
 263      * Returns a human friendly description of the filter used as label.
 264      * @param array $data filter settings
 265      * @return string active filter label
 266      */
 267     function get_label($data) {
 268         error('Abstract method get_label() called - must be implemented');
 269     }
 270 }