-- 采购订单自动催办定时任务 --

--调度作业--
DELETE from T_SCH_TASKDEFINE WHERE fid = '2BOTT1/0END=';
INSERT INTO t_sch_taskdefine (fid, fclassname, fnumber, fappid) VALUES ('2BOTT1/0END=', 'kd.scm.pur.common.task.PurOrderAutoUrgeTask', 'pur_PurOrderUrgeToSup', 'pur');
DELETE from T_SCH_TASKDEFINE_L WHERE FID = '2BOTT1/0END=' AND flocaleid = 'zh_CN';
DELETE from T_SCH_TASKDEFINE_L WHERE FID = '2BOTT1/0END=' AND flocaleid = 'zh_TW';
INSERT INTO t_sch_taskdefine_l (fpkid, fid, flocaleid, fname) VALUES ('2BOTT1/0GQ61', '2BOTT1/0END=', 'zh_CN', '采购订单自动催办');
INSERT INTO t_sch_taskdefine_l (fpkid, fid, flocaleid, fname) VALUES ('2BOTT1/0GQ62', '2BOTT1/0END=', 'zh_TW', '采購訂單自動催辦');

DELETE from T_SCH_JOB WHERE fid = '2BP2L1R57HSR';
INSERT INTO t_sch_job (fid, fjobtype, ftaskclassname, frunbyuserid, fparams, fnumber, ftaskdefineid, fstatus) VALUES ('2BP2L1R57HSR', 'BIZ', 'kd.scm.pur.common.task.PurOrderAutoUrgeTask', 1, '{}', 'pur_PurOrderUrgeToSup_SKDJ_S', '2BOTT1/0END=', '1');
DELETE from t_sch_job_l WHERE fid = '2BP2L1R57HSR' AND flocaleid = 'zh_CN';
DELETE from t_sch_job_l WHERE fid = '2BP2L1R57HSR' AND flocaleid = 'zh_TW';
INSERT INTO t_sch_job_l (fpkid, fid, flocaleid, fname) VALUES ('2BP2L1R57DR7', '2BP2L1R57HSR', 'zh_CN', '采购订单自动催办');
INSERT INTO t_sch_job_l (fpkid, fid, flocaleid, fname) VALUES ('2BP2L1R57DR8', '2BP2L1R57HSR', 'zh_TW', '采購訂單自動催辦');

--调度任务--
DELETE from T_SCH_SCHEDULE WHERE fid = '2BP38DVA50BK';
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 ('2BP38DVA50BK', '2BP2L1R57HSR', {ts'2022-04-02 11:24:46'}, {ts'2050-12-03 11:24:47'}, '0 24 8 * * ?', 'pur_PurOrderUrgeToSup_SKDP_S', '0', 'd', 1, '172.19.108.42', '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 fid = '2BP38DVA50BK' AND flocaleid = 'zh_CN';
DELETE from T_SCH_SCHEDULE_L WHERE fid = '2BP38DVA50BK' AND flocaleid = 'zh_TW';
INSERT INTO t_sch_schedule_l (fpkid, fid, flocaleid, fname) VALUES ('2BP38DVA4YA0', '2BP38DVA50BK', 'zh_CN', '采购订单自动催办');
INSERT INTO t_sch_schedule_l (fpkid, fid, flocaleid, fname) VALUES ('2BP38DVA4YA1', '2BP38DVA50BK', 'zh_TW', '采購訂單自動催辦');