--清除之前的数据
DELETE FROM t_evt_event WHERE FID = 1371729830864749568;
DELETE FROM t_evt_event_l WHERE FPKID = '2=GTTTCLPKHO';
DELETE FROM t_evt_event_l WHERE FPKID = '2=GTTTCLPKHP';
DELETE FROM t_evt_subscription WHERE FID = 1372536723786957824;
DELETE FROM t_evt_subscription_l WHERE FPKID = '2=KOKM500AO5';

--事件定义
DELETE FROM t_evt_event WHERE FID = 1377504248090066944;
INSERT INTO t_evt_event(FID,FMODIFYDATE,FTYPE,FISPREINSDATA,FSCENE,FCREATEDATE,FOPERATION,FDESCRIPTION,FENTITY,FOPERNUMBER,FSTATUS,FNUMBER,FNAME,FMODIFIER,FSOURCE,FNUMBERVIEW,FISMODIFIED,FCREATER) VALUES (1377504248090066944,{ts'2022-03-16  00:00:00'},'cosmic','1','operate',{ts'2022-03-16  00:00:00'},'审核',' ','pmpd_project','audit','1','pmpd_project.audit',' ',61021620,'064+L=UVGI9P','pmpd_project.audit','1',61021620);
DELETE FROM t_evt_event WHERE FID = 1377504648344109056;
INSERT INTO t_evt_event(FID,FMODIFYDATE,FTYPE,FISPREINSDATA,FSCENE,FCREATEDATE,FOPERATION,FDESCRIPTION,FENTITY,FOPERNUMBER,FSTATUS,FNUMBER,FNAME,FMODIFIER,FSOURCE,FNUMBERVIEW,FISMODIFIED,FCREATER) VALUES (1377504648344109056,{ts'2022-03-16  00:00:00'},'cosmic','1','operate',{ts'2022-03-16  00:00:00'},'反审核',' ','pmpd_project','unaudit','1','pmpd_project.unaudit',' ',61021620,'064+L=UVGI9P','pmpd_project.unaudit','1',61021620);
DELETE FROM t_evt_event WHERE FID = 1377533611741283328;
INSERT INTO t_evt_event(FID,FMODIFYDATE,FTYPE,FISPREINSDATA,FSCENE,FCREATEDATE,FOPERATION,FDESCRIPTION,FENTITY,FOPERNUMBER,FSTATUS,FNUMBER,FNAME,FMODIFIER,FSOURCE,FNUMBERVIEW,FISMODIFIED,FCREATER) VALUES (1377533611741283328,{ts'2022-03-16  00:00:00'},'custom','1','operate',{ts'2022-03-16  00:00:00'},' ',' ',' ',' ','1','pmpd_project_delete',' ',61021620,' ','pmpd_project_delete','1',61021620);

DELETE FROM t_evt_event_l WHERE FPKID = '2A6GQWGM0FNN';
INSERT INTO t_evt_event_l(FID,FPKID,FLOCALEID,FOPERATION,FDESCRIPTION,FNAME) VALUES (1377504248090066944,'2A6GQWGM0FNN','zh_CN',' ','项目审核','项目.审核');
DELETE FROM t_evt_event_l WHERE FPKID = '2A6GQWGM0FNO';
INSERT INTO t_evt_event_l(FID,FPKID,FLOCALEID,FOPERATION,FDESCRIPTION,FNAME) VALUES (1377504248090066944,'2A6GQWGM0FNO','zh_TW',' ','項目審核',' ');
DELETE FROM t_evt_event_l WHERE FPKID = '2A6GTT7Y2I=W';
INSERT INTO t_evt_event_l(FID,FPKID,FLOCALEID,FOPERATION,FDESCRIPTION,FNAME) VALUES (1377504648344109056,'2A6GTT7Y2I=W','zh_CN',' ','项目反审核','项目.反审核');
DELETE FROM t_evt_event_l WHERE FPKID = '2A6GTT7Y2I=X';
INSERT INTO t_evt_event_l(FID,FPKID,FLOCALEID,FOPERATION,FDESCRIPTION,FNAME) VALUES (1377504648344109056,'2A6GTT7Y2I=X','zh_TW',' ','項目反審核',' ');
DELETE FROM t_evt_event_l WHERE FPKID = '2A6M7VDO=4CK';
INSERT INTO t_evt_event_l(FID,FPKID,FLOCALEID,FOPERATION,FDESCRIPTION,FNAME) VALUES (1377533611741283328,'2A6M7VDO=4CK','zh_CN',' ','项目删除','项目.删除');
DELETE FROM t_evt_event_l WHERE FPKID = '2A6M7VDO=4CL';
INSERT INTO t_evt_event_l(FID,FPKID,FLOCALEID,FOPERATION,FDESCRIPTION,FNAME) VALUES (1377533611741283328,'2A6M7VDO=4CL','zh_TW',' ','項目刪除','項目.刪除');

