Displaying Related Data in Gridview Using Yii2

Question

I have being struggling with related model data for a while and can't seem to pin point the problem, I have been reduced to using a very simple example.

I have two models Dog and Owner, which have the following relations.

Owner:

public function getDogs()
{
    return $this->hasMany(Dog::className(), ['owner_id' => 'id']);
}

Dog:

public function getOwner()
{
    return $this->hasOne(Owner::className(), ['id' => 'owner_id']);
}

As a simple test I want to get the dog to disaply from the grid view in the index page in Owner view This is my index.php in the Owner view

<?= GridView::widget([
    'dataProvider' => $dataProvider,
    'filterModel' => $searchModel,
    'columns' => [
        ['class' => 'yii\grid\SerialColumn'],

        'id',
        'name',
        [       
            'attribute' => 'type',
            'value' => 'dog.type',
        ],

        ['class' => 'yii\grid\ActionColumn'],
    ],
]); ?>

I must be missing something fundamental here?

Current error is Getting unknown property: app\models\Owner::dog — Winkmei5ter
– Winkmei5ter, Commented Apr 30, 2015 at 11:43
Check relations, there are some mistakes there. They reference to the same type of object. And If the owner has many dogs, you can't access relation as dog, since it's dogs. — arogachev
– arogachev, Commented Apr 30, 2015 at 11:56
I am looking at the relations, but I can't seem to find any problems. they were generated directly from Gii. What problems do you see? I did however change the dog to dogs and now the page loads, but not the value, it just says in the Type column not set — Winkmei5ter
– Winkmei5ter, Commented Apr 30, 2015 at 12:16

soju · Accepted Answer · 2015-04-30 14:37:04Z

7

You cannot display multiple related items like this, but you could simply use a callback, e.g. :

[
    'label' => 'Dog types',
    'value' => function($model) {
        return join(', ', yii\helpers\ArrayHelper::map($model->dogs, 'id', 'type'));
    },
],

answered Apr 30, 2015 at 14:37

soju

25.4k3 gold badges70 silver badges71 bronze badges

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

2 Comments

topher Over a year ago

The yii2 version of GROUP_CONCAT. Lovely solution.

Winkmei5ter Over a year ago

Thanks that's just what I needed. Now so you say I would not be able to display multiple related items like this but what about doing it the other way, from the Dog view, can I display the Owner information using my method above? As Any particular dog can only have one owner at a time.

Collectives™ on Stack Overflow

Displaying Related Data in Gridview Using Yii2

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related