5f5c0759ce
1. 修改 SysNotification 实体，新增 senderId, senderName, targetType 字段 2. 新增 SendNotificationRequest 请求DTO 3. 扩展通知类型至6种（新增用户通知、课程通知） 4. 实现角色层级权限控制，支持多级管理员通知下级 5. 支持老师群发课程通知给学生 6. 新增批量发送接口和权限配置
103 lines
9.2 KiB
SQL
103 lines
9.2 KiB
SQL
INSERT INTO sys_role_permission (role_id, role_code, model_name, permission_code, permission_name, create_time, update_time) VALUES
|
|
-- 系统管理模块
|
|
(1, 'SUPER', '系统管理', 'sysUser:add', '用户新增', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '系统管理', 'sysUser:edit', '用户修改', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '系统管理', 'sysUser:delete', '用户删除', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '系统管理', 'sysUser:query', '用户查询', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '系统管理', 'sysUser:resetPwd', '重置密码', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '系统管理', 'sysRole:add', '角色新增', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '系统管理', 'sysRole:edit', '角色修改', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '系统管理', 'sysRole:delete', '角色删除', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '系统管理', 'sysRole:query', '角色查询', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '系统管理', 'sysMenu:add', '菜单新增', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '系统管理', 'sysMenu:edit', '菜单修改', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '系统管理', 'sysMenu:delete', '菜单删除', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '系统管理', 'sysDict:manage', '字典管理', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '系统管理', 'sysLog:query', '日志查询', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '系统管理', 'sysDept:add', '部门新增', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '系统管理', 'sysDept:edit', '部门修改', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '系统管理', 'sysDept:delete', '部门删除', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '系统管理', 'sysDept:query', '部门查询', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
|
|
-- 通知管理模块
|
|
(1, 'SUPER', '通知管理', 'notification:add', '发送通知', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '通知管理', 'notification:delete', '删除通知', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '通知管理', 'notification:query', '查询通知', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '通知管理', 'notification:edit', '编辑通知', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
|
|
-- 课程管理模块
|
|
(1, 'SUPER', '课程管理', 'course:add', '课程新增', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '课程管理', 'course:edit', '课程修改', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '课程管理', 'course:delete', '课程删除', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '课程管理', 'course:query', '课程查询', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
|
|
-- 考勤管理模块
|
|
(1, 'SUPER', '考勤管理', 'attendance:add', '考勤新增', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '考勤管理', 'attendance:edit', '考勤修改', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '考勤管理', 'attendance:delete', '考勤删除', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '考勤管理', 'attendance:query', '考勤查询', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '考勤管理', 'attendance:scan', '扫码签到', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
|
|
-- 教师管理模块
|
|
(1, 'SUPER', '教师管理', 'teacher:add', '教师新增', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '教师管理', 'teacher:edit', '教师修改', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '教师管理', 'teacher:delete', '教师删除', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '教师管理', 'teacher:query', '教师查询', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
|
|
-- 学生管理模块
|
|
(1, 'SUPER', '学生管理', 'student:add', '学生新增', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '学生管理', 'student:edit', '学生修改', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '学生管理', 'student:delete', '学生删除', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '学生管理', 'student:query', '学生查询', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
|
|
-- 作业管理模块
|
|
(1, 'SUPER', '作业管理', 'homework:add', '作业新增', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '作业管理', 'homework:edit', '作业修改', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '作业管理', 'homework:delete', '作业删除', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '作业管理', 'homework:query', '作业查询', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '作业管理', 'homework:submit', '作业提交', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '作业管理', 'homework:grade', '作业批改', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
|
|
-- 考试管理模块
|
|
(1, 'SUPER', '考试管理', 'exam:add', '考试新增', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '考试管理', 'exam:edit', '考试修改', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '考试管理', 'exam:delete', '考试删除', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '考试管理', 'exam:query', '考试查询', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '考试管理', 'exam:submit', '考试提交', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '考试管理', 'exam:grade', '考试批改', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '考试管理', 'exam:makeup', '创建补考', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
|
|
-- 优秀作品模块
|
|
(1, 'SUPER', '优秀作品', 'excellentWork:add', '作品新增', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '优秀作品', 'excellentWork:delete', '作品删除', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '优秀作品', 'excellentWork:query', '作品查询', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '优秀作品', 'excellentWork:like', '作品点赞', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '优秀作品', 'excellentWork:mark', '标记优秀', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
|
|
-- 账户管理模块
|
|
(1, 'SUPER', '账户管理', 'account:query', '账户查询', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '账户管理', 'account:recharge', '账户充值', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '账户管理', 'account:gift', '赠送金额', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(1, 'SUPER', '账户管理', 'account:transaction', '交易记录', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
|
|
-- SCHOOL_ADMIN 角色权限
|
|
(2, 'SCHOOL_ADMIN', '系统管理', 'sysUser:query', '用户查询', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(2, 'SCHOOL_ADMIN', '系统管理', 'sysRole:query', '角色查询', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(2, 'SCHOOL_ADMIN', '教师管理', 'teacher:add', '教师新增', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(2, 'SCHOOL_ADMIN', '教师管理', 'teacher:edit', '教师修改', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(2, 'SCHOOL_ADMIN', '教师管理', 'teacher:delete', '教师删除', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(2, 'SCHOOL_ADMIN', '教师管理', 'teacher:query', '教师查询', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(2, 'SCHOOL_ADMIN', '学生管理', 'student:add', '学生新增', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(2, 'SCHOOL_ADMIN', '学生管理', 'student:edit', '学生修改', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(2, 'SCHOOL_ADMIN', '学生管理', 'student:delete', '学生删除', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(2, 'SCHOOL_ADMIN', '学生管理', 'student:query', '学生查询', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(2, 'SCHOOL_ADMIN', '课程管理', 'course:add', '课程新增', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(2, 'SCHOOL_ADMIN', '课程管理', 'course:edit', '课程修改', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(2, 'SCHOOL_ADMIN', '课程管理', 'course:delete', '课程删除', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(2, 'SCHOOL_ADMIN', '课程管理', 'course:query', '课程查询', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(2, 'SCHOOL_ADMIN', '考勤管理', 'attendance:add', '考勤新增', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(2, 'SCHOOL_ADMIN', '考勤管理', 'attendance:edit', '考勤修改', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(2, 'SCHOOL_ADMIN', '考勤管理', 'attendance:query', '考勤查询', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(2, 'SCHOOL_ADMIN', '作业管理', 'homework:query', '作业查询', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(2, 'SCHOOL_ADMIN', '考试管理', 'exam:query', '考试查询', '2026-04-30 18:00:00', '2026-05-08 16:33:19'),
|
|
(2, 'SCHOOL_ADMIN', '优秀作品', 'excellentWork:query', '作品查询', '2026-04-30 18:00:00', '2026-05-08 16:33:19'); |