soc/project_data/sql/0.0.3/soc/soc.sql

CREATE TABLE if not exists  `core_safety_dict` (
                                                   `id` int NOT NULL AUTO_INCREMENT,
                                                   `code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '指标分类code',
    `parent_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '父级code',
    `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '指标分类name',
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE KEY `code` (`code`) USING BTREE
    ) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='安全指标配置字典表';

-- 新增安保综合评价规则表
CREATE TABLE if not exists`core_safety_index_calculate_rule` (
                                                                 id             bigint default 0 not null ,
                                                                 type_code      varchar(50)      null comment '指标分类code',
    project_code   varchar(50)      null comment '指标项目code',
    point_code     varchar(50)      null comment '指标要点code',
    deduction_type int              null comment '扣分方式 1：直接扣分，2最高扣分',
    score          int              null comment '分值',
    formula        varchar(500)     null comment '扣分规则描述',
    org_type       int              null comment '机构类型',
    deleted        int    default 0 null comment '是否删除 0否1是',
    cycle          int              null comment '周期，只有在指标分类为安保履职时使用',
    remark         varchar(500)     null comment '备注',
    create_time    datetime         null,
    create_by      varchar(125)     null,
    update_time    datetime         null,
    update_by      varchar(125)     null,
    PRIMARY KEY (`id`) USING BTREE
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='安全指标配置表';


CREATE TABLE if not exists `core_safety_index_calculate_rule_item` (
                                                                       id             bigint default 0 not null ,
                                                                       rule_id        bigint           null comment '安全指标主键',
                                                                       indicator_note varchar(100)     null comment '细化指数描述',
    calculate_type int              null comment '计算类型 1累计数，2连续数，3 分类,4 固化值',
    indicator_days int              null comment '连续数，连续多少天',
    item_type      int              null comment 'calculate_type为3是用来存具体分类',
    item_value     double(5, 2)     null comment '扣分系数',
    order_num      int              null comment '排序',
    create_time    datetime         null,
    create_by      varchar(125)     null,
    update_time    datetime         null,
    update_by      varchar(125)     null,
    PRIMARY KEY (`id`) USING BTREE,
    KEY `rule_id` (`rule_id`) USING BTREE
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='安全指标指数细化表';


CREATE TABLE if not exists core_safe_level
(
    id          int auto_increment primary key,
    level_name  varchar(50)  null comment '安全等级名称：L1,L2,L3，l4',
    min_value   double(5, 2) null comment '最小值',
    max_value   double(5, 2) null comment '最大值',
    risk_level  int          null comment '等级风险：0：低，1：中，2：高,3: 极高',
    description varchar(50)  null comment '安全等级描述:'
    ) comment '安全等级配置表';

CREATE TABLE if not exists `core_safe_month_score` (
                                                       `id` bigint NOT NULL COMMENT '主键id',
                                                       `level_id` bigint DEFAULT NULL COMMENT '评分等级id',
                                                       `org_id` bigint DEFAULT NULL COMMENT '机构id',
                                                       `data_year` int DEFAULT NULL COMMENT '数据所在年',
                                                       `data_month` int DEFAULT NULL COMMENT '数据所在月',
                                                       `org_score` double(10,2) NOT NULL COMMENT '机构得分',
    `release_status` int DEFAULT NULL COMMENT '评分状态',
    `org_path` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '机构path',
    PRIMARY KEY (`id`) USING BTREE,
    KEY `idx_year_month` (`data_year`,`data_month`) USING BTREE,
    KEY `idx_orgId` (`org_id`) USING BTREE
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='安全指数机构月度得分表';

create table if not exists core_safety_exception_data(
                                                         id           bigint auto_increment comment '主键' primary key,
                                                         data_id      varchar(100)                       null comment '异常数据id',
    org_id       bigint                             null comment '机构id',
    org_name     varchar(225)                       null comment '机构名称',
    org_path     varchar(225)                       null comment '机构path',
    data_time    date                               null comment '数据产生日期',
    data_source  varchar(50)                        null comment '数据来源表',
    extra_field1 varchar(100)                       null comment '扩展预留字段',
    extra_field2 varchar(100)                       null comment '扩展预留字段',
    create_time  datetime default CURRENT_TIMESTAMP null comment '创建时间'
    ) comment '安全指标的异常数据';

CREATE TABLE if not exists`core_safety_source_data` (
                                                        `id` bigint NOT NULL COMMENT '主键id',
                                                        `rule_id` bigint DEFAULT NULL COMMENT '评价规则id',
                                                        `item_id` bigint DEFAULT NULL COMMENT '评价规则项id',
                                                        `org_id` bigint DEFAULT NULL COMMENT '机构id',
                                                        `data_year` int DEFAULT NULL COMMENT '数据所在年',
                                                        `data_month` int DEFAULT NULL COMMENT '数据所在月',
                                                        `times` int DEFAULT NULL COMMENT '出现次数',
                                                        `score` double(10,2) DEFAULT NULL COMMENT '扣分值',
    `type_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '配置项',
    PRIMARY KEY (`id`) USING BTREE,
    KEY `idx_year_month` (`data_year`,`data_month`) USING BTREE,
    KEY `idx_orgId` (`org_id`) USING BTREE
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='安全指数机构扣分细项表';

CREATE TABLE if not exists `core_safety_deduct_data` (
                                                         `id` bigint NOT NULL COMMENT '主键id',
                                                         `rule_id` bigint DEFAULT NULL COMMENT '评价规则表',
                                                         `org_id` bigint DEFAULT NULL COMMENT '机构id',
                                                         `data_year` int DEFAULT NULL COMMENT '数据所在年',
                                                         `data_month` int DEFAULT NULL COMMENT '数据所在月',
                                                         `score` double(10,2) DEFAULT NULL COMMENT '合计每个子项后得出安全指标的分数',
    `score_real` double(10,2) DEFAULT NULL COMMENT '真实扣分',
    PRIMARY KEY (`id`) USING BTREE,
    KEY `idx_year_month` (`data_year`,`data_month`) USING BTREE,
    KEY `idx_orgId` (`org_id`) USING BTREE
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='安全指数扣分表';

CREATE TABLE  if not exists `core_safecheck_plan_to_check_org_type` (
                                                                        `plan_id` bigint NOT NULL COMMENT '计划id',
                                                                        `type_id` bigint NOT NULL COMMENT '类型id',
                                                                        `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                                                                        `update_time` datetime DEFAULT NULL COMMENT '修改时间',
                                                                        `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
    `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人'
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='常规安全检查-受检机构类型关联表';

create table if not exists core_register_book_pdf(
                                                     id                 bigint       not null
                                                     primary key,
                                                     register_book_type int          not null comment '登记簿类型',
                                                     date               date         not null comment '保存日期',
                                                     org_id             bigint       not null comment '机构id',
                                                     org_name           varchar(255)       not null comment '机构名称',
    org_path           varchar(255)       not null comment '机构path',
    file_name          varchar(255) null comment '文件名称',
    file_url           varchar(255) null comment '文件地址'
    );

create table if not exists core_edu_training_plan_to_org_type
(
    plan_id bigint not null comment '计划id',
    org_type  int not null comment '机构类型'
)
    comment '教育培训计划与执行机构类型关系表';

-- 新增安全指数字典表
delete from core_safety_dict;
INSERT ignore INTO core_safety_dict (id, code, parent_code, name) VALUES (52, '1004', '-1', '安保履职');
INSERT ignore INTO core_safety_dict (id, code, parent_code, name) VALUES (53, '100402', '1004', '未登');
INSERT ignore INTO core_safety_dict (id, code, parent_code, name) VALUES (54, '10040203', '100402', '网点安全员 (营业中)');
INSERT ignore INTO core_safety_dict (id, code, parent_code, name) VALUES (55, '10040201', '100402', '网点安全员（营业前）');
INSERT ignore INTO core_safety_dict (id, code, parent_code, name) VALUES (56, '10040202', '100402', '网点安全员（营业后）');
INSERT ignore INTO core_safety_dict (id, code, parent_code, name) VALUES (57, '1005', '-1', '问题整改');
INSERT ignore INTO core_safety_dict (id, code, parent_code, name) VALUES (58, '100501', '1005', '问题数量');
INSERT ignore INTO core_safety_dict (id, code, parent_code, name) VALUES (59, '10050101', '100501', '未在规定时间内确认');
INSERT ignore INTO core_safety_dict (id, code, parent_code, name) VALUES (60, '100502', '1005', '整改情况');
INSERT ignore INTO core_safety_dict (id, code, parent_code, name) VALUES (61, '10050201', '100502', '已确认但未在规定时间内完成整改');
INSERT ignore INTO core_safety_dict (id, code, parent_code, name) VALUES (62, '1006', '-1', '监控调阅');
INSERT ignore INTO core_safety_dict (id, code, parent_code, name) VALUES (63, '100601', '1006', '监控调阅-未登');
INSERT ignore INTO core_safety_dict (id, code, parent_code, name) VALUES (64, '10060101', '100601', '未登-网点负责人(每周)');

-- 新增安保综合评价规则初始化数据(注释数据勿删除,留以备用)
delete from core_safety_index_calculate_rule;
-- INSERT ignore INTO core_safety_index_calculate_rule (id, type_code, project_code, point_code, deduction_type, score, formula, org_type, deleted, cycle, remark, create_time, create_by, update_time, update_by) VALUES (3846713285328896, '1005', '100501', '10050101', 2, 10, '扣分=问题数量*K+风险等级为“重大”的问题数量*K1+风险等级为“关注”的问题数量*K2+风险等级为“一般”的问题数量*K3+风险等级为“轻微”的问题数量*K4；得分大于10，取分值10。K为调节系数，可变更，建议测试期间K=0.05；K1=0.05；K2=0.15；K3=0.2；K4=0.25。', 3, 0, null, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule (id, type_code, project_code, point_code, deduction_type, score, formula, org_type, deleted, cycle, remark, create_time, create_by, update_time, update_by) VALUES (3846715519614976, '1005', '100501', '10050101', 2, 10, '扣分=问题数量*K+风险等级为“重大”的问题数量*K1+风险等级为“关注”的问题数量*K2+风险等级为“一般”的问题数量*K3+风险等级为“轻微”的问题数量*K4；得分大于10，取分值10。K为调节系数，可变更，建议测试期间K=0.05；K1=0.05；K2=0.15；K3=0.2；K4=0.25。', 4, 0, null, null, now(), null, now(), null);
-- INSERT ignore INTO core_safety_index_calculate_rule (id, type_code, project_code, point_code, deduction_type, score, formula, org_type, deleted, cycle, remark, create_time, create_by, update_time, update_by) VALUES (3846717305962496, '1005', '100501', '10050101', 2, 10, '扣分=问题数量*K+风险等级为“重大”的问题数量*K1+风险等级为“关注”的问题数量*K2+风险等级为“一般”的问题数量*K3+风险等级为“轻微”的问题数量*K4；得分大于10，取分值10。K为调节系数，可变更，建议测试期间K=0.05；K1=0.05；K2=0.15；K3=0.2；K4=0.25。', 5, 0, null, null, now(), null, now(), null);
-- INSERT ignore INTO core_safety_index_calculate_rule (id, type_code, project_code, point_code, deduction_type, score, formula, org_type, deleted, cycle, remark, create_time, create_by, update_time, update_by) VALUES (3846720300892160, '1005', '100502', '10050201', 2, 10, '扣分=两次整改问题数*K+三次或三次以上整改问题数*K1+超期整改问题数*K2+超期未整改问题数量*K3;得分大于10，取分值10。K为调节系数，可变更，建议测试期间K=3；K1=5；K2=0.6；K3=1。', 3, 0, null, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule (id, type_code, project_code, point_code, deduction_type, score, formula, org_type, deleted, cycle, remark, create_time, create_by, update_time, update_by) VALUES (3846721706754048, '1005', '100502', '10050201', 2, 10, '扣分=两次整改问题数*K+三次或三次以上整改问题数*K1+超期整改问题数*K2+超期未整改问题数量*K3;得分大于10，取分值10。K为调节系数，可变更，建议测试期间K=3；K1=5；K2=0.6；K3=1。', 4, 0, null, null, now(), null, now(), null);
-- INSERT ignore INTO core_safety_index_calculate_rule (id, type_code, project_code, point_code, deduction_type, score, formula, org_type, deleted, cycle, remark, create_time, create_by, update_time, update_by) VALUES (3846723149234176, '1005', '100502', '10050201', 2, 10, '扣分=两次整改问题数*K+三次或三次以上整改问题数*K1+超期整改问题数*K2+超期未整改问题数量*K3;得分大于10，取分值10。K为调节系数，可变更，建议测试期间K=3；K1=5；K2=0.6；K3=1。', 5, 0, null, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule (id, type_code, project_code, point_code, deduction_type, score, formula, org_type, deleted, cycle, remark, create_time, create_by, update_time, update_by) VALUES (3846745983598592, '1004', '100402', '10040203', 2, 20, '扣分=未登天数*K+未登连续3天*K1+未登连续5天*K2+未登连续10天*K3；得分大于20，取分值20。K为调节系数，可变更，建议测试期间K=0.5；K1=1.5；K2=3；K3=5。', 4, 0, 2, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule (id, type_code, project_code, point_code, deduction_type, score, formula, org_type, deleted, cycle, remark, create_time, create_by, update_time, update_by) VALUES (3846747145125888, '1004', '100402', '10040202', 2, 20, '扣分=未登天数*K+未登连续3天*K1+未登连续5天*K2+未登连续10天*K3；得分大于20，取分值20。K为调节系数，可变更，建议测试期间K=0.5；K1=1.5；K2=3；K3=5。', 4, 0, 2, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule (id, type_code, project_code, point_code, deduction_type, score, formula, org_type, deleted, cycle, remark, create_time, create_by, update_time, update_by) VALUES (1714172822255894529, '1006', '100601', '10060101', 2, 10, '扣分=未登天数*K+未登连续3天*K1+未登连续5天*K2+未登连续10天*K3；得分大于20，取分值20。K为调节系数，可变更，建议测试期间K=0.5；K1=1.5；K2=3；K3=5。', 4, 0, null, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule (id, type_code, project_code, point_code, deduction_type, score, formula, org_type, deleted, cycle, remark, create_time, create_by, update_time, update_by) VALUES (1714185441062748161, '1004', '100402', '10040201', 2, 20, '扣分=未登天数*K+未登连续3天*K1+未登连续5天*K2+未登连续10天*K3；得分大于20，取分值20。K为调节系数，可变更，建议测试期间K=0.5；K1=1.5；K2=3；K3=5。', 4, 0, 2, null, now(), null, now(), null);
-- 新增安 ignore保综合评价规则项初始化数据(注释数据勿删除,留以备用)
delete from core_safety_index_calculate_rule_item;
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846702578221056, 3846702577319936, '登记问题数量', 1, null, null, 1, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846703826649089, 3846703826108416, '连续报警三天', 2, 3, null, 1, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846703826649090, 3846703826108416, '连续报警五天', 2, 5, null, 2, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846703826649091, 3846703826108416, '连续报警十天', 2, 10, null, 3, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846704899833858, 3846704899145728, '连续报警五天', 2, 5, null, 2, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846704899833859, 3846704899145728, '连续报警十天', 2, 10, null, 3, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846706034999297, 3846706034688000, '连续报警三天', 2, 3, null, 1, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846706034999298, 3846706034688000, '连续报警五天', 2, 5, null, 2, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846706034999299, 3846706034688000, '连续报警十天', 2, 10, null, 3, null, now(), null, now(), null);
-- INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846713285820416, 3846713285328896, '问题数量', 1, null, null, 0.05, null, now(), null, now(), null);
-- INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846713285820417, 3846713285328896, '风险等级为轻微的问题数量', 3, null, 2, 0.05, null, now(), null, now(), null);
-- INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846713285820418, 3846713285328896, '风险等级为关注的问题数量', 3, null, 1, 0.15, null, now(), null, now(), null);
-- INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846713285820419, 3846713285328896, '风险等级为一般的问题数量', 3, null, 3, 0.2, null, now(), null, now(), null);
-- INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846713285820420, 3846713285328896, '风险等级为重大的问题数量', 3, null, 5, 0.25, null,now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846715519942656, 3846715519614976, '问题数量', 1, null, null, 0.05, null, now(), null, now(), null);
-- INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846715519942657, 3846715519614976, '风险等级为轻微的问题数量', 3, null, 2, 0.05, null,now(), null, now(), null);
-- INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846715519942658, 3846715519614976, '风险等级为关注的问题数量', 3, null, 1, 0.15, null, now(), null, now(), null);
-- INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846715519942659, 3846715519614976, '风险等级为一般的问题数量', 3, null, 3, 0.2, null,now(), null, now(), null);
-- INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846715519942660, 3846715519614976, '风险等级为重大的问题数量', 3, null, 5, 0.25, null, now(), null, now(), null);
-- INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846717306454016, 3846717305962496, '问题数量', 1, null, null, 0.05, null, now(), null, now(), null);
-- INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846717306454017, 3846717305962496, '风险等级为轻微的问题数量', 3, null, 2, 0.05, null, now(), null, now(), null);
-- INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846717306454018, 3846717305962496, '风险等级为关注的问题数量', 3, null, 1, 0.15, null, now(), null, now(), null);
-- INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846717306454019, 3846717305962496, '风险等级为一般的问题数量', 3, null, 3, 0.2, null, now(), null, now(), null);
-- INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846717306454020, 3846717305962496, '风险等级为重大的问题数量', 3, null, 5, 0.25, null, now(), null, now(), null);
-- INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846720301350912, 3846720300892160, ' 超期未整改问题数量', 3, null, 2, 1, null, now(), null, now(), null);
-- INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846720301350913, 3846720300892160, '两次整改问题数', 3, null, 3, 3, null, now(), null, now(), null);
-- INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846720301350914, 3846720300892160, '三次或三次以上整改问题数', 3, null, 4, 5, null, now(), null, now(), null);
-- INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846720301350915, 3846720300892160, '超期整改问题数', 3, null, 1, 0.6, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846721707180032, 3846721706754048, '超期整改问题数', 1, null, 1, 0.6, null, now(), null, now(), null);
-- INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846721707180033, 3846721706754048, '三次或三次以上整改问题数', 3, null, 4, 5, null, now(), null, now(), null);
-- INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846721707180034, 3846721706754048, '超期未整改问题数量', 3, null, 2, 1, null, now(), null, now(), null);
-- INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846721707180035, 3846721706754048, ' 两次整改问题数', 3, null, 3, 3, null, now(), null, now(), null);
-- INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846723149578240, 3846723149234176, '超期整改问题数', 3, null, 1, 0.6, null, now(), null, now(), null);
-- INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846723149578241, 3846723149234176, '三次或三次以上整改问题数', 3, null, 4, 5, null,now(), null, now(), null);
-- INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846723149578242, 3846723149234176, '超期未整改问题数量', 3, null, 2, 1, null, now(), null, now(), null);
-- INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846723149578243, 3846723149234176, '两次整改问题数', 3, null, 3, 3, null,now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846747145633792, 3846747145125888, '未登总数', 1, null, null, 0.5, 0, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846747145633793, 3846747145125888, '未登连续三天', 2, 3, null, 1, 0, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846747145633794, 3846747145125888, '未登连续五天', 2, 5, null, 3, 0, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846747145633795, 3846747145125888, '未登连续十天', 2, 10, null, 5, 0, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846751521964032, 3846751521619968, '未登天数', 1, null, null, 0.5, null,now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846751521964033, 3846751521619968, '未登连续三天', 2, 3, null, 2, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846751521964034, 3846751521619968, '未登连续五天', 2, 5, null, 3, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846751521964035, 3846751521619968, '未登连续十天', 2, 10, null, 5, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846752731742208, 3846752731185152, '未登天数', 1, null, null, 0.5, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846752731742209, 3846752731185152, '未登连续三天', 2, 3, null, 2, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846752731742210, 3846752731185152, '未登连续五天', 2, 5, null, 3, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (3846752731742211, 3846752731185152, ' 未登连续十天', 2, 10, null, 5, null, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1711273894279716865, 1711273894451683330, '风险等级为轻微的问题数量', 3, 3, null, 0.05, 0, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1711273894334242818, 1711273894451683330, '未登连续五天', 2, 5, null, 1.5, 0, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1714184891021721602, 3846745983598592, '未登总数', 1, null, null, 0.5, 0, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1714184891030110210, 3846745983598592, '连续三天未登', 2, 3, null, 1, 0, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1714184891034304513, 3846745983598592, '连续五天未登', 2, 5, null, 1, 0, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1714184891038498818, 3846745983598592, '连续十天未登', 2, 10, null, 1, 0, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1714185441075331073, 1714185441062748161, '未登总数', 1, null, null, 0.5, 0, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1714185441083719682, 1714185441062748161, '连续三天未登', 2, 3, null, 1, 0, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1714185441092108290, 1714185441062748161, '连续五天未登', 2, 5, null, 1, 0, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1714185441096302594, 1714185441062748161, '连续十天未登', 2, 10, null, 1, 0, now(), null, now(), null);
INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1717123345548406785, 1714172822255894529, '未登总数', 1, null, null, 0.5, 0, now(), null, now(), null);
-- INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1717123345560989697, 1714172822255894529, '连续三次未登', 2, 3, null, 1, 0, now(), null, now(), null);
-- INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1717123345565184002, 1714172822255894529, '连续五次未登', 2, 5, null, 1, 0, now(), null, now(), null);
-- INSERT ignore INTO core_safety_index_calculate_rule_item (id, rule_id, indicator_note, calculate_type, indicator_days, item_type, item_value, order_num, create_time, create_by, update_time, update_by) VALUES (1717123345569378306, 1714172822255894529, '连续十次未登', 2, 10, null, 1, 0, now(), null, now(), null);

delete from sys_menu where id in (1728960667819544578);
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 (1728960667819544578, '安保部门从业人员导出', 100, 10, '', null, null, 1, 0, 'F', '0', '0', 'system:user:exportSecurity', '1', null, null, null, now(), '', null, '');
delete from sys_role_menu where menu_id=1728960667819544578;
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (115, 1728960667819544578);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (116, 1728960667819544578);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (117, 1728960667819544578);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (118, 1728960667819544578);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (119, 1728960667819544578);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (120, 1728960667819544578);
-- 新增安保综合评价规则目录、菜单、页面及页面权限
delete from sys_menu where id in (1714247486990786561,1712277074707779586,1712278645189414914,1714187591810588674,1714187748136493058,1714187851295399937,1714188002965626881,1714188131026116609);
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 (1712277074707779586, '安全综合管理评价', 0, 13, '/safetyindex', null, null, 1, 0, 'M', '0', '0', '', '1', 'clipboard', null, null, now(), null, now(), '');
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 (1712278645189414914, '评价规则配置', 1712277074707779586, 1, 'evaluationRule', 'evaluationRule/index', null, 1, 1, 'C', '0', '0', 'core:safetyIndexRule:list', '1', 'table', null, null, now(), '', 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 (1714187591810588674, '综合评价规则新增', 1712278645189414914, 1, '', null, null, 1, 0, 'F', '0', '0', 'core:safetyIndexRule:add', '1', null, null, null, now(), '', 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 (1714187748136493058, '综合评价规则编辑', 1712278645189414914, 2, '', null, null, 1, 0, 'F', '0', '0', 'core:safetyIndexRule:edit', '1', null, null, null, now(), '', 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 (1714187851295399937, '综合评价规则详情', 1712278645189414914, 3, '', null, null, 1, 0, 'F', '0', '0', 'core:safetyIndexRule:query', '1', null, null, null, now(), '', 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 (1714188002965626881, '综合评价规则列表查询', 1712278645189414914, 4, '', null, null, 1, 0, 'F', '0', '0', 'core:safetyIndexRule:list', '1', null, null, null, now(), '', 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 (1714188131026116609, '综合评价规则删除', 1712278645189414914, 5, '', null, null, 1, 0, 'F', '0', '0', 'core:safetyIndexRule:remove', '1', null, null, null, now(), '', null, '');
-- 新增安保综合评价规则页面权限
delete from sys_role_menu where menu_id in (1712277074707779586,1712278645189414914,1714187591810588674,1714187748136493058,1714187851295399937,1714188002965626881,1714188131026116609);
insert into sys_role_menu select  id,1712277074707779586 from sys_role where role_name like '%省联社安全保卫管理人员%';
insert into sys_role_menu select  id,1712278645189414914 from sys_role where role_name like '%省联社安全保卫管理人员%';
insert into sys_role_menu select  id,1714187591810588674 from sys_role where role_name like '%省联社安全保卫管理人员%';
insert into sys_role_menu select  id,1714187748136493058 from sys_role where role_name like '%省联社安全保卫管理人员%';
insert into sys_role_menu select  id,1714187851295399937 from sys_role where role_name like '%省联社安全保卫管理人员%';
insert into sys_role_menu select  id,1714188002965626881 from sys_role where role_name like '%省联社安全保卫管理人员%';
insert into sys_role_menu select  id,1714188131026116609 from sys_role where role_name like '%省联社安全保卫管理人员%';

-- 新增风险等级字典
delete from sys_dict_type where dict_type='risk_level';
delete from sys_dict_data where dict_type='risk_level';
INSERT INTO sys_dict_type ( dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark) VALUES ('风险等级', 'risk_level', '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 ( 0, '低', '0', 'risk_level', 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 ( 1, '中', '1', 'risk_level', 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, '高', '2', 'risk_level', 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', 'risk_level', null, 'default', 'N', '0', null, now(), null, now(), null);

-- 安全等级初始化数据
INSERT ignore INTO core_safe_level (id, level_name, min_value, max_value, risk_level, description) VALUES (1, 'L1', 90, 100, 0, '90分(不含)以上');
INSERT ignore INTO core_safe_level (id, level_name, min_value, max_value, risk_level, description) VALUES (2, 'L2', 80, 90, 1, '80分(不含)与90分(含)之间 ');
INSERT ignore INTO core_safe_level (id, level_name, min_value, max_value, risk_level, description) VALUES (3, 'L3', 70, 80, 2, '70分(不含)与80分(含)之间');
INSERT ignore INTO core_safe_level (id, level_name, min_value, max_value, risk_level, description) VALUES (4, 'L4', 0, 70, 3, '70分及以下');

-- 新增安全等级菜单及页面权限
delete from sys_menu where id in (1717479664205783042,1717480807703076866,1717480976800636929,1717481080311865346,1717481175799390210,1717481251359776769);
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 (1717479664205783042, '安全等级配置', 1712277074707779586, 1, '/level', 'core/safeLevel/index', null, 1, 0, 'C', '0', '0', 'core.safeIndex:safeLevel:list', '1', 'button', null, null, now(), null, now(), 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 (1717480807703076866, '安全等级列表', 1717479664205783042, 1, '', null, null, 1, 0, 'F', '0', '0', 'core.safeIndex:safeLevel:list', '1', null, null, null, now(), null, now(), 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 (1717480976800636929, '安全等级详情', 1717479664205783042, 2, '', null, null, 1, 0, 'F', '0', '0', 'core.safetyIndex:safeLevel:query', '1', null, null, null, now(), null, now(), 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 (1717481080311865346, '安全等级新增', 1717479664205783042, 3, '', null, null, 1, 0, 'F', '0', '0', 'core.safetyIndex:safeLevel:add', '1', null, null, null, now(), null, now(), 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 (1717481175799390210, '安全等级编辑', 1717479664205783042, 4, '', null, null, 1, 0, 'F', '0', '0', 'core.safetyIndex:safeLevel:edit', '1', null, null,  null, now(), null, now(), 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 (1717481251359776769, '安全等级删除', 1717479664205783042, 5, '', null, null, 1, 0, 'F', '0', '0', 'core.safetyIndex:safeLevel:remove', '1', null, null, null, now(), null, now(), null);
-- 安全等级菜单权限
delete from sys_role_menu where menu_id in (1717479664205783042,1717480807703076866,1717480976800636929,1717481080311865346,1717481175799390210,1717481251359776769);
insert into sys_role_menu select  id,1717479664205783042 from sys_role where role_name like '%省联社安全保卫管理人员%';
insert into sys_role_menu select  id,1717480807703076866 from sys_role where role_name like '%省联社安全保卫管理人员%';
insert into sys_role_menu select  id,1717480976800636929 from sys_role where role_name like '%省联社安全保卫管理人员%';
insert into sys_role_menu select  id,1717481080311865346 from sys_role where role_name like '%省联社安全保卫管理人员%';
insert into sys_role_menu select  id,1717481175799390210 from sys_role where role_name like '%省联社安全保卫管理人员%';
insert into sys_role_menu select  id,1717481251359776769 from sys_role where role_name like '%省联社安全保卫管理人员%';

-- 新增综合计算得分菜单及菜单权限
delete from sys_menu where id in (1718909968666697730,1719970958288199682,1719986164527636481);
delete from sys_role_menu where menu_id in (1718909968666697730,1719970958288199682,1719986164527636481);
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 (1718909968666697730, '计算综合得分', 1712277074707779586, 3, 'scorestatistics', 'scorestatistics/index', null, 1, 1, 'C', '0', '0', 'core:safeMonthScore:list', '1', 'system', null,  null, now(), null, now(), 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 (1719970958288199682, '综合得分重新计算', 1718909968666697730, 1, '', null, null, 1, 0, 'F', '0', '0', 'core:safetyExceptionData:reCalculate', '1', null, null,  null, now(), null, now(), 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 (1719986164527636481, '综合得分指数分布', 1718909968666697730, 2, '', null, null, 1, 0, 'F', '0', '0', 'core:safeMonthScore:list', '1', null, null,  null, now(), null, now(), null);
insert into sys_role_menu select  id,1718909968666697730 from sys_role where org_type in (1,2,3);
insert into sys_role_menu select  id,1719970958288199682 from sys_role where org_type in (1,2,3);
insert into sys_role_menu select  id,1719986164527636481 from sys_role where org_type in (1,2,3);

-- 新增登记簿类型字典
delete from sys_dict_type where dict_type='register_book_type';
delete from sys_dict_data where dict_type='register_book_type';
INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark) VALUES ('登记簿类型', 'register_book_type', '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 (0, '安保履职登记簿', '0', 'register_book_type', 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 (1, '教育培训登记簿', '1', 'register_book_type', 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, '预案演练登记簿', '2', 'register_book_type', 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 (26, '安全检查登记簿', '26', 'register_book_type', null, 'default', 'N', '0', null, now(), null, now(), null);
-- 新增行政级别字典
delete from sys_dict_type where dict_type='administrative_level';
delete from sys_dict_data where dict_type='administrative_level';
INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark)
VALUES ('行政级别', 'administrative_level', '0', null, now(), null, now(), '省市县');
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', 'administrative_level', null, 'default', 'N', '0', '超级管理员', now(), '超级管理员', now(), '省级');
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', 'administrative_level', null, 'default', 'N', '0', '超级管理员', now(), '超级管理员', now(), '市级');
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', 'administrative_level', null, 'default', 'N', '0', '超级管理员', now(), '超级管理员', now(), '县级');
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', 'administrative_level', null, 'default', 'N', '0', '超级管理员', now(), '超级管理员', now(), '无');
ALTER TABLE  core_protection MODIFY COLUMN id bigint NOT NULL COMMENT '主键';
ALTER TABLE  core_protection MODIFY COLUMN create_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '创建人';
ALTER TABLE  core_protection MODIFY COLUMN update_by varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '修改人';

ALTER TABLE  core_protection_log MODIFY COLUMN id bigint NOT NULL COMMENT '主键';
ALTER TABLE  core_protection_log MODIFY COLUMN create_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '创建人';
ALTER TABLE  core_protection_log MODIFY COLUMN update_by varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '修改人';

ALTER TABLE  core_question MODIFY COLUMN id bigint NOT NULL COMMENT '主键';
ALTER TABLE  core_question MODIFY COLUMN create_time datetime NULL COMMENT '创建时间';
ALTER TABLE  core_question MODIFY COLUMN update_time datetime NULL COMMENT '修改时间';
ALTER TABLE  core_question MODIFY COLUMN create_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '创建人';
ALTER TABLE  core_question MODIFY COLUMN update_by varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '修改人';

ALTER TABLE  core_question_flow MODIFY COLUMN id bigint NOT NULL COMMENT '主键';

ALTER TABLE  core_resumption MODIFY COLUMN id bigint NOT NULL COMMENT '主键';
ALTER TABLE  core_resumption MODIFY COLUMN org_path varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '机构业务路径';
ALTER TABLE  core_resumption MODIFY COLUMN org_name varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '机构名称';
ALTER TABLE  core_resumption MODIFY COLUMN create_time datetime NULL COMMENT '创建时间';
ALTER TABLE  core_resumption MODIFY COLUMN update_time datetime NULL COMMENT '修改时间';
ALTER TABLE  core_resumption MODIFY COLUMN create_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '创建人';

ALTER TABLE  core_resumption_configuration MODIFY COLUMN create_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '创建人';
ALTER TABLE  core_resumption_configuration MODIFY COLUMN create_time datetime NULL COMMENT '创建时间';
ALTER TABLE  core_resumption_configuration MODIFY COLUMN update_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '修改人';
ALTER TABLE  core_resumption_configuration MODIFY COLUMN update_time datetime NULL COMMENT '修改时间';
ALTER TABLE  core_resumption_configuration MODIFY COLUMN del_flag varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' NULL COMMENT '删除标识';

ALTER TABLE  core_resumption_data MODIFY COLUMN id bigint DEFAULT 0 NOT NULL COMMENT '主键';

ALTER TABLE  core_resumption_data_nfc MODIFY COLUMN id bigint DEFAULT 0 NOT NULL COMMENT '主键';

ALTER TABLE  core_resumption_data_protection MODIFY COLUMN id bigint NOT NULL COMMENT '主键';

ALTER TABLE  core_resumption_data_remarkimg MODIFY COLUMN id bigint DEFAULT 0 NOT NULL COMMENT '主键';

ALTER TABLE  core_resumption_rule MODIFY COLUMN id bigint auto_increment NOT NULL COMMENT '主键';
ALTER TABLE  core_resumption_rule MODIFY COLUMN create_time datetime NULL COMMENT '创建时间';
ALTER TABLE  core_resumption_rule MODIFY COLUMN update_time datetime NULL COMMENT '修改时间';
ALTER TABLE  core_resumption_rule MODIFY COLUMN create_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '创建人';
ALTER TABLE  core_resumption_rule MODIFY COLUMN update_by varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '修改人';


ALTER TABLE  core_resumption_rule_item MODIFY COLUMN id bigint auto_increment NOT NULL COMMENT '主键';
ALTER TABLE  core_resumption_rule_item MODIFY COLUMN create_time datetime NULL COMMENT '创建时间';
ALTER TABLE  core_resumption_rule_item MODIFY COLUMN update_time datetime NULL COMMENT '更新时间';
ALTER TABLE  core_resumption_rule_item MODIFY COLUMN create_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '创建人';
ALTER TABLE  core_resumption_rule_item MODIFY COLUMN update_by varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '修改人';

ALTER TABLE  core_resumption_rule_point MODIFY COLUMN id bigint auto_increment NOT NULL COMMENT '主键';
ALTER TABLE  core_resumption_rule_point MODIFY COLUMN create_time datetime NULL COMMENT '创建时间';
ALTER TABLE  core_resumption_rule_point MODIFY COLUMN update_time datetime NULL COMMENT '修改时间';
ALTER TABLE  core_resumption_rule_point MODIFY COLUMN create_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '创建人';


ALTER TABLE  core_safe_month_score MODIFY COLUMN release_status int NULL COMMENT '评分状态';


ALTER TABLE  core_safecheck_plan MODIFY COLUMN create_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '创建人';
ALTER TABLE  core_safecheck_plan MODIFY COLUMN update_by varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '修改人';

ALTER TABLE  core_safecheck_plan_to_check_org MODIFY COLUMN create_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '创建人';
ALTER TABLE  core_safecheck_plan_to_check_org MODIFY COLUMN update_by varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '修改人';

ALTER TABLE  core_safecheck_plan_to_exec_org MODIFY COLUMN create_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '创建人';
ALTER TABLE  core_safecheck_plan_to_exec_org MODIFY COLUMN update_by varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '修改人';

ALTER TABLE  core_safecheck_plan_to_point MODIFY COLUMN create_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '创建人';
ALTER TABLE  core_safecheck_plan_to_point MODIFY COLUMN update_by varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '修改人';
ALTER TABLE  core_safecheck_plan_to_point MODIFY COLUMN required tinyint(1) NULL COMMENT '是否必填';

ALTER TABLE  core_safecheck_plan_to_role MODIFY COLUMN create_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '创建人';
ALTER TABLE  core_safecheck_plan_to_role MODIFY COLUMN update_by varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '更新人';


ALTER TABLE  core_safety_book MODIFY COLUMN id bigint auto_increment NOT NULL COMMENT '主键';

ALTER TABLE  core_safety_book_user MODIFY COLUMN id bigint auto_increment NOT NULL COMMENT '主键';

ALTER TABLE  core_safety_book_user_id MODIFY COLUMN id bigint auto_increment NOT NULL COMMENT '主键';


ALTER TABLE  core_safety_dict MODIFY COLUMN id int auto_increment NOT NULL COMMENT '主键';


alter table core_safety_exception_data modify id bigint auto_increment comment '主键';
alter table core_safety_exception_data auto_increment = 1;
ALTER TABLE  core_safety_exception_data MODIFY COLUMN create_time datetime DEFAULT CURRENT_TIMESTAMP  NULL COMMENT '创建时间';


ALTER TABLE  core_safety_index_calculate_rule MODIFY COLUMN id bigint DEFAULT 0 NOT NULL COMMENT '主键';
ALTER TABLE  core_safety_index_calculate_rule MODIFY COLUMN create_time datetime NULL COMMENT '创建时间';
ALTER TABLE  core_safety_index_calculate_rule MODIFY COLUMN create_by varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '创建人';
ALTER TABLE  core_safety_index_calculate_rule MODIFY COLUMN update_time datetime NULL COMMENT '更新时间';
ALTER TABLE  core_safety_index_calculate_rule MODIFY COLUMN update_by varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '修改人';


ALTER TABLE  core_safety_index_calculate_rule_item MODIFY COLUMN id bigint DEFAULT 0 NOT NULL COMMENT '主键';
ALTER TABLE  core_safety_index_calculate_rule_item MODIFY COLUMN create_time datetime NULL COMMENT '创建时间';
ALTER TABLE  core_safety_index_calculate_rule_item MODIFY COLUMN create_by varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '创建人';
ALTER TABLE  core_safety_index_calculate_rule_item MODIFY COLUMN update_time datetime NULL COMMENT '更新时间';
ALTER TABLE  core_safety_index_calculate_rule_item MODIFY COLUMN update_by varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '更新人';


ALTER TABLE  core_safety_task MODIFY COLUMN id bigint NOT NULL COMMENT '主键';
ALTER TABLE  core_safety_task MODIFY COLUMN create_time datetime NULL COMMENT '创建时间';
ALTER TABLE  core_safety_task MODIFY COLUMN update_time datetime NULL COMMENT '更新时间';
ALTER TABLE  core_safety_task MODIFY COLUMN create_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '创建人';
ALTER TABLE  core_safety_task MODIFY COLUMN update_by varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '修改人';

ALTER TABLE  core_safety_task_data MODIFY COLUMN id bigint DEFAULT 0 NOT NULL COMMENT '主键';
ALTER TABLE  core_safety_task_data_nfc MODIFY COLUMN id bigint DEFAULT 0 NOT NULL COMMENT '主键';

ALTER TABLE  core_safety_task_data_remark MODIFY COLUMN id bigint DEFAULT 0 NOT NULL COMMENT '主键';
ALTER TABLE  core_safety_task_data_remarkimg MODIFY COLUMN id bigint DEFAULT 0 NOT NULL COMMENT '主键';

ALTER TABLE  core_safetycheck_rule MODIFY COLUMN id bigint auto_increment NOT NULL COMMENT '主键';
ALTER TABLE  core_safetycheck_rule MODIFY COLUMN create_time datetime NULL COMMENT '创建时间';
ALTER TABLE  core_safetycheck_rule MODIFY COLUMN update_time datetime NULL COMMENT '更新时间';
ALTER TABLE  core_safetycheck_rule MODIFY COLUMN create_by varchar(255) CHARACTER SET utf8mb4;
-- 修改演练任务表状态字段释义
alter table core_drill_task  modify status int default 0 null comment '任务状态:0:待登记,5:待提交,1:待签名,2待评价,3:已完成,4:已逾期';
alter table core_drill_dictionary modify drill_type varchar(12) null comment '演练项目,字典表关联取值';
alter table core_drill_dictionary modify drill_type_name varchar(32) null comment '演练项目名称';
alter table core_drill_task modify comment varchar(2000) null comment '点评总结(登记人自评)';
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 = 'core_resumption' AND COLUMN_NAME = 'times' ) THEN
ALTER TABLE `core_resumption`
    ADD COLUMN `times` smallint NULL COMMENT '第几次' AFTER `role_id`;
END IF;

		-- 履职表增加提交人
	IF
NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema = DATABASE () and TABLE_NAME = 'core_resumption' AND COLUMN_NAME = 'submitor_id' ) THEN
ALTER TABLE `soc`.`core_resumption`
    ADD COLUMN `submitor_id` bigint NULL COMMENT '提交人id' AFTER `submit_time`,
			ADD COLUMN `submitor_name` varchar(32) NULL COMMENT '提交人姓名' AFTER `submitor_id`;
END IF;
		-- 人员补充信息表增加金融安全防范工程专家
	IF
NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema = DATABASE () and TABLE_NAME = 'sys_user_information' AND COLUMN_NAME = 'financial_experts' ) THEN
ALTER TABLE `sys_user_information`
    ADD COLUMN `financial_experts`varchar(32) NULL COMMENT '金融安全防范工程专家';
END IF;
	-- 机构扩展添加字段
    IF
NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema = DATABASE () and TABLE_NAME = 'sys_org_extend' AND COLUMN_NAME = 'remote_count' ) THEN
ALTER TABLE `sys_org_extend`
    ADD COLUMN `remote_count` int NULL COMMENT '业务库防控隔离门出入口数量';
END IF;
    IF
NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema = DATABASE () and TABLE_NAME = 'sys_org_extend' AND COLUMN_NAME = 'cash_adding_room' ) THEN
ALTER TABLE `sys_org_extend`
    ADD COLUMN `cash_adding_room` int NULL COMMENT '离行式加钞间出入口数量';
END IF;
    IF
NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema = DATABASE () and TABLE_NAME = 'sys_org_extend' AND COLUMN_NAME = 'safe_box' ) THEN
ALTER TABLE `sys_org_extend`
    ADD COLUMN `safe_box` int NULL COMMENT '是否设立保管箱库';
END IF;
    IF
NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema = DATABASE () and TABLE_NAME = 'sys_org_extend' AND COLUMN_NAME = 'inner_count' ) THEN
ALTER TABLE `sys_org_extend`
    ADD COLUMN `inner_count` int NULL COMMENT '内部保安人数';
END IF;
    IF
NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema = DATABASE () and TABLE_NAME = 'sys_org_extend' AND COLUMN_NAME = 'outside_count' ) THEN
ALTER TABLE `sys_org_extend`
    ADD COLUMN `outside_count` int NULL COMMENT '外聘保安人数';
END IF;
	IF
NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema = DATABASE () and TABLE_NAME = 'core_protection' AND COLUMN_NAME = 'status_updator_id' ) THEN
ALTER TABLE `core_protection`
    ADD COLUMN `status_updator_id` bigint NULL DEFAULT NULL COMMENT '上报人id' AFTER `status_update_time`,
			ADD COLUMN `status_updator_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '上报人姓名' AFTER `status_updator_id`;
END IF;

    -- 安全指数机构分数表增加机构名称字段
    IF NOT EXISTS(SELECT *
                  FROM information_schema.columns
                  WHERE table_schema = DATABASE()
                    AND table_name = 'core_safe_month_score'
                    AND column_name = 'org_name') THEN
alter table core_safe_month_score
    add org_name varchar(125) null comment '机构名称' after org_id;
END IF;

    -- 安全指数机构扣分细项表增加机构名称字段
    IF NOT EXISTS(SELECT *
                  FROM information_schema.columns
                  WHERE table_schema = DATABASE()
                    AND table_name = 'core_safety_source_data'
                    AND column_name = 'org_name') THEN

alter table core_safety_source_data
    add org_name varchar(225) null comment '机构名称' after org_id;

alter table core_safety_source_data
    add org_path varchar(225) null comment '机构path' after org_name;

END IF;

    -- 安全指数扣分表增加机构名称字段
    IF NOT EXISTS(SELECT *
                  FROM information_schema.columns
                  WHERE table_schema = DATABASE()
                    AND table_name = 'core_safety_deduct_data'
                    AND column_name = 'org_name') THEN

alter table core_safety_deduct_data
    add org_name varchar(225) null comment '机构名称' after org_id;

alter table core_safety_deduct_data
    add org_path varchar(225) null comment '机构path' after org_name;

END IF;

    -- 安全指数异常数据表增加机构名称字段
    IF NOT EXISTS(SELECT *
                  FROM information_schema.columns
                  WHERE table_schema = DATABASE()
                    AND table_name = 'core_safety_exception_data'
                    AND column_name = 'org_name') THEN

alter table core_safety_exception_data
    add org_name varchar(225) null comment '机构名称' after org_id;

alter table core_safety_exception_data
    add org_path varchar(225) null comment '机构path' after org_name;

END IF;

    -- 安全指数机构分数表增加索引
    IF EXISTS(SELECT *
                  FROM information_schema.STATISTICS
                  WHERE table_schema = DATABASE()
                    AND table_name = 'core_safe_month_score'
                    AND INDEX_NAME = 'idx_year_month') THEN
drop index idx_orgId on core_safe_month_score;
drop index idx_year_month on core_safe_month_score;

create unique index idx_orgId_year_month on core_safe_month_score (org_id, data_year, data_month) comment '机构id+年+月';
END IF;


    -- 调阅计划加所属机构
    IF NOT EXISTS(SELECT *
                  FROM information_schema.columns
                  WHERE table_schema = DATABASE()
                    AND table_name = 'core_monitoring_retrieval_plan'
                    AND column_name = 'organization') THEN
alter table core_monitoring_retrieval_plan
    add organization varchar(255) DEFAULT NULL COMMENT '所属机构';
END IF;

    -- 履职添加pdf
    IF NOT EXISTS(SELECT *
                  FROM information_schema.columns
                  WHERE table_schema = DATABASE()
                    AND table_name = 'core_resumption_plan'
                    AND column_name = 'pdf_url') THEN
alter table core_resumption_plan
    add pdf_url varchar(255) DEFAULT NULL COMMENT 'pdf下载地址';
END IF;

    -- 作息添加是否值班打卡
    IF NOT EXISTS(SELECT *
                  FROM information_schema.columns
                  WHERE table_schema = DATABASE()
                    AND table_name = 'sys_work_time'
                    AND column_name = 'is_duty') THEN
alter table sys_work_time
    add is_duty int  NULL COMMENT '是否值班打卡';
END IF;
    IF NOT EXISTS(SELECT *
                  FROM information_schema.columns
                  WHERE table_schema = DATABASE()
                    AND table_name = 'sys_work_time_set_dayofweek'
                    AND column_name = 'is_duty') THEN
alter table sys_work_time_set_dayofweek
    add is_duty int  NULL COMMENT '是否值班打卡';
END IF;
    -- 演练范本库表增加演练类型字段
    IF NOT EXISTS(SELECT *
                  FROM information_schema.columns
                  WHERE table_schema = DATABASE()
                    AND table_name = 'core_drill_dictionary'
                    AND column_name = 'drill_category') THEN
alter table core_drill_dictionary
    add drill_category int null comment '演练类型,字典表取值' after drill_type_name;

alter table core_drill_dictionary
    add drill_category_name varchar(125) null comment '演练类型名称' after drill_category;
END IF;

    -- 履职计划增加是否有任务已经完成
    IF NOT EXISTS(SELECT *
                  FROM information_schema.columns
                  WHERE table_schema = DATABASE()
                    AND table_name = 'core_resumption_plan'
                    AND column_name = 'task_has_completed') THEN
ALTER TABLE `core_resumption_plan`
    ADD COLUMN `task_has_completed` int NULL COMMENT '1：表示有已完成的任务';
END IF;

    -- 履职内容增加生效日期
    IF NOT 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`
    ADD COLUMN `effective_date` date NULL COMMENT '生效日期。不为null';
UPDATE core_resumption_plan_to_point set effective_date='2000-01-01';
END IF;


       IF NOT EXISTS(SELECT *
                  FROM information_schema.columns
                  WHERE table_schema = DATABASE()
                    AND table_name = 'sys_org_physical_defense_construction'
                    AND column_name = 'date_of_complete') THEN
ALTER TABLE `sys_org_physical_defense_construction`
    ADD COLUMN `date_of_complete` datetime NULL DEFAULT NULL COMMENT '计划达标日期';
END IF;

    IF NOT EXISTS(SELECT *
                  FROM information_schema.columns
                  WHERE table_schema = DATABASE()
                    AND table_name = 'sys_org_physical_defense_construction'
                    AND column_name = 'reason') THEN
ALTER TABLE `sys_org_physical_defense_construction`
    ADD COLUMN `reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '未达标原因';
END IF;

	-- 培训计划表新增字段 培训类型
    IF NOT EXISTS(SELECT *
                  FROM information_schema.columns
                  WHERE table_schema = DATABASE()
                    AND table_name = 'core_edu_training_plan'
                    AND column_name = 'type') THEN
alter table core_edu_training_plan
    add type int default 0 not null comment '培训类型,0:行社安全保卫教育培训,1:行社消防安全培训,2:营业网点安全保卫教育培训,3:营业网点消防安全培训,4:其他' after id;
END IF;

    -- 演练计划表新增字段 演练类型
    IF NOT EXISTS(SELECT *
                  FROM information_schema.columns
                  WHERE table_schema = DATABASE()
                    AND table_name = 'core_drill_plan'
                    AND column_name = 'category') THEN
alter table core_drill_plan
    add category int default 0 not null comment '演练类型,0:应急预案演练,1:灭火和应急疏散预案演练,2:其他' after id;
END IF;

    -- 演练任务表新增字段 演练类型
    IF NOT EXISTS(SELECT *
                  FROM information_schema.columns
                  WHERE table_schema = DATABASE()
                    AND table_name = 'core_drill_task'
                    AND column_name = 'category') THEN
alter table core_drill_task
    add category int default 0 not null comment '演练类型,0:应急预案演练,1:灭火和应急疏散预案演练,2:其他' after id;
-- 修改表字段释义
alter table core_drill_task
    modify type int null comment '演练项目';
END IF;

    -- 隐患问题增加来源任务的任务类型字段
    IF NOT EXISTS(SELECT *
                  FROM information_schema.columns
                  WHERE table_schema = DATABASE()
                    AND table_name = 'core_question'
                    AND column_name = 'src_task_type') THEN
ALTER TABLE `core_question`
    ADD COLUMN `src_task_type` int NULL COMMENT '来源任务的任务类型' AFTER `src_type`;
update core_question set src_task_type=(SELECT p.plan_type FROM core_resumption r INNER JOIN core_resumption_plan p on r.plan_id=p.id WHERE r.id=core_question.src_task_id) WHERE src_task_type is null and src_type=1;
update core_question set src_task_type=(SELECT p.check_type FROM core_safety_task r INNER JOIN core_safecheck_plan p on r.plan_id=p.id WHERE r.id=core_question.src_task_id) WHERE src_task_type is null and src_type=2;
END IF;


END ??
DELIMITER;
CALL schema_change ();

UPDATE sys_menu SET menu_name='设备登记管理' WHERE id=2050;

UPDATE sys_menu SET menu_name='监控调阅' WHERE id=2076;
UPDATE sys_menu SET menu_name='调阅任务下发' WHERE id=2052;

update sys_menu set menu_name='调阅情况跟踪' where menu_name='监控调阅任务管理';
-- 教育培训菜单名称变更
update sys_menu set menu_name='教育培训' where menu_name='教育培训管理' limit 1;
update sys_menu set menu_name='培训任务下发' where menu_name='培训计划管理' limit 1;
UPDATE sys_menu t SET t.menu_name = '教育培训任务新增' WHERE t.menu_name = '教育培训计划新增' limit 1;
UPDATE sys_menu t SET t.menu_name = '教育培训任务修改' WHERE t.menu_name = '教育培训计划修改' limit 1;
UPDATE sys_menu t SET t.menu_name = '教育培训任务删除' WHERE t.menu_name = '教育培训计划删除' limit 1;
UPDATE sys_menu t SET t.menu_name = '教育培训任务下发' WHERE t.menu_name = '教育培训计划下发' limit 1;
UPDATE sys_menu t SET t.menu_name = '教育培训任务查询' WHERE t.menu_name = '教育培训计划查询' limit 1;
UPDATE sys_menu t SET t.menu_name = '教育培训任务导出' WHERE t.menu_name = '教育培训计划导出' limit 1;
update sys_menu set menu_name='培训登记跟踪' where menu_name='培训任务管理' limit 1;
-- 培训计划菜单名称修改
update sys_menu set menu_name ='培训登记查询' where perms='core:eduTask:list' and menu_name='查询' limit 1;
update sys_menu set menu_name ='培训登记新增' where perms='core:eduTask:add' and menu_name='新增' limit 1;
update sys_menu set menu_name ='培训登记编辑' where perms='core:eduTask:edit' and menu_name='编辑' limit 1;
update sys_menu set menu_name ='培训登记删除' where perms='core:eduTask:remove' and menu_name='删除' limit 1;
update sys_menu set menu_name ='培训登记导出' where perms='core:eduTask:export' and menu_name='导出' limit 1;

-- 布撤防菜单名称修改
update sys_menu set `menu_name`='履职情况跟踪' WHERE  `menu_name`='履职情况查询';
update sys_menu set `menu_name`='布撤防情况跟踪',parent_id=2000 WHERE  `menu_name`='布撤防状态监管';
-- 履职/安全检查菜单变更
UPDATE `sys_menu` SET `menu_name` = '履职任务下发' WHERE menu_name='履职计划管理';
UPDATE `sys_menu` SET `menu_name` = '检查任务下发' WHERE menu_name='检查计划管理';
UPDATE `sys_menu` SET `menu_name` = '检查登记跟踪' WHERE menu_name='检查任务管理';
UPDATE `sys_menu` SET `menu_name` = '日常履职' WHERE menu_name='日常安全履职';
UPDATE `sys_menu` SET `menu_name` = '安全检查' WHERE menu_name='安全检查管理';
UPDATE `sys_menu` SET `menu_name` = '基础信息' WHERE menu_name='安保基础信息';

-- 增加整改情况跟踪菜单
DELETE FROM `sys_menu` WHERE id in (1719662219582926849,1719663201104588802,2355);
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 (01719662219582926849, '整改情况跟踪', 2350, 2, 'reform', 'question/reform/index', NULL, 1, 0, 'C', '0', '0', 'question:reform', '1', 'post', NULL, 'jwx', '2023-11-01 18:27:01', '', 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 (01719663201104588802, '查询', 1719662219582926849, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'question:reform:query', '1', NULL, NULL, '超级管理员', '2023-11-01 18:30:55', '', 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 (00000000000000002355, '整改', 1719662219582926849, 2, '', NULL, NULL, 1, 0, 'F', '0', '0', 'question:reform:reform', '1', '#', NULL, '超级管理员', '2023-09-23 16:30:16', '超级管理员', '2023-11-01 18:31:21', '');
-- 安全检查字典变更
DELETE FROM `sys_dict_data` WHERE `dict_type`='safety_check_status';
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', 'safety_check_status', NULL, 'default', 'N', '0', '超级管理员', '2023-09-21 10:44:18', '', 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 ( 2, '进行中', '2', 'safety_check_status', NULL, 'default', 'N', '0', '超级管理员', '2023-09-21 10:44:29', '', 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', 'safety_check_status', NULL, 'default', 'N', '0', '超级管理员', '2023-09-21 10:44:36', '省联社账号', '2023-11-03 10:53:52', 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, '已逾期', '4', 'safety_check_status', NULL, 'default', 'N', '0', '超级管理员', '2023-09-21 10:44:43', '', NULL, NULL);



-- 机构类型字典变更
DELETE FROM `sys_dict_data` WHERE `dict_type`='sys_org_type';
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 ( 900, '省联社', '1', 'sys_org_type', NULL, 'default', 'N', '0', '何悦', '2023-08-16 17:51:17', '何悦', '2023-08-24 10:35:12', 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 ( 800, '办事处', '2', 'sys_org_type', NULL, 'default', 'N', '0', '何悦', '2023-08-16 17:51:38', '超级管理员', '2023-09-05 14:55:20', 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 ( 200, '行社', '3', 'sys_org_type', NULL, 'default', 'N', '0', '何悦', '2023-08-16 17:52:01', '超级管理员', '2023-09-15 18:10:38', 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 ( 100, '营业网点', '4', 'sys_org_type', NULL, 'default', 'N', '0', '何悦', '2023-08-16 17:52:13', '超级管理员', '2023-09-15 18:15:21', 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 ( 300, '离行式自助银行', '5', 'sys_org_type', NULL, 'default', 'N', '0', '何悦', '2023-08-16 17:52:41', '超级管理员', '2023-09-15 18:15:35', 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 ( 600, '中心业务库', '6', 'sys_org_type', NULL, 'default', 'N', '0', '何悦', '2023-08-16 17:52:59', '省联社账号', '2023-11-01 10:42:56', 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 ( 700, '监控中心', '10', 'sys_org_type', NULL, 'default', 'N', '0', '何悦', '2023-08-16 17:53:46', '省联社账号', '2023-11-01 10:43:10', 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 ( 500, '网点业务库', '8', 'sys_org_type', NULL, 'default', 'N', '0', '超级管理员', '2023-09-12 19:57:55', '超级管理员', '2023-09-15 18:18:44', 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 ( 400, '保管箱库', '7', 'sys_org_type', NULL, 'default', 'N', '0', '超级管理员', '2023-09-15 17:10: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 ( 1000, '其他', '9', 'sys_org_type', NULL, 'default', 'N', '0', '超级管理员', '2023-09-17 00:13:26', '超级管理员', '2023-09-17 00:13:37', NULL);
DELETE FROM `sys_dict_data` WHERE `dict_type`='org_platform_brand';
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', 'org_platform_brand', NULL, 'default', 'N', '0', '超级管理员', '2023-09-04 15:25:09', '省联社账号', '2023-11-01 10:44:47', 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, '恒通', '2', 'org_platform_brand', NULL, 'default', 'N', '0', '超级管理员', '2023-09-04 15:25:18', '省联社账号', '2023-11-01 10:44:53', 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_platform_brand', NULL, 'default', 'N', '0', '超级管理员', '2023-09-04 15:25:25', '省联社账号', '2023-11-01 10:45:01', 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, '天跃', '4', 'org_platform_brand', NULL, 'default', 'N', '0', '超级管理员', '2023-09-04 15:25:34', '省联社账号', '2023-11-01 10:45:18', 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', 'org_platform_brand', NULL, 'default', 'N', '0', '超级管理员', '2023-09-04 15:25:43', '省联社账号', '2023-11-01 10:45:26', NULL);

-- 预案演练菜单名称变更
UPDATE sys_menu set menu_name ='预案演练' WHERE menu_name ='预案演练管理';
UPDATE sys_menu set menu_name ='演练范本管理' WHERE menu_name ='演练库管理';
UPDATE sys_menu set menu_name ='演练范本新增' WHERE menu_name ='演练库新增';
UPDATE sys_menu set menu_name ='演练范本查询' WHERE menu_name ='演练库查询';
UPDATE sys_menu set menu_name ='演练范本编辑' WHERE menu_name ='演练库编辑';
UPDATE sys_menu set menu_name ='演练范本详情' WHERE menu_name ='演练库详情';
UPDATE sys_menu set menu_name ='演练范本删除' WHERE menu_name ='演练库删除';
-- 演练计划
UPDATE sys_menu set menu_name ='演练任务下发' WHERE menu_name ='演练计划管理';
UPDATE sys_menu set menu_name ='演练任务新增' WHERE menu_name ='演练计划新增';
UPDATE sys_menu set menu_name ='演练任务列表' WHERE menu_name ='演练计划列表';
UPDATE sys_menu set menu_name ='演练任务下发' WHERE menu_name ='演练计划下发';
UPDATE sys_menu set menu_name ='演练任务编辑' WHERE menu_name ='演练计划编辑';
UPDATE sys_menu set menu_name ='演练任务删除' WHERE menu_name ='演练计划删除';
UPDATE sys_menu set menu_name ='演练任务详情' WHERE menu_name ='演练计划详情';

UPDATE sys_menu set menu_name ='演练登记跟踪' WHERE menu_name ='演练任务管理';
UPDATE sys_dict_data set dict_label ='待登记' WHERE dict_label ='待演练' AND dict_type='drill_task_status';

update sys_menu set menu_name='演练登记编辑' where perms ='core:drillTask:edit' and menu_name ='演练任务登记' limit 1;
update sys_menu set menu_name='演练登记详情' where perms ='core:drillTask:query' and menu_name ='演练任务详情' limit 1;
update sys_menu set menu_name='演练登记签名' where perms ='core:drillTask:sign' and menu_name ='演练任务签名' limit 1;
update sys_menu set menu_name='演练登记评价' where perms ='core:drillTask:evaluate' and menu_name ='演练任务评价' limit 1;
update sys_menu set menu_name='演练登记删除' where perms ='core:drillTask:remove' and menu_name ='演练任务删除' limit 1;
-- 演练任务
-- 新增演练任务删除按钮菜单及权限赋予
delete from sys_menu where id=1721426177600598018;
delete from sys_role_menu where menu_id=1721426177600598018;
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 (1721426177600598018, '演练任务删除', 2322, 5, '', null, null, 1, 0, 'F', '0', '0', 'core:drillTask:remove', '1', null, null, null, now(), null, now(), null);
insert into sys_role_menu(role_id, menu_id)
select r.id,m.id
from sys_role r ,sys_menu m
where m.menu_name ='演练任务删除' and  m.perms='core:drillTask:remove';
-- 修改字典名称
update sys_dict_type  SET dict_name = '预案演练项目' WHERE dict_name = '预案演练类型' and dict_type='core_drill_type' limit 1;
-- 新增演练类型字典
delete  from sys_dict_type where dict_type='core_drill_category';
delete  from sys_dict_data where dict_type='core_drill_category';
INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark) VALUES ('预案演练类型', 'core_drill_category', '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, '应急预案演练', '0', 'core_drill_category', 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 (20, '灭火和应急疏散预案演练', '1', 'core_drill_category', 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 (30, '其他', '2', 'core_drill_category', null, 'default', 'N', '0',  null, now(), null, now(), null);

-- 修改演练项目字典值
delete from sys_dict_data where  dict_type='core_drill_type';
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', 'core_drill_type', NULL, 'default', 'N', '0', '超级管理员', '2023-09-06 15:22: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 (2, '防盗应急预案', '2', 'core_drill_type', NULL, 'default', 'N', '0', '超级管理员', '2023-09-06 15:22: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 (3, '反诈应急预案', '3', 'core_drill_type', NULL, 'default', 'N', '0', '超级管理员', '2023-09-06 15:22: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 (4, '消防及疏散应急预案', '4', 'core_drill_type', NULL, 'default', 'N', '0', '超级管理员', '2023-09-06 15:22: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, '防自然灾害应急预案', '6', 'core_drill_type', NULL, 'default', 'N', '0', '超级管理员', '2023-09-06 15:22:23', '超级管理员', '2023-11-21 16:49:57', 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 (7, '其它应急预案', '7', 'core_drill_type', NULL, 'default', 'N', '0', '超级管理员', '2023-11-16 11:42:24', '超级管理员', '2023-11-21 16:50:07', 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', 'core_drill_type', NULL, 'default', 'N', '0', '超级管理员', '2023-11-21 16:46:54', '', NULL, NULL);

-- 报警控制器
ALTER TABLE `core_protection_log`
    MODIFY COLUMN `status_updator_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '上报人姓名' AFTER `status_updator_id`;
-- 修改安全指数机构分数表机构path字段长度
alter table core_safe_month_score modify org_path varchar(225) null comment '机构path';
DELETE FROM sys_menu WHERE id IN(01724607752400044034,01723993298998222849,01719287834364436482,01719288533101928450,01719892877586239490,01720000571298115585,1722135552494403586,01722523915868221442,01724355771043504129,01726904309791121409);
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 (01719287834364436482, '统计报表', 0, 1, 'reportForms', NULL, NULL, 1, 0, 'M', '0', '0', null, '1', 'chart', NULL, '超级管理员', '2023-09-21 10:37:52', '超级管理员', '2023-09-22 09:42:43', '');
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 (01719288533101928450, '行社全面检查统计报表', 1719287834364436482, 1, 'core/reportForms', 'core/reportForms/safetyInspectReport', NULL, 1, 1, 'C', '0', '0', 'core:safetyInspectReport:list', '1', 'chart', NULL, '超级管理员', '2023-09-21 10:37:52', '超级管理员', '2023-09-22 09:42:43', '');
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:safetyInspectReport:list', '1', 'chart', NULL, '超级管理员', '2023-09-21 10:37:52', '超级管理员', '2023-09-22 09:42:43', '');
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 (01720000571298115585, '监控调阅统计报表', 1719287834364436482, 3, 'core', 'core/reportForms/monitorAccessReport', NULL, 1, 1, 'C', '0', '0', 'core:monitorAccessReport:list', '1', 'chart', NULL, '超级管理员', '2023-09-21 10:37:52', '超级管理员', '2023-09-22 09:42:43', '');
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 (01722523915868221442, '履职报表', 1719287834364436482, 5, '/core/resumptionReport', 'core/reportForms/resumptionReport', NULL, 1, 1, 'C', '0', '0', 'core:resumptionReport:list', '1', 'chart', NULL, '超级管理员', '2023-09-21 10:37:52', '超级管理员', '2023-09-22 09:42:43', '');
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 (01723993298998222849, '报警测试报表', 1719287834364436482, 6, '/resumptionReport/intrusionTest', 'core/reportForms/intrusionTestReport', NULL, 1, 1, 'C', '0', '0', 'core:resumptionReport:list', '1', 'chart', NULL, '超级管理员', '2023-09-21 10:37:52', '超级管理员', '2023-09-22 09:42:43', '');
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 (01724607752400044034, '备用电源维护报表', 1719287834364436482, 7, '/resumptionReport/standbyPower', 'core/reportForms/standbyPowerReport', NULL, 1, 1, 'C', '0', '0', 'core:resumptionReport:list', '1', 'chart', NULL, '超级管理员', '2023-09-21 10:37:52', '超级管理员', '2023-09-22 09:42:43', '');
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 (01724355771043504129, '离行式自助银行巡检报表', 1719287834364436482, 7, '/resumptionReport/serviceBank', 'core/reportForms/serviceBankReport', NULL, 1, 1, 'C', '0', '0', 'core:resumptionReport:list', '1', 'chart', NULL, '超级管理员', '2023-09-21 10:37:52', '超级管理员', '2023-09-22 09:42:43', '');

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 (01726904309791121409, '网点负责人自查报表', 1719287834364436482, 9, '/core/safetyInspectReport/selfInspectList', 'core/reportForms/selfInspectReport', NULL, 1, 1, 'C', '0', '0', 'core:safetyInspectReport:list', '1', 'chart', NULL, '超级管理员', '2023-09-21 10:37:52', '超级管理员', '2023-09-22 09:42:43', '');

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 (1722135552494403586, '登记簿批量导出', 1719287834364436482, 10, 'code/registerbook', 'registerBook/index', null, 1, 0, 'C', '0', '0', 'core:registerBook:list', '1', 'education', null, null, now(), null, now(), null);

delete from sys_role_menu where menu_id IN(01726904309791121409,01724355771043504129,01723993298998222849,01722523915868221442,01719287834364436482,01719288533101928450,01719892877586239490,01720000571298115585,01724607752400044034);

INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (116, 01726904309791121409);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (120, 01726904309791121409);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (121, 01726904309791121409);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (122, 01726904309791121409);

INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (116, 01724355771043504129);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (120, 01724355771043504129);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (121, 01724355771043504129);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (122, 01724355771043504129);

INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (116, 01724607752400044034);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (120, 01724607752400044034);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (121, 01724607752400044034);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (122, 01724607752400044034);

INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (116, 01723993298998222849);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (120, 01723993298998222849);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (121, 01723993298998222849);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (122, 01723993298998222849);

INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (116, 01720000571298115585);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (120, 01720000571298115585);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (121, 01720000571298115585);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (122, 01720000571298115585);

INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (116, 01722523915868221442);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (120, 01722523915868221442);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (121, 01722523915868221442);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (122, 01722523915868221442);


INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (116, 01719287834364436482);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (120, 01719287834364436482);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (121, 01719287834364436482);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (122, 01719287834364436482);

INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (116, 01719288533101928450);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (120, 01719288533101928450);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (121, 01719288533101928450);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (122, 01719288533101928450);

INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (116, 01719892877586239490);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (120, 01719892877586239490);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (121, 01719892877586239490);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (122, 01719892877586239490);
delete from sys_menu where id =1730138955887800321;
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 (1730138955887800321, '导出', 1719288533101928450, 1, '', null, NULL, 1, 0, 'F', '0', '0', 'core:safetyInspectReport:export', '1', NULL, NULL, '超级管理员', '2023-09-21 10:37:52', '超级管理员', '2023-09-22 09:42:43', '');
delete from sys_role_menu where menu_id =1730138955887800321;
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (116, 1730138955887800321);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (120, 1730138955887800321);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (121, 1730138955887800321);
INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (122, 1730138955887800321);
-- 登记簿批量导出菜单权限赋予
delete from sys_role_menu where menu_id =1722135552494403586;
insert into sys_role_menu select id,1722135552494403586 from sys_role where org_type in (1,2,3,4) and del_flag=0 and status=0;

-- 新增省联社角色
delete from sys_role where role_name IN('省联社部门管理层');
INSERT INTO `sys_role` VALUES (114, '1', '省联社部门管理层', 'default', 0, 1, 1, 1, '0', 0, '超级管理员', '2023-09-04 09:39:13', '超级管理员', '2023-09-16 23:57:16', NULL);
-- 新增驾驶舱
DELETE from `sys_menu` WHERE `id`=01720394197110317057;
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 (01720394197110317057, '驾驶舱', 0, 1, 'board', 'board/index', NULL, 1, 0, 'C', '0', '0', '', '1', 'chart', NULL, '超级管理员', '2023-11-03 18:55:39', '超级管理员', '2023-11-03 18:56:17', '');

-- 新增临时登记按钮
DELETE from `sys_menu` WHERE `id`=01721420669971296258;
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 (01721420669971296258, '临时登记', 2318, 7, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:safetycheck:tempregister', '1', NULL, NULL, '超级管理员', '2023-11-06 14:54:29', '', NULL, '');

DELETE from `sys_role_menu` WHERE `menu_id`=1720394197110317057;
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (114, 1720394197110317057);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (115, 1720394197110317057);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (116, 1720394197110317057);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (117, 1720394197110317057);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (118, 1720394197110317057);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (119, 1720394197110317057);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (120, 1720394197110317057);


-- 同步机构 特殊机构移动配置数据
DELETE FROM `sync_fjnx_org_move` WHERE id IN (1,2,3,4);
INSERT INTO `sync_fjnx_org_move` (`id`, `org_code`, `org_type`) VALUES (1, '910020000', 1);
INSERT INTO `sync_fjnx_org_move` (`id`, `org_code`, `org_type`) VALUES (2, '910040000', 1);
INSERT INTO `sync_fjnx_org_move` (`id`, `org_code`, `org_type`) VALUES (3, '910060000', 1);
INSERT INTO `sync_fjnx_org_move` (`id`, `org_code`, `org_type`) VALUES (4, '910030000', 1);

-- 同步机构 业务机构层级配置数据
DELETE FROM `sync_fjnx_org_business_relation` WHERE id <=19;
INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (1, 'M39000000', 'M31000000', 'C900000000', 3, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (2, 'M42000000', 'M33000000', 'C900000000', 3, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (3, 'M43000000', 'M34000000', 'C900000000', 3, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (5, 'M45000000', 'M36000000', 'C900000000', 3, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (6, 'M46000000', 'M37000000', 'C900000000', 3, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (7, 'M47000000', 'M38000000', 'C900000000', 3, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (8, '900000000', 'C900000000', 'C900000000', 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (9, 'M40000000', '900000000', 'C900000000', 3, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (10, 'M44000000', '900000000', 'C900000000', 3, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (11, 'M31000000', NULL, NULL, 2, 'M39000000', NULL, NULL, NULL, NULL);
INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (12, 'M32000000', NULL, NULL, 2, 'M41000000', NULL, NULL, NULL, NULL);
INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (13, 'M33000000', NULL, NULL, 2, 'M42000000', NULL, NULL, NULL, NULL);
INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (14, 'M34000000', NULL, NULL, 2, 'M43000000', NULL, NULL, NULL, NULL);
INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (15, 'M35000000', NULL, NULL, 2, 'M39000000', NULL, NULL, NULL, NULL);
INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (16, 'M36000000', NULL, NULL, 2, 'M45000000', NULL, NULL, NULL, NULL);
INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (17, 'M37000000', NULL, NULL, 2, 'M46000000', NULL, NULL, NULL, NULL);
INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (18, 'M38000000', NULL, NULL, 2, 'M47000000', NULL, NULL, NULL, NULL);
INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (19, 'M41000000', 'M32000000', 'C900000000', 3, NULL, NULL, NULL, NULL, NULL);

DELETE FROM sys_menu WHERE id IN(01720259442805620738,01717076927401005058,01717079254782545922);
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 (01720259442805620738, '外包评价', 0, 1, 'core/evaluate', NULL, NULL, 1, 0, 'M', '0', '0', 'core:send:list', '1', 'edit', NULL, '超级管理员', '2023-09-21 10:37:52', '超级管理员', '2023-09-22 09:42:43', '');
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 (01717076927401005058, '评价计划管理', 01720259442805620738, 1, 'resumption', 'resumptionEvaluate/evaluate/index', NULL, 1, 1, 'C', '0', '0', 'core:evaluatePlan:list', '1', 'excel', NULL, '超级管理员', '2023-09-21 10:37:52', '超级管理员', '2023-09-22 09:42:43', '');
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 (01717079254782545922, '外包评价', 01720259442805620738, 2, 'wbpj', 'resumptionEvaluate/evaluatePlan/index', NULL, 1, 1, 'C', '0', '0', 'core:evaluateTask:list', '1', 'checkbox', NULL, '超级管理员', '2023-09-21 10:37:52', '超级管理员', '2023-09-22 09:42:43', '');

DELETE from `sys_role_menu` WHERE `menu_id` in(01720259442805620738,01717076927401005058,01717079254782545922);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (114, 01720259442805620738);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (115, 01720259442805620738);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (116, 01720259442805620738);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (117, 01720259442805620738);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (118, 01720259442805620738);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (119, 01720259442805620738);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (120, 01720259442805620738);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (121, 01720259442805620738);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (122, 01720259442805620738);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (128, 01720259442805620738);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (129, 01720259442805620738);


INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (114, 01717076927401005058);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (115, 01717076927401005058);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (116, 01717076927401005058);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (117, 01717076927401005058);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (118, 01717076927401005058);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (119, 01717076927401005058);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (120, 01717076927401005058);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (121, 01717076927401005058);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (122, 01717076927401005058);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (128, 01717076927401005058);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (129, 01717076927401005058);

INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (114, 01717079254782545922);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (115, 01717079254782545922);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (116, 01717079254782545922);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (117, 01717079254782545922);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (118, 01717079254782545922);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (119, 01717079254782545922);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (120, 01717079254782545922);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (121, 01717079254782545922);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (122, 01717079254782545922);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (128, 01717079254782545922);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (129, 01717079254782545922);
-- 天气接口配置
delete from sys_config where config_key='WEATHER_URL';
INSERT INTO sys_config (config_id, config_name, config_key, config_value, config_type, create_by, create_time, update_by, update_time, remark) VALUES (191, '天气接口', 'WEATHER_URL', 'https://ali-weather.showapi.com', 'Y', NULL, now(), NULL, now(), NULL);
-- 知识库状态修改
DELETE FROM sys_dict_data WHERE dict_type = 'materials_status' and dict_value=2;
UPDATE sys_dict_data t SET t.dict_label = '已发布' WHERE dict_type = 'materials_status' and dict_value=1;
UPDATE sys_dict_data t SET t.dict_label = '待发布' WHERE dict_type = 'materials_status' and dict_value=0;
DELETE FROM sys_menu WHERE id IN(01714200330384744450,01714195109957963777);
DELETE FROM sys_menu WHERE menu_name IN('导入设备','导出模版');
INSERT INTO `sys_menu` VALUES (01714200330384744450, '导入设备', 2050, 6, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:device:importData', '1', '#', NULL, '超级管理员', '2023-09-04 17:46:17', '超级管理员', '2023-09-04 17:47:06', '');
INSERT INTO `sys_menu` VALUES (01714195109957963777, '导出模版', 2050, 5, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:device:export', '1', '#', NULL, '超级管理员', '2023-09-04 17:46:17', '超级管理员', '2023-09-04 17:47:06', '');
DELETE from `sys_role_menu` WHERE `menu_id` in (01714200330384744450,01714195109957963777);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (114, 01714200330384744450);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (115, 01714200330384744450);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (116, 01714200330384744450);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (117, 01714200330384744450);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (118, 01714200330384744450);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (119, 01714200330384744450);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (120, 01714200330384744450);

INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (114, 01714195109957963777);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (115, 01714195109957963777);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (116, 01714195109957963777);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (117, 01714195109957963777);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (118, 01714195109957963777);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (119, 01714195109957963777);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (120, 01714195109957963777);

-- 变更安全检查类型
DELETE FROM `sys_dict_data` WHERE `dict_type` = 'check_type';
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', 'check_type', NULL, 'default', 'N', '0', '超级管理员', '2023-09-12 15:00:48', '省联社账号', '2023-11-13 16:57: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 ( 2, '【定期检查】办事处辖区安全检查', '2', 'check_type', NULL, 'default', 'N', '0', '超级管理员', '2023-09-12 15:00:59', '省联社账号', '2023-11-13 16:57:52', 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', 'check_type', NULL, 'default', 'N', '0', '超级管理员', '2023-09-12 15:01:25', '省联社账号', '2023-11-13 16:58:03', 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, '【定期检查】行社全面安全检查', '4', 'check_type', NULL, 'default', 'N', '0', '超级管理员', '2023-09-12 15:01:36', '省联社账号', '2023-11-13 16:58:12', 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', 'check_type', NULL, 'default', 'N', '0', '省联社账号', '2023-11-13 16:58:27', '', 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, ' 【不定期检查】专项检查 ', '6', 'check_type', NULL, 'default', 'N', '0', '省联社账号', '2023-11-13 16:58:40', '', 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 ( 7, '其他', '7', 'check_type', NULL, 'default', 'N', '0', '省联社账号', '2023-11-13 16:58:53', '', NULL, NULL);



delete from sys_dict_data where dict_type = 'org_extend_type';
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 (20231113001, 1, '营业网点', '1', 'org_extend_type', NULL, 'default', 'N', '0', '超级管理员', '2023-09-04 15:34:57', '', 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 (20231113002, 2, '在行式自助银行', '2', 'org_extend_type', NULL, 'default', 'N', '0', '超级管理员', '2023-09-04 15:35:17', '超级管理员', '2023-11-13 11:34:10', 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 (20231113003, 3, '离行式自助银行', '3', 'org_extend_type', NULL, 'default', 'N', '0', '超级管理员', '2023-11-13 11:34:31', '', 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 (20231113004, 4, '中心业务库', '4', 'org_extend_type', NULL, 'default', 'N', '0', '超级管理员', '2023-11-13 11:34:50', '', 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 (20231113005, 5, '网点业务库', '5', 'org_extend_type', NULL, 'default', 'N', '0', '超级管理员', '2023-11-13 11:35:04', '', 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 (20231113006, 6, '保管箱库', '6', 'org_extend_type', NULL, 'default', 'N', '0', '超级管理员', '2023-11-13 11:35:16', '', 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 (20231113007, 7, '监控中心', '7', 'org_extend_type', NULL, 'default', 'N', '0', '超级管理员', '2023-11-13 11:35:36', '', NULL, NULL);


delete from sys_dict_type where dict_type = 'duty_options';
delete from sys_dict_data where dict_type = 'duty_options';
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (20231113001, '夜间值守方式', 'duty_options', '0', '超级管理员', '2023-11-13 12:00:27', '', 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 (20231113008, 1, '远程中心值守', '1', 'duty_options', NULL, 'default', 'N', '0', '超级管理员', '2023-11-13 12:01:10', '', 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 (20231113009, 2, '同楼异地值守', '2', 'duty_options', NULL, 'default', 'N', '0', '超级管理员', '2023-11-13 12:01:25', '', NULL, NULL);

-- 修改/新增教育培训类型字典信息
update sys_dict_data set dict_label='行社安全保卫教育培训' where dict_label='每月安全培训教育' and dict_type='edu_training_type' limit 1;
update sys_dict_data set dict_label='行社消防安全培训' where dict_label='专项安全培训教育' and dict_type='edu_training_type' limit 1;
delete from sys_dict_data where dict_type='edu_training_type' and dict_label in ('营业网点安全保卫教育培训','营业网点消防安全培训','其他');
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', 'edu_training_type', 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', 'edu_training_type', 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 (4, '其他', '4', 'edu_training_type', null, 'default', 'N', '0',  null, now(), null, now(), null);


-- 履职任务类型增加其它，履职时间增加工作时间
update sys_dict_type set dict_name='履职任务类型' WHERE dict_type='resumption_plan_type';
DELETE from sys_dict_data WHERE dict_type='resumption_plan_type' and dict_value=8;
DELETE from sys_dict_data WHERE dict_type='resumption_plan_exec' and dict_value=6;
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 (8, '其它', '8', 'resumption_plan_type', NULL, 'default', 'N', '0', '超级管理员', '2023-11-14 11:03:01', '', 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, '工作时间', '6', 'resumption_plan_exec', NULL, 'default', 'N', '0', '超级管理员', '2023-11-14 11:43:43', '', NULL, NULL);



-- Web端 出入管理
DELETE FROM sys_menu WHERE id IN(01712729517575520258);
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 (01712729517575520258, '出入管理', 0, 100, 'Introduce', NULL, NULL, 1, 0, 'M', '0', '0', '', '1', 'client', NULL, '超级管理员', '2023-10-13 15:18:50', '超级管理员', '2023-10-13 15:25:27', '');

-- 介绍信管理
DELETE FROM sys_menu WHERE id IN(01712730072704237569,01722086291781177346,01722089558964723714,01722089643559641090,01722133971111796737);
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 (01712730072704237569, '介绍信管理', 1712729517575520258, 1, 'core/letter', 'core/outIn/letter/index', NULL, 1, 0, 'C', '0', '0', 'core:letter:query', '1', 'color', NULL, '超级管理员', '2023-10-13 15:21:02', '超级管理员', '2023-11-13 18:36:53', '');
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 (01722086291781177346, '新增', 1712730072704237569, 0, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:letter:add', '1', NULL, NULL, 'zlsls01', '2023-11-08 10:59:25', '', 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 (01722089558964723714, '删除', 1712730072704237569, 2, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:letter:remove', '1', NULL, NULL, '超级管理员', '2023-11-08 11:12:00', '超级管理员', '2023-11-08 11:12:58', '');
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 (01722089643559641090, '编辑', 1712730072704237569, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:letter:edit', '1', NULL, NULL, '超级管理员', '2023-11-08 11:12:20', '超级管理员', '2023-11-08 11:13:05', '');
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 (01722133971111796737, '查询', 1712730072704237569, 3, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:letter:query', '1', NULL, NULL, '超级管理员', '2023-11-08 14:08:29', '', NULL, '');

DELETE FROM `sys_role_menu` WHERE menu_id IN(01712730072704237569,01722086291781177346,01722089558964723714,01722089643559641090,01722133971111796737);

INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (114, 01712730072704237569);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (114, 01722086291781177346);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (114, 01722089558964723714);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (114, 01722089643559641090);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (114, 01722133971111796737);

INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (115, 01712730072704237569);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (115, 01722086291781177346);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (115, 01722089558964723714);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (115, 01722089643559641090);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (115, 01722133971111796737);

-- 出入事项审批
DELETE FROM sys_menu WHERE id IN(01722459057471643650,01722497238984318978,01722551208603836417);

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 (01722459057471643650, '来访事项审批', 1712729517575520258, 1, 'core/letter/approve', 'core/outIn/approve/index', NULL, 1, 0, 'C', '0', '0', 'core:letter:approveList', '1', 'validCode', NULL, '超级管理员', '2023-11-09 11:40:15', '超级管理员', '2023-11-09 11:47:28', '');
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 (01722497238984318978, '查询', 1722459057471643650, 0, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:letter:query', '1', NULL, NULL, '超级管理员', '2023-11-09 14:11:58', '超级管理员', '2023-11-13 18:38:23', '');
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 (01722551208603836417, '审核', 1722459057471643650, 0, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:letter:approve', '1', NULL, NULL, '超级管理员', '2023-11-09 17:46:26', '', NULL, '');

DELETE FROM `sys_role_menu` WHERE menu_id IN(01722459057471643650,01722497238984318978,01722551208603836417);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (121, 01722459057471643650);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (121, 01722497238984318978);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (121, 01722551208603836417);

-- 出入情况查询
DELETE FROM sys_menu WHERE id IN(01722881657557610498,01722883092282208257);
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 (01722881657557610498, '来访情况跟踪', 1712729517575520258, 3, 'core/outin/record', 'core/outIn/outInLog/index', NULL, 1, 0, 'C', '0', '0', 'core:record:list', '1', 'log', NULL, '超级管理员', '2023-11-10 15:39:31', '超级管理员', '2023-11-10 15:40:48', '');
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 (01722883092282208257, '查询', 1722881657557610498, 0, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:record:list', '1', NULL, NULL, '超级管理员', '2023-11-10 15:45:13', '', NULL, '');

DELETE FROM `sys_role_menu` WHERE menu_id IN(01722881657557610498,01722883092282208257);

INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (114, 01722881657557610498);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (115, 01722881657557610498);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (116, 01722881657557610498);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (117, 01722881657557610498);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (118, 01722881657557610498);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (119, 01722881657557610498);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (120, 01722881657557610498);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (121, 01722881657557610498);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (122, 01722881657557610498);

INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (114, 01722883092282208257);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (115, 01722883092282208257);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (116, 01722883092282208257);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (117, 01722883092282208257);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (118, 01722883092282208257);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (119, 01722883092282208257);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (120, 01722883092282208257);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (121, 01722883092282208257);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (122, 01722883092282208257);


-- 移动端 出入管理菜单
DELETE FROM sys_menu WHERE id IN(01719176094776664066);
INSERT INTO `soc`.`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 (01719176094776664066, '来访', 0, 4, '‘’', NULL, NULL, 1, 0, 'M', '0', '0', '', '0', NULL, NULL, '超级管理员', '2023-10-31 10:14:56', '超级管理员', '2023-10-31 10:38:38', '');

-- 出入人员登记
DELETE FROM sys_menu WHERE id IN(01719180104111788033,01724016270912864258,01724016373870444545);
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 (01719180104111788033, '来访核验登记', 1719176094776664066, 3, '/visitRecord', NULL, NULL, 1, 0, 'C', '0', '0', 'core:record:list', '0', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAFcAAABWCAMAAACNSvr7AAAAM1BMVEVHcExsnHRsnHRsnHRsnHRsnHRsnHRsnHRsnHRsnHRsnHRsnHRsnHRsnHRsnHRsnHRsnHS6r07EAAAAEHRSTlMAIKDQEPAwQIDAUJDgcGCwLB1LQwAAAAlwSFlzAAALEgAACxIB0t1+/AAAAghJREFUWIXtmNGOhCAMRasCgqjD/3/tBtSRAiOtzmazCfdR67GU0gLQ1NTU9FfqRo7ITlrH0qzw50prrQrYkYd1ziDqsD0TGVdzuS76eD2eDRk4cE1HiVinE+50/syWuC8KNQwbcZWMRpE67Lkkb4NsxBVDHJ2pwCVjkXWPoq6/xV3cr3DT/EwXzE2ukBgrL0bG4Q6Ju8sny95VZK6s80w9LGvYzWq3XpNX+XJ7c+caVu7Wc7Ig/KsOhJ3L3FFXNO3WFkTqgwIw6Sxx520WWXTXQDGpJY8bai2q2TYksxSpJYc7+mgogPWMsNmS+dm6gJBjvQB1xNj7afJlzOf6ujAoEOY9Z3lwI+5iKto9UpuX094RlmJw2eviLLorwCiDnyYPbsSVFerOPVPMAgjtO4KRWXGIuNVdREiwqKO5fieUujxz3jo0qrT13OcaV/D3ORe1nkINu8lVMVZWmjidi/q6LM/WHS6qYmvNmsxFDbiUsTe5sbvXqcDjRk0irzIPuOQM43HPJKtlGI97ThvtiMHlymqG8bj7eYG2s2dwfcmRPf2YReVOxlLSgMSd4h1QcFWMNjuhsLl4Rz4fjx5zX4jrKtZ0rnjFnV9/jfvIunEb979zLzdwSAOLK4ngzjgW17m5dgrwGs76Q+VyROMqLpZ6ybTWTxaxCldwn8S5nqRfXTU1NTUhAcAPovdX9YWaiFoAAAAASUVORK5CYII=', NULL, '超级管理员', '2023-10-31 10:30:52', '超级管理员', '2023-11-13 18:54:33', '');
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 (01724016270912864258, '新增', 1719180104111788033, 0, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:record:add', '0', NULL, NULL, '超级管理员', '2023-11-13 18:48:04', '', 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 (01724016373870444545, '修改', 1719180104111788033, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:record:edit', '0', NULL, NULL, '超级管理员', '2023-11-13 18:48:28', '', NULL, '');

DELETE FROM `sys_role_menu` WHERE menu_id IN(01719180104111788033,01724016270912864258,01724016373870444545);

INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (122, 01719180104111788033);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (122, 01724016270912864258);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (122, 01724016373870444545);

-- 出入事项审批
DELETE FROM sys_menu WHERE id IN(01721714093297004546,01724017039149973506);
INSERT INTO `soc`.`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 (01721714093297004546, '来访审批', 1719176094776664066, 2, '/visitCheck', NULL, NULL, 1, 0, 'C', '0', '0', 'core:letter:approveList', '0', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAFcAAABWCAMAAACNSvr7AAAAM1BMVEVHcExsnHRsnHRsnHRsnHRsnHRsnHRsnHRsnHRsnHRsnHRsnHRsnHRsnHRsnHRsnHRsnHS6r07EAAAAEHRSTlMAIKDQEPAwQIDAUJDgcGCwLB1LQwAAAAlwSFlzAAALEgAACxIB0t1+/AAAAghJREFUWIXtmNGOhCAMRasCgqjD/3/tBtSRAiOtzmazCfdR67GU0gLQ1NTU9FfqRo7ITlrH0qzw50prrQrYkYd1ziDqsD0TGVdzuS76eD2eDRk4cE1HiVinE+50/syWuC8KNQwbcZWMRpE67Lkkb4NsxBVDHJ2pwCVjkXWPoq6/xV3cr3DT/EwXzE2ukBgrL0bG4Q6Ju8sny95VZK6s80w9LGvYzWq3XpNX+XJ7c+caVu7Wc7Ig/KsOhJ3L3FFXNO3WFkTqgwIw6Sxx520WWXTXQDGpJY8bai2q2TYksxSpJYc7+mgogPWMsNmS+dm6gJBjvQB1xNj7afJlzOf6ujAoEOY9Z3lwI+5iKto9UpuX094RlmJw2eviLLorwCiDnyYPbsSVFerOPVPMAgjtO4KRWXGIuNVdREiwqKO5fieUujxz3jo0qrT13OcaV/D3ORe1nkINu8lVMVZWmjidi/q6LM/WHS6qYmvNmsxFDbiUsTe5sbvXqcDjRk0irzIPuOQM43HPJKtlGI97ThvtiMHlymqG8bj7eYG2s2dwfcmRPf2YReVOxlLSgMSd4h1QcFWMNjuhsLl4Rz4fjx5zX4jrKtZ0rnjFnV9/jfvIunEb979zLzdwSAOLK4ngzjgW17m5dgrwGs76Q+VyROMqLpZ6ybTWTxaxCldwn8S5nqRfXTU1NTUhAcAPovdX9YWaiFoAAAAASUVORK5CYII=', NULL, '超级管理员', '2023-11-07 10:20:02', '超级管理员', '2023-11-13 18:55:10', '');
INSERT INTO `soc`.`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 (01724017039149973506, '审批', 1721714093297004546, 0, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:letter:approve', '0', NULL, NULL, '超级管理员', '2023-11-13 18:51:07', '', NULL, '');

DELETE FROM `sys_role_menu` WHERE menu_id IN(01721714093297004546,01724017039149973506);

INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (121, 01721714093297004546);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (121, 01724017039149973506);

-- 出入事项申请
DELETE FROM sys_menu WHERE id IN(01721714556507549698,01724017221941936130,01724017294985740290,01724017404872310786);
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 (01721714556507549698, '来访申请', 1719176094776664066, 1, '/visitRegister', NULL, NULL, 1, 0, 'C', '0', '0', 'core:letter:query', '0', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAFcAAABWCAMAAACNSvr7AAAAM1BMVEVHcExsnHRsnHRsnHRsnHRsnHRsnHRsnHRsnHRsnHRsnHRsnHRsnHRsnHRsnHRsnHRsnHS6r07EAAAAEHRSTlMAIKDQEPAwQIDAUJDgcGCwLB1LQwAAAAlwSFlzAAALEgAACxIB0t1+/AAAAghJREFUWIXtmNGOhCAMRasCgqjD/3/tBtSRAiOtzmazCfdR67GU0gLQ1NTU9FfqRo7ITlrH0qzw50prrQrYkYd1ziDqsD0TGVdzuS76eD2eDRk4cE1HiVinE+50/syWuC8KNQwbcZWMRpE67Lkkb4NsxBVDHJ2pwCVjkXWPoq6/xV3cr3DT/EwXzE2ukBgrL0bG4Q6Ju8sny95VZK6s80w9LGvYzWq3XpNX+XJ7c+caVu7Wc7Ig/KsOhJ3L3FFXNO3WFkTqgwIw6Sxx520WWXTXQDGpJY8bai2q2TYksxSpJYc7+mgogPWMsNmS+dm6gJBjvQB1xNj7afJlzOf6ujAoEOY9Z3lwI+5iKto9UpuX094RlmJw2eviLLorwCiDnyYPbsSVFerOPVPMAgjtO4KRWXGIuNVdREiwqKO5fieUujxz3jo0qrT13OcaV/D3ORe1nkINu8lVMVZWmjidi/q6LM/WHS6qYmvNmsxFDbiUsTe5sbvXqcDjRk0irzIPuOQM43HPJKtlGI97ThvtiMHlymqG8bj7eYG2s2dwfcmRPf2YReVOxlLSgMSd4h1QcFWMNjuhsLl4Rz4fjx5zX4jrKtZ0rnjFnV9/jfvIunEb979zLzdwSAOLK4ngzjgW17m5dgrwGs76Q+VyROMqLpZ6ybTWTxaxCldwn8S5nqRfXTU1NTUhAcAPovdX9YWaiFoAAAAASUVORK5CYII=', NULL, '超级管理员', '2023-11-07 10:21:53', '超级管理员', '2023-11-13 18:54:47', '');
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 (01724017221941936130, '新增', 1721714556507549698, 0, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:letter:add', '0', NULL, NULL, '超级管理员', '2023-11-13 18:51:51', '', 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 (01724017294985740290, '修改', 1721714556507549698, 0, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:letter:edit', '0', NULL, NULL, '超级管理员', '2023-11-13 18:52:08', '', 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 (01724017404872310786, '删除', 1721714556507549698, 2, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:letter:remove', '0', NULL, NULL, '超级管理员', '2023-11-13 18:52:34', '', NULL, '');

DELETE FROM `sys_role_menu` WHERE menu_id IN(01721714556507549698,01724017221941936130,01724017294985740290,01724017404872310786);

INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (122, 01721714556507549698);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (122, 01724017221941936130);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (122, 01724017294985740290);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (122, 01724017404872310786);

-- 删除检查登记授权按钮权限
DELETE from sys_menu WHERE perms='core:safetycheck:grant'  and menu_type='F';

-- 删除履职内容库管理页面，改为按钮
DELETE FROM sys_menu WHERE menu_name like '履职内容库管理%';
DELETE FROM sys_role_menu WHERE menu_id =1726808689796902913;
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 (01726808689796902913, '履职内容库管理', 2004, 5, '', NULL, NULL, 1, 0, 'F', '0', '0', 'resumption:rule:contentmanage', '1', NULL, NULL, 'jwx', '2023-11-21 11:44:08', '', NULL, '');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (115, 1726808689796902913);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (116, 1726808689796902913);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (117, 1726808689796902913);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (118, 1726808689796902913);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (119, 1726808689796902913);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (120, 1726808689796902913);

DELETE FROM sys_menu WHERE id =2332 or parent_id=2332 or id=01726875550324551681;
DELETE FROM sys_role_menu WHERE menu_id =01726875550324551681;

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 (01726875550324551681, '内容库管理', 2327, 5, '', NULL, NULL, 1, 0, 'F', '0', '0', 'safetycheck:rule:contentmanage', '1', NULL, NULL, 'jwx', '2023-11-21 16:09:49', '', NULL, '');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (115, 01726875550324551681);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (116, 01726875550324551681);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (117, 01726875550324551681);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (118, 01726875550324551681);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (119, 01726875550324551681);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (120, 01726875550324551681);

UPDATE sys_menu set menu_name='履职内容库' WHERE menu_name='履职内容库定义';
UPDATE sys_menu set menu_name='检查内容库' WHERE menu_name='检查内容库定义';

-- 更新菜单名称
update sys_menu set menu_name='隐患管理' WHERE menu_name='问题处理管理' and menu_type='M';
update sys_menu set menu_name='综合考核' WHERE menu_name='安全综合管理评价' and menu_type='M';
update sys_menu set menu_name='外包考核评价',order_num=4,parent_id=01712277074707779586 WHERE menu_name='评价计划管理' and menu_type='C';
update sys_menu set menu_name='外包考核结果',order_num=5,parent_id=01712277074707779586 WHERE menu_name='外包评价' and menu_type='C';
update sys_menu set menu_name='高管工作部署' WHERE menu_name='行社高管部署登记' and menu_type='C';
update sys_menu set menu_name='年度工作计划' WHERE menu_name='安全保卫部年度计划' and menu_type='C';
DELETE from sys_menu WHERE id=1720259442805620738;


-- 履职任务类型修正
DELETE FROM sys_dict_data where dict_type='resumption_plan_type';
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', 'resumption_plan_type', NULL, 'default', 'N', '0', '何悦', '2023-08-28 18:44:08', '超级管理员', '2023-09-28 15:16:39', 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, '营业期间安全管理', '2', 'resumption_plan_type', NULL, 'default', 'N', '0', '何悦', '2023-08-28 18:44:19', '超级管理员', '2023-09-28 15:16:51', 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', 'resumption_plan_type', NULL, 'default', 'N', '0', '何悦', '2023-08-29 10:56:15', '超级管理员', '2023-09-28 15:17:11', 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, '“110”入侵报警系统测试', '4', 'resumption_plan_type', NULL, 'default', 'N', '0', '何悦', '2023-08-29 10:56:35', '超级管理员', '2023-09-28 15:17:23', 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, '不间断电源(UPS)维护', '5', 'resumption_plan_type', NULL, 'default', 'N', '0', '何悦', '2023-08-29 10:56:50', '省联社账号', '2023-11-16 10:19:49', 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', 'resumption_plan_type', NULL, 'default', 'N', '0', '何悦', '2023-08-29 10:57:08', '超级管理员', '2023-09-28 15:17:42', 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 ( 7, '非营业时间安全管理', '7', 'resumption_plan_type', NULL, 'default', 'N', '0', '何悦', '2023-08-29 10:57:26', '超级管理员', '2023-09-28 15:17:51', 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 ( 8, '其他', '8', 'resumption_plan_type', NULL, 'default', 'N', '0', '超级管理员', '2023-11-14 11:03:01', '省联社账号', '2023-11-16 10:19:31', NULL);




-- 出入管理相关表
CREATE TABLE if not exists `core_introduce_letter` (
                                                       `id` bigint NOT NULL,
                                                       `letter_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '介绍信名称',
    `start_time` datetime DEFAULT NULL COMMENT '有效开始时间',
    `end_time` datetime DEFAULT NULL COMMENT '有效结束时间',
    `letter_file` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '介绍信文件',
    `org_id` bigint DEFAULT NULL COMMENT '创建机构',
    `org_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建机构',
    `org_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建机构',
    `create_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
    `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    `deleted` int DEFAULT NULL COMMENT '0正常1删除',
    `letter_no` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '介绍信编号',
    `description` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
    `reasons` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '出入事由',
    `status` int DEFAULT NULL COMMENT '状态：0 草稿 ，1 使用中， 2 已逾期',
    `update_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人',
    `update_time` datetime DEFAULT NULL COMMENT '修改时间',
    `type` int DEFAULT NULL COMMENT '类型：1 职能部门出入, 2 临时出入，3 紧急出入',
    PRIMARY KEY (`id`) USING BTREE
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='介绍信';

CREATE TABLE if not exists `core_introduce_letter_user` (
                                                            `id` bigint DEFAULT NULL,
                                                            `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `company_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `id_card` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `img_file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `letter_id` bigint DEFAULT NULL,
    `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `create_time` datetime DEFAULT NULL,
    KEY `index_letter_id` (`letter_id`) USING BTREE
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='介绍信人员表';

CREATE TABLE if not exists `core_introduce_letter_to_org` (
                                                              `letter_id` bigint DEFAULT NULL,
                                                              `org_id` bigint DEFAULT NULL,
                                                              KEY `index_org_id` (`org_id`) USING BTREE,
    KEY `index_letter_id` (`letter_id`) USING BTREE
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='介绍信接待机构';

CREATE TABLE if not exists `core_introduce_letter_approve_log` (
                                                                   `id` bigint NOT NULL,
                                                                   `letter_id` bigint DEFAULT NULL COMMENT '介绍信id',
                                                                   `approve_user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '审核人',
    `approve_user_id` bigint DEFAULT NULL COMMENT '审核人Id',
    `approve_time` datetime DEFAULT NULL COMMENT '审核时间',
    `approve_status` int DEFAULT NULL COMMENT '审核状态:0待审批1通过2不通过3逾期',
    `approve_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
    `org_id` bigint DEFAULT NULL COMMENT '接待机构',
    PRIMARY KEY (`id`) USING BTREE,
    KEY `index_letter_id` (`letter_id`) USING BTREE,
    KEY `index_org_id` (`org_id`) USING BTREE
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='介绍信审批记录';

CREATE TABLE if not exists `core_out_in_record` (
                                                    `id` bigint NOT NULL,
                                                    `org_id` bigint DEFAULT NULL COMMENT '出入机构',
                                                    `letter_id` bigint DEFAULT NULL COMMENT '介绍信/出入申请ID',
                                                    `letter_user_id` bigint DEFAULT NULL COMMENT '介绍信/出入申请中 人员ID',
                                                    `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '登记人员',
    `create_time` datetime DEFAULT NULL COMMENT '登记时间',
    `arrival_time` datetime DEFAULT NULL COMMENT '到达时间',
    `departure_time` datetime DEFAULT NULL COMMENT '离开时间',
    `accompanying_person` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '陪同人员',
    `check_image` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '核验照片',
    PRIMARY KEY (`id`),
    KEY `index_letter_id` (`letter_id`) USING BTREE
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='人员出入登记表';

-- 出入管理相关字典

DELETE FROM `sys_dict_type` where dict_type='out_in_type';
DELETE FROM `sys_dict_data` where dict_type='out_in_type';
INSERT INTO `sys_dict_type` (`dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '出入类型', 'out_in_type', '0', 'zlsls01', '2023-11-08 17:24: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, '电子', '1', 'out_in_type', NULL, 'default', 'N', '0', 'zlsls01', '2023-11-08 17:25:16', '', 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, '纸质', '2', 'out_in_type', NULL, 'default', 'N', '0', 'zlsls01', '2023-11-08 17:25:24', '', 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 (2, '紧急', '3', 'out_in_type', NULL, 'default', 'N', '0', 'zlsls01', '2023-11-08 17:25:32', '', NULL, NULL);

DELETE FROM `sys_dict_type` where dict_type='out_in_approve_status';
DELETE FROM `sys_dict_data` where dict_type='out_in_approve_status';
INSERT INTO `sys_dict_type` (`dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ('出入申请审批状态', 'out_in_approve_status', '0', 'zlsls01', '2023-11-08 17:27:43', '', 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', 'out_in_approve_status', NULL, 'default', 'N', '0', 'zlsls01', '2023-11-08 17:28:10', '', 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', 'out_in_approve_status', NULL, 'default', 'N', '0', 'zlsls01', '2023-11-08 17:28:20', '', 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 (2, '不同意', '2', 'out_in_approve_status', NULL, 'default', 'N', '0', 'zlsls01', '2023-11-08 17:28:28', '', 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', 'out_in_approve_status', NULL, 'default', 'N', '0', 'zlsls01', '2023-11-08 17:28:34', '', NULL, NULL);

DELETE FROM `sys_dict_type` where dict_type='letter_status';
DELETE FROM `sys_dict_data` where dict_type='letter_status';
INSERT INTO `sys_dict_type` (`dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ('介绍信状态', 'letter_status', '0', '超级管理员', '2023-10-13 15:29:50', '', 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', 'letter_status', NULL, 'default', 'N', '0', '超级管理员', '2023-10-13 15:30:40', 'zlsls01', '2023-11-08 11:04:29', 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', 'letter_status', NULL, 'default', 'N', '0', '超级管理员', '2023-10-13 15:31:04', 'zlsls01', '2023-11-08 11:04: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 (2, '已失效', '2', 'letter_status', NULL, 'default', 'N', '0', '超级管理员', '2023-10-13 15:31:17', 'zlsls01', '2023-11-08 11:04:41', NULL);


DELETE FROM `sys_dict_type` where dict_type='letter_id_type';
DELETE FROM `sys_dict_data` where dict_type='letter_id_type';
INSERT INTO `soc`.`sys_dict_type` (`dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ('介绍信证件类型', 'letter_id_type', '0', '超级管理员', '2023-11-21 15:24:42', '', NULL, NULL);
INSERT INTO `soc`.`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', 'letter_id_type', NULL, 'default', 'N', '0', '超级管理员', '2023-11-21 15:25:09', '', NULL, NULL);
INSERT INTO `soc`.`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', 'letter_id_type', NULL, 'default', 'N', '0', '超级管理员', '2023-11-21 15:25:22', '', NULL, NULL);
INSERT INTO `soc`.`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', 'letter_id_type', NULL, 'default', 'N', '0', '超级管理员', '2023-11-21 15:25:30', '', NULL, NULL);


UPDATE sys_dict_data set dict_label='待整改' WHERE dict_type='question_reform_status' and dict_value=10;

update sys_dict_data SET dict_label='报警控制器' WHERE dict_label='报警主机';

delete  from sys_dict_data where dict_type= 'sys_device_type';
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, '硬盘录像机', '0', 'sys_device_type', null, 'default', 'N', '0', '超级管理员', now(), '', 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 (4, '报警控制器', '1', 'sys_device_type', null, 'default', 'N', '0', '超级管理员', now(), '', 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, '摄像机', '2', 'sys_device_type', null, 'default', 'N', '0', '超级管理员', now(), '', 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, '灭火器', '3', 'sys_device_type', null, 'default', 'N', '0', '超级管理员', now(), '', 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 (2, '过滤式消防自助呼吸器', '4', 'sys_device_type', null, 'default', 'N', '0', '超级管理员', now(), '', null, null);

DELETE FROM `sys_menu` where id =00000000000000002318;
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 (00000000000000002318, '检查登记跟踪', 2326, 4, 'saftask', 'safetycheck/task/index', NULL, 1, 0, 'C', '0', '0', 'core:task:list', '1', 'documentation', NULL, '超级管理员', '2023-09-21 10:37:52', '省联社账号', '2023-11-21 16:41:17', '');

delete from sys_dict_data where dict_type='science_protection';
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, '硬盘录像机', '0', 'science_protection', null, 'default', 'N', '0', '超级管理员', now(), '', 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 (2, '报警控制器', '1', 'science_protection', null, 'default', 'N', '0', '超级管理员', now(), '', 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, '摄像机', '2', 'science_protection', null, 'default', 'N', '0', '超级管理员', now(), '', null, null);
delete from sys_dict_data where dict_type='fire_fighting';
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, '过滤式消防自助呼吸器', '4', 'fire_fighting', null, 'default', 'N', '0', '超级管理员', now(), '', 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 (2, '灭火器', '3', 'fire_fighting', null, 'default', 'N', '0', '超级管理员', now(), '', null, null);


DELETE FROM `sys_dict_data` WHERE dict_code in (20231113208,20231113210);
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 (20231113208, 3, '已逾期', '12', 'question_reform_status', NULL, 'default', 'N', '0', 'jwx', '2023-11-22 14:23: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 (20231113210, 4, '已逾期', '4', 'question_confirm_status', NULL, 'default', 'N', '0', '超级管理员', '2023-11-22 17:28:29', '超级管理员', '2023-11-22 17:28:38', NULL);

-- 删除多余的表
drop TABLE if EXISTS sys_bank_physical_defense_construction;
-- 新增演练项目字典,及修改字典排序
-- DELETE from sys_dict_data where dict_type='core_drill_type' 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 (7, '防爆防恐应急预案', '7', 'core_drill_type', NULL, 'default', 'N', '0', NULL, NOW(), NULL, NOW(), NULL);
-- update sys_dict_data set dict_sort =5 where dict_type='core_drill_type' and dict_label='防爆防恐应急预案' limit 1;
-- update sys_dict_data set dict_sort =6 where dict_type='core_drill_type' and dict_label='防自然灾害应急预案' limit 1;
-- update sys_dict_data set dict_sort =7 where dict_type='core_drill_type' and dict_label='其它应急预案' limit 1;

ALTER TABLE `core_question` 
MODIFY COLUMN `reform_status` int NULL DEFAULT NULL COMMENT '整改状态。10待整改，11已整改,12已逾期' AFTER `confirm_status`;
delete from `sys_dict_data` Where dict_type='question_reform_status' and dict_value=12;
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, '已逾期', '12', 'question_reform_status', NULL, 'default', 'N', '0', 'jwx', '2023-11-22 14:23:36', '', NULL, NULL);

ALTER TABLE `core_question`
    MODIFY COLUMN `reform_status` int NULL DEFAULT NULL COMMENT '整改状态。10待整改，11已整改,12已逾期' AFTER `confirm_status`;
delete from `sys_dict_data` Where dict_type='question_reform_status' and dict_value=12;
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, '已逾期', '12', 'question_reform_status', NULL, 'default', 'N', '0', 'jwx', '2023-11-22 14:23:36', '', NULL, NULL);

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 = 'core_introduce_letter'
                    AND column_name = 'effective_days') THEN
ALTER TABLE `core_introduce_letter`
    MODIFY COLUMN `start_time` datetime NULL DEFAULT NULL COMMENT '有效开始时间，开具时间' AFTER `letter_name`,
    ADD COLUMN `effective_days` int NULL COMMENT '有效天数' AFTER `type`;

END IF;


-- 出入介绍信 来访人员新增 证件类型
IF NOT EXISTS(SELECT *
                  FROM information_schema.columns
                  WHERE table_schema = DATABASE()
                    AND table_name = 'core_introduce_letter_user'
                    AND column_name = 'id_type') THEN
ALTER TABLE `core_introduce_letter_user`
    ADD COLUMN `id_type` int NULL COMMENT '证件类型' AFTER `company_name`;

END IF;

-- 监控调阅时长
IF NOT EXISTS(SELECT *
                  FROM information_schema.columns
                  WHERE table_schema = DATABASE()
                    AND table_name = 'core_monitoring_task_registration'
                    AND column_name = 'average_duration') THEN
ALTER TABLE `core_monitoring_task_registration`
    ADD COLUMN `average_duration` double DEFAULT '0' COMMENT '平均调阅时长';

END IF;


-- 安全责任书
IF NOT EXISTS(SELECT *
              FROM information_schema.columns
              WHERE table_schema = DATABASE()
                AND table_name = 'core_safety_book_hsggbsdj'
                AND column_name = 'org_id') THEN
    ALTER TABLE `core_safety_book_hsggbsdj`
        ADD COLUMN `org_id` bigint NULL COMMENT '机构id';

END IF;
-- 安全责任书
IF NOT EXISTS(SELECT *
              FROM information_schema.columns
              WHERE table_schema = DATABASE()
                AND table_name = 'core_safety_book_hsggbsdj'
                AND column_name = 'join_names') THEN
    ALTER TABLE `core_safety_book_hsggbsdj`
        ADD COLUMN `join_names` varchar(255) NULL COMMENT '参与人员';

END IF;
-- 安全责任书
IF NOT EXISTS(SELECT *
              FROM information_schema.columns
              WHERE table_schema = DATABASE()
                AND table_name = 'core_safety_book_aqbwbndjh'
                AND column_name = 'type') THEN
    ALTER TABLE `core_safety_book_aqbwbndjh`
        ADD COLUMN `type` varchar(255) NULL COMMENT '文件种类';

END IF;
-- 安全责任书
IF NOT EXISTS(SELECT *
              FROM information_schema.columns
              WHERE table_schema = DATABASE()
                AND table_name = 'core_safety_book_aqbwbndjh'
                AND column_name = 'year') THEN
    ALTER TABLE `core_safety_book_aqbwbndjh`
        ADD COLUMN `year` int NULL COMMENT '工作年度';

END IF;

END ??
DELIMITER;
CALL schema_change ();

UPDATE `sys_menu` SET `menu_name` = '来访管理',`icon`='link' WHERE `menu_name` = '出入管理' AND `parent_id` = 0 AND platform_type=1;
UPDATE `sys_menu` SET `menu_name` = '来访•核验',`order_num`=2  WHERE `menu_name` = '来访' AND `parent_id` = 0 AND platform_type=0;

-- 调整移动端菜单分组 开始
UPDATE `sys_menu` SET `menu_name` = '来访•核验',`order_num`=2  WHERE `menu_name` = '来访' AND `parent_id` = 0 AND platform_type=0;
DELETE FROM sys_menu WHERE id IN(01726899190588432386,01726899481861873666,01726900357129232386,01722798472651890689);
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 (01726899190588432386, '培训•演练', 0, 3, '‘’', NULL, NULL, 1, 0, 'M', '0', '0', NULL, '0', '#', NULL, '超级管理员', '2023-11-21 17:44:07', '', 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 (01726899481861873666, '设置•管理', 0, 4, '‘’', NULL, NULL, 1, 0, 'M', '0', '0', NULL, '0', '#', NULL, '超级管理员', '2023-11-21 17:45:17', '', 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 (01726900357129232386, '履职•检查', 0, 1, '‘’', NULL, NULL, 1, 0, 'M', '0', '0', NULL, '0','#', NULL, '超级管理员', '2023-11-21 17:48:45', '', 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 (01722798472651890689, 'app驾驶舱', 1726899481861873666, 1, '/cockpit', '', NULL, 1, 1, 'C', '0', '0', '', '0', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAFYAAABWCAMAAABiiJHFAAAAMFBMVEVHcEymgKWmgKWmgKWmgKWmgKWmgKWmgKWmgKWmgKWmgKWmgKWmgKWmgKWmgKWmgKUnf6aaAAAAD3RSTlMAQMCAYNAQIKAw8HDgsJCcvx8RAAAACXBIWXMAAAsSAAALEgHS3X78AAABwElEQVRYhe3Y2W6EMAwFUBICYR3//9+OCtMWTXKvTWAeqsbvPkLGztbUqFGjRmmMzsUPFM+LiHRDuNne2I0O/SdYkam9Dz6wX/A1zM3t6n3CinRjKRnnbyrDisxFaDg4WVaGAnQ5Ann2tDu+GYA96c7v6Yg94/Zrkg1Z+3/ruzQZs2Lss5zK2KVcZayY5i2fzNjJsKQ98qmMNXSDA5mUFW056xeQyFmtui1K5KzSDBEmclbp3aGUpVXop1LWMzZZYMysMDY7XzaWFBf/MJ11mA0XWLI84j7QWdIKpLRXWJK1saPDgRcx9sdoA/FAi9cfZPcVtSWBqkvZbnNZZ6OBoKzulrGqC8eXs5oLOxevthYXqXQ4VRdvZ3B/tLgrZEeVJS5ZGbXiMpdsD+CgZHHZScFQBeQ+CKv3AnTpoVEZNOzSc4LxczMu2XjN1U1d3LSv0Eci4xqO42z7PcRezJcbVLWJhpmQn4N9EOuNz1jeX9d4j2Q7yzH2CQjm26nNnZSmytTBUN+p4O0jqv3gy56AlP4tfv+JZI7XKw9sLn1V2GI4/a/ev7hNLpXdfMtTYAyDf/XF4h93Py/WqFHjH0TTNE8qcZLTHufPKAAAAABJRU5ErkJggg==', NULL, '超级管理员', '2023-11-10 10:08:58', '超级管理员', '2023-11-22 17:04:54', '');

-- 修改改为禁用状态
DELETE from `sys_menu` WHERE  `parent_id` = 0 AND platform_type=0 and  `menu_name` in ('管理','设备','履职','培训','演练','驾驶舱App'); 

-- 修改移动端菜单目录

UPDATE sys_menu
SET parent_id = 01726899481861873666
WHERE
        parent_id IN ( SELECT * FROM ( SELECT id FROM sys_menu WHERE (`menu_name` = '管理' OR `menu_name` = '设备' OR `menu_name` = '驾驶舱App' ) AND `parent_id` = 0 AND platform_type = 0 ) AS s );


UPDATE sys_menu
SET parent_id = 01726899190588432386
WHERE
        parent_id IN ( SELECT * FROM ( SELECT id FROM sys_menu WHERE (`menu_name` = '培训' OR `menu_name` = '演练' ) AND `parent_id` = 0 AND platform_type = 0 ) AS s );


UPDATE sys_menu
SET parent_id = 01726900357129232386
WHERE
        parent_id IN ( SELECT * FROM ( SELECT id FROM sys_menu WHERE `menu_name` = '履职' AND `parent_id` = 0 AND platform_type = 0 ) AS s );

-- 在权限表中删除没有菜单的数据
DELETE from sys_role_menu WHERE menu_id not in (SELECT id from sys_menu);
-- 调整移动端菜单分组 结束

-- 更新安全责任书类型
delete from `sys_dict_data`  where  dict_type='safety_book_type';
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', 'safety_book_type', NULL, 'default', 'N', '0', '超级管理员', '2023-10-11 14:37:00', '省联社账号', '2023-11-24 09:16:39', 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, '联防协议书', '2', 'safety_book_type', NULL, 'default', 'N', '0', '超级管理员', '2023-10-11 14:37:07', '省联社账号', '2023-11-24 09:16:58', 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', 'safety_book_type', NULL, 'default', 'N', '0', '超级管理员', '2023-10-11 14:37:13', '省联社账号', '2023-11-24 09:17:05', NULL);


-- 登记簿固化表增加非空约束
ALTER TABLE core_register_book_pdf
    MODIFY COLUMN `file_name` varchar(225) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文件名称' AFTER `org_path`,
    MODIFY COLUMN `file_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文件地址' AFTER `file_name`;
	
	
-- 补充未添加的一级菜单权限				
INSERT into sys_role_menu				
SELECT
	a.* 
FROM
	(
	SELECT
		rm.role_id,
		m.parent_id AS menu_id 
	FROM
		sys_menu m
		INNER JOIN sys_role_menu rm ON m.id = rm.menu_id 
	WHERE
		menu_type = 'C' 
		AND m.`status` = 0 
		AND m.parent_id > 0 
	GROUP BY
		rm.role_id,
		m.parent_id 
	) a where CONCAT(a.role_id,a.menu_id) not in (SELECT CONCAT(role_id,menu_id) from sys_role_menu)
	order by a.role_id	;
-- 字段长度变更
ALTER TABLE `core_drill_task`
    MODIFY COLUMN `drill_site` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '演练地点' AFTER `drill_end_time`;