public function orderTotal($orderId)
{
$items = OrderItem::where('order_id', '=', $orderId)->get();
$total = 0;
foreach ($items as $item) {
$total += $item->quantity * $item->price;
}
return $total;
}
public function download($orderId, $filename)
{
$fileid = \App\File::where('filename', $filename)->first();
$orderItem = OrderItem::where('order_id', '=', $orderId)->where('file_id', $fileid->id)->first();
if (!$orderItem) {
redirect('/failed');
}
$entry = \App\File::where('filename', $filename)->first();
$file = Storage::disk('local')->get($entry->filename);
return (new Response($file, 200))->header('Content-Type', $entry->mime);
}
public function show($id)
{
$orderItems = OrderItem::where('order_id', $id)->get();
return view('order.show', compact('orderItems'));
}
public function getOrderItems($orderId)
{
return OrderItem::where('order_id', $orderId)->get();
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
$order = Order::findOrFail($id);
$order_item = OrderItem::where('order_id', $id)->get();
//오더 아이템의 갯수만큼 텍스트 박스를 늘려서, 값을 넣어야한다.
$customer = Customer::where('order_relationship', $id)->first();
if ($customer == null) {
$customer_name = substr($order->customer_name, 0, 6);
$customer = Customer::where('first_name', 'LIKE', "%{$customer_name}%")->first();
}
// 여기를 contact_number로 변경하고 없
//$customer = Customer::where('first_name','LIKE',"%$customer_name%")->get();
/* product_name 컬럼안의 갯수만큼 배열 변수를 만들어야한다. */
//$order->product_name_arr = explode(",",$order->product_name);
//갯수를 구한다.
//dd($order->product_name_arr);
return view('order.edit', compact('order', 'customer', 'order_item'));
}