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

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

第一种方法

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

});

}

}

第二种方法

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;

}