Understanding Query Scopes in Eloquent Laravel Meetup Okinawa #3 nunulk

Who am I? $I->am(‘nunulk’) ->workAs(‘a freelance programmer’) ->tackleComplexityOfSoftware()
 ->with([
 ‘Domain-Driven Design’,
 ‘Laravel’
 ]);

Global Scopes “Global scopes allow you to add constraints to all queries for a given model.” Eloquent: Getting Started - Laravel

Global Scopes “Global scopes allow you to add constraints to all queries for a given model.” Eloquent: Getting Started - Laravel

Global Scope class Task extends Model
 {
 } // retrieving todo list
 $todos = Task::whereNull(‘done_at’)->get();


Global Scope class Task extends Model
 {
 protected static function boot()
 {
 parent::boot(); // applied to all queries
 static::addGlobalScope(‘todo’, new TodoScope());
 }
 } // retrieving todo list
 $todos = Task::all();
 


Global Scope class TodoScope implements Scope
 {
 public function apply(Builder $builder)
 {
 // applied to all queries
 $builder->whereNull('done_at');
 }
 } // retrieving todo list
 $todos = Task::all();

Global Scope class TodoScope implements Scope
 {
 public function apply(Builder $builder)
 {
 // applied to all queries
 $builder->whereNull('done_at');
 } public function extend(Builder $builder, Model $model) { $builder->macro('done', function (Builder $builder) { return $builder->withoutGlobalScope($this) ->whereNotNull('done_at'); }); }
 } // retrieving done list
 $todos = Task::done()->get();

Local Scopes “Local scopes allow you to define common sets of constraints that you may easily re-use throughout your application.” Eloquent: Getting Started - Laravel

Local Scopes “Local scopes allow you to define common sets of constraints that you may easily re-use throughout your application.” Eloquent: Getting Started - Laravel

Local Scopes class Task extends Model
 {
 } // retrieving expired todo list
 Task::->where(‘deadline’, ‘<’, Carbon::now())->get();

Local Scopes class Task extends Model
 {
 public function scopeExpired(Builder $builder, Carbon $date)
 {
 return $builder->where(‘deadline’, ‘<’, $date);
 }
 } // retrieving expired todo list
 Task::expired(Carbon::now())->get();

Query Scopes ˒Global Scopes •Scope interface •apply, extend •macro ˒Local Scopes •scope query method