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
4011826 / Hot Shots Sports Game Time Basketball
One of the best ways to develop your basketball skills is through game play, and in Game Time you do just that. Each week, basketball players are challenged through various games including 1-on-1, 3-on-3, and 5-on-5. Coaches referee and guide the class to enhance the players’ understanding of the game. MP
4011826-1 - Hot Shots Sports Game Time Basketball
Res/NonRes
$136.00/$207.00
6/12/2024 - 8/7/2024
5:15 pm - 6:15 pm
4011827 / Hot Shots Sports Basketball League
One of the best ways to develop your basketball skills is through game play, and in Game Time you do just that. Each week, basketball players are challenged through various games including 1-on-1, 3-on-3, and 5-on-5. Coaches referee and guide the class to enhance the players’ understanding of the game. The first half of the league will be focused on drills/skills building, and the last hour will focus on scrimmages.
4011827-1 - Hot Shots Sports Basketball League
Res/NonRes
$242.00/$370.00
6/16/2024 - 8/11/2024
9:00 am - 11:00 am
4011831 / Hot Shots Sports Pee Wee Flag Football
Develop early football skills such as rushing, receiving 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 football beginner looking to understand the game, learn new skills, and have fun! MP
4011831-1 - Hot Shots Sports Pee Wee Flag Football
Res/NonRes
$136.00/$207.00
6/10/2024 - 8/5/2024
4:45 pm - 5:45 pm
4011832 / Hot Shots Sports Junior Flag Football
Come join in on the fun and start playing the nation’s most loved game! Players are introduced to stance, receiving, rushing, blocking and defense. Each week ends with a scrimmage encouraging teamwork and sportsmanship. Players always get to play either receiver or running back each week. Games focus on fundamentals and field concepts, as well as positions and mechanics. No equipment necessary!
4011832-1 - Hot Shots Sports Junior Flag Football
Res/NonRes
$136.00/$207.00
6/10/2024 - 8/5/2024
5:45 pm - 6:45 pm
4011840 / Hot Shots Sports Adult-Tot Tumbling
Your child's physical, mental, emotional, and social skills are developed through this fun and challenging class. Children are introduced to age-appropriate exercises specifically designed for balance and coordination of their large muscle groups. Through basic gymnastics and movement, participants experience their world in a whole new way and begin to understand how their bodies work. Wear loose fitting clothing, gym shoes and be prepared to have tons of fun! Parent or caregiver participation is required.
4011840-1 - Hot Shots Sports Adult-Tot Tumbling
Res/NonRes
$121.00/$185.00
6/12/2024 - 8/7/2024
6:00 pm - 6:45 pm
4011840-2 - Hot Shots Sports Adult-Tot Tumbling
Res/NonRes
$121.00/$185.00
6/13/2024 - 8/8/2024
9:15 am - 10:00 am
4011840-3 - Hot Shots Sports Adult-Tot Tumbling
Res/NonRes
$121.00/$185.00
6/15/2024 - 8/10/2024
11:15 am - 12:00 pm