如何解决LaravelEloquent查询作用域重复逻辑的问题，使用protonemedia/laravel-eloquent-scope-as-select优化数据查询

<pre class="brush:php;toolbar:false;">class Post extends Model
{
    public function scopePublished($query)
    {
        return $query->whereNotNull('published_at');
    }
}

// 获取所有已发布的文章
$publishedPosts = Post::published()->get();

<pre class="brush:php;toolbar:false;">$allPosts = Post::all();
$allPosts->each(function (Post $post) {
    // 方案一：在 PHP 层面重复逻辑判断
    $isPublished = !is_null($post->published_at);
    // ... 对 $isPublished 进行操作
});

<pre class="brush:php;toolbar:false;">class Post extends Model
{
    // ...
    public function comments() { return $this->hasMany(Comment::class); }
    public function scopePublishedInCurrentYear($query) { /* ... */ }
    public function scopePopular($query) { return $query->has('comments', '>=', 10); }
}

$allPosts = Post::all();
$allPosts->each(function (Post $post) {
    // 方案二：更复杂的 PHP 层面重复逻辑，可能导致 N+1 查询问题
    $isRecentAndPopular = $post->comments()->count() >= 10
        && optional($post->published_at)->isCurrentYear();
    // ...
});

<code class="bash">composer require protonemedia/laravel-eloquent-scope-as-select</code>

<pre class="brush:php;toolbar:false;">// app/Providers/AppServiceProvider.php

use ProtoneMedia\LaravelEloquentScopeAsSelect\ScopeAsSelect;

public function boot()
{
    ScopeAsSelect::addMacro(); // 默认宏名称为 addScopeAsSelect

    // 或者你可以自定义宏名称
    // ScopeAsSelect::addMacro('withScopeAsSubQuery');
}

<pre class="brush:php;toolbar:false;">use App\Models\Post;

$posts = Post::addScopeAsSelect('is_published', function ($query) {
    $query->published();
})->get();

// 简洁写法，直接传入作用域名称字符串
$posts = Post::addScopeAsSelect('is_published', 'published')->get();

$posts->each(function (Post $post) {
    if ($post->is_published) {
        echo "文章 '{$post->title}' 已发布。\n";
    } else {
        echo "文章 '{$post->title}' 未发布。\n";
    }
});

<pre class="brush:php;toolbar:false;">use App\Models\Post;

$posts = Post::query()
    ->addScopeAsSelect('is_published_this_year_and_popular', function ($query) {
        $query->publishedInCurrentYear()->popular(); // 复用已有的作用域
    })
    ->get();

$posts->each(function (Post $post) {
    if ($post->is_published_this_year_and_popular) {
        echo "文章 '{$post->title}' 是本年度热门文章。\n";
    }
});

<pre class="brush:php;toolbar:false;">// 动态作用域：ofType('announcement')
$posts = Post::addScopeAsSelect('is_announcement', ['ofType' => 'announcement'])->get();

// 翻转结果：is_not_announcement
$posts = Post::addScopeAsSelect('is_not_announcement', ['ofType' => 'announcement'], false)->get();
// 如果 postA 是公告，则 $postA->is_announcement 为 true
// 如果 postB 不是公告，则 $postB->is_not_announcement 为 true