DELETE FROM t_evt_eventconfig WHERE FENTRYID = 1377554408174256128;
INSERT INTO t_evt_eventconfig(FID,FCONFIGDESCRIPTION,FCONFIGTYPE,FISTRANSFER,FENTRYID,FSEQ,FCONFIGNUMBER,FISCUSTOM,FCONFIGNAME) VALUES (1377533611741283328,'返回结果类型为:枚举',' ','1',1377554408174256128,1,'projectids','1','项目ID');

--事件订阅
DELETE FROM t_evt_subscription WHERE FID = 1377554982307365888;
INSERT INTO t_evt_subscription(FMODIFYDATE,FSERVICENUMBER,FSEQUENCE,FEXECUTORVALUE,FSERVICECONFIG,FEVENT,FERRORNOTIFY,FEVENTNUMBER,FISMODIFIED,FTIMINGSTRATEGY,FID,FISPREINSDATA,FCONDITION,FCREATEDATE,FISCONCURRENT,FSTATUS,FNOTIFYTEXT,FSERVICE,FNUMBER,FNAME,FEXPRESSION,FMODIFIER,FEXECUTOR,FERRORSTRATEGY,FCREATER) VALUES ({ts'2022-03-22  00:00:00'},'executePlugin',0,' ','{"scriptid":"","type":"class","value":"{\"appid\":\"fmm\",\"class\":\"kd.pmc.event.project.delete.DeleteProjectServiceEvent\"}"}',1377533611741283328,' ','pmpd_project_delete','1',' ',1377554982307365888,'1',' ',{ts'2022-03-16  00:00:00'},'1','1',' ',904236026388547584,'pmpd_project_delete.project','项目.删除.执行插件',' ',61021620,' ','retry',61021620);
DELETE FROM t_evt_subscription WHERE FID = 1377506365416669184;
INSERT INTO t_evt_subscription(FMODIFYDATE,FSERVICENUMBER,FSEQUENCE,FEXECUTORVALUE,FSERVICECONFIG,FEVENT,FERRORNOTIFY,FEVENTNUMBER,FISMODIFIED,FTIMINGSTRATEGY,FID,FISPREINSDATA,FCONDITION,FCREATEDATE,FISCONCURRENT,FSTATUS,FNOTIFYTEXT,FSERVICE,FNUMBER,FNAME,FEXPRESSION,FMODIFIER,FEXECUTOR,FERRORSTRATEGY,FCREATER) VALUES ({ts'2022-03-22  00:00:00'},'executePlugin',0,' ','{"scriptid":"","type":"class","value":"{\"appid\":\"fmm\",\"class\":\"kd.pmc.event.project.audit.CreateProjectServiceEvent\"}"}',1377504248090066944,' ','pmpd_project.audit','1',' ',1377506365416669184,'1',' ',{ts'2022-03-16  00:00:00'},'1','1',' ',904236026388547584,'pmpd_project.audit.project','项目.审核.项目主数据',' ',61021620,' ','retry',61021620);
DELETE FROM t_evt_subscription WHERE FID = 1377507831074258944;
INSERT INTO t_evt_subscription(FMODIFYDATE,FSERVICENUMBER,FSEQUENCE,FEXECUTORVALUE,FSERVICECONFIG,FEVENT,FERRORNOTIFY,FEVENTNUMBER,FISMODIFIED,FTIMINGSTRATEGY,FID,FISPREINSDATA,FCONDITION,FCREATEDATE,FISCONCURRENT,FSTATUS,FNOTIFYTEXT,FSERVICE,FNUMBER,FNAME,FEXPRESSION,FMODIFIER,FEXECUTOR,FERRORSTRATEGY,FCREATER) VALUES ({ts'2022-03-22  00:00:00'},'executePlugin',0,' ','{"scriptid":"","type":"class","value":"{\"appid\":\"fmm\",\"class\":\"kd.pmc.event.project.unaudit.UnAuditProjectServiceEvent\"}"}',1377504648344109056,' ','pmpd_project.unaudit','1',' ',1377507831074258944,'1',' ',{ts'2022-03-16  00:00:00'},'1','1',' ',904236026388547584,'pmpd_project.unaudit.project','项目.反审核.项目主数据',' ',61021620,' ','retry',61021620);
DELETE FROM t_evt_subscription WHERE FID = 1377507247487188992;
INSERT INTO t_evt_subscription(FMODIFYDATE,FSERVICENUMBER,FSEQUENCE,FEXECUTORVALUE,FSERVICECONFIG,FEVENT,FERRORNOTIFY,FEVENTNUMBER,FISMODIFIED,FTIMINGSTRATEGY,FID,FISPREINSDATA,FCONDITION,FCREATEDATE,FISCONCURRENT,FSTATUS,FNOTIFYTEXT,FSERVICE,FNUMBER,FNAME,FEXPRESSION,FMODIFIER,FEXECUTOR,FERRORSTRATEGY,FCREATER) VALUES ({ts'2022-03-22  00:00:00'},'executePlugin',0,' ','{"scriptid":"","type":"class","value":"{\"appid\":\"fmm\",\"class\":\"kd.pmc.event.project.unaudit.DeleteTaskCodeServiceEvent\"}"}',1377504648344109056,' ','pmpd_project.unaudit','1',' ',1377507247487188992,'1',' ',{ts'2022-03-16  00:00:00'},'1','1',' ',904236026388547584,'pmpd_project.unaudit.taskcode','项目.反审核.任务进度计划编码规则',' ',61021620,' ','retry',61021620);
DELETE FROM t_evt_subscription WHERE FID = 1377505971915456512;
INSERT INTO t_evt_subscription(FMODIFYDATE,FSERVICENUMBER,FSEQUENCE,FEXECUTORVALUE,FSERVICECONFIG,FEVENT,FERRORNOTIFY,FEVENTNUMBER,FISMODIFIED,FTIMINGSTRATEGY,FID,FISPREINSDATA,FCONDITION,FCREATEDATE,FISCONCURRENT,FSTATUS,FNOTIFYTEXT,FSERVICE,FNUMBER,FNAME,FEXPRESSION,FMODIFIER,FEXECUTOR,FERRORSTRATEGY,FCREATER) VALUES ({ts'2022-03-22  00:00:00'},'executePlugin',0,' ','{"scriptid":"","type":"class","value":"{\"appid\":\"fmm\",\"class\":\"kd.pmc.event.project.audit.CreateTaskCodeServiceEvent\"}"}',1377504248090066944,' ','pmpd_project.audit','1',' ',1377505971915456512,'1',' ',{ts'2022-03-16  00:00:00'},'1','1',' ',904236026388547584,'pmpd_project.audit.taskcode','项目.审核.任务进度计划编码规则',' ',61021620,' ','retry',61021620);
DELETE FROM t_evt_subscription WHERE FID = 1397093225994389504;
INSERT INTO t_evt_subscription(FMODIFYDATE,FSERVICENUMBER,FSEQUENCE,FEXECUTORVALUE,FSERVICECONFIG,FEVENT,FERRORNOTIFY,FEVENTNUMBER,FISMODIFIED,FTIMINGSTRATEGY,FID,FISPREINSDATA,FCONDITION,FCREATEDATE,FISCONCURRENT,FSTATUS,FNOTIFYTEXT,FSERVICE,FNUMBER,FNAME,FEXPRESSION,FMODIFIER,FEXECUTOR,FERRORSTRATEGY,FCREATER) VALUES ({ts'2022-04-12  00:00:00'},'executePlugin',0,' ','{"scriptid":"","type":"class","value":"{\"appid\":\"fmm\",\"class\":\"kd.pmc.event.project.save.BackWriteSourcePlanEvent\"}"}',1377504248090066944,' ','pmpd_project.audit','1',' ',1397093225994389504,'1','{"elementid":"","expression":"${ model.entryentity1.sourcebilltype.number == \"pmpd_resourceplan\" }","entryentity":[{"valuetype":"commVal","leftbracket":"","rightbracket":"","isHideExp":false,"id":"1397092883143591936","paramnumber":"model.entryentity1.sourcebilltype.number","logic":"&&","operation":"==","value":"pmpd_resourceplan"}],"showtext":{"zh_TW":"执行条件","en_US":"执行条件","zh_CN":"执行条件"},"property":"EventConfig","description":{"zh_TW":"","en_US":"","zh_CN":""},"validtime":null,"type":"exeConditionRule"}',{ts'2022-04-12  00:00:00'},'1','1',' ',904236026388547584,'pmpd_project.audit.executePlugin','项目.审核.检修资源计划','${ model.entryentity1.sourcebilltype.number == "pmpd_resourceplan" }',61021620,' ','retry',61021620);
DELETE FROM t_evt_subscription WHERE FID = 1397106977665977344;
INSERT INTO t_evt_subscription(FMODIFYDATE,FSERVICENUMBER,FSEQUENCE,FEXECUTORVALUE,FSERVICECONFIG,FEVENT,FERRORNOTIFY,FEVENTNUMBER,FISMODIFIED,FTIMINGSTRATEGY,FID,FISPREINSDATA,FCONDITION,FCREATEDATE,FISCONCURRENT,FSTATUS,FNOTIFYTEXT,FSERVICE,FNUMBER,FNAME,FEXPRESSION,FMODIFIER,FEXECUTOR,FERRORSTRATEGY,FCREATER) VALUES ({ts'2022-04-12  00:00:00'},'executePlugin',0,' ','{"scriptid":"","type":"class","value":"{\"appid\":\"fmm\",\"class\":\"kd.pmc.event.project.save.BackWriteSourcePlanEvent\"}"}',1377504648344109056,' ','pmpd_project.unaudit','1',' ',1397106977665977344,'1','{"elementid":"","expression":"${ model.entryentity1.sourcebilltype.number == \"pmpd_resourceplan\" }","entryentity":[{"valuetype":"commVal","leftbracket":"","rightbracket":"","isHideExp":false,"id":"1397106712795679744","paramnumber":"model.entryentity1.sourcebilltype.number","logic":"&&","operation":"==","value":"pmpd_resourceplan"}],"showtext":{"zh_TW":"执行条件","en_US":"执行条件","zh_CN":"执行条件"},"property":"EventConfig","description":{"zh_TW":"","en_US":"","zh_CN":""},"validtime":null,"type":"exeConditionRule"}',{ts'2022-04-12  00:00:00'},'1','1',' ',904236026388547584,'pmpd_project.unaudit.executePlugin','项目.反审核.检修资源计划','${ model.entryentity1.sourcebilltype.number == "pmpd_resourceplan" }',61021620,' ','retry',61021620);


