smartsearch/doc/已更新脚本.txt

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);