-- 新增协作操作 更新发放设置（1150_S）
DELETE FROM t_hpdi_triggercolla WHERE FID = 1747766440636712960;
INSERT INTO t_hpdi_triggercolla(FID,FALIAS,FENTITYOBJECTID,FISSYSPRESET,FOPERATIONTYPEID,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FOPERATIONCLSID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FBIZAPPID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1747766440636712960,'更新发放设置','hsas_paysetting','1',1747751690569778176,NULL,' ',' ',1747766440636712960,1010,'C','1150_S','更新发放设置',0,{ts'2023-08-09  00:00:00'},1632490550739337216,'1','/UHMBBGZQ65X',{ts'2023-08-18  00:00:00'},1632490550739337216,0);

DELETE FROM t_hpdi_triggercolla_l WHERE FPKID = '3GOCN508PS9N';
--INSERT INTO t_hpdi_triggercolla_l(FID,FALIAS,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1747766440636712960,' ','3GOCN508PS9N','zh_TW',' ',' ','更新發放設置');
DELETE FROM t_hpdi_triggercolla_l WHERE FPKID = '3GOCN508PS9M';
INSERT INTO t_hpdi_triggercolla_l(FID,FALIAS,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1747766440636712960,'更新发放设置','3GOCN508PS9M','zh_CN',' ',' ','更新发放设置');


-- 新增协作活动 更新发放设置（1030_S）
DELETE FROM t_hpdi_payrollact WHERE FID = 1747770021473421312;
INSERT INTO t_hpdi_payrollact(FID,FALIAS,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FBIZAPPID,FPREPAYROLLACTID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1747770021473421312,'更新发放设置','1',NULL,' ',' ',1747770021473421312,'C','1030_S','更新发放设置',0,{ts'2023-08-09  00:00:00'},1632490550739337216,'1','/UHMBBGZQ65X',1010,{ts'2023-08-18  00:00:00'},1632490550739337216,0);

DELETE FROM t_hpdi_payrollact_l WHERE FPKID = '3GODA8ML9OYJ';
INSERT INTO t_hpdi_payrollact_l(FID,FALIAS,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1747770021473421312,'更新发放设置','3GODA8ML9OYJ','zh_CN',' ',' ','更新发放设置');
DELETE FROM t_hpdi_payrollact_l WHERE FPKID = '3GODA8ML9OYK';
--INSERT INTO t_hpdi_payrollact_l(FID,FALIAS,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1747770021473421312,' ','3GODA8ML9OYK','zh_TW',' ',' ','更新發放設置');

-- 协作活动分录添加协作操作 更新发放设置
DELETE FROM t_hpdi_payrollactent WHERE FENTRYID = 1747770021632804864;
INSERT INTO t_hpdi_payrollactent(FID,FENTRYID,FSEQ,FTRIGGERCOLLAID,FEXECUTESEQ) VALUES (1747770021473421312,1747770021632804864,1,1747766440636712960,0);


-- 协作规则模板 薪资协作模板（1010_S）
-- 修改模板描述
update t_hpdi_payrollactgtpl set fdescription = '用于员工发生入职、转正、调动、外派、兼职、离职后，需要同步计薪人员、维护人员薪资档案、更新发放设置等协作场景' where fid = 1010;
update t_hpdi_payrollactgtpl_l set fdescription = '用于员工发生入职、转正、调动、外派、兼职、离职后，需要同步计薪人员、维护人员薪资档案、更新发放设置等协作场景' where fpkid = '0R9UY3SYUZ72';

-- 分录修改协作活动 生成人员变动记录 的“执行顺序”为4
update t_hpdi_payrollactgtplent set fseq = 4, fexecuteseq = 4 where fentryid = 1641351804513998848;

-- 分录新增协作活动 更新发放设置
DELETE FROM t_hpdi_payrollactgtplent WHERE FENTRYID = 1747774430089578496;
INSERT INTO t_hpdi_payrollactgtplent(FID,FISMUSTEXECUTE,FENTRYID,FSEQ,FEXECUTESEQ,FPAYROLLACTID) VALUES (1010,'0',1747774430089578496,3,3,1747770021473421312);


