DELETE FROM t_msg_tplscene WHERE FID = 1386958661427026944;
INSERT INTO t_msg_tplscene(FID,FMODIFYDATE,FISPREINSDATA,FCREATEDATE,FENTITYNUMBER,FNUMBER,FNAME) VALUES (1386958661427026944,{ts'2022-03-29  00:00:00'},'0',{ts'2022-03-29  00:00:00'},'hom_activeinfobody','OBD015','入职协作处理-转交');
DELETE FROM t_msg_tplscene WHERE FID = 1386959009428316160;
INSERT INTO t_msg_tplscene(FID,FMODIFYDATE,FISPREINSDATA,FCREATEDATE,FENTITYNUMBER,FNUMBER,FNAME) VALUES (1386959009428316160,{ts'2022-03-29  00:00:00'},'0',{ts'2022-03-29  00:00:00'},'hom_activeinfobody','OBD016','入职协作管理-转交');
DELETE FROM t_msg_tplscene WHERE FID = 1371052008638797824;
INSERT INTO t_msg_tplscene(FID,FMODIFYDATE,FISPREINSDATA,FCREATEDATE,FENTITYNUMBER,FNUMBER,FNAME) VALUES (1371052008638797824,{ts'2022-03-07  00:00:00'},'0',{ts'2022-03-07  00:00:00'},'hom_onbrdbilltpl','OBD005','信息采集提醒');
DELETE FROM t_msg_tplscene WHERE FID = 1371050635138444288;
INSERT INTO t_msg_tplscene(FID,FMODIFYDATE,FISPREINSDATA,FCREATEDATE,FENTITYNUMBER,FNUMBER,FNAME) VALUES (1371050635138444288,{ts'2022-03-07  00:00:00'},'0',{ts'2022-03-07  00:00:00'},'hom_onbrdbilltpl','OBD003','邀约登录提醒');
DELETE FROM t_msg_tplscene WHERE FID = 1371051159065734144;
INSERT INTO t_msg_tplscene(FID,FMODIFYDATE,FISPREINSDATA,FCREATEDATE,FENTITYNUMBER,FNUMBER,FNAME) VALUES (1371051159065734144,{ts'2022-03-07  00:00:00'},'0',{ts'2022-03-07  00:00:00'},'hom_onbrdbilltpl','OBD004','邀约登录提醒');
DELETE FROM t_msg_tplscene WHERE FID = 1371051841906825216;
INSERT INTO t_msg_tplscene(FID,FMODIFYDATE,FISPREINSDATA,FCREATEDATE,FENTITYNUMBER,FNUMBER,FNAME) VALUES (1371051841906825216,{ts'2022-03-07  00:00:00'},'0',{ts'2022-03-07  00:00:00'},'hom_onbrdbilltpl','OBD002','入职邀约发送');
DELETE FROM t_msg_tplscene WHERE FID = 1371052389951351808;
INSERT INTO t_msg_tplscene(FID,FMODIFYDATE,FISPREINSDATA,FCREATEDATE,FENTITYNUMBER,FNUMBER,FNAME) VALUES (1371052389951351808,{ts'2022-03-07  00:00:00'},'0',{ts'2022-03-07  00:00:00'},'hom_onbrdbilltpl','OBD006','信息审核通过提醒');
DELETE FROM t_msg_tplscene WHERE FID = 1371052767405168640;
INSERT INTO t_msg_tplscene(FID,FMODIFYDATE,FISPREINSDATA,FCREATEDATE,FENTITYNUMBER,FNUMBER,FNAME) VALUES (1371052767405168640,{ts'2022-03-07  00:00:00'},'0',{ts'2022-03-07  00:00:00'},'hom_onbrdbilltpl','OBD007','信息不审核通过提醒');
DELETE FROM t_msg_tplscene WHERE FID = 1371052940571203584;
INSERT INTO t_msg_tplscene(FID,FMODIFYDATE,FISPREINSDATA,FCREATEDATE,FENTITYNUMBER,FNUMBER,FNAME) VALUES (1371052940571203584,{ts'2022-03-07  00:00:00'},'0',{ts'2022-03-07  00:00:00'},'hom_onbrdbilltpl','OBD008','信息驳回提醒');
DELETE FROM t_msg_tplscene WHERE FID = 1371053093168360448;
INSERT INTO t_msg_tplscene(FID,FMODIFYDATE,FISPREINSDATA,FCREATEDATE,FENTITYNUMBER,FNUMBER,FNAME) VALUES (1371053093168360448,{ts'2022-03-07  00:00:00'},'0',{ts'2022-03-07  00:00:00'},'hom_onbrdbilltpl','OBD009','入职预约结果提醒');
DELETE FROM t_msg_tplscene WHERE FID = 1371053226035522560;
INSERT INTO t_msg_tplscene(FID,FMODIFYDATE,FISPREINSDATA,FCREATEDATE,FENTITYNUMBER,FNUMBER,FNAME) VALUES (1371053226035522560,{ts'2022-03-07  00:00:00'},'0',{ts'2022-03-07  00:00:00'},'hom_onbrdbilltpl','OBD010','入职有效期截止提醒');
DELETE FROM t_msg_tplscene WHERE FID = 1371053422857443328;
INSERT INTO t_msg_tplscene(FID,FMODIFYDATE,FISPREINSDATA,FCREATEDATE,FENTITYNUMBER,FNUMBER,FNAME) VALUES (1371053422857443328,{ts'2022-03-07  00:00:00'},'0',{ts'2022-03-07  00:00:00'},'hom_onbrdbilltpl','OBD011','入职有效期截止提醒');
DELETE FROM t_msg_tplscene WHERE FID = 1371053827741997056;
INSERT INTO t_msg_tplscene(FID,FMODIFYDATE,FISPREINSDATA,FCREATEDATE,FENTITYNUMBER,FNUMBER,FNAME) VALUES (1371053827741997056,{ts'2022-03-07  00:00:00'},'0',{ts'2022-03-07  00:00:00'},'hom_onbrdbilltpl','OBD012','终止入职知会');
DELETE FROM t_msg_tplscene WHERE FID = 1371053957220150272;
INSERT INTO t_msg_tplscene(FID,FMODIFYDATE,FISPREINSDATA,FCREATEDATE,FENTITYNUMBER,FNUMBER,FNAME) VALUES (1371053957220150272,{ts'2022-03-07  00:00:00'},'0',{ts'2022-03-07  00:00:00'},'hom_onbrdbilltpl','OBD013','确认入职成功');
DELETE FROM t_msg_tplscene WHERE FID = 1407110954465889280;
INSERT INTO t_msg_tplscene(FID,FMODIFYDATE,FISPREINSDATA,FCREATEDATE,FENTITYNUMBER,FNUMBER,FNAME) VALUES (1407110954465889280,{ts'2022-04-26  00:00:00'},'0',{ts'2022-04-26  00:00:00'},'hom_onbrdbilltpl','OBD018','信息验收通过提醒');
DELETE FROM t_msg_tplscene WHERE FID = 1407111134837736448;
INSERT INTO t_msg_tplscene(FID,FMODIFYDATE,FISPREINSDATA,FCREATEDATE,FENTITYNUMBER,FNUMBER,FNAME) VALUES (1407111134837736448,{ts'2022-04-26  00:00:00'},'0',{ts'2022-04-26  00:00:00'},'hom_onbrdbilltpl','OBD019','信息验收不通过提醒');
DELETE FROM t_msg_tplscene WHERE FID = 1407113809125966848;
INSERT INTO t_msg_tplscene(FID,FMODIFYDATE,FISPREINSDATA,FCREATEDATE,FENTITYNUMBER,FNUMBER,FNAME) VALUES (1407113809125966848,{ts'2022-04-26  00:00:00'},'0',{ts'2022-04-26  00:00:00'},'hom_activeinfobody','OBD017','协作待处理项定时提醒');
DELETE FROM t_msg_tplscene_l WHERE FPKID = '2DUAMFFD9T/Q';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1407110954465889280,'2DUAMFFD9T/Q','zh_CN','信息验收通过提醒');

