def METHOD_NAME(date):
    today_dt = datetime.combine(date, time())
    bookings_today = (ReservationOccurrence.query
                      .filter(ReservationOccurrence.is_valid,
                              db_dates_overlap(ReservationOccurrence,
                                               'start_dt', today_dt,
                                               'end_dt', today_dt + timedelta(days=1)))
                      .count())
    return dict(
        active_rooms=Room.query.filter_by(is_deleted=False).count(),
        buildings=Room.query.distinct(Room.building).filter_by(is_deleted=False).count(),
        pending_bookings=Reservation.query.filter(Reservation.is_pending, ~Reservation.is_archived).count(),
        bookings_today=bookings_today
    )