Eloquent Query Scope on Relationships
Problem :
$activePosts = Post::where('active', true)->get();
Solution:
class Post extends Model
{
public function scopeActive($query)
{
return $query->where('active', 1);
}
}
$activePosts = Post::active()->get();
=======================================================
Create Dynamic Scope:
class Post extends Model
{
public function scopeActive($query, $value)
{
return $query->where('active', $value);
}
}
// Get active posts
$activePosts = Post::active(true)->get();
// Get not active posts
$notActivePosts = Post::active(false)->get();
===========================================================
Scope with Relation :
$category = Category::find(1);
$activePost = $category->posts()->active(true)->get();