Conteúdo Acessório Área de Pedidos - Admin Filament

create_order_items_table.php

<?php
#up
Schema::create('order_items', function (Blueprint $table) {
    $table->id();

    $table->foreignId('order_id')
        ->constrained('user_orders')
        ->cascadeOnDelete();

    $table->foreignId('product_id')
        ->constrained()
        ->cascadeOnDelete();

    $table->integer('amount');
    $table->integer('order_value');

    $table->timestamps();
});

#down
Schema::dropIfExists('order_items');

create_user_ordes_table.php

<?php
#up
Schema::create('user_orders', function (Blueprint $table) {
    $table->id();
    $table->uuid('order_code');
    $table->foreignId('user_id')->constrained()->cascadeOnDelete();
    $table->timestamps();
});

#down
Schema::dropIfExists('user_orders');

DatabaseSeeder.php

<?php

#up seed

$user = \App\Models\User::factory()
            ->hasOrders(1)
            ->create();

$order = $user->orders->first();

foreach (\App\Models\Product::orderByRaw('RANDOM()')->take(4)->get() as $prod) {
    $amount = rand(1, 5);

    $order->items()->create([
        'product_id' => $prod->id,
        'amount' => $amount,
        'order_value' => $prod->price * $amount
    ]);

UserOrder.php

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\BelongsTo;

class UserOrder extends Model
{
    use HasFactory;

    public function items()
    {
        return $this->hasMany(OrderItem::class, 'order_id');
    }
}

UserOrderFactory.php

<?php

namespace Database\Factories;

use Illuminate\Database\Eloquent\Factories\Factory;

/**
 * @extends \Illuminate\Database\Eloquent\Factories\Factory<\App\Models\UserOrder>
 */
class UserOrderFactory extends Factory
{
    /**
     * Define the model's default state.
     *
     * @return array<string, mixed>
     */
    public function definition(): array
    {
        return [
            'order_code' => $this->faker->uuid()
        ];
    }
}