/** 预置商旅集成调度任务-滴滴订单调度任务 wenyue_chi**/
DELETE FROM T_SCH_TASKDEFINE WHERE FID IN ('1B1QG+XY0Q5M');
INSERT INTO T_SCH_TASKDEFINE (FID, FCLASSNAME, FNUMBER, FAPPID) VALUES ('1B1QG+XY0Q5M', 'kd.fi.er.business.trip.task.didi.DiDiTripOrderTask', 'DiDiTripOrderTask', 'em');

DELETE FROM T_SCH_TASKDEFINE_L WHERE FID IN ('1B1QG+XY0Q5M');
INSERT INTO T_SCH_TASKDEFINE_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('1B1QG+XY0LFU', '1B1QG+XY0Q5M', 'zh_CN', '费用-商旅集成-滴滴订单');
INSERT INTO T_SCH_TASKDEFINE_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('1B1QG+XY0LFV', '1B1QG+XY0Q5M', 'zh_TW', '費用-商旅集成-滴滴訂單');


DELETE FROM T_SCH_JOB WHERE FID IN ('1B1RA8=W8Y7H');
INSERT INTO T_SCH_JOB (FID, FJOBTYPE, FTASKCLASSNAME, FRUNBYUSERID, FNUMBER, FTASKDEFINEID, FSTATUS, FPARAMS, FTIMEOUT, FRUNBYORGID, FRUNBYLANG, FCONCURRENT, FRUNMODE, FSTRATEGY, FRETRYTIME) VALUES ('1B1RA8=W8Y7H', 'BIZ', 'kd.fi.er.business.trip.task.didi.DiDiTripOrderTask', '1', 'em_DiDiGetCarOrder_SKDJ_S', '1B1QG+XY0Q5M', '1', ' ', '0', '0', ' ', '1', '0', '1', '0');

DELETE FROM T_SCH_JOB_L WHERE FID IN ('1B1RA8=W8Y7H');
INSERT INTO T_SCH_JOB_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('1B1RA8=W90Y=', '1B1RA8=W8Y7H', 'zh_CN', '费用-商旅集成-滴滴订单-用车');
INSERT INTO T_SCH_JOB_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('1B1RA8=W90YA', '1B1RA8=W8Y7H', 'zh_TW', '費用-商旅集成-滴滴訂單-用車');

DELETE FROM T_SCH_SCHEDULE WHERE FID IN ('1B1SC8+U5DTX');
INSERT INTO T_SCH_SCHEDULE (FID, FJOBID, FSTARTTIME, FENDTIME, FPLAN, FNUMBER, FSTATUS, 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, FREPEATMODE) VALUES ('1B1SC8+U5DTX', '1B1RA8=W8Y7H', {ts'2021-01-01 23:59:59'}, {ts'2999-12-31  23:59:59'}, '0 27 * * * ?', 'em_DiDiGetCarOrder_SKDP_S', '0', '1', '172.19.109.70', '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', '事件将于2021-01-12 10:27:23起，每1小时重复。预计最近十次执行时间：2021-01-12 11:27:00,2021-01-12 12:27:00,2021-01-12 13:27:00,2021-01-12 14:27:00,2021-01-12 15:27:00,2021-01-12 16:27:00,2021-01-12 17:27:00,2021-01-12 18:27:00,2021-01-12 19:27:00,2021-01-12 20:27:00', 'h');

DELETE FROM t_sch_schedule_entry WHERE FID IN ('1B1SC8+U5DTX');
INSERT INTO t_sch_schedule_entry (FID, FENTRYID, FSEQ, FJOBNUMBER) VALUES ('1B1SC8+U5DTX', '1B1SC8+U5DTY', '1', '1B1RA8=W8Y7H');

DELETE FROM T_SCH_SCHEDULE_L WHERE FID IN ('1B1SC8+U5DTX');
INSERT INTO T_SCH_SCHEDULE_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('1B1SC8+U5IIP', '1B1SC8+U5DTX', 'zh_CN', '费用-商旅集成-滴滴订单-用车');
INSERT INTO T_SCH_SCHEDULE_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('1B1SC8+U5IIQ', '1B1SC8+U5DTX', 'zh_TW', '費用-商旅集成-滴滴訂單-用車');
