laravel 对 数据库 json 字段的查询方式汇总
public static function roleDelCheck($params)
{
$user = Auth::user();
$check = CustomField::query()->where([
'company_id' => $user['company_id'],
'field_form' => 'workorders',
'field_type' => 'workorder_role',
'extend->relate_role_id' => $params['role_id'] // json字段, 单层级
])->exists();
return responseData([
'role_id' => $params['role_id'],
'is_exist' => $check,
]);
}