fjnx
/
soc


			
							1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677
							UPDATE sys_dict_data set dict_label='停用' WHERE (dict_type='plan_status' and dict_value=1 ) or (dict_type='sys_user_is_lock' and dict_value=1 );

DELETE FROM `sys_dict_type` WHERE dict_type='rule_status';
DELETE FROM `sys_dict_data` WHERE dict_type='rule_status';
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (20231113157, '手册状态', 'rule_status', '0', 'jwx', '2023-11-27 14:55:51', '', NULL, NULL);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (20231114641, 0, '启用', '0', 'rule_status', NULL, 'default', 'N', '0', 'jwx', '2023-11-27 14:56:36', '', NULL, NULL);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (20231114643, 1, '停用', '1', 'rule_status', NULL, 'default', 'N', '0', 'jwx', '2023-11-27 14:56:44', '', NULL, NULL);

-- 修改教育培训任务状态字典描述
update sys_dict_data set dict_label='待登记' where dict_type='edu_training_do_status' and dict_label='待培训' and dict_value=0 LIMIT 1;
update sys_dict_data set dict_label='登记中' where dict_type='edu_training_do_status' and dict_label='待提交' and dict_value=4 LIMIT 1;
-- 履职状态描述变更
update sys_dict_data set dict_label='履职中' where dict_type='resumption_status' and dict_label='进行中' and dict_value=2 LIMIT 1;

delete from sys_menu where id in (1729308502301728769);
INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark)
VALUES (1729308502301728769, '导出全省农信系统物防建设达标情况', 103, 5, '', null, null, 1, 0, 'F', '0', '0', 'system:dept:exportConstruction', '1', null, null, null, now(), '', null, '');
delete from sys_role_menu where menu_id=1729308502301728769;
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (115, 1729308502301728769);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (116, 1729308502301728769);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (117, 1729308502301728769);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (118, 1729308502301728769);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (119, 1729308502301728769);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (120, 1729308502301728769);
delete  from `sys_menu` where  id=01729407886809481218;
INSERT INTO `sys_menu`(`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (01729407886809481218, '导出', 2318, 8, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:safetycheck:export', '1', NULL, NULL, '省联社账号', '2023-11-28 15:52:54', '', NULL, '');

-- web培训统计报表菜单及权限
delete from sys_menu where id = 1730059329344102401;
INSERT INTO `sys_menu`(`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (01730059329344102401, '培训统计排行', 1719287834364436482, 700, 'core/reportForms/eduTraining', 'core/reportForms/eduTraining', NULL, 1, 0, 'C', '0', '0', NULL, '1', 'chart', NULL, NULL, NOW(),NULL , NOW(), NULL);
delete from sys_role_menu where menu_id=1730059329344102401;
insert into sys_role_menu select  id,1730059329344102401 from sys_role where org_type in (1,2,3);

-- web演练统计报表菜单及权限
delete from sys_menu where id = 01730111975367106562;
INSERT INTO `sys_menu`(`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (01730111975367106562, '演练统计排行', 1719287834364436482, 701, 'core/reportForms/drill', 'core/reportForms/drill', NULL, 1, 0, 'C', '0', '0', NULL, '1', 'chart', NULL, NULL, NOW(),NULL , NOW(), NULL);
delete from sys_role_menu where menu_id=01730111975367106562;
insert into sys_role_menu select  id,01730111975367106562 from sys_role where org_type in (1,2,3);


update sys_menu set menu_name='履职手册' WHERE menu_name='履职内容库' and platform_type=1 and menu_type='C' ;
update sys_menu set menu_name='检查手册' WHERE menu_name='检查内容库' and platform_type=1 and menu_type='C' ;
update sys_menu set menu_name='检查手册' WHERE menu_name='检查内容库' and platform_type=1 and menu_type='C' ;

-- 文书档案文件表
CREATE TABLE if not exists `core_safety_book_book_files` (
                                               `id` bigint NOT NULL,
                                               `book_user_id` bigint DEFAULT NULL,
                                               `name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
                                               `url` varchar(2000) COLLATE utf8mb4_general_ci DEFAULT NULL,
                                               `create_by` bigint DEFAULT NULL COMMENT '创建人id',
                                               `create_time` datetime(6) DEFAULT NULL COMMENT '创建时间',
                                               `update_by` bigint DEFAULT NULL COMMENT '修改人id',
                                               `update_time` datetime(6) DEFAULT NULL COMMENT '更新时间',
                                               PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- 修改菜单排序
UPDATE `sys_menu` SET `order_num` = 2 WHERE `menu_name` = '驾驶舱';
UPDATE `sys_menu` SET `order_num` = 4 WHERE `menu_name` = '日常履职';
UPDATE `sys_menu` SET `order_num` = 6 WHERE `menu_name` = '监控调阅';
UPDATE `sys_menu` SET `order_num` = 8 WHERE `menu_name` = '教育培训';
UPDATE `sys_menu` SET `order_num` = 10 WHERE `menu_name` = '预案演练';
UPDATE `sys_menu` SET `order_num` = 12 WHERE `menu_name` = '安全检查';
UPDATE `sys_menu` SET `order_num` = 14 WHERE `menu_name` = '隐患管理';
UPDATE `sys_menu` SET `order_num` = 16 WHERE `menu_name` = '来访管理';
UPDATE `sys_menu` SET `order_num` = 18 WHERE `menu_name` = '综合考核';
UPDATE `sys_menu` SET `order_num` = 20 WHERE `menu_name` = '基础信息';
UPDATE `sys_menu` SET `order_num` = 22 WHERE `menu_name` = '统计报表';
UPDATE `sys_menu` SET `order_num` = 24 WHERE `menu_name` = '信息中心';
UPDATE `sys_menu` SET `menu_name` = '档案管理' WHERE `menu_name` = '文书档案';
UPDATE `sys_menu` SET `order_num` = 26 WHERE `menu_name` = '档案管理';
UPDATE `sys_menu` SET `order_num` = 28 WHERE `menu_name` = '系统管理';
UPDATE `sys_menu` SET `menu_name` = '系统运维' WHERE `menu_name` = '系统监控';
UPDATE `sys_menu` SET `order_num` = 30 WHERE `menu_name` = '系统运维';
UPDATE `sys_menu` SET `order_num` = 999 WHERE `menu_name` = '登记簿批量导出' limit 1;