DELETE FROM t_msg_tplscene_l WHERE FPKID = '2DUANRPJ6CEX';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1407111134837736448,'2DUANRPJ6CEX','zh_CN','信息验收不通过提醒');

DELETE FROM t_msg_tplscene_l WHERE FPKID = '2DUB58Q/RSY2';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1407113809125966848,'2DUB58Q/RSY2','zh_CN','协作待处理项定时提醒');

DELETE FROM t_msg_tplscene_l WHERE FPKID = '2=DKA14+A/SH';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1371052767405168640,'2=DKA14+A/SH','zh_CN','信息不审核通过提醒');

DELETE FROM t_msg_tplscene_l WHERE FPKID = '2=DKBAB9FXCN';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1371052940571203584,'2=DKBAB9FXCN','zh_CN','信息驳回提醒');

DELETE FROM t_msg_tplscene_l WHERE FPKID = '2=DKCEPKKY06';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1371053093168360448,'2=DKCEPKKY06','zh_CN','入职预约结果提醒');
DELETE FROM t_msg_tplscene_l WHERE FPKID = '2=DJXI5/28PI';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1371050635138444288,'2=DJXI5/28PI','zh_CN','邀约登录提醒');

DELETE FROM t_msg_tplscene_l WHERE FPKID = '2=DK/B0Z246R';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1371051159065734144,'2=DK/B0Z246R','zh_CN','邀约登录提醒');

