YII框架CGridView sql有条件分页实现

$SQL="SELECT * FROM {{user}} WHERE `typeff`=2 order by create_time desc";

        $SQL_count="SELECT count(*) FROM {{user}} WHERE `typeff`=2 order by create_time desc";
        $count=Yii::app()->db->createCommand($SQL_count)->queryScalar();


        $dataProvider=new CSqlDataProvider($SQL, array(
            'totalItemCount'=>$count,
            'sort'=>array(
                'attributes'=>array(
                    'id','email','company_name','company_full_name','company_status','company_dengji_step','company_verify_tel'
                ),
            ),
            'pagination'=>array(
                'pageSize'=>10,
            ),
        ));
$SQL="SELECT * FROM {{user}} WHERE `typeff`