field->id; if (isset($formdata->$fieldname)) { $content = $formdata->$fieldname; } else { $content = ''; } } else if ($recordid) { $content = trim($DB->get_field('data_content', 'content', array('fieldid'=>$this->field->id, 'recordid'=>$recordid))); } else { $content = ''; } $str = '

'; $str .= '

' . $this->field->name; if ($this->field->required) { $str .= ' ' . get_string('requiredelement', 'form') . ''; $image = html_writer::img($OUTPUT->pix_url('req'), get_string('requiredelement', 'form'), array('class' => 'req', 'title' => get_string('requiredelement', 'form'))); $str .= html_writer::div($image, 'inline-req'); } else { $str .= ''; } $i = 0; $requiredstr = ''; $options = explode("\n", $this->field->param1); foreach ($options as $radio) { $radio = trim($radio); if ($radio === '') { continue; // skip empty lines } $str .= 'field->id.'_'.$i.'">'.$radio.'
'; $i++; } $str .= '

'; $str .= '

'; return $str; } function display_search_field($value = '') { global $CFG, $DB; $varcharcontent = $DB->sql_compare_text('content', 255); $used = $DB->get_records_sql( "SELECT DISTINCT $varcharcontent AS content FROM {data_content} WHERE fieldid=? ORDER BY $varcharcontent", array($this->field->id)); $options = array(); if(!empty($used)) { foreach ($used as $rec) { $options[$rec->content] = $rec->content; //Build following indicies from the sql. } } $return = html_writer::label(get_string('nameradiobutton', 'data'), 'menuf_'. $this->field->id, false, array('class' => 'accesshide')); $return .= html_writer::select($options, 'f_'.$this->field->id, $value); return $return; } function parse_search_field() { return optional_param('f_'.$this->field->id, '', PARAM_NOTAGS); } function generate_sql($tablealias, $value) { global $DB; static $i=0; $i++; $name = "df_radiobutton_$i"; $varcharcontent = $DB->sql_compare_text("{$tablealias}.content", 255); return array(" ({$tablealias}.fieldid = {$this->field->id} AND $varcharcontent = :$name) ", array($name=>$value)); } }