-- 电子签服务商数据预置脚本
IF EXISTS (SELECT 1 FROM t_hrcs_esignspmgr WHERE FID = 1732814414484112384 AND FENABLE ='0')
	DELETE FROM t_hrcs_esignspmgr WHERE FID = 1732814414484112384;
IF NOT EXISTS (SELECT 1 FROM t_hrcs_esignspmgr WHERE FID = 1732814414484112384)
	INSERT INTO t_hrcs_esignspmgr(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1732814414484112384,'1',NULL,' ',' ',1732814414484112384,'C','1020_S','金蝶云电子签',0,{ts'2023-07-19  00:00:00'},13466739,'0',{ts'2023-07-19  00:00:00'},13466739,0);

IF EXISTS (SELECT 1 FROM t_hrcs_esignspmgr WHERE FID = 1732802837861139456 AND FENABLE ='0')
	DELETE FROM t_hrcs_esignspmgr WHERE FID = 1732802837861139456;
IF NOT EXISTS (SELECT 1 FROM t_hrcs_esignspmgr WHERE FID = 1732802837861139456)
	INSERT INTO t_hrcs_esignspmgr(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1732802837861139456,'1',NULL,' ',' ',1732802837861139456,'C','1010_S','法大大（公有云）',0,{ts'2023-07-19  00:00:00'},13466739,'0',{ts'2023-07-19  00:00:00'},13466739,0);

DELETE FROM t_hrcs_esignspmgr_l WHERE FPKID = '3EUORMUETLXW';
INSERT INTO t_hrcs_esignspmgr_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1732802837861139456,'3EUORMUETLXW','zh_CN',' ',' ','法大大（公有云）');
DELETE FROM t_hrcs_esignspmgr_l WHERE FPKID = '3EUQY+R8MTHB';
INSERT INTO t_hrcs_esignspmgr_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1732814414484112384,'3EUQY+R8MTHB','zh_CN',' ',' ','金蝶云电子签');

-- delete dirty data
--法大大（公有云）
DELETE FROM t_hrcs_esignspmgrentry WHERE FENTRYID = 1732802838146352128;
DELETE FROM t_hrcs_esignspmgrentry WHERE FENTRYID = 1732802838146352129;
DELETE FROM t_hrcs_esignspmgrentry WHERE FENTRYID = 1732802838146352130;
DELETE FROM t_hrcs_esignspmgrentry WHERE FENTRYID = 1732802838146352131;
DELETE FROM t_hrcs_esignspmgrentry WHERE FENTRYID = 1732802838146352132;
DELETE FROM t_hrcs_esignspmgrentry WHERE FENTRYID = 1732802838146352133;
DELETE FROM t_hrcs_esignspmgrentry WHERE FENTRYID = 1732802838146352134;
DELETE FROM t_hrcs_esignspmgrentry WHERE FENTRYID = 1732802838146352135;
DELETE FROM t_hrcs_esignspmgrentry WHERE FENTRYID = 1732802838146352136;
DELETE FROM t_hrcs_esignspmgrentry WHERE FENTRYID = 1732802838146352137;
DELETE FROM t_hrcs_esignspmgrentry WHERE FENTRYID = 1732802838146352138;
DELETE FROM t_hrcs_esignspmgrentry WHERE FENTRYID = 1732802838146352139;
--金蝶云电子签
DELETE FROM t_hrcs_esignspmgrentry WHERE FENTRYID = 1732814414526055424;
DELETE FROM t_hrcs_esignspmgrentry WHERE FENTRYID = 1732814414526055425;
DELETE FROM t_hrcs_esignspmgrentry WHERE FENTRYID = 1732814414526055426;
DELETE FROM t_hrcs_esignspmgrentry WHERE FENTRYID = 1732814414526055427;
DELETE FROM t_hrcs_esignspmgrentry WHERE FENTRYID = 1732814414526055428;
DELETE FROM t_hrcs_esignspmgrentry WHERE FENTRYID = 1732814414526055429;
DELETE FROM t_hrcs_esignspmgrentry WHERE FENTRYID = 1732814414526055430;
DELETE FROM t_hrcs_esignspmgrentry WHERE FENTRYID = 1732814414526055431;
DELETE FROM t_hrcs_esignspmgrentry WHERE FENTRYID = 1732814414526055432;
DELETE FROM t_hrcs_esignspmgrentry WHERE FENTRYID = 1732814414526055433;
DELETE FROM t_hrcs_esignspmgrentry WHERE FENTRYID = 1732814414526055434;
DELETE FROM t_hrcs_esignspmgrentry WHERE FENTRYID = 1732814414526055435;

