我正在使用Yii2 gridview小部件来显示数据。

我正在使用两个名为消息 message_trigger 的表。

消息中,表列为object_modelObject_id

message_trigger 中,列为object_idobject_name

网格从表消息中获取值。因此,网格字段为Object_modelObject_id

现在我的问题是我需要根据表消息中的Object_name显示表message_trigger中的object_id

在我的表格中,我使用了像这样的网格

<?= GridView::widget([
    'dataProvider' => $dataProvider,
    'filterModel' => $searchModel,
    'columns' => [
        ['class' => 'yii\grid\SerialColumn'],
        'object_model',
        'object_id',
        ['class' => 'yii\grid\ActionColumn', 'template' => '{view} {update} {delete} '],
    ],
]); ?>

在我使用的模型中
public function search($params){
    $query = AlertTrigger::find()->where(['alert_id'=>$params['id']])->andWhere(['!=','status',2]);
    $dataProvider = new ActiveDataProvider([
        'query' => $query,
    ]);
}

最佳答案

Message模型中

public function getMessageTrigger()
{
    return $this->hasOne(MessageTrigger::className(), ['object_id' => 'object_id']);
}

鉴于
<?= GridView::widget([
    'dataProvider' => $dataProvider,
    'filterModel' => $searchModel,
    'columns' => [
        ['class' => 'yii\grid\SerialColumn'],
        'object_model',
        'object_id',
        [
            'label' => 'Name',
            'value' => 'messageTrigger.object_name',
        ],
        ['class' => 'yii\grid\ActionColumn', 'template' => '{view} {update} {delete} '],
    ],
]); ?>

10-04 23:35
查看更多