[Summary view] [Print] [Text view]

   1  <?php
   2  // This file is part of Moodle - http://moodle.org/
   3  //
   4  // Moodle is free software: you can redistribute it and/or modify
   5  // it under the terms of the GNU General Public License as published by
   6  // the Free Software Foundation, either version 3 of the License, or
   7  // (at your option) any later version.
   8  //
   9  // Moodle is distributed in the hope that it will be useful,
  10  // but WITHOUT ANY WARRANTY; without even the implied warranty of
  11  // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  12  // GNU General Public License for more details.
  13  //
  14  // You should have received a copy of the GNU General Public License
  15  // along with Moodle.  If not, see <http://www.gnu.org/licenses/>.
  16  
  17  /**
  18   * Date filter
  19   *
  20   * @package   core_user
  21   * @category  user
  22   * @copyright 1999 Martin Dougiamas  http://dougiamas.com
  23   * @license   http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
  24   */
  25  
  26  require_once($CFG->dirroot.'/user/filters/lib.php');
  27  
  28  /**
  29   * Generic filter based on a date.
  30   * @copyright 1999 Martin Dougiamas  http://dougiamas.com
  31   * @license   http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
  32   */
  33  class user_filter_date extends user_filter_type {
  34      /**
  35       * the fields available for comparisson
  36       * @var string
  37       */
  38      public $_field;
  39  
  40      /**
  41       * Constructor
  42       * @param string $name the name of the filter instance
  43       * @param string $label the label of the filter instance
  44       * @param boolean $advanced advanced form element flag
  45       * @param string $field user table filed name
  46       */
  47      public function __construct($name, $label, $advanced, $field) {
  48          parent::__construct($name, $label, $advanced);
  49          $this->_field = $field;
  50      }
  51  
  52      /**
  53       * Old syntax of class constructor. Deprecated in PHP7.
  54       *
  55       * @deprecated since Moodle 3.1
  56       */
  57      public function user_filter_date($name, $label, $advanced, $field) {
  58          debugging('Use of class name as constructor is deprecated', DEBUG_DEVELOPER);
  59          self::__construct($name, $label, $advanced, $field);
  60      }
  61  
  62      /**
  63       * Adds controls specific to this filter in the form.
  64       * @param object $mform a MoodleForm object to setup
  65       */
  66      public function setupForm(&$mform) {
  67          $objs = array();
  68  
  69          $objs[] = $mform->createElement('static', $this->_name.'_sck', null, get_string('isafter', 'filters'));
  70          $objs[] = $mform->createElement('date_selector', $this->_name.'_sdt', null, array('optional' => true));
  71          $objs[] = $mform->createElement('static', $this->_name.'_break', null, '<br/>');
  72          $objs[] = $mform->createElement('static', $this->_name.'_edk', null, get_string('isbefore', 'filters'));
  73          $objs[] = $mform->createElement('date_selector', $this->_name.'_edt', null, array('optional' => true));
  74  
  75          $grp =& $mform->addElement('group', $this->_name.'_grp', $this->_label, $objs, '', false);
  76  
  77          if ($this->_advanced) {
  78              $mform->setAdvanced($this->_name.'_grp');
  79          }
  80      }
  81  
  82      /**
  83       * Retrieves data from the form data
  84       * @param object $formdata data submited with the form
  85       * @return mixed array filter data or false when filter not set
  86       */
  87      public function check_data($formdata) {
  88          $sdt = $this->_name.'_sdt';
  89          $edt = $this->_name.'_edt';
  90  
  91          if (!$formdata->$sdt and !$formdata->$edt) {
  92              return false;
  93          }
  94  
  95          $data = array();
  96          $data['after'] = $formdata->$sdt;
  97          $data['before'] = $formdata->$edt;
  98  
  99          return $data;
 100      }
 101  
 102      /**
 103       * Returns the condition to be used with SQL where
 104       * @param array $data filter settings
 105       * @return array sql string and $params
 106       */
 107      public function get_sql_filter($data) {
 108          $after  = (int)$data['after'];
 109          $before = (int)$data['before'];
 110  
 111          $field  = $this->_field;
 112  
 113          if (empty($after) and empty($before)) {
 114              return array('', array());
 115          }
 116  
 117          $res = " $field >= 0 ";
 118  
 119          if ($after) {
 120              $res .= " AND $field >= $after";
 121          }
 122  
 123          if ($before) {
 124              $res .= " AND $field <= $before";
 125          }
 126          return array($res, array());
 127      }
 128  
 129      /**
 130       * Returns a human friendly description of the filter used as label.
 131       * @param array $data filter settings
 132       * @return string active filter label
 133       */
 134      public function get_label($data) {
 135          $after  = $data['after'];
 136          $before = $data['before'];
 137          $field  = $this->_field;
 138  
 139          $a = new stdClass();
 140          $a->label  = $this->_label;
 141          $a->after  = userdate($after);
 142          $a->before = userdate($before);
 143  
 144          if ($after and $before) {
 145              return get_string('datelabelisbetween', 'filters', $a);
 146          } else if ($after) {
 147              return get_string('datelabelisafter', 'filters', $a);
 148          } else if ($before) {
 149              return get_string('datelabelisbefore', 'filters', $a);
 150          }
 151          return '';
 152      }
 153  }