/**商旅同步组织到差旅壹号定时任务 预置脚本 yk**/
DELETE FROM t_sch_taskdefine WHERE FID = '08Q/PMFP28ZY';
INSERT INTO t_sch_taskdefine (FID, FCLASSNAME, FNUMBER, FAPPID) VALUES ('08Q/PMFP28ZY', 'kd.fi.er.business.trip.task.travelno1.TTripOrgTask', 'ChaiLvYiHaoSyncDept', 'em');

DELETE FROM t_sch_taskdefine_l WHERE FPKID = '08Q/PMFP28ZY';
DELETE FROM t_sch_taskdefine_l WHERE FPKID = '08Q/PMFP28ZZ';
INSERT INTO t_sch_taskdefine_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('08Q/PMFP28ZY', '08Q/PMFP28ZY', 'zh_CN', '费用商旅同步组织到差旅壹号');
INSERT INTO t_sch_taskdefine_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('08Q/PMFP28ZZ', '08Q/PMFP28ZY', 'zh_TW', '費用商旅同步組織到差旅壹號');


DELETE FROM t_sch_job WHERE FID = '08Q0AE/2L+62';
INSERT INTO t_sch_job (FID, FJOBTYPE, FTASKCLASSNAME, FRUNBYUSERID, FPARAMS, FNUMBER, FTASKDEFINEID, FSTATUS, FTIMEOUT, FRUNBYLANG, FRUNBYORGID) VALUES ('08Q0AE/2L+62', 'BIZ', 'kd.fi.er.business.trip.task.travelno1.TTripOrgTask', '1', ' ', 'em_ChaiLvYiHaoSyncDept_SKDJ_S', '08Q/PMFP28ZY', '0', '0', 'zh_CN', '0');

DELETE FROM t_sch_job_l WHERE FPKID = '08Q0AE/2L+62';
DELETE FROM t_sch_job_l WHERE FPKID = '08Q0AE/2L+63';
INSERT INTO t_sch_job_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('08Q0AE/2L+62', '08Q0AE/2L+62', 'zh_CN', '费用商旅同步组织到差旅壹号');
INSERT INTO t_sch_job_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('08Q0AE/2L+63', '08Q0AE/2L+62', 'zh_TW', '費用商旅同步組織到差旅壹號');