DELETE FROM t_evt_subscription_l WHERE FPKID = '2A6H1FCMUIO7';
INSERT INTO t_evt_subscription_l(FID,FPKID,FLOCALEID,FNOTIFYTEXT,FNAME) VALUES (1377505971915456512,'2A6H1FCMUIO7','zh_CN',' ','项目.审核.任务进度计划编码规则');
DELETE FROM t_evt_subscription_l WHERE FPKID = '2A6H1FCMUIO8';
INSERT INTO t_evt_subscription_l(FID,FPKID,FLOCALEID,FNOTIFYTEXT,FNAME) VALUES (1377505971915456512,'2A6H1FCMUIO8','zh_TW',' ','項目.審核.任務進度計劃編碼規則');
DELETE FROM t_evt_subscription_l WHERE FPKID = '2A6H4A7/=Z13';
INSERT INTO t_evt_subscription_l(FID,FPKID,FLOCALEID,FNOTIFYTEXT,FNAME) VALUES (1377506365416669184,'2A6H4A7/=Z13','zh_CN',' ','项目.审核.项目主数据');
DELETE FROM t_evt_subscription_l WHERE FPKID = '2A6H4A7/=Z14';
INSERT INTO t_evt_subscription_l(FID,FPKID,FLOCALEID,FNOTIFYTEXT,FNAME) VALUES (1377506365416669184,'2A6H4A7/=Z14','zh_TW',' ','項目.審核.項目主數據');
DELETE FROM t_evt_subscription_l WHERE FPKID = '2A6H=QWF16ZP';
INSERT INTO t_evt_subscription_l(FID,FPKID,FLOCALEID,FNOTIFYTEXT,FNAME) VALUES (1377507247487188992,'2A6H=QWF16ZP','zh_CN',' ','项目.反审核.任务进度计划编码规则');
DELETE FROM t_evt_subscription_l WHERE FPKID = '2A6H=QWF16ZQ';
INSERT INTO t_evt_subscription_l(FID,FPKID,FLOCALEID,FNOTIFYTEXT,FNAME) VALUES (1377507247487188992,'2A6H=QWF16ZQ','zh_TW',' ','項目.反審核.任務進度計劃編碼規則');
DELETE FROM t_evt_subscription_l WHERE FPKID = '2A6HE+QMCZH3';
INSERT INTO t_evt_subscription_l(FID,FPKID,FLOCALEID,FNOTIFYTEXT,FNAME) VALUES (1377507831074258944,'2A6HE+QMCZH3','zh_CN',' ','项目.反审核.项目主数据');
DELETE FROM t_evt_subscription_l WHERE FPKID = '2A6HE+QMCZH4';
INSERT INTO t_evt_subscription_l(FID,FPKID,FLOCALEID,FNOTIFYTEXT,FNAME) VALUES (1377507831074258944,'2A6HE+QMCZH4','zh_TW',' ','項目.反審核.項目主數據');
DELETE FROM t_evt_subscription_l WHERE FPKID = '2A6Q7KRC7I4Q';
INSERT INTO t_evt_subscription_l(FID,FPKID,FLOCALEID,FNOTIFYTEXT,FNAME) VALUES (1377554982307365888,'2A6Q7KRC7I4Q','zh_CN',' ','项目.删除.执行插件');
DELETE FROM t_evt_subscription_l WHERE FPKID = '2CLD=MULQ9I6';
INSERT INTO t_evt_subscription_l(FID,FPKID,FLOCALEID,FNOTIFYTEXT,FNAME) VALUES (1397093225994389504,'2CLD=MULQ9I6','zh_TW',' ','項目.審核.檢修資源計劃');
DELETE FROM t_evt_subscription_l WHERE FPKID = '2CLDEMYHU1HD';
INSERT INTO t_evt_subscription_l(FID,FPKID,FLOCALEID,FNOTIFYTEXT,FNAME) VALUES (1397106977665977344,'2CLDEMYHU1HD','zh_CN',' ','项目.反审核.检修资源计划');
DELETE FROM t_evt_subscription_l WHERE FPKID = '2CLDEMYHU1HE';
INSERT INTO t_evt_subscription_l(FID,FPKID,FLOCALEID,FNOTIFYTEXT,FNAME) VALUES (1397106977665977344,'2CLDEMYHU1HE','zh_TW',' ','項目.反審核.檢修資源計劃');
DELETE FROM t_evt_subscription_l WHERE FPKID = '2CLAVETUVD24';
INSERT INTO t_evt_subscription_l(FID,FPKID,FLOCALEID,FNOTIFYTEXT,FNAME) VALUES (1397093225994389504,'2CLAVETUVD24','zh_CN',' ','项目.审核.检修资源计划');

