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