laravel - 有没有办法结合 Laravel 查询生成器条件？

Question

假设我有 2 个查询构建器:

$builderA = User::where("happiness", ">", 5);
$builderB = User::where("color", "blue");

除了输入一个新的构建器之外，还有什么方法可以组合这 2 个构建器，从而生成如下所示的构建器？

$combined = User::where("happiness", ">", 5)->where("color", "blue");

Answer 1

对于更复杂的情况，您可以使用tap 和mergeWheres:

$where = User::where('a', 1)->where('b', '>', 2)->where('c', '<', 2)->where('d', '<>', 2);

$combined = User::where('e', 5)->tap(function (Builder $builder) use ($where) {
    $builder->mergeWheres($where->wheres, $where->getBindings());
});

Laravel 5.6 添加了几种处理子查询的方法:

• selectSub
• fromSub
• createSub
• parseSub
• whereSub