-- 20201014 delete from sys_dict where codeType ='subsidyBusinessType' and codeValue in('006','007','008'); INSERT INTO `sys_dict` ( `isActive`, `updateTime`, `updateflag`, `codeType`, `tableName`, `description`, `codeValue`, `label`, `seq`) VALUES ('1', now(), true, 'subsidyBusinessType', NULL, '补贴业务类型', '006', '资格证平台服务费', '6'), ('1', now(), true, 'subsidyBusinessType', NULL, '补贴业务类型', '007', '等级证结业证平台服务费', '7'), ('1', now(), true, 'subsidyBusinessType', NULL, '补贴业务类型', '008', '等级证鉴定证平台服务费', '8'); delete from sys_dict where codeType ='grantState'; INSERT INTO `sys_dict` ( `isActive`, `updateTime`, `updateflag`, `codeType`, `tableName`, `description`, `codeValue`, `label`, `seq`) VALUES ('1', now(), true, 'grantState', NULL, '补贴发放状态', '1', '已发放', '1'), ('1', now(), true, 'grantState', NULL, '补贴发放状态', '0', '未发放', '2'); -- INSERT INTO `sys_dict` ( `isActive`, `updateTime`, `updateflag`, `codeType`, `tableName`, `description`, `codeValue`, `label`, `seq`)VALUES -- ('1', now(), true, 'subsidyStatus', NULL, '补贴比对状态', '05', '公示不通过', '5'); -- -- INSERT INTO `sys_dict` ( `isActive`, `updateTime`, `updateflag`, `codeType`, `tableName`, `description`, `codeValue`, `label`, `seq`)VALUES -- ('1', now(), true, 'cerCompareStatus', NULL, '补贴比对状态', '05', '公示不通过', '5'); -- -- INSERT INTO `sys_dict` ( `isActive`, `updateTime`, `updateflag`, `codeType`, `tableName`, `description`, `codeValue`, `label`, `seq`)VALUES -- ('1', now(), true, 'compareStatus', NULL, '补贴比对状态', '05', '公示不通过', '5'); -- #平台服务费 20201026 delete from subsidyconfig where businesstype in ('006','007','008'); INSERT INTO `subsidyconfig` (`active`, `create_time`, `update_time`, `update_by`, `businessType`, `businessName`, `amount`, `percent`, `EffectiveTime`) VALUES ('', now(), now(), 'bj_super', '006', '资格证平台服务费', '40', NULL, NULL), ('', now(), now(), 'bj_super', '007', '等级证结业证平台服务费', '300', NULL, NULL), ('', now(), now(), 'bj_super', '008', '等级证鉴定证平台服务费', '500', NULL, NULL);