YII 按照日期过滤不起作用,怎么回事?
YII 按照日期过滤不起作用,怎么回事?
模型
<br> <?php <br /> <br> /**<br> * This is the model class for table "user".<br> *<br> * The followings are the available columns in table 'user':<br> * @property integer $id<br> * @property string $uname<br> */<br> class Timefliter extends CActiveRecord<br> {<br> /**<br> * Returns the static model of the specified AR class.<br> * @param string $className active record class name.<br> * @return User the static model class<br> */<br> public static function model($className=__CLASS__)<br> {<br> return parent::model($className);<br> }<br> <br> /**<br> * @return string the associated database table name<br> */<br> public function tableName()<br> {<br> return 't_time';<br> }<br> <br> <br> public $starttime;<br> public $endtime; <br> <br> <br> /**<br> * @return array validation rules for model attributes.<br> */<br> public function rules()<br> {<br> // NOTE: you should only define rules for those attributes that<br> // will receive user inputs.<br> return array(<br> array('id', 'safe'),<br> //array('id', 'numerical', 'integerOnly'=>true),<br> array('time', 'safe'),<br> <br> <br> // The following rule is used by search().<br> // Please remove those attributes that should not be searched.<br> array('id, time', 'safe', 'on'=>'search'),<br> );<br> }<br> <br> /**<br> * @return array relational rules.<br> */<br> public function relations()<br> {<br> // NOTE: you may need to adjust the relation name and the related<br> // class name for the relations automatically generated below.<br> return array(<br> );<br> }<br> <br> /**<br> * @return array customized attribute labels (name=>label)<br> */<br> public function attributeLabels()<br> {<br> return array(<br> 'id'=> '编号',<br> 'time'=> '时间',<br> );<br> }<br> <br> /**<br> * Retrieves a list of models based on the current search/filter conditions.<br> * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions.<br> */<br> public function search()<br> {<br> // Warning: Please modify the following code to remove attributes that<br> // should not be searched.<br> <br> $criteria=new CDbCriteria;<br> <br> $criteria->compare('id',$this->id);<br> $criteria->compare('time','>='.$this->starttime);<br> $criteria->compare('time','endtime);<br> <br> //是否开启模糊搜索,在后面true中实现<br> return new CActiveDataProvider($this, array(<br> 'criteria'=>$criteria, <br> //'pagination'=>array('pagesize'=>$pagesize?pagesize:$page),<br> //'pagination'=>array('pagesize'=>$page), <div class="clear"> </div>