DEBUG
4
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 'WithAdult')
),
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 'Early Childhood' */ ART.typecode LIKE 'Early Childhood')
/* OG
ORDER BY JSON_VALUE(ART.DataJSON, '$.aractivity_typecode')
*/
ORDER BY ART.typecode
;
Programs with Adults
4130102 / Tot Rock
This interactive class has everyone on their feet! We all learn together while engaging in active, creative, music-based activities, while using rhythm instruments and movement props. All class procedures are designed to keep staff and students safe. Activities are age appropriate by class and include songs and rhymes, rhythm and coordination, fine and gross motor, imagination and sensory, listening and following directions skills. Sing, dance, play, learn and imagine with us! www.rockitkids.com
7/12/2024 - 8/2/2024
9:15 am - 9:55 am
4130103 / Kid Rock I
This interactive class has everyone on their feet! We all learn together while engaging in active, creative, music-based activities, while using rhythm instruments and movement props. All class procedures are designed to keep staff and students safe. Activities are age appropriate by class and include songs and rhymes, rhythm and coordination, fine and gross motor, imagination and sensory, listening and following directions skills. Sing, dance, play, learn and imagine with us! www.rockitkids.com
7/12/2024 - 8/2/2024
10:00 am - 10:40 am
4130104 / Family Kid Rock
This interactive class has everyone on their feet! We all learn together while engaging in active, creative, music-based activities, while using rhythm instruments and movement props. All class procedures are designed to keep staff and students safe. Activities are age appropriate by class and include songs and rhymes, rhythm and coordination, fine and gross motor, imagination and sensory, listening and following directions skills. Sing, dance, play, learn and imagine with us! www.rockitkids.com
4130104-2 - Family Kid Rock
7/12/2024 - 8/2/2024
10:45 am - 11:25 am
4130107 / Happy Hunters
Join us for a morning of exploration and fun. Meet at our new beautiful Maine Park Playground and Pavilion and start our morning together with a circle-time, story, craft time and scavenger hunt adventure! Each week will be a new theme build around our story and craft. Both Tuesday and Wednesday classes will be the same activities. No rain dates, refunds will be issued for class cancellations due to weather.
4130107-1 - Happy Hunters
Res/NonRes
$65.00/$101.00
6/12/2024 - 7/3/2024
9:30 am - 10:30 am
4130107-2 - Happy Hunters
Res/NonRes
$65.00/$101.00
7/17/2024 - 8/7/2024
9:30 am - 10:30 am
4130107-3 - Happy Hunters
Res/NonRes
$65.00/$101.00
6/11/2024 - 7/9/2024
9:30 am - 10:30 am
4130107-4 - Happy Hunters
Res/NonRes
$65.00/$101.00
7/16/2024 - 8/6/2024
9:30 am - 10:30 am