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


