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
;
4230531 / Plant Box Making
Join us for this final Plant Box Making class where you’ll build a 2 ft. plant box with a rack that holds four, round flower pots. The plant box can be decorated and used inside, while the rack and flower pots can be used outside, if desired. All materials for the plant box, flower pots, potting soil, and seedings are provided. If you desire, you can bring your own seeds or seedings. Decorating of the plant box is on your own. Registration deadline: July 15. Instructor: Ted Sigg. CAC
4230531-1 - Plant Box Making
7/23/2024 - 7/23/2024
4:00 pm - 6:00 pm
Location
Centennial Activity Center
4230566 / Zentangle Workshop
Zentangle Workshop (Ages 18 and Older)
Learn the art of Zentangle to create a mobile or picture for your window with new translucent tiles of Zentangle! Relax, enjoy pizza and the process of creating in a supportive class environment. No experience required. All experience levels are welcome whether you’re new to Zentangle or a continuing student. Pizza, instruction and supplies included. Instructor: Robin Moss. Registration deadline: July 12. CAC
4230566-1 - Zentangle Workshop
7/22/2024 - 7/22/2024
6:00 pm - 8:00 pm
Location
Centennial Activity Center
4230567 / Macrame Wish Bracelets
Macramé Wish Bracelets (Ages 18 and Older)
Macramé evokes a calming effect with its repetitive knotting and the limitless creative possibilities. Spend time with a friend or family member enjoying pizza before making your own macramé wish bracelets. This fun craft project will have you learn easy knots and braiding techniques to create your own unique bracelet. A wish bracelet is a bracelet you make a wish on when it is tied onto you. No experience needed. Pizza, instruction and supplies included. Instructor: Robin Moss. Registration deadline: July 1. CAC
4230567-1 - Macrame Wish Bracelts
7/15/2024 - 7/15/2024
4:30 pm - 6:30 pm
Location
Centennial Activity Center
4230568 / Pizza & Sharpie Tye-Dying
Pizza and Sharpie Tie-Dying
Make a cool sharpie tie dye pillowcase and tote bag using permanent markers! Dress for a mess. No experience needed. Class includes pizza dinner, instruction and two tie dye items. Adult must attend with child. Children are recommended to be age 5 or older. Instructor: Robin Moss. CAC Registration deadline: July 19. CAC
4230568-1 - Pizza & Sharpie Tie-Dying (Individual)
8/1/2024 - 8/1/2024
4:30 pm - 6:30 pm
Location
Centennial Activity Center
4230568-2 - Pizza & Sharpie Tie-Dying (Partner)
8/1/2024 - 8/1/2024
4:30 pm - 6:30 pm
Location
Centennial Activity Center