dirroot.'/user/filters/lib.php'); /** * Generic filter based on a list of values. */ class user_filter_simpleselect extends user_filter_type { /** * options for the list values */ var $_options; var $_field; /** * Constructor * @param string $name the name of the filter instance * @param string $label the label of the filter instance * @param boolean $advanced advanced form element flag * @param string $field user table filed name * @param array $options select options */ function user_filter_simpleselect($name, $label, $advanced, $field, $options) { parent::user_filter_type($name, $label, $advanced); $this->_field = $field; $this->_options = $options; } /** * Adds controls specific to this filter in the form. * @param object $mform a MoodleForm object to setup */ function setupForm(&$mform) { $choices = array(''=>get_string('anyvalue', 'filters')) + $this->_options; $mform->addElement('select', $this->_name, $this->_label, $choices); if ($this->_advanced) { $mform->setAdvanced($this->_name); } } /** * Retrieves data from the form data * @param object $formdata data submited with the form * @return mixed array filter data or false when filter not set */ function check_data($formdata) { $field = $this->_name; if (array_key_exists($field, $formdata) and $formdata->$field !== '') { return array('value'=>(string)$formdata->$field); } return false; } /** * Returns the condition to be used with SQL where * @param array $data filter settings * @return array sql string and $params */ function get_sql_filter($data) { static $counter = 0; $name = 'ex_simpleselect'.$counter++; $value = $data['value']; $params = array(); $field = $this->_field; if ($value == '') { return ''; } return array("$field=:$name", array($name=>$value)); } /** * Returns a human friendly description of the filter used as label. * @param array $data filter settings * @return string active filter label */ function get_label($data) { $value = $data['value']; $a = new stdClass(); $a->label = $this->_label; $a->value = '"'.s($this->_options[$value]).'"'; $a->operator = get_string('isequalto','filters'); return get_string('selectlabel', 'filters', $a); } }