public function detail(Request $request) { $validator = Validator::make($request->all(), ['order' => 'required']); if ($validator->fails()) { return Response::json(array('result' => false, 'data' => 'parameter not found.')); } $orders_number = $request->input('order'); $order = Orders::where('orders_number', $orders_number)->get()->first(); $order_detail = Orders_detail::where('orders_number', $orders_number)->get(); foreach ($order_detail as $key => $value) { # code... $pro = DB::table('products_vol')->join('products', 'products.id', '=', 'products_vol.products_id')->where('products_vol.code', $value->product_vol_code)->first(); $value->product_name = $pro->name; } if ($order != null && $order_detail != null) { return Response::json(array('result' => true, 'order' => $order, 'detail' => $order_detail)); } return Response::json(array('result' => false, 'data' => 'some thing is wrong.')); }
public function showInvoice(Request $request) { $rules = array('order' => 'required'); $validator = \Validator::make($request->all(), $rules); if ($validator->fails()) { return Response::json(array('result' => false, 'data' => 'กลับไปที่หน้าแรก โปรดตรวจสอบข้อมูลใหม่อีกครั้ง')); } $order = Orders::where("orders_number", $request->input('order'))->get()->first(); $orders_detail = Orders_detail::where("orders_number", $order->orders_number)->get(); $point_total = 0; $amount_total = 0; foreach ($orders_detail as $key => $value) { # code... $pro = DB::table('products_vol')->join('products', 'products.id', '=', 'products_vol.products_id')->where('products_vol.code', $value->product_vol_code)->first(); $value->product_name = $pro->name; $value->point = $pro->point; $point_total += $value->point * $value->product_vol_qty; $amount_total += $value->product_vol_qty; //product_vol_qty } $point_total = $point_total + ($amount_total - 1); // $total_grand = $request->input('total') + $request->input('trans'); // $user = array('name'=>$request->input('name') , 'address' => $request->input('address') // , 'phone'=>$request->input('phone') , 'trans' => $request->input('trans')); // $order = array('total'=>$request->input('total') , 'trans'=>$request->input('trans') , 'total_grand'=> $total_grand); return view('order.invoiceview', ['orders_detail' => $orders_detail, 'order' => $order, 'point_total' => $point_total]); }