Laravel 9中无ID未提交带子项表单的处理方案咨询

针对Laravel 9 + PHP 8.1 + Livewire环境下采购订单（PO）父子行关联的问题，推荐以下两种落地性强的方案，解决无父ID、验证规则、孤立项等核心痛点：

方案1：前端临时标识+后端事务批量创建 #

核心逻辑 #

前端用临时ID（如uniqid()）维护子行数据，提交时先验证父表单+子行整体规则（确保至少1条子行），再通过数据库事务原子化创建父PO和子行——事务失败则全量回滚，彻底避免孤立项。

代码实现 #

Livewire组件

<?php

namespace App\Http\Livewire\PurchaseOrders;

use App\Models\PurchaseOrder;
use App\Models\PurchaseOrderItem;
use Illuminate\Support\Facades\DB;
use Livewire\Component;

class Create extends Component
{
    // 父PO字段
    public $supplier_id;
    public $order_date;
    public $notes;

    // 子行数组，带临时ID用于编辑/删除
    public $items = [];

    // 添加子行
    public function addItem()
    {
        $this->items[] = [
            'temp_id' => uniqid(),
            'product_id' => '',
            'quantity' => 1,
            'unit_price' => 0,
        ];
    }

    // 删除子行
    public function removeItem($tempId)
    {
        $this->items = collect($this->items)->reject(fn($item) => $item['temp_id'] === $tempId)->values()->toArray();
    }

    // 验证规则：强制子行数量≥1
    protected function rules()
    {
        return [
            'supplier_id' => 'required|exists:suppliers,id',
            'order_date' => 'required|date',
            'notes'' => 'nullable|string',
            'items' => 'required|array|min:1',
            'items.*.product_id' => 'required|exists:products,id',
            'items.*.quantity' => 'required|integer|min:1',
            'items.*.unit_price' => 'required|numeric|min:0.01',
        ];
    }

    // 提交表单（事务包裹）
    public function submit()
    {
        $this->validate();

        DB::transaction(function () {
            // 1. 创建父PO
            $po = PurchaseOrder::create([
                'supplier_id' => $this->supplier_id,
                'order_date' => $this->order_date,
                'notes' => $this->notes,
            ]);

            // 2. 批量创建子行
            $batchItems = collect($this->items)->map(fn($item) => [
                'purchase_order_id' => $po->id,
                'product_id' => $item['product_id'],
                'quantity' => $item['quantity'],
                'unit_price' => $item['unit_price'],
                'created_at' => now(),
                'updated_at' => now(),
            ])->toArray();

            PurchaseOrderItem::insert($batchItems);
        });

        session()->flash('success', '采购订单创建成功');
        return redirect()->route('purchase-orders.index');
    }

    public function render()
    {
        return view('livewire.purchase-orders.create');
    }
}

Blade视图核心片段

<form wire:submit.prevent="submit">
    <!-- 父PO字段省略 -->

    <!-- 子行操作区 -->
    <div class="mb-4">
        <button type="button" wire:click="addItem" class="btn btn-primary mb-2">添加商品</button>
        @error('items') <span class="text-red-500">{{ $message }}</span> @enderror

        @foreach($items as $index => $item)
            <div class="flex gap-2 mb-2" wire:key="item-{{ $item['temp_id'] }}">
                <select wire:model="items.{{ $index }}.product_id" class="form-control flex-1"></select>
                <input type="number" wire:model="items.{{ $index }}.quantity" class="form-control w-20" min="1">
                <input type="number" wire:model="items.{{ $index }}.unit_price" class="form-control w-24" step="0.01" min="0.01">
                <button type="button" wire:click="removeItem('{{ $item['temp_id'] }}')" class="btn btn-danger">删除</button>

                @error("items.$index.product_id") <span class="text-red-500 block">{{ $message }}</span> @enderror
            </div>
        @endforeach
    </div>

    <button type="submit" class="btn btn-success">创建采购订单</button>
</form>

方案2：改进版草稿模式（解决孤立项问题） #

核心逻辑 #

给PO模型添加user_id（关联创建者）、is_draft（草稿标记）、expires_at（过期时间）字段，强制草稿必须包含至少1条子行，同时通过定时任务清理过期草稿，彻底解决孤立项。

代码实现 #

模型迁移

Schema::table('purchase_orders', function (Blueprint $table) {
    $table->foreignId('user_id')->constrained();
    $table->boolean('is_draft')->default(true);
    $table->timestamp('expires_at')->nullable();
});

Livewire组件新增草稿保存方法

public function saveDraft()
{
    $this->validate(array_merge($this->rules(), [
        'items' => 'required|array|min:1',
    ]));

    DB::transaction(function () {
        // 查找当前用户的未过期草稿，不存在则创建
        $po = PurchaseOrder::firstOrCreate(
            ['user_id' => auth()->id(), 'is_draft' => true, 'expires_at' => '>', now()],
            [
                'supplier_id' => $this->supplier_id,
                'order_date' => $this->order_date,
                'notes' => $this->notes,
                'expires_at' => now()->addDay(),
            ]
        );

        // 更新草稿：先删旧子行，再新增当前子行
        $po->items()->delete();
        foreach ($this->items as $item) {
            $po->items()->create([
                'product_id' => $item['product_id'],
                'quantity' => $item['quantity'],
                'unit_price' => $item['unit_price'],
            ]);
        }
    });

    session()->flash('success', '草稿已保存');
}

过期草稿清理命令

<?php

namespace App\Console\Commands;

use App\Models\PurchaseOrder;
use Illuminate\Console\Command;

class CleanExpiredDrafts extends Command
{
    protected $signature = 'drafts:clean';
    protected $description = '清理过期的采购订单草稿';

    public function handle()
    {
        $deleted = PurchaseOrder::where('is_draft', true)
            ->where('expires_at', '<=', now())
            ->delete();

        $this->info("已清理 {$deleted} 条过期草稿");
        return 0;
    }
}

调度定时任务（app/Console/Kernel.php）

protected function schedule(Schedule $schedule)
{
    $schedule->command('drafts:clean')->daily();
}

方案对比 #

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