评价数的计算逻辑有问题？

个人觉得应该根据 Order 的 reviewed 计算，$query->whereNotNull('paid_at') 换为 $query->where('reviewed', 1)

个人愚见，跟id大小其实没有关系，whereHas 只是查询出了这款商品的已支付订单，并不能保证其他支付的订单也评论了

whereHas('order', function($query) {
    $query->whereNotNull('paid_at');
}

我觉得修改成这样比较合理

$reviews = OrderItem::query()->with(['order.user', 'productSku'])
        ->where('product_id', $product->id)
        ->whereNotNull('reviewed_at')
        ->orderBy('reviewed_at', 'desc')
        ->limit(10)
        ->get();

我觉得应该这样

    public function handle(OrderReviewed $event)
    {
        $items = $event->getOrder()->items()->with(['product'])->get();
        foreach ($items as $item) {
            $result = OrderItem::query()
                ->where('product_id', $item->product_id)
                ->whereNotNull('reviewed_at')  <-- 加了这句
                ->whereHas('order', function ($query) {
                    $query->whereNotNull('paid_at');
                })
                ->first([
                    DB::raw('count(*) as review_count'),
                    DB::raw('avg(rating) as rating'),
                ]);
            // 更新商品评分和评价
            $item->product->update([
                'rating'       => $result->rating,
                'review_count' => $result->review_count,
            ]);
        }
    }