39 lines
3.6 KiB
MySQL
39 lines
3.6 KiB
MySQL
|
-- 仅新增健康菜单与权限，超级管理员会自动获得；普通管理员通过角色授权。
|
||
|
|
SET NAMES utf8mb4;
|
||
|
|
START TRANSACTION;
|
||
|
|
INSERT INTO system_menu (name,permission,type,sort,parent_id,path,icon,status,visible,keep_alive,always_show)
|
||
|
|
SELECT '健康服务','',1,5,0,'/health','ep:first-aid-kit',0,b'1',b'1',b'1'
|
||
|
|
WHERE NOT EXISTS (SELECT 1 FROM system_menu WHERE parent_id=0 AND path='/health' AND deleted=b'0');
|
||
|
|
SET @health_menu = (SELECT id FROM system_menu WHERE parent_id=0 AND path='/health' AND deleted=b'0' LIMIT 1);
|
||
|
|
INSERT INTO system_menu (name,permission,type,sort,parent_id,path,icon,component,component_name,status,visible,keep_alive,always_show)
|
||
|
|
SELECT '身份与档案','health:identity:query',2,1,@health_menu,'identity','ep:user','health/identity/index','HealthIdentity',0,b'1',b'1',b'1'
|
||
|
|
WHERE NOT EXISTS (SELECT 1 FROM system_menu WHERE permission='health:identity:query' AND deleted=b'0');
|
||
|
|
SET @health_child = (SELECT id FROM system_menu WHERE permission='health:identity:query' AND deleted=b'0' LIMIT 1);
|
||
|
|
INSERT INTO system_menu (name,permission,type,sort,parent_id,path,status,visible,keep_alive,always_show)
|
||
|
|
SELECT '新增档案','health:identity:create',3,1,@health_child,'',0,b'1',b'1',b'1'
|
||
|
|
WHERE NOT EXISTS (SELECT 1 FROM system_menu WHERE permission='health:identity:create' AND deleted=b'0');
|
||
|
|
INSERT INTO system_menu (name,permission,type,sort,parent_id,path,status,visible,keep_alive,always_show)
|
||
|
|
SELECT '编辑档案','health:identity:update',3,1,@health_child,'',0,b'1',b'1',b'1'
|
||
|
|
WHERE NOT EXISTS (SELECT 1 FROM system_menu WHERE permission='health:identity:update' AND deleted=b'0');
|
||
|
|
INSERT INTO system_menu (name,permission,type,sort,parent_id,path,status,visible,keep_alive,always_show)
|
||
|
|
SELECT '志愿者审核','health:identity:audit',3,1,@health_child,'',0,b'1',b'1',b'1'
|
||
|
|
WHERE NOT EXISTS (SELECT 1 FROM system_menu WHERE permission='health:identity:audit' AND deleted=b'0');
|
||
|
|
INSERT INTO system_menu (name,permission,type,sort,parent_id,path,status,visible,keep_alive,always_show)
|
||
|
|
SELECT '启用停用','health:identity:update-status',3,1,@health_child,'',0,b'1',b'1',b'1'
|
||
|
|
WHERE NOT EXISTS (SELECT 1 FROM system_menu WHERE permission='health:identity:update-status' AND deleted=b'0');
|
||
|
|
INSERT INTO system_menu (name,permission,type,sort,parent_id,path,icon,component,component_name,status,visible,keep_alive,always_show)
|
||
|
|
SELECT '家属关联','health:family-relation:query',2,2,@health_menu,'family-relation','ep:connection','health/family-relation/index','HealthFamilyRelation',0,b'1',b'1',b'1'
|
||
|
|
WHERE NOT EXISTS (SELECT 1 FROM system_menu WHERE permission='health:family-relation:query' AND deleted=b'0');
|
||
|
|
SET @health_child = (SELECT id FROM system_menu WHERE permission='health:family-relation:query' AND deleted=b'0' LIMIT 1);
|
||
|
|
INSERT INTO system_menu (name,permission,type,sort,parent_id,path,status,visible,keep_alive,always_show)
|
||
|
|
SELECT '新增关联','health:family-relation:create',3,1,@health_child,'',0,b'1',b'1',b'1'
|
||
|
|
WHERE NOT EXISTS (SELECT 1 FROM system_menu WHERE permission='health:family-relation:create' AND deleted=b'0');
|
||
|
|
INSERT INTO system_menu (name,permission,type,sort,parent_id,path,status,visible,keep_alive,always_show)
|
||
|
|
SELECT '核实确认及重提','health:family-relation:review',3,1,@health_child,'',0,b'1',b'1',b'1'
|
||
|
|
WHERE NOT EXISTS (SELECT 1 FROM system_menu WHERE permission='health:family-relation:review' AND deleted=b'0');
|
||
|
|
INSERT INTO system_menu (name,permission,type,sort,parent_id,path,status,visible,keep_alive,always_show)
|
||
|
|
SELECT '解除关联','health:family-relation:revoke',3,1,@health_child,'',0,b'1',b'1',b'1'
|
||
|
|
WHERE NOT EXISTS (SELECT 1 FROM system_menu WHERE permission='health:family-relation:revoke' AND deleted=b'0');
|
||
|
|
COMMIT;
|
||
|
|
|