/** * Execute the console command. * * @return mixed */ public function handle() { $days = ['sunday', 'monday', 'tuesday', 'wednesday', 'thursday', 'friday', 'saturday']; $schudules = CompanyReminderSchedule::with('company.users')->where($days[Carbon::now()->dayOfWeek], true)->get(); foreach ($schudules as $schudule) { foreach ($schudule->company->users as $user) { $orders = $this->navisionService->getUserUnconfirmedOrders($user->company->nav_code); Mail::send('user::emails.reminder', ['user' => $user, 'count' => count($orders)], function ($mail) use($user) { $mail->to($user->username)->subject('You have unconfirmed orders'); }); } } }