Add missing public dashboard routes

[Former user]

No description provided.

[Ghislain Hachey]

Adding missing dashboards and cleanup menus will require running the following script (adapted from #1018). There needs to be minor manual adjustments in how the indicators are to be “menu’ed”.

‌

begin transaction

Select * from Navigation

DELETE from Navigation
WHERE id like 'public%'

INSERT INTO Navigation
(id
, icon
, label
, state
, children
, note
)
Select 'public.' + id
, icon
, label
, replace(state,'site.indicators','public.indicators')
, replace(children,'indicators.','public.indicators.')
, note
FROM Navigation
WHERE id like 'indicators%'

INSERT INTO Navigation
(id, icon, label, state)
VALUES 
('public.dashboards.findata','attach_money', 'Budgets','public.dashboards.findata')
, ('public.dashboards.exams','assignment_turned_in', 'Exams','public.dashboards.exams')
, ('public.dashboards.schools','location_city', 'Schools','public.dashboards.schools')
, ('public.dashboards.teachers','person', 'Teachers','public.dashboards.teachers')
, ('public.dashboards.specialed','people_outline', 'Special Education','public.dashboards.specialed')
, ('public.dashboards.schoolaccreditations','assessment', 'School Accreditation','public.dashboards.schoolaccreditations')
, ('public.dashboards.wash','local_hospital', 'WASH Surveys','public.dashboards.wash')

INSERT INTO Navigation
(id, icon, label, children)
VALUES ('public.dashboards','pie_chart', 'Public Data','public.indicators|public.dashboards.findata|public.dashboards.exams|public.dashboards.schools|public.dashboards.teachers|public.dashboards.specialed|public.dashboards.schoolaccreditations|public.dashboards.wash')
, ('PUBLIC','pie_chart', 'Public Access','public.dashboards')

Select * from Navigation
ROLLBACK

‌

[Ghislain Hachey]

chore(PublicAccress): add missing dashboard and cleanup menus

Resolves #1154

→ <<cset 0e5c36578201>>