field->id, 'recordid', $recordid); $content = trim($content); } else { $content = ''; } $str = '

'; $rawoptions = explode("\n",$this->field->param1); foreach ($rawoptions as $option) { $option = trim($option); if ($option) { $options[$option] = $option; } } $str .= choose_from_menu($options, 'field_'.$this->field->id, $content, get_string('menuchoose', 'data'), '', '', true, false, 0, 'field_'.$this->field->id); $str .= '

'; return $str; } function display_search_field($content = '') { global $CFG; $usedoptions = array(); $sql = "SELECT DISTINCT content FROM {$CFG->prefix}data_content WHERE fieldid={$this->field->id} AND content IS NOT NULL"; if ($used = get_records_sql($sql)) { foreach ($used as $data) { $value = $data->content; if ($value === '') { continue; } $usedoptions[$value] = $value; } } $options = array(); foreach (explode("\n",$this->field->param1) as $option) { $option = trim($option); if (!isset($usedoptions[$option])) { continue; } $options[$option] = $option; } if (!$options) { // oh, nothing to search for return ''; } return choose_from_menu($options, 'f_'.$this->field->id, stripslashes($content), ' ', '', 0, true); } function parse_search_field() { return optional_param('f_'.$this->field->id, '', PARAM_NOTAGS); } function generate_sql($tablealias, $value) { return " ({$tablealias}.fieldid = {$this->field->id} AND {$tablealias}.content = '$value') "; } } ?>