问题描述
我有新闻模型，当我查询新闻时，我希望它带来默认状态 = 1 的新闻.
I have News model, when i query news, i want it brings news where status = 1 as default.
News::all(); // select * from news where status = 1
News::where('anotherColumn',2)->get(); // select * from news where status = 1 and where category = 2
这可能吗?我想要的与软删除功能非常相似(它在 deleted_at 不为空的地方，如果所有数据都需要 withTrashed 功能可以使用).
Is this possible? What i want is so similar to soft delete feature (it gets where deleted_at is not null and if all data is wanted withTrashed function can be used).
我查看了文档，但找不到任何有用的信息.另外，我尝试在 News 模型的构造中处理它，但它也没有工作.
I looked docs but i couldn't find anything helpful. Also, i tried to handle it in construct at News model but it didn't worked either.
谢谢.
推荐答案
我通常会为此重写 newQuery().newQuery() 是 Eloquent 用来构造新查询的方法.
I normally override newQuery() for this. newQuery() is the method that Eloquent use to construct a new query.
class News extends Eloquent {
public function newQuery($excludeDeleted = true) {
return parent::newQuery($excludeDeleted)
->where(status, '=', 1);
}
}
现在您的 News::all() 将只输出您的状态 = 1 的新闻.
Now your News::all() will only output your news with status = 1.
这篇关于Laravel Eloquent 查询生成器默认 Where 条件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！