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
;
4011811 / Hot Shots Sports Adult-Tot T-Ball
Parents are an integral part of helping their tots develop basic sports movement and motor skills through the great sport of baseball. Motor skill activities focus on hand/eye and running coordination. Sports equipment and instruction are provided to help guide your child through an introduction to organized sports. Parents or caregiver participation is required, and participants should bring their own gloves if desired. MP
4011811-1 - Hot Shots Sports Adult-Tot T-Ball
Res/NonRes
$97.00/$149.00
6/15/2024 - 8/10/2024
9:45 am - 10:30 am
4011814 / Hot Shots Sports Baseball Clinic 101
This baseball class gives players an introduction to baseball. Players work on technique and enhancing form in this comprehensive skills clinic. This program teaches throwing mechanics as well as batting stance, bat positioning and speed, using both live pitching and hitting off the tee. Players learn various positions in the field through game play and basic game strategy. Players should bring their own gloves, and be ready for a fun, fast paced learning environment. MP
4011814-1 - Hot Shots Sports Baseball Clinic 101
Res/NonRes
$136.00/$207.00
6/11/2024 - 8/6/2024
5:30 pm - 6:30 pm
4011824 / Hot Shots Sports Lil Dribblers
The Lil’ Dribblers Basketball program introduces children to the game of basketball in a safe, fun and exciting environment. Our curriculum uses age appropriate activities and games specifically designed to increase balance, body awareness, motor skills, hand eye coordination, listening skills and the ability to follow directions. The Lil’ Dribblers program includes exclusively design equipment tailored to enhance the basketball experience for each participant. The program challenges children to develop new cognitive, physical and social skills. In addition, each child will experience social interaction with children and adults in a fun environment. MP
4011824-1 - Hot Shots Sports Lil Dribblers
Res/NonRes
$109.00/$167.00
6/12/2024 - 8/7/2024
3:30 pm - 4:15 pm
4011825 / Hot Shots Sports Basketball 101
Develop early basketball skills such as shooting, dribbling and passing, along with the basic rules of the game. All instruction is game/drill oriented with mini games and scrimmages played every week. This class is for the basketball beginner looking to understand the game, learn new skills, and have fun! MP
4011825-1 - Hot Shots Sports Basketball 101
Res/NonRes
$136.00/$207.00
6/12/2024 - 8/7/2024
4:15 pm - 5:15 pm