-- 项目计划进度默认数据源 数据实体子分录
DELETE FROM t_msplan_entity_condition WHERE FDETAILID = 1413599016796591104;
INSERT INTO t_msplan_entity_condition(FFIELDSORTFLAG,FDETAILID,FCENTITYID,FCFILTERTEXT,FFIELDSORT,FENTRYID,FSEQ,FCFILTER_TAG,FCFILTER) VALUES ('number',1413599016796591104,'pmts_task','版本.版本号 为 为空 ','单据头.任务编码',1406532931173757952,1,'{"filterRow":[{"id":"2FBB78B3BJZ+","leftBracket":"","compareType":"37","fieldName":"version.number","rightBracket":"","logic":"0","value":[{"id":"2FBB78B6ZLAV","value":""}],"baseDataIds":[]}],"forList":false}',' ');

-- 项目计划进度默认数据源 横道设置
DELETE FROM t_msplan_crossset WHERE FENTRYID = 1417951510943240192;
INSERT INTO t_msplan_crossset(FCROSSFLAGDETAILCONTENT,FID,FENDDATEFILED,FSTARTDATEFILED,FENTRYID,FCROSSFLAGCONTENT,FFLAGCONNECTOR,FFLAGDETAILCONNECTOR,FISGROUPCOUNT,FCROSSTYPEID,FCROSSOBJ,FLANDMARKSFILED,FSEQ,FCROSSENTITYID) VALUES (' ',1406532930871768064,'planenddate','planstartdate',1417951510943240192,' ',' ',' ','0',0,'2',' ',4,'pmts_task');
DELETE FROM t_msplan_crossset WHERE FENTRYID = 1423789813575724032;
INSERT INTO t_msplan_crossset(FCROSSFLAGDETAILCONTENT,FID,FENDDATEFILED,FSTARTDATEFILED,FENTRYID,FCROSSFLAGCONTENT,FFLAGCONNECTOR,FFLAGDETAILCONNECTOR,FISGROUPCOUNT,FCROSSTYPEID,FCROSSOBJ,FLANDMARKSFILED,FSEQ,FCROSSENTITYID) VALUES (' ',1406532930871768064,'bsenddate','bsstartdate',1423789813575724032,' ',' ',' ','0',1078161460598849536,'1',' ',5,'pmts_task');

-- 项目计划进度默认数据源 数据过滤设置
DELETE FROM t_msplan_filter WHERE FENTRYID = 1423745801896606720;
INSERT INTO t_msplan_filter(FENTITYCONDFILTER,FID,FENTITYCONDID,FENTRYID,FSEQ,FISUNLIMITED,FISMULTI,FENTITYCONDALIGN,FENTITYCONDFILTER_TAG,FENTITYCONDSET) VALUES (' ',1406532930871768064,'fmm_plantype',1423745801896606720,2,'1','0','plantype','{"filterRow":[{"id":"2FW/RZZ615W/","leftBracket":"","compareType":"105","fieldName":"status","rightBracket":"","logic":"0","value":[{"id":"2FW/RZZC=MFD","value":"C"}],"baseDataIds":[]}],"forList":false}','数据状态 等于 已审核 ');



--项目进度任务历史版本数据源
DELETE FROM t_msplan_gttsource WHERE FID = 1419530514422837248;
INSERT INTO t_msplan_gttsource(FID,FRALATIONENTITYID,FHIGHLIGHTGROUPFLAG,FPOSTRALATIONFLAG,FGTENTITYID,FENTITYLAYOUTID,FMASTERID,FSTATUS,FHIGHLIGHTGROUP,FHIGHCOLORVALUE,FNUMBER,FDATAMODELMUTL,FPRERALATION,FPOSTENTITY,FPOSTRALATION,FCREATETIME,FMODIFIERID,FENABLE,FPREENTITY,FMODIFYTIME,FPRERALATIONFLAG,FPOSTRALATIONNAME,FCREATORID,FPRERALATIONNAME) VALUES (1419530514422837248,'pmts_task','status','postpositiontaskentry',' ',' ',1419530514422837248,'C',' ',' ','taskplanhistory_S','0','taskrelation','postpositiontask','taskrelationtwo',{ts'2022-05-13  00:00:00'},1,'1','prepositiontask',{ts'2022-05-19  00:00:00'},'prepositiontaskentry','后置作业关系',1,'前置作业关系');

