/** * Retrieves a list of models based on the current search/filter conditions. * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions. */ public function search() { $criteria = new CDbCriteria(); $criteria->compare('t.id', $this->id); $criteria->compare('t.title', $this->title, true); $criteria->compare('t.country_id', $this->country_id); $criteria->compare('t.department', $this->department, true); $date = DateHelper::toDbDateFormat_tuan($this->posted); if (!empty($date)) { $criteria->addCondition('DATE(t.posted) = "' . $date . '"'); } $criteria->order = 't.id desc'; return new CActiveDataProvider($this, array('criteria' => $criteria, 'pagination' => array('pageSize' => Yii::app()->user->getState('pageSize', Yii::app()->params['defaultPageSize'])))); }