Yii2 get GriwView records?

Question

Yii

There is such a database structure: It is necessary to display all authors for one book in a separate GridView

column . I tried in the Authors model, to make such a connection:

/**
     * @return \yii\db\ActiveQuery
     */
    public function getAuthorsBooks()
    {
        return $this->hasMany(AuthorsBooks::className(), ['authors_id' => 'id'])->viaTable('books', ['id' => 'books_id']);
    }

What is the best way to implement this?

Answer 1

....
[
  'attribute'=>'authorsBooks',
  'value'=>function($model){
      return implode(',',ArrayMap::getColumn($model->authorsBooks,'name'));
    }
]
...

It is possible to implement a method in the model

public function getAutorsString(){
  return implode(',',ArrayMap::getColumn($this->authorsBooks,'name'));
}

respectively in gridView:

....
[
  'attribute'=>'authorsBooks',
  'value'=>'autorsString'
]
...

The second option is more logical as it avoids code duplication. As I understand it, there are many places where it is necessary to display.

Answer 2

GridView::widget([
  ...
  'columns' => [
    ...
    'author' => [
      'label' => 'Авторы', 
      'format' => 'html',
      'value' => function (Book $book) {
        foreach($book->authorsBooks...
        return ...;
      },
    ],
  ],
])