自定义API资源关系

Question

我有一个查询，我使获得用户，这张表与其他3个表有关，但查询有点长，我想处理JsonResource，但我没有能够生成JsonResource，因为我在正常查询中拥有它。

方法指数:

public function index()
{
$users = User::select('users.id', 'users.name', 'users.email', 'users.username', 'users.status', 'users.id_cost_center', 'cost_centers.code AS code_cost_center', 'cost_centers.description AS cost_center', 
'users.id_dependence', 'dependencies.description AS dependence', 'users.id_profile', 'profiles.name AS profile', 'users.created_at')
->join('cost_centers', 'users.id_cost_center', '=', 'cost_centers.id')
->join('dependencies', 'users.id_dependence', '=', 'dependencies.id')
->join('profiles', 'users.id_profile', '=', 'profiles.id')                            
->orderBy('users.created_at', 'desc')
->get();
$message = $this->sendResponse($users, 'List of users');
return $message;
}

我的用户模型中的关系:

public function cost_center()
{
return $this->belongsTo(CostCenter::class, 'id_cost_center');
}  

public function dependence()
{
return $this->belongsTo(Dependence::class, 'id_dependence');
}

public function profile() {
return $this->belongsTo(Profile::class, 'id_profile');
}

其他表的关系:

CostCenter:

public function users()
{
return $this->hasMany(User::class, 'id_cost_center');
}

依赖:

public function users()
{
return $this->hasMany(User::class, 'id_dependence');
}

简介:

public function users() 
{
return $this->hasMany(User::class, 'id_profile');
}

反应:

{
"success": true,
"data": [
{
"id": 1,
"name": "admin",
"email": "[e-mail]",
"username": "admin",
"status": 1,
"id_cost_center": 1,
"code_cost_center": "001",
"cost_center": "Admin",
"id_dependence": 1,
"dependence": "System",
"id_profile": 1,
"profile": "Developer",
"created_at": "2021-09-13T11:26:46.000000Z"
},
{
"id": 2,
"name": "user",
"email": "[e-mail]",
"username": "user",
"status": 1,
"id_cost_center": 2,
"code_cost_center": "002",
"cost_center": "Service",
"id_dependence": 2,
"dependence": "Store",
"id_profile": 2,
"profile": "Aux",
"created_at": "2021-09-13T11:26:46.000000Z"
}
],
"message": "List of users"

}

我尝试创建一个用户集合类，但它只生成用户而不生成关系:

public function toArray($request)
{
return [
'data' => $this->collection,
];
}

它只显示我的用户数据，我希望能够得到相同的答案，我在第一个正常查询。

Answer 1

你可以做的三件事:

1. 当用户模型被调用时总是返回关系:

class User extends Model {
protected $with = ['cost_center', 'profile', 'dependence'];
// ...
}

这将始终返回带有关系的用户。

2. 仅在使用toArray时返回关系

public function toArray($request)
{
return [
'data' => $this->collection->with('cost_center'),
];
}

3. 只需在控制器中执行此操作。

$users = User::with('cost_center', 'profile', 'dependance')->get();