How to convert model data objects array to dataProvider

Question

Suppose I have model User which have many to many relation to itself named as friends. so $user->friends (or $model->friends in view) gives me an array of User objects. I wanted to display the friends as gridview. But CGridView data as dataProvider object. Googling for it found the way to convert array of model objects to dataProvider object as given below.

$this->widget('zii.widgets.grid.CGridView', array(
    'id' => 'gridUser',
    'dataProvider' => new CArrayDataProvider($model->friends, array()),
));

Now using this I get an error

Property "User.id" is not defined.

UPDATE

public function relations()
{
    return array(
         'friends' => array(self::MANY_MANY, 'User', 'friendship(user_id, friend_id)'),
    );
}

adding how you defined relation and how two models relate (PK and FK) is crucial to getting an answer! — Stefano Mtangoo
– Stefano Mtangoo, Commented Jan 3, 2013 at 10:15

Stefano Mtangoo · Accepted Answer · 2013-01-03 10:13:03Z

18

I use two stage building the provider shown below. But I found that it gives you trouble in terms of Pagination. I have not bothered to resolve that problem since am doing other things

$dataProvider =  new CArrayDataProvider('User');
$dataProvider->setData($model->friends);
$this->widget('zii.widgets.grid.CGridView', array(
    'id' => 'gridUser',
    'dataProvider' =>$dataProvider,
));

That being said, your code should work (see the example below from API docs). I suspect there is wrong attribute in your relations than the provided code. Re-check the relation definition if it is ok

From Yii docs:

$rawData=Yii::app()->db->createCommand('SELECT * FROM tbl_user')->queryAll();
// or using: $rawData=User::model()->findAll(); <--this better represents your question
$dataProvider=new CArrayDataProvider($rawData, array(
    'id'=>'user',
    'sort'=>array(
        'attributes'=>array(
             'id', 'username', 'email',
        ),
    ),
    'pagination'=>array(
        'pageSize'=>10,
    ),
));

answered Jan 3, 2013 at 10:13

Stefano Mtangoo

6,5308 gold badges56 silver badges102 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Prashanth Shyamprasad Over a year ago

got the exact thing i was searching, anyways thanks dude. thumbs up to your answer too.

Prashanth Shyamprasad Over a year ago

the exact answer that i was searching is given below. please check it and upvote if its useful

Stefano Mtangoo Over a year ago

Great that I was of help :)

Prashanth Shyamprasad Over a year ago

Please check if the below given answer is correct or not. I got the required result from that. I just want to know if its a better answer or not

Stefano Mtangoo Over a year ago

its nice and efficient solution I can think of. So no need to worry!

|

Prashanth Shyamprasad · Accepted Answer · 2013-01-10 10:02:42Z

13

Got it :) , i can use CActiveDataProvider instead of CArrayDataProvider as given below

$this->widget('zii.widgets.grid.CGridView', array(
    'id' => 'gridUser',
    'dataProvider' => new CActiveDataProvider('User', array(
            'data'=>$model->friends,
    )),
    //...... columns display list.....
));

Anyways thanks for the reply @Stefano

answered Jan 10, 2013 at 10:02

Prashanth Shyamprasad

8372 gold badges17 silver badges40 bronze badges

1 Comment

Gero Over a year ago

this is a better answer, as it enables CGridView to fetch grid headers from the CModel...

Collectives™ on Stack Overflow

How to convert model data objects array to dataProvider

2 Answers 2

6 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related