23 lines
1.5 KiB
SQL
23 lines
1.5 KiB
SQL
-- =============================================
|
|
-- 员工调动记录管理菜单权限配置
|
|
-- 父级菜单: 信息维护(menu_id=2000)
|
|
-- 作者: ruoyi
|
|
-- 日期: 2026-02-10
|
|
-- =============================================
|
|
|
|
-- 主菜单: 员工调动记录管理
|
|
INSERT INTO `sys_menu` (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, remark)
|
|
VALUES ('员工调动记录', 2000, 4, 'staffTransfer', 'ccdiStaffTransfer/index', NULL, NULL, 1, 0, 'C', '0', '0', 'ccdi:staffTransfer:list', 'peoples', 'admin', NOW(), '员工调动记录管理菜单');
|
|
|
|
-- 获取刚插入的menu_id
|
|
SET @menu_id = LAST_INSERT_ID();
|
|
|
|
-- 子菜单按钮权限
|
|
INSERT INTO `sys_menu` (menu_name, parent_id, order_num, path, component, menu_type, visible, status, perms, create_by, create_time) VALUES
|
|
('员工调动记录查询', @menu_id, 1, '', NULL, 'F', '0', '0', 'ccdi:staffTransfer:query', 'admin', NOW()),
|
|
('员工调动记录新增', @menu_id, 2, '', NULL, 'F', '0', '0', 'ccdi:staffTransfer:add', 'admin', NOW()),
|
|
('员工调动记录修改', @menu_id, 3, '', NULL, 'F', '0', '0', 'ccdi:staffTransfer:edit', 'admin', NOW()),
|
|
('员工调动记录删除', @menu_id, 4, '', NULL, 'F', '0', '0', 'ccdi:staffTransfer:remove', 'admin', NOW()),
|
|
('员工调动记录导出', @menu_id, 5, '', NULL, 'F', '0', '0', 'ccdi:staffTransfer:export', 'admin', NOW()),
|
|
('员工调动记录导入', @menu_id, 6, '', NULL, 'F', '0', '0', 'ccdi:staffTransfer:import', 'admin', NOW());
|