DELETE FROM t_hrcs_esignspmgrentry_l WHERE FPKID = '3EUORMUETLXY';
DELETE FROM t_hrcs_esignspmgrentry_l WHERE FPKID = '3EUORMUETLXZ';
DELETE FROM t_hrcs_esignspmgrentry_l WHERE FPKID = '3EUORMUETLY+';
DELETE FROM t_hrcs_esignspmgrentry_l WHERE FPKID = '3EUORMUETLY/';
DELETE FROM t_hrcs_esignspmgrentry_l WHERE FPKID = '3EUORMUETLY0';
DELETE FROM t_hrcs_esignspmgrentry_l WHERE FPKID = '3EUORMUETLY1';
DELETE FROM t_hrcs_esignspmgrentry_l WHERE FPKID = '3EUORMUETLY2';
DELETE FROM t_hrcs_esignspmgrentry_l WHERE FPKID = '3EUORMUETLY3';
DELETE FROM t_hrcs_esignspmgrentry_l WHERE FPKID = '3EUORMUETLY4';
DELETE FROM t_hrcs_esignspmgrentry_l WHERE FPKID = '3EUORMUETLY5';
DELETE FROM t_hrcs_esignspmgrentry_l WHERE FPKID = '3EUORMUETLY6';
DELETE FROM t_hrcs_esignspmgrentry_l WHERE FPKID = '3EUORMUETLY7';

DELETE FROM t_hrcs_esignspmgrentry_l WHERE FPKID = '3EUQY+R8MTHD';
DELETE FROM t_hrcs_esignspmgrentry_l WHERE FPKID = '3EUQY+R8MTHE';
DELETE FROM t_hrcs_esignspmgrentry_l WHERE FPKID = '3EUQY+R8MTHF';
DELETE FROM t_hrcs_esignspmgrentry_l WHERE FPKID = '3EUQY+R8MTHG';
DELETE FROM t_hrcs_esignspmgrentry_l WHERE FPKID = '3EUQY+R8MTHH';
DELETE FROM t_hrcs_esignspmgrentry_l WHERE FPKID = '3EUQY+R8MTHI';
DELETE FROM t_hrcs_esignspmgrentry_l WHERE FPKID = '3EUQY+R8MTHJ';
DELETE FROM t_hrcs_esignspmgrentry_l WHERE FPKID = '3EUQY+R8MTHK';
DELETE FROM t_hrcs_esignspmgrentry_l WHERE FPKID = '3EUQY+R8MTHL';
DELETE FROM t_hrcs_esignspmgrentry_l WHERE FPKID = '3EUQY+R8MTHM';
DELETE FROM t_hrcs_esignspmgrentry_l WHERE FPKID = '3EUQY+R8MTHN';
DELETE FROM t_hrcs_esignspmgrentry_l WHERE FPKID = '3EUQY+R8MTHO';

