官方文档:
https://learnku.com/docs/laravel/6.x/eloquent/5176#b438f8
项目中经常会使用到 find 查找数据,有时候需要判断数据是否存在,laravel提供了这样的方式方法:
1、findOrNew
$result = OutPatientOrderModel::getQuery()->with([
'detail' => function ($query) {
$query->where('is_deleted', '0')->select('img_des', 'illness_des', 'order_id', 'pkid', 'is_visit');
}
])->findOrNew($id, $fields)->toArray();
执行结果:
hospital\app\Services\Inquiry\OrderService.php line:49Array
(
)
2、findOrFail
$result = OutPatientOrderModel::getQuery()->with([
'detail' => function ($query) {
$query->where('is_deleted', '0')->select('img_des', 'illness_des', 'order_id', 'pkid', 'is_visit');
}
])->findOrFail($id, $fields)->toArray();
执行结果:
"message": "No query results for model [App\\Models\\Inquiry\\OutPatientOrderModel] 5563908201780521180",
3、find
$result = OutPatientOrderModel::getQuery()->with([
'detail' => function ($query) {
$query->where('is_deleted', '0')->select('img_des', 'illness_des', 'order_id', 'pkid', 'is_visit');
}
])->find($id, $fields)->toArray();
执行结果:
"message": "Call to a member function toArray() on null",
官方文档:
https://learnku.com/docs/laravel/6.x/eloquent/5176#b438f8