DELETE FROM t_msg_tplscene_l WHERE FPKID = '2=DK4A37L=L0';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1371051841906825216,'2=DK4A37L=L0','zh_CN','入职邀约发送');

DELETE FROM t_msg_tplscene_l WHERE FPKID = '2=DK5IH6KQEV';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1371052008638797824,'2=DK5IH6KQEV','zh_CN','信息采集提醒');

DELETE FROM t_msg_tplscene_l WHERE FPKID = '2=DK8=VGF1AF';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1371052389951351808,'2=DK8=VGF1AF','zh_CN','信息审核通过提醒');


DELETE FROM t_msg_tplscene_l WHERE FPKID = '2=DKDDG7=76R';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1371053226035522560,'2=DKDDG7=76R','zh_CN','入职有效期截止提醒');

DELETE FROM t_msg_tplscene_l WHERE FPKID = '2=DKEUDOURM8';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1371053422857443328,'2=DKEUDOURM8','zh_CN','入职有效期截止提醒');

DELETE FROM t_msg_tplscene_l WHERE FPKID = '2=DKHSG7ULE0';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1371053827741997056,'2=DKHSG7ULE0','zh_CN','终止入职知会');

DELETE FROM t_msg_tplscene_l WHERE FPKID = '2=DKIQ9=MB58';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1371053957220150272,'2=DKIQ9=MB58','zh_CN','确认入职成功');

DELETE FROM t_msg_tplscene_l WHERE FPKID = '2BBS909=Z+M2';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1386958661427026944,'2BBS909=Z+M2','zh_CN','入职协作处理-转交');

DELETE FROM t_msg_tplscene_l WHERE FPKID = '2BBSAK5CW=VX';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1386959009428316160,'2BBSAK5CW=VX','zh_CN','入职协作管理-转交');

