/* 
 * List of all exclusions (listed in order)
 *
 * Past Dates
 * Weekends
 * Martin Luther King Jr. Day
 * SPRING BREAK
 * FINALS WEEK (SPRING)
 * SUMMER TRANSITION
 * Memorial Day
 * Fourth of July
 * FALL TRANSITION
 * Labor Day
 * FALL BREAK
 * THANKSGIVING BREAK
 * FINALS WEEK (FALL)
 * WINTER BREAK
 *
 * NOTE: If an exclusion is written in all capitals, then that means the formula
 * for that exclusion needs to be rewritten according to the latest
 * Auburn calendar (see https://bulletin.auburn.edu/generalinformation/auburnuniversitycalendar/)
*/

// Past Dates
lessThan({Self}, {Current Date})

// Weekends
or(
    equals(formatDate({Self}, "dddd"), "Saturday"), 
    equals(formatDate({Self}, "dddd"), "Sunday")
)


// Martin Luther King Jr. Day
if(
    equals(
        formatDate({Self}, "MMMM"), "January"
    ),
    and(
        equals(formatDate({Self}, "dddd"), "Monday"),
        and(
            greaterThanOrEqual(
                formatDate({Self}, "dd"),
                "15"
            ),
            lessThanOrEqual(
                formatDate({Self}, "dd"),
                "21"
            )
        )
    ),
    not(TRUE)
)


// Spring Break
and(
    equals(formatDate({Self}, "MMMM"), "March"),
    and(
        greaterThanOrEqual(
            formatDate({Self}, "dd"),
            "11"
        ),
        lessThanOrEqual(
            formatDate({Self}, "dd"),
            "15"
        )
    )
)


// Finals Week (Spring)
or(
    and(
        equals(formatDate({Self}, "MMMM"), "April"),
        or(
            equals(formatDate({Self}, "dd"), "29"),
            equals(formatDate({Self}, "dd"), "30")
        )
    ),
    and(
        equals(formatDate({Self}, "MMMM"), "May"),
        and(
            greaterThanOrEqual(formatDate({Self}, "dd"), "01"),
            lessThanOrEqual(formatDate({Self}, "dd"), "03")
        )
    )
)

// Summer Transition (DO NOT HAVE THAT INFORMATION)

//Memorial Day 
and(
    equals(formatDate({Self}, "MMMM"), "May"),
    and(
        equals(formatDate({Self}, "dddd"), "Monday"),
        and(
            greaterThanOrEqual(
                formatDate({Self}, "dd"),
                "25"
            ),
            lessThanOrEqual(
                formatDate({Self}, "dd"),
                "31"
            )
        )
    )
)


Fourth of July
and(
    equals(formatDate({Self}, "MMMM"), "July"),
    equals(formatDate({Self}, "dd"), "04")
)


Fall Transition 
and(
    equals(formatDate({Self}, "MMMM"), "August"),
    and(
        greaterThanOrEqual(formatDate({Self}, "dd"), "06"),
        lessThanOrEqual(formatDate({Self}, "dd"), "20")
    )
)


Labor Day
and(
    equals(formatDate({Self}, "MMMM"), "September"),
    and(
        equals(formatDate({Self}, "dddd"), "Monday"),
        and(
            greaterThanOrEqual(
                formatDate({Self}, "dd"),
                "01"
            ),
            lessThanOrEqual(
                formatDate({Self}, "dd"),
                "07"
            )
        )
    )
)

Fall Break
and(
    equals(formatDate({Self}, "MMMM"), "October"),
    or(
        equals(formatDate({Self}, "dd"), "11"),
        equals(formatDate({Self}, "dd"), "12")
    )
)


// Thanksgiving Break - Split by day of Week
Monday
and(
    equals(formatDate({Self},"MMMM"), "November"), 
    if (equals(formatDate({Self},"dddd"), "Monday"), 
    and(
        greaterThanOrEqual(formatDate({Self},"dd"), "19"), 
        lessThanOrEqual(formatDate({Self},"dd"),"25"),false)
    )
)
Tuesday
and(
    equals(formatDate({Self},"MMMM"), "November"), 
    if(equals(formatDate({Self},"dddd"), "Tuesday"), 
    and(
        greaterThanOrEqual(formatDate({Self},"dd"), "20"), 
        lessThanOrEqual(formatDate({Self},"dd"),"26"),false)
    )
)
Wednesday
and(
    equals(formatDate({Self},"MMMM"), "November"), 
    if(equals(formatDate({Self},"dddd"), "Wednesday"), 
    and(
        greaterThanOrEqual(formatDate({Self},"dd"), "21"), 
        lessThanOrEqual(formatDate({Self},"dd"),"27"),false)
    )
)
Thursday
and(
    equals(formatDate({Self},"MMMM"), "November"), 
    if(equals(formatDate({Self},"dddd"), "Thursday"), 
    and(
        greaterThanOrEqual(formatDate({Self},"dd"), "22"), 
        lessThanOrEqual(formatDate({Self},"dd"),"28"),false)
    )
)
Friday
and(
    equals(formatDate({Self},"MMMM"), "November"), 
    if(equals(formatDate({Self},"dddd"), "Friday"), 
    and(
        greaterThanOrEqual(formatDate({Self},"dd"), "23"), 
        lessThanOrEqual(formatDate({Self},"dd"),"29"),false)
    )
)


// Finals Week (Fall)
and(
    equals(formatDate({Self}, "MMMM"), "December"),
    or(
        greaterThanOrEqual(
            formatDate({Self}, "dd"),
            "10"
        ),
        lessThanOrEqual(
            formatDate({Self}, "dd"),
            "14"
        )
    )
)


// Invalidate Summer before Summer Registration
or(
    or(
        and(
            equals(formatDate(DATE, "MMMM"), "May"), 
            greaterThanOrEqual(formatDate(DATE, "dd"), "6")
        ), 
        equals(formatDate(DATE, "MMMM"), "June")
    ), 
    or(
        equals(formatDate(DATE, "MMMM"), "July"), 
        and(
            equals(formatDate(DATE, "MMMM"), "August"), 
            lessThanOrEqual(formatDate(DATE, "dd"), "17")
        )
    )
)


// Winter Break
or(
    and(
        equals(formatDate({Self}, "MMMM"), "December"),
        and(
            greaterThanOrEqual(formatDate({Self}, "dd"), "17"),
            lessThanOrEqual(formatDate({Self}, "dd"), "31")
        )
    ),
    and(
        equals(formatDate({Self}, "MMMM"), "January"),
        and(
            greaterThanOrEqual(formatDate({Self}, "dd"), "01"),
            lessThanOrEqual(formatDate({Self}, "dd"), "08")
        )
    )
)