Files
eip4-platform/docs/sql/A2-A4_sys_admin_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

11 lines
8.9 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.
-- A2/A3/A4 sys-admin 管理页 schema upsert(幂等)
INSERT INTO sys_page_schema (template_id, name, schema_json, schema_etag, version, update_time)
VALUES ('sys-admin-user', '用户管理', '{"type":"page","title":"用户管理","body":[{"type":"crud","name":"userCrud","syncLocation":false,"api":{"method":"get","url":"/api/admin/users?page=${page}&perPage=${perPage}&keyword=${keyword}","adaptor":"if(payload&&payload.data){return payload;}return {status:0,data:{items:payload.items||[],total:payload.total||0}};"},"headerToolbar":[{"type":"button","label":"新建用户","level":"primary","icon":"fa fa-plus","actionType":"dialog","dialog":{"title":"新建用户","body":{"type":"form","api":"post:/api/admin/users/create","reload":"userCrud","body":[{"type":"input-text","name":"account","label":"账号","required":true},{"type":"input-text","name":"name","label":"姓名","required":true},{"type":"input-text","name":"userorgid","label":"所属部门ID","placeholder":"可空,部门主键"},{"type":"alert","level":"info","body":"初始密码为 110,可在列表「重置密码」恢复。角色通过「权限分配」页按用户组授予。"}]}}},{"type":"tpl","tpl":"共 ${total} 条","className":"v-middle"},"pagination"],"footerToolbar":["statistics","pagination"],"perPage":20,"filter":{"title":"查询条件","submitText":"查询","body":[{"type":"input-text","name":"keyword","label":"账号/姓名","placeholder":"输入账号或姓名关键字","clearable":true}]},"columns":[{"name":"account","label":"账号"},{"name":"name","label":"姓名"},{"name":"departName","label":"部门"},{"name":"state","label":"激活状态","type":"mapping","map":{"1":"<span class=\"label label-success\">激活</span>","2":"<span class=\"label label-warning\">停用</span>","3":"<span class=\"label label-default\">未激活</span>","*":"<span class=\"label label-default\">未知</span>"}},{"type":"operation","label":"操作","width":290,"buttons":[{"type":"button","label":"编辑","level":"link","actionType":"dialog","dialog":{"title":"编辑用户「${name}」","body":{"type":"form","api":"post:/api/admin/users/${id}/update","reload":"userCrud","body":[{"type":"static","name":"account","label":"账号"},{"type":"input-text","name":"name","label":"姓名","required":true,"value":"${name}"}]}}},{"type":"button","label":"停用","level":"link","className":"text-warning","visibleOn":"${state == 1}","actionType":"ajax","confirmText":"确认停用用户「${name}」?","api":{"method":"post","url":"/api/admin/users/${id}/toggle-state","data":{"state":2}},"reload":"userCrud"},{"type":"button","label":"启用","level":"link","className":"text-success","visibleOn":"${state != 1}","actionType":"ajax","confirmText":"确认启用用户「${name}」?","api":{"method":"post","url":"/api/admin/users/${id}/toggle-state","data":{"state":1}},"reload":"userCrud"},{"type":"button","label":"重置密码","level":"link","className":"text-danger","actionType":"ajax","confirmText":"确认将「${name}」密码重置为初始密码(110)?","api":"post:/api/admin/users/${id}/reset-password","reload":"userCrud"}]}]}]}'::jsonb, 'f351ba9ccab80bc1a9cf3ca5cc876b5f2c3930f29d021baa85982c65af84b523', 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;
INSERT INTO sys_page_schema (template_id, name, schema_json, schema_etag, version, update_time)
VALUES ('sys-admin-role', '角色管理', '{"type":"page","title":"角色管理","body":[{"type":"crud","name":"roleCrud","syncLocation":false,"api":{"method":"get","url":"/api/org/roles","adaptor":"var d=payload.data||{};return {status:0,data:{items:d.items||[],total:d.total||0}};"},"headerToolbar":[{"type":"button","label":"新建角色","level":"primary","icon":"fa fa-plus","actionType":"dialog","dialog":{"title":"新建角色","body":{"type":"form","api":"post:/api/admin/roles/create","reload":"roleCrud","body":[{"type":"input-text","name":"name","label":"角色名称","required":true},{"type":"textarea","name":"description","label":"描述"},{"type":"select","name":"roletype","label":"角色类型","value":1,"options":[{"label":"功能角色","value":1},{"label":"数据角色","value":2}]}]}}},{"type":"tpl","tpl":"共 ${total} 条角色","className":"v-middle"}],"footerToolbar":["statistics","pagination"],"perPage":20,"columns":[{"name":"name","label":"角色名称"},{"name":"description","label":"描述"},{"name":"roleType","label":"类型","type":"mapping","map":{"1":"功能角色","2":"数据角色","*":"其他"}},{"type":"operation","label":"操作","width":260,"buttons":[{"type":"button","label":"编辑","level":"link","actionType":"dialog","dialog":{"title":"编辑角色「${name}」","body":{"type":"form","api":"post:/api/admin/roles/${id}/update","reload":"roleCrud","body":[{"type":"input-text","name":"name","label":"角色名称","required":true,"value":"${name}"},{"type":"textarea","name":"description","label":"描述","value":"${description}"},{"type":"select","name":"roletype","label":"角色类型","value":"${roleType}","options":[{"label":"功能角色","value":1},{"label":"数据角色","value":2}]}]}}},{"type":"button","label":"查看成员","level":"link","actionType":"dialog","dialog":{"title":"角色「${name}」成员列表","size":"lg","body":{"type":"service","api":{"method":"get","url":"/api/admin/roles/${id}/users","adaptor":"var d=payload.data||{};return {status:0,data:{items:d.items||[],total:d.total||0}};"},"body":{"type":"table","source":"${items}","columns":[{"name":"account","label":"账号"},{"name":"userName","label":"姓名"},{"name":"state","label":"激活状态","type":"mapping","map":{"1":"激活","2":"停用","3":"未激活","*":"未知"}}]}},"actions":[{"type":"button","label":"关闭","actionType":"close"}]}},{"type":"button","label":"删除","level":"link","className":"text-danger","actionType":"ajax","confirmText":"确认删除角色「${name}」?将一并清除其菜单权限与用户组关联。","api":"post:/api/admin/roles/${id}/delete","reload":"roleCrud"}]}]}]}'::jsonb, '1a7b151ef4b28444fc0d15d1a1003a763b77864d807cd701721c7bccc11ad87c', 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;
INSERT INTO sys_page_schema (template_id, name, schema_json, schema_etag, version, update_time)
VALUES ('sys-admin-depart', '部门管理', '{"type":"page","title":"部门管理","body":[{"type":"crud","name":"deptCrud","syncLocation":false,"api":{"method":"get","url":"/api/admin/departs/tree","adaptor":"return {status:0,data:{items:payload.items||[]}};"},"childrenColumnName":"children","headerToolbar":[{"type":"button","label":"新建顶级部门","level":"primary","icon":"fa fa-plus","actionType":"dialog","dialog":{"title":"新建顶级部门","body":{"type":"form","api":"post:/api/admin/departs/create","reload":"deptCrud","body":[{"type":"input-text","name":"name","label":"部门名称","required":true},{"type":"input-text","name":"leader","label":"负责人"},{"type":"textarea","name":"description","label":"描述"},{"type":"input-number","name":"seq","label":"排序号","value":0}]}}},{"type":"reload","label":"刷新"}],"footerToolbar":[],"columns":[{"name":"name","label":"部门名"},{"name":"leader","label":"负责人"},{"name":"seq","label":"排序"},{"type":"operation","label":"操作","width":240,"buttons":[{"type":"button","label":"加子部门","level":"link","actionType":"dialog","dialog":{"title":"在「${name}」下新增子部门","body":{"type":"form","api":"post:/api/admin/departs/create","reload":"deptCrud","body":[{"type":"hidden","name":"parentId","value":"${id}"},{"type":"input-text","name":"name","label":"部门名称","required":true},{"type":"input-text","name":"leader","label":"负责人"},{"type":"input-number","name":"seq","label":"排序号","value":0}]}}},{"type":"button","label":"编辑","level":"link","actionType":"dialog","dialog":{"title":"编辑部门「${name}」","body":{"type":"form","api":"post:/api/admin/departs/${id}/update","reload":"deptCrud","body":[{"type":"input-text","name":"name","label":"部门名称","required":true,"value":"${name}"},{"type":"input-text","name":"leader","label":"负责人","value":"${leader}"},{"type":"input-number","name":"seq","label":"排序号","value":"${seq}"}]}}},{"type":"button","label":"删除","level":"link","className":"text-danger","actionType":"ajax","confirmText":"确认删除部门「${name}」?有子部门时会被拒绝。","api":"post:/api/admin/departs/${id}/delete","reload":"deptCrud"}]}]}]}'::jsonb, '16ae6c51f5889b0cfa058b0f30311a3bd5688e79ee539c1b2522cc381d3f020c', 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;