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
4230532 / STAR Centennial Game Show
There is no better way to spend a Wednesday afternoon than competing against your friends in a friendly game showdown! Test your knowledge of classic game shows such as Who Wants to Be a Millionaire, Wheel of Fortune, and Family Feud to name a few. Enjoy a delicious seasonal treat as you win prizes and hone in on your skills! CAC
4230532-1 - Centennial Game Show
7/3/2024 - 7/3/2024
1:30 pm - 3:00 pm
Location
Centennial Activity Center
4230532-2 - Centennial Game Show
8/7/2024 - 8/7/2024
1:30 pm - 3:00 pm
Location
Centennial Activity Center
4230538 / Sip & Security
Sip & Security
with Eileen O’Leary
Adults 65 and older are at the most risk for internet and phishing scams. Participants will learn practical strategies to protect their personal information, financial assets, and digital identity. Topics covered include recognizing phishing emails, creating strong passwords, using secure browsing practices, and safeguarding against identity theft. With her 16 years of experience in tech, Eileen O’Leary, the Information Technology Director at the District will be your guide. Pizza, salad, bread & 1 glass of wine will be served. CAC
4230538-1 - Sip & Security
8/13/2024 - 8/13/2024
5:00 pm - 6:30 pm
Location
Centennial Activity Center
4230543 / Empowering Caregivers: Navigating Legalities in Parental Care
Empowering Caregivers: Navigating Legalities in Parental Care
With Coogan Gallagher: Personal Injury Lawyers
Coogan Gallagher offers an enlightening presentation tailored specifically for caregivers, as we delve into the essential legal aspects of caring for aging parents. From understanding power of attorney to navigating healthcare directives, we'll provide comprehensive insights to help you confidently manage legal responsibilities. Discover key strategies for estate planning, guardianship, and accessing vital resources. Whether you're just beginning your caregiving journey or seeking to enhance your knowledge, this presentation equips you with the tools and knowledge to ensure your parent's well-being while safeguarding their legal rights. Don't miss this opportunity to empower yourself with the legal know-how to provide the best possible care for your loved ones.
4230543-1 - Empowering Caregivers: Navigating Legalities in Parental Care
7/10/2024 - 7/10/2024
5:30 pm - 6:30 pm
Location
Centennial Activity Center
4230601 / Yoga For Aging Well
This mat yoga class will focus on building strength, agility, balance and flexibility. This is a more active class for seniors that includes floor, seated, and standing postures. Participants must be able to get up and down from the floor on their own. Instructor: Jodi Fedoruk. CAC
4230601-1 - Yoga For Aging Well
Res/NonRes
$108.00/$108.00
7/15/2024 - 8/19/2024
10:15 am - 11:00 am
Location
Centennial Activity Center
4230602 / Mindful Chair Yoga
In this class we combine mindfulness practices with yoga movements that help you find strength. Flexibility and balance while seated and standing. All experience levels are welcome. Class size is limited, so sign up today. No class on July 4 & 11. Instructor: Jodi Fedoruk (Tu) & Joan McGee (Th). CAC
4230602-2 - Mindful Chair Yoga
6/13/2024 - 7/18/2024
10:15 am - 11:00 am
Location
Centennial Activity Center
4230602-3 - Mindful Chair Yoga
Res/NonRes
$108.00/$108.00
7/16/2024 - 8/20/2024
10:15 am - 11:00 am
Location
Centennial Activity Center
4230602-4 - Mindful Chair Yoga
7/25/2024 - 8/22/2024
10:15 am - 11:00 am
Location
Centennial Activity Center