DELETE FROM t_msg_template WHERE FID = 1407115481680186368;
INSERT INTO t_msg_template(FID,FMODIFYDATE,FMSGSCENENAME,FCREATEDATE,FCOMMONLANG,FMSGENTITY,FNUMBER,FNAME,FMSGTYPE,FMSGCHANNEL,FBIZPLUGIN,FMSGTEMPLATE,FMSGSCENE) VALUES (1407115481680186368,{ts'2022-05-01  00:00:00'},'信息验收不通过提醒',{ts'2022-04-26  00:00:00'},'{"content":"亲爱的{name}，您好！您的资料验收事项未通过，如有疑问，请入职服务人员。"}','hom_onbrdbilltpl','OBD019','信息验收不通过提醒','message','sms',' ',NULL,'OBD019');
DELETE FROM t_msg_template WHERE FID = 1407109870531906560;
INSERT INTO t_msg_template(FID,FMODIFYDATE,FMSGSCENENAME,FCREATEDATE,FCOMMONLANG,FMSGENTITY,FNUMBER,FNAME,FMSGTYPE,FMSGCHANNEL,FBIZPLUGIN,FMSGTEMPLATE,FMSGSCENE) VALUES (1407109870531906560,{ts'2022-05-01  00:00:00'},'信息验收通过提醒',{ts'2022-04-26  00:00:00'},'{"content":"亲爱的{name}，您好！您的资料验收已通过，请登录入职服务平台：{url} 查看后续流程，期待您的加入。 "}','hom_onbrdbilltpl','OBD018','信息验收通过提醒','message','sms',' ',NULL,'OBD018');
DELETE FROM t_msg_template WHERE FID = 1371040063965637632;
INSERT INTO t_msg_template(FID,FMODIFYDATE,FMSGSCENENAME,FCREATEDATE,FCOMMONLANG,FMSGENTITY,FNUMBER,FNAME,FMSGTYPE,FMSGCHANNEL,FBIZPLUGIN,FMSGTEMPLATE,FMSGSCENE) VALUES (1371040063965637632,{ts'2022-05-01  00:00:00'},'信息不审核通过提醒',{ts'2022-03-07  00:00:00'},'{"content":"亲爱的{name}，您好！您的信息采集资料未通过审核，如有疑问，请联系HR。"}','hom_onbrdbilltpl','OBD007','信息不审核通过提醒','message','sms',' ',NULL,'OBD007');
DELETE FROM t_msg_template WHERE FID = 1371038331516770304;
INSERT INTO t_msg_template(FID,FMODIFYDATE,FMSGSCENENAME,FCREATEDATE,FCOMMONLANG,FMSGENTITY,FNUMBER,FNAME,FMSGTYPE,FMSGCHANNEL,FBIZPLUGIN,FMSGTEMPLATE,FMSGSCENE) VALUES (1371038331516770304,{ts'2022-05-01  00:00:00'},'信息采集提醒',{ts'2022-03-07  00:00:00'},'{"content":"亲爱的{name}，您好！您有一个信息采集任务需要完成，请尽快填写。"}','hom_onbrdbilltpl','OBD005','信息采集提醒','message','sms',' ',NULL,'OBD005');
DELETE FROM t_msg_template WHERE FID = 1335375715809385472;
INSERT INTO t_msg_template(FID,FMODIFYDATE,FMSGSCENENAME,FCREATEDATE,FCOMMONLANG,FMSGENTITY,FNUMBER,FNAME,FMSGTYPE,FMSGCHANNEL,FBIZPLUGIN,FMSGTEMPLATE,FMSGSCENE) VALUES (1335375715809385472,{ts'2022-05-01  00:00:00'},'邀约登录提醒',{ts'2022-01-17  00:00:00'},'{"content":"亲爱的{name}，您好！感谢您选择{model.acompany.name}作为进入社会大家庭的第一步！有关入职相关事宜及待办事项已发送您的邮箱，请及时处理~网址链接：{url} (邮件内容可能被误收进垃圾箱)"}','hom_onbrdbilltpl','OBD004','邀约登录提醒','message','sms',' ',NULL,'OBD004');
DELETE FROM t_msg_template WHERE FID = 1335372449788746752;
INSERT INTO t_msg_template(FID,FMODIFYDATE,FMSGSCENENAME,FCREATEDATE,FCOMMONLANG,FMSGENTITY,FNUMBER,FNAME,FMSGTYPE,FMSGCHANNEL,FBIZPLUGIN,FMSGTEMPLATE,FMSGSCENE) VALUES (1335372449788746752,{ts'2022-05-01  00:00:00'},'邀约登录提醒',{ts'2022-01-17  00:00:00'},'{"content":"亲爱的{name}，您好！有一封入职欢迎信已经发送到您的邮箱，请及时处理哦~网址链接：{url} (邮件内容可能被误收进垃圾箱)"}','hom_onbrdbilltpl','OBD003','邀约登录提醒','message','sms',' ',NULL,'OBD003');
DELETE FROM t_msg_template WHERE FID = 1371023195624200192;
INSERT INTO t_msg_template(FID,FMODIFYDATE,FMSGSCENENAME,FCREATEDATE,FCOMMONLANG,FMSGENTITY,FNUMBER,FNAME,FMSGTYPE,FMSGCHANNEL,FBIZPLUGIN,FMSGTEMPLATE,FMSGSCENE) VALUES (1371023195624200192,{ts'2022-05-01  00:00:00'},'入职邀约发送',{ts'2022-03-07  00:00:00'},'{"content":"亲爱的{name}，您好！感谢您加入{model.acompany.name}！有关入职相关事宜及待办事项已发送您的邮箱，请及时查看并登录入职服务平台完成您的待办事项，网址链接：{url} (邮件内容可能被误收进垃圾箱)"}','hom_onbrdbilltpl','OBD002','入职邀约发送','message','sms',' ',NULL,'OBD002');
DELETE FROM t_msg_template WHERE FID = 1371039437277911040;
INSERT INTO t_msg_template(FID,FMODIFYDATE,FMSGSCENENAME,FCREATEDATE,FCOMMONLANG,FMSGENTITY,FNUMBER,FNAME,FMSGTYPE,FMSGCHANNEL,FBIZPLUGIN,FMSGTEMPLATE,FMSGSCENE) VALUES (1371039437277911040,{ts'2022-05-01  00:00:00'},'信息审核通过提醒',{ts'2022-03-07  00:00:00'},'{"content":"亲爱的{name}，您好！您的信息采集资料已通过，请登录入职服务平台：{url} 查看后续流程，期待您的加入。"}','hom_onbrdbilltpl','OBD006','信息审核通过提醒','message','sms',' ',NULL,'OBD006');
DELETE FROM t_msg_template WHERE FID = 1371040859709003776;
INSERT INTO t_msg_template(FID,FMODIFYDATE,FMSGSCENENAME,FCREATEDATE,FCOMMONLANG,FMSGENTITY,FNUMBER,FNAME,FMSGTYPE,FMSGCHANNEL,FBIZPLUGIN,FMSGTEMPLATE,FMSGSCENE) VALUES (1371040859709003776,{ts'2022-05-01  00:00:00'},'信息驳回提醒',{ts'2022-03-07  00:00:00'},'{"content":"您的信息采集内容被驳回，请点击链接修改后重新提交，{url} "}','hom_onbrdbilltpl','OBD008','信息驳回提醒','message','sms',' ',NULL,'OBD008');
DELETE FROM t_msg_template WHERE FID = 1371044629104831488;
INSERT INTO t_msg_template(FID,FMODIFYDATE,FMSGSCENENAME,FCREATEDATE,FCOMMONLANG,FMSGENTITY,FNUMBER,FNAME,FMSGTYPE,FMSGCHANNEL,FBIZPLUGIN,FMSGTEMPLATE,FMSGSCENE) VALUES (1371044629104831488,{ts'2022-05-01  00:00:00'},'入职预约结果提醒',{ts'2022-03-07  00:00:00'},'{"content":"亲爱的{name}，您已完成入职预约事项，待其他待办事项完成之后，请于{effectdate}前往{model.onbrdtcity.address}办理入职。"}','hom_onbrdbilltpl','OBD009','入职预约结果提醒','message','sms',' ',NULL,'OBD009');
DELETE FROM t_msg_template WHERE FID = 1371046082305349632;
INSERT INTO t_msg_template(FID,FMODIFYDATE,FMSGSCENENAME,FCREATEDATE,FCOMMONLANG,FMSGENTITY,FNUMBER,FNAME,FMSGTYPE,FMSGCHANNEL,FBIZPLUGIN,FMSGTEMPLATE,FMSGSCENE) VALUES (1371046082305349632,{ts'2022-05-01  00:00:00'},'入职有效期截止提醒',{ts'2022-03-07  00:00:00'},'{"emailTitle":"入职有效期提醒","emailContent":"<p>亲爱的{name}，您好！<br />距离您的入职有效期{validuntil}还有一周，请您按照入职邀约尽快完成入职预约，谢谢！如您无法在入职有效期内入职，请尽快联系入职服务人员。</p>\n<p> </p>"}','hom_onbrdbilltpl','OBD010','入职有效期截止提醒','message','email',' ',NULL,'OBD010');
DELETE FROM t_msg_template WHERE FID = 1371047453171668992;
INSERT INTO t_msg_template(FID,FMODIFYDATE,FMSGSCENENAME,FCREATEDATE,FCOMMONLANG,FMSGENTITY,FNUMBER,FNAME,FMSGTYPE,FMSGCHANNEL,FBIZPLUGIN,FMSGTEMPLATE,FMSGSCENE) VALUES (1371047453171668992,{ts'2022-05-01  00:00:00'},'入职有效期截止提醒',{ts'2022-03-07  00:00:00'},'{"content":"您的入职有效期即将过期，请尽快完成入职预约~"}','hom_onbrdbilltpl','OBD011','入职有效期截止提醒','message','sms',' ',NULL,'OBD011');
DELETE FROM t_msg_template WHERE FID = 1371048128001616896;
INSERT INTO t_msg_template(FID,FMODIFYDATE,FMSGSCENENAME,FCREATEDATE,FCOMMONLANG,FMSGENTITY,FNUMBER,FNAME,FMSGTYPE,FMSGCHANNEL,FBIZPLUGIN,FMSGTEMPLATE,FMSGSCENE) VALUES (1371048128001616896,{ts'2022-05-01  00:00:00'},'终止入职知会',{ts'2022-03-07  00:00:00'},'{"emailTitle":"终止入职知会","emailContent":"<p>亲爱的{name}，您好！<br />很遗憾不能与您并肩奋斗，您的入职流程已终止。<br />祝身体健康，事业有成！</p>"}','hom_onbrdbilltpl','OBD012','终止入职知会','message','email',' ',NULL,'OBD012');
DELETE FROM t_msg_template WHERE FID = 1371048775417616384;
INSERT INTO t_msg_template(FID,FMODIFYDATE,FMSGSCENENAME,FCREATEDATE,FCOMMONLANG,FMSGENTITY,FNUMBER,FNAME,FMSGTYPE,FMSGCHANNEL,FBIZPLUGIN,FMSGTEMPLATE,FMSGSCENE) VALUES (1371048775417616384,{ts'2022-05-01  00:00:00'},'确认入职成功',{ts'2022-03-07  00:00:00'},'{"content":"亲爱的{name}，您已报到成功，成为{model.acompany.name}的正式一员，期待以后并肩奋斗的时光，接下来请根据入职服务人员指引完成后续事项。"}','hom_onbrdbilltpl','OBD013','确认入职成功','message','sms',' ',NULL,'OBD013');
DELETE FROM t_msg_template WHERE FID = 1410358253258310656;
INSERT INTO t_msg_template(FID,FMODIFYDATE,FMSGSCENENAME,FCREATEDATE,FCOMMONLANG,FMSGENTITY,FNUMBER,FNAME,FMSGTYPE,FMSGCHANNEL,FBIZPLUGIN,FMSGTEMPLATE,FMSGSCENE) VALUES (1410358253258310656,{ts'2022-05-01  00:00:00'},'无',{ts'2022-04-30  00:00:00'},'{"content":"亲爱的{model.name}，距离您入职已不足三天，请尽快完成信息提交，以免影响您的入职进度，[链接地址]{activityUrl}，快来填写吧！"}','hom_onbrdbillbase','OBD014','信息采集定时提醒','alarm','sms',' ',NULL,'default');
DELETE FROM t_msg_template WHERE FID = 1386953560960311296;
INSERT INTO t_msg_template(FID,FMODIFYDATE,FMSGSCENENAME,FCREATEDATE,FCOMMONLANG,FMSGENTITY,FNUMBER,FNAME,FMSGTYPE,FMSGCHANNEL,FBIZPLUGIN,FMSGTEMPLATE,FMSGSCENE) VALUES (1386953560960311296,{ts'2022-05-01  00:00:00'},'入职协作处理-转交',{ts'2022-03-29  00:00:00'},'{"title":"转交","content":"您好，一条待处理的入职活动任务已被{model.modifier.name}转交给您，请在{model.latestdeadline}前完成。活动任务详情如下：活动项-{model.activity.name}，入职员工-{model.onbrdid.name}，点击快速处理。"}','hom_activeinfobody','OBD015','入职协作处理-转交','message','mcenter',' ',NULL,'OBD015');
DELETE FROM t_msg_template WHERE FID = 1386957871673024512;
INSERT INTO t_msg_template(FID,FMODIFYDATE,FMSGSCENENAME,FCREATEDATE,FCOMMONLANG,FMSGENTITY,FNUMBER,FNAME,FMSGTYPE,FMSGCHANNEL,FBIZPLUGIN,FMSGTEMPLATE,FMSGSCENE) VALUES (1386957871673024512,{ts'2022-05-01  00:00:00'},'入职协作管理-转交',{ts'2022-03-29  00:00:00'},'{"title":"转交","content":"您好，一条待处理的入职活动任务已被{model.modifier.name}转交给您，请在{model.latestdeadline}前完成。活动任务详情如下：活动项-{model.activity.name}，入职员工-{model.onbrdid.name}，点击快速处理。"}','hom_activeinfobody','OBD016','入职协作管理-转交','message','mcenter',' ',NULL,'OBD016');
DELETE FROM t_msg_template WHERE FID = 1407114813477227520;
INSERT INTO t_msg_template(FID,FMODIFYDATE,FMSGSCENENAME,FCREATEDATE,FCOMMONLANG,FMSGENTITY,FNUMBER,FNAME,FMSGTYPE,FMSGCHANNEL,FBIZPLUGIN,FMSGTEMPLATE,FMSGSCENE) VALUES (1407114813477227520,{ts'2022-05-01  00:00:00'},'协作待处理项定时提醒',{ts'2022-04-26  00:00:00'},'{"content":"您共有{0}个入职协作任务，请尽快处理，点击下方【快速处理】链接处理；其中，{0}为变量，等于用户\n待处理列表的单据总数"}','hom_activeinfobody','OBD017','协作待处理项定时提醒','message','mcenter',' ',NULL,'OBD017');
DELETE FROM t_msg_template_l WHERE FPKID = '2E7WCFVTM+8W';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1410358253258310656,'无','2E7WCFVTM+8W','zh_CN','{"content":"亲爱的{model.name}，距离您入职已不足三天，请尽快完成信息提交，以免影响您的入职进度，[链接地址]{activityUrl}，快来填写吧！"}','信息采集定时提醒');

