soc/project_data/sql/0.0.5/soc/soc.sql

DELIMITER ??
DROP PROCEDURE IF
        EXISTS schema_change ?? CREATE PROCEDURE schema_change () BEGIN
    IF
    NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema = DATABASE () AND TABLE_NAME = 'sys_org' AND COLUMN_NAME = 'breviary' ) THEN
ALTER TABLE `sys_org` ADD COLUMN `breviary` VARCHAR ( 255 ) NULL COMMENT '机构缩略词';

END IF;

	IF
        NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema = DATABASE () AND TABLE_NAME = 'core_safety_task' AND COLUMN_NAME = 'solid_id' ) THEN
        ALTER TABLE  `core_safety_task`
					ADD COLUMN `solid_id` bigint NULL COMMENT '固定的id,用于识别多个副本是否属于同一个计划' AFTER `plan_id`;
    END IF;
	IF
       NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema = DATABASE () AND TABLE_NAME = 'core_safecheck_plan' AND COLUMN_NAME = 'publish_time' ) THEN
        	ALTER TABLE `core_safecheck_plan`
				MODIFY COLUMN `parent_id` bigint NULL DEFAULT -1 COMMENT '下发父计划id' AFTER `id`,
				ADD COLUMN `solid_id` bigint NULL COMMENT '固定的id,用于识别多个副本是否属于同一个计划' AFTER `parent_id`,
				ADD COLUMN `parent_solid_id` bigint NULL COMMENT '固定的parentid,用于识别多个副本是否属于同一个计划' AFTER `solid_id`,
				ADD COLUMN `task_has_completed` int DEFAULT NULL COMMENT '1：表示有已完成的任务',
				ADD COLUMN `publish_time` datetime NULL COMMENT '最后一次下发时间' AFTER `task_has_completed`,
				ADD COLUMN `withdraw_time` datetime NULL COMMENT '最后一次撤回时间' AFTER `publish_time`,
				ADD COLUMN `effective_time` datetime NULL COMMENT '计划生效时间' AFTER `withdraw_time`;
				update core_safecheck_plan set publish_time =create_time WHERE publish_time is null and plan_status=1;
				update core_safecheck_plan set withdraw_time =create_time WHERE withdraw_time is null and plan_status=2;
				update core_safecheck_plan set effective_time =create_time WHERE effective_time is null and (plan_status=1 or plan_status=2);
    END IF;


--             -- 预案演练表增加字段:最后一次下发时间/最后一次撤回时间/计划生效日期
            IF NOT EXISTS(SELECT *
                              FROM information_schema.columns
                              WHERE table_schema = DATABASE()
                                AND table_name = 'core_drill_plan'
                                AND column_name = 'publish_time') THEN
                    ALTER TABLE core_drill_plan
                        ADD COLUMN `publish_time` datetime NULL COMMENT '最后一次下发时间' AFTER `parent_id`,
                        ADD COLUMN `withdraw_time` datetime NULL COMMENT '最后一次撤回时间' AFTER `publish_time`,
                        ADD COLUMN `effective_time` datetime NULL COMMENT '计划生效日期' AFTER `withdraw_time`;
                    update core_drill_plan set publish_time =update_time WHERE publish_time is null and plan_status=1;
                    update core_drill_plan set withdraw_time =update_time WHERE withdraw_time is null and plan_status=2;
                    update core_drill_plan set effective_time =update_time WHERE effective_time is null and (plan_status=1 or plan_status=2);
            END IF;
-- 
--                 -- 预案演练表增加字段:最后一次下发时间/最后一次撤回时间/计划生效日期
            IF NOT EXISTS(SELECT *
                              FROM information_schema.columns
                              WHERE table_schema = DATABASE()
                                AND table_name = 'core_edu_training_plan'
                                AND column_name = 'publish_time') THEN
                    ALTER TABLE core_edu_training_plan
                        ADD COLUMN `publish_time` datetime NULL COMMENT '最后一次下发时间' AFTER `parent_id`,
                        ADD COLUMN `withdraw_time` datetime NULL COMMENT '最后一次撤回时间' AFTER `publish_time`,
                        ADD COLUMN `effective_time` datetime NULL COMMENT '计划生效日期' AFTER `withdraw_time`;
                    update core_edu_training_plan set publish_time =update_time WHERE publish_time is null and plan_status=1;
                    update core_edu_training_plan set withdraw_time =update_time WHERE withdraw_time is null and plan_status=2;
                    update core_edu_training_plan set effective_time =update_time WHERE effective_time is null and (plan_status=1 or plan_status=2);
            END IF;


