laravel为模型中所有查询统一添加WHERE条件

第一种方法

<?php
namespace Table;
use Illuminate\Database\Eloquent\Builder;
/**
*
*
*/
class TSingleService extends Table{
     
    protected $table = 'single_service_list';
    public $timestamps = false;

    /**
     * 设置单项服务全局查询条件
    */
    protected static function boot()
     {
         parent::boot(); // TODO: Change the autogenerated stub
         static::addGlobalScope('avaiable',function (Builder $builder){
             $builder->where('deleted_at','=',NULL);
         });
     }
}

  

第二种方法

<?php
namespace Table;

use Illuminate\Database\Eloquent\SoftDeletes;
/**
*
*
*/
class TSingleService extends Table{
    use SoftDeletes;
    protected $table = 'single_service_list';
    protected $dates = ['deleted_at'];
    public $timestamps = false;

}

  

posted @ 2020-07-29 14:10  孤独二世  阅读(2529)  评论(0编辑  收藏  举报