46 lines
2.6 KiB
MySQL
46 lines
2.6 KiB
MySQL
|
-- 添加员工亲属关系维护菜单
|
||
|
|
-- 注意: 执行前请确认已存在"信息维护"父菜单
|
||
|
|
-- 如果不存在,请先执行以下语句创建父菜单:
|
||
|
|
-- INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, remark)
|
||
|
|
-- VALUES (2000, '信息维护', 0, 4, 'dpc', NULL, '', '', 1, 0, 'M', '0', '0', '', 'example', 'admin', NOW(), '信息维护目录');
|
||
|
|
|
||
|
|
-- 查询信息维护父菜单ID
|
||
|
|
SET @parent_menu_id = (SELECT menu_id FROM sys_menu WHERE menu_name='信息维护' AND parent_id=0 LIMIT 1);
|
||
|
|
|
||
|
|
-- 添加员工亲属关系维护菜单
|
||
|
|
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
||
|
|
VALUES
|
||
|
|
('员工亲属关系维护', @parent_menu_id, 3, 'staffFmyRelation', 'ccdiStaffFmyRelation/index', 1, 0, 'C', '0', '0', 'ccdi:staffFmyRelation:list', 'peoples', 'admin', NOW(), '', NULL, '员工亲属关系信息管理菜单');
|
||
|
|
|
||
|
|
-- 获取刚插入的菜单ID
|
||
|
|
SET @menu_id = LAST_INSERT_ID();
|
||
|
|
|
||
|
|
-- 添加按钮权限
|
||
|
|
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, remark) VALUES
|
||
|
|
('亲属关系查询', @menu_id, 1, '', '', 1, 0, 'F', '0', '0', 'ccdi:staffFmyRelation:query', '#', 'admin', NOW(), ''),
|
||
|
|
('亲属关系新增', @menu_id, 2, '', '', 1, 0, 'F', '0', '0', 'ccdi:staffFmyRelation:add', '#', 'admin', NOW(), ''),
|
||
|
|
('亲属关系修改', @menu_id, 3, '', '', 1, 0, 'F', '0', '0', 'ccdi:staffFmyRelation:edit', '#', 'admin', NOW(), ''),
|
||
|
|
('亲属关系删除', @menu_id, 4, '', '', 1, 0, 'F', '0', '0', 'ccdi:staffFmyRelation:remove', '#', 'admin', NOW(), ''),
|
||
|
|
('亲属关系导出', @menu_id, 5, '', '', 1, 0, 'F', '0', '0', 'ccdi:staffFmyRelation:export', '#', 'admin', NOW(), ''),
|
||
|
|
('亲属关系导入', @menu_id, 6, '', '', 1, 0, 'F', '0', '0', 'ccdi:staffFmyRelation:import', '#', 'admin', NOW(), '');
|
||
|
|
|
||
|
|
-- 查询结果验证
|
||
|
|
SELECT
|
||
|
|
m.menu_id AS '菜单ID',
|
||
|
|
m.menu_name AS '菜单名称',
|
||
|
|
m.parent_id AS '父菜单ID',
|
||
|
|
p.menu_name AS '父菜单名称',
|
||
|
|
m.order_num AS '显示顺序',
|
||
|
|
m.path AS '路由地址',
|
||
|
|
m.component AS '组件路径',
|
||
|
|
m.menu_type AS '菜单类型',
|
||
|
|
m.perms AS '权限标识',
|
||
|
|
m.icon AS '菜单图标',
|
||
|
|
m.visible AS '显示状态',
|
||
|
|
m.status AS '菜单状态',
|
||
|
|
m.create_time AS '创建时间'
|
||
|
|
FROM sys_menu m
|
||
|
|
LEFT JOIN sys_menu p ON m.parent_id = p.menu_id
|
||
|
|
WHERE m.menu_name = '员工亲属关系维护' OR m.parent_id = @menu_id
|
||
|
|
ORDER BY m.parent_id, m.order_num;
|