[Summary view] [Print] [Text view]

   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       * Check if a field from an add form is empty
  99       *
 100       * @param mixed $value
 101       * @param mixed $name
 102       * @return bool
 103       */
 104      function notemptyfield($value, $name) {
 105          return strval($value) !== '';
 106      }
 107  }
 108  
 109