Laravel Eloquent关系与不起作用

Question

我正在尝试此代码，但在whith中where查询不起作用有人能解决这个问题吗？

Quotation::with(['QuoParts', 'client'=>function($cq){
$cq->orWhere('first_name', 'LIKE', '%Muhammad%');
}, 'user'])->orWhere(function($q) use ($s){
$q->orWhere('sku', 'LIKE', '%'.$s.'%');
$q->orWhere('issue_date', 'LIKE', '%'.$s.'%');

})->take($length)->skip($r->start)->get();

Answer 1

$posts = AppUser::whereHas('posts', function (Builder $query) {
$query->where('name', 'like', `foo%');
})->get();

Answer 2

您应该使用where()，然后使用orWhere()

Quotation::with([
'QuoParts', 'user', 'client' => function ($cq) {
$cq->where('first_name', 'LIKE', '%Muhammad%');
},
])->where(function ($q) use ($s) {
$q->where('sku', 'LIKE', '%' . $s . '%');
$q->orWhere('issue_date', 'LIKE', '%' . $s . '%');
})->take($length)->skip($r->start)->get();

Answer 3

经过大量搜索，我通过使用WhereHas闭包function解决了这个问题

$q = Quotation::with(['QuoParts', 'user', 'client'])->whereHas('client', function ($query) use ($s) {
$query->where('sku', 'like', '%' . $s . '%');
$query->orWhere('first_name', 'like', '%' . $s . '%');
$query->orWhere('last_name', 'like', '%' . $s . '%');
})->orWhereHas('user', function ($query) use ($s) {
$query->where('name', 'like', '%' . $s . '%');

})
->orWhere(function ($q) use ($s) {
$q->orWhere('sku', 'LIKE', '%' . $s . '%');
$q->orWhere('issue_date', 'LIKE', '%' . $s . '%');
})
->take($length)
->skip($r->start)
->get();```