delete from T_MSG_TEMPLATE where fid = 852837124876022784;
delete from T_MSG_TEMPLATE where fid = 852838228842001408;
delete from T_MSG_TEMPLATE where fid = 875119353761246208;
delete from T_MSG_TEMPLATE where fid = 875119914522835968;
INSERT INTO T_MSG_TEMPLATE (FID, FMSGTYPE, FMSGCHANNEL, FMSGSCENE, FMSGTEMPLATE, FMSGENTITY, FCREATEDATE, FMODIFYDATE, FMSGSCENENAME) VALUES ('852837124876022784', 'message', 'yunzhijia', 'trip_order_change', '您好! 你的机票订单 {ordernum} 差异已调整, 请及时确认!', 'er_planebill', {ts'2020-03-22 16:33:39'}, {ts'2020-04-22 10:23:08'}, '商旅机票订单变更');
INSERT INTO T_MSG_TEMPLATE (FID, FMSGTYPE, FMSGCHANNEL, FMSGSCENE, FMSGTEMPLATE, FMSGENTITY, FCREATEDATE, FMODIFYDATE, FMSGSCENENAME) VALUES ('852838228842001408', 'message', 'yunzhijia', 'trip_order_change', '您好! 您的酒店订单 {ordernum} 差异已调整, 请及时确认!', 'er_hotelbill', {ts'2020-03-22 16:36:36'}, {ts'2020-04-22 10:23:20'}, '商旅酒店订单变更');
INSERT INTO T_MSG_TEMPLATE (FID, FMSGTYPE, FMSGCHANNEL, FMSGSCENE, FMSGTEMPLATE, FMSGENTITY, FCREATEDATE, FMODIFYDATE, FMSGSCENENAME) VALUES ('875119353761246208', 'message', 'yunzhijia', 'trip_order_change', '您好! 你的用车订单 {ordernum} 差异已调整, 请及时确认!', 'er_vehiclebill', {ts'2020-04-22 10:24:53'}, {ts'2020-04-22 10:25:56'}, '商旅用车订单变更');
INSERT INTO T_MSG_TEMPLATE (FID, FMSGTYPE, FMSGCHANNEL, FMSGSCENE, FMSGTEMPLATE, FMSGENTITY, FCREATEDATE, FMODIFYDATE, FMSGSCENENAME) VALUES ('875119914522835968', 'message', 'yunzhijia', 'trip_order_change', '您好! 你的火车订单 {ordernum} 差异已调整, 请及时确认!', 'er_trainbill', {ts'2020-04-22 10:26:14'}, {ts'2020-04-22 10:27:03'}, '商旅火车订单变更');
delete from T_MSG_TEMPLATE_L where fid = 852837124876022784;
delete from T_MSG_TEMPLATE_L where fid = 852838228842001408;
delete from T_MSG_TEMPLATE_L where fid = 875119353761246208;
delete from T_MSG_TEMPLATE_L where fid = 875119914522835968;
INSERT INTO T_MSG_TEMPLATE_L (FPKID, FID, FLOCALEID, FMSGSCENENAME) VALUES ('0QGL/FZS51HJ', '852837124876022784', 'zh_CN', '商旅机票订单变更');
INSERT INTO T_MSG_TEMPLATE_L (FPKID, FID, FLOCALEID, FMSGSCENENAME) VALUES ('0QGL07+/1RA0', '852838228842001408', 'zh_CN', '商旅酒店订单变更');
INSERT INTO T_MSG_TEMPLATE_L (FPKID, FID, FLOCALEID, FMSGSCENENAME) VALUES ('0QGL9R34LWF9', '875119353761246208', 'zh_CN', '商旅用车订单变更');
INSERT INTO T_MSG_TEMPLATE_L (FPKID, FID, FLOCALEID, FMSGSCENENAME) VALUES ('0QGLCUG8V5FA', '875119914522835968', 'zh_CN', '商旅火车订单变更');
delete from t_msg_selectscene where fid = 852837124876022784;
delete from t_msg_selectscene where fid = 852838228842001408;
delete from t_msg_selectscene where fid = 875119353761246208;
delete from t_msg_selectscene where fid = 875119914522835968;
INSERT INTO t_msg_selectscene (FPKID, FID, FBASEDATAID) VALUES ('875117942268898304', '852837124876022784', '861474585680422921');
INSERT INTO t_msg_selectscene (FPKID, FID, FBASEDATAID) VALUES ('875118044333091840', '852838228842001408', '861474585680422924');
INSERT INTO t_msg_selectscene (FPKID, FID, FBASEDATAID) VALUES ('875119353769556992', '875119353761246208', '861474585680422922');
INSERT INTO t_msg_selectscene (FPKID, FID, FBASEDATAID) VALUES ('875119914522913792', '875119914522835968', '861474585680422923');

