field->id, 'recordid', $recordid);
$content = explode('##', $content);
} else {
$content = array();
}
$str = '';
$str .= ''; // hidden field - needed for empty selection
$str .= '';
$str .= '
';
return $str;
}
function display_search_field($value = '') {
global $CFG;
if (is_array($value)){
$content = $value['selected'];
$allrequired = $value['allrequired'] ? 'checked = "checked"' : '';
} else {
$content = array();
$allrequired = '';
}
static $c = 0;
$str = '';
$str .= ' ';
$str .= '';
$c++;
return $str;
}
function parse_search_field() {
$selected = optional_param('f_'.$this->field->id, array(), PARAM_NOTAGS);
$allrequired = optional_param('f_'.$this->field->id.'_allreq', 0, PARAM_BOOL);
if (empty($selected)) {
// no searching
return '';
}
return array('selected'=>$selected, 'allrequired'=>$allrequired);
}
function generate_sql($tablealias, $value) {
$allrequired = $value['allrequired'];
$selected = $value['selected'];
if ($selected) {
$conditions = array();
foreach ($selected as $sel) {
$likesel = str_replace('%', '\%', $sel);
$likeselsel = str_replace('_', '\_', $likesel);
$conditions[] = "({$tablealias}.fieldid = {$this->field->id} AND ({$tablealias}.content = '$sel'
OR {$tablealias}.content LIKE '$likesel##%'
OR {$tablealias}.content LIKE '%##$likesel'
OR {$tablealias}.content LIKE '%##$likesel##%'))";
}
if ($allrequired) {
return " (".implode(" AND ", $conditions).") ";
} else {
return " (".implode(" OR ", $conditions).") ";
}
} else {
return " ";
}
}
function update_content($recordid, $value, $name='') {
$content = new object;
$content->fieldid = $this->field->id;
$content->recordid = $recordid;
$content->content = $this->format_data_field_multimenu_content($value);
if ($oldcontent = get_record('data_content','fieldid', $this->field->id, 'recordid', $recordid)) {
$content->id = $oldcontent->id;
return update_record('data_content', $content);
} else {
return insert_record('data_content', $content);
}
}
function format_data_field_multimenu_content($content) {
if (!is_array($content)) {
return NULL;
}
$options = explode("\n", $this->field->param1);
$options = array_map('trim', $options);
$vals = array();
foreach ($content as $key=>$val) {
if ($key === 'xxx') {
continue;
}
if (!in_array(stripslashes($val), $options)) {
continue;
}
$vals[] = $val;
}
if (empty($vals)) {
return NULL;
}
return implode('##', $vals);
}
function display_browse_field($recordid, $template) {
if ($content = get_record('data_content', 'fieldid', $this->field->id, 'recordid', $recordid)) {
if (empty($content->content)) {
return false;
}
$options = explode("\n",$this->field->param1);
$options = array_map('trim', $options);
$contentArr = explode('##', $content->content);
$str = '';
foreach ($contentArr as $line) {
if (!in_array($line, $options)) {
// hmm, looks like somebody edited the field definition
continue;
}
$str .= $line . "
\n";
}
return $str;
}
return false;
}
}
?>