我是 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]
]);
}
}
你$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([
.
.
.
.
.
我的天啊!很简单。不敢相信我在这上面浪费了这么多时间。我应该直接找你 疯狂的骷髅 :) 非常感谢你的帮助!
@Adsar。不客气。随时准备提供帮助:)