Files
eip4-platform/docs/sql/A1_sys_admin_menu_manage_upsert.sql
zhengwr 48dec13719 RBAC 管理后台对齐老系统:用户/角色/部门/菜单/数据权限 增删改 + amis 管理页(A1–A5)
A1 SYS_MENU CRUD(软删+清role_menu+有子拒删)+menuAll isGroup+sys-admin-menu crud树
A2 用户 reset-password(MD5 110)+sys-admin-user 新建/编辑/停用/重置按钮
A3 SYS_ROLE CRUD(删清三关联表+evictAll)+sys-admin-role 新建/编辑/删除
A4 SYS_DEPART CRUD(有子拒删)+departs/tree 读端点+新页 sys-admin-depart
A5 sys_filterrule CRUD+set-roles+filterrules/{id}/roles+sys-admin-filterrule 授权UI
AdminWriteControllerTest 35测 + AdminUserControllerTest 3测;全部 API e2e 对真实库 + 浏览器验收

Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
2026-06-14 02:03:51 +08:00

14 lines
3.7 KiB
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
-- ============================================================================
-- A1 菜单管理页 schema upsert(幂等)—— 升级 sys-admin-menu 为可管理(增删改)
-- 依赖后端 AdminWriteController /api/admin/menus/{create,update,delete} + AdminController menu-all(isGroup)
-- 应用:psql -h localhost -p 5433 -U zhengwr -d eip4dev(schema eip3 在 url)
-- ============================================================================
INSERT INTO sys_page_schema (template_id, name, schema_json, schema_etag, version, update_time)
VALUES ('sys-admin-menu', '菜单管理', '{"type":"page","title":"菜单管理","body":[{"type":"crud","name":"menuCrud","syncLocation":false,"api":{"method":"get","url":"/api/admin/menu-all","adaptor":"return {status:0,data:{items:payload.roots||[]}};"},"childrenColumnName":"children","headerToolbar":[{"type":"button","label":"新增菜单","level":"primary","icon":"fa fa-plus","actionType":"dialog","dialog":{"title":"新增菜单","body":{"type":"form","api":"post:/api/admin/menus/create","reload":"menuCrud","body":[{"type":"select","name":"menuroot","label":"所属分组","required":true,"source":{"method":"get","url":"/api/admin/menu-all","adaptor":"return {status:0,data:{options:(payload.roots||[]).map(function(r){return {label:r.name,value:r.id};})}};"}},{"type":"input-text","name":"name","label":"菜单名称","required":true},{"type":"input-text","name":"typename","label":"类型","placeholder":"如 目录/菜单"},{"type":"input-text","name":"viewTemplateId","label":"模板ID","placeholder":"指向页面 templateId,目录可空"},{"type":"input-number","name":"seq","label":"排序号","value":0}]}}},{"type":"reload","label":"刷新"}],"footerToolbar":[],"columns":[{"name":"name","label":"菜单名"},{"name":"typename","label":"类型"},{"name":"templateId","label":"模板ID","type":"tpl","tpl":"<span class=\"text-muted\">${templateId|default:-}</span>"},{"name":"seq","label":"排序"},{"type":"operation","label":"操作","width":240,"buttons":[{"type":"button","label":"加子菜单","level":"link","visibleOn":"${!isGroup}","actionType":"dialog","dialog":{"title":"在「${name}」下新增子菜单","body":{"type":"form","api":"post:/api/admin/menus/create","reload":"menuCrud","body":[{"type":"hidden","name":"parentId","value":"${id}"},{"type":"input-text","name":"name","label":"菜单名称","required":true},{"type":"input-text","name":"typename","label":"类型"},{"type":"input-text","name":"viewTemplateId","label":"模板ID"},{"type":"input-number","name":"seq","label":"排序号","value":0}]}}},{"type":"button","label":"编辑","level":"link","visibleOn":"${!isGroup}","actionType":"dialog","dialog":{"title":"编辑菜单「${name}」","body":{"type":"form","api":"post:/api/admin/menus/${id}/update","reload":"menuCrud","body":[{"type":"input-text","name":"name","label":"菜单名称","required":true,"value":"${name}"},{"type":"input-text","name":"typename","label":"类型","value":"${typename}"},{"type":"input-text","name":"viewTemplateId","label":"模板ID","value":"${templateId}"},{"type":"input-number","name":"seq","label":"排序号","value":"${seq}"}]}}},{"type":"button","label":"删除","level":"link","className":"text-danger","visibleOn":"${!isGroup}","actionType":"ajax","confirmText":"确认删除菜单「${name}」?有子菜单时会被拒绝。","api":"post:/api/admin/menus/${id}/delete","reload":"menuCrud"}]}]}]}'::jsonb, '3d65184270fcf65b71189fb0a4ba2e96624c71d1e90a7bc9527a0a685e064c12', 1, 1749600000000)
ON CONFLICT (template_id) DO UPDATE
SET name = EXCLUDED.name,
schema_json = EXCLUDED.schema_json,
schema_etag = EXCLUDED.schema_etag,
version = sys_page_schema.version + 1,
update_time = EXCLUDED.update_time;