CDbCriteria CArrayDataProvider zii.widgets.grid （2）

//商品汇总
    public function actionGoodslist() {
        set_time_limit(0);
        $criteria = new CDbCriteria();
        $StartTime = getValue("StartTime");
        $StartTime = $StartTime ? $StartTime :('1970-01-01');
        $StartTime=substr($StartTime,0,10);
        $EndTime = getValue("EndTime");
        $EndTime = $EndTime ? ($EndTime) : date('Y-m-d',time());
        $EndTime=substr($EndTime,0,10);
        $GoodsName = trim(getValue('GoodsName'));
        $GoodsSn = trim(getValue('GoodsSn'));
        $GoodsBref= trim(getValue('GoodsBref'));
        $condition='1=1';
        if ($GoodsName) {
            $condition.=' AND  x.GoodsName="'.$GoodsName.'"';
        }
        if ($GoodsSn) {
            $condition.=' AND   x.GoodsSn="'.$GoodsSn.'"';
        }
        if($GoodsBref){
            $condition.=' AND  x.GoodsBref="'.$GoodsBref.'"';
        }
        if ($StartTime){
            $condition.=' AND  x.CreateTime>="'.$StartTime.'"';
        }
        if ($EndTime){
            $condition.=' AND  x.CreateTime<="'.$EndTime.'"';
        }
        print_r($condition);
        $sql="SELECT x.CreateTime ,x.GoodsName  ,x.GoodsSn ,x.GoodsBref ,x.ShopPrice ,SUM(x.Num) as num,
           ShopPrice*SUM(x.Num) as totalmoney
           FROM (SELECT
           b.GoodsName,
           b.GoodsSn,
           b.GoodsBref,
           b.ShopPrice,
           a.Num,
           FROM_UNIXTIME(a.CreateTime,'%Y-%m-%d' )as CreateTime
           FROM kps_ordergoods a , kps_goods b
           where   a.GoodsId=b.GoodsId GROUP BY a.CreateTime)x
           where $condition
           GROUP BY x.CreateTime ,x.GoodsName limit 10000
          ";
        $connection=Yii::app()->db;
        $command=$connection->createCommand($sql);
        $num=$command->queryAll();
        $connection->active = false;
       $dataProvider = new CArrayDataProvider($num,array('id'=>'user',));
       $this->render('goodslist',array('dataProvider' => $dataProvider,) );

    }

view：

<?php
/* @var $this GoodsController */
/* @var $dataProvider CActiveDataProvider */


$this->breadcrumbs=array(
'Goods',
);
?>


<table align="left" width='100%' class='AdminMenuSys'>
    <tr>
        <td align='left'><h1>商品汇总</h1></td>
        <td align="right">


        </td>
        <td width='50'></td>
    </tr>
    <tr>
        <td colspan="3">
            <form action="" method="get">
                <?php
                echo CHtml::label('日期：', 'CreateTime');
            echo   CHtml::textField('StartTime',date('Y-m-d',$StartTime),array('class' => 'ShortTxt', 'onclick' => 'WdatePicker()','readOnly' => 'readOnly'));?>-<?php echo CHtml::textField('EndTime',date('Y-m-d',$EndTime),array('class' => 'ShortTxt', 'onclick' => 'WdatePicker()', 'readOnly' => 'readOnly'));?>
              <?php  echo CHtml::label('商品名称', 'GoodsName');?>
              <?php  echo CHtml::textField('GoodsName',$GoodsName);?>
              <?php  echo CHtml::label('货号', 'GoodsSn');?>
              <?php  echo CHtml::textField('GoodsSn',$GoodsSn);?>
              <?php  echo CHtml::label('备注', 'GoodsBref');?>
              <?php  echo CHtml::textField('GoodsBref',$GoodsBref);?>
              <?php  echo CHtml::submitButton('搜索');?>
            </form>
        </td>
    </tr>
</table>
<?php

cs()->registerScriptFile(resBu('js/DatePicker/WdatePicker.js'));
?>
<?php $this->widget('zii.widgets.grid.CGridView', array(
'dataProvider'=>$dataProvider,
));

?>