--报到通知书预置模版
DELETE FROM T_TSRBD_CFGMSGTEMPLATE WHERE FID = 1731957583046005760;
INSERT INTO T_TSRBD_CFGMSGTEMPLATE(FBITINDEX,FRECRUTYPLIST,FISSYSPRESET,FUSEORGID,FCREATEORGID,FINTVCATEGORYLIST,FINTVMETHODLIST,FDESCRIPTION,FMASTERID,FMSGPUSHSCENEID,FCTRLSTRATEGY,FSMSTEMPLATE,FEMAILRICHTEXT,FSENDTYPE,FCREATETIME,FMSGRECEIVERID,FENABLE,FEMAILRICHTEXT_TAG,FEMAILTHEME,FDISABLERID,FID,FDISABLEDATE,FSOURCEDATAID,FSIMPLENAME,FORGID,FSTATUS,FMSGCHANNELLIST,FNUMBER,FNAME,FINDEX,FYZJTEMPLATE,FSOURCEBITINDEX,FMODIFIERID,FMODIFYTIME,FCREATORID,FRECRUTYPEID) VALUES (0,' ','1',100000,100000,' ',' ',' ',1731957583046005760,1080,'5','候选人{候选人姓名}已经完成全部招聘流程，预计将于{预计入职日期}到{报到地址}报到，请您协助办理入职手续，谢谢。如有疑问请联系 {Offer联系人}（{Offer联系人电话}）。',' ','2',{ts'2023-07-18  00:00:00'},1011,'1','<p>                                                                              {候选人姓名}报到通知书</p>
<p> {报到联系人姓名}，您好：</p>
<p>        候选人{候选人姓名}已经完成全部招聘流程，预计将于{预计入职日期}到{报到地址}报到，请您协助办理入职手续，谢谢。</p>
<p> 如有疑问请联系 {Offer联系人} （{Offer联系人电话} ）。</p>
<p>                                                                                                                                                                                                                                </p>
<p>                                                                                                                                     {拟入职公司}</p>
<p>                                                                                                                                         人力资源部</p>','报到通知书',0,1731957583046005760,NULL,0,' ',100000,'C',',475773782250774528,475773159430184960,','1070_S','报到通知书',0,' ',0,1426680676765178880,{ts'2023-07-28  00:00:00'},1,1020);
DELETE FROM T_TSRBD_CFGMSGTEMPLATE_L WHERE FPKID = '3EQMU9VJ0SZ9';
INSERT INTO T_TSRBD_CFGMSGTEMPLATE_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1731957583046005760,'3EQMU9VJ0SZ9','zh_CN',' ',' ','报到通知书');
DELETE FROM T_TSRBD_CFGMSGTEMPLATE_L WHERE FPKID = '3EQMU9VJ0SZ=';
--INSERT INTO T_TSRBD_CFGMSGTEMPLATE_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1731957583046005760,'3EQMU9VJ0SZ=','zh_TW',' ',' ','報到通知書');
DELETE FROM T_TSRBD_MSGCHANNEL WHERE FPKID = 1739048324834542592;
INSERT INTO T_TSRBD_MSGCHANNEL(FID,FBASEDATAID,FPKID) VALUES (1731957583046005760,475773782250774528,1739048324834542592);
DELETE FROM T_TSRBD_MSGCHANNEL WHERE FPKID = 1739048324834542593;
INSERT INTO T_TSRBD_MSGCHANNEL(FID,FBASEDATAID,FPKID) VALUES (1731957583046005760,475773159430184960,1739048324834542593);

