[nemo]

I can not display total number of data. I have one field, name "record", I want to display total records. Can any one help me?

This is my view file
<?php $this->widget('zii.widgets.grid.CGridView', array(
'dataProvider'=>$dataProvider,
'columns'=>array(
'id',
'name',
'records_id',
'note',

),
)); ?>

Controller

public function actionView()
{
$dataProvider=new CActiveDataProvider('info', array(
'criteria'=>array(
'condition'=>'User_id =' .Yii::app()->user->id,
),

'pagination'=>array(
'pageSize'=>self::PAGE_SIZE,
),
));

$this->render('view',array(
'dataProvider'=>$dataProvider,
));
}

This is my sql command

SELECT count( records_id ) FROM `info` WHERE records_id IS NOT NULL AND User_id = 12 GROUP BY records_id

[jsoo]

echo $dataProvider->getTotalItemCount();

[nemo]

jsoo, on 12 March 2010 - 08:55 AM, said:

echo $dataProvider->getTotalItemCount();

I don't want total records. I need SUM(records_id) field with group by . THis is my SQL command

SELECT count(records_id ) FROM `info` WHERE records_id IS NOT NULL AND User_id = 12 GROUP BY records_id


<?php $this->widget('zii.widgets.grid.CGridView', array(
'dataProvider'=>$dataProvider,
'columns'=>array(
'id',
'name',
'records_id',
'note',

),
)); ?>

[jsoo]

Sorry. I just can't understand what you're asking.

[nemo]

jsoo, on 12 March 2010 - 10:02 AM, said:

Sorry. I just can't understand what you're asking.

Sorry about my english. Actually I want to count record_id field if record_id IS NOT NULL

[jsoo]

I think you can do this with

Info::model()->count($condition);

putting your WHERE clause into $condition, either as a string or an array to initialize a CDbCriteria.