field->id, 'recordid', $recordid); $content = explode('##', $content); } else { $content = array(); } $str = '
'; $str .= '
'.$this->field->name.''; $i = 0; foreach (explode("\n", $this->field->param1) as $checkbox) { $checkbox = trim($checkbox); if ($checkbox === '') { continue; // skip empty lines } $str .= ''; $str .= 'field->id.'_'.$i.'">'.$checkbox.'
'; $i++; } $str .= '
'; $str .= '
'; return $str; } function display_search_field($value='') { global $CFG; if (is_array($value)){ $content = $value['checked']; $allrequired = $value['allrequired'] ? 'checked = "checked"' : ''; } else { $content = array(); $allrequired = ''; } static $c = 0; $str = ''; $found = false; foreach (explode("\n",$this->field->param1) as $checkbox) { $checkbox = trim($checkbox); $str .= 'field->id.'[]">' . $checkbox . '
'; $found = true; } if (!$found) { // oh, nothing to search for return ''; } $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('checked'=>$selected, 'allrequired'=>$allrequired); } function generate_sql($tablealias, $value) { $allrequired = $value['allrequired']; $selected = $value['checked']; 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_checkbox_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 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; } function format_data_field_checkbox_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); } } ?>