IF
        NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema = DATABASE () AND TABLE_NAME = 'core_resumption_plan' AND COLUMN_NAME = 'solid_id' ) THEN
        ALTER TABLE  `core_resumption_plan` 
			MODIFY COLUMN `parent_id` bigint NULL DEFAULT -1 COMMENT '下发父计划id' AFTER `id`,
			ADD COLUMN `solid_id` bigint NULL COMMENT '固定的id,用于识别多个副本是否属于同一个计划' AFTER `parent_id`,
			ADD COLUMN `parent_solid_id` bigint NULL COMMENT '固定的parentid,用于识别多个副本是否属于同一个计划' AFTER `solid_id`;
    END IF;
	IF
        NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema = DATABASE () AND TABLE_NAME = 'core_resumption' AND COLUMN_NAME = 'solid_id' ) THEN
        ALTER TABLE  `core_resumption` 
			ADD COLUMN `solid_id` bigint NULL COMMENT '固定的id,用于识别多个副本是否属于同一个计划' AFTER `plan_id`,
			ADD COLUMN `parent_solid_id` bigint NULL COMMENT '固定的parentid,用于识别多个副本是否属于同一个计划' AFTER `solid_id`;
    END IF;
	IF
        EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema = DATABASE () AND TABLE_NAME = 'core_resumption_plan_to_point' AND COLUMN_NAME = 'effective_date' ) THEN
        ALTER TABLE `core_resumption_plan_to_point` 
			DROP COLUMN `effective_date`;
    END IF;
	
	IF
       NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema = DATABASE () AND TABLE_NAME = 'core_resumption_plan' AND COLUMN_NAME = 'publish_time' ) THEN
        	ALTER TABLE `core_resumption_plan` 
				ADD COLUMN `publish_time` datetime NULL COMMENT '最后一次下发时间' AFTER `task_has_completed`,
				ADD COLUMN `withdraw_time` datetime NULL COMMENT '最后一次撤回时间' AFTER `publish_time`,
				ADD COLUMN `effective_time` datetime NULL COMMENT '计划生效时间' AFTER `withdraw_time`;
				update core_resumption_plan set publish_time =update_time WHERE publish_time is null and plan_status=1;
				update core_resumption_plan set withdraw_time =update_time WHERE withdraw_time is null and plan_status=2;
				update core_resumption_plan set effective_time =update_time WHERE effective_time is null and plan_status=1;
    END IF;

	
	IF
       NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema = DATABASE () AND TABLE_NAME = 'core_resumption_plan' AND COLUMN_NAME = 'start_date' ) THEN
        	ALTER TABLE `core_resumption_plan` 
				ADD COLUMN `start_date` datetime NULL COMMENT '任务开始日期' AFTER `effective_time`,
				ADD COLUMN `end_date` datetime NULL COMMENT '任务结束日期' AFTER `start_date`;
    END IF;
END ??
DELIMITER;
CALL schema_change ();

