DEBUG
294
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
),
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
/* OG
ORDER BY JSON_VALUE(ART.DataJSON, '$.aractivity_typecode')
*/
ORDER BY ART.typecode
;
4230903 / STAR Adventure Camp
S.T.A.R. Adventure Camp
You are never too old to go to camp! Embark on a summer adventure with and adult twist. We are exploring all Chicago has to offer. We can’t wait to see what this week-long journey has in store! Transportation and admission are included for each day. If you register by July 1 you will receive a free Adventure Camp t-shirt! Registration deadline: August 2.
Lavergne & Shirley Tour, Milwaukee, WI
Grab your friends and get ready for a fun day! Experience a comedic city tour of Milwaukee through the eyes of Lavergne & Shirley! In this themed tour we’ll start at the Lakefront Brewery, learn the opening dance from Lavergne & Shirley, take a Brewery Tour that includes two samples of beer or soda, and a souvenir glass. See the Bronz Fonz and a few other sites. Then enjoy a pizza lunch at Balistreri’s Italian Ristorante followed by a fun time mini-bowling, and then we’ll swing by Leon’s Drive-In and end our tour with a delicious frozen treat.
4230903-1 - STAR Adventure Camp-Lavergne & Shirley Tour
Res/NonRes
$120.00/$135.00
8/19/2024 - 8/19/2024
8:00 am - 6:00 pm
Location
Centennial Activity Center
4230903-2 - STAR Adventure Camp-Starved Rock Land & Water Cruise
8/20/2024 - 8/20/2024
9:00 am - 5:00 pm
Location
Centennial Activity Center
4230903-3 - STAR Adventure Camp-Olbrich Botanical Gardens
8/21/2024 - 8/21/2024
9:00 am - 4:30 pm
Location
Centennial Activity Center
4230903-4 - STAR Adventure Camp-Geja’s Café
Res/NonRes
$89.00/$109.00
8/22/2024 - 8/22/2024
3:15 pm - 8:00 pm
Location
Centennial Activity Center
4230903-5 - STAR Adventure Camp-Long Grove Confectionary Tour & Lunch
8/23/2024 - 8/23/2024
9:00 am - 3:00 pm
Location
Centennial Activity Center
4230113 / Adult Art
Our instructor guides beginner through advanced students in all media, including sketching, pastels, watercolor, oils, and acrylics. New students should bring a pencil and sketch pad to first class. No class July 4. Instructor: Linda Khan. CAC
6/13/2024 - 7/18/2024
9:00 am - 12:00 pm
Location
Centennial Activity Center
7/25/2024 - 8/22/2024
9:00 am - 12:00 pm
Location
Centennial Activity Center
4230529 / Zentangle Art
Zentangle Art (Ages 18 and Older)
Learn the mindfulness practice of Zentangle Art which is an easy-to-learn, relaxing and fun way to create beautiful images by drawing structured patterns and combines "elemental strokes" such as dots, lines, simple curves and orbs to create your own original, unique, and beautiful Zentangle images. No experience required. All experience levels are welcome whether you’re new to Zentangle or a continuing student. All supplies included. Class meets every other week. Instructor: Robin Moss. Registration deadline: June 5. CAC
4230529-1 - Zentangle Art
6/13/2024 - 7/25/2024
10:00 am - 11:30 am
Location
Centennial Activity Center
4230530 / Birdhouse Making
Birdhouse Making (Ages 18 and Older)
Ted Sigg leads you through the step-by-step process to build three of your own birdhouses – a wren house, goldfinch house, and a nesting platform for Robbins and Morning Doves. No experience necessary and all materials and use of tools is provided. Registration deadline: July 29. CAC
4230530-1 - Birdhouse Making
8/6/2024 - 8/6/2024
4:00 pm - 6:00 pm
Location
Centennial Activity Center