public function getDeclined() { $orders = Order::whereStatus(-1)->get(); $pageData = self::orderPageData('pending', 1, 1, 1, 0); $pageData['table'] = $orders; return view('panel.orders', $pageData); }
public function __construct() { // Глобальная перменная для шаблона - залогиненный пользователь view()->share('auser', Auth::user()); // Количество новых заказов view()->share('newOrdersCount', Order::whereStatus(1)->count()); }
/** * 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')); }