user/filters/date.php

   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 }