public function payment(Request $request)
 {
     $rules = array('no_invoice' => 'required', 'account_name' => 'required', 'bank_account' => 'required', 'bank_name' => 'required', 'admin_account' => 'required', 'total_transfer' => 'required', 'transfer_date' => 'required');
     $validator = Validator::make($request->all(), $rules);
     if (!$validator->fails()) {
         $order = Order::where('no_invoice', $request->no_invoice)->first();
         if (!is_null($order)) {
             $payment = new PaymentConfirmation();
             $payment->no_invoice = $order->no_invoice;
             $payment->account_name = $request->account_name;
             $payment->bank_account = $request->bank_account;
             $payment->bank_name = $request->bank_name;
             $payment->admin_account = $request->admin_account;
             $payment->total_transfer = $request->total_transfer;
             $payment->transfer_date = $request->transfer_date;
             $payment->order_id = $order->id;
             $payment->save();
             $order->order_status = "Telah Dibayar";
             $order->save();
             $orderdetail = OrderDetail::where('order_id', $order->id)->get();
             foreach ($orderdetail as $detail) {
                 $product = Product::where('id', $detail->product_id)->first();
                 $product->sold += $detail->quantity;
                 $product->save();
             }
             return redirect('konfirmasi_pembayaran')->with('success', 'Konfirmasi berhasil .Kami akan mengecek pembayaran Anda');
         } else {
             return redirect('konfirmasi_pembayaran')->with('failed', 'Maaf no invoice tidak terdaftar');
         }
     } else {
         return redirect('konfirmasi_pembayaran')->with('failed', 'Silahkan isi form sesuai yang disediakan');
     }
 }