/**预警平台方案**/

DELETE FROM t_warn_schedule WHERE FID = '1692807176651218944';
INSERT INTO t_warn_schedule(FMODIFYDATE,FTYPE,FEARLYWARNID,FISV,FDATA,FINHERITPATH,FMASTERID,FMONITORFREQUENCY,FPLANID,FMONITORRANGE,FENABLE,FJOBID,FMODELTYPE,FID,FVERSION,FISTEMPLATE,FSTARTDATE,FCREATEDATE,FLASTSYNCTIME,FBYENTRY,FPARENTID,FNUMBER,FPLANNUMBER,FMODIFIERID,FBIZAPPID,FENDDATE,FCREATORID) VALUES ({ts'2023-06-20  00:00:00'},'0','1692808432761256960','kingdee',' ','1692807176651218944','1692807176651218944','每天-08:00:00','1706569530744250368','从2023-05-25开始','1','1692814217545457664','WarnScheduleModel','1692807176651218944',1687254068008,'0',{ts'2023-05-25  00:00:00'},{ts'2023-05-25  00:00:00'},{ts'2023-06-20  00:00:00'},'1',' ','contactOverUnpaidSchm',' ',1155765943016650752,'10MYBGBYHXDU',{ts'2023-05-25  00:00:00'},1155765943016650752);

DELETE FROM t_warn_schedule_l WHERE FID = '1692807176651218944';
DELETE FROM t_warn_schedule_l WHERE FPKID = '3C8QA7JED3D5';
INSERT INTO t_warn_schedule_l(FID,FPKID,FLOCALEID,FDATA,FNAME) VALUES ('1692807176651218944','3C8QA7JED3D5','zh_TW','<?xml version="1.0" encoding="UTF-8"?>

<WarnScheduleMetadata>
  <WarnSchedule>
    <WarnSchedule>
      <MessageConfig>
        <WarnMessageConfig>
          <SendTypes>
            <WarnMessageSendType action="edit" oid="yunzhijia">
              <Id>475756772099906560</Id>
            </WarnMessageSendType>
            <WarnMessageSendType action="edit" oid="sms">
              <Id>475773159430184960</Id>
            </WarnMessageSendType>
          </SendTypes>
        </WarnMessageConfig>
      </MessageConfig>
      <Name>合同台賬超期未付預警方案</Name>
    </WarnSchedule>
  </WarnSchedule>
</WarnScheduleMetadata>
','合同台賬超期未付預警方案');


DELETE FROM t_warn_schedule_l WHERE FPKID = '3C8QA7JE9=JM';
INSERT INTO t_warn_schedule_l(FID,FPKID,FLOCALEID,FDATA,FNAME) VALUES ('1692807176651218944','3C8QA7JE9=JM','zh_CN','<?xml version="1.0" encoding="UTF-8"?>

<WarnScheduleMetadata>
  <WarnSchedule>
    <WarnSchedule>
      <MessageConfig>
        <WarnMessageConfig>
          <SendTypes>
            <WarnMessageSendType action="edit" oid="yunzhijia">
              <Id>475756772099906560</Id>
            </WarnMessageSendType>
            <WarnMessageSendType action="edit" oid="sms">
              <Id>475773159430184960</Id>
            </WarnMessageSendType>
          </SendTypes>
        </WarnMessageConfig>
      </MessageConfig>
    </WarnSchedule>
  </WarnSchedule>
</WarnScheduleMetadata>
','合同台账超期未付预警方案');
DELETE FROM t_warn_schedule_l WHERE FPKID = '3C8QA7JI/IKO';
INSERT INTO t_warn_schedule_l(FID,FPKID,FLOCALEID,FDATA,FNAME) VALUES ('1692807176651218944','3C8QA7JI/IKO','en_US','<?xml version="1.0" encoding="UTF-8"?>
<WarnScheduleMetadata>
  <WarnSchedule>
    <WarnSchedule>
      <MessageConfig>
        <WarnMessageConfig>
          <SendTypes>
            <WarnMessageSendType action="edit" oid="yunzhijia">
              <Id>475756772099906560</Id>
            </WarnMessageSendType>
            <WarnMessageSendType action="edit" oid="sms">
              <Id>475773159430184960</Id>
            </WarnMessageSendType>
          </SendTypes>
        </WarnMessageConfig>
      </MessageConfig>
    </WarnSchedule>
  </WarnSchedule>
</WarnScheduleMetadata>
',' ');



/**预警平台方案 对应的调度任务、调度计划**/


DELETE FROM t_sch_taskdefine WHERE FID = 'EW_1692807176651218944';
INSERT INTO t_sch_taskdefine(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('EW_1692807176651218944','kd.bos.service.earlywarn.EarlyWarnScheduleTask','em','contactOverUnpaidSchm');

DELETE FROM t_sch_taskdefine_l WHERE FPKID = '3=Y318DMXMMA';
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('EW_1692807176651218944','3=Y318DMXMMA','zh_TW','预警监控方案执行类');
DELETE FROM t_sch_taskdefine_l WHERE FPKID = '3=Y318DMXMMB';
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('EW_1692807176651218944','3=Y318DMXMMB','zh_CN','预警监控方案执行类');
DELETE FROM t_sch_taskdefine_l WHERE FPKID = '3=Y318DMXMMC';
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('EW_1692807176651218944','3=Y318DMXMMC','en_US','预警监控方案执行类');



DELETE FROM T_SCH_JOB WHERE FID = '1692814217545457664';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FRUNMODE,FTASKDEFINEID,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FRETRYTIME,FRUNBYLANG,FCANSTOP,FRUNBYORGID,FPARAMS) VALUES ('1692814217545457664','kd.bos.service.earlywarn.EarlyWarnScheduleTask','0','EW_1692807176651218944',1,'BIZ','1','contactOverUnpaidSchm','0','1',0,0,'zh_CN','0',0,'{"warnScheduleId":"1692807176651218944"}');

DELETE FROM t_sch_job_l WHERE FID = '1692814217545457664';
INSERT INTO t_sch_job_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1692814217545457664','3C4T6A=YYR74','zh_CN','合同台账超期未付预警方案');


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

DELETE FROM t_sch_schedule_l WHERE FID = '1706569530744250368';
INSERT INTO t_sch_schedule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1706569530744250368','1706569530811235328','zh_CN','合同台账超期未付预警方案');
