complaint-system/sql/ry_dm_menu.sql

-- ============================================
-- 教育投诉平台 PC 后台菜单（达梦 DM8，模式 COMPLAINT）
-- 权限字符串与后端 ComplaintController @PreAuthorize 对应
-- 执行方式：DBeaver 用 COMPLAINT 连接，Ctrl+Shift+Enter
-- ============================================

SET IDENTITY_INSERT sys_menu ON;

-- 一级菜单
insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, "query", route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values (2001, '工作台', 0, 1, 'dashboard', 'complaint/dashboard/index', '', '', 1, 0, 'C', '0', '0', 'complaint:dashboard:list', 'dashboard', 'admin', sysdate, '', null, '投诉工作台');

insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, "query", route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values (2002, '工单管理', 0, 2, 'workorder', '', '', '', 1, 0, 'M', '0', '0', '', 'order', 'admin', sysdate, '', null, '工单管理目录');

insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, "query", route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values (2003, '工单列表', 2002, 1, 'list', 'complaint/workorder/index', '', '', 1, 0, 'C', '0', '0', 'complaint:workorder:list', 'list', 'admin', sysdate, '', null, '工单列表');

insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, "query", route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values (2004, '复核管理', 0, 3, 'review', 'complaint/review/index', '', '', 1, 0, 'C', '0', '0', 'complaint:review:list', 'audit', 'admin', sysdate, '', null, '异议复核管理');

insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, "query", route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values (2005, '统计分析', 0, 4, 'statistics', 'complaint/statistics/index', '', '', 1, 0, 'C', '0', '0', 'complaint:statistics:list', 'chart', 'admin', sysdate, '', null, '统计分析');

insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, "query", route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values (2006, '系统设置', 0, 5, 'settings', '', '', '', 1, 0, 'M', '0', '0', '', 'settings', 'admin', sysdate, '', null, '系统设置目录');

insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, "query", route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values (2007, '学校管理员', 2006, 1, 'admin', 'complaint/admin/index', '', '', 1, 0, 'C', '0', '0', 'complaint:admin:list', 'peoples', 'admin', sysdate, '', null, '学校管理员维护');

insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, "query", route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values (2008, '学校管理', 2006, 2, 'school', 'complaint/school/index', '', '', 1, 0, 'C', '0', '0', 'complaint:school:list', 'tree', 'admin', sysdate, '', null, '学校机构管理');

-- 按钮权限
insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, "query", route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values (2010, '工单查询', 2003, 1, '', '', '', '', 1, 0, 'F', '0', '0', 'complaint:workorder:query', '#', 'admin', sysdate, '', null, '');

insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, "query", route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values (2011, '工单处置', 2003, 2, '', '', '', '', 1, 0, 'F', '0', '0', 'complaint:workorder:handle', '#', 'admin', sysdate, '', null, '受理/暂存/办结/驳回');

insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, "query", route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values (2012, '复核处理', 2004, 1, '', '', '', '', 1, 0, 'F', '0', '0', 'complaint:review:handle', '#', 'admin', sysdate, '', null, '维持原判/复核通过');

insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, "query", route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values (2013, '管理员新增', 2007, 1, '', '', '', '', 1, 0, 'F', '0', '0', 'complaint:admin:add', '#', 'admin', sysdate, '', null, '');

insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, "query", route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values (2014, '管理员修改', 2007, 2, '', '', '', '', 1, 0, 'F', '0', '0', 'complaint:admin:edit', '#', 'admin', sysdate, '', null, '');

insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, "query", route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values (2015, '管理员删除', 2007, 3, '', '', '', '', 1, 0, 'F', '0', '0', 'complaint:admin:remove', '#', 'admin', sysdate, '', null, '');

insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, "query", route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values (2016, '数据同步', 2008, 1, '', '', '', '', 1, 0, 'F', '0', '0', 'complaint:school:sync', '#', 'admin', sysdate, '', null, '机构数据手动同步');


-- 投诉中心（PC 端投诉与记录查询）
insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, "query", route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values (2020, '投诉中心', 0, 6, 'complaint-center', '', '', '', 1, 0, 'M', '0', '0', '', 'form', 'admin', sysdate, '', null, 'PC端投诉与记录查询目录');

insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, "query", route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values (2021, '我要投诉', 2020, 1, 'submit', 'complaint/submit/index', '', '', 1, 0, 'C', '0', '0', 'complaint:submit:add', 'edit', 'admin', sysdate, '', null, 'PC端投诉填报');

insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, "query", route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values (2022, '我的投诉记录', 2020, 2, 'record-list', 'complaint/record/index', '', '', 1, 0, 'C', '0', '0', 'complaint:record:list', 'list', 'admin', sysdate, '', null, 'PC端查看投诉记录');

insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, "query", route_name, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values (2023, '工单详情', 2020, 3, 'record-detail', 'complaint/record/detail', '', '', 1, 0, 'C', '1', '0', 'complaint:record:query', '#', 'admin', sysdate, '', null, '投诉记录详情（隐藏菜单，列表跳转进入）');
SET IDENTITY_INSERT sys_menu OFF;

commit;