DELETE FROM t_msg_template_l WHERE FPKID = '2BBR=VR9Z=ZW';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1386953560960311296,'入职协作处理-转交','2BBR=VR9Z=ZW','zh_CN','{"title":"转交","content":"您好，一条待处理的入职活动任务已被{model.modifier.name}转交给您，请在{model.latestdeadline}前完成。活动任务详情如下：活动项-{model.activity.name}，入职员工-{model.onbrdid.name}，点击快速处理。"}','入职协作处理-转交');

DELETE FROM t_msg_template_l WHERE FPKID = '2BBS39U1PWDJ';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1386957871673024512,'入职协作管理-转交','2BBS39U1PWDJ','zh_CN','{"title":"转交","content":"您好，一条待处理的入职活动任务已被{model.modifier.name}转交给您，请在{model.latestdeadline}前完成。活动任务详情如下：活动项-{model.activity.name}，入职员工-{model.onbrdid.name}，点击快速处理。"}','入职协作管理-转交');

DELETE FROM t_msg_template_l WHERE FPKID = '2=DESK13LWWQ';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1371023195624200192,'入职邀约发送','2=DESK13LWWQ','zh_CN','{"content":"亲爱的{name}，您好！感谢您加入{model.acompany.name}！有关入职相关事宜及待办事项已发送您的邮箱，请及时查看并登录入职服务平台完成您的待办事项，网址链接：{url} (邮件内容可能被误收进垃圾箱)"}','入职邀约发送');
DELETE FROM t_msg_template_l WHERE FPKID = '26/ML6DYJOR+';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1335372449788746752,'邀约登录提醒','26/ML6DYJOR+','zh_CN','{"content":"亲爱的{name}，您好！有一封入职欢迎信已经发送到您的邮箱，请及时处理哦~网址链接：{url} (邮件内容可能被误收进垃圾箱)"}','邀约登录提醒');
DELETE FROM t_msg_template_l WHERE FPKID = '26/N7+KWB77C';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1335375715809385472,'邀约登录提醒','26/N7+KWB77C','zh_CN','{"content":"亲爱的{name}，您好！感谢您选择{model.acompany.name}作为进入社会大家庭的第一步！有关入职相关事宜及待办事项已发送您的邮箱，请及时处理~网址链接：{url} (邮件内容可能被误收进垃圾箱)"}','邀约登录提醒');
DELETE FROM t_msg_template_l WHERE FPKID = '2DUAEJDLQ9HM';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1407109870531906560,'信息验收通过提醒','2DUAEJDLQ9HM','zh_CN','{"content":"亲爱的{name}，您好！您的资料验收已通过，请登录入职服务平台：{url} 查看后续流程，期待您的加入。 "}','信息验收通过提醒');