update sys_menu set component='safetycheck/plan/index' WHERE menu_name='检查任务下发' and menu_type='C' and platform_type='1';
delete from sys_menu where id=1734903034555719682;
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 (1734903034555719682, '导出安全保卫工作情况统计', 103, 8, '', null, null, 1, 0, 'F', '0', '0', 'system:dept:exportConstructionDetails', '1', null, null, null, now(), '', null, '');
delete from sys_role_menu where menu_id =1734903034555719682;
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (114, 1734903034555719682);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (115, 1734903034555719682);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (116, 1734903034555719682);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (117, 1734903034555719682);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (118, 1734903034555719682);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (119, 1734903034555719682);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (120, 1734903034555719682);
delete  from sys_role_menu where menu_id in (select id from  sys_menu where perms='core:eduTask:report' and menu_name='报表查看');
delete  from sys_menu where perms='core:eduTask:report' and menu_name='报表查看';
delete  from sys_dict_type where  dict_type='monitor_org';
INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark)
VALUES ('调阅机构类型', 'monitor_org', '0', null, now(), null, now(), null);
delete  from sys_dict_data where dict_type='monitor_org';
INSERT INTO sys_dict_data (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 (3, '行社', '3', 'monitor_org', null, 'default', 'N', '0',  null, now(), null, now(), null);
INSERT INTO sys_dict_data (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 (2, '营业网点', '4', 'monitor_org', null, 'default', 'N', '0',  null, now(), null, now(), null);
INSERT INTO sys_dict_data (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 (5, '离行式自助银行', '5', 'monitor_org', null, 'default', 'N', '0',  null, now(), null, now(), null);
INSERT INTO sys_dict_data (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 (6, '中心业务库', '6', 'monitor_org', null, 'default', 'N', '0',  null, now(), null, now(), null);
INSERT INTO sys_dict_data (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 (10, '监控中心', '10', 'monitor_org', null, 'default', 'N', '0',  null, now(), null, now(), null);
delete  from `sys_menu` where  id=01719892877586239490;
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 (01719892877586239490, '外包履职评价统计表', 1719287834364436482, 2, 'evaluateTable', 'evaluateTable/index', NULL, 1, 1, 'C', '0', '0', 'core:evaluateTask:statistics', '1', 'chart', NULL, '超级管理员', '2023-09-21 10:37:52', '超级管理员', '2023-09-22 09:42:43', '');


UPDATE sys_menu set menu_type='C',perms='appquestion:list' WHERE platform_type=0 and menu_name='隐患问题清单';
delete from sys_dict_data where dict_type='register_book_type' and dict_value='28';
INSERT INTO sys_dict_data (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 (28, '监控调阅登记簿', '28', 'register_book_type', null, 'default', 'N', '0', null, now(), null, now(), null);

DELETE from `sys_dict_type`  WHERE `dict_type`='app_question_status';
DELETE from `sys_dict_data`  WHERE `dict_type`='app_question_status';

INSERT INTO `sys_dict_type` ( `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( 'APP隐患问题状态', 'app_question_status', '0', '超级管理员', '2023-12-19 15:40:55', '', NULL, NULL);
INSERT INTO `sys_dict_data` ( `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 ( 0, '待确认', '0', 'app_question_status', NULL, 'default', 'N', '0', '超级管理员', '2023-12-19 15:42:47', '', NULL, NULL);
INSERT INTO `sys_dict_data` ( `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 ( 1, '提出异议', '1', 'app_question_status', NULL, 'default', 'N', '0', '超级管理员', '2023-12-19 15:42:59', '', NULL, NULL);
INSERT INTO `sys_dict_data` ( `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 ( 3, '已关闭', '3', 'app_question_status', NULL, 'default', 'N', '0', '超级管理员', '2023-12-19 15:43:23', '超级管理员', '2023-12-19 15:43:30', NULL);
INSERT INTO `sys_dict_data` ( `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 ( 10, '待整改', '10', 'app_question_status', NULL, 'default', 'N', '0', '超级管理员', '2023-12-19 15:43:55', '', NULL, NULL);
INSERT INTO `sys_dict_data` ( `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 ( 11, '已整改', '11', 'app_question_status', NULL, 'default', 'N', '0', '超级管理员', '2023-12-19 15:44:07', '超级管理员', '2023-12-19 15:44:31', NULL);
INSERT INTO `sys_dict_data` ( `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 ( 12, '已逾期', '12', 'app_question_status', NULL, 'default', 'N', '0', '超级管理员', '2023-12-19 15:44:18', '', NULL, NULL);

DELETE from sys_dict_data where dict_type in ('org_extend_standard');

INSERT INTO `sys_dict_data`( `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 ( 1, 'GA38-2021', '1', 'org_extend_standard', NULL, 'default', 'N', '0', '超级管理员', '2023-09-14 16:57:04', '超级管理员', '2023-10-07 15:24:27', NULL);
INSERT INTO `sys_dict_data`( `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 ( 2, 'GA38-2015', '2', 'org_extend_standard', NULL, 'default', 'N', '0', '超级管理员', '2023-09-14 16:57:10', '超级管理员', '2023-10-07 15:24:36', NULL);
INSERT INTO `sys_dict_data`( `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 ( 3, '未达标', '3', 'org_extend_standard', NULL, 'default', 'N', '0', '超级管理员', '2023-09-14 16:57:28', '超级管理员', '2023-10-07 15:24:43', NULL);
delete from sys_menu where  id in (2043);
-- 新增安全责任书签署层级字典
DELETE from sys_dict_data where dict_type='sign_level' and dict_label='其他' limit 1;
INSERT INTO  `sys_dict_data`( `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 (0, '其他', '3', 'sign_level', NULL, 'default', 'N', '0', null, NOW(), null
                                                                                                                                                                                                                , NOW(), NULL);
-- 增加演练范本详情菜单权限
set @id =  ( SELECT id FROM `sys_menu` where menu_name='演练范本详情' and perms='core:drillDictionary:query');
DELETE from sys_role_menu where menu_id=@id;
insert into sys_role_menu select DISTINCT id,@id from sys_role;
-- 仅仅给超级管理员用，标记为删除状态,通过脚本维护了一条管理员与角色的关联数据，防止首页等依赖于登录用户角色信息的页面查询报错
DELETE FROM `sys_role` WHERE `role_name`='超级管理员';
INSERT INTO `sys_role` (`org_type`, `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`) VALUES ('1', '超级管理员', 'default', 0, 1, 1, 1, '0', 2, '超级管理员', '2023-12-07 17:14:07', '', NULL, '仅仅给超级管理员用，标记为删除状态,通过脚本维护了一条管理员与角色的关联数据，防止首页等依赖于登录用户角色信息的页面查询报错');
DELETE FROM `sys_user_role` WHERE `role_id` = (SELECT id FROM `sys_role` WHERE `role_name`='超级管理员');
INSERT INTO `sys_user_role` (`user_id`, `role_id`, `create_by`, `create_time`, `update_by`, `update_time`) SELECT 1 as `user_id`, id as `role_id`, '超级管理员' as `create_by`, '2023-09-17 19:57:06' as `create_time`, NULL, NULL  FROM `sys_role` WHERE `role_name`='超级管理员';
-- 修改演练周期字典排序
update sys_dict_data set dict_sort=dict_value where dict_type='drill_plan_cycle';
-- 演练新增每周每月的计划周期
delete  from sys_dict_data where dict_type='drill_plan_cycle' and dict_value in ('2','3');
INSERT INTO `sys_dict_data`(`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 (2, '每周', '2', 'drill_plan_cycle', NULL, 'default', 'N', '0', NULL, NOW(), NULL, NOW(), NULL);
INSERT INTO `sys_dict_data`(`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 (3, '每月', '3', 'drill_plan_cycle', NULL, 'default', 'N', '0', NULL, NOW(), NULL, NOW(), NULL);

-- 整改期限增加60天、180天内，360天内
DELETE from sys_dict_data WHERE dict_type='rectification_deadline';
INSERT INTO `sys_dict_data` ( `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 ( 1, '15天内', '15', 'rectification_deadline', NULL, 'default', 'N', '0', '超级管理员', '2023-09-01 16:58:56', 'jwx', '2023-12-26 16:36:34', NULL);
INSERT INTO `sys_dict_data` ( `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 ( 2, '30天内', '30', 'rectification_deadline', NULL, 'default', 'N', '0', '超级管理员', '2023-09-01 17:00:07', 'jwx', '2023-12-26 16:36:40', NULL);
INSERT INTO `sys_dict_data` ( `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 ( 4, '90天内', '90', 'rectification_deadline', NULL, 'default', 'N', '0', '超级管理员', '2023-09-01 17:00:17', 'jwx', '2023-12-26 16:37:04', NULL);
INSERT INTO `sys_dict_data` ( `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 ( 3, '60天内', '60', 'rectification_deadline', NULL, 'default', 'N', '0', '超级管理员', '2023-12-26 16:36:57', 'jwx', '2023-12-26 16:37:08', NULL);
INSERT INTO `sys_dict_data` ( `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 ( 5, '180天内', '180', 'rectification_deadline', NULL, 'default', 'N', '0', '超级管理员', '2023-12-26 16:37:23', '', NULL, NULL);
INSERT INTO `sys_dict_data` ( `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 ( 6, '360天内', '360', 'rectification_deadline', NULL, 'default', 'N', '0', '超级管理员', '2023-12-26 16:37:39', '', NULL, NULL);

DELETE FROM `sys_dict_data` WHERE `dict_type`='resumption_plan_cycle' and  `dict_value`='0';
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 (20231114998, 8, '无周期', '0', 'resumption_plan_cycle', NULL, 'default', 'N', '0', 'jwx', '2024-01-02 09:25:16', '', NULL, NULL);


DROP TABLE IF EXISTS `sys_operating_type`;
CREATE TABLE `sys_operating_type`  (
  `id` bigint NOT NULL COMMENT '主键',
  `source_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '资料类型',
  `sort` int NULL DEFAULT NULL COMMENT '排序字段',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sys_operating
-- ----------------------------
DROP TABLE IF EXISTS `sys_operating`;
CREATE TABLE `sys_operating`  (
  `id` bigint NOT NULL COMMENT '主键',
  `source_id` bigint NULL DEFAULT NULL COMMENT '资料类型',
  `file_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件地址',
  `file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件名称',
  `sort` int NULL DEFAULT NULL COMMENT '排序字段',
  `file_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件类型',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;


delete from sys_menu where menu_name = '手册类型';
delete from sys_menu where menu_name = '操作手册';
delete from sys_menu where menu_name = '操作手册配置';
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 (01738858108249956353, '手册类型', 1739111245879676930, 12, 'operating', 'system/operating/type/index', NULL, 1, 0, 'C', '0', '0', '', '1', 'documentation', NULL, '超级管理员', '2023-12-24 17:44:14', '超级管理员', '2023-12-25 10:35:22', '');
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 (01738865249262231553, '操作手册', 1739111245879676930, 13, 'operatingData', 'system/operating/data/index', NULL, 1, 0, 'C', '0', '0', '', '1', 'documentation', NULL, '超级管理员', '2023-12-24 18:12:36', '超级管理员', '2023-12-25 10:35:03', '');
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 (01739111245879676930, '操作手册配置', 1, 15, 'opertion', NULL, NULL, 1, 0, 'M', '0', '0', NULL, '1', 'dict', NULL, '超级管理员', '2023-12-25 10:30:06', '', NULL, '');


delete from sys_config where config_key = 'CUSTOMER_SERVICE';
INSERT INTO `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (202, '客服服务', 'CUSTOMER_SERVICE', '', 'Y', '超级管理员', '2023-12-25 10:16:37', '', NULL, NULL);

DROP TABLE IF EXISTS `core_announcement_notification_to_orgtype`;
CREATE TABLE `core_announcement_notification_to_orgtype`  (
                                                              `announcement_notification_id` bigint(0) NOT NULL,
                                                              `org_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
delete from sys_menu where id in(00000000000000002196,00000000000000002208,00000000000000002209,00000000000000002210, 00000000000000002211,00000000000000002212);
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 (00000000000000002196, '通知公告', 2207, 1, 'core/message', 'core/message/index', NULL, 1, 0, 'C', '0', '0', 'core:notification:list', '1', 'dashboard', NULL, '超级管理员', '2023-09-13 17:50:26', '超级管理员', '2023-09-15 16:47:45', '');
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 (00000000000000002208, '通知公告详情', 2196, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:notification:query', '1', '#', NULL, '超级管理员', '2023-09-19 15:17:27', '', NULL, '');
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 (00000000000000002209, '通知公告编辑', 2196, 2, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:notification:edit', '1', '#', NULL, '超级管理员', '2023-09-19 15:17:56', '', NULL, '');
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 (00000000000000002210, '新增通知公告', 2196, 3, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:notification:add', '1', '#', NULL, '超级管理员', '2023-09-19 15:18:18', '', NULL, '');
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 (00000000000000002211, '删除通知公告', 2196, 4, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:notification:remove', '1', '#', NULL, '超级管理员', '2023-09-19 15:18:42', '', NULL, '');
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 (00000000000000002212, '发布通知公告', 2196, 5, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:notification:publish', '1', '#', NULL, '超级管理员', '2023-09-19 15:19:03', '', NULL, '');




-- ----------------------------
-- Table structure for sys_org_map
-- ----------------------------
DROP TABLE IF EXISTS `sys_org_map`;
CREATE TABLE `sys_org_map`  (
  `org_code` varchar(64) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL COMMENT '机构的编码',
  `map` varchar(255) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT '机构的地图文件',
  `longitude` double NULL DEFAULT NULL COMMENT '经度',
  `latitude` double NULL DEFAULT NULL COMMENT '纬度',
  `name` varchar(255) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,
  PRIMARY KEY (`org_code`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = gbk COLLATE = gbk_chinese_ci COMMENT = '机构地图信息' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_org_map
-- ----------------------------
INSERT INTO `sys_org_map` VALUES ('900000000', '/map/fj.json', NULL, NULL, '省联社');
INSERT INTO `sys_org_map` VALUES ('901020300', '/map/fuzhou.json', 119.345806, 26.058267, '福州农商行');
INSERT INTO `sys_org_map` VALUES ('901030300', '/map/minhou.json', 119.163648, 26.1521, '闽侯县联社');
INSERT INTO `sys_org_map` VALUES ('901040300', '/map/minqing.json', 118.868057, 26.226602, '闽清联社');
INSERT INTO `sys_org_map` VALUES ('901050300', '/map/yongtai.json', 118.939153, 25.872016, '永泰联社');
INSERT INTO `sys_org_map` VALUES ('901060300', '/map/changle.json', 119.515565, 25.967859, '长乐农商行');
INSERT INTO `sys_org_map` VALUES ('901070300', '/map/fuqing.json', 119.357814, 25.722627, '福清汇通农商行');
INSERT INTO `sys_org_map` VALUES ('901080300', '/map/pingtan.json', 119.805094, 25.508058, '平潭农商行');
INSERT INTO `sys_org_map` VALUES ('901090300', '/map/lianjiang.json', 119.550222, 26.214663, '连江农商银行');
INSERT INTO `sys_org_map` VALUES ('901100300', '/map/luoyuan.json', 119.556364, 26.493841, '罗源县联社');
INSERT INTO `sys_org_map` VALUES ('902010200', '/map/xiameng.json', 118.082466, 24.491062, '厦门农商行');
INSERT INTO `sys_org_map` VALUES ('903020300', '/map/sanming.json', 117.641758, 26.274434, '三明农商银行');
INSERT INTO `sys_org_map` VALUES ('903030300', '/map/mingxi.json', 117.210085, 26.366816, '明溪联社');
INSERT INTO `sys_org_map` VALUES ('903040300', '/map/yongan.json', 117.373871, 25.982393, '永安农商银行');
INSERT INTO `sys_org_map` VALUES ('903050300', '/map/qingliu.json', 116.824593, 26.184229, '清流农信联社');
INSERT INTO `sys_org_map` VALUES ('903060300', '/map/ninghua.json', 116.671271, 26.255966, '宁化县联社');
INSERT INTO `sys_org_map` VALUES ('903070300', '/map/datian.json', 117.860745, 25.696962, '大田县联社');
INSERT INTO `sys_org_map` VALUES ('903080300', '/map/youxi.json', 118.20086, 26.177155, '尤溪农信联社');
INSERT INTO `sys_org_map` VALUES ('903090300', '/map/shaxian.json', 117.79744, 26.399502, '沙县农商银行');
INSERT INTO `sys_org_map` VALUES ('903100300', '/map/jiangle.json', 117.486381, 26.727502, '将乐县联社');
INSERT INTO `sys_org_map` VALUES ('903110300', '/map/taining.json', 117.185688, 26.898715, '泰宁县联社');
INSERT INTO `sys_org_map` VALUES ('903120300', '/map/jianning.json', 16.856116, 26.830608, '建宁联社');
INSERT INTO `sys_org_map` VALUES ('904020300', '/map/putian.json', 119.014794, 25.427314, '莆田农商银行');
INSERT INTO `sys_org_map` VALUES ('904060300', '/map/xianyou.json', 118.703371, 25.361024, '仙游农商银行');
INSERT INTO `sys_org_map` VALUES ('905020300', '/map/nanping.json', 118.185343, 26.648297, '南平农商银行');
INSERT INTO `sys_org_map` VALUES ('905030300', '/map/shaowu.json', 117.499641, 27.339004, '邵武农商行');
INSERT INTO `sys_org_map` VALUES ('905040300', '/map/jianyang.json', 118.128905, 27.337197, '建阳区联社');
INSERT INTO `sys_org_map` VALUES ('905050300', '/map/shunchang.json', 117.815179, 26.796944, '顺昌县联社');
INSERT INTO `sys_org_map` VALUES ('905060300', '/map/jianou.json', 118.326437, 27.039505, '建瓯农商银行');
INSERT INTO `sys_org_map` VALUES ('905070300', '/map/pucheng.json', 118.54245, 27.929252, '浦城县联社');
INSERT INTO `sys_org_map` VALUES ('905080300', '/map/wuyishan.json', 118.036163, 27.757306, '武夷山农商行');
INSERT INTO `sys_org_map` VALUES ('905090300', '/map/guangzhe.json', 117.339921, 27.545182, '光泽农信联社');
INSERT INTO `sys_org_map` VALUES ('905100300', '/map/songxi.json', 118.791406, 27.535185, '松溪县联社');
INSERT INTO `sys_org_map` VALUES ('905110300', '/map/zhenghe.json', 118.858131, 27.3699, '政和县联社');
INSERT INTO `sys_org_map` VALUES ('906020300', '/map/ningde.json', 119.550016, 26.642835, '宁德农商行');
INSERT INTO `sys_org_map` VALUES ('906030300', '/map/fuding.json', 120.218, 27.322, '福鼎市联社');
INSERT INTO `sys_org_map` VALUES ('906040300', '/map/xiapu.json', 120.034052, 26.90268, '霞浦县联社');
INSERT INTO `sys_org_map` VALUES ('906050300', '/map/fuan.json', 119.655959, 27.098314, '龙岩农商行');
INSERT INTO `sys_org_map` VALUES ('906060300', '/map/gutian.json', 118.752494, 26.582936, '古田农信联社');
INSERT INTO `sys_org_map` VALUES ('906070300', '/map/pingnan.json', 118.993309, 26.913816, '屏南县联社');
INSERT INTO `sys_org_map` VALUES ('906080300', '/map/shouning.json', 119.518667, 27.461004, '寿宁联社');
INSERT INTO `sys_org_map` VALUES ('906090300', '/map/zhouning.json', 119.345858, 27.107093, '周宁县联社');
INSERT INTO `sys_org_map` VALUES ('906100300', '/map/zherong.json', 119.892966, 27.242269, '柘荣联社');
INSERT INTO `sys_org_map` VALUES ('907020300', '/map/quanzhou.json', 118.68752, 24.877245, '泉州农商行');
INSERT INTO `sys_org_map` VALUES ('907030300', '/map/huian.json', 118.807105, 25.034176, '惠安联社');
INSERT INTO `sys_org_map` VALUES ('907040300', '/map/jinjiang.json', 118.580761, 24.810567, '晋江农商行');
INSERT INTO `sys_org_map` VALUES ('907060300', '/map/shishi.json', 118.628645, 24.741741, '石狮农商银行');
INSERT INTO `sys_org_map` VALUES ('907070300', '/map/nanan.json', 118.414178, 24.964147, '南安农商行');
INSERT INTO `sys_org_map` VALUES ('907090300', '/map/anxi.json', 118.20232, 25.047271, '安溪农商银行');
INSERT INTO `sys_org_map` VALUES ('907100300', '/map/yongchun.json', 118.297553, 25.328058, '永春县联社');
INSERT INTO `sys_org_map` VALUES ('907110300', '/map/dehua.json', 118.254932, 25.500535, '德化县联社');
INSERT INTO `sys_org_map` VALUES ('908020300', '/map/zhangzhou.json', 117.678885, 24.508849, '漳州农商行');
INSERT INTO `sys_org_map` VALUES ('908030300', '/map/longhai.json', 117.827787, 24.445486, '龙海农商行');
INSERT INTO `sys_org_map` VALUES ('908040300', '/map/yunxiao.json', 117.347455, 23.94945, '云霄联社');
INSERT INTO `sys_org_map` VALUES ('908050300', '/map/zhangpu.json', 117.628503, 24.12591, '漳浦农商银行');
INSERT INTO `sys_org_map` VALUES ('908060300', '/map/zhaoan.json', 117.185415, 23.717726, '诏安县联社');
INSERT INTO `sys_org_map` VALUES ('908070300', '/map/changtai.json', 117.755075, 24.626346, '长泰联社');
INSERT INTO `sys_org_map` VALUES ('908080300', '/map/dongshan.json', 117.432607, 23.713423, '东山联社');
INSERT INTO `sys_org_map` VALUES ('908090300', '/map/nanjing.json', 117.37278, 24.523476, '南靖县联社');
INSERT INTO `sys_org_map` VALUES ('908100300', '/map/pinghe.json', 117.322278, 24.376662, '平和农商银行');
INSERT INTO `sys_org_map` VALUES ('908110300', '/map/huaan.json', 117.543383, 25.006307, '华安县联社');
INSERT INTO `sys_org_map` VALUES ('909020300', '/map/longyan.json', 117.035585, 25.120735, '永定联社');
INSERT INTO `sys_org_map` VALUES ('909030300', '/map/changding.json', 116.36285, 25.838911, '长汀联社');
INSERT INTO `sys_org_map` VALUES ('909040300', '/map/yongding.json', 116.734408, 24.723809, '福安联社');
INSERT INTO `sys_org_map` VALUES ('909050300', '/map/shanghang.json', 116.429341, 25.060384, '上杭农商行');
INSERT INTO `sys_org_map` VALUES ('909060300', '/map/wuping.json', 116.101001, 25.086408, '武平县联社');
INSERT INTO `sys_org_map` VALUES ('909070300', '/map/zhangping.json', 117.428414, 25.291055, '漳平农商行');
INSERT INTO `sys_org_map` VALUES ('909080300', '/map/liancheng.json', 116.772351, 25.716789, '连城联社');
INSERT INTO `sys_org_map` VALUES ('C900000000', '/map/fj.json', NULL, NULL, '福建农信');
INSERT INTO `sys_org_map` VALUES ('M39000000', '/map/fuzhou.json', NULL, NULL, '福州地区行社');
INSERT INTO `sys_org_map` VALUES ('M40000000', '/map/xiameng.json', NULL, NULL, '厦门地区行社');
INSERT INTO `sys_org_map` VALUES ('M41000000', '/map/putian.json', NULL, NULL, '莆田地区行社');
INSERT INTO `sys_org_map` VALUES ('M42000000', '/map/quanzhou.json', NULL, NULL, '泉州地区行社');
INSERT INTO `sys_org_map` VALUES ('M43000000', '/map/zhangzhou.json', NULL, NULL, '漳州地区行社');
INSERT INTO `sys_org_map` VALUES ('M44000000', '/map/longyan.json', NULL, NULL, '龙岩地区行社');
INSERT INTO `sys_org_map` VALUES ('M45000000', '/map/sanming.json', NULL, NULL, '三明地区行社');
INSERT INTO `sys_org_map` VALUES ('M46000000', '/map/nanping.json', NULL, NULL, '南平地区行社');
INSERT INTO `sys_org_map` VALUES ('M47000000', '/map/ningde.json', NULL, NULL, '宁德地区行社');


update sys_org set sort =6000 WHERE short_name='福州农商行';
update sys_org set sort =6001 WHERE short_name='闽侯联社';
update sys_org set sort =6002 WHERE short_name='闽清联社';
update sys_org set sort =6003 WHERE short_name='永泰联社';
update sys_org set sort =6004 WHERE short_name='长乐农商银行';
update sys_org set sort =6005 WHERE short_name='福清汇通农商行';
update sys_org set sort =6006 WHERE short_name='平潭农商银行';
update sys_org set sort =6007 WHERE short_name='连江农商行';
update sys_org set sort =6008 WHERE short_name='罗源联社';
update sys_org set sort =6009 WHERE short_name='厦门农商银行';
update sys_org set sort =6010 WHERE short_name='漳州农商银行';
update sys_org set sort =6011 WHERE short_name='龙海农商银行';

update sys_org set sort =6012 WHERE short_name='云霄联社';
update sys_org set sort =6013 WHERE short_name='漳浦农商银行';
update sys_org set sort =6014 WHERE short_name='诏安联社';
update sys_org set sort =6015 WHERE short_name='长泰联社';
update sys_org set sort =6016 WHERE short_name='东山联社';
update sys_org set sort =6017 WHERE short_name='南靖联社';
update sys_org set sort =6018 WHERE short_name='平和联社';
update sys_org set sort =6019 WHERE short_name='华安联社';
update sys_org set sort =6020 WHERE short_name='泉州农商银行';
update sys_org set sort =6021 WHERE short_name='晋江农商银行';
update sys_org set sort =6022 WHERE short_name='石狮农商银行';
update sys_org set sort =6023 WHERE short_name='南安农商银行';

update sys_org set sort =6024 WHERE short_name='惠安联社';
update sys_org set sort =6025 WHERE short_name='安溪农商银行';
update sys_org set sort =6026 WHERE short_name='永春联社';
update sys_org set sort =6027 WHERE short_name='德化联社';
update sys_org set sort =6028 WHERE short_name='莆田农商银行';
update sys_org set sort =6029 WHERE short_name='仙游农商银行';
update sys_org set sort =6030 WHERE short_name='三明农商银行';
update sys_org set sort =6031 WHERE short_name='明溪联社';
update sys_org set sort =6032 WHERE short_name='永安农商银行';
update sys_org set sort =6033 WHERE short_name='清流联社';
update sys_org set sort =6034 WHERE short_name='宁化联社';
update sys_org set sort =6035 WHERE short_name='大田联社';

update sys_org set sort =6036 WHERE short_name='尤溪联社';
update sys_org set sort =6037 WHERE short_name='沙县农商行';
update sys_org set sort =6038 WHERE short_name='将乐联社';
update sys_org set sort =6039 WHERE short_name='泰宁县联社';
update sys_org set sort =6040 WHERE short_name='建宁联社';
update sys_org set sort =6041 WHERE short_name='南平农商银行';
update sys_org set sort =6042 WHERE short_name='邵武农商银行';
update sys_org set sort =6043 WHERE short_name='建阳联社';
update sys_org set sort =6044 WHERE short_name='武夷山农商银行';
update sys_org set sort =6045 WHERE short_name='建瓯农商银行';
update sys_org set sort =6046 WHERE short_name='顺昌联社';
update sys_org set sort =6047 WHERE short_name='浦城联社';

update sys_org set sort =6048 WHERE short_name='光泽联社';
update sys_org set sort =6049 WHERE short_name='松溪联社';
update sys_org set sort =6050 WHERE short_name='政和联社';
update sys_org set sort =6051 WHERE short_name='龙岩农商银行';
update sys_org set sort =6052 WHERE short_name='长汀联社';
update sys_org set sort =6053 WHERE short_name='永定联社';
update sys_org set sort =6054 WHERE short_name='上杭农商银行';
update sys_org set sort =6055 WHERE short_name='武平联社';
update sys_org set sort =6056 WHERE short_name='漳平农商银行';
update sys_org set sort =6057 WHERE short_name='连城联社';
update sys_org set sort =6058 WHERE short_name='宁德农商银行';
update sys_org set sort =6059 WHERE short_name='福鼎联社';

update sys_org set sort =6060 WHERE short_name='霞浦联社';
update sys_org set sort =6061 WHERE short_name='福安联社';
update sys_org set sort =6062 WHERE short_name='古田联社';
update sys_org set sort =6063 WHERE short_name='屏南联社';
update sys_org set sort =6064 WHERE short_name='寿宁联社';
update sys_org set sort =6065 WHERE short_name='周宁联社';
update sys_org set sort =6066 WHERE short_name='柘荣联社';


delete from sys_dict_data where dict_type = 'core_registration_project';
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 (238, 0, '监控设备', '0', 'core_registration_project', NULL, 'default', 'N', '0', '何悦', '2023-08-30 16:39:40', '超级管理员', '2024-01-04 17:59:57', '包含但不限于：\n1.检查监控图像画面是否不清晰或丢失、画面角度是否偏移、录像时间是否校时。\n2.监控录像回放效果应达到以下要求:图像清晰、连续;能清晰显示柜员操作及客户脸部特征,无丢包现象,录音系统良好;有完整的图像声音复合记录,图像覆盖范围准确。\n3.录像存盘不少于30天(业务库等重要部位不少90天)。');
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 (239, 1, '员工在岗', '1', 'core_registration_project', NULL, 'default', 'N', '0', '何悦', '2023-08-30 16:39:56', '超级管理员', '2024-01-04 18:00:03', '包含但不限于：\n1、各岗位员工是否按时到岗，是否存在缺岗而未请假者。\n2、安全员是否挂牌上岗。');
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 (240, 2, '双道门进出', '2', 'core_registration_project', NULL, 'default', 'N', '0', '何悦', '2023-08-30 16:40:24', '超级管理员', '2024-01-04 18:00:07', '包含但不限于：\n1、除营业前进入现金业务区使用钥匙外，营业期间进出现金业务区，一律不得使用钥匙开启互锁安全门，必须由现金业务区内工作人员使用电控装置开启。\n2、实行“开一道随手关一道，然后再开、关第二道”的程序操作，非紧急情况下禁止使用电控装置双开按钮同时开启互锁安全门的内、外门。\n3、营业终了同时在确认互锁安全门已锁闭后，人员方可离开。');
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 (241, 3, '查验身份', '3', 'core_registration_project', NULL, 'default', 'N', '0', '何悦', '2023-08-30 16:40:56', '超级管理员', '2024-01-04 18:00:11', '包含但不限于：\n1、非本营业网点人员因工作需要进出现金业务区，由本网点工作人员在现金业务区全程陪同，网点工作人员必须主动认真查验来访人员出具的相关证件，经核验无误后，在确认安全的情况下，方可同意其外部人员进出，并做好记录。\n2、福建农信系统因工作需要进出现金业务区，必须出示检查单位或受检行社开具的介绍信检查人员身份证，并由受检行社安全保卫等相关职能部门人员或网点负责人陪同，受检单位人员必须主动认真核验检查人员出具的相关证件，经核验无误后，在确认安全的情况下，方可同意其外部人员进出，并做好记录。\n3、外部单位（如公安、消防、监管部门）需要对行社的安全情况进行检查时需要进出现金业务区，必须出示检查单位县级以上部门的介绍信、检查人员身份证（或能够证明本人身份的工作证），并由受检行社安全保卫等相关职能部门人员或网点负责人陪同，受检单位人员必须主动认真核验检查人员出具的相关证件，经核验无误并做好记录后。');
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 (242, 4, '款箱交接', '4', 'core_registration_project', NULL, 'default', 'N', '0', '何悦', '2023-08-30 16:41:17', '超级管理员', '2024-01-04 18:00:16', '包含但不限于：\n1、营业终了，现金、有价单证、贵重物品、代保管品等是否全部装入款箱运走或入库保管。\n2、接送款箱时，应先验人、验证、验运钞车，由款箱提款员提款箱出入互锁安全门，持枪人员只能在现金业务区外警戒。\n3、款箱交接人员严格按照规定办理款箱交接手续，督促接钞人员应提前到岗、严禁出现“车等人”现象，确保核对运钞车号、对押运人员进行身份识别、核对款箱、封签条和锁具的完整性等动作均应在监控摄像下的指定区域完成。');
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 (243, 14, '现金保管', '14', 'core_registration_project', NULL, 'default', 'N', '0', '何悦', '2023-08-30 16:41:30', '', 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 (244, 15, '临时离柜', '15', 'core_registration_project', NULL, 'default', 'N', '0', '何悦', '2023-08-30 16:41:50', '', 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 (246, 17, '印章管理', '17', 'core_registration_project', NULL, 'default', 'N', '0', '何悦', '2023-08-30 16:42:31', '', 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 (247, 16, '每日碰库', '16', 'core_registration_project', NULL, 'default', 'N', '0', '何悦', '2023-08-30 16:42:53', '', 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 (252, 18, '离岗交接', '18', 'core_registration_project', NULL, 'default', 'N', '0', '何悦', '2023-08-30 16:44:38', '', 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 (253, 6, '值班情况', '6', 'core_registration_project', NULL, 'default', 'N', '0', '何悦', '2023-08-30 16:44:56', '超级管理员', '2024-01-04 18:00:28', '包含但不限于：\n1、检查值班人员是否在岗并认真履行职责，严格控制人员出入，除值班和加班人员外，其余人员不得在营业场所逗留。');
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 (254, 19, '其他', '19', 'core_registration_project', NULL, 'default', 'N', '0', '何悦', '2023-08-30 16:45:55', '', 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 (20231114693, 5, '押运监督', '5', 'core_registration_project', NULL, 'default', 'N', '0', '超级管理员', '2023-12-11 16:52:21', '超级管理员', '2024-01-04 18:00:24', '包含但不限于：\n1、押运人员执行任务时是否携带武器、穿防弹衣、戴防弹头盔。\n2、押运人员警戒是否合规。\n3、运钞车停车位置是否合规。\n4、款箱交接位置是否合规。');
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 (20231114694, 7, '自助银行管理', '7', 'core_registration_project', NULL, 'default', 'N', '0', '超级管理员', '2023-12-11 16:52:45', '超级管理员', '2024-01-04 18:00:33', '包含但不限于：\n1、进出库房是否同进同出，自助设备保险柜开启时，钥匙管理员和密码管理员是否同时在场，是否按程序各自独立进行操作，相互委托开启。\n2、加钞间是否按规定撤布控，是否双人开启自助机具。\n3、自助银行设备加钞前是否按规定清分（验钞）。\n4、更换在行式自助设备钞箱时，除双人操作外，无安全保卫人员进行安全警戒时是否采取其他有效安保措施，如关闭双道门等。\n5、自助银行设备的密码、钥匙等是否是否按规定保管（自助设备钥匙不使用时，应入库或者入保险柜保管），是否执行双人分管分用制度。');
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 (20231114695, 8, '业务合规操作', '8', 'core_registration_project', NULL, 'default', 'N', '0', '超级管理员', '2023-12-11 16:52:59', '', 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 (20231114696, 9, '网点履职监督', '9', 'core_registration_project', NULL, 'default', 'N', '0', '超级管理员', '2023-12-11 16:53:47', '超级管理员', '2024-01-04 18:02:50', '包含但不限于：\n1、安全员及员工履职监督，例如营业厅大门开启后是否反锁固定。\n2、是否按规定对自助设备进行巡检。\n3、营业终了营业厅的门窗是否关闭锁定，离开营业厅时是否设防。');
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 (20231114697, 10, '消防安全管理', '10', 'core_registration_project', NULL, 'default', 'N', '0', '超级管理员', '2023-12-11 16:53:58', '超级管理员', '2024-01-04 18:02:54', '包含但不限于：\n1、在安全区域内是否使用明火电炉、乱拉电线等行为。\n2、下班后电源、电器是否及时关闭，垃圾纸屑等易燃物是否清理。');
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 (20231114698, 11, '员工着装', '11', 'core_registration_project', NULL, 'default', 'N', '0', '超级管理员', '2023-12-11 16:54:37', '', 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 (20231114699, 12, '行为举止', '12', 'core_registration_project', NULL, 'default', 'N', '0', '超级管理员', '2023-12-11 16:54:50', '', 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 (20231114700, 13, '服务质量', '13', 'core_registration_project', NULL, 'default', 'N', '0', '超级管理员', '2023-12-11 16:55:08', '', NULL, '可参考具体制度要求');


-- 修正检查登记跟踪菜单权限
update sys_menu set perms="core:safetytask:list" WHERE menu_name ="检查登记跟踪" and platform_type=1;
update sys_menu set perms="core:safetytask:list" WHERE parent_id in (SELECT id from (SELECT id from sys_menu WHERE  menu_name ="检查登记跟踪" and platform_type=1) a) and menu_name ="列表" and platform_type=1;
update sys_menu set perms="core:safetytask:query" WHERE parent_id in (SELECT id from (SELECT id from sys_menu WHERE  menu_name ="检查登记跟踪" and platform_type=1) a) and menu_name ="详细信息" and platform_type=1;
DELETE FROM sys_menu where  parent_id in (SELECT id from (SELECT id from sys_menu WHERE  menu_name ="检查登记跟踪" and platform_type=1) a) and menu_name in("新增","修改") and platform_type=1;


update sys_dict_data set dict_label='大专' WHERE dict_type='sys_highest_education' and dict_label='专科';
DELETE from `sys_dict_data` WHERE dict_type='sys_highest_education' and dict_label='中专';
INSERT INTO `sys_dict_data` ( `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 ( 4, '中专', '4', 'sys_highest_education', NULL, 'default', 'N', '0', '何悦', '2023-08-22 14:17:59', '超级管理员', '2023-09-15 16:59:16', NULL);