/** * Bootstrap any application services. * * @return void */ public function boot(Guard $auth) { view()->composer('*', function ($view) { $pages = Page::orderBy('position', 'asc')->get(); $view->with('pages', $pages); }); view()->composer('*', function ($view) { $view->with('currentUser', Auth::user()); }); view()->composer('sidebar.special', function ($view) { $specialProduct = Product::where('special', 1)->get(); $view->with('specialProduct', $specialProduct); }); view()->composer('sidebar.admin', function ($view) { $today = \Carbon\Carbon::today(); $orders = DB::table('orders')->where('dateOrdered', '=', $today)->where('status_id', '>', 1)->count('id'); $view->with('orders', $orders); }); view()->composer('sidebar.admin', function ($view) { $today = date('l'); $hours = DB::table('hours')->where('day', $today)->value('hours'); $view->with('hours', $hours); }); view()->composer('sidebar.admin', function ($view) { $batches = Batch::where('proddate', \Carbon\Carbon::today())->count(); $view->with('batches', $batches); }); view()->composer('sidebar.admin', function ($view) { $date = date('Y-m-d'); $shift = Shift::where('date', $date)->pluck('id'); $employeees = Shift::find($shift)->users()->count(); $view->with('employeees', $employeees); }); view()->composer('sidebar.special', function ($view) { $categories = Category::all(); $view->with('categories', $categories); }); view()->composer('*', function ($view) use($auth) { $user = Auth::user(); if (Auth::user()) { $cart = DB::table('orders')->select('id')->where('status_id', '=', 1)->where('user_id', '=', $user->id)->value('id'); $cartItems = DB::table('order_products')->where('order_id', '=', $cart)->sum('quantity'); $view->with('cartItems', $cartItems); } }); }
/** * Execute the console command. * * @return mixed */ public function handle() { $date = new \DateTime(); $date->modify('+3 days'); $formatted_date_from = $date->format('Y-m-d'); $date->modify('+6 days'); $formatted_date_to = $date->format('Y-m-d'); $dates = createDateRangeArray(strtotime($formatted_date_from), strtotime($formatted_date_to)); $bases = Base::where('center', 1)->get(); $current_gen = Gen::getCurrentGen(); $shiftSessions = ShiftSession::where('active', 1)->get(); $lastShift = Shift::where('gen_id', $current_gen->id)->orderBy('week', 'desc')->first(); $week = $lastShift ? $lastShift->week : 0; foreach ($dates as $date) { foreach ($bases as $base) { foreach ($shiftSessions as $shiftSession) { $shift = new Shift(); $shift->gen_id = $current_gen->id; $shift->base_id = $base->id; $shift->shift_session_id = $shiftSession->id; $shift->week = $week + 1; $shift->date = $date; $shift->save(); } } } $role_ids = Tab::find(35)->roles->pluck('id')->unique()->toArray(); $roles = Role::whereIn('id', $role_ids)->get(); if ($week == 0) { $week = 1; } foreach ($roles as $role) { $users = $role->users; foreach ($users as $user) { send_mail_regis_shift($user, $week, $current_gen, ['*****@*****.**']); } } $this->info('done'); }