DELETE FROM t_msg_template_l WHERE FPKID = '2DUBBK4R5BX2';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1407114813477227520,'协作待处理项定时提醒','2DUBBK4R5BX2','zh_CN','{"content":"您共有{0}个入职协作任务，请尽快处理，点击下方【快速处理】链接处理；其中，{0}为变量，等于用户\n待处理列表的单据总数"}','协作待处理项定时提醒');

DELETE FROM t_msg_template_l WHERE FPKID = '2DUBGF0S96JA';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1407115481680186368,'信息验收不通过提醒','2DUBGF0S96JA','zh_CN','{"content":"亲爱的{name}，您好！您的资料验收事项未通过，如有疑问，请入职服务人员。"}','信息验收不通过提醒');

DELETE FROM t_msg_template_l WHERE FPKID = '2=DHLVJT4W=S';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1371038331516770304,'信息采集提醒','2=DHLVJT4W=S','zh_CN','{"content":"亲爱的{name}，您好！您有一个信息采集任务需要完成，请尽快填写。"}','信息采集提醒');

DELETE FROM t_msg_template_l WHERE FPKID = '2=DISR=3SEUV';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1371044629104831488,'入职预约结果提醒','2=DISR=3SEUV','zh_CN','{"content":"亲爱的{name}，您已完成入职预约事项，待其他待办事项完成之后，请于{effectdate}前往{model.onbrdtcity.address}办理入职。"}','入职预约结果提醒');

