DEBUG
11
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
AND (/* OG JSON_VALUE(ART.DataJSON, '$.aractivity_typecode') LIKE 'Dance' */ ART.typecode LIKE 'Dance')
/* OG
ORDER BY JSON_VALUE(ART.DataJSON, '$.aractivity_typecode')
*/
ORDER BY ART.typecode
;
4100111 / Adult/Tot Predance
An excellent chance to expose your child to the magic of dance. Through games, songs, exercise and activities, your child learns how to participate in a group environment, as well as strengthens his/her movement patterns.
No class Jul 5
4100111-1 - Adult/Tot Predance LS
Res/NonRes
$126.00/$189.00
6/21/2024 - 8/9/2024
9:30 am - 10:00 am
4100113 / Teeny Tiny Tots
This beginner ballet class incorporates steps and terminology with fun and exciting music. Participants enjoy using hula hoops, beanbags, and maracas. Participants are welcome to wear dance attire or comfortable clothes.
No class Jul 2-5
4100113-1 - Teeny Tiny Tots LS
Res/NonRes
$126.00/$189.00
6/18/2024 - 8/6/2024
9:30 am - 10:00 am
4100113-3 - Teeny Tiny Tots
Res/NonRes
$126.00/$189.00
6/20/2024 - 8/8/2024
4:00 pm - 4:30 pm
4100113-4 - Teeny Tiny Tots LS
Res/NonRes
$126.00/$189.00
6/21/2024 - 8/9/2024
10:05 am - 10:35 am
4100115 / Ballet
Young dancers are introduced to basic ballet skills, terminology, rhythm, and coordination. Lessons are practiced and developed through creative movement and music in a supportive and playful environment.
No class Jul 2 & Jul 5
Res/NonRes
$138.00/$207.00
6/21/2024 - 8/9/2024
10:45 am - 11:30 am
Res/NonRes
$138.00/$207.00
6/18/2024 - 8/6/2024
5:15 pm - 6:00 pm
Res/NonRes
$138.00/$207.00
6/18/2024 - 8/6/2024
10:05 am - 10:50 am
4100117 / Poms
Pom Dance combines the sharp movements of cheerleading with jazz techniques. Students use pom poms to accentuate the rhythm and create colorful visual effects while executing high energy dance routines. This class focuses on coordination, movement, and dancing as a team. It prepares students for dance teams and cheerleading.
4100117-1 - Poms Dance HR
Res/NonRes
$138.00/$207.00
6/18/2024 - 8/6/2024
6:30 pm - 7:15 pm
4100117-2 - Poms Dance HR
Res/NonRes
$138.00/$207.00
6/18/2024 - 8/6/2024
7:15 pm - 8:00 pm