hi all,
controller
[code]
$model=Product::model()->display_products_statistics();
//$model->unsetAttributes(); // clear any default values
//if(isset($_GET['Product']))
//$model->attributes=$_GET['Product'];
$this->render('admin',array(
'model'=>$model,
));
[code]
view
[code]
<?php $this->widget(‘zii.widgets.grid.CGridView’, array(
'id'=>'product-grid',
'dataProvider'=>$model->display_products_statistics(),
'filter'=>$model,
'columns'=>array(
'member_count',
'seller_count',
'visitor_count',
/*'Higest price',
'lowest price',
/*
'desc',
/*
'price',
'createdate',
'updatedate',
'opid',
'pimg',
*/
array(
'class'=>'CButtonColumn',
//'template'=>'{update}'
),
),
)); ?>
[code]
model
[code]
$sql="select member_count,seller_count,
visitor_count from fc_product fp
group by member_count,visitor_count,seller_count
order by member_count desc";
$connection=Yii::app()->db;
$command=$connection->createCommand($sql);
$products_statistics=$command->queryAll();
$dataprovider=new CArrayDataProvider($products_statistics,
array(‘pagination’=>false));
//print_r($dataprovider);exit;
return $dataprovider->getData();
[code]
but then i am getting this error
Fatal error: Call to a member function getData() on a non-object in D:\wamp\www\yii\framework\zii\widgets\CBaseListView.php on line 111
I am confused and dont know whats going wrong
Plz let me know