/** 预置商旅集成调度任务 wenyue_chi**/
DELETE from T_SCH_TASKDEFINE where fid in ('11GMN4=/MXZ=');
DELETE from T_SCH_TASKDEFINE_L where fid in ('11GMN4=/MXZ=');
INSERT INTO T_SCH_TASKDEFINE (FID, FCLASSNAME, FNUMBER, FAPPID) VALUES ('11GMN4=/MXZ=', 'kd.fi.er.business.trip.task.ZTE.ZTEOrgTask', 'ZTEOrgTask', 'em');
INSERT INTO T_SCH_TASKDEFINE_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('11GMN4=/MV99', '11GMN4=/MXZ=', 'zh_CN', '费用商旅同步组织到中兴商旅任务');
INSERT INTO T_SCH_TASKDEFINE_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('11GMN4=/MV9=', '11GMN4=/MXZ=', 'zh_TW', '費用商旅同步組織到中興商旅任務');

DELETE from T_SCH_JOB where fid in ('11GNE6PBWE3S');
DELETE from T_SCH_JOB_L where fid in ('11GNE6PBWE3S');
INSERT INTO T_SCH_JOB (FID, FJOBTYPE, FTASKCLASSNAME, FRUNBYUSERID, FNUMBER, FTASKDEFINEID, FSTATUS, FPARAMS, FTIMEOUT, FRUNBYORGID, FRUNBYLANG, FCONCURRENT) VALUES ('11GNE6PBWE3S', 'BIZ', 'kd.fi.er.business.trip.task.ZTE.ZTEOrgTask', '1', 'em_PushOrgToZTE_SKDJ_S', '11GMN4=/MXZ=', '1', '', '0', '0', ' ', '1');
INSERT INTO T_SCH_JOB_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('11GNE6PBWGTT', '11GNE6PBWE3S', 'zh_CN', '费用-同步组织到中兴商旅作业');
INSERT INTO T_SCH_JOB_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('11GNE6PBWGTU', '11GNE6PBWE3S', 'zh_TW', '費用-同步組織到中興商旅作業');

