如何在Yii2 gridview中连接两个表并获取值 [英] How to join two tables and get values in Yii2 gridview
问题描述
我使用两个名为 message 和 message_trigger 。
在消息表列中, object_model
, Object_id
。
$ b 在 message_trigger 中,列是 object_id
, object_name
。
网格从表格消息中获取值。因此,网格字段是 Object_model
, Object_id
。
现在我的问题是我需要从表 在我的窗体我已经使用过这样的网格 在模型中,我使用了 > Message Model 视图 I'm using Yii2 gridview widget to display the data. I'm using two tables named as message and message_trigger. In message table columns are In message_trigger the column are The grid get the values from the table message. So grid fields are Now my problem is I need to show In my form I have used grid like this In model I have used
In in view
这篇关于如何在Yii2 gridview中连接两个表并获取值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋! message_trigger $>中显示
Object_name
c $ c>基于表消息中的 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() - >其中(['alert_id'=> $ params ['id']]) - > andWhere([ '!=', '状态',2]);
$ dataProvider = new ActiveDataProvider([
'query'=> $ query,
]);
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}'],
],
]); ?>
object_model
, Object_id
. object_id
, object_name
.Object_model
, Object_id
. Object_name
from the table message_trigger
based on the object_id
from the table message.<?= 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
Modelpublic 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} '],
],
]); ?>