DELETE FROM t_msg_template_l WHERE FPKID = '2=DHYGXDHZRB';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1371040063965637632,'信息不审核通过提醒','2=DHYGXDHZRB','zh_CN','{"content":"亲爱的{name}，您好！您的信息采集资料未通过审核，如有疑问，请联系HR。"}','信息不审核通过提醒');



DELETE FROM t_msg_template_l WHERE FPKID = '2=DJF8N4T/OT';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1371048128001616896,'终止入职知会','2=DJF8N4T/OT','zh_CN','{"emailTitle":"终止入职知会","emailContent":"<p>亲爱的{name}，您好！<br />很遗憾不能与您并肩奋斗，您的入职流程已终止。<br />祝身体健康，事业有成！</p>"}','终止入职知会');

DELETE FROM t_msg_template_l WHERE FPKID = '2=DJAAVRRDN4';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1371047453171668992,'入职有效期截止提醒','2=DJAAVRRDN4','zh_CN','{"content":"您的入职有效期即将过期，请尽快完成入职预约~"}','入职有效期截止提醒');

DELETE FROM t_msg_template_l WHERE FPKID = '2=DHTXTHMR18';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1371039437277911040,'信息审核通过提醒','2=DHTXTHMR18','zh_CN','{"content":"亲爱的{name}，您好！您的信息采集资料已通过，请登录入职服务平台：{url} 查看后续流程，期待您的加入。"}','信息审核通过提醒');
DELETE FROM t_msg_template_l WHERE FPKID = '2=DI2=1/S8UO';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1371040859709003776,'信息驳回提醒','2=DI2=1/S8UO','zh_CN','{"content":"您的信息采集内容被驳回，请点击链接修改后重新提交，{url} "}','信息驳回提醒');
DELETE FROM t_msg_template_l WHERE FPKID = '2=DJ1B9O6OTH';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1371046082305349632,'入职有效期截止提醒','2=DJ1B9O6OTH','zh_CN','{"emailTitle":"入职有效期提醒","emailContent":"<p>亲爱的{name}，您好！<br />距离您的入职有效期{validuntil}还有一周，请您按照入职邀约尽快完成入职预约，谢谢！如您无法在入职有效期内入职，请尽快联系入职服务人员。</p>\n<p> </p>"}','入职有效期截止提醒');
DELETE FROM t_msg_template_l WHERE FPKID = '2=DJJZMSKTKF';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1371048775417616384,'确认入职成功','2=DJJZMSKTKF','zh_CN','{"content":"亲爱的{name}，您已报到成功，成为{model.acompany.name}的正式一员，期待以后并肩奋斗的时光，接下来请根据入职服务人员指引完成后续事项。"}','确认入职成功');
