Warm tip: This article is reproduced from serverfault.com, please click

其他-Yii2 在手风琴小部件内显示动态 GridView

(其他 - Yii2 Display Dynamic GridView inside Accordion Widget)

发布于 2021-05-11 09:49:20

我是 Yii2 的新手,我被困在一项相当微不足道的任务上。

我有两个表/模型(实体和属性)。一个实体可以有多个属性,但一个属性只能有一个实体。这些关系已在各自的模型中定义

我正在尝试为登录用户创建一个 dashboard 视图,该视图显示用户关联的实体(通过连接表 Entityuser)。在视图中,我希望为每个实体显示一个手风琴,展开时将显示属于该实体的属性的 GridView。我遇到的问题是 GridView 只显示由 ArrayDataProvider 返回的数组中的最后一个属性模型,而不管实体关系如何(即它也在所有实体的手风琴中显示相同的属性模型)。

我在下面复制了我的代码。任何帮助将不胜感激。我花了太多时间在这上面😊

楷模:

实体

public function getProperty()
{
    return $this->hasMany(Property::className(), ['entity_id' => 'entity_id']);
}

财产

public function getEntity()
{
    return $this->hasOne(Entity::className(), ['entity_id' => 'entity_id']);
}

控制器:

public function actionDashboard($id)
{
    $model = User::findOne($id);

    $entities = new ActiveDataProvider([
            'query' => Entity::find()
                        ->joinWith('entityUsers')
                        ->where(['entity_user.user_id' => $id]),
            'pagination' => [
            'pageSize' => 10,
        ],
    ]);


  foreach($entities->models as $ent){

  $en_id = $ent->entity_id;

  $dataProvider = new ArrayDataProvider([
       'models' => Property::find()->where(['entity_id' => $en_id])->all(),
       // 'models' => $searchModel->entity_id,
        'pagination' => [
            'pageSize' => 10,
        ],
    ]);
   }        

    return $this->render('userProfile', [
    
    'model' => $model,
    'entities' => $entities,
    'dataProvider' => $dataProvider,

看法:

foreach($entities->models as $model){

$entity_id = $model->entity_id;
   
echo Accordion::widget([
    'items' => [
    ['header' => $model->entity,
    'content' => 
                 
   GridView::widget([
    'dataProvider' => $dataProvider,
    'columns' => [
    ['class' => 'yii\grid\SerialColumn'],
    'name',
    'address',
    'city',
    'entity_id',
    'land',
     ['class' => 'yii\grid\ActionColumn',
     'header' => '',
     'template' => '{view}',
     'controller' => 'property',
     'contentOptions' => ['style' => 'width:50px; white-space: normal;'],
    ]]
    ])
    ]
    ],
    'clientOptions' => ['collapsible' => true, 'active' => false]
    
    ]); 
     
    }
   }
Questioner
Adsar
Viewed
11
Insane Skull 2021-05-11 18:33:06

$dataProvder只做最后一张唱片。

控制器

foreach ($entities->models as $ent) {
    $en_id = $ent->entity_id;
    $dataProviders[$en_id] = new ArrayDataProvider([
       'models' => Property::find()->where(['entity_id' => $en_id])->all(),
       'pagination' => [
           'pageSize' => 10,
        ],
    ]);
}
return $this->render('userProfile', [
    'model' => $model,
    'entities' => $entities,
    'dataProviders' => $dataProviders,
]);

看法

foreach($entities->models as $model){
   $entity_id = $model->entity_id;
   $dataProvider = $dataProviders[$entity_id];

   echo Accordion::widget([
    .
    .
    .
    .
    .