DELETE FROM t_warn_schedule WHERE FID = '1208520049963368448';
INSERT INTO t_warn_schedule(FMODIFYDATE,FTYPE,FEARLYWARNID,FISV,FDATA,FINHERITPATH,FMASTERID,FMONITORFREQUENCY,FPLANID,FMONITORRANGE,FENABLE,FJOBID,FMODELTYPE,FID,FVERSION,FISTEMPLATE,FSTARTDATE,FCREATEDATE,FLASTSYNCTIME,FPARENTID,FNUMBER,FPLANNUMBER,FMODIFIERID,FBIZAPPID,FENDDATE,FCREATORID) VALUES ({ts'2021-08-25  00:00:00'},'0','1208524529505326080','kingdee','<?xml version="1.0" encoding="UTF-8"?>

<WarnScheduleMetadata>
  <DevType>0</DevType>
  <WarnSchedule>
    <WarnSchedule>
      <LastSyncTime>1629883325000</LastSyncTime>
      <RunCycle>
        <RunCycle>
          <RangeType>from_start_date</RangeType>
          <EndDate>2021-07-26</EndDate>
          <Description>从2021-07-26开始，每天 00:00:00执行</Description>
          <PeriodType>day</PeriodType>
          <StartDate>2021-07-26</StartDate>
        </RunCycle>
      </RunCycle>
      <WarnCondition>
        <WarnCondition>
          <CustomDataJson>{"warnday":20}</CustomDataJson>
        </WarnCondition>
      </WarnCondition>
      <BizAppId>XV1IC150UR4</BizAppId>
      <JobId>1208528720881583104</JobId>
      <Number>adm_qualification_warn</Number>
      <MessageConfig>
        <WarnMessageConfig>
          <MergeContent>合并发送</MergeContent>
          <ReceiverTypes>
            <WarnMessageReceiverType>
              <Receivers>
                <WarnMessageReceiver>
                  <ReceiverType>custom_receiver</ReceiverType>
                  <Name>kd.scm.srm.formplugin.warn.SrmWarnCostomReceivePlugin</Name>
                  <Id>custom_receiver</Id>
                </WarnMessageReceiver>
              </Receivers>
              <Type>custom_receiver</Type>
            </WarnMessageReceiverType>
          </ReceiverTypes>
          <Title>证书预警</Title>
          <SendTypes>
            <WarnMessageSendType>
              <Name>消息中心</Name>
              <Value>message_center</Value>
            </WarnMessageSendType>
          </SendTypes>
          <SingleContent>您好！贵公司“{name}”在“{createorg.name}”提交的资质证书，存在有到期的信息，请及时更新，谢谢！到期明细如下：</SingleContent>
        </WarnMessageConfig>
      </MessageConfig>
      <nable>true</nable>
      <Name>供应商方_供应商资质证书到期预警方案</Name>
      <PlanId>1223694681192359936</PlanId>
      <Id>1208520049963368448</Id>
      <EarlyWarnId>1208524529505326080</EarlyWarnId>
    </WarnSchedule>
  </WarnSchedule>
  <ModelType>WarnScheduleModel</ModelType>
  <Isv>kingdee</Isv>
  <ParentId></ParentId>
  <MasterId>1208520049963368448</MasterId>
  <Number>adm_qualification_warn</Number>
  <BizappId>XV1IC150UR4</BizappId>
  <Id>1208520049963368448</Id>
  <InheritPath>1208520049963368448</InheritPath>
</WarnScheduleMetadata>
','1208520049963368448','1208520049963368448','每天-00:00:00','1223694681192359936','从2021-07-26开始','1','1208528720881583104','WarnScheduleModel','1208520049963368448',1629882725914,'0',{ts'2021-07-26  00:00:00'},{ts'2021-08-25  00:00:00'},{ts'2021-08-25  00:00:00'},' ','adm_qualification_warn',' ',13466739,'XV1IC150UR4',{ts'2021-07-26  00:00:00'},13466739); 

 
 
DELETE FROM t_warn_schedule_l WHERE FPKID = '1V3Y/DZZ7RHU';
INSERT INTO t_warn_schedule_l(FID,FPKID,FLOCALEID,FDATA,FNAME) VALUES ('1208520049963368448','1V3Y/DZZ7RHU','zh_CN','<?xml version="1.0" encoding="UTF-8"?>

<WarnScheduleMetadata/>
','供应商方_供应商资质证书到期预警方案'); 

DELETE FROM t_warn_schedule WHERE FID = '1230281669915757568';
INSERT INTO t_warn_schedule(FMODIFYDATE,FTYPE,FEARLYWARNID,FISV,FDATA,FINHERITPATH,FMASTERID,FMONITORFREQUENCY,FPLANID,FMONITORRANGE,FENABLE,FJOBID,FMODELTYPE,FID,FVERSION,FISTEMPLATE,FSTARTDATE,FCREATEDATE,FLASTSYNCTIME,FPARENTID,FNUMBER,FPLANNUMBER,FMODIFIERID,FBIZAPPID,FENDDATE,FCREATORID) VALUES ({ts'2021-08-25  00:00:00'},'0','1208524529505326080','kingdee','<?xml version="1.0" encoding="UTF-8"?>

<WarnScheduleMetadata>
  <DevType>0</DevType>
  <WarnSchedule>
    <WarnSchedule>
      <LastSyncTime>1629884888000</LastSyncTime>
      <RunCycle>
        <RunCycle>
          <RangeType>from_start_date</RangeType>
          <EndDate>2021-07-26</EndDate>
          <Description>从2021-07-26开始，每天 00:00:00执行</Description>
          <PeriodType>day</PeriodType>
          <StartDate>2021-07-26</StartDate>
        </RunCycle>
      </RunCycle>
      <WarnCondition>
        <WarnCondition>
          <CustomDataJson>{"warnday":20}</CustomDataJson>
        </WarnCondition>
      </WarnCondition>
      <BizAppId>XV1IC150UR4</BizAppId>
      <JobId>1230283226313032704</JobId>
      <Number>srm_qualification_warn</Number>
      <MessageConfig>
        <WarnMessageConfig>
          <MergeContent></MergeContent>
          <ReceiverTypes>
            <WarnMessageReceiverType>
              <Receivers>
                <WarnMessageReceiver>
                  <Field>auditor</Field>
                  <ReceiverType>relation_person</ReceiverType>
                  <Name>审核人-本人</Name>
                  <Id>auditor-self</Id>
                  <DataSource>srm_supplier</DataSource>
                  <Relation>self</Relation>
                </WarnMessageReceiver>
              </Receivers>
              <Type>relation_person</Type>
            </WarnMessageReceiverType>
          </ReceiverTypes>
          <Title>证书预警</Title>
          <SendTypes>
            <WarnMessageSendType>
              <Name>消息中心</Name>
              <Value>message_center</Value>
            </WarnMessageSendType>
          </SendTypes>
          <SingleContent>您好！“{name}”提交的资质证书存在到期的证书信息，请及时联系供应商更新资质信息，谢谢！明细如下：</SingleContent>
        </WarnMessageConfig>
      </MessageConfig>
      <nable>true</nable>
      <Name>采购方_供应商资质证书到期预警方案</Name>
      <PlanId>1230283226363364352</PlanId>
      <Id>1230281669915757568</Id>
      <EarlyWarnId>1208524529505326080</EarlyWarnId>
    </WarnSchedule>
  </WarnSchedule>
  <ModelType>WarnScheduleModel</ModelType>
  <Isv>kingdee</Isv>
  <ParentId></ParentId>
  <MasterId>1230281669915757568</MasterId>
  <Number>srm_qualification_warn</Number>
  <BizappId>XV1IC150UR4</BizappId>
  <Id>1230281669915757568</Id>
  <InheritPath>1230281669915757568</InheritPath>
</WarnScheduleMetadata>
 ','1230281669915757568','1230281669915757568','每天-00:00:00','1230283226363364352','从2021-07-26开始','1','1230283226313032704','WarnScheduleModel','1230281669915757568',1629883714254,'0',{ts'2021-07-26  00:00:00'},{ts'2021-08-25  00:00:00'},{ts'2021-08-25  00:00:00'},' ','srm_qualification_warn',' ',13466739,'XV1IC150UR4',{ts'2021-07-26  00:00:00'},13466739); 



DELETE FROM t_warn_schedule_l WHERE FPKID = '1V35YE9KP/UO';
INSERT INTO t_warn_schedule_l(FID,FPKID,FLOCALEID,FDATA,FNAME) VALUES ('1230281669915757568','1V35YE9KP/UO','zh_CN','<?xml version="1.0" encoding="UTF-8"?>

<WarnScheduleMetadata/>
','采购方_供应商资质证书到期预警方案'); 