DELETE FROM t_sch_schedule WHERE FID = '08Q3W7G+DEVJ';
INSERT INTO t_sch_schedule (FID, FJOBID, FSTARTTIME, FENDTIME, FPLAN, FNUMBER, FSTATUS, FREPEATMODE, FCYCLENUM, FHOST, FSUN, FSAT, FFRI, FTHUR, FWED, FTUES, FMON, FONE, FTWO, FTHIRTYONE, FTHIRTY, FTWENTYNINE, FTWENTYEIGHT, FTWENTYSEVEN, FTWENTYSIX, FTWENTYFIVE, FTWENTYFOUR, FTWENTYTHREE, FTWENTYTWO, FTWENTYONE, FTWENTY, FNINETEEN, FEIGHTEEN, FSEVENTEEN, FSIXTEEN, FFIFTEEN, FFOURTEEN, FTHIRTEEN, FTWELVE, FELEVEN, FTEN, FNINE, FEIGHT, FSEVEN, FSIX, FFIVE, FFOUR, FTHREE, FNO, FNOWEEK, FJAN, FDEC, FNOV, FOCT, FSEP, FAUG, FJUL, FJUN, FMAY, FAPR, FMAR, FFEB, FBYWEEK, FBYDAYORWEEK, FDESC) VALUES ('08Q3W7G+DEVJ', '08Q0AE/2L+62', {ts'2019-09-25 21:59:00'}, {ts'2049-12-30 21:59:59'}, '0 59 21 * * ?', 'em_ChaiLvYiHaoSyncDept_SKDP_S', '0', 'd', '1', '172.20.201.61', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', ' ', ' ', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'd', '事件将于每1天重复');

DELETE FROM t_sch_schedule_l WHERE FPKID = '08Q3W7G+DWC7';
DELETE FROM t_sch_schedule_l WHERE FPKID = '08Q3W7G+DWC8';
INSERT INTO t_sch_schedule_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('08Q3W7G+DWC7', '08Q3W7G+DEVJ', 'zh_CN', '费用商旅同步组织到差旅壹号');
INSERT INTO t_sch_schedule_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('08Q3W7G+DWC8', '08Q3W7G+DEVJ', 'zh_TW', '費用商旅同步組織到差旅壹號');


/**商旅同步人员到差旅壹号定时任务 预置脚本 yk**/
DELETE FROM t_sch_taskdefine WHERE FID = '08TI9I0PQOS6';
INSERT INTO t_sch_taskdefine (FID, FCLASSNAME, FNUMBER, FAPPID) VALUES ('08TI9I0PQOS6', 'kd.fi.er.business.trip.task.travelno1.TTripUserTask', 'ChaiLvYiHaoSyncUser', 'em');

DELETE FROM t_sch_taskdefine_l WHERE FPKID = '08TI9I0PSSXG';
DELETE FROM t_sch_taskdefine_l WHERE FPKID = '08TI9I0PSSXH';
INSERT INTO t_sch_taskdefine_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('08TI9I0PSSXG', '08TI9I0PQOS6', 'zh_CN', '费用商旅同步人员到差旅壹号');
INSERT INTO t_sch_taskdefine_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('08TI9I0PSSXH', '08TI9I0PQOS6', 'zh_TW', '費用商旅同步人员到差旅壹號');

DELETE FROM t_sch_job WHERE FID = '08TINELME=RJ';
INSERT INTO t_sch_job (FID, FJOBTYPE, FTASKCLASSNAME, FRUNBYUSERID, FPARAMS, FNUMBER, FTASKDEFINEID, FSTATUS, FTIMEOUT, FRUNBYLANG, FRUNBYORGID) VALUES ('08TINELME=RJ', 'BIZ', 'kd.fi.er.business.trip.task.travelno1.TTripUserTask', '1', ' ', 'em_ChaiLvYiHaoSyncUser_SKDJ_S', '08TI9I0PQOS6', '0', '0', 'zh_CN', '0');

DELETE FROM t_sch_job_l WHERE FPKID = '08TINELTO23T';
DELETE FROM t_sch_job_l WHERE FPKID = '08TINELTO23U';
INSERT INTO t_sch_job_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('08TINELTO23T', '08TINELME=RJ', 'zh_CN', '费用商旅同步人员到差旅壹号');
INSERT INTO t_sch_job_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('08TINELTO23U', '08TINELME=RJ', 'zh_TW', '費用商旅同步人員到差旅壹號');

DELETE FROM t_sch_schedule WHERE FID = '08TJ739PAJPT';
INSERT INTO t_sch_schedule (FID, FJOBID, FSTARTTIME, FENDTIME, FPLAN, FNUMBER, FSTATUS, FREPEATMODE, FCYCLENUM, FHOST, FSUN, FSAT, FFRI, FTHUR, FWED, FTUES, FMON, FONE, FTWO, FTHIRTYONE, FTHIRTY, FTWENTYNINE, FTWENTYEIGHT, FTWENTYSEVEN, FTWENTYSIX, FTWENTYFIVE, FTWENTYFOUR, FTWENTYTHREE, FTWENTYTWO, FTWENTYONE, FTWENTY, FNINETEEN, FEIGHTEEN, FSEVENTEEN, FSIXTEEN, FFIFTEEN, FFOURTEEN, FTHIRTEEN, FTWELVE, FELEVEN, FTEN, FNINE, FEIGHT, FSEVEN, FSIX, FFIVE, FFOUR, FTHREE, FNO, FNOWEEK, FJAN, FDEC, FNOV, FOCT, FSEP, FAUG, FJUL, FJUN, FMAY, FAPR, FMAR, FFEB, FBYWEEK, FBYDAYORWEEK, FDESC) VALUES ('08TJ739PAJPT', '08TINELME=RJ', {ts'2019-09-25 22:59:00'}, {ts'2049-12-25 22:59:59'}, '0 59 22 * * ?', 'em_ChaiLvYiHaoSyncUser_SKDP_S', '0', 'd', '1', '10.10.214.239', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', ' ', ' ', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'd', '事件将于每1天重复');

DELETE FROM t_sch_schedule_l WHERE FPKID = '08TJ739P9FKI';
DELETE FROM t_sch_schedule_l WHERE FPKID = '08TJ739P9FKJ';
INSERT INTO t_sch_schedule_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('08TJ739P9FKI', '08TJ739PAJPT', 'zh_CN', '费用商旅同步人员到差旅壹号');
INSERT INTO t_sch_schedule_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('08TJ739P9FKJ', '08TJ739PAJPT', 'zh_TW', '費用商旅同步人員到差旅壹號');


/**商旅同步订单从差旅壹号定时任务 预置脚本 yk**/
DELETE FROM t_sch_taskdefine WHERE FID = '09OGPB1GQCMX';
DELETE FROM t_sch_taskdefine_l WHERE FPKID = '09OGPB1GQNE/';
DELETE FROM t_sch_taskdefine_l WHERE FPKID = '09OGPB1GQNE0';
INSERT INTO t_sch_taskdefine (FID, FCLASSNAME, FNUMBER, FAPPID) VALUES ('09OGPB1GQCMX', 'kd.fi.er.business.trip.task.travelno1.TTripOrderTask', 'ChaiLvYiHaoSyncOrder', 'em');
INSERT INTO t_sch_taskdefine_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('09OGPB1GQNE/', '09OGPB1GQCMX', 'zh_CN', '费用商旅同步订单从差旅壹号');
INSERT INTO t_sch_taskdefine_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('09OGPB1GQNE0', '09OGPB1GQCMX', 'zh_TW', '費用商旅同步訂單從差旅壹號');

DELETE FROM t_sch_job WHERE FID = '09OH3QZDR54M';
DELETE FROM t_sch_job_l WHERE FPKID = '09OH3QZDREXQ';
DELETE FROM t_sch_job_l WHERE FPKID = '09OH3QZDREXR';
INSERT INTO t_sch_job (FID, FJOBTYPE, FTASKCLASSNAME, FRUNBYUSERID, FPARAMS, FNUMBER, FTASKDEFINEID, FSTATUS, FTIMEOUT, FRUNBYLANG, FRUNBYORGID) VALUES ('09OH3QZDR54M', 'BIZ', 'kd.fi.er.business.trip.task.travelno1.TTripOrderTask', '1', ' ', 'em_ChaiLvYiHaoSyncOrder_SKDJ_S', '09OGPB1GQCMX', '0', '0', 'zh_CN ', '0');
INSERT INTO t_sch_job_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('09OH3QZDREXQ', '09OH3QZDR54M', 'zh_CN', '费用商旅同步订单从差旅壹号');
INSERT INTO t_sch_job_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('09OH3QZDREXR', '09OH3QZDR54M', 'zh_TW', '費用商旅同步訂單從差旅壹號');

DELETE FROM t_sch_schedule WHERE FID = '09OHPFW297YR';
DELETE FROM t_sch_schedule_l WHERE FPKID = '09OHPFW2=YL4';
DELETE FROM t_sch_schedule_l WHERE FPKID = '09OHPFW2=YL5';
INSERT INTO t_sch_schedule (FID, FJOBID, FSTARTTIME, FENDTIME, FPLAN, FNUMBER, FSTATUS, FREPEATMODE, FCYCLENUM, FHOST, FSUN, FSAT, FFRI, FTHUR, FWED, FTUES, FMON, FONE, FTWO, FTHIRTYONE, FTHIRTY, FTWENTYNINE, FTWENTYEIGHT, FTWENTYSEVEN, FTWENTYSIX, FTWENTYFIVE, FTWENTYFOUR, FTWENTYTHREE, FTWENTYTWO, FTWENTYONE, FTWENTY, FNINETEEN, FEIGHTEEN, FSEVENTEEN, FSIXTEEN, FFIFTEEN, FFOURTEEN, FTHIRTEEN, FTWELVE, FELEVEN, FTEN, FNINE, FEIGHT, FSEVEN, FSIX, FFIVE, FFOUR, FTHREE, FNO, FNOWEEK, FJAN, FDEC, FNOV, FOCT, FSEP, FAUG, FJUL, FJUN, FMAY, FAPR, FMAR, FFEB, FBYWEEK, FBYDAYORWEEK, FDESC) VALUES ('09OHPFW297YR', '09OH3QZDR54M', {ts'2019-10-05 00:00:00'}, {ts'2049-10-05 00:00:00'}, '0 0 * * * ?', 'em_ChaiLvYiHaoSyncOrder_SKDP_S', '0', 'h', '1', '10.10.218.166', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', ' ', ' ', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'd', '事件将于每1小时重复');
INSERT INTO t_sch_schedule_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('09OHPFW2=YL4', '09OHPFW297YR', 'zh_CN', '费用商旅同步订单从差旅壹号');
INSERT INTO t_sch_schedule_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('09OHPFW2=YL5', '09OHPFW297YR', 'zh_TW', '費用商旅同步訂單從差旅壹號');