DELETE FROM t_msplan_gttsource_l WHERE FPKID = '2FBU5K6QJD+6';
INSERT INTO t_msplan_gttsource_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1419530514422837248,'2FBU5K6QJD+6','zh_CN','项目进度任务历史版本数据源');
DELETE FROM t_msplan_gttsource_l WHERE FPKID = '2FBU5K6QJD+7';
INSERT INTO t_msplan_gttsource_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1419530514422837248,'2FBU5K6QJD+7','zh_TW','項目進度任務曆史版本數據源');



-- 项目进度任务历史版本数据源 数据实体
DELETE FROM t_msplan_entity WHERE FENTRYID = 1419530514523500544;
INSERT INTO t_msplan_entity(FGROUPFIELD,FUPGROUPENTITYID,FID,FGROUPENTITYID,FFILTERTEXT,FENTRYID,FGANTTTYPE,FFILTER_TAG,FJOINFILTER,FFILTER,FENTITYID,FUPUPGROUPFIELD,FISMAPPINGENTITY,FSEQ,FUPUPGROUPENTITYID,FUPGROUPFIELD,FTIMEFIELD) VALUES ('wbs',' ',1419530514422837248,'pmts_wbs',' ',1419530514523500544,'B',' ','1',' ','pmts_task',' ','1',1,' ',' ','createtime');

DELETE FROM t_msplan_entity_condition WHERE FDETAILID = 1419530514523523074;
INSERT INTO t_msplan_entity_condition(FFIELDSORTFLAG,FDETAILID,FCENTITYID,FCFILTERTEXT,FFIELDSORT,FENTRYID,FSEQ,FCFILTER_TAG,FCFILTER) VALUES ('number',1419530514523523074,'pmts_task','版本.版本号 为 不为空 ','单据头.任务编码',1419530514523500544,1,'{"filterRow":[{"id":"2FBU5DDYLXBO","leftBracket":"","compareType":"9","fieldName":"version.number","rightBracket":"","logic":"0","value":[{"id":"2FBU5DDYLIJ0","value":""}],"baseDataIds":[]}],"forList":false}',' ');

-- 项目进度任务历史版本数据源 字段设置
DELETE FROM t_msplan_fentryety WHERE FENTRYID = 1419530514523523075;
INSERT INTO t_msplan_fentryety(FID,FENTRYFIELDALIGN,FENTRYFIELDFLAG,FENTRYID,FSEQ,FENTRYFIELDNAME,FENTRYENTITYNAME) VALUES (1419530514422837248,'任务编码','number',1419530514523523075,1,'单据头.任务编码','pmts_task');
DELETE FROM t_msplan_fentryety WHERE FENTRYID = 1419530514523523076;
INSERT INTO t_msplan_fentryety(FID,FENTRYFIELDALIGN,FENTRYFIELDFLAG,FENTRYID,FSEQ,FENTRYFIELDNAME,FENTRYENTITYNAME) VALUES (1419530514422837248,'任务名称','name',1419530514523523076,2,'单据头.任务名称','pmts_task');
DELETE FROM t_msplan_fentryety WHERE FENTRYID = 1419530514523523077;
INSERT INTO t_msplan_fentryety(FID,FENTRYFIELDALIGN,FENTRYFIELDFLAG,FENTRYID,FSEQ,FENTRYFIELDNAME,FENTRYENTITYNAME) VALUES (1419530514422837248,'计划工期','plantime',1419530514523523077,3,'单据头.计划工期','pmts_task');
DELETE FROM t_msplan_fentryety WHERE FENTRYID = 1419530514523523078;
INSERT INTO t_msplan_fentryety(FID,FENTRYFIELDALIGN,FENTRYFIELDFLAG,FENTRYID,FSEQ,FENTRYFIELDNAME,FENTRYENTITYNAME) VALUES (1419530514422837248,'计划开始时间','planstartdate',1419530514523523078,4,'单据头.计划开始时间','pmts_task');
DELETE FROM t_msplan_fentryety WHERE FENTRYID = 1419530514523523079;
INSERT INTO t_msplan_fentryety(FID,FENTRYFIELDALIGN,FENTRYFIELDFLAG,FENTRYID,FSEQ,FENTRYFIELDNAME,FENTRYENTITYNAME) VALUES (1419530514422837248,'计划完成时间','planenddate',1419530514523523079,5,'单据头.计划完成时间','pmts_task');


