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
;
Programs
4230105 / 4th of July Celebration
Embrace the joys of summer as we celebrate the Fourth of July and remember the significance of freedom and empowerment. We’ll be serving up patriotic foods and be entertained by Skip Griparis, a virtuoso singer, guitarist, impressionist, comedian and member of the Illinois Rock and Roll Hall of Fame. Join us for an incredibly fun trip as Skip stars in his 50s/60s/70s Heroes of Rock! Lunch on mini pulled pork sliders, Italain meatball sliders, mini Vienna hot dogs, potato salad, strawberry spinach salad and dessert. Registration deadline: June 21. CAC
4230105-1 - 4th of July Celebration
7/1/2024 - 7/1/2024
12:30 pm - 2:15 pm
Location
Centennial Activity Center
4230105-2 - 4th of July Celebration - SHOW ONLY
7/1/2024 - 7/1/2024
1:15 pm - 2:15 pm
Location
Centennial Activity Center
4230106 / Ice Cream Social
Ice Cream Social
I scream, you scream, we all scream for ice cream! Cool off this summer with an ice cream sundae while listening to Peggy and Ray of The Silverliners. Registration deadline: June 28. CAC
4230106-1 - Ice Cream Social
7/10/2024 - 7/10/2024
1:00 pm - 2:30 pm
Location
Centennial Activity Center
4230107 / Art of Charcuterie Tasting
Art of Charcuterie Tasting
Who, when and where did the first charcuterie originate? Learn about the different types of charcuterie boards and what kinds of foods can be paired together. Discover the best ways to build and present a charcuterie tasting to create a unique visual feast for your eyes. In this session, partake in delectable foods and flavorful tastes. Registration deadline: July 5. CAC
4230107-1 - Art of Charcuterie Tasting
7/15/2024 - 7/15/2024
12:00 pm - 1:00 pm
Location
Centennial Activity Center
4230108 / An Evening Out with Sweet Reminders
An Evening Out with Sweet Reminders
Join us for an evening out with Sweet Reminders, a dynamic duo that entertains with hits of yesterday in their unique playful style. Beautiful vocals and interesting harmonies meet light-hearted fun, as Nancy Baumet and Dia Madden invite you to join in an engaging musical experience. Dine on meatloaf, mashed potatoes, green beans, mac and cheese, and dessert. Registration deadline: July 5. CAC
4230108-1 - An Evening Out with Sweet Reminders
7/18/2024 - 7/18/2024
5:30 pm - 7:15 pm
Location
Centennial Activity Center
4230108-2 - An Evening Out with Sweet Reminders - SHOW ONLY
7/18/2024 - 7/18/2024
6:15 pm - 7:15 pm
Location
Centennial Activity Center
4230109 / Christmas in July
Christmas in July is a chance to celebrate many of the things you love about Christmas – fun, friends, family, food, and gifts to name a few. Join us for something a little out of the box. Dust off your Christmas decorations, enjoy warm July weather, partake in some jingle juice (virgin, of course), and put on some red and green as you delight in the jolliest of carols with Maureen Christine. Also join in our White Elephant gift exchange by bringing one new item wrapped in holiday paper. Laughs are sure to happen. Lunch on herb crusted pork tenderloin, mashed potatoes, Waldorf chopped salad, and dessert. Registration deadline: July 15. CAC
4230109-1 - Christmas In July
7/25/2024 - 7/25/2024
12:30 pm - 3:00 pm
Location
Centennial Activity Center
4230109-2 - Christmas in July - SHOW ONLY & GIFT EXCHANGE
7/25/2024 - 7/25/2024
1:15 pm - 3:00 pm
Location
Centennial Activity Center