我这里有问题。 如何从用户表中调用字段“用户名”? 我想在这里显示用户名而不是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']);更多推荐
发布评论