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
4011860 / Hot Shots Sports Mini Ninja Warriors
Leap, hop, skip, run your way through obstacles and put your child’s Ninja skills to the test. This fun movement-based class challenges your Ninja to maneuver over and under objects. In addition, group games to further challenge their Ninja skills will be played.
4011860-1 - Hot Shots Sports Mini Ninja Warrior
Res/NonRes
$97.00/$149.00
6/12/2024 - 8/7/2024
1:15 pm - 2:00 pm
4011860-2 - Hot Shots Sports Mini Ninja Warrior
Res/NonRes
$97.00/$149.00
6/13/2024 - 8/8/2024
4:15 pm - 5:00 pm
4011860-3 - Hot Shots Sports Mini Ninja Warrior
Res/NonRes
$97.00/$149.00
6/14/2024 - 8/9/2024
10:30 am - 11:15 am
4011860-4 - Hot Shots Sports Mini Ninja Warrior
Res/NonRes
$97.00/$149.00
6/15/2024 - 8/10/2024
10:30 am - 11:15 am
4011861 / Hot Shots Sports Junior Ninja Warriors
Take everything you learned from Mini Ninja Warriors and test your Ninja skills with even more difficult obstacles to leap, hop, skip and run your way through. Group games will put your Ninja skills to the test
in this fun movement-based class.
4011861-1 - Hot Shots Sports Junior Ninja Warrior
Res/NonRes
$121.00/$185.00
6/13/2024 - 8/8/2024
5:00 pm - 6:00 pm
4011861-2 - Hot Shots Sports Junior Ninja Warrior
Res/NonRes
$121.00/$185.00
6/13/2024 - 8/8/2024
6:00 pm - 7:00 pm
4011862 / Hot Shots Sports Adult Tot Ninja Warriors
Parents are an integral part of helping their tots develop basic sports movement and motor skills. Leap, hop, skip, run your way through obstacles and put your ninja skills to the test. This fun movement based class challenges your ninja to maneuver over and under objects. In addition, we play group games to further challenge their Ninja skills. Parents or caregiver participation is required
4011862-1 - Hot Shots Sports Adult and Tot Ninja Warriors
Res/NonRes
$109.00/$167.00
6/11/2024 - 8/6/2024
6:00 pm - 6:45 pm
4011862-2 - Hot Shots Sports Adult and Tot Ninja Warriors
Res/NonRes
$109.00/$167.00
6/15/2024 - 8/10/2024
9:00 am - 9:45 am
4011863 / Hot Shots Sports Tiny Ninja Warriors
This course is perfect for young toddlers looking to get involved in sports in a fun, safe way. Players will take turns on various obstacles working on balance, gross and fine motor function, body control, hand dexterity and strength, and speed. This program is tremendous for helping players find a love of fitness and sports in an interactive and accessible environment where players can grow and have fun. Sign up today and begin building confidence and a love for fitness and sports!
4011863-1 - Hot Shots Sports Tiny Ninja Warriors
Res/NonRes
$109.00/$167.00
6/11/2024 - 8/6/2024
4:15 pm - 5:00 pm
4011863-2 - Hot Shots Sports Tiny Ninja Warriors
Res/NonRes
$109.00/$167.00
6/12/2024 - 8/7/2024
12:30 pm - 1:15 pm
4011863-3 - Hot Shots Sports Tiny Ninja Warriors
Res/NonRes
$109.00/$167.00
6/15/2024 - 8/10/2024
9:45 am - 10:30 am
4011864 / Hot Shots Sports Amazing Ninja Warriors
The ultimate stage in our Ninja Warriors program, players will be exposed to challenging obstacles that will require them to use every aspect of their strength and core. Simple gymnastics principles will be taught and used in order to conquer these incredible courses, and gymnastics gear will be utilized to ensure a difficult but safe environment. Players of all levels of athletic and sports backgrounds will be able to participate, compete, and have fun in this program which focuses on personal growth, development, and fitness. Sign up today and get ready to conquer the course!
4011864-1 - Hot Shots Sports Amazing Ninja Warriors
Res/NonRes
$136.00/$207.00
6/11/2024 - 8/6/2024
5:00 pm - 6:00 pm