delete from T_MSG_TEMPLATE where fid = 874706024320320512;
delete from T_MSG_TEMPLATE where fid = 874705162147578880;
delete from T_MSG_TEMPLATE where fid = 874705807206319104;
delete from T_MSG_TEMPLATE where fid = 874706282362242048;
delete from T_MSG_TEMPLATE where fid = 874706490483655680;
INSERT INTO T_MSG_TEMPLATE (FID, FMSGTYPE, FMSGCHANNEL, FMSGSCENE, FMSGTEMPLATE, FMSGENTITY, FCREATEDATE, FMODIFYDATE, FMSGSCENENAME) VALUES ('874706024320320512', 'message', 'yunzhijia', 'er_cas_pay', '亲，您提报的单据{billno}已经全部付款，请知悉！', 'er_dailyloanbill', {ts'2020-04-21 20:44:20'}, {ts'2020-04-22 10:24:02'}, '借款单付款');
INSERT INTO T_MSG_TEMPLATE (FID, FMSGTYPE, FMSGCHANNEL, FMSGSCENE, FMSGTEMPLATE, FMSGENTITY, FCREATEDATE, FMODIFYDATE, FMSGSCENENAME) VALUES ('874705162147578880', 'message', 'yunzhijia', 'er_cas_pay', '亲，您提报的单据{billno}已经全部付款，请知悉！', 'er_tripreqbill', {ts'2020-04-21 20:32:17'}, {ts'2020-04-22 10:23:39'}, '出差借款单付款');
INSERT INTO T_MSG_TEMPLATE (FID, FMSGTYPE, FMSGCHANNEL, FMSGSCENE, FMSGTEMPLATE, FMSGENTITY, FCREATEDATE, FMODIFYDATE, FMSGSCENENAME) VALUES ('874705807206319104', 'message', 'yunzhijia', 'er_cas_pay', '亲，您提报的单据{billno}已经全部付款，请知悉！', 'er_tripreimbursebill', {ts'2020-04-21 20:43:11'}, {ts'2020-04-22 10:23:50'}, '差旅报销单付款');
INSERT INTO T_MSG_TEMPLATE (FID, FMSGTYPE, FMSGCHANNEL, FMSGSCENE, FMSGTEMPLATE, FMSGENTITY, FCREATEDATE, FMODIFYDATE, FMSGSCENENAME) VALUES ('874706282362242048', 'message', 'yunzhijia', 'er_cas_pay', '亲，您提报的单据{billno}已经全部付款，请知悉！', 'er_dailyreimbursebill', {ts'2020-04-21 20:44:45'}, {ts'2020-04-22 10:24:14'}, '费用报销单');
INSERT INTO T_MSG_TEMPLATE (FID, FMSGTYPE, FMSGCHANNEL, FMSGSCENE, FMSGTEMPLATE, FMSGENTITY, FCREATEDATE, FMODIFYDATE, FMSGSCENENAME) VALUES ('874706490483655680', 'message', 'yunzhijia', 'er_cas_pay', '亲，您提报的单据{billno}已经全部付款，请知悉！', 'er_publicreimbursebill', {ts'2020-04-21 20:45:16'}, {ts'2020-04-22 10:24:27'}, '对公报销单');
delete from T_MSG_TEMPLATE_L where fid = 874706024320320512;
delete from T_MSG_TEMPLATE_L where fid = 874705162147578880;
delete from T_MSG_TEMPLATE_L where fid = 874705807206319104;
delete from T_MSG_TEMPLATE_L where fid = 874706282362242048;
delete from T_MSG_TEMPLATE_L where fid = 874706490483655680;
INSERT INTO T_MSG_TEMPLATE_L (FPKID, FID, FLOCALEID, FMSGSCENENAME) VALUES ('0QGL1C5BGSQJ', '874705162147578880', 'zh_CN', '出差借款单付款');
INSERT INTO T_MSG_TEMPLATE_L (FPKID, FID, FLOCALEID, FMSGSCENENAME) VALUES ('0QGL210N+3PL', '874705807206319104', 'zh_CN', '差旅报销单付款');
INSERT INTO T_MSG_TEMPLATE_L (FPKID, FID, FLOCALEID, FMSGSCENENAME) VALUES ('0QGL2T=TW83Z', '874706024320320512', 'zh_CN', '借款单付款');
INSERT INTO T_MSG_TEMPLATE_L (FPKID, FID, FLOCALEID, FMSGSCENENAME) VALUES ('0QGL3I2TS/1Y', '874706282362242048', 'zh_CN', '费用报销单');
INSERT INTO T_MSG_TEMPLATE_L (FPKID, FID, FLOCALEID, FMSGSCENENAME) VALUES ('0QGL4=XEL+PM', '874706490483655680', 'zh_CN', '对公报销单');
delete from t_msg_selectscene where fid = 874706024320320512;
delete from t_msg_selectscene where fid = 874705162147578880;
delete from t_msg_selectscene where fid = 874705807206319104;
delete from t_msg_selectscene where fid = 874706282362242048;
delete from t_msg_selectscene where fid = 874706490483655680;
INSERT INTO t_msg_selectscene (FPKID, FID, FBASEDATAID) VALUES ('875118203339156480', '874705162147578880', '861474585680422926');
INSERT INTO t_msg_selectscene (FPKID, FID, FBASEDATAID) VALUES ('875118297920711680', '874705807206319104', '861474585680422925');
INSERT INTO t_msg_selectscene (FPKID, FID, FBASEDATAID) VALUES ('875118400882486272', '874706024320320512', '861474585680422927');
INSERT INTO t_msg_selectscene (FPKID, FID, FBASEDATAID) VALUES ('875118498685266944', '874706282362242048', '861474585680422928');
INSERT INTO t_msg_selectscene (FPKID, FID, FBASEDATAID) VALUES ('875118607099636736', '874706490483655680', '861474585680422929');
