Laravel雄辩查询生成器默认条件 [英] Laravel Eloquent Query Builder Default Where Condition

问题描述

 新闻我的新闻模型，当我查询新闻，我想要它带来的消息，其中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雄辩查询生成器默认条件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！