-- 项目进度任务历史版本数据源 横道设置
DELETE FROM t_msplan_crossset WHERE FENTRYID = 1419530514523500545;
INSERT INTO t_msplan_crossset(FCROSSFLAGDETAILCONTENT,FID,FENDDATEFILED,FSTARTDATEFILED,FENTRYID,FCROSSFLAGCONTENT,FFLAGCONNECTOR,FFLAGDETAILCONNECTOR,FISGROUPCOUNT,FCROSSTYPEID,FCROSSOBJ,FLANDMARKSFILED,FSEQ,FCROSSENTITYID) VALUES ('planstartdate,planenddate',1419530514422837248,'planenddate','planstartdate',1419530514523500545,'number,name,responsperson.name','-','~','0',1078085411659881472,'1',' ',1,'pmts_task');
DELETE FROM t_msplan_crossset WHERE FENTRYID = 1419530514523500546;
INSERT INTO t_msplan_crossset(FCROSSFLAGDETAILCONTENT,FID,FENDDATEFILED,FSTARTDATEFILED,FENTRYID,FCROSSFLAGCONTENT,FFLAGCONNECTOR,FFLAGDETAILCONNECTOR,FISGROUPCOUNT,FCROSSTYPEID,FCROSSOBJ,FLANDMARKSFILED,FSEQ,FCROSSENTITYID) VALUES (' ',1419530514422837248,'actualenddate','actualstartdate',1419530514523500546,' ',' ',' ','0',1078160656248782848,'1',' ',2,'pmts_task');
DELETE FROM t_msplan_crossset WHERE FENTRYID = 1419530514523500547;
INSERT INTO t_msplan_crossset(FCROSSFLAGDETAILCONTENT,FID,FENDDATEFILED,FSTARTDATEFILED,FENTRYID,FCROSSFLAGCONTENT,FFLAGCONNECTOR,FFLAGDETAILCONNECTOR,FISGROUPCOUNT,FCROSSTYPEID,FCROSSOBJ,FLANDMARKSFILED,FSEQ,FCROSSENTITYID) VALUES (' ',1419530514422837248,'nlastenddate','nfirststartdate',1419530514523500547,' ',' ',' ','0',1078161020498919424,'1',' ',3,'pmts_task');
DELETE FROM t_msplan_crossset WHERE FENTRYID = 1419530514523500548;
INSERT INTO t_msplan_crossset(FCROSSFLAGDETAILCONTENT,FID,FENDDATEFILED,FSTARTDATEFILED,FENTRYID,FCROSSFLAGCONTENT,FFLAGCONNECTOR,FFLAGDETAILCONNECTOR,FISGROUPCOUNT,FCROSSTYPEID,FCROSSOBJ,FLANDMARKSFILED,FSEQ,FCROSSENTITYID) VALUES (' ',1419530514422837248,'planenddate','planstartdate',1419530514523500548,' ',' ',' ','0',0,'2',' ',4,'pmts_task');
DELETE FROM t_msplan_crossset WHERE FENTRYID = 1424613941840986112;
INSERT INTO t_msplan_crossset(FCROSSFLAGDETAILCONTENT,FID,FENDDATEFILED,FSTARTDATEFILED,FENTRYID,FCROSSFLAGCONTENT,FFLAGCONNECTOR,FFLAGDETAILCONNECTOR,FISGROUPCOUNT,FCROSSTYPEID,FCROSSOBJ,FLANDMARKSFILED,FSEQ,FCROSSENTITYID) VALUES (' ',1419530514422837248,'bsenddate','bsstartdate',1424613941840986112,' ',' ',' ','0',1078161460598849536,'1',' ',5,'pmts_task');

-- 项目进度任务历史版本数据源 数据过滤设置
DELETE FROM t_msplan_filter WHERE FENTRYID = 1419530514523500559;
INSERT INTO t_msplan_filter(FENTITYCONDFILTER,FID,FENTITYCONDID,FENTRYID,FSEQ,FISUNLIMITED,FISMULTI,FENTITYCONDALIGN,FENTITYCONDFILTER_TAG,FENTITYCONDSET) VALUES (' ',1419530514422837248,'pmpd_project',1419530514523500559,1,'0','0','projectnum','{"filterRow":[{"id":"2DK=7D6Q0L7B","leftBracket":"","compareType":"105","fieldName":"status","rightBracket":"","logic":"0","value":[{"id":"2DK=7D6TO023","value":"C"}],"baseDataIds":[]}],"forList":false}','数据状态 等于 已审核 ');
DELETE FROM t_msplan_filter WHERE FENTRYID = 1423885144376224768;
INSERT INTO t_msplan_filter(FENTITYCONDFILTER,FID,FENTITYCONDID,FENTRYID,FSEQ,FISUNLIMITED,FISMULTI,FENTITYCONDALIGN,FENTITYCONDFILTER_TAG,FENTITYCONDSET) VALUES (' ',1419530514422837248,'mpdm_gantt_version_task',1423885144376224768,2,'0','0','version','{"filterRow":[{"id":"2FWORK3CYTB0","leftBracket":"","compareType":"105","fieldName":"status","rightBracket":"","logic":"0","value":[{"id":"2FWORK3GJUPX","value":"C"}],"baseDataIds":[]}],"forList":false}','数据状态 等于 已审核 ');

