Laravel操作order_service中间表报item_id无默认值及函数名错误问询

错误原因分析 #

• 报错1 Field 'item_id' doesn't have a default value：调用attach方法时仅传递了service_id，没有传入中间表要求的非空额外字段item_id、quantity、amount
• 报错2 Function name must be a string：模型关联方法语法错误，Order.php和Service.php中写完return语句后多了一行裸写的类名调用代码，属于语法错误

修复步骤 #

步骤1：修正模型关联代码 #

删除模型中多余的语法错误行，补全belongsToMany关联参数：

Order.php

protected $guarded = [];
public function services()
{
    return $this->belongsToMany(Service::class, 'order_service', 'order_id', 'service_id')
                ->withPivot('item_id', 'quantity', 'amount');
}

Service.php

protected $guarded = [];
public function orders()
{
    return $this->belongsToMany(Order::class, 'order_service', 'service_id', 'order_id')
                ->withPivot('item_id', 'quantity', 'amount');
}

注意：withPivot仅需要填写两个关联外键之外的额外中间表字段即可，无需重复传入order_id和service_id

步骤2：修正控制器插入逻辑 #

首先确保前端提交的serviceOrders数组每个子项都包含service_id、item_id、quantity、amount字段，再调整attach传参逻辑：

public function store(Request $request)
{
    $data = $request->validate([
        'total' => 'required|numeric',
        'serviceOrders' => 'required|array',
        'serviceOrders.*.service_id' => 'required|exists:services,id',
        'serviceOrders.*.item_id' => 'required|exists:items,id',
        'serviceOrders.*.quantity' => 'required|integer|min:1',
        'serviceOrders.*.amount' => 'required|numeric|min:0',
    ]);
    
    $order = Order::create($data);
    
    if ($request->serviceOrders) {
        foreach ($request->serviceOrders as $serviceItem) {
            // 第一个参数传关联的service_id，第二个参数传中间表额外字段
            $order->services()->attach(
                $serviceItem['service_id'],
                [
                    'item_id' => $serviceItem['item_id'],
                    'quantity' => $serviceItem['quantity'],
                    'amount' => $serviceItem['amount']
                ]
            );
        }
    }
    
    // 后续返回响应逻辑自行补充
}

可选性能优化：批量插入 #

避免循环调用attach降低性能，可使用syncWithoutDetaching批量插入中间表数据：

$pivotData = collect($request->serviceOrders)->mapWithKeys(function ($item) {
    return [
        $item['service_id'] => [
            'item_id' => $item['item_id'],
            'quantity' => $item['quantity'],
            'amount' => $item['amount']
        ]
    ];
})->toArray();

$order->services()->syncWithoutDetaching($pivotData);

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