mod/data/field/number/field.class.php

   1 <?php
   2 ///////////////////////////////////////////////////////////////////////////
   3 //                                                                       //
   4 // NOTICE OF COPYRIGHT                                                   //
   5 //                                                                       //
   6 // Moodle - Modular Object-Oriented Dynamic Learning Environment         //
   7 //          http://moodle.org                                            //
   8 //                                                                       //
   9 // Copyright (C) 1999-onwards Moodle Pty Ltd  http://moodle.com          //
  10 //                                                                       //
  11 // This program is free software; you can redistribute it and/or modify  //
  12 // it under the terms of the GNU General Public License as published by  //
  13 // the Free Software Foundation; either version 2 of the License, or     //
  14 // (at your option) any later version.                                   //
  15 //                                                                       //
  16 // This program is distributed in the hope that it will be useful,       //
  17 // but WITHOUT ANY WARRANTY; without even the implied warranty of        //
  18 // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the         //
  19 // GNU General Public License for more details:                          //
  20 //                                                                       //
  21 //          http://www.gnu.org/copyleft/gpl.html                         //
  22 //                                                                       //
  23 ///////////////////////////////////////////////////////////////////////////
  24
  25 class data_field_number extends data_field_base {
  26     var $type = 'number';
  27
  28     function update_content($recordid, $value, $name='') {
  29         global $DB;
  30
  31         $content = new stdClass();
  32         $content->fieldid = $this->field->id;
  33         $content->recordid = $recordid;
  34         $value = trim($value);
  35         if (strlen($value) > 0) {
  36             $content->content = floatval($value);
  37         } else {
  38             $content->content = null;
  39         }
  40         if ($oldcontent = $DB->get_record('data_content', array('fieldid'=>$this->field->id, 'recordid'=>$recordid))) {
  41             $content->id = $oldcontent->id;
  42             return $DB->update_record('data_content', $content);
  43         } else {
  44             return $DB->insert_record('data_content', $content);
  45         }
  46     }
  47
  48     function display_browse_field($recordid, $template) {
  49         global $DB;
  50
  51         if ($content = $DB->get_record('data_content', array('fieldid'=>$this->field->id, 'recordid'=>$recordid))) {
  52             if (strlen($content->content) < 1) {
  53                 return false;
  54             }
  55             $number = $content->content;
  56             $decimals = trim($this->field->param1);
  57             // only apply number formatting if param1 contains an integer number >= 0:
  58             if (preg_match("/^\d+$/", $decimals)) {
  59                 $decimals = $decimals * 1;
  60                 // removes leading zeros (eg. '007' -> '7'; '00' -> '0')
  61                 $str = format_float($number, $decimals, true);
  62                 // For debugging only:
  63 #                $str .= " ($decimals)";
  64             } else {
  65                 $str = $number;
  66             }
  67             return $str;
  68         }
  69         return false;
  70     }
  71
  72     function display_search_field($value = '') {
  73         return '<label class="accesshide" for="f_'.$this->field->id.'">' . get_string('fieldname', 'data') . '</label>' .
  74                '<input type="text" size="16" id="f_'.$this->field->id.'" name="f_'.$this->field->id.'" value="'.s($value).'" />';
  75     }
  76
  77     function parse_search_field() {
  78         return optional_param('f_'.$this->field->id, '', PARAM_NOTAGS);
  79     }
  80
  81     // need to cast?
  82     function generate_sql($tablealias, $value) {
  83         global $DB;
  84
  85         static $i=0;
  86         $i++;
  87         $name = "df_number_$i";
  88         $varcharcontent = $DB->sql_compare_text("{$tablealias}.content");
  89         return array(" ({$tablealias}.fieldid = {$this->field->id} AND $varcharcontent = :$name) ", array($name=>$value));
  90     }
  91
  92     function get_sort_sql($fieldname) {
  93         global $DB;
  94         return $DB->sql_cast_char2real($fieldname, true);
  95     }
  96
  97 }
  98
  99