DEBUG
8
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 'Youth Athletics' */ ART.typecode LIKE 'Youth Athletics')AND (ART.activitycode = '4013602'OR ART.activitycode = '4011825'OR ART.activitycode = '4011824'OR ART.activitycode = '4011826'OR ART.activitycode = '4011827'OR ART.activitycode = '4011013'OR ART.activitycode = '4011014'OR ART.activitycode = '4011015')
/* OG
ORDER BY JSON_VALUE(ART.DataJSON, '$.aractivity_typecode')
*/
ORDER BY ART.typecode
;
Programs
4011013 / J Dreams Basketballing 101
This program will introduce your children to the game of basketball if they are beginners or if they need the know how to get to the next level. Basic skills of dribbling, passing, shooting, and defense will be taught. New individual challenges will be presented to develop the importance of reaching goals. Modified basketballs will help reach the next level. Lesson plan also incorporated pivoting, closeouts and jump-stops.
4011013-21 - J Dreams Basketballing 101 Session II
Res/NonRes
$121.00/$185.00
7/20/2024 - 8/10/2024
12:30 pm - 2:00 pm
4011014 / J Dreams Basketballing 102
This program will advance your children into "game situation" drills and continue to build basketball fundamentals on an individual basis. Advanced skills n drills of dribbling, passing, finishing, shooting, and defense will be taught. Pairing games will be played to show the importance of counter-moves! Lesson plan also incorporates reverse pivoting, closeouts and jump-stops.
4011014-21 - J Dreams Basketballing 102 Session II
Res/NonRes
$121.00/$185.00
7/20/2024 - 8/10/2024
2:00 pm - 3:30 pm
4011015 / J Dreams Form Shooting and Finishing
This class focuses on building shooting skills and confidence in each and every player who attends. The goals of this class is to develop the player in every facet of shooting the basketball in addition to training concepts to improve the strength, agility, and quickness of each player. Topics covered are form shooting, range finding, balance and footwork, shot selection, jumping, and first step explosion training.
4011015-21 - J Dreams The Art of Shooting a Basketball Session II
Res/NonRes
$121.00/$185.00
7/20/2024 - 8/10/2024
3:30 pm - 5:00 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