DELETE from T_SCH_SCHEDULE where fid in ('11GNRXBB/WIZ');
DELETE from T_SCH_SCHEDULE_L where fid in ('11GNRXBB/WIZ');
INSERT INTO T_SCH_SCHEDULE_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('11GNRXBB/Z8+', '11GNRXBB/WIZ', 'zh_CN', '费用-同步组织到中兴商旅计划');
INSERT INTO T_SCH_SCHEDULE_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('11GNRXBB/Z8/', '11GNRXBB/WIZ', '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 ('11GNRXBB/WIZ', '11GNE6PBWE3S', {ts'2020-09-15 11:06:39'}, {ts'2049-12-30 23:59:59'}, '0 6 23 * * ?', 'em_PushOrgToZTE_SKDP_S', '1', '1', '172.19.72.81', '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-09-15 11:06:39起，每1天23时重复。预计下一次执行时间：2020-09-15 23:06:00', 'd');


UPDATE t_sch_taskdefine SET FCLASSNAME='kd.fi.er.business.trip.task.ctrip.CTripUserTask' WHERE FNUMBER='CTripUserTask';
update t_sch_taskdefine_l set FNAME = '费用-商旅集成-携程人员' where fid = (select fid from t_sch_taskdefine where FNUMBER = 'CTripUserTask');


UPDATE t_sch_taskdefine SET FCLASSNAME='kd.fi.er.business.trip.task.ctrip.CTripOrderBillUpdateTask' WHERE FNUMBER='PlaneOrderT+2BillTask';
update t_sch_taskdefine_l set FNAME = '费用-商旅集成-携程订单-机票(T+2)' where fid = (select fid from t_sch_taskdefine where FNUMBER = 'PlaneOrderT+2BillTask');

UPDATE t_sch_taskdefine SET FCLASSNAME='kd.fi.er.business.trip.task.ctrip.CTripOrderBillUpdateTask' WHERE FNUMBER='TrainOrderBillUpdateTask';
update t_sch_taskdefine_l set FNAME = '费用-商旅集成-携程订单-火车(T+2)' where fid = (select fid from t_sch_taskdefine where FNUMBER = 'TrainOrderBillUpdateTask');




UPDATE t_sch_taskdefine SET FCLASSNAME='kd.fi.er.business.trip.task.ctrip.CTripCheckingBillTask' WHERE FNUMBER='TrainCheckingBillTask';
update t_sch_taskdefine_l set FNAME = '费用-商旅集成-携程结算单-火车' where fid = (select fid from t_sch_taskdefine where FNUMBER = 'TrainCheckingBillTask');

UPDATE t_sch_taskdefine SET FCLASSNAME='kd.fi.er.business.trip.task.ctrip.CTripCheckingBillTask' WHERE FNUMBER='PlaneCheckingBillTask';
update t_sch_taskdefine_l set FNAME = '费用-商旅集成-携程结算单-机票' where fid = (select fid from t_sch_taskdefine where FNUMBER = 'PlaneCheckingBillTask');

UPDATE t_sch_taskdefine SET FCLASSNAME='kd.fi.er.business.trip.task.ctrip.CTripCheckingBillTask' WHERE FNUMBER='HotelCheckingBillTask';
update t_sch_taskdefine_l set FNAME = '费用-商旅集成-携程结算单-酒店' where fid = (select fid from t_sch_taskdefine where FNUMBER = 'HotelCheckingBillTask');

UPDATE t_sch_taskdefine SET FCLASSNAME='kd.fi.er.business.trip.task.ctrip.CTripCheckingBillTask' WHERE FNUMBER='VehicleCheckingBillTask';
update t_sch_taskdefine_l set FNAME = '费用-商旅集成-携程结算单-用车' where fid = (select fid from t_sch_taskdefine where FNUMBER = 'VehicleCheckingBillTask');



UPDATE t_sch_taskdefine SET FCLASSNAME='kd.fi.er.business.trip.task.ctrip.CTripGetInvoiceDetailTask' WHERE FNUMBER='GetInvoiceDetailTask';
update t_sch_taskdefine_l set FNAME = '费用-商旅集成-携程发票接收' where fid = (select fid from t_sch_taskdefine where FNUMBER = 'GetInvoiceDetailTask');


UPDATE t_sch_taskdefine SET FCLASSNAME='kd.fi.er.business.trip.task.zte.ETripOrgTask' WHERE FNUMBER='ZTEOrgTask';
update t_sch_taskdefine_l set FNAME = '费用-商旅集成-中兴组织' where fid = (select fid from t_sch_taskdefine where FNUMBER = 'ZTEOrgTask');

UPDATE t_sch_taskdefine SET FCLASSNAME='kd.fi.er.business.trip.task.zte.ETripUserTask' WHERE FNUMBER='ZTEUserTask';
update t_sch_taskdefine_l set FNAME = '费用-商旅集成-中兴人员' where fid = (select fid from t_sch_taskdefine where FNUMBER = 'ZTEUserTask');

update t_sch_job_l set FNAME = '费用-商旅集成-差旅壹号组织' where fid = (select fid from t_sch_job where FNUMBER = 'em_ChaiLvYiHaoSyncDept_SKDJ_S');
update t_sch_job_l set FNAME = '费用-商旅集成-差旅壹号订单' where fid = (select fid from t_sch_job where FNUMBER = 'em_ChaiLvYiHaoSyncOrder_SKDJ_S');
update t_sch_job_l set FNAME = '费用-商旅集成-差旅壹号人员' where fid = (select fid from t_sch_job where FNUMBER = 'em_ChaiLvYiHaoSyncUser_SKDJ_S');
update t_sch_job set FSTATUS = '1' where FNUMBER = 'em_ChaiLvYiHaoSyncDept_SKDJ_S';
update t_sch_job set FSTATUS = '1' where FNUMBER = 'em_ChaiLvYiHaoSyncOrder_SKDJ_S';
update t_sch_job set FSTATUS = '1' where FNUMBER = 'em_ChaiLvYiHaoSyncUser_SKDJ_S';

update t_sch_job_l set FNAME = '费用-商旅集成-订单转换低碳积分' where fid = (select fid from t_sch_job where FNUMBER = 'em_OrderConvertToIntegral_SKDJ_S');
update t_sch_job_l set FNAME = '费用-商旅集成-未报销订单自动报销' where fid = (select fid from t_sch_job where FNUMBER = 'em_UnreimbursedOrderConvertToBill_SKDJ_S');

update t_sch_job_l set FNAME = '费用-商旅集成-携程城市' where fid = (select fid from t_sch_job where FNUMBER = 'em_GetCityFromCTrip_SKDJ_S');
update t_sch_job_l set FNAME = '费用-商旅集成-携程人员' where fid = (select fid from t_sch_job where FNUMBER = 'em_PushUserToCTrip_SKDJ_S');
update t_sch_job set FTASKCLASSNAME = 'kd.fi.er.business.trip.task.ctrip.CTripUserTask',FSTATUS = '1' where FNUMBER = 'em_PushUserToCTrip_SKDJ_S';



update t_sch_job_l set FNAME = '费用-商旅集成-携程订单-机票(T+2)' where fid = (select fid from t_sch_job where FNUMBER = 'em_PullPlaneOrderT+2BillFromCTrip_SKDJ_S');
update t_sch_job set FTASKCLASSNAME = 'kd.fi.er.business.trip.task.ctrip.CTripOrderBillUpdateTask',FPARAMS='{"businesstype":"PLANE"}',FSTATUS = '1'  where FNUMBER = 'em_PullPlaneOrderT+2BillFromCTrip_SKDJ_S';
delete from t_sch_jobparams where FENTRYID = '11NIJ3QJRU/W';
INSERT INTO t_sch_jobparams (FID, FENTRYID, FSEQ, FPARAMNAME, FPARAMVALUE) VALUES ('0LKU+KU1VUWG', '11NIJ3QJRU/W', '1', 'businesstype', 'PLANE');

update t_sch_job_l set FNAME = '费用-商旅集成-携程订单-火车(T+2)' where fid = (select fid from t_sch_job where FNUMBER = 'em_PullTrainOrderCTrip_SKDJ_S');
update t_sch_job set FTASKCLASSNAME = 'kd.fi.er.business.trip.task.ctrip.CTripOrderBillUpdateTask',FPARAMS='{"businesstype":"TRAIN"}',FSTATUS = '1'  where FNUMBER = 'em_PullTrainOrderCTrip_SKDJ_S';
delete from t_sch_jobparams where FENTRYID = '11NJFJXZP=BH';
INSERT INTO t_sch_jobparams (FID, FENTRYID, FSEQ, FPARAMNAME, FPARAMVALUE) VALUES ('0Y20U+L4HY8G', '11NJFJXZP=BH', '1', 'businesstype', 'TRAIN');


update t_sch_job_l set FNAME = '费用-商旅集成-携程结算单-机票' where fid = (select fid from t_sch_job where FNUMBER = 'em_PullPlaneCheckingBillFromCTrip_SKDJ_S');
update t_sch_job set FTASKCLASSNAME = 'kd.fi.er.business.trip.task.ctrip.CTripCheckingBillTask',FPARAMS='{"businesstype":"PLANE"}',FSTATUS = '1'  where FNUMBER = 'em_PullPlaneCheckingBillFromCTrip_SKDJ_S';
delete from t_sch_jobparams where FENTRYID = '11NFQX+8IKFC';
INSERT INTO t_sch_jobparams (FID, FENTRYID, FSEQ, FPARAMNAME, FPARAMVALUE) VALUES ('/BSQAO8MCOOC', '11NFQX+8IKFC', '1', 'businesstype', 'PLANE');



update t_sch_job_l set FNAME = '费用-商旅集成-携程结算单-酒店' where fid = (select fid from t_sch_job where FNUMBER = 'em_PullHotelCheckingBillFromCTrip_SKDJ_S');
update t_sch_job set FTASKCLASSNAME = 'kd.fi.er.business.trip.task.ctrip.CTripCheckingBillTask',FPARAMS='{"businesstype":"HOTEL"}',FSTATUS = '1'  where FNUMBER = 'em_PullHotelCheckingBillFromCTrip_SKDJ_S';
delete from t_sch_jobparams where FENTRYID = '11NG55S=G8X5';
INSERT INTO t_sch_jobparams (FID, FENTRYID, FSEQ, FPARAMNAME, FPARAMVALUE) VALUES ('/BSQ=CAS+I50', '11NG55S=G8X5', '1', 'businesstype', 'HOTEL');


update t_sch_job_l set FNAME = '费用-商旅集成-携程结算单-火车' where fid = (select fid from t_sch_job where FNUMBER = 'em_PullTrainSettlesCTrip_SKDJ_S');
update t_sch_job set FTASKCLASSNAME = 'kd.fi.er.business.trip.task.ctrip.CTripCheckingBillTask',FPARAMS='{"businesstype":"TRAIN"}',FSTATUS = '1'  where FNUMBER = 'em_PullTrainSettlesCTrip_SKDJ_S';
delete from t_sch_jobparams where FENTRYID = '11NGBU8L8YL9';
INSERT INTO t_sch_jobparams (FID, FENTRYID, FSEQ, FPARAMNAME, FPARAMVALUE) VALUES ('0XSBY5V9KRKH', '11NGBU8L8YL9', '1', 'businesstype', 'TRAIN');


update t_sch_job_l set FNAME = '费用-商旅集成-携程结算单-用车' where fid = (select fid from t_sch_job where FNUMBER = 'em_PullVehicleCheckingBillFromCTrip_SKDJ_S');
update t_sch_job set FTASKCLASSNAME = 'kd.fi.er.business.trip.task.ctrip.CTripCheckingBillTask',FPARAMS='{"businesstype":"CAR"}',FSTATUS = '1'  where FNUMBER = 'em_PullVehicleCheckingBillFromCTrip_SKDJ_S';
delete from t_sch_jobparams where FENTRYID = '11NG55S=G8X6';
INSERT INTO t_sch_jobparams (FID, FENTRYID, FSEQ, FPARAMNAME, FPARAMVALUE) VALUES ('/BSQBUG5Y3LJ', '11NG55S=G8X6', '1', 'businesstype', 'CAR');


update t_sch_job_l set FNAME = '费用-商旅集成-携程发票接收' where fid = (select fid from t_sch_job where FNUMBER = 'em_PullInvoiceDetailFromCTrip_SKDJ_S');
update t_sch_job set FTASKCLASSNAME = 'kd.fi.er.business.trip.task.ctrip.CTripGetInvoiceDetailTask',FSTATUS = '1'  where FNUMBER = 'em_PullInvoiceDetailFromCTrip_SKDJ_S';



update t_sch_job_l set FNAME = '费用-商旅集成-中兴组织' where fid = (select fid from t_sch_job where FNUMBER = 'em_PushOrgToZTE_SKDJ_S');
update t_sch_job set FTASKCLASSNAME = 'kd.fi.er.business.trip.task.zte.ETripOrgTask',FSTATUS = '1'  where FNUMBER = 'em_PushOrgToZTE_SKDJ_S';

update t_sch_job_l set FNAME = '费用-商旅集成-中兴人员' where fid = (select fid from t_sch_job where FNUMBER = 'em_PushUserByIncrToZhongXing_SKDJ_S');
update t_sch_job set FTASKCLASSNAME = 'kd.fi.er.business.trip.task.zte.ETripUserTask',FSTATUS = '1'  where FNUMBER = 'em_PushUserByIncrToZhongXing_SKDJ_S';




update t_sch_schedule_l set FNAME = '费用-商旅集成-未报销订单自动报销' where fid = (select fid from t_sch_schedule where FNUMBER = 'em_AutoSubmitOrderBill_SKDP_S');
update t_sch_schedule_l set FNAME = '费用-商旅集成-订单转换低碳积分' where fid = (select fid from t_sch_schedule where FNUMBER = 'em_OrderConvertToIntegral_SKDP_S');

update t_sch_schedule_l set FNAME = '费用-商旅集成-差旅壹号部门' where fid = (select fid from t_sch_schedule where FNUMBER = 'em_ChaiLvYiHaoSyncDept_SKDP_S');
update t_sch_schedule_l set FNAME = '费用-商旅集成-差旅壹号订单' where fid = (select fid from t_sch_schedule where FNUMBER = 'em_ChaiLvYiHaoSyncOrder_SKDP_S');
update t_sch_schedule_l set FNAME = '费用-商旅集成-差旅壹号人员' where fid = (select fid from t_sch_schedule where FNUMBER = 'em_ChaiLvYiHaoSyncUser_SKDP_S');


update t_sch_schedule_l set FNAME = '费用-商旅集成-携程城市' where fid = (select fid from t_sch_schedule where FNUMBER = 'em_GetCityFromCTrip_SKDP_S');
update t_sch_schedule_l set FNAME = '费用-商旅集成-携程人员' where fid = (select fid from t_sch_schedule where FNUMBER = 'em_PushUserToCTrip_SKDP_S');
update t_sch_schedule_l set FNAME = '费用-商旅集成-携程订单-机票(T+2)' where fid = (select fid from t_sch_schedule where FNUMBER = 'em_PullPlaneOrderT+2FromCTrip_SKDP_S');
update t_sch_schedule_l set FNAME = '费用-商旅集成-携程订单-火车(T+2)' where fid = (select fid from t_sch_schedule where FNUMBER = 'em_PullTrainOrderCTrip_SKDP_S');

update t_sch_schedule_l set FNAME = '费用-商旅集成-携程结算单-机票' where fid = (select fid from t_sch_schedule where FNUMBER = 'em_PullPlaneCheckingBill_SKDP_S');
update t_sch_schedule_l set FNAME = '费用-商旅集成-携程结算单-酒店' where fid = (select fid from t_sch_schedule where FNUMBER = 'em_PullHotelCheckingBill_SKDP_S');
update t_sch_schedule_l set FNAME = '费用-商旅集成-携程结算单-火车' where fid = (select fid from t_sch_schedule where FNUMBER = 'em_PullTrainCheckingBill_SKDP_S');
update t_sch_schedule_l set FNAME = '费用-商旅集成-携程结算单-用车' where fid = (select fid from t_sch_schedule where FNUMBER = 'em_PullVehicleCheckingBill_SKDP_S');

update t_sch_schedule_l set FNAME = '费用-商旅集成-携程发票接收' where fid = (select fid from t_sch_schedule where FNUMBER = 'em_PullInvoiceDetailFromCTrip_SKDP_S');

update t_sch_schedule_l set FNAME = '费用-商旅集成-中兴组织' where fid = (select fid from t_sch_schedule where FNUMBER = 'em_PushOrgToZTE_SKDP_S');
update t_sch_schedule_l set FNAME = '费用-商旅集成-中兴人员' where fid = (select fid from t_sch_schedule where FNUMBER = 'em_PushUserByIncrToZhongXing_SKDP_S');
