从一个到多个表Yii2调用另一个字段(Call another field from one to many table Yii2)

从一个到多个表Yii2调用另一个字段(Call another field from one to many table Yii2)

我这里有问题。 如何从用户表中调用字段“用户名”？ 我想在这里显示用户名而不是user_id。 这里的图片： 我想在部分'Direquest oleh'和'Disetujui / Ditolak oleh'中显示用户名而不是user_id

在这里我的代码：

[ 'attribute' => 'waktu_request', 'label' => 'Waktu Request', 'format' => ['DateTime', 'php:d M Y H:i:s'], 'filter' => '', ], [ 'attribute'=>'requested_by', 'label' => 'Direquest oleh', 'value' => function($model){ if($model->requested_by == NULL){ return '-'; }else{ return $model->requested_by; } } ], [ 'attribute'=>'approved_rejected_by', 'label' => 'Disetujui/Ditolak oleh', 'value' => function($model){ if($model->approved_rejected_by == NULL){ return '-'; }else{ return $model->approved_rejected_by; } } ],

我希望有人能在这里解决我的问题。 为了你的关注我说谢谢。

I have a problem here. How can i call the field 'username' from the user table? I want to show the username here not the user_id. Here the pict : I want to show the username not the user_id in part 'Direquest oleh' and 'Disetujui/Ditolak oleh'

and here my code :

[ 'attribute' => 'waktu_request', 'label' => 'Waktu Request', 'format' => ['DateTime', 'php:d M Y H:i:s'], 'filter' => '', ], [ 'attribute'=>'requested_by', 'label' => 'Direquest oleh', 'value' => function($model){ if($model->requested_by == NULL){ return '-'; }else{ return $model->requested_by; } } ], [ 'attribute'=>'approved_rejected_by', 'label' => 'Disetujui/Ditolak oleh', 'value' => function($model){ if($model->approved_rejected_by == NULL){ return '-'; }else{ return $model->approved_rejected_by; } } ],

I hope anyone can solve my problem here. For your attention i say thank you.

最满意答案

如果您使用Gii生成模型和crud，则可能已经生成了名为getRequestedBy()和getApprovedRejectedBy() 。

[ 'attribute'=>'requested_by', 'label' => 'Direquest oleh', 'value' => function($model){ return ($model->requested_by) ? $model->requestedBy->username : '-'; } ], [ 'attribute'=>'approved_rejected_by', 'label' => 'Disetujui/Ditolak oleh', 'value' => function($model){ return ($model->approved_rejected_by) ? $model->approvedRejectedBy->username : '-'; } ],

不要忘记在searchModel中添加关系以进行急切加载，即减少查询次数。 例如，

ModelName::find()->with(['requestedBy', 'approvedRejectedBy']);

If you had used Gii to generate model and crud you probably already have relation generated named getRequestedBy() and getApprovedRejectedBy().

[ 'attribute'=>'requested_by', 'label' => 'Direquest oleh', 'value' => function($model){ return ($model->requested_by) ? $model->requestedBy->username : '-'; } ], [ 'attribute'=>'approved_rejected_by', 'label' => 'Disetujui/Ditolak oleh', 'value' => function($model){ return ($model->approved_rejected_by) ? $model->approvedRejectedBy->username : '-'; } ],

Don't forget to add relation in searchModel for eager loading aka reduce no of queries. For example,

ModelName::find()->with(['requestedBy', 'approvedRejectedBy']);