--1.发送邀约消息模板:更新为消息模板编码为OBD002的ID：1371023195624200192
update T_HOM_ONBRDINVITE set FSENDINVITEMESSAGETPLID = 1371023195624200192;
--2.登录方案:通过入职单的url进行升级：包含hom_int，则更新为：1393469528884760576，如果为空，则更新为正式员工hom_emp ：1393468982660550656
update T_HOM_ONBRDINVITE set FLOGINSCHEMEID = 1393468982660550656;
update T_HOM_ONBRDINVITE set FLOGINSCHEMEID = 1393469528884760576 where fonbrdid in (select fid from t_hom_onbrdbill_b where furl like '%hom_int%' );
--3.登录提醒消息模板:实习生更新为OBD004：1335375715809385472，否则更新为正式员工OBD003：1335372449788746752
update T_HOM_ONBRDINVITE set FLOGINREMINDMESSAGETPLID = 1335372449788746752;
update T_HOM_ONBRDINVITE set FLOGINREMINDMESSAGETPLID = 1335375715809385472 where fonbrdid in (select fid from t_hom_onbrdbill_a where fonbrdtypeid in (1020) );
--4.欢迎信发送状态:如果已发送1，则更新为已发送2,5.邀约消息发送状态:如果已发送1，则更新为已发送2
update T_HOM_ONBRDINVITE set FWELCOMELETTERSENDSTATUS = '2',FINVITEMESSAGESENDSTATUS = '2' where FSENDSTATUS = '2';
update T_HOM_ONBRDINVITE set FWELCOMELETTERSENDSTATUS = '1',FINVITEMESSAGESENDSTATUS = '1' where FSENDSTATUS = '1';