fieldid = $this->field->id;
$content->recordid = $recordid;
$value = trim($value);
if (strlen($value) > 0) {
$content->content = floatval($value);
} else {
$content->content = null;
}
if ($oldcontent = $DB->get_record('data_content', array('fieldid'=>$this->field->id, 'recordid'=>$recordid))) {
$content->id = $oldcontent->id;
return $DB->update_record('data_content', $content);
} else {
return $DB->insert_record('data_content', $content);
}
}
function display_browse_field($recordid, $template) {
global $DB;
if ($content = $DB->get_record('data_content', array('fieldid'=>$this->field->id, 'recordid'=>$recordid))) {
if (strlen($content->content) < 1) {
return false;
}
$number = $content->content;
$decimals = trim($this->field->param1);
// only apply number formatting if param1 contains an integer number >= 0:
if (preg_match("/^\d+$/", $decimals)) {
$decimals = $decimals * 1;
// removes leading zeros (eg. '007' -> '7'; '00' -> '0')
$str = format_float($number, $decimals, true);
// For debugging only:
# $str .= " ($decimals)";
} else {
$str = $number;
}
return $str;
}
return false;
}
function display_search_field($value = '') {
return '' .
'';
}
function parse_search_field() {
return optional_param('f_'.$this->field->id, '', PARAM_NOTAGS);
}
// need to cast?
function generate_sql($tablealias, $value) {
global $DB;
static $i=0;
$i++;
$name = "df_number_$i";
$varcharcontent = $DB->sql_compare_text("{$tablealias}.content");
return array(" ({$tablealias}.fieldid = {$this->field->id} AND $varcharcontent = :$name) ", array($name=>$value));
}
function get_sort_sql($fieldname) {
global $DB;
return $DB->sql_cast_char2real($fieldname, true);
}
}