我正在使用Yii2 gridview小部件来显示数据.
我正在使用两个名为message和message_trigger的表.
在消息表中,列是object_model,Object_id.
在message_trigger中,该列是object_id,object_name.
网格从表消息中获取值.所以网格字段是Object_model,Object_id.
现在我的问题是我需要根据表消息中的object_id从表message_trigger中显示Object_name.
在我的表格中,我使用了这样的网格
- <?= 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,]);
- }
在消息模型中
- public function getMessageTrigger()
- {
- return $this->hasOne(MessageTrigger::className(),['object_id' => 'object_id']);
- }
在视野中
- <?= GridView::widget([
- 'dataProvider' => $dataProvider,[
- 'label' => 'Name','value' => 'messageTrigger.object_name',]); ?>
