Laravel雄辩查询生成器默认条件

Laravel雄辩查询生成器默认条件

本文介绍了Laravel雄辩查询生成器默认条件的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

 新闻我的新闻模型,当我查询新闻,我想要它带来的消息,其中status = 1为默认值。 ::所有(); // select * from news where status = 1 
News :: where('anotherColumn',2) - > get(); // select * from news where status = 1 and where category = 2

这可能吗?我想要的是如此类似于软删除功能(它得到的位置,delete_at不为null,如果所有数据都需要withTrashed功能可以使用)。



我看过docs我找不到任何帮助另外,我试图在新闻模型中处理它,但它也没有起作用。



谢谢。

newQuery()来解决这个问题。 newQuery()是Eloquent用来构造新查询的方法。

   - >其中(status,' =',1); 
}

}

现在您的新闻:: all()只会输出你的消息,状态= 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

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).

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.

Thanks.

解决方案

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);
    }

}

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

这篇关于Laravel雄辩查询生成器默认条件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

07-25 20:10