-- 1.事件定义

--单头 

DELETE FROM t_evt_event WHERE FID = 1504600514565031936;

DELETE FROM t_evt_event WHERE FID = 1504425214853811200;
INSERT INTO t_evt_event(FID,FMODIFYDATE,FTYPE,FSCENE,FCREATEDATE,FOPERATION,FDESCRIPTION,FENTITY,FOPERNUMBER,FSTATUS,FNUMBER,FNAME,FMODIFIER,FSOURCE,FCREATER) VALUES (1504425214853811200,{ts'2022-09-07  00:00:00'},'cosmic','operate',{ts'2022-09-07  00:00:00'},'审核',' ','scp_ordchange','audit','1','scp_ordchange.audit',' ',1210069609236019200,'eae607fb000152ac',1210069609236019200); 
--多语言

DELETE FROM t_evt_event_l WHERE FID = 1504600514565031936 AND flocaleid = 'zh_CN';

DELETE FROM t_evt_event_l WHERE FID = 1504425214853811200 AND flocaleid = 'zh_CN';
INSERT INTO t_evt_event_l(FID,FPKID,FLOCALEID,FOPERATION,FDESCRIPTION,FNAME) VALUES (1504425214853811200,'2PSJCT5WLLK9','zh_CN',' ',' ','订单变更.审核'); 

-- 2.事件订阅
--单头 

DELETE FROM t_evt_subscription WHERE FID = 1504601452285583360;

DELETE FROM t_evt_subscription WHERE FID = 1504459089025990656;
INSERT INTO t_evt_subscription(FMODIFYDATE,FSERVICENUMBER,FEXECUTORVALUE,FSEQUENCE,FSERVICECONFIG,FEVENT,FERRORNOTIFY,FEVENTNUMBER,FISMODIFIED,FTIMINGSTRATEGY,FID,FISPREINSDATA,FCONDITION,FCREATEDATE,FSTATUS,FISCONCURRENT,FNOTIFYTEXT,FSERVICE,FNAME,FNUMBER,FEXPRESSION,FMODIFIER,FEXECUTOR,FCREATER,FERRORSTRATEGY) VALUES ({ts'2022-09-20  00:00:00'},'sendMsg',' ',0,'{"receivervalue":"[{\"valueshowtext\":\"订单变更.采购方联系人.对应人员\",\"type\":\"entity\",\"value\":\"model.person.user\",\"required\":false}]","receiver":"实体：订单变更.采购方联系人.对应人员","urlvalue":"{\"formId\":\"pur_scppromisedatechange\",\"mob_formId\":\"pur_scppromisedatechange\"}","batch":true,"signalemail":false,"notifytype":",sms,email,","url":"http://localhost:8080/ierp/integration/yzjShareOpen.do?formId=pur_scppromisedatechange&mb_formId=pur_scppromisedatechange&pkId=0&accountId=1150088256818250752&src=wf","content":"{\"title\":{\"zh_CN\":\"【订单变更确认通知】\"},\"content\":{\"zh_CN\":\"供应商发起交期变更，请及时确认。\\n供应商：{model.supplier.name}\\n订单编号：{model.pobillno}\\n变更单号：{billno}\\n\"}}"}',1504425214853811200,' ','scp_ordchange.audit','1',' ',1504459089025990656,'0',' ',{ts'2022-09-07  00:00:00'},'0','1',' ',920966216397414400,'采购订单变更采购方确认消息.发送给采购方联系人','scp_ordchange.audit.sendMsg',' ',1210069609236019200,' ',1210069609236019200,'retry'); 

--多语言
DELETE FROM t_evt_subscription_l WHERE FID = 1504601452285583360 AND flocaleid = 'zh_CN';

DELETE FROM t_evt_subscription_l WHERE FID = 1504459089025990656 AND flocaleid = 'zh_CN';
INSERT INTO t_evt_subscription_l(FID,FPKID,FLOCALEID,FNOTIFYTEXT,FNAME) VALUES (1504459089025990656,'2PSPPMZA0GTR','zh_CN',' ','采购订单变更采购方确认消息.发送给采购方联系人'); 
DELETE FROM t_evt_subscription_l WHERE FID = 1504459089025990656 AND flocaleid = 'zh_TW';
INSERT INTO t_evt_subscription_l(FID,FPKID,FLOCALEID,FNOTIFYTEXT,FNAME) VALUES (1504459089025990656,'2QYDGNYVL6UM','zh_TW',' ','采購訂單變更采購方確認消息.發送給采購方聯係人'); 