DELETE FROM t_msplan_filterentry WHERE FDETAILID = 1419530514523523081;
INSERT INTO t_msplan_filterentry(FDETAILID,FCHILDENTITYFLAG,FTOFILTERFLAG,FENTRYID,FSEQ) VALUES (1419530514523523081,'pmts_wbs','projectnum',1419530514523500559,1);

-- 项目进度任务历史版本数据源 横道颜色设置
DELETE FROM t_msplan_person_color WHERE FENTRYID = 1419530514523523082;
INSERT INTO t_msplan_person_color(FID,FENTRYID,FSEQ,FCOLORCONDFILTER,FCOLORVALUE,FCOLORCONDITON,FCOLORCONDFILTER_TAG) VALUES (1419530514422837248,1419530514523523082,1,' ','rgba(199, 21, 133, 1)','计划状态 等于 下达 ','{"filterRow":[{"id":"2DRS49J0GYPH","leftBracket":"","compareType":"105","fieldName":"taskstatus","rightBracket":"","logic":"0","value":[{"id":"2DRS49J0GY08","value":"3"}],"baseDataIds":[]}],"forList":false}');
DELETE FROM t_msplan_person_color WHERE FENTRYID = 1419530514523523083;
INSERT INTO t_msplan_person_color(FID,FENTRYID,FSEQ,FCOLORCONDFILTER,FCOLORVALUE,FCOLORCONDITON,FCOLORCONDFILTER_TAG) VALUES (1419530514422837248,1419530514523523083,2,' ','rgba(187, 187, 187, 1)','计划状态 等于 关闭 ','{"filterRow":[{"id":"2DRS5L+BLFLN","leftBracket":"","compareType":"105","fieldName":"taskstatus","rightBracket":"","logic":"0","value":[{"id":"2DRS5L+BLEYD","value":"4"}],"baseDataIds":[]}],"forList":false}');
DELETE FROM t_msplan_person_color WHERE FENTRYID = 1419530514523523084;
INSERT INTO t_msplan_person_color(FID,FENTRYID,FSEQ,FCOLORCONDFILTER,FCOLORVALUE,FCOLORCONDITON,FCOLORCONDFILTER_TAG) VALUES (1419530514422837248,1419530514523523084,3,' ','rgba(25, 190, 107, 1)','执行状态 等于 进行中 ','{"filterRow":[{"id":"2DRS85/S2WBC","leftBracket":"","compareType":"105","fieldName":"executestatus","rightBracket":"","logic":"0","value":[{"id":"2DRS85/S2X/M","value":"2"}],"baseDataIds":[]}],"forList":false}');
DELETE FROM t_msplan_person_color WHERE FENTRYID = 1419530514523523085;
INSERT INTO t_msplan_person_color(FID,FENTRYID,FSEQ,FCOLORCONDFILTER,FCOLORVALUE,FCOLORCONDITON,FCOLORCONDFILTER_TAG) VALUES (1419530514422837248,1419530514523523085,4,' ','rgba(0, 206, 209, 1)','执行状态 等于 暂停 ','{"filterRow":[{"id":"2DRS9E5XV86+","leftBracket":"","compareType":"105","fieldName":"executestatus","rightBracket":"","logic":"0","value":[{"id":"2DRS9E5XV7HQ","value":"3"}],"baseDataIds":[]}],"forList":false}');
DELETE FROM t_msplan_person_color WHERE FENTRYID = 1419530514523523086;
INSERT INTO t_msplan_person_color(FID,FENTRYID,FSEQ,FCOLORCONDFILTER,FCOLORVALUE,FCOLORCONDITON,FCOLORCONDFILTER_TAG) VALUES (1419530514422837248,1419530514523523086,5,' ','rgba(255, 215, 0, 1)','执行状态 等于 已完成 ','{"filterRow":[{"id":"2DRS=STDE1IW","leftBracket":"","compareType":"105","fieldName":"executestatus","rightBracket":"","logic":"0","value":[{"id":"2DRS=STDE0VM","value":"4"}],"baseDataIds":[]}],"forList":false}');










