Widget-Dataprovider-Count same rows

Yii 1.1 General Discussion
1

Hi Yii Masters!

I have a problem, what i cant solve it. I tried search the solution, but i cant find it (of course that is my mistakes ^^’).

So I have a Datagridview from $model, which show a Cars and Owners.

I want counting the same rows (see below the sample what i want)

<?php

$this->widget(‘application.extensions.NPager.NGridView’, array(

'id' =&gt; 'Car-grid',


'dataProvider' =&gt; &#036;model-&gt;search(),


'filter' =&gt; &#036;model,


'ajaxUrl' =&gt; &#036;this-&gt;ajaxUrl,





'cssFile' =&gt; Yii::app()-&gt;baseUrl . '/css/gridview/styles.css',


'template' =&gt; '{summary}{pagerlist}{pager}{items}{pager}',


'pagerlist' =&gt; array(


    '8' =&gt; '8',


    '10' =&gt; '10',


    '25' =&gt; '25',


    '50' =&gt; '50',


    '100' =&gt; '100',


),


'textItemsPerPage' =&gt; 'per side',


'columns' =&gt; array(

array(

'name' =&gt; 'Owner',


'header' =&gt; 'Owner',


    'type' =&gt; 'raw',


'filter' =&gt; CHtml::activeTextField(&#036;model, 'searchid', array('id'=&gt;'Owner_tb'),


    ),

array(

'name' =&gt; 'Car',


'header' =&gt; 'Car',


'value' =&gt; '(is_object(&#036;data-&gt;car),


'type' =&gt; 'raw',


'filter' =&gt; CHtml::activeTextField(&#036;model, 'searchcar','id'=&gt;'Car_tb'),


);

array(

'name' =&gt; 'Count',


'header' =&gt; 'Count',


'value' =&gt; <img src='http://www.yiiframework.com/forum/public/style_emoticons/default/huh.gif' class='bbc_emoticon' alt='???' />?<img src='http://www.yiiframework.com/forum/public/style_emoticons/default/huh.gif' class='bbc_emoticon' alt='???' />


'type' =&gt; 'raw',





);

?>

My result :

Owner | Car

Peter Company | BMW

Johs Company | Volvo

Peter Company | BMW

And what i want :

Owner | Car | Count

Peter Company | BMW | 2

Johs Company | Volvo | 1

Sorry for my bad english, but i hope its understandable :)

Thank you :)

2

Through this i can solved the problem !

<?php

$rawData=Yii::app()->db->createCommand(‘SQL COMMAND PLACE’)->queryAll();

$dataProvider = new CArrayDataProvider($rawData);

$dataProvider->setData($model->productitemid);

$model->setAttributes($rawData);

$newDataProvider=$model->search();

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

'id' =&gt; 'product-grid',


'dataProvider' =&gt; &#036;model-&gt;search(),


'ajaxUrl' =&gt; &#036;this-&gt;ajaxUrl,


'cssFile' =&gt; Yii::app()-&gt;baseUrl . '/css/gridview/styles.css',


'template' =&gt; '{summary}{pagerlist}{pager}{items}{pager}',

));

?>

^^ thank you who read my post .