public function update($id, Request $request)
    {
        $order = Order::findOrFail($id);

        $clientName = $request->input('client_name');
        $warehouse = $request->input('warehouse');
        $shipping = $request->input('shipping');
        $phone = $request->input('client_phone');
        $express = $request->input('express');
        $awb = $request->input('awb');
        $notes= $request->input('notes');

        $productName = $request->input('product_name');
        $productSeries = $request->input('product_series');
        $productQty = $request->input('product_qty');
        $productPrice = $request->input('product_price');

        $order->client_name = $clientName;
        $order->warehouse = $warehouse;
        $order->shipping = $shipping;
        $order->express = $express;
        $order->awb = $awb;
        $order->notes = $notes;
        $order->client_phone = $phone;

        $order->save();
        $totalOrder = 0;

        foreach($productName as $key => $product){

            $order->products()->attach($product, ['product_qty' => $productQty[$key], 'product_series' => $productSeries[$key]]);

            $order->products()->updateExistingPivot($product, ['product_price_two' => $productPrice[$key]]);

            $toUpdateProduct = Product::find($product);

            $toUpdateProduct->product_qty -= $productQty[$key];

            $toUpdateProduct->total_sold += $productQty[$key];

            $toUpdateProduct->save();

            $totalOrder += ($productPrice[$key] * $productQty[$key]);
        }

        $order->total_order = $totalOrder;
        $order->save();
        dd($request->all());

        return redirect()->route('orders_list');
    }