Reusable Query Logic with Eloquent Scopes: Clean Query Architecture

<?php

declare(strict_types=1);

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Builder;

class Subscription extends Model
{
    public function scopeActive(Builder $query): Builder {
        return $query->where('status', 'active')
                     ->where(fn ($q) => $q->whereNull('expires_at')->orWhere('expires_at', '>=', now()));
    }

    public function scopeExpiringWithinDays(Builder $query, int $days = 7): Builder {
        return $query->where('status', 'active')
                     ->whereBetween('expires_at', [now(), now()->addDays($days)->endOfDay()]);
    }
}