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
4012102 / Girls Lacrosse
Learn girls lacrosse from the Maine South girls players, coaches, and Park Ridge lacrosse coaches! We will teach you the fundamentals (passing, cradling, shooting, and catching) and how to play lacrosse. Each session will consist of training and mini games to keep it fun. NIRP
4012102-1 - 3rd - 5th Grade Girls Lacrosse
Res/NonRes
$125.00/$125.00
7/8/2024 - 8/12/2024
5:15 pm - 6:30 pm
4012102-2 - 6th - 8th Grade Girls Lacrosse
Res/NonRes
$125.00/$125.00
7/8/2024 - 8/12/2024
6:30 pm - 7:45 pm
4012103 / Co-Ed Speed Lacrosse
Speed Lacrosse is a fast fun version of 3v3 lacrosse played on a small field. Players do not wear any equipment, do not have positions, and the game is supposed to be fast and free flowing. 30 mins skills/30 min speed game. Taught by expert coaches from Park Ridge Lacrosse.
4012103-1 - Co-Ed Speed Lacrosse PreK-K
7/8/2024 - 8/12/2024
5:30 pm - 6:15 pm
4012801 / Fencing
In this fun and unique fencing program, participants learn the basics of sword-fighting and participate in a challenging and exciting new sport! Group classes include games, footwork exercises, and real fencing matches with all equipment provided. Fencing helps to develop agility, focus, muscle strength, coordination, and sportsmanship. This class is coached by a Master Fencing Instructor who is a former World Cup Champion and National US Fencing Team Coach.
Location: Fencing Center of Chicago, 111 S. Washington Ave, Park Ridge
Res/NonRes
$301.00/$301.00
6/21/2024 - 8/23/2024
5:00 pm - 6:30 pm
Location
Fencing Center of Chicago
4013602 / All Star Basketball
Our instructional program is designed to teach the game of basketball at a basic level while keeping players active and engaged. Fun games are played to teach the importance of each skill learned. Our foundation technique focuses on basic mechanics to build confidence, then adds larger challenges as we progress. Footwork is an extremely important aspect of the game. This means no players are sitting! We work on dribbling with each hand, passing, and shooting technique, and understanding basic offense and defense.
4013602-1 - All Star Basketball
Res/NonRes
$106.00/$162.00
6/10/2024 - 7/22/2024
4:00 pm - 4:45 pm
Location
Centennial Fitness Center
4013602-2 - All Star Basketball
Res/NonRes
$106.00/$162.00
6/14/2024 - 8/2/2024
4:00 pm - 4:45 pm
Location
Centennial Fitness Center
4013602-3 - All Star Basketball
Res/NonRes
$106.00/$162.00
6/10/2024 - 7/22/2024
4:45 pm - 5:45 pm
Location
Centennial Fitness Center
4013602-4 - All Star Basketball
Res/NonRes
$106.00/$162.00
6/14/2024 - 8/2/2024
4:45 pm - 5:45 pm
Location
Centennial Fitness Center
4013602-5 - All Star Basketball Skills
Res/NonRes
$106.00/$162.00
6/10/2024 - 7/22/2024
5:45 pm - 6:45 pm
Location
Centennial Fitness Center
4013602-6 - All Star Basketball Skills
Res/NonRes
$106.00/$162.00
6/14/2024 - 8/2/2024
5:45 pm - 6:45 pm
Location
Centennial Fitness Center
4013606 / All Star Soccer
This program keeps everyone active and engaged. Our lesson plan hides drills in fun games and uses association techniques that get down to the player's level. Soccer is an action-packed game, so there is no sitting and waiting! We cover simple foot skills, dribbling, passing, shooting, basic rules, and even work on spreading the field. This class keeps players active and prepares them for the next level of play.
4013606-1 - All Star Soccer
Res/NonRes
$106.00/$162.00
6/12/2024 - 7/31/2024
4:00 pm - 4:45 pm
Location
Centennial Fitness Center
4013606-2 - All Star Soccer
Res/NonRes
$106.00/$162.00
6/15/2024 - 8/3/2024
11:45 am - 12:30 pm
Location
Centennial Fitness Center
4013606-3 - All Star Soccer
Res/NonRes
$106.00/$162.00
6/12/2024 - 7/31/2024
4:45 pm - 5:45 pm
Location
Centennial Fitness Center
4013606-4 - All Star Soccer
Res/NonRes
$106.00/$162.00
6/15/2024 - 8/3/2024
12:30 pm - 1:30 pm
Location
Centennial Fitness Center
4013606-5 - All Star Soccer Skills
Res/NonRes
$106.00/$162.00
6/12/2024 - 7/31/2024
5:45 pm - 6:45 pm
Location
Centennial Fitness Center
4013606-6 - All Star Soccer Skills
Res/NonRes
$106.00/$162.00
6/15/2024 - 8/3/2024
1:30 pm - 2:30 pm
Location
Centennial Fitness Center