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]);
}
