
delete from `config` where `key`='lastDateTime';
INSERT INTO `config` ( `key`, `value`, `name`, `active`, `create_time`, `update_time`, `update_by`)
select 'lastDateTime', '2020-12-05 12:55:11', '最后同步时间', true,now(), now(), 'system';

delete from `config` where `key`='DATASYNC_SWITCH';
INSERT INTO `config` ( `key`, `value`, `name`, `active`, `create_time`, `update_time`, `update_by`)
select 'DATASYNC_SWITCH', '0', '新同步开关 0关1开', true,now(), now(), 'system';

delete from `config` where `key`='DATASYNC_FILEPATHS';
INSERT INTO `config` ( `key`, `value`, `name`, `active`, `create_time`, `update_time`, `update_by`)
select 'DATASYNC_FILEPATHS', 'upload/,1||ftpOut/,0', '需要同步的文件路径', true,now(), now(), 'system'
from config where `key`="police" and active=true and `value`='0';

INSERT INTO `config` ( `key`, `value`, `name`, `active`, `create_time`, `update_time`, `update_by`)
select 'DATASYNC_FILEPATHS', 'personImg/,1||ftpIn/,0', '需要同步的文件路径', true,now(), now(), 'system'
from config where `key`="police" and active=true and `value`='1';


delete from `config` where `key`='TIME_HOST';
delete from `config` where `key`='TARGET_TIME_HOST';
INSERT INTO `config` ( `key`, `value`, `name`, `active`, `create_time`, `update_time`, `update_by`)
select 'TIME_HOST', 'http://outbjbbd.test.baibaodun.cn/ars-rest/', '当前定时器访问地址', true,now(), now(), 'system'
from config t1,config t2
where t1.`key`='police' and t2.`key`='current_native'
and t1.`value`='0' and t2.`value`='11';


INSERT INTO `config` ( `key`, `value`, `name`, `active`, `create_time`, `update_time`, `update_by`)
select 'TARGET_TIME_HOST', 'http://inbjbbd.test.baibaodun.cn/ars-rest/', '目标定时器访问地址', true,now(), now(), 'system'
from config t1,config t2
where t1.`key`='police' and t2.`key`='current_native'
and t1.`value`='0' and t2.`value`='11';


INSERT INTO `config` ( `key`, `value`, `name`, `active`, `create_time`, `update_time`, `update_by`)
select 'TIME_HOST', 'http://inbjbbd.test.baibaodun.cn/ars-rest/', '当前定时器访问地址', true,now(), now(), 'system'
from config t1,config t2
where t1.`key`='police' and t2.`key`='current_native'
and t1.`value`='1' and t2.`value`='11';

INSERT INTO `config` ( `key`, `value`, `name`, `active`, `create_time`, `update_time`, `update_by`)
select 'TARGET_TIME_HOST', 'http://outbjbbd.test.baibaodun.cn/ars-rest/', '目标定时器访问地址', true,now(), now(), 'system'
from config t1,config t2
where t1.`key`='police' and t2.`key`='current_native'
and t1.`value`='1' and t2.`value`='11';


delete from `config` where `key`='DATA_SYNC_FTP_HOST';
INSERT INTO `config` ( `key`, `value`, `name`, `active`, `create_time`, `update_time`, `update_by`)
select 'DATA_SYNC_FTP_HOST', 'http://221.7.196.203:81/', '数据同步FTP地址', true,now(), now(), 'system'
from config where `key`="police" and active=true and `value`='0';

INSERT INTO `config` ( `key`, `value`, `name`, `active`, `create_time`, `update_time`, `update_by`)
select 'DATA_SYNC_FTP_HOST', 'http://10.148.77.214:8022/', '数据同步FTP地址', true,now(), now(), 'system'
from config where `key`="police" and active=true and `value`='1';

