如何保存与Eloquent的OneToMany关系

Question

我是Laravel堆栈的新手，目前正在使用Lumen和Eloquent开发API。我需要将Order模型和它的OrderLines一起保存。但是，它没有通过。你能告诉我怎么做吗。

以下是我的型号和控制器设置：

class Order extends Model {
public function orderLines() {
return $this->hasMany('AppOrderLine')
}
}
class OrderLine extends Model {
.....
}
//inside OrdersController method I'm trying to save Order with Order lines received from JSON body
public function create(Request $request)
{
$orderData = $this->validate($request, [
'store' => 'required',
......
'order_status' => 'bail|required|max:20',
'delivery_date' => 'nullable|date',
'customer_id' => 'nullable|numeric',
'order_lines.*.product_id' => 'bail|required|numeric',
'order_lines.*.description' => 'bail|required|max:80',
'order_lines.*.unit_price' => 'bail|required|numeric',
'order_lines.*.discount' => 'bail|required|numeric',
'order_lines.*']);

$order = new Order($orderData);
$order->push(); // This does not save and gives me an error
$order->refresh();
return response()->json($order);
} 
//This is the json body provided in the request
{
"store" : "Some Store",
...
"order_lines" : [{
"product_id": 1,
"description": "TU001: Polka dots",
"unit_price": 1000,
"discount": 100,
"units": 2
},
{
"product_id": 2,
"description": "TU002: Polka dots",
"unit_price": 500,
"discount": 0,
"units": 1
}]
}

当我尝试使用save方法在没有订单行的情况下单独保存订单时，它是有效的。但对于OrderLine，它失败了。

有人能教我怎么做吗。我曾经在CakePHP中这样做，但不确定在Eloquent中是如何做到的。

//使用进一步信息进行编辑在生成的insert sql查询中，我看到orderLines作为Order表中的一列。从那以后，它给出了一个数组到字符串的转换错误。但实际上orderLines的插入应该在一个单独的sql查询中。

Answer 1

public function create(Request $request)
{
$this->validate($request, [
'store' => 'required',
......
'order_status' => 'bail|required|max:20',
'delivery_date' => 'nullable|date',
'customer_id' => 'nullable|numeric',
'order_lines.*.product_id' => 'bail|required|numeric',
'order_lines.*.description' => 'bail|required|max:80',
'order_lines.*.unit_price' => 'bail|required|numeric',
'order_lines.*.discount' => 'bail|required|numeric',
'order_lines.*'
]);
$order = new Order($request->except('order_lines'));
$order->save();
$order->orderLines()->createMany($request->input('order_lines'));
$order->load('order_lines'); //not sure that you need this line
return $order;
}