/** * Show the application dashboard. * * @return Response */ public function index() { $private = Order::whereRaw('(status = 1 OR status = 2) AND prio = 0')->orderBy('order_id', 'desc')->whereHas("customer", function ($query) { $query->where("business", "=", '0'); })->get(); $company = Order::whereRaw('(status = 1 OR status = 2) AND prio = 0')->orderBy('order_id', 'desc')->whereHas("customer", function ($query) { $query->where("business", "=", '1'); })->get(); $prio = Order::where('prio', '=', '1')->whereRaw('(status = 1 OR status = 2)')->orderBy('order_id')->with("customer")->get(); $finished = Order::whereStatus('4')->with('customer')->get(); return view('home', compact('private', 'company', 'prio', 'finished')); }
public function getReport(Request $request) { $this->page->title = 'Заказы такси'; $this->page->desc = 'Текущие заказы'; // ПОЛЬЗОВАТЕЛЬ Текущие заказы $user = User::where('company', '=', $request->input('company'))->get()->first(); $this->data['company'] = $user->company; $this->data['date_from'] = $request->input('date_from'); $this->data['date_to'] = $request->input('date_to'); $this->data['orders'] = Order::whereRaw('user_id = ' . $user->id . ' AND (departure_time > now() OR arrivals_time > now())')->where('created_at', '>=', date("Y-m-d 00:00:00", strtotime($request->input('date_from'))))->where('created_at', '<=', date("Y-m-d 23:59:59", strtotime($request->input('date_to'))))->orderBy('created_at', 'DESC')->get(); // не олачено $this->data['nopay_orders'] = Order::whereRaw('user_id = ' . $user->id . ' AND payment_status = 0 AND (departure_time < now() AND arrivals_time < now())')->where('created_at', '>=', date("Y-m-d 00:00:00", strtotime($request->input('date_from'))))->where('created_at', '<=', date("Y-m-d 23:59:59", strtotime($request->input('date_to'))))->orderBy('created_at', 'DESC')->get(); // отображение return $this->render('reports.list-report'); }
/** * Архив заказов * * @return \Illuminate\View\View */ public function getArchive() { $this->page->title = 'Заказы такси'; $this->page->desc = 'Архив заказов'; // АДМИНИСТРАТОР Текущие заказы if (Sentinel::inRole('admin')) { $this->data['orders'] = Order::whereRaw('order_status = 3 AND payment_status = 1 AND (departure_time < now() and arrivals_time < now())')->orderBy('created_at', 'DESC')->get(); } else { $this->data['orders'] = Order::whereRaw('order_status = 3 AND payment_status = 1 AND (departure_time < now() and arrivals_time < now())')->where('user_id', Sentinel::getUser())->orderBy('created_at', 'DESC')->get(); } // АДМИНИСТРАТОР отображение return $this->render('order.list-archive'); }