如何在Laravel中显示产品每月销售额

// Product.php
namespace App;

use Illuminate\Database\Eloquent\Model;

class Product extends Model
{
    public function orders()
    {
        return $this->hasMany(Order::class);
    }
}

// Order.php
namespace App;

use Illuminate\Database\Eloquent\Model;

class Order extends Model
{
    public function product()
    {
        return $this->belongsTo(Product::class);
    }
}

// SalesController.php
namespace App\Http\Controllers;

use App\Product;
use Illuminate\Http\Request;

class SalesController extends Controller
{
    public function monthlySales()
    {
        $products = Product::with('orders')->get();

        $monthlySales = [];

        foreach ($products as $product) {
            $monthlySales[$product->name] = $product->orders->groupBy(function ($order) {
                return $order->created_at->format('Y-m');
            })->map(function ($orders) {
                return $orders->sum('quantity') * $orders->first()->product->price;
            });
        }

        return view('sales.monthly', compact('monthlySales'));
    }
}

// monthly.blade.php
@foreach ($monthlySales as $productName => $sales)
    <h3>{{ $productName }}</h3>
    <ul>
        @foreach ($sales as $month => $amount)
            <li>{{ $month }}: ${{ $amount }}</li>
        @endforeach
    </ul>
@endforeach