Laravel中如何删除数组对象且不改变原数组类型

问题说明 #

我通过foreach循环处理查询结果，同时做URL生成和删除操作——移除curtidas、compartilhamentos、comentarios三列值均为0的对象。但执行unset($posts[$key])后，$posts变成对象，无法正确转换回数组，相关代码如下：

$posts = Post::query();
$posts = $posts->leftJoin('likes', 'posts.id', '=', 'likes.post_id');
$posts = $posts->leftJoin('shares', 'posts.id', '=', 'shares.post_id');
$posts = $posts->leftJoin('comments', 'posts.id', '=', 'comments.post_id');
$posts = $posts->selectRaw('posts.id, posts.page, posts.slug, posts.title as publicacao, COUNT(likes.id) AS curtidas, COUNT(shares.id) AS compartilhamentos, COUNT(comments.id) AS comentarios');
$posts = $posts->groupBy('posts.id', 'posts.page', 'posts.slug', 'posts.title');
$posts = $posts->get();

foreach ($posts as $key => $post) {
    if($post->curtidas > 0 && $post->compartilhamentos > 0 && $post->comentarios > 0){
        $pages = Post::whichPage();
        $post->url = 'https://blogavozdocliente.com.br/blog/' . $pages[$post->page] . '/' . $post->id . '/' . $post->slug; 

        unset($post->id);
        unset($post->page);
        unset($post->slug);
    }
    else{
        unset($posts[$key]);
    }
}

return response()->json($posts);

解决方案 #

1. 修复集合unset后的格式问题 #

Laravel的get()返回的是Collection对象，直接unset集合元素会导致索引不连续，返回JSON时会变成对象而非数组。可以用values()方法重置集合索引：

// 保留原循环代码，在循环结束后添加
$posts = $posts->values(); // 重置索引，确保JSON输出为数组
return response()->json($posts);

更优雅的方式是用集合的filter()方法替代foreach中的unset操作：

$pages = Post::whichPage(); // 提前调用，避免循环内重复执行
$posts = $posts->filter(function ($post) use ($pages) {
    if ($post->curtidas > 0 && $post->compartilhamentos > 0 && $post->comentarios > 0) {
        $post->url = 'https://blogavozdocliente.com.br/blog/' . $pages[$post->page] . '/' . $post->id . '/' . $post->slug;
        unset($post->id, $post->page, $post->slug);
        return true;
    }
    return false;
})->values(); // 重置索引

return response()->json($posts);

2. 优化查询直接过滤无效记录 #

没必要在循环里删除不符合条件的记录，直接在SQL查询阶段用having条件过滤，减少后续处理：

$posts = Post::query()
    ->leftJoin('likes', 'posts.id', '=', 'likes.post_id')
    ->leftJoin('shares', 'posts.id', '=', 'shares.post_id')
    ->leftJoin('comments', 'posts.id', '=', 'comments.post_id')
    ->selectRaw('posts.id, posts.page, posts.slug, posts.title as publicacao, COUNT(likes.id) AS curtidas, COUNT(shares.id) AS compartilhamentos, COUNT(comments.id) AS comentarios')
    ->groupBy('posts.id', 'posts.page', 'posts.slug', 'posts.title')
    ->havingRaw('curtidas > 0 AND compartilhamentos > 0 AND comentarios > 0') // 直接过滤符合条件的记录
    ->get();

// 统一处理URL生成和字段移除
$pages = Post::whichPage();
$posts->transform(function ($post) use ($pages) {
    $post->url = 'https://blogavozdocliente.com.br/blog/' . $pages[$post->page] . '/' . $post->id . '/' . $post->slug;
    unset($post->id, $post->page, $post->slug);
    return $post;
});

return response()->json($posts);

这样既减少了内存开销，又避免了集合结构异常的问题，代码更简洁高效。

内容的提问来源于stack exchange，提问作者gobs