/** 预置商旅集成调度任务-滴滴人员和组织同步 wenyue_chi**/
DELETE from T_SCH_TASKDEFINE where fid in ('18X3ZTPLBHOK');
DELETE from T_SCH_TASKDEFINE_L where fid in ('18X3ZTPLBHOK');
INSERT INTO T_SCH_TASKDEFINE (FID, FCLASSNAME, FNUMBER, FAPPID) VALUES ('18X3ZTPLBHOK', 'kd.fi.er.business.trip.task.didi.DiDiTripUserAndOrgTask','DiDiTripUserAndOrgTask', 'em');
INSERT INTO T_SCH_TASKDEFINE_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('18X3ZTPLBDN0', '18X3ZTPLBHOK', 'zh_CN', '费用商旅同步组织和人员到滴滴任务');
INSERT INTO T_SCH_TASKDEFINE_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('18X3ZTPLBDN1', '18X3ZTPLBHOK', 'zh_TW', '費用商旅同步組織和人員到滴滴任務');

/**组织调度任务**/
DELETE from t_sch_job where fid in ('18X4JQXC=Z1B');
DELETE from t_sch_job_l where fid in ('18X4JQXC=Z1B');
INSERT INTO t_sch_job (FID, FJOBTYPE, FTASKCLASSNAME, FRUNBYUSERID, FNUMBER, FTASKDEFINEID, FSTATUS, FPARAMS, FTIMEOUT, FRUNBYORGID, FRUNBYLANG, FCONCURRENT) VALUES ('18X4JQXC=Z1B', 'BIZ', 'kd.fi.er.business.trip.task.didi.DiDiTripUserAndOrgTask', '1', 'em_DiDiSyncOrg_SKDJ_S', '18X3ZTPLBHOK', '1', '{function:ORG}', '0', '0', ' ', '1');
INSERT INTO t_sch_job_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('18X4JQXFYG=D', '18X4JQXC=Z1B', 'zh_CN', '费用-商旅集成-滴滴组织');
INSERT INTO t_sch_job_l  (FPKID, FID, FLOCALEID, FNAME) VALUES ('18X4JQXFYG=E', '18X4JQXC=Z1B', 'zh_TW', '費用-商旅集成-滴滴組織');

DELETE from t_sch_jobparams where FID = '18X4JQXC=Z1B';
INSERT INTO t_sch_jobparams (FID, FENTRYID, FSEQ, FPARAMNAME, FPARAMVALUE) VALUES ('18X4JQXC=Z1B', '18X4JQXFYC8V', '1', 'function', 'ORG');

DELETE from T_SCH_SCHEDULE where fid in ('18X57KEWWRW4');
DELETE from T_SCH_SCHEDULE_L where fid in ('18X57KEWWRW4');
INSERT INTO T_SCH_SCHEDULE_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('18X57KEWWNUL', '18X57KEWWRW4', 'zh_CN', '费用-商旅集成-滴滴组织');
INSERT INTO T_SCH_SCHEDULE_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('18X57KEWWNUY', '18X57KEWWRW4', 'zh_TW', '費用-商旅集成-滴滴組織');
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 ('18X57KEWWRW4', '18X4JQXC=Z1B', {ts'2020-12-01 23:59:59'}, {ts'2049-12-30 23:59:59'}, '0 44 23 * * ?', 'em_DiDiSyncOrg_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', '事件将于2020-12-07 19:44:19起，每1天23时重复。计最近十次执行时间：2020-12-07 23:44:00,2020-12-08 23:44:00,2020-12-09 23:44:00,2020-12-10 23:44:00,2020-12-11 23:44:00,2020-12-12 23:44:00,2020-12-13 23:44:00,2020-12-14 23:44:00,2020-12-15 23:44:00,2020-12-16 23:44:00', 'd');

/**人员调度任务**/
DELETE from t_sch_job where fid in ('18X6IJ342O+X');
DELETE from t_sch_job_l where fid in ('18X6IJ342O+X');
INSERT INTO t_sch_job (FID, FJOBTYPE, FTASKCLASSNAME, FRUNBYUSERID, FNUMBER, FTASKDEFINEID, FSTATUS, FPARAMS, FTIMEOUT, FRUNBYORGID, FRUNBYLANG, FCONCURRENT) VALUES ('18X6IJ342O+X', 'BIZ', 'kd.fi.er.business.trip.task.didi.DiDiTripUserAndOrgTask', '1', 'em_DiDiSyncUser_SKDJ_S', '18X3ZTPLBHOK', '1', '{function:ORG}', '0', '0', ' ', '1');
INSERT INTO t_sch_job_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('18X6IJ342JZC', '18X6IJ342O+X', 'zh_CN', '费用-商旅集成-滴滴人员');
INSERT INTO t_sch_job_l  (FPKID, FID, FLOCALEID, FNAME) VALUES ('18X6IJ342JZD', '18X6IJ342O+X', 'zh_TW', '費用-商旅集成-滴滴人員');

DELETE from t_sch_jobparams where FID = '18X6IJ342O+X';
INSERT INTO t_sch_jobparams (FID, FENTRYID, FSEQ, FPARAMNAME, FPARAMVALUE) VALUES ('18X6IJ342O+X', '18X6IJ342O+Y', '1', 'function', 'USER');

DELETE from T_SCH_SCHEDULE where fid in ('18X6ZBG65Q2R');
DELETE from T_SCH_SCHEDULE_L where fid in ('18X6ZBG65Q2R');
INSERT INTO T_SCH_SCHEDULE_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('18X6ZBG65U4=', '18X6ZBG65Q2R', 'zh_CN', '费用-商旅集成-滴滴人员');
INSERT INTO T_SCH_SCHEDULE_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('18X6ZBG65U4A', '18X6ZBG65Q2R', 'zh_TW', '費用-商旅集成-滴滴人員');
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 ('18X6ZBG65Q2R', '18X6IJ342O+X', {ts'2020-12-01 23:59:59'}, {ts'2049-12-30 23:59:59'}, '0 22 23 * * ?', 'em_DiDiSyncUser_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', '事件将于2020-12-07 20:22:50起，每1天23时重复。预计最近十次执行时间：2020-12-07 23:22:00,2020-12-08 23:22:00,2020-12-09 23:22:00,2020-12-10 23:22:00,2020-12-11 23:22:00,2020-12-12 23:22:00,2020-12-13 23:22:00,2020-12-14 23:22:00,2020-12-15 23:22:00,2020-12-16 23:22:00', 'd');

