INSERT INTO `sys_function_code` (`FunctionCode`, `FunctionName`, `ParentFunctionCode`, `OrderNo`) VALUES ('T01220101', '日报', 'T012201', 1), ('T01220201', '周报', 'T012202', 1), ('T01220202', '周报评阅', 'T012202', 2), ('T01220301', '月报', 'T012203', 1), ('T01220302', '月报评阅', 'T012203', 2), ('T01220304', '编辑月报', 'T012203', 4), ('T01220401', '实习总结及鉴定', 'T012204', 1), ('T01220402', '实习总结及鉴定评阅', 'T012204', 2); update sys_menu set FunctionCode = MenuNo where MenuNo='S01220201'; update sys_menu set FunctionCode = MenuNo where MenuNo='S01220203'; update sys_menu set FunctionCode = MenuNo where MenuNo='S01220204'; update sys_menu set FunctionCode = MenuNo where MenuNo='S01220301'; update sys_menu set FunctionCode = MenuNo where MenuNo='S01220303'; update sys_menu set FunctionCode = MenuNo where MenuNo='S01220304'; update sys_menu set FunctionCode = MenuNo where MenuNo='S01220401'; update sys_menu set FunctionCode = MenuNo where MenuNo='S01220403'; update sys_menu set FunctionCode = MenuNo where MenuNo='S01220404'; update sys_menu set FunctionCode = MenuNo where MenuNo='T01220102'; update sys_menu set FunctionCode = MenuNo where MenuNo='T01220103'; update sys_menu set FunctionCode = MenuNo where MenuNo='T01220203'; update sys_menu set FunctionCode = MenuNo where MenuNo='T01220204'; update sys_menu set FunctionCode = MenuNo where MenuNo='T01220303'; update sys_menu set FunctionCode = MenuNo where MenuNo='T01220403'; update sys_menu set FunctionCode = MenuNo where MenuNo='T01220404'; update sys_menu set FunctionCode = MenuNo where MenuNo='T01220101'; update sys_menu set FunctionCode = MenuNo where MenuNo='T01220201'; update sys_menu set FunctionCode = MenuNo where MenuNo='T01220202'; update sys_menu set FunctionCode = MenuNo where MenuNo='T01220301'; update sys_menu set FunctionCode = MenuNo where MenuNo='T01220302'; update sys_menu set FunctionCode = MenuNo where MenuNo='T01220304'; update sys_menu set FunctionCode = MenuNo where MenuNo='T01220401'; update sys_menu set FunctionCode = MenuNo where MenuNo='T01220402'; update sys_menu set FunctionCode = MenuNo where MenuNo='S01220101'; update sys_menu set FunctionCode = ParentMenuNo where (MenuNo like 'T0122%' or MenuNo like 'S0122%') and ParentMenuNo not like '%0122' and MenuNo not like '%0122' -- 以上sql测试服已执行----------------------------------------------------------------------------------------------------------------- --- 2023.04.10 create table sys_role_sys_menu_shortcut ( RoleID varchar(50) not null, MenuNo varchar(50) not null, primary key (RoleID, MenuNo) ); alter table sys_role_sys_menu_shortcut add constraint FK_Reference_110 foreign key (RoleID) references sys_role (RoleID) on delete restrict on update restrict; alter table sys_role_sys_menu_shortcut add constraint FK_Reference_111 foreign key (MenuNo) references sys_menu (MenuNo) on delete restrict on update restrict; alter table sys_menu add ShortcutIcon varchar(50); update sys_menu set shortcutIcon='实习任务.png' where menuno='T0112'; update sys_menu set shortcutIcon='实习生名单.png' where menuno='T0114'; update sys_menu set shortcutIcon='请假申请（请假管理）.png' where menuno='T013007'; update sys_menu set shortcutIcon='补签申请（补签管理）.png' where menuno='T013004'; update sys_menu set shortcutIcon='周报.png' where menuno='T01220201'; update sys_menu set shortcutIcon='月报.png' where menuno='T01220301'; update sys_menu set shortcutIcon='实习任务.png' where menuno='S0111'; update sys_menu set shortcutIcon='日报.png' where menuno='S01220101'; update sys_menu set shortcutIcon='周报.png' where menuno='S01220201'; update sys_menu set shortcutIcon='轮科记录.png' where menuno='S010901'; update sys_menu set shortcutIcon='补签申请（补签管理）.png' where menuno='S010701'; update sys_menu set shortcutIcon='请假申请（请假管理）.png' where menuno='S010801'; update sys_menu set shortcutIcon='实习生名单.png' where menuno='E0103'; update sys_menu set shortcutIcon='非轮科成绩.png' where menuno='E010401'; update sys_menu set shortcutIcon='轮科成绩.png' where menuno='E010402'; insert into sys_role_sys_menu_shortcut values('8f5eb41d-fb05-48b7-9e2f-40b034918236','T0112'),('8f5eb41d-fb05-48b7-9e2f-40b034918236','T0114'),('8f5eb41d-fb05-48b7-9e2f-40b034918236','T013007'), ('8f5eb41d-fb05-48b7-9e2f-40b034918236','T013004'),('8f5eb41d-fb05-48b7-9e2f-40b034918236','T01220201'),('8f5eb41d-fb05-48b7-9e2f-40b034918236','T01220301'); insert into sys_role_sys_menu_shortcut values('0a683b13-0b3b-43a3-9e66-3d45fc045cb5','T0112'),('0a683b13-0b3b-43a3-9e66-3d45fc045cb5','T0114'),('0a683b13-0b3b-43a3-9e66-3d45fc045cb5','T013007'), ('0a683b13-0b3b-43a3-9e66-3d45fc045cb5','T013004'),('0a683b13-0b3b-43a3-9e66-3d45fc045cb5','T01220201'),('0a683b13-0b3b-43a3-9e66-3d45fc045cb5','T01220301'); insert into sys_role_sys_menu_shortcut values('20afde90-a81a-11ed-a6c5-7085c2a9999e','T0112'),('20afde90-a81a-11ed-a6c5-7085c2a9999e','T0114'),('20afde90-a81a-11ed-a6c5-7085c2a9999e','T013007'), ('20afde90-a81a-11ed-a6c5-7085c2a9999e','T013004'),('20afde90-a81a-11ed-a6c5-7085c2a9999e','T01220201'),('20afde90-a81a-11ed-a6c5-7085c2a9999e','T01220301'); insert into sys_role_sys_menu_shortcut values('dda836b7-cf68-11ed-acb0-7085c2a9999e','T0112'),('dda836b7-cf68-11ed-acb0-7085c2a9999e','T0114'),('dda836b7-cf68-11ed-acb0-7085c2a9999e','T013007'), ('dda836b7-cf68-11ed-acb0-7085c2a9999e','T013004'),('dda836b7-cf68-11ed-acb0-7085c2a9999e','T01220201'),('dda836b7-cf68-11ed-acb0-7085c2a9999e','T01220301'); insert into sys_role_sys_menu_shortcut values('8e814c6d-b40b-11ed-be3c-7085c2a9999e','S0111'),('8e814c6d-b40b-11ed-be3c-7085c2a9999e','S01220101'),('8e814c6d-b40b-11ed-be3c-7085c2a9999e','S01220201'), ('8e814c6d-b40b-11ed-be3c-7085c2a9999e','S010901'),('8e814c6d-b40b-11ed-be3c-7085c2a9999e','S010701'),('8e814c6d-b40b-11ed-be3c-7085c2a9999e','S010801'); insert into sys_role_sys_menu_shortcut values('db894e5f-258f-4f62-b91b-4b4772ac5233','E0103'),('db894e5f-258f-4f62-b91b-4b4772ac5233','E010401'),('db894e5f-258f-4f62-b91b-4b4772ac5233','E010402'); INSERT INTO sys_function_code (`FunctionCode`, `FunctionName`, `ParentFunctionCode`, `OrderNo`) VALUES ('E0105', '签到信息', 'E01', 5), ('E0106', '请假信息', 'E01', 6); INSERT INTO sys_menu (`MenuNo`, `OrderNo`, `MenuName`, `Icon`, `ViewPath`, `Url`, `ParentMenuNo`, `Description`, `IsTopMenu`, `IsVisible`, `IsLeaf`, `FunctionCode`, `RecordStatus`, `ShortcutIcon`) VALUES ('E0105', 5, '签到信息', 'EditOutlined', 'views/attendance/enterpriseindex', '/attendance/enterpriseindex', 'E01', '', 0, 1, 1, 'E0105', 1, '签到信息.png'), ('E0106', 6, '请假信息', 'SolutionOutlined', 'views/attendance/timeoff/enterpriseindex', '/attendance/timeoff/enterpriseindex', 'E01', '', 0, 1, 1, 'E0106', 1, '请假信息.png'); INSERT INTO sys_menu (`MenuNo`, `OrderNo`, `MenuName`, `Icon`, `ViewPath`, `Url`, `ParentMenuNo`, `Description`, `IsTopMenu`, `IsVisible`, `IsLeaf`, `FunctionCode`, `RecordStatus`, `ShortcutIcon`) VALUES ('E010601', 0, '请假详细', '', 'views/attendance/timeoff/enterprisedetail', '/attendance/timeoff/detail', 'E01', NULL, 0, 0, 1, null, 1, NULL); ---2023-4-17 数据范围 update sys_menu set FunctionCode='T0118' where MenuNo='T011801'; update sys_menu set FunctionCode='T0126' where MenuNo='T012601'; update sys_menu set FunctionCode='T013001' where MenuNo='T013001'; update sys_menu set FunctionCode='T013004' where MenuNo='T013004'; update sys_menu set FunctionCode='T013007' where MenuNo='T013007'; update sys_menu set FunctionCode='T0132' where MenuNo='T013201'; update sys_menu set functioncode='S0107' where menuno='S010701'; update sys_menu set functioncode='S0108' where menuno='S010801'; update sys_menu set functioncode='S0109' where menuno='S010901'; -- 以上sql测试服已执行----------------------------------------------------------------------------------------------------------------- --- 2023.04.17 删除无效的数据范围 delete from sys_dictionary_item where DictionaryCode='DataRange' and Value>1; ---2023.4.18 alter table pm_practice_self_contact add PositionID varchar(50); ---2023.04.19 alter table pm_practice_task_student add arrangeType int; ---2023.04.19 补充测试表字段 alter table cf_classroom add column Practice text -- 以上sql测试服已执行----------------------------------------------------------------------------------------------------------------- ---2023.04.28 INSERT INTO `sys_menu` (`MenuNo`, `OrderNo`, `MenuName`, `Icon`, `ViewPath`, `Url`, `ParentMenuNo`, `Description`, `IsTopMenu`, `IsVisible`, `IsLeaf`, `FunctionCode`, `RecordStatus`, `ShortcutIcon`) VALUES ('T01020102', 2, '新增院系信息', NULL, 'views/schoolinformation/college/edit', '/add', 'T010201', NULL, 0, 0, 1, NULL, 1, NULL), ('T01020103', 3, '编辑院系信息', NULL, 'views/schoolinformation/college/edit', '/edit', 'T010201', NULL, 0, 0, 1, NULL, 1, NULL), ('T0102020102', 2, '新增院系专业', NULL, 'views/schoolinformation/professionclass/major/edit', '/add', 'T01020201', NULL, 0, 0, 1, NULL, 1, NULL), ('T0102020103', 3, '编辑院系专业', NULL, 'views/schoolinformation/professionclass/major/edit', '/edit', 'T01020201', NULL, 0, 0, 1, NULL, 1, NULL), ('T01020502', 2, '新增学年学期', '', 'views/schoolinformation/schoolyear/edit', '/add', 'T010205', NULL, 0, 0, 1, NULL, 1, NULL), ('T01020503', 3, '编辑学年学期', '', 'views/schoolinformation/schoolyear/edit', '/edit', 'T010205', NULL, 0, 0, 1, NULL, 1, NULL); update sys_menu set FunctionCode='T01020201' where ParentMenuNo = 'T01020201'; update sys_menu set FunctionCode='T010201' where ParentMenuNo = 'T010201'; update sys_menu set FunctionCode='T010205' where ParentMenuNo = 'T010205'; -- 以上sql测试服已执行----------------------------------------------------------------------------------------------------------------- ---2023.4.20 INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('156441901', '156441901', '东城街道', '156441900'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('156441902', '156441902', '南城街道', '156441900'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('156441903', '156441903', '万江街道', '156441900'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('156441904', '156441904', '莞城街道', '156441900'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('156441905', '156441905', '石碣镇', '156441900'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('156441906', '156441906', '石龙镇', '156441900'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('156441907', '156441907', '茶山镇', '156441900'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('156441908', '156441908', '石排镇', '156441900'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('156441909', '156441909', '企石镇', '156441900'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('156441910', '156441910', '横沥镇', '156441900'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('156441911', '156441911', '桥头镇', '156441900'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('156441912', '156441912', '谢岗镇', '156441900'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('156441913', '156441913', '东坑镇', '156441900'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('156441914', '156441914', '常平镇', '156441900'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('156441915', '156441915', '察步镇', '156441900'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('156441916', '156441916', '樟木头镇', '156441900'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('156441917', '156441917', '大朗镇', '156441900'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('156441918', '156441918', '黄江镇', '156441900'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('156441919', '156441919', '清溪镇', '156441900'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('156441920', '156441920', '塘厦镇', '156441900'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('156441921', '156441921', '凤岗镇', '156441900'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('156441922', '156441922', '大岭山镇', '156441900'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('156441923', '156441923', '长安镇', '156441900'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('156441924', '156441924', '虎门镇', '156441900'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('156441925', '156441925', '厚街镇', '156441900'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('156441926', '156441926', '沙田镇', '156441900'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('156441927', '156441927', '道溶镇', '156441900'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('156441928', '156441928', '洪梅镇', '156441900'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('156441929', '156441929', '麻涌镇', '156441900'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('156441930', '156441930', '望牛墩镇', '156441900'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('156441931', '156441931', '中堂镇', '156441900'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('156441932', '156441932', '高步镇', '156441900'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('442000001', '442000001', '石岐街道', '156442000'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('442000002', '442000002', '东区街道', '156442000'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('442000003', '442000003', '西区街道', '156442000'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('442000004', '442000004', '南区街道', '156442000'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('442000005', '442000005', '五桂山街道', '156442000'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('442000006', '442000006', '中山港街道', '156442000'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('442000007', '442000007', '黄圃镇', '156442000'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('442000008', '442000008', '南头镇', '156442000'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('442000101', '442000101', '东凤镇', '156442000'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('442000103', '442000103', '阜沙镇', '156442000'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('442000105', '442000105', '小榄镇', '156442000'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('442000106', '442000106', '东升镇', '156442000'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('442000107', '442000107', '古镇镇', '156442000'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('442000108', '442000108', '横栏镇', '156442000'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('442000109', '442000109', '三角镇', '156442000'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('442000110', '442000110', '民众镇', '156442000'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('442000111', '442000111', '南朗镇', '156442000'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('442000112', '442000112', '港口镇', '156442000'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('442000114', '442000114', '大涌镇', '156442000'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('442000115', '442000115', '沙溪镇', '156442000'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('442000116', '442000116', '三乡镇', '156442000'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('442000117', '442000117', '板芙镇', '156442000'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('442000118', '442000118', '神湾镇', '156442000'); INSERT INTO sys_area (AreaID, Code, Name, ParentAreaID) VALUES ('442000119', '442000119', '坦洲镇', '156442000'); ---2023.4.26 INSERT INTO sys_function_code values ('T019902','通知公告','T0199',105); INSERT INTO sys_menu (`MenuNo`, `OrderNo`, `MenuName`, `Icon`, `ViewPath`, `Url`, `ParentMenuNo`, `Description`, `IsTopMenu`, `IsVisible`, `IsLeaf`, `FunctionCode`, `RecordStatus`, `ShortcutIcon`) VALUES ('T019902', 102, '通知公告', '', 'views/announcement', '/announcement', 'T0199', NULL, 0, 1, 1, 'T019902', 1, NULL); insert into sys_dictionary values('AnnouncementStatus','公告通知状态',30,1); insert into sys_dictionary_item values(uuid(),'','AnnouncementStatus',1,'正常',1,1,0); insert into sys_dictionary_item values(uuid(),'','AnnouncementStatus',2,'置顶',2,1,0); insert into sys_dictionary_item values(uuid(),'','AnnouncementStatus',3,'删除',3,1,0); --2023/6/12 学校信息教师信息，年级专业，班级信息，学生信息新增编辑脚本 INSERT INTO `practicedb`.`sys_menu` (`MenuNo`, `OrderNo`, `MenuName`, `Icon`, `ViewPath`, `Url`, `ParentMenuNo`, `Description`, `IsTopMenu`, `IsVisible`, `IsLeaf`, `FunctionCode`, `RecordStatus`, `ShortcutIcon`) VALUES ('T01020302', 2, '新增教师信息', '', 'views/schoolinformation/teacher/edit', '/add', 'T010203', NULL, 0, 0, 1, 'T010203', 1, NULL); INSERT INTO `practicedb`.`sys_menu` (`MenuNo`, `OrderNo`, `MenuName`, `Icon`, `ViewPath`, `Url`, `ParentMenuNo`, `Description`, `IsTopMenu`, `IsVisible`, `IsLeaf`, `FunctionCode`, `RecordStatus`, `ShortcutIcon`) VALUES ('T01020303', 3, '编辑教师信息', '', 'views/schoolinformation/teacher/edit', '/edit', 'T010203', NULL, 0, 0, 1, 'T010203', 1, NULL); INSERT INTO `practicedb`.`sys_menu` (`MenuNo`, `OrderNo`, `MenuName`, `Icon`, `ViewPath`, `Url`, `ParentMenuNo`, `Description`, `IsTopMenu`, `IsVisible`, `IsLeaf`, `FunctionCode`, `RecordStatus`, `ShortcutIcon`) VALUES ('T0102020202', 2, '新增年级专业', '', 'views/schoolinformation/professionclass/majorgrade/edit', '/add', 'T01020202', NULL, 0, 0, 1, 'T01020202', 1, NULL); INSERT INTO `practicedb`.`sys_menu` (`MenuNo`, `OrderNo`, `MenuName`, `Icon`, `ViewPath`, `Url`, `ParentMenuNo`, `Description`, `IsTopMenu`, `IsVisible`, `IsLeaf`, `FunctionCode`, `RecordStatus`, `ShortcutIcon`) VALUES ('T0102020203', 3, '编辑年级专业', '', 'views/schoolinformation/professionclass/majorgrade/edit', '/edit', 'T01020202', NULL, 0, 0, 1, 'T01020202', 1, NULL); INSERT INTO `practicedb`.`sys_menu` (`MenuNo`, `OrderNo`, `MenuName`, `Icon`, `ViewPath`, `Url`, `ParentMenuNo`, `Description`, `IsTopMenu`, `IsVisible`, `IsLeaf`, `FunctionCode`, `RecordStatus`, `ShortcutIcon`) VALUES ('T0102020302', 2, '新增班级信息', '', 'views/schoolinformation/professionclass/majorclass/edit', '/add', 'T01020203', NULL, 0, 0, 1, 'T01020203', 1, NULL); INSERT INTO `practicedb`.`sys_menu` (`MenuNo`, `OrderNo`, `MenuName`, `Icon`, `ViewPath`, `Url`, `ParentMenuNo`, `Description`, `IsTopMenu`, `IsVisible`, `IsLeaf`, `FunctionCode`, `RecordStatus`, `ShortcutIcon`) VALUES ('T0102020303', 3, '编辑班级信息', '', 'views/schoolinformation/professionclass/majorclass/edit', '/edit', 'T01020203', NULL, 0, 0, 1, 'T01020203', 1, NULL); INSERT INTO `practicedb`.`sys_menu` (`MenuNo`, `OrderNo`, `MenuName`, `Icon`, `ViewPath`, `Url`, `ParentMenuNo`, `Description`, `IsTopMenu`, `IsVisible`, `IsLeaf`, `FunctionCode`, `RecordStatus`, `ShortcutIcon`) VALUES ('T01020402', 2, '新增学生信息', '', 'views/schoolinformation/student/edit', '/add', 'T010204', NULL, 0, 0, 1, 'T010204', 1, NULL); INSERT INTO `practicedb`.`sys_menu` (`MenuNo`, `OrderNo`, `MenuName`, `Icon`, `ViewPath`, `Url`, `ParentMenuNo`, `Description`, `IsTopMenu`, `IsVisible`, `IsLeaf`, `FunctionCode`, `RecordStatus`, `ShortcutIcon`) VALUES ('T01020403', 3, '编辑学生信息', '', 'views/schoolinformation/student/edit', '/edit', 'T010204', NULL, 0, 0, 1, 'T010204', 1, NULL); --2023/6/21 待办退回地址,68测试已经执行过了 alter table sys_task add ReturnUrl varchar(1024) go update sys_menu set viewPath='selfcontactdetail' where menuno='S010203' update sys_menu set viewPath='selfcontactstudetail' where menuno='T012602' go --2023/6/29 日报表增加字段为“任务标题“ alter table pr_daily_report add tasktitle varchar(50) --- 2023.6.29 insert into sys_function_code values('E0107','学校实习计划','E01',7); insert into sys_menu values ('E0107','7','学校实习计划','OrderedListOutlined','','/plan/school','E01','','0','1','1','E0107',1,null), ('E010701','1','学校实习计划','','views/practice/plan/school/practicebase-index','/practicebase-list','E0107','','0','0','1','E0107',1,null), ('E010702','2','查看学校实习计划','','views/practice/plan/school/practicebase-detail','/practicebase-detail','E0107','','0','0','1','E0107',1,null); --- 2023.6.30 alter table pm_practice_student_intention add IntentionCityID varchar(50); alter table pm_practice_student_intention add constraint FK_Reference_1001 foreign key (IntentionCityID) references sys_area (AreaID) on delete restrict on update restrict; alter table sys_area add orderNo int; update sys_area set orderNo=1 where areaID='156445300'; update sys_area set orderNo=2 where ParentAreaID='156440000' and areaID<>'156445300'; --- 2023.07.04 按钮权限 insert into sys_function_code values ('T01080100','查看','T010801','0'), ('T01080101','新增','T010801','1'), ('T01080102','修改','T010801','2'), ('T01080103','删除','T010801','3'), ('T01080200','查看','T010802','0'), ('T01080201','新增','T010802','1'), ('T01080202','修改','T010802','2'), ('T01080203','删除','T010802','3'), ('T011200','查看','T0112','0'), ('T011201','生成实习任务','T0112','1'), ('T011202','指派管理人员','T0112','2'), ('T011203','指派单位岗位','T0112','3'), ('T011204','删除任务','T0112','4'), ('T011400','查看','T0114','0'), ('T011401','指派单位岗位','T0114','1'); ---2023.7.4 日报改成日常作业 update sys_menu set MenuName='日常作业' where MenuName='日报'; update sys_menu set MenuName='日常作业列表' where MenuName='日报列表'; update sys_menu set MenuName='查看日常作业' where MenuName='查看日报'; alter table pr_daily_report add TaskTitle varchar(200); insert into sys_function_code values ('T01380100','查看','T013801',0), ('T01380101','导入成绩','T013801',1), ('T01380102','录入成绩','T013801',2), ('T01380200','查看','T013802',0), ('T01380201','录入成绩','T013802',1); update sys_function_code set FunctionName=replace(FunctionName,'日报','日常作业') where FunctionName like '%日报%'; update sys_function_code set FunctionName='实习基地管理' where FunctionCode='T010403'; insert into sys_function_code values ('T01040300','查看','T010403',0), ('T01040301','新增','T010403',1), ('T01040302','导入','T010403',2), ('T01040303','编辑','T010403',3), ('T01040304','删除','T010403',4); insert into sys_function_code values ('T01040100','查看','T010401',0), ('T01040101','新增','T010401',1), ('T01040102','导入','T010401',2), ('T01040103','编辑','T010401',3), ('T01040104','删除','T010401',4); insert into sys_function_code values ('T010600','查看','T0106',0), ('T010601','新增','T0106',1), ('T010602','导入','T0106',2), ('T010603','编辑','T0106',3), ('T010604','删除','T0106',4); insert into sys_function_code values ('T01160100','查看','T011601',0), ('T01160101','审核','T011601',1); insert into sys_function_code values ('T011800','查看','T0118',0), ('T011801','审核','T0118',1); insert into sys_function_code values ('T012000','查看','T0120',0), ('T012001','新增','T0120',1), ('T012002','导入','T0120',2), ('T012003','编辑','T0120',3), ('T012004','删除','T0120',4), ('T012005','通知补实习','T0120',5); insert into sys_function_code values ('T012600','查看','T0126',0), ('T012601','审核','T0126',1); insert into sys_function_code values ('T01300100','查看','T013001',0), ('T01300101','编辑','T013001',1), ('T01300102','删除','T013001',2); insert into sys_function_code values ('T01300400','查看','T013004',0), ('T01300401','审核','T013004',1); insert into sys_function_code values ('T01300700','查看','T013007',0), ('T01300701','审核','T013007',1); insert into sys_function_code values ('T0122020100','查看','T01220201',0), ('T0122020101','评阅','T01220201',1); insert into sys_function_code values ('T0122030100','查看','T01220301',0), ('T0122030101','评阅','T01220301',1); insert into sys_function_code values ('T0122040100','查看','T01220401',0), ('T0122040101','评阅','T01220401',1); insert into sys_function_code values ('T01360100','查看','T013601',0), ('T01360101','新增','T013601',1), ('T01360102','修改','T013601',2), ('T01360103','删除','T013601',3); insert into sys_function_code values ('T0136030100','查看','T01360301',0), ('T0136030101','新增','T01360301',1), ('T0136030102','修改','T01360301',2), ('T0136030103','删除','T01360301',3); insert into sys_function_code values ('T0199010100','查看','T01990101',0), ('T0199010101','新增','T01990101',1), ('T0199010102','启用','T01990101',2), ('T0199010103','禁用','T01990101',3), ('T0199010104','修改密码','T01990101',4); insert into sys_function_code values ('T0199010200','查看','T01990102',0), ('T0199010201','新增','T01990102',1), ('T0199010202','编辑','T01990102',2), ('T0199010203','删除','T01990102',3); insert into sys_function_code values ('S010200','查看','S0102',0), ('S010201','新增','S0102',1), ('S010202','编辑','S0102',2), ('S010203','删除','S0102',3); insert into sys_function_code values ('S010400','查看','S0104',0), ('S010401','发起申请','S0104',1), ('S010402','编辑','S0104',2), ('S010403','删除','S0104',3); insert into sys_function_code values ('S010500','查看','S0105',0), ('S010501','新增','S0105',1), ('S010502','编辑','S0105',2), ('S010503','删除','S0105',3); insert into sys_function_code values ('S010700','查看','S0107',0), ('S010701','新增','S0107',1), ('S010702','编辑','S0107',2), ('S010703','删除','S0107',3); insert into sys_function_code values ('S010800','查看','S0108',0), ('S010801','新增','S0108',1), ('S010802','编辑','S0108',2), ('S010803','删除','S0108',3); insert into sys_function_code values ('S010900','查看','S0109',0), ('S010901','新增','S0109',1), ('S010902','编辑','S0109',2), ('S010903','删除','S0109',3); insert into sys_function_code values ('S01220105','删除','S012201',5); insert into sys_function_code values ('S01220206','删除','S012202',5); insert into sys_function_code values ('S01220306','删除','S012203',6); insert into sys_function_code values ('S01220406','删除','S012204',6); --2023-7-7 考勤情况统计报表 INSERT INTO sys_function_code (`FunctionCode`, `FunctionName`, `ParentFunctionCode`, `OrderNo`) VALUES ('T013008', '考勤情况统计报表', 'T0130', 8); INSERT INTO sys_menu (`MenuNo`, `OrderNo`, `MenuName`, `Icon`, `ViewPath`, `Url`, `ParentMenuNo`, `Description`, `IsTopMenu`, `IsVisible`, `IsLeaf`, `FunctionCode`, `RecordStatus`, `ShortcutIcon`) VALUES ('T013008', 8, '考勤情况统计报表', '', 'views/attendanceReport', '/attendance/attendanceReport', 'T0130', '', 0, 1, 1, 'T013008', 1, ''); --2023-7-10学校信息管理模块增加按钮权限 insert into sys_function_code values ('T01020100','查看','T010201',0), ('T01020101','新增','T010201',1), ('T01020102','编辑','T010201',2), ('T01020103','删除','T010201',3); insert into sys_function_code values ('T0102020100','查看','T01020201',0), ('T0102020101','新增','T01020201',1), ('T0102020102','编辑','T01020201',2), ('T0102020103','删除','T01020201',3); insert into sys_function_code values ('T0102020200','查看','T01020202',0), ('T0102020201','新增','T01020202',1), ('T0102020202','编辑','T01020202',2), ('T0102020203','删除','T01020202',3), ('T0102020204','同步','T01020202',4), ('T0102020205','导入','T01020202',5); insert into sys_function_code values ('T0102020300','查看','T01020203',0), ('T0102020301','新增','T01020203',1), ('T0102020302','编辑','T01020203',2), ('T0102020303','删除','T01020203',3), ('T0102020304','同步','T01020203',4), ('T0102020305','导入','T01020203',5); insert into sys_function_code values ('T01020300','查看','T010203',0), ('T01020301','新增','T010203',1), ('T01020302','编辑','T010203',2), ('T01020303','删除','T010203',3), ('T01020304','同步','T010203',4), ('T01020305','导入','T010203',5); insert into sys_function_code values ('T01020400','查看','T010204',0), ('T01020401','新增','T010204',1), ('T01020402','编辑','T010204',2), ('T01020403','删除','T010204',3), ('T01020404','同步','T010204',4), ('T01020405','导入','T010204',5); insert into sys_function_code values ('T01020500','查看','T010205',0), ('T01020501','新增','T010205',1), ('T01020502','编辑','T010205',2), ('T01020503','删除','T010205',3); ---2023-7-13 学生端实习手册 insert into sys_function_code values('S0125','实习手册','S01',15); insert into sys_menu values('S0125',15,'实习手册','FolderOpenOutlined','views/databank/practicenote/studentlist','/practicenote/studentlist','T01','',0,1,0,'S0125',1,null); --- 2023.08.02 create table Sys_Log ( LogID varchar(50) not null, PageName varchar(500), PageUrl varchar(500), ActionName varchar(500), UserID varchar(50), LogTime datetime, primary key (LogID) ); alter table Sys_Log add constraint FK_Reference_124 foreign key (UserID) references sys_user (UserID) on delete restrict on update restrict; insert into sys_function_code values('T019903','日志管理','T0199','106'); insert into sys_menu values('T019903','103','日志管理','','views/log','/log','T0199',null,0,1,1,'T019903',1,null); --- 2023.08.18 alter table ch_check add CheckDepartmentName varchar(300); --- 2023.09.07 ---新增表结构pb_ledgerRecord【问题台账登记表】 drop table if exists pb_ledgerRecord; /*==============================================================*/ /* Table: pb_ledgerRecord */ /*==============================================================*/ create table pb_ledgerRecord ( ProblemLedgerRecordID varchar(50) not null, SchoolYearID varchar(50), CollegeID varchar(50), FeedbackDate datetime, ProblemCharacteristics int comment '关联字典', ProblemDesc text, ResolvePlan text, IsResolve int, ResolveDate datetime, RecordStatus int, CreateBy varchar(50), CreateTime datetime, UpdateBy varchar(50), UpdateTime datetime, primary key (ProblemLedgerRecordID) ); alter table pb_ledgerRecord add constraint FK_Reference_116 foreign key (SchoolYearID) references cf_schoolyear (SchoolYearID) on delete restrict on update restrict; alter table pb_ledgerRecord add constraint FK_Reference_117 foreign key (CollegeID) references cf_college (CollegeID) on delete restrict on update restrict; ---插入菜单、按钮功能码数据 insert into sys_function_code values('T0140','问题台账登记','T01',20) insert into sys_menu values('T0140',20,'问题台账登记','FilePptOutlined','views/problem/index','/index','T01',null,0,1,1,'T0140',1,null) insert sys_function_code VALUES('T014000','查看','T0140',1) insert sys_function_code VALUES('T014001','新增','T0140',2) insert sys_function_code VALUES('T014002','编辑','T0140',3) insert sys_function_code VALUES('T014003','删除','T0140',4) ---插入字典【问题特性】 insert sys_dictionary values('Characteristics','问题特性',25,1); insert sys_dictionary_item values('24870d11-ad0d-175e-a6c5-7085c84ej79e','','Characteristics',1,'共性',1,1,0); insert sys_dictionary_item values('24870d11-84id-15rt-iuj5-784oj467j78h','','Characteristics',2,'个性',2,1,0); ---2024-5-30日 购物车mysql脚本 create table cf_apply_form ( applyId varchar(50) not null, applyUserId varchar(50), applyUserName varchar(50), status int comment '1、审核中2、审核通过3、驳回', applyDate datetime comment '申请时间', reason varchar(300) comment '申请原因', primary key (applyId) ); create table cf_apply_form_reviewer ( reviewerId varchar(50) not null, applyId varchar(50), reviewerUserId varchar(50), reviewerUserName varchar(50), reviewerAction int, comments varchar(300), reviewerDate datetime, primary key (reviewerId) ); alter table cf_apply_form_reviewer add constraint FK_Reference_34 foreign key (applyId) references cf_apply_form (applyId) on delete restrict on update restrict; create table cf_apply_form_well_file ( wellFileId varchar(50) not null, applyId varchar(50) comment '关联申请单', well_common_name varchar(200) comment '井', file_name varchar(200) comment '文件名称', primary key (wellFileId) ); alter table cf_apply_form_well_file add constraint FK_Reference_35 foreign key (applyId) references cf_apply_form (applyId) on delete restrict on update restrict; INSERT INTO sys_function_code (FunctionCode, FunctionName, ParentFunctionCode, OrderNo) VALUES ('T0111', '我的审批', 'T01', 9); INSERT INTO sys_menu (MenuNo, OrderNo, MenuName, Icon, ViewPath, Url, ParentMenuNo, Description, IsTopMenu, IsVisible, IsLeaf, FunctionCode, RecordStatus, ShortcutIcon) VALUES ('T0111', 4, '我的审批', 'MailOutlined', 'views/reviewer', '/reviewer', 'T01', null, 0, 1, 1, 'T0111', 1, null); INSERT INTO sys_menu (MenuNo, OrderNo, MenuName, Icon, ViewPath, Url, ParentMenuNo, Description, IsTopMenu, IsVisible, IsLeaf, FunctionCode, RecordStatus, ShortcutIcon) VALUES ('T011101', 1, '我的审批', '', 'views/reviewerList', '/reviewer/list', 'T0111', null, 0, 0, 1, 'T0111', 1, null); INSERT INTO sys_function_code (FunctionCode, FunctionName, ParentFunctionCode, OrderNo) VALUES ('T0110', '我的申请', 'T01', 9); INSERT INTO sys_menu (MenuNo, OrderNo, MenuName, Icon, ViewPath, Url, ParentMenuNo, Description, IsTopMenu, IsVisible, IsLeaf, FunctionCode, RecordStatus, ShortcutIcon) VALUES ('T0110', 4, '我的申请', 'FileDoneOutlined', 'views/apply', '/apply', 'T01', null, 0, 1, 1, 'T0110', 1, null); INSERT INTO sys_menu (MenuNo, OrderNo, MenuName, Icon, ViewPath, Url, ParentMenuNo, Description, IsTopMenu, IsVisible, IsLeaf, FunctionCode, RecordStatus, ShortcutIcon) VALUES ('T011001', 1, '我的申请', '', 'views/applyList', '/apply/list', 'T0110', null, 0, 0, 1, 'T0110', 1, null); UPDATE sys_menu SET OrderNo=6 WHERE MenuNo='T0108'; UPDATE sys_menu SET OrderNo=5 WHERE MenuNo='T0109'; insert into sys_dictionary value('applyFormStatus','申请单状态',1,1); insert into sys_dictionary_item values (uuid(),'','applyFormStatus',1,'审核中',1,1,1); insert into sys_dictionary_item values (uuid(),'','applyFormStatus',2,'通过',2,1,1); insert into sys_dictionary_item values (uuid(),'','applyFormStatus',3,'驳回',3,1,1);