Eloquent Query Scope on Relationships

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

Source

Also in PHP: