DEBUG
7
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 'Preschool' */ ART.typecode LIKE 'Preschool')
/* OG
ORDER BY JSON_VALUE(ART.DataJSON, '$.aractivity_typecode')
*/
ORDER BY ART.typecode
;
Programs
5140101 / 2 Year Old Preschool
Our play-based Preschool Program emphasizes socialization and self-expression through an array of creative and fun preschool appropriate activities. Students have fun learning vital social and emotional skills through art, music, manipulatives, and many other hands on activities. All children must be completely toilet trained and 2 years old by September 1, 2024.
A $100 deposit is due at time of registration. Payment plans are available, please visit or call Maine Park to set up.
5140101-1 - 2 Yr Old Preschool MWF AM Playtime Pkwy
Res/NonRes
$2185.00/$3124.00
9/4/2024 - 5/7/2025
9:00 am - 11:30 am
5140101-2 - 2 Yr Old Preschool T/TH AM Playtime Pkwy
Res/NonRes
$1530.00/$2188.00
9/3/2024 - 5/8/2025
9:00 am - 11:30 am
5140102 / 3 Year Old Morning Preschool
Our play-based Preschool Program emphasizes socialization and self-expression through an array of creative and fun preschool appropriate activities. Students have fun learning vital social and emotional skills through art, music, manipulatives, and many other hands on activities. All children must be completely toilet trained and 3 years old by September 1, 2024.
A $100 deposit is due at time of registration. Payment plans are available, please visit or call Maine Park to set up.
5140102-1 - 3 Yr Old Preschool M-F AM Imagination Way
Res/NonRes
$3713.00/$5307.00
9/3/2024 - 5/8/2025
9:00 am - 11:30 am
5140102-3 - 3 Yr Old Preschool MWF AM Discovery Drive
Res/NonRes
$2185.00/$3124.00
9/4/2024 - 5/7/2025
9:00 am - 11:30 am
5140102-4 - 3 Yr Old Preschool T/TH AM Discovery Drive
Res/NonRes
$1530.00/$2188.00
9/3/2024 - 5/8/2025
9:00 am - 11:30 am
5140103 / 4 Year Old Morning Preschool
Our play-based Preschool Program emphasizes socialization and self-expression through an array of creative and fun preschool appropriate activities. Students have fun learning vital social and emotional skills through art, music, manipulatives, and many other hands on activities. This class concentrates on kindergarten readiness skills. All children must be completely toilet trained and 4 years old by September 1, 2024.
A $100 deposit is due at time of registration. Payment plans are available, please visit or call Maine Park to set up.
5140103-1 - 4 Yr Old Preschool MWF AM Learning Lane
Res/NonRes
$2185.00/$3124.00
9/4/2024 - 5/7/2025
9:00 am - 11:30 am
5140103-6 - 4 Yr Old Preschool T/TH AM Learning Lane
Res/NonRes
$1530.00/$2188.00
9/3/2024 - 5/8/2025
9:00 am - 11:30 am
5140103-9 - 4 Yr Old Preschool M-F AM Creative Court
Res/NonRes
$3713.00/$5307.00
9/3/2024 - 5/8/2025
9:00 am - 11:30 am
5140104 / 3 Year Old Afternoon Preschool
Our play-based Preschool Program emphasizes socialization and self-expression through an array of creative and fun preschool appropriate activities. Students have fun learning vital social and emotional skills through art, music, manipulatives, and many other hands on activities. All children must be completely toilet trained and 3 years old by September 1, 2024 and fully potty trained.
A $100 deposit is due at time of registration. Payment plans are available, please visit or call Maine Park to set up.
5140104-3 - 3 Yr Old Preschool MWF PM Discovery Drive
Res/NonRes
$2185.00/$3124.00
9/4/2024 - 5/7/2025
12:30 pm - 3:00 pm
5140104-4 - 3 Yr Old Preschool T/TH PM Discovery Drive
Res/NonRes
$1530.00/$2188.00
9/3/2024 - 5/8/2025
12:30 pm - 3:00 pm
5140105 / 4 Year Old Afternoon Preschool
Our play-based Preschool Program emphasizes socialization and self-expression through an array of creative and fun preschool appropriate activities. Students have fun learning vital social and emotional skills through art, music, manipulatives, and many other hands on activities. This class concentrates on kindergarten readiness skills. All children must be completely toilet trained and 4 years old by September 1, 2024.
A $100 deposit is due at time of registration. Payment plans are available, please visit or call Maine Park to set up. Balance is due August 16th, 2024.
5140105-1 - 4 Yr Old Preschool MWF PM Learning Lane
Res/NonRes
$2185.00/$3124.00
9/4/2024 - 5/7/2025
12:30 pm - 3:00 pm
Ages
Age 4 as of 9/1/2024
5140105-6 - 4 Yr Old Preschool T/TH PM Learning Lane
Res/NonRes
$1530.00/$2188.00
9/3/2024 - 5/8/2025
12:30 pm - 3:00 pm
Ages
Age 4 as of 9/1/2024
5140105-10 - 4 Yr Old Preschool M-F PM Exploration Ave
Res/NonRes
$3713.00/$5307.00
9/3/2024 - 5/8/2025
12:30 pm - 3:00 pm
Ages
Age 4 as of 9/1/2024