complaint-system/sql/ry_dm_menu_add.sql

-- ============================================
-- 教育投诉平台 PC 后台菜单-新增（投诉中心 2020-2023）
-- 执行：DBeaver 用 COMPLAINT 连接，选中全部执行（Ctrl+Shift+Enter）
-- 注意：若之前执行过，先执行 delete from sys_menu where menu_id >= 2020;
-- ============================================
SET IDENTITY_INSERT sys_menu ON;
-- 投诉中心（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;