--法大大（公有云）
DELETE FROM t_hrcs_esignspmgrentry WHERE FENTRYID = 1732802838146352128;
INSERT INTO t_hrcs_esignspmgrentry(FID,FINTERFACE,FSRVDESC,FENTRYID,FPLUGIN,FSEQ,FSRVNAME,FMUSTFLAG) VALUES (1732802837861139456,'kd.hr.hrcs.bussiness.service.esign.api.CorporateAuth','企业授权接口描述',1732802838146352128,'kd.hr.hrcs.bussiness.service.esign.impl.fadada.FddCorporateAuth',1,'企业授权','1');
DELETE FROM t_hrcs_esignspmgrentry WHERE FENTRYID = 1732802838146352129;
INSERT INTO t_hrcs_esignspmgrentry(FID,FINTERFACE,FSRVDESC,FENTRYID,FPLUGIN,FSEQ,FSRVNAME,FMUSTFLAG) VALUES (1732802837861139456,'kd.hr.hrcs.bussiness.service.esign.api.CorporateSealQuery','企业印章查询接口描述',1732802838146352129,'kd.hr.hrcs.bussiness.service.esign.impl.fadada.FddCorporateSealQuery',2,'企业印章查询','1');
DELETE FROM t_hrcs_esignspmgrentry WHERE FENTRYID = 1732802838146352130;
INSERT INTO t_hrcs_esignspmgrentry(FID,FINTERFACE,FSRVDESC,FENTRYID,FPLUGIN,FSEQ,FSRVNAME,FMUSTFLAG) VALUES (1732802837861139456,'kd.hr.hrcs.bussiness.service.esign.api.CorporateSealCUD','企业印章增删改接口描述',1732802838146352130,'kd.hr.hrcs.bussiness.service.esign.impl.fadada.FddCorporateSealCUD',3,'企业印章增删改','2');
DELETE FROM t_hrcs_esignspmgrentry WHERE FENTRYID = 1732802838146352131;
INSERT INTO t_hrcs_esignspmgrentry(FID,FINTERFACE,FSRVDESC,FENTRYID,FPLUGIN,FSEQ,FSRVNAME,FMUSTFLAG) VALUES (1732802837861139456,'kd.hr.hrcs.bussiness.service.esign.api.AcrossCorporateAuth','企业印章授权接口描述',1732802838146352131,'kd.hr.hrcs.bussiness.service.esign.impl.fadada.FddAcrossCorporateAuth',4,'企业印章授权','2');
DELETE FROM t_hrcs_esignspmgrentry WHERE FENTRYID = 1732802838146352132;
INSERT INTO t_hrcs_esignspmgrentry(FID,FINTERFACE,FSRVDESC,FENTRYID,FPLUGIN,FSEQ,FSRVNAME,FMUSTFLAG) VALUES (1732802837861139456,'kd.hr.hrcs.bussiness.service.esign.api.InitiateSignTask','创建签署任务接口描述',1732802838146352132,'kd.hr.hrcs.bussiness.service.esign.impl.fadada.FddInitiateSignTask',5,'创建签署任务','1');
DELETE FROM t_hrcs_esignspmgrentry WHERE FENTRYID = 1732802838146352133;
INSERT INTO t_hrcs_esignspmgrentry(FID,FINTERFACE,FSRVDESC,FENTRYID,FPLUGIN,FSEQ,FSRVNAME,FMUSTFLAG) VALUES (1732802837861139456,'kd.hr.hrcs.bussiness.service.esign.api.ObtainSignLink','获取签署链接接口描述',1732802838146352133,'kd.hr.hrcs.bussiness.service.esign.impl.fadada.FddObtainSignLink',6,'获取签署链接','1');
DELETE FROM t_hrcs_esignspmgrentry WHERE FENTRYID = 1732802838146352134;
INSERT INTO t_hrcs_esignspmgrentry(FID,FINTERFACE,FSRVDESC,FENTRYID,FPLUGIN,FSEQ,FSRVNAME,FMUSTFLAG) VALUES (1732802837861139456,'kd.hr.hrcs.bussiness.service.esign.api.CorpSignTask','企业签署接口描述',1732802838146352134,'kd.hr.hrcs.bussiness.service.esign.impl.fadada.FddCorpSignTask',7,'企业签署','1');
DELETE FROM t_hrcs_esignspmgrentry WHERE FENTRYID = 1732802838146352135;
INSERT INTO t_hrcs_esignspmgrentry(FID,FINTERFACE,FSRVDESC,FENTRYID,FPLUGIN,FSEQ,FSRVNAME,FMUSTFLAG) VALUES (1732802837861139456,'kd.hr.hrcs.bussiness.service.esign.api.QuerySignTask','获取签署状态接口描述',1732802838146352135,'kd.hr.hrcs.bussiness.service.esign.impl.fadada.FddQuerySignTask',8,'获取签署状态','1');
--DELETE FROM t_hrcs_esignspmgrentry WHERE FENTRYID = 1732802838146352136;
--INSERT INTO t_hrcs_esignspmgrentry(FID,FINTERFACE,FSRVDESC,FENTRYID,FPLUGIN,FSEQ,FSRVNAME,FMUSTFLAG) VALUES (1732802837861139456,'kd.hr.hrcs.bussiness.service.esign.api.RemindSignTask','催办签署任务接口描述',1732802838146352136,'kd.hr.hrcs.bussiness.service.esign.impl.fadada.FddRemindSignTask',9,'催办签署任务','2');
DELETE FROM t_hrcs_esignspmgrentry WHERE FENTRYID = 1732802838146352137;
INSERT INTO t_hrcs_esignspmgrentry(FID,FINTERFACE,FSRVDESC,FENTRYID,FPLUGIN,FSEQ,FSRVNAME,FMUSTFLAG) VALUES (1732802837861139456,'kd.hr.hrcs.bussiness.service.esign.api.DownLoadSignFile','合同预览/下载接口描述',1732802838146352137,'kd.hr.hrcs.bussiness.service.esign.impl.fadada.FddDownLoadSignFile',10,'合同预览/下载','1');
--DELETE FROM t_hrcs_esignspmgrentry WHERE FENTRYID = 1732802838146352138;
--INSERT INTO t_hrcs_esignspmgrentry(FID,FINTERFACE,FSRVDESC,FENTRYID,FPLUGIN,FSEQ,FSRVNAME,FMUSTFLAG) VALUES (1732802837861139456,'kd.hr.hrcs.bussiness.service.esign.api.BatchInitiateSignTask','批量签署接口描述',1732802838146352138,'kd.hr.hrcs.bussiness.service.esign.impl.fadada.FddBatchInitiateSignTask',11,'批量签署','1');
--DELETE FROM t_hrcs_esignspmgrentry WHERE FENTRYID = 1732802838146352139;
--INSERT INTO t_hrcs_esignspmgrentry(FID,FINTERFACE,FSRVDESC,FENTRYID,FPLUGIN,FSEQ,FSRVNAME,FMUSTFLAG) VALUES (1732802837861139456,'kd.hr.hrcs.bussiness.service.esign.api.CancelSignTask','撤销签署任务接口描述',1732802838146352139,'kd.hr.hrcs.bussiness.service.esign.impl.fadada.FddCancelSignTask',12,'撤销签署任务','1');
--DELETE FROM t_hrcs_esignspmgrentry WHERE FENTRYID = 1732802838146352140;
--INSERT INTO t_hrcs_esignspmgrentry(FID,FINTERFACE,FSRVDESC,FENTRYID,FPLUGIN,FSEQ,FSRVNAME,FMUSTFLAG) VALUES (1732802837861139456,'kd.hr.hrcs.bussiness.service.esign.api.DisuseSignTask','解除签署任务接口描述',1732802838146352140,'kd.hr.hrcs.bussiness.service.esign.impl.fadada.FddDisuseSignTask',13,'解除签署任务','1');
DELETE FROM t_hrcs_esignspmgrentry WHERE FENTRYID = 1732802838146352141;
INSERT INTO t_hrcs_esignspmgrentry(FID,FINTERFACE,FSRVDESC,FENTRYID,FPLUGIN,FSEQ,FSRVNAME,FMUSTFLAG) VALUES (1732802837861139456,'kd.hr.hrcs.bussiness.service.esign.api.CallBackEvent','回调事件接口描述',1732802838146352141,'kd.hr.hrcs.bussiness.service.esign.impl.fadada.FddCallBackEvent',14,'回调事件','1');


