/** * Show the application dashboard to the user. * */ public function index() { $timezone = 1; $order = J2storeOrder::all(); $total = floatval(J2storeOrder::isValid()->sum('order_total')); $orderInfo = J2storeOrderInfo::join('u16w2_j2store_orders', function ($q) { $q->on('u16w2_j2store_orderinfo.order_id', '=', 'u16w2_j2store_orders.order_id'); })->orderBy('created_date', 'desc')->get(); return view('home', compact('orderInfo', 'order', 'total', 'timezone')); }
/** * @return \Illuminate\View\View */ public function index() { $timezone = 1; $order = J2storeOrder::all(); $orderInfo = J2storeOrderInfo::join('u16w2_j2store_orders', function ($q) { $q->on('u16w2_j2store_orderinfo.order_id', '=', 'u16w2_j2store_orders.order_id'); })->orderBy('created_date', 'desc')->get(); $orderItem = J2storeOrderItem::all(); $wait = $order->where('order_state_id', '1')->count(); $confirm = $order->where('order_state_id', '2')->count(); $stop = $order->where('order_state_id', '3')->count(); $road = $order->where('order_state_id', '4')->count(); return view('pages.commandes.histo', compact('orderInfo', 'order', 'orderItem', 'wait', 'confirm', 'stop', 'road', 'timezone')); }