all-project/backend/script/sql/add-head-teacher-role.sql

-- 添加班主任角色
INSERT INTO sys_role (role_id, role_name, role_key, role_sort, data_scope, menu_check_strictly, dept_check_strictly, status, del_flag, create_by, create_time, update_by, update_time, remark, tenant_id)
VALUES (1947639680473493505, '班主任', 'head_teacher', 3, '1', 1, 1, '0', '0', 1, NOW(), 1, NOW(), '班主任角色', '000000');

-- 为班主任角色添加菜单权限
INSERT INTO sys_role_menu (role_id, menu_id, tenant_id)
SELECT 1947639680473493505, menu_id, '000000' FROM sys_menu WHERE perms LIKE 'xg:%' AND status = '0' AND del_flag = '0';

-- 为智控学院张三用户分配班主任角色
INSERT INTO sys_user_role (user_id, role_id, tenant_id)
VALUES (2001, 1947639680473493505, '000000');

-- 为信息学院李四用户分配班主任角色
INSERT INTO sys_user_role (user_id, role_id, tenant_id)
VALUES (2002, 1947639680473493505, '000000');

-- 为机电学院王五用户分配班主任角色
INSERT INTO sys_user_role (user_id, role_id, tenant_id)
VALUES (2003, 1947639680473493505, '000000');

-- 为经管学院赵六用户分配班主任角色
INSERT INTO sys_user_role (user_id, role_id, tenant_id)
VALUES (2004, 1947639680473493505, '000000');

-- 添加班主任角色相关的权限
INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query_param, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark, tenant_id)
VALUES (1947639680473493506, '班主任管理', 2000, 5, 'headteacher', 'xg-xx/headteacher/index', NULL, 1, 0, 'C', '0', '0', 'xg:headteacher:list', 'user', 1, NOW(), NULL, NULL, '班主任管理菜单', '000000');

-- 添加班主任管理按钮权限
INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query_param, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark, tenant_id)
VALUES (1947639680473493507, '班主任查询', 1947639680473493506, 1, '', '', NULL, 1, 0, 'F', '0', '0', 'xg:headteacher:query', '#', 1, NOW(), NULL, NULL, '', '000000');

INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query_param, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark, tenant_id)
VALUES (1947639680473493508, '班主任新增', 1947639680473493506, 2, '', '', NULL, 1, 0, 'F', '0', '0', 'xg:headteacher:add', '#', 1, NOW(), NULL, NULL, '', '000000');

INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query_param, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark, tenant_id)
VALUES (1947639680473493509, '班主任修改', 1947639680473493506, 3, '', '', NULL, 1, 0, 'F', '0', '0', 'xg:headteacher:edit', '#', 1, NOW(), NULL, NULL, '', '000000');

INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query_param, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark, tenant_id)
VALUES (1947639680473493510, '班主任删除', 1947639680473493506, 4, '', '', NULL, 1, 0, 'F', '0', '0', 'xg:headteacher:remove', '#', 1, NOW(), NULL, NULL, '', '000000');

-- 为班主任角色添加班主任管理权限
INSERT INTO sys_role_menu (role_id, menu_id, tenant_id)
VALUES (1947639680473493505, 1947639680473493506, '000000'),
       (1947639680473493505, 1947639680473493507, '000000'),
       (1947639680473493505, 1947639680473493508, '000000'),
       (1947639680473493505, 1947639680473493509, '000000'),
       (1947639680473493505, 1947639680473493510, '000000');