Laravel Eloquent Query Builder 默认的 Where 条件

时间:2023-03-03
本文介绍了Laravel Eloquent Query Builder 默认的 Where 条件的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

问题描述

我有新闻模型,当我查询新闻时,我希望它带来新闻,默认状态 = 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 不为空的地方,如果需要所有数据,可以使用Trashed 函数).

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() 只会输出 status = 1 的新闻.

Now your News::all() will only output your news with status = 1.

这篇关于Laravel Eloquent Query Builder 默认的 Where 条件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

上一篇:将图像从android上传到PHP服务器 下一篇:如何在 Laravel 中对自定义查询的结果进行分块

相关文章