<?php

/**

 * This is the model class for table "mv_search_count".

 *

 * The followings are the available columns in table 'mv_search_count':

 * @property string $id

 * @property string $kid

 * @property string $searchtime

 */

class MvSearchCount extends CActiveRecord

{

    // 满足搜索之用

    public $count_kid;

    /**

     * @return string the associated database table name

     */

    public function tableName()

    {

        return 'mv_search_count';

    }

    /**

     * @return array validation rules for model attributes.

     */

    public function rules()

    {

        // NOTE: you should only define rules for those attributes that

        // will receive user inputs.

        return array(

            array('kid, searchtime', 'required'),

            array('kid, searchtime', 'length', 'max'=>10),

            // The following rule is used by search().

            // @todo Please remove those attributes that should not be searched.

            array('id, kid, searchtime', 'safe', 'on'=>'search'),

        );

    }

    /**

     * @return array relational rules.

     */

    public function relations()

    {

        // NOTE: you may need to adjust the relation name and the related

        // class name for the relations automatically generated below.

        return array(

            'fk_keyword' => array(self::BELONGS_TO, 'MvSearchKeywords', 'kid'),

        );

    }

    /**

     * @return array customized attribute labels (name=>label)

     */

    public function attributeLabels()

    {

        return array(

            'id' => '主键',

            'kid' => 'keywords主键',

            'searchtime' => '搜索时的时间',

        );

    }

    /**

     * Retrieves a list of models based on the current search/filter conditions.

     *

     * Typical usecase:

     * - Initialize the model fields with values from filter form.

     * - Execute this method to get CActiveDataProvider instance which will filter

     * models according to data in model fields.

     * - Pass data provider to CGridView, CListView or any similar widget.

     *

     * @return CActiveDataProvider the data provider that can return the models

     * based on the search/filter conditions.

     */

    public function search()

    {

        // @todo Please modify the following code to remove attributes that should not be searched.

        $criteria=new CDbCriteria;

        /*$criteria->compare('id',$this->id,true);

        $criteria->compare('kid',$this->kid,true);*/

        // $criteria->compare('searchtime',$this->searchtime,true);

        // $criteria->distinct = true;

        // $criteria->select = 'kid, count(`kid`) as count_kid';

        $criteria->select = array('kid', 'count(`kid`) as count_kid');

        // $criteria->join = 'left join mv_search_keywords t2 on(t.kid=t2.kid)';

        $criteria->order = 'count_kid desc';

        $criteria->group = 'kid';

        $criteria->mergeWith($this->dateRangeSearchCriteria('searchtime', $this->searchtime));

        return new CActiveDataProvider($this, array(

            'criteria'=>$criteria,

            'pagination'=>array('pageSize'=>1000,),

        ));

    }

    /**

     * Returns the static model of the specified AR class.

     * Please note that you should have this exact method in all your CActiveRecord descendants!

     * @param string $className active record class name.

     * @return MvSearchCount the static model class

     */

    public static function model($className=__CLASS__)

    {

        return parent::model($className);

    }

    /**

     * Model behaviors

     */

    public function behaviors()

    {

        return array(

            'dateRangeSearch'=>array(

                'class'=>'application.components.behaviors.EDateRangeSearchBehavior',

            ),

        );

    }

}

<?php

$data = $model->search();

$this->widget('zii.widgets.grid.CGridView', array(

    'id'=>'mv-search-count-grid',

    'dataProvider'=>$data,

    'filter'=>$model,

    'columns'=>array(

        // 'id',

        // 'kid',

        array(

            'name'=>'kid',

            'value'=>'$data->fk_keyword->keyword',

            'filter'=>false, // Set the filter to false when date range searching

        ),

        array(

            'header'=>'搜索次数',

            'value'=>'$data->count_kid',

            'filter'=>false,

        ),

        // 'searchtime',

        /*array(

            'name'=>'searchtime',

            'value'=>"Yii::app()->dateFormatter->formatDateTime(\$data->searchtime, 'medium', 'short')",

            'filter'=>false, // Set the filter to false when date range searching

        ),*/

        /*array(

            'class'=>'CButtonColumn',

        ),*/

    ),

)); ?>