Example #1
0
 /**
  * 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']))));
 }