$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,

            ),

        ));

$this->render('auditing',array(

            'dataProvider'=>$dataProvider,

            'model'=>$model,

        ));

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

    'id'=>'table-responsive',

    'itemsCssClass' => 'table table-striped table-bordered table-advance table-hover',

    'pagerCssClass'=>'margin-top-20',

    'htmlOptions'=>array('class'=>'table-responsive'),

    'pager'=>array(

        'class'=>'CLinkPager',

        'header'=>'',

        'htmlOptions'=>array('class'=>'pagination'),

    ),

    'dataProvider'=>$dataProvider,

    'columns'=>array(

        'id',

        'email',

        'company_name',

        'company_full_name',

        array(

            'name'=>'company_status',

            'value'=>'$data["company_status"] == 0 ? "待审" : "通过"'

        ),

        'company_dengji_step',

        'company_verify_tel',

        array(

            'header'=>'操作',

            'value'=>'createOperationHtmlForTable($data["id"])',

            'type'=>'html',

            'htmlOptions' => array('style' => 'width:200px;'),

        )

    )

));