DELETE FROM t_hrcs_esignspmgrentry_l WHERE FPKID = '3EUORMUETLXY';
INSERT INTO t_hrcs_esignspmgrentry_l(FSRVDESC,FPKID,FLOCALEID,FENTRYID,FSRVNAME) VALUES ('企业授权接口描述','3EUORMUETLXY','zh_CN',1732802838146352128,'企业授权');
DELETE FROM t_hrcs_esignspmgrentry_l WHERE FPKID = '3EUORMUETLXZ';
INSERT INTO t_hrcs_esignspmgrentry_l(FSRVDESC,FPKID,FLOCALEID,FENTRYID,FSRVNAME) VALUES ('企业印章查询接口描述','3EUORMUETLXZ','zh_CN',1732802838146352129,'企业印章查询');
DELETE FROM t_hrcs_esignspmgrentry_l WHERE FPKID = '3EUORMUETLY+';
INSERT INTO t_hrcs_esignspmgrentry_l(FSRVDESC,FPKID,FLOCALEID,FENTRYID,FSRVNAME) VALUES ('企业印章增删改接口描述','3EUORMUETLY+','zh_CN',1732802838146352130,'企业印章增删改');
DELETE FROM t_hrcs_esignspmgrentry_l WHERE FPKID = '3EUORMUETLY/';
INSERT INTO t_hrcs_esignspmgrentry_l(FSRVDESC,FPKID,FLOCALEID,FENTRYID,FSRVNAME) VALUES ('企业印章授权接口描述','3EUORMUETLY/','zh_CN',1732802838146352131,'企业印章授权');
DELETE FROM t_hrcs_esignspmgrentry_l WHERE FPKID = '3EUORMUETLY0';
INSERT INTO t_hrcs_esignspmgrentry_l(FSRVDESC,FPKID,FLOCALEID,FENTRYID,FSRVNAME) VALUES ('创建签署任务接口描述','3EUORMUETLY0','zh_CN',1732802838146352132,'创建签署任务');
DELETE FROM t_hrcs_esignspmgrentry_l WHERE FPKID = '3EUORMUETLY1';
INSERT INTO t_hrcs_esignspmgrentry_l(FSRVDESC,FPKID,FLOCALEID,FENTRYID,FSRVNAME) VALUES ('获取签署链接接口描述','3EUORMUETLY1','zh_CN',1732802838146352133,'获取签署链接');
DELETE FROM t_hrcs_esignspmgrentry_l WHERE FPKID = '3EUORMUETLY2';
INSERT INTO t_hrcs_esignspmgrentry_l(FSRVDESC,FPKID,FLOCALEID,FENTRYID,FSRVNAME) VALUES ('企业签署接口描述','3EUORMUETLY2','zh_CN',1732802838146352134,'企业签署');
DELETE FROM t_hrcs_esignspmgrentry_l WHERE FPKID = '3EUORMUETLY3';
INSERT INTO t_hrcs_esignspmgrentry_l(FSRVDESC,FPKID,FLOCALEID,FENTRYID,FSRVNAME) VALUES ('获取签署状态接口描述','3EUORMUETLY3','zh_CN',1732802838146352135,'获取签署状态');
--DELETE FROM t_hrcs_esignspmgrentry_l WHERE FPKID = '3EUORMUETLY4';
--INSERT INTO t_hrcs_esignspmgrentry_l(FSRVDESC,FPKID,FLOCALEID,FENTRYID,FSRVNAME) VALUES ('催办签署任务接口描述','3EUORMUETLY4','zh_CN',1732802838146352136,'催办签署任务');
DELETE FROM t_hrcs_esignspmgrentry_l WHERE FPKID = '3EUORMUETLY5';
INSERT INTO t_hrcs_esignspmgrentry_l(FSRVDESC,FPKID,FLOCALEID,FENTRYID,FSRVNAME) VALUES ('合同预览/下载接口描述','3EUORMUETLY5','zh_CN',1732802838146352137,'合同预览/下载');
--DELETE FROM t_hrcs_esignspmgrentry_l WHERE FPKID = '3EUORMUETLY6';
--INSERT INTO t_hrcs_esignspmgrentry_l(FSRVDESC,FPKID,FLOCALEID,FENTRYID,FSRVNAME) VALUES ('批量签署接口描述','3EUORMUETLY6','zh_CN',1732802838146352138,'批量签署');
--DELETE FROM t_hrcs_esignspmgrentry_l WHERE FPKID = '3EUORMUETLY7';
--INSERT INTO t_hrcs_esignspmgrentry_l(FSRVDESC,FPKID,FLOCALEID,FENTRYID,FSRVNAME) VALUES ('撤销签署任务接口描述','3EUORMUETLY7','zh_CN',1732802838146352139,'撤销签署任务');
--DELETE FROM t_hrcs_esignspmgrentry_l WHERE FPKID = '3EUORMUETLY8';
--INSERT INTO t_hrcs_esignspmgrentry_l(FSRVDESC,FPKID,FLOCALEID,FENTRYID,FSRVNAME) VALUES ('解除签署任务接口描述','3EUORMUETLY8','zh_CN',1732802838146352140,'解除签署任务');
DELETE FROM t_hrcs_esignspmgrentry_l WHERE FPKID = '3EUORMUETLY9';
INSERT INTO t_hrcs_esignspmgrentry_l(FSRVDESC,FPKID,FLOCALEID,FENTRYID,FSRVNAME) VALUES ('回调事件接口描述','3EUORMUETLY9','zh_CN',1732802838146352141,'回调事件');



