php - 拉拉维尔 : Nested relation search

Question

我有两个嵌套关系，一个是 requester.link 和 requester.company，我希望两者都搜索单词 $request->search .

代码是不言自明的:

$clients = \App\AcceptedConnection::with('requester.link', 'requester.company')
    ->where('accepter_id', Auth::user()->id)
    ->orWhereHas('requester.link', function ($query) use ($request) {
        $query->orWhere('name', $request->search);
    })->orWhereHas('requester.company', function ($query) use ($request) {
        $query->orWhere('email', $request->search);
        $query->orWhere('firstname', $request->search);
        $query->orWhere('lastname', $request->search);
    })->get();

它为我提供任何搜索的记录，即使搜索不匹配，它也会返回记录，搜索任何内容，它都会为您提供记录，

我错过了什么？

Answer 1

您正在检查 accepter_id=Auth::user()->id OR 记录是否与您的搜索词匹配。

您必须将 whereHas() 检查包装到闭包中:

$clients = \App\AcceptedConnection::with('requester.link', 'requester.company')
    ->where('accepter_id', Auth::user()->id)
    ->where(function($query) use ($request) {
        $query->whereHas('requester.link', function ($query) use ($request) {
            $query->orWhere('name', $request->search);
        })->orWhereHas('requester.company', function ($query) use ($request) {
            $query->orWhere('email', $request->search);
            $query->orWhere('firstname', $request->search);
            $query->orWhere('lastname', $request->search);
        });
    })->get()