查询返回数据库中的所有项

如果你想得到数据 is_succcessfully_created = true 和 (("order_no", "like", "%{$req->search}%") or ("traveler_first_name", "like", "%{$req->search}%") ...) ,您可以这样写:

$orders = Order::with([
            "logs"
        ])->where("is_succcessfully_created", true)
            ->where(function ($query) {
                $query->where("order_no", "like", "%{$req->search}%")
                    ->orWhere("traveler_first_name", "like", "%{$req->search}%")
                    ->orWhere("traveler_last_name", "like", "%{$req->search}%")
                    ->orWhere("contact_person_first_name", "like", "%{$req->search}%")
                    ->orWhere("contact_person_last_name", "like", "%{$req->search}%")
                    ->orWhere("contact_person_email", "like", "%{$req->search}%")
                    ->orWhere("contact_person_primary_phone", "like", "%{$req->search}%")
                    ->orWhere("contact_person_alternate_phone", "like", "%{$req->search}%")
                    ->orWhere("return_person_name", "like", "%{$req->search}%")
                    ->orWhere("return_person_phone", "like", "%{$req->search}%")
            })->get();

是的,可能有问题,因为 orWhere 声明。

在你的情况下,如果没有 succcessfully_created 然后,查询将搜索一条满足其余记录之一的记录。 何处 声明。

所以你得到 全部或几乎全部 命令的

您应该将all orwhere语句放入嵌套的where函数中:

->where("is_succcessfully_created", true)
->orWhere(function($query) {
     ...
     all current orWhere go here 
     ...
})