-- Adds the categorized forms directory (44 forms migrated from larcareservices.com/portal
-- across 4 batches) to the CMS-authored "portal" page (dim_web_pages, slug='portal') on the
-- LarCare site. The page's code-level fallback (LarCare/frontend/src/app/portal/page.tsx)
-- already lists these, but this CMS row takes priority over that fallback whenever it exists
-- (BlockRenderer renders layout_json directly) — so the code-only version never actually
-- rendered on the live site. Appends new richText blocks rather than replacing the row, so the
-- existing hero/intro/CTA blocks are preserved. Idempotent — guarded by block-id existence.
-- Deploy: mysql --default-character-set=utf8mb4 -u root -p db_abos_v0.1 < db/larcare_portal_page_forms_directory.sql
USE db_abos_v0.1;
SET @site_id = (SELECT id FROM dim_web_sites WHERE primary_domain = 'larcareservices.com' LIMIT 1);
UPDATE dim_web_pages
SET layout_json = JSON_ARRAY_APPEND(JSON_ARRAY_APPEND(JSON_ARRAY_APPEND(JSON_ARRAY_APPEND(JSON_ARRAY_APPEND(layout_json, '$.blocks', JSON_OBJECT('id', 'portal-forms-directory-heading', 'type', 'richText', 'props', JSON_OBJECT('html', 'Forms
Every form staff and clients need, organized the same way as our internal portal.
'), 'children', JSON_ARRAY())), '$.blocks', JSON_OBJECT('id', 'portal-forms-category-1', 'type', 'richText', 'props', JSON_OBJECT('html', 'Client / Patient
'), 'children', JSON_ARRAY())), '$.blocks', JSON_OBJECT('id', 'portal-forms-category-2', 'type', 'richText', 'props', JSON_OBJECT('html', 'Caregivers / Contractors
'), 'children', JSON_ARRAY())), '$.blocks', JSON_OBJECT('id', 'portal-forms-category-3', 'type', 'richText', 'props', JSON_OBJECT('html', 'Nurses
'), 'children', JSON_ARRAY())), '$.blocks', JSON_OBJECT('id', 'portal-forms-category-4', 'type', 'richText', 'props', JSON_OBJECT('html', 'Operations / HR / Training
'), 'children', JSON_ARRAY()))
WHERE site_id = @site_id
AND slug = 'portal'
AND JSON_SEARCH(layout_json, 'one', 'portal-forms-directory-heading', NULL, '$.blocks[*].id') IS NULL;