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
;
4013608 / All Star T-Ball
We engage all players no matter their skill level. Our coaching technique provides basic building blocks in a fun, safe environment. Players keep moving and learning, even while in the dugout! Mechanics and hand-eye coordination are the keys to early success. Players become more confident as we work on the proper mechanics of catching, throwing, fielding, base running, and batting. This program prepares players for level II, t-ball, or coach pitch leagues.
4013608-1 - All Star T-Ball
Res/NonRes
$106.00/$162.00
6/11/2024 - 7/23/2024
4:00 pm - 4:45 pm
Location
Centennial Fitness Center
4013608-2 - All Star T-Ball
Res/NonRes
$106.00/$162.00
6/13/2024 - 8/1/2024
4:00 pm - 4:45 pm
Location
Centennial Fitness Center
4013608-3 - All Star T-Ball
Res/NonRes
$106.00/$162.00
6/15/2024 - 8/3/2024
9:45 am - 10:30 am
Location
Centennial Fitness Center
4013608-4 - All Star T-Ball
Res/NonRes
$106.00/$162.00
6/11/2024 - 7/23/2024
4:45 pm - 5:45 pm
Location
Centennial Fitness Center
4013608-5 - All Star T-Ball
Res/NonRes
$106.00/$162.00
6/13/2024 - 8/1/2024
4:45 pm - 5:45 pm
Location
Centennial Fitness Center
4013608-6 - All Star T-Ball
Res/NonRes
$106.00/$162.00
6/15/2024 - 8/3/2024
10:30 am - 11:30 am
Location
Centennial Fitness Center
4110815 / Glitzy Girlz: Back to School
Come join Glitzy Girlz staff for a class to design some fun goodies to get you ready for school year! Each participant will be creating a beaded item for backpacks accessory
or jewelry. We have a great assorted bead selection from crystals to sports, adventure, unicorn, animals, neon & more! Our crafts decorating fun school accessories with paints,
embellishments, stickers and more. A surprise goodie bag goes home with all guests! A great class for everyone!
4110815-1 - Glitzy Girlz: Back to School Fun!
8/15/2024 - 8/15/2024
6:00 pm - 7:00 pm
4111111 / Magic
Children are guaranteed to have a great time as they learn a collection of fascinating and mesmerizing tricks from the "Magic Team of Gary Kantor!" Amaze family and friends with tricks that involve cards, ropes, coins, and mind-reading. All materials are provided, and each child receives a magic kit to take home. Children are grouped by age and always learn tricks that are age-appropriate. Additionally, you can sign up for this class again and again since brand new tricks are always taught at each session! Instructor: Magic Team of Gary Kantor.
4111111-2 - Magic! Magic! Magic!
7/8/2024 - 7/8/2024
6:45 pm - 7:40 pm
4111111-3 - Magic! Magic! Magic!
8/12/2024 - 8/12/2024
6:45 pm - 7:40 pm
4130211 / Congo River Mini Golf
Enjoy a day of fun at this spectacular 32-hole adventure mini golf course! Teens of all ages will be captivated by the tall mountain peak and colorful waterfalls. Practice your best shot and aim for a hole-in-one inside the cave, around the tiki statues, or atop the mountain. Additional details will be provided closer to the start date. Registration deadline: July 17.
4130211-1 - Congo River Mini Golf
7/24/2024 - 7/24/2024
1:00 pm - 4:00 pm