DELETE FROM t_evt_event WHERE FID = 1984729070574881792;
INSERT INTO t_evt_event(FID,FMODIFYDATE,FTYPE,FISPREINSDATA,FSCENE,FCREATEDATE,FENTITY,FOPERNUMBER,FSTATUS,FPASSOPERPARAM,FNUMBER,FNAME,FMODIFIER,FSOURCE,FNUMBERVIEW,FISMODIFIED,FCREATER) VALUES (1984729070574881792,{ts'2024-07-01  00:00:00'},'cosmic','0','operate',{ts'2024-07-01  00:00:00'},'adm_complaint','submit','1','0','adm_complaint.submit','我的投诉单.提交',1210710027598321664,'/DNEA3QW/ATD','adm_complaint.submit','1',1210710027598321664); 
DELETE FROM t_evt_event_l WHERE FID = 1984729070574881792 and FLOCALEID = 'zh_CN';
INSERT INTO t_evt_event_l(FID,FPKID,FLOCALEID,FOPERATION,FDESCRIPTION,FNAME) VALUES (1984729070574881792,'47SN2SNY44DX','zh_CN','提交',' ','我的投诉单.提交'); 


DELETE FROM t_evt_subscription WHERE FID = 1647939204120181760;
INSERT INTO t_evt_subscription(FMODIFYDATE,FSERVICENUMBER,FEXECUTORVALUE,FSEQUENCE,FSERVICECONFIG,FEVENT,FERRORNOTIFY,FEVENTNUMBER,FISMODIFIED,FEXECUTIONSTRATEGY,FTIMINGSTRATEGY,FID,FISPREINSDATA,FCONDITION,FCREATEDATE,FISCONCURRENT,FSTATUS,FNOTIFYTEXT,FSERVICE,FNUMBER,FEXPRESSION,FMODIFIER,FAPPID,FEXECUTOR,FERRORSTRATEGY,FCREATER,FEVENTSPLITCONFIG) VALUES ({ts'2024-07-01  00:00:00'},'sendMsg',' ',0,'{"receivervalue":"[{\"valueshowtext\":\"投诉管理.投诉发起人\",\"type\":\"entity\",\"value\":\"model.launchuser\",\"required\":false}]","receiver":"实体：投诉管理.投诉发起人","urlvalue":"{\"formId\":\"adm_complaint\",\"mob_formId\":\"adm_complaint_mob\"}","batch":true,"signalemail":true,"notifytype":",sms,email,","url":"http://172.19.111.125:8080/ierp/integration/yzjShareOpen.do?formId=adm_complaint&mb_formId=adm_complaint_mob&pkId=0&accountId=1150088256818250752&src=wf","content":"{\"title\":{\"zh_CN\":\"【投诉处理回复】\"},\"content\":{\"zh_CN\":\"您的投诉“{name}”已有处理回复，请及时查看。\"}}"}',1647938359823315968,' ','srm_complaintmanage.audit','1',' ',' ',1647939204120181760,'1','{"elementid":"","expression":"${ model.precomments == \"B\" }","entryentity":[{"valuetype":"commVal","leftbracket":"","rightbracket":"","isHideExp":false,"id":"1984720033770753024","paramnumber":"model.precomments","logic":"&&","operation":"==","value":"B","seq":0}],"showtext":{"zh_TW":"执行条件","en_US":"执行条件","GLang":"执行条件","zh_CN":"执行条件"},"property":"EventConfig","description":{"zh_TW":"","en_US":"","zh_CN":""},"validtime":null,"type":"exeConditionRule"}',{ts'2023-03-24  00:00:00'},'1','1',' ',920966216397414400,'srm_complaintmanage.audit.sendMsg','${ model.precomments == "B" }',1210710027598321664,' ',' ','retry',13466739,' '); 
DELETE FROM t_evt_subscription WHERE FID = 1647945841706677248;
INSERT INTO t_evt_subscription(FMODIFYDATE,FSERVICENUMBER,FEXECUTORVALUE,FSEQUENCE,FSERVICECONFIG,FEVENT,FERRORNOTIFY,FEVENTNUMBER,FISMODIFIED,FEXECUTIONSTRATEGY,FTIMINGSTRATEGY,FID,FISPREINSDATA,FCONDITION,FCREATEDATE,FISCONCURRENT,FSTATUS,FNOTIFYTEXT,FSERVICE,FNUMBER,FEXPRESSION,FMODIFIER,FAPPID,FEXECUTOR,FERRORSTRATEGY,FCREATER,FEVENTSPLITCONFIG) VALUES ({ts'2024-07-01  00:00:00'},'sendMsg',' ',0,'{"receivervalue":"[{\"valueshowtext\":\"投诉处理.投诉发起人\",\"type\":\"entity\",\"value\":\"model.launchuser\",\"required\":false}]","receiver":"实体：投诉处理.投诉发起人","urlvalue":"{\"formId\":\"adm_complaint\",\"mob_formId\":\"adm_complaint_mob\"}","batch":true,"signalemail":true,"notifytype":",email,sms,","url":"http://172.19.111.125:8080/ierp/integration/yzjShareOpen.do?formId=adm_complaint&mb_formId=adm_complaint_mob&pkId=0&accountId=1150088256818250752&src=wf","content":"{\"title\":{\"zh_CN\":\"【投诉处理回复】\"},\"content\":{\"zh_CN\":\"您的投诉“{name}”已有处理回复，请及时查看。\"}}"}',1647945001705026560,' ','srm_complainthandle.audit','1',' ',' ',1647945841706677248,'1',' ',{ts'2023-03-24  00:00:00'},'1','1',' ',920966216397414400,'srm_complainthandle.audit.sendMsg',' ',1210710027598321664,' ',' ','retry',13466739,' '); 
DELETE FROM t_evt_subscription WHERE FID = 1647894673236308992;
INSERT INTO t_evt_subscription(FMODIFYDATE,FSERVICENUMBER,FEXECUTORVALUE,FSEQUENCE,FSERVICECONFIG,FEVENT,FERRORNOTIFY,FEVENTNUMBER,FISMODIFIED,FEXECUTIONSTRATEGY,FTIMINGSTRATEGY,FID,FISPREINSDATA,FCONDITION,FCREATEDATE,FISCONCURRENT,FSTATUS,FNOTIFYTEXT,FSERVICE,FNUMBER,FEXPRESSION,FMODIFIER,FAPPID,FEXECUTOR,FERRORSTRATEGY,FCREATER,FEVENTSPLITCONFIG) VALUES ({ts'2023-03-30  00:00:00'},'sendMsg',' ',0,'{"receivervalue":"[{\"valueshowtext\":\"投诉管理.指派处理人员\",\"type\":\"entity\",\"value\":\"model.dealuser\",\"required\":false}]","receiver":"实体：投诉管理.指派处理人员","urlvalue":"{\"formId\":\"srm_complainthandle\",\"mob_formId\":\"srm_complainthandle_mob\"}","batch":true,"signalemail":false,"url":"http://172.19.111.125:8080/ierp/integration/yzjShareOpen.do?formId=srm_complainthandle&mb_formId=srm_complainthandle_mob&pkId=0&accountId=1150088256818250752&src=wf","content":"{\"title\":{\"zh_CN\":\"【投诉处理指派】\"},\"content\":{\"zh_CN\":\"''''{model.acceptuser.name}'''' 指派您处理 '''' {model.supplier.name}''''，主题为''''{name}'''' 的投诉，请尽快处理。\"}}"}',1647893216336673792,' ','srm_complaintmanage.pushhandle','1',' ',' ',1647894673236308992,'1','{"elementid":"","expression":"${ notempty model.dealuser.id }","entryentity":[{"valuetype":"fieldVal","leftbracket":"","rightbracket":"","isHideExp":false,"id":"1647894772255437824","paramnumber":"model.dealuser.id","logic":"&&","operation":"notempty","value":"","seq":0}],"showtext":{"zh_TW":"执行条件","en_US":"执行条件","GLang":"执行条件","zh_CN":"执行条件"},"property":"EventConfig","description":{"zh_TW":"","en_US":"","zh_CN":""},"validtime":null,"type":"exeConditionRule"}',{ts'2023-03-24  00:00:00'},'1','1',' ',920966216397414400,'srm_complaintmanage.pushhandle.sendMsg','${ notempty model.dealuser.id }',13466739,' ',' ','retry',13466739,' '); 
DELETE FROM t_evt_subscription WHERE FID = 1984725098518662144;
INSERT INTO t_evt_subscription(FMODIFYDATE,FSERVICENUMBER,FEXECUTORVALUE,FSEQUENCE,FSERVICECONFIG,FEVENT,FERRORNOTIFY,FEVENTNUMBER,FISMODIFIED,FEXECUTIONSTRATEGY,FTIMINGSTRATEGY,FID,FISPREINSDATA,FCONDITION,FCREATEDATE,FISCONCURRENT,FSTATUS,FNOTIFYTEXT,FSERVICE,FNUMBER,FEXPRESSION,FMODIFIER,FAPPID,FEXECUTOR,FERRORSTRATEGY,FCREATER,FEVENTSPLITCONFIG) VALUES ({ts'2024-07-01  00:00:00'},'sendMsg',' ',0,'{"receivervalue":"[{\"valueshowtext\":\"投诉管理.处理人\",\"type\":\"entity\",\"value\":\"model.dealuser\",\"required\":false}]","receiver":"实体：投诉管理.处理人","urlvalue":"{\"formId\":\"srm_complainthandle\",\"mob_formId\":\"srm_complainthandle_mob\"}","batch":false,"signalemail":true,"notifytype":",sms,email,","url":"http://localhost:8080/ierp/integration/yzjShareOpen.do?formId=srm_complainthandle&mb_formId=srm_complainthandle_mob&pkId=0&accountId=1150088256818250752&src=wf","content":"{\"title\":{\"zh_CN\":\"【投诉处理通知】\"},\"content\":{\"zh_CN\":\"请您尽快查看并处理主题为“{name}”的投诉。\"}}"}',1647938359823315968,' ','srm_complaintmanage.audit','1',' ',' ',1984725098518662144,'1','{"elementid":"","expression":"${ model.precomments == \"A\" }","entryentity":[{"valuetype":"commVal","leftbracket":"","rightbracket":"","isHideExp":false,"id":"1984721118132801536","paramnumber":"model.precomments","logic":"&&","operation":"==","value":"A","seq":0}],"showtext":{"zh_TW":"执行条件","en_US":"执行条件","GLang":"执行条件","zh_CN":"执行条件"},"property":"EventConfig","description":{"zh_TW":"","en_US":"","zh_CN":""},"validtime":null,"type":"exeConditionRule"}',{ts'2024-07-01  00:00:00'},'1','1',' ',920966216397414400,'srm_complaintmanage.audit.sendMsg2','${ model.precomments == "A" }',1210710027598321664,' ',' ','retry',1210710027598321664,' '); 
DELETE FROM t_evt_subscription_l WHERE FID = 1647945841706677248 and FLOCALEID = 'zh_CN';
INSERT INTO t_evt_subscription_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1647945841706677248,'35E4L5/D3YPK','zh_CN','投诉处理.审核.发送消息'); 
DELETE FROM t_evt_subscription_l WHERE FID = 1647894673236308992 and FLOCALEID = 'zh_CN';
INSERT INTO t_evt_subscription_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1647894673236308992,'35DX0=AL7EB1','zh_CN','投诉管理.下达.发送消息'); 
DELETE FROM t_evt_subscription_l WHERE FID = 1647939204120181760 and FLOCALEID = 'zh_CN';
INSERT INTO t_evt_subscription_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1647939204120181760,'35E3BSNOR2X4','zh_CN','投诉管理.审核.不受理发送消息'); 
DELETE FROM t_evt_subscription_l WHERE FID = 1984725098518662144 and FLOCALEID = 'zh_CN';
INSERT INTO t_evt_subscription_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1984725098518662144,'47SMBUUMVEXA','zh_CN','投诉管理.审核.受理发送消息'); 
