链接时，如何在括号内包装Laravel Eloquent ORM查询范围? [英] How do you wrap Laravel Eloquent ORM query scopes in parentheses when chaining?

问题描述

在Eloquent中，我想生成此查询:

In Eloquent, I'd like to generate this query:

SELECT * FROM table WHERE a=1 AND ( b=2 OR c=3 );

但是我似乎正在生成此查询:

But I seem to be generating this query instead:

SELECT * FROM table WHERE a=1 AND b=2 OR c=3;

---

这是我的实现和代码:

---

Here is my implementation and code:

$result = Model::aIsOne()->bIsTwoOrCIsThree()->get();

Model包含:

function scopeAIsOne($query) {
    return $query->where('a', 1);
}

function scopeBIsTwoOrCIsThree($query) {
    return $query->where('b', 2)->orWhere('c', 3);
}

感谢您的帮助.我搜索了包括高级位置的文档，但无济于事.

Thanks for any help. I've searched through the docs including Advanced Wheres to no avail.

推荐答案

您是否测试过whereRaw()?

Did you test whereRaw()?

因此您的函数应如下所示:

so your function should look like:

function scopeIsFeaturedOrIsBlogPost($query) {
    return $query->whereRaw('( isFeatured = "true" OR type = "blogPost" )');
}

ps.这未经测试

这篇关于链接时，如何在括号内包装Laravel Eloquent ORM查询范围?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！