themsaid/ergodnc

use App\Models\Reservation;
use App\Notifications\HostReservationStarting;
use App\Notifications\UserReservationStarting;
use Illuminate\Console\Command;
use Illuminate\Support\Facades\Notification;
 
class SendDueReservationsNotifications extends Command
{
    protected $signature = 'ergodnc:send-reservations-notifications';
 
    protected $description = 'Command description';
 
    public function __construct()
    {
        parent::__construct();
    }
 
    public function handle()
    {
        Reservation::query()
            ->with('office.user')
            ->where('status', Reservation::STATUS_ACTIVE)
            ->where('start_date', now()->toDateString())
            ->each(function ($reservation) {
                    Notification::send($reservation->user, new UserReservationStarting($reservation));
                    Notification::send($reservation->office->user, new HostReservationStarting($reservation));
            });
 
        return 0;
    }
}