-- Apple经销商ERP系统对接项目 - 日志管理权限配置脚本
-- 创建时间: 2025-01-27
-- 版本: v1.0

-- 设置数据库和字符集
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- 使用数据库
USE apple_erp;

-- =========================================
-- 1. 插入日志管理相关菜单和权限
-- =========================================

-- 日志管理主菜单
INSERT INTO t_sys_menu (menu_id, parent_id, menu_name, menu_type, path, icon, sort, status, perms, create_by, create_time, update_by, update_time, del_flag) 
VALUES (300, 0, '日志管理', '0', '/system/log', 'log', 6, '1', '', 'admin', NOW(), 'admin', NOW(), '0');

-- 日志管理子菜单
INSERT INTO t_sys_menu (menu_id, parent_id, menu_name, menu_type, path, icon, sort, status, perms, create_by, create_time, update_by, update_time, del_flag) 
VALUES 
(3001, 300, '日志查询', '1', '/system/log/list', '', 1, '1', 'system:log:list', 'admin', NOW(), 'admin', NOW(), '0'),
(3002, 300, '日志详情', '2', '', '', 2, '1', 'system:log:query', 'admin', NOW(), 'admin', NOW(), '0'),
(3003, 300, '日志删除', '2', '', '', 3, '1', 'system:log:remove', 'admin', NOW(), 'admin', NOW(), '0'),
(3004, 300, '日志清理', '2', '', '', 4, '1', 'system:log:clean', 'admin', NOW(), 'admin', NOW(), '0'),
(3005, 300, '日志统计', '2', '', '', 5, '1', 'system:log:count', 'admin', NOW(), 'admin', NOW(), '0');

-- =========================================
-- 2. 为ADMIN角色分配日志管理权限
-- =========================================

-- 获取ADMIN角色ID
SET @admin_role_id = (SELECT role_id FROM t_sys_role WHERE role_code = 'ADMIN' AND del_flag = '0' LIMIT 1);

-- 为ADMIN角色分配日志管理权限
INSERT INTO t_sys_role_menu (role_id, menu_id, create_by, create_time, update_by, update_time, del_flag) 
SELECT @admin_role_id, menu_id, 'admin', NOW(), 'admin', NOW(), '0'
FROM t_sys_menu 
WHERE menu_id IN (300, 3001, 3002, 3003, 3004, 3005)
AND del_flag = '0';

-- =========================================
-- 3. 插入日志相关字典数据
-- =========================================

-- 插入日志类型字典
INSERT INTO t_sys_dict_type (dict_type, dict_name, status, remark, create_by, create_time, update_by, update_time, del_flag) 
VALUES 
('sys_log_type', '日志类型', 1, '系统日志类型列表', 'admin', NOW(), 'admin', NOW(), '0'),
('sys_log_status', '日志状态', 1, '日志操作状态列表', 'admin', NOW(), 'admin', NOW(), '0');

-- 插入日志类型字典项
INSERT INTO t_sys_dict_item (dict_type_id, dict_label, dict_value, sort, remark, create_by, create_time, update_by, update_time, del_flag) 
SELECT dt.dict_type_id, '操作日志', '0', 1, '操作日志', 'admin', NOW(), 'admin', NOW(), '0'
FROM t_sys_dict_type dt WHERE dt.dict_type = 'sys_log_type' AND dt.del_flag = '0';

INSERT INTO t_sys_dict_item (dict_type_id, dict_label, dict_value, sort, remark, create_by, create_time, update_by, update_time, del_flag) 
SELECT dt.dict_type_id, '异常日志', '1', 2, '异常日志', 'admin', NOW(), 'admin', NOW(), '0'
FROM t_sys_dict_type dt WHERE dt.dict_type = 'sys_log_type' AND dt.del_flag = '0';

INSERT INTO t_sys_dict_item (dict_type_id, dict_label, dict_value, sort, remark, create_by, create_time, update_by, update_time, del_flag) 
SELECT dt.dict_type_id, '登录日志', '2', 3, '登录日志', 'admin', NOW(), 'admin', NOW(), '0'
FROM t_sys_dict_type dt WHERE dt.dict_type = 'sys_log_type' AND dt.del_flag = '0';

-- 插入日志状态字典项
INSERT INTO t_sys_dict_item (dict_type_id, dict_label, dict_value, sort, remark, create_by, create_time, update_by, update_time, del_flag) 
SELECT dt.dict_type_id, '成功', '1', 1, '操作成功', 'admin', NOW(), 'admin', NOW(), '0'
FROM t_sys_dict_type dt WHERE dt.dict_type = 'sys_log_status' AND dt.del_flag = '0';

INSERT INTO t_sys_dict_item (dict_type_id, dict_label, dict_value, sort, remark, create_by, create_time, update_by, update_time, del_flag) 
SELECT dt.dict_type_id, '失败', '0', 2, '操作失败', 'admin', NOW(), 'admin', NOW(), '0'
FROM t_sys_dict_type dt WHERE dt.dict_type = 'sys_log_status' AND dt.del_flag = '0';

-- 重置外键检查
SET FOREIGN_KEY_CHECKS = 1;

-- 输出完成信息
SELECT '日志管理权限配置完成！' AS message;