DEBUG
8
WITH cteSection AS
(
/* OG
SELECT ROW_NUMBER() OVER (
PARTITION BY JSON_VALUE(AccuRecTrac.DataJSON, '$.arsection_activitycode')
Order BY JSON_VALUE(AccuRecTrac.DataJSON, '$.arsection_activitycode'),
JSON_VALUE(AccuRecTrac.DataJSON, '$.arsection_section')
) AS RowNum,
JSON_VALUE(AccuRecTrac.DataJSON, '$.arsection_activitycode') AS ActivityCode,
JSON_VALUE(AccuRecTrac.DataJSON, '$.arsection_section') AS SectionNum,
JSON_VALUE(AccuRecTrac.DataJSON, '$.arsection_brochurecode') AS BrochureCode,
JSON_VALUE(AccuRecTrac.DataJSON, '$.arsection_brochuretext') AS ActivityDescription,
JSON_VALUE(AccuRecTrac.DataJSON, '$.arsection_facilitylocation') AS LocationCode,
JSON_VALUE(AccuRecTrac.DataJSON, '$.arsection_displayonweb') AS Display
FROM AccuRecTrac
WHERE AccuRecTrac.TableName LIKE 'arsection'
-- [X] TODO - move to api filter
AND JSON_VALUE(AccuRecTrac.DataJSON, '$.arsection_archived') = 'false'
--AND JSON_VALUE(AccuRecTrac.DataJSON, '$.arsection_displayonweb') LIKE 'Yes'
*/
SELECT ROW_NUMBER() OVER (
PARTITION BY activitycode
Order BY activitycode,
section
) AS RowNum,
activitycode AS ActivityCode,
section AS SectionNum,
brochurecode AS BrochureCode,
brochuretext AS ActivityDescription,
facilitylocation AS LocationCode
FROM AccuRecTrac_arsection
),
cteSectionFilter AS
(
/* OG
SELECT DISTINCT JSON_VALUE(AccuRecTrac.DataJSON, '$.arsection_activitycode') AS ActivityCode
FROM AccuRecTrac
WHERE AccuRecTrac.TableName LIKE 'arsection'
-- [X] TODO - move to api filter
AND JSON_VALUE(AccuRecTrac.DataJSON, '$.arsection_displayonweb') LIKE 'Yes'
*/
SELECT DISTINCT activitycode AS ActivityCode
FROM AccuRecTrac_arsection
WHERE 1 = 1
AND (subtype LIKE 'EC w Adult'OR subtype LIKE 'EC wout Adult')
),
cteBrochure AS
(
SELECT JSON_VALUE(AccuRecTrac.DataJSON, '$.sacommentcode_commentcode') AS BrochureCode,
JSON_VALUE(AccuRecTrac.DataJSON, '$.sacommentcode_comments') AS ActivityDescription
FROM AccuRecTrac
WHERE AccuRecTrac.TableName LIKE 'sacommentcode'
)
/* OG
SELECT DISTINCT JSON_VALUE(ART.DataJSON, '$.aractivity_activitycode') AS ActivityCode,
JSON_VALUE(ART.DataJSON, '$.aractivity_shortdescription') AS Title,
JSON_VALUE(ART.DataJSON, '$.aractivity_typecode') AS TypeCode,
CASE WHEN Brochure.ActivityDescription IS NOT NULL THEN Brochure.ActivityDescription ELSE SecDesc.ActivityDescription END AS ActivityDescription,
SecDesc.SectionNum as SectionNum,
SecDesc.RowNum
FROM AccuRecTrac AS ART
INNER JOIN cteSection AS SecDesc ON SecDesc.ActivityCode = JSON_VALUE(ART.DataJSON, '$.aractivity_activitycode')
LEFT JOIN cteBrochure AS Brochure ON Brochure.BrochureCode = SecDesc.BrochureCode
-- [] TODO - uncomment as the fallback skip activities with no sections returned will mess with pagination by possibly having less than rpp on a page
--INNER JOIN cteSectionFilter AS Filter ON Filter.ActivityCode = SecDesc.ActivityCode
WHERE ART.TableName LIKE 'aractivity'
-- [X] TODO - move to api filter
AND JSON_VALUE(ART.DataJSON, '$.aractivity_activitycode') <> ''
-- [X] TODO - move to api filter
AND SecDesc.ActivityDescription <> ''
AND RowNum = 1
-- [X] TODO - move to api filter
AND SecDesc.Display LIKE 'Yes'
*/
SELECT DISTINCT ART.activitycode AS ActivityCode,
ART.shortdescription AS Title,
ART.typecode AS TypeCode,
CASE WHEN Brochure.ActivityDescription IS NOT NULL THEN Brochure.ActivityDescription ELSE SecDesc.ActivityDescription END AS ActivityDescription,
SecDesc.SectionNum as SectionNum,
SecDesc.RowNum
FROM AccuRecTrac_aractivity AS ART
INNER JOIN cteSection AS SecDesc ON SecDesc.ActivityCode = ART.activitycode
LEFT JOIN cteBrochure AS Brochure ON Brochure.BrochureCode = SecDesc.BrochureCode
-- [] TODO - uncomment as the fallback skip activities with no sections returned will mess with pagination by possibly having less than rpp on a page
INNER JOIN cteSectionFilter AS Filter ON Filter.ActivityCode = SecDesc.ActivityCode
WHERE SecDesc.RowNum = 1
AND (/* OG JSON_VALUE(ART.DataJSON, '$.aractivity_typecode') LIKE 'Nature' */ ART.typecode LIKE 'Nature')
/* OG
ORDER BY JSON_VALUE(ART.DataJSON, '$.aractivity_typecode')
*/
ORDER BY ART.typecode
;
5160202 / Science Kids
See the world through science goggles. Each session features a different scientific topic, and each week dives deeper into that topic through fun experiments, observations, games, crafts, and outdoor hikes. Please send you child with a peanut/tree nut free snack and reusable water bottle.
No Class Nov 27
5160202-1 - Science Kids Wednesday AM (Full Semester)
Res/NonRes
$364.00/$434.00
9/4/2024 - 12/18/2024
9:00 am - 11:30 am
Location
Wildwood Nature Center
5160202-2 - Science Kids Wednesday PM (Full Semester)
Res/NonRes
$364.00/$434.00
9/4/2024 - 12/18/2024
12:30 pm - 3:00 pm
Location
Wildwood Nature Center
5160202-3 - Science Kids Wednesday AM Session 1
Res/NonRes
$194.00/$233.00
9/4/2024 - 10/23/2024
9:00 am - 11:30 am
Location
Wildwood Nature Center
5160202-4 - Science Kids Wednesday AM Session 2
Res/NonRes
$170.00/$204.00
10/30/2024 - 12/18/2024
9:00 am - 11:30 am
Location
Wildwood Nature Center
5160202-5 - Science Kids Wednesday PM Session 1
Res/NonRes
$194.00/$233.00
9/4/2024 - 10/23/2024
12:30 pm - 3:00 pm
Location
Wildwood Nature Center
5160202-6 - Science Kids Wednesday PM Session 2
Res/NonRes
$170.00/$204.00
10/30/2024 - 12/18/2024
12:30 pm - 3:00 pm
Location
Wildwood Nature Center
5160206 / Wild Child
Preschool explorers get ready for outdoor adventure! Wild Child’s kid crew will create their own adventures around Wildwood’s pond, prairie, and woodland paths, and extend the exploration inside the classroom. No class Nov 29.
5160206-1 - Wild Child Friday (Full Semester)
Res/NonRes
$364.00/$434.00
9/6/2024 - 12/20/2024
12:30 pm - 3:00 pm
Location
Wildwood Nature Center
5160215 / Toddler Tree School
Does your toddler miss the cutoff for Nature Preschool or Nature Play School? Toddler Tree School is an introductory class for two and three year olds. Tots explore nature, learn, and grow through themed hikes, outdoor exploration, sensory activities, dramatic play, songs, stories, art, and visits to the animal room. The majority of the program takes place outside at the Wildwood Nature Center grounds in their outdoor gathering space and hiking, and their indoor classroom is located at Wildwood. Program is for children ages 2-3 as of September 1. No class November 26 and 28.
5160215-1 - Toddler Tree School Tu/Th
Res/NonRes
$694.00/$850.00
9/3/2024 - 12/19/2024
9:15 am - 11:15 am
Location
Wildwood Nature Center