我只需要返回一个具有权限name
列的数组,但无法使其与->pluck()
一起工作
class User
{
public function roleTeams()
{
return $this->hasMany(RoleTeam::class);
}
}
class RoleTeams
{
public function roles()
{
return $this->belongsToMany(Role::class);
}
}
class Role
{
public function permissions()
{
return $this->belongsToMany(Permission::class);
}
}
这是我最后一次尝试基于我发现的类似答案的代码。
$permissions = $user->roleTeams()->with('roles.permissions')->pluck('roles.*.permissions.*.name')->all();
预期结果为
[
'edit_user',
'delete_user',
...
]
所以,我试着模拟你的情况。我的代码是:
$arr = [
'id' => 1,
'name' => 'User 1',
'roles' => [
[
'id' => 2,
'name' => 'Admin',
'permissions' => [
[
'id' => 8,
'name' => 'edit_user',
'type' => 'editor',
],
[
'id' => 9,
'name' => 'delete_user',
'type' => 'deleter',
],
],
],
[
'id' => 3,
'name' => 'Manager',
'permissions' => [
[
'id' => 6,
'name' => 'do_smth1_with_user',
'type' => 'smth1',
],
[
'id' => 7,
'name' => 'do_smth2_with_user',
'type' => 'smth2',
],
],
],
],
];
$collection = collect([$arr]);
并有感兴趣的结果。如果使用pluck()
方法,如您的答案:
dd($collection->pluck('roles.*.permissions.*.name'));
结果是这样的:
Collection {#322 ▼
#items: array:1 [▼
0 => array:4 [▼
0 => "edit_user"
1 => "delete_user"
2 => "do_smth1_with_user"
3 => "do_smth2_with_user"
]
]
}
但如果我使用pluck()
和collapse()
方法,看起来就像你想要的:
dd($collection->pluck('roles')->collapse()->pluck('permissions')->collapse()->pluck('name'));
结果是:
Collection {#322 ▼
#items: array:4 [▼
0 => "edit_user"
1 => "delete_user"
2 => "do_smth1_with_user"
3 => "do_smth2_with_user"
]
}
老实说,我不知道为什么它能像工作一样工作,但试着用collapse()
方法,让我知道它是否对你有帮助。希望我的回答能帮助你解决你的问题。