# 20201209 抽查记录 字典表增加
-- 考培信息抽查结果
delete from sys_dict where codeType='recordCheckState';
insert into sys_dict (isActive, updateTime, updateflag, codeType, tableName, description, codeValue, label, seq)
values (1, now(), true, 'recordCheckState', '', '考培信息抽查结果', '1', '抽查合格', 1);

insert into sys_dict (isActive, updateTime, updateflag, codeType, tableName, description, codeValue, label, seq)
values (1, now(), true, 'recordCheckState', '', '考培信息抽查结果', '2', '抽查不合格', 1);

# insert into sys_dict (isActive, updateTime, updateflag, codeType, tableName, description, codeValue, label, seq)
# values (1, now(), true, 'recordCheckState', '', '考培信息抽查结果', '3', '待复核', 1);

-- 基本信息审查结果
delete from sys_dict where codeType='recordBaseResult';
insert into sys_dict (isActive, updateTime, updateflag, codeType, tableName, description, codeValue, label, seq)
values (1, now(), true, 'recordBaseResult', '', '考培信息抽查基本信息审查结果', '1', '合格', 1);

insert into sys_dict (isActive, updateTime, updateflag, codeType, tableName, description, codeValue, label, seq)
values (1, now(), true, 'recordBaseResult', '', '考培信息抽查基本信息审查结果', '0', '不合格', 1);

-- 学习照片审查结果
delete from sys_dict where codeType='recordStudyResult';
insert into sys_dict (isActive, updateTime, updateflag, codeType, tableName, description, codeValue, label, seq)
values (1, now(), true, 'recordStudyResult', '', '考培信息抽查学习照片审查结果', '0', '不合格', 1);

insert into sys_dict (isActive, updateTime, updateflag, codeType, tableName, description, codeValue, label, seq)
values (1, now(), true, 'recordStudyResult', '', '考培信息抽查学习照片审查结果', '1', '合格', 1);

delete from module_menu where parentIds like '%786192747567583232%';
INSERT INTO `module_menu` (`id`, `active`, `createTime`, `updateTime`, `updateBy`, `location`, `name`, `parentId`, `seq`, `menuType`, `description`, `iconClass`, `iconCls`, `permission`, `parentIds`, `uniqueId`, `intranetFlag`, `superAdmin`, `platform`, `rankAuth`) VALUES ('786192747567583232', '', '2020-12-09 11:29:18', '2020-12-23 16:50:08', 'bj_super', NULL, '保安员考培信息抽查管理', NULL, '45', '0', NULL, '/assets/images/nav/menu/static/icon7.png', NULL, NULL, '786192747567583232/', NULL, '0', '0', '1', '0');
INSERT INTO `module_menu` (`id`, `active`, `createTime`, `updateTime`, `updateBy`, `location`, `name`, `parentId`, `seq`, `menuType`, `description`, `iconClass`, `iconCls`, `permission`, `parentIds`, `uniqueId`, `intranetFlag`, `superAdmin`, `platform`, `rankAuth`) VALUES ('786193581261000704', '', '2020-12-09 11:32:37', '2020-12-23 16:49:17', 'bj_super', '/checkRecord/list/index.do?recordType=01', '资格证考培信息抽查记录', '786192747567583232', '1', '0', NULL, NULL, NULL, NULL, '786192747567583232/786193581261000704/', 'personCheckList', '0', '0', '1', '0');
INSERT INTO `module_menu` (`id`, `active`, `createTime`, `updateTime`, `updateBy`, `location`, `name`, `parentId`, `seq`, `menuType`, `description`, `iconClass`, `iconCls`, `permission`, `parentIds`, `uniqueId`, `intranetFlag`, `superAdmin`, `platform`, `rankAuth`) VALUES ('786193873171976192', '', '2020-12-09 11:33:46', '2020-12-23 16:49:35', 'bj_super', '/checkRecord/list/index.do?recordType=03', '等级证考培信息抽查记录', '786192747567583232', '2', '0', NULL, NULL, NULL, NULL, '786192747567583232/786193873171976192/', 'gradeCheckList', '0', '0', '1', '0');
