-- 删除历史任务数据源中多的过滤条件
delete from t_msplan_filterentry where fentryid in(1465928705963474944,1465945646799273985);
delete  from t_msplan_filter where fentryid in(1465928705963474944,1465945646799273985);


DELETE FROM t_msplan_entity_condition WHERE FDETAILID = 1456702546717463552;
INSERT INTO t_msplan_entity_condition(FFIELDSORTFLAG,FVERSIONFILED,FDETAILID,FCENTITYID,FCFILTERTEXT,FFIELDSORT,FENTRYID,FSEQ,FCFILTER_TAG,FCFILTER) VALUES ('number','version',1456702546717463552,'pmts_wbs','版本.版本号 为 为空 ','单据头.WBS编码',1448405437132118016,2,'{"filterRow":[{"id":"2JXX9VY28T/O","leftBracket":"","compareType":"37","fieldName":"version.number","rightBracket":"","logic":"0","value":[{"id":"2JXX9VY280DD","value":""}],"baseDataIds":[]}],"forList":false}',' ');
DELETE FROM t_msplan_entity_condition WHERE FDETAILID = 1452019518892154880;
INSERT INTO t_msplan_entity_condition(FFIELDSORTFLAG,FVERSIONFILED,FDETAILID,FCENTITYID,FCFILTERTEXT,FFIELDSORT,FENTRYID,FSEQ,FCFILTER_TAG,FCFILTER) VALUES ('number','version',1452019518892154880,'pmts_wbs','版本.版本号 为 为空 ','单据头.WBS编码',1448401325246191616,2,'{"filterRow":[{"id":"2JBGK5TIHQ+1","leftBracket":"","compareType":"37","fieldName":"version.number","rightBracket":"","logic":"0","value":[{"id":"2JBGK5TIHP=T","value":""}],"baseDataIds":[]}],"forList":false}',' ');
DELETE FROM t_msplan_entity_condition WHERE FDETAILID = 1452020722128920576;
INSERT INTO t_msplan_entity_condition(FFIELDSORTFLAG,FVERSIONFILED,FDETAILID,FCENTITYID,FCFILTERTEXT,FFIELDSORT,FENTRYID,FSEQ,FCFILTER_TAG,FCFILTER) VALUES ('number','version',1452020722128920576,'pmts_wbs','版本.版本号 为 不为空 ','单据头.WBS编码',1448402326401390592,2,'{"filterRow":[{"id":"2JBGN40NZ0F9","leftBracket":"","compareType":"9","fieldName":"version.number","rightBracket":"","logic":"0","value":[{"id":"2JBGN40NZ/S/","value":""}],"baseDataIds":[]}],"forList":false}',' ');
DELETE FROM t_msplan_entity_condition WHERE FDETAILID = 1452985778320772096;
INSERT INTO t_msplan_entity_condition(FFIELDSORTFLAG,FVERSIONFILED,FDETAILID,FCENTITYID,FCFILTERTEXT,FFIELDSORT,FENTRYID,FSEQ,FCFILTER_TAG,FCFILTER) VALUES ('number','version',1452985778320772096,'pmts_wbs','版本.版本号 为 为空 ','单据头.WBS编码',1448397882938955776,2,'{"filterRow":[{"id":"2JG33WBXS40O","leftBracket":"","compareType":"37","fieldName":"version.number","rightBracket":"","logic":"0","value":[{"id":"2JG33WC/E=VG","value":""}],"baseDataIds":[]}],"forList":false}',' ');
DELETE FROM t_msplan_entity_condition WHERE FDETAILID = 1452990017596054528;
INSERT INTO t_msplan_entity_condition(FFIELDSORTFLAG,FVERSIONFILED,FDETAILID,FCENTITYID,FCFILTERTEXT,FFIELDSORT,FENTRYID,FSEQ,FCFILTER_TAG,FCFILTER) VALUES ('number','version',1452990017596054528,'pmts_wbs','版本.版本号 为 不为空 ','单据头.WBS编码',1448400037636807680,2,'{"filterRow":[{"id":"2JG3XRG9H1EX","leftBracket":"","compareType":"9","fieldName":"version.number","rightBracket":"","logic":"0","value":[{"id":"2JG3XRG9G=TM","value":""}],"baseDataIds":[]}],"forList":false}',' ');
DELETE FROM t_msplan_entity_condition WHERE FDETAILID = 1456703212437439488;
INSERT INTO t_msplan_entity_condition(FFIELDSORTFLAG,FVERSIONFILED,FDETAILID,FCENTITYID,FCFILTERTEXT,FFIELDSORT,FENTRYID,FSEQ,FCFILTER_TAG,FCFILTER) VALUES ('number','version',1456703212437439488,'pmts_wbs','版本.版本号 为 不为空 ','单据头.WBS编码',1448406769066908672,2,'{"filterRow":[{"id":"2JXXPR8AZM75","leftBracket":"","compareType":"9","fieldName":"version.number","rightBracket":"","logic":"0","value":[{"id":"2JXXPR8B+CUF","value":""}],"baseDataIds":[]}],"forList":false}',' ');
DELETE FROM t_msplan_entity_condition WHERE FDETAILID = 1456735845942877184;
INSERT INTO t_msplan_entity_condition(FFIELDSORTFLAG,FVERSIONFILED,FDETAILID,FCENTITYID,FCFILTERTEXT,FFIELDSORT,FENTRYID,FSEQ,FCFILTER_TAG,FCFILTER) VALUES ('number','version',1456735845942877184,'pmts_wbs','版本.版本号 为 为空 ','单据头.WBS编码',1448403161520871424,2,'{"filterRow":[{"id":"2JY1T0CX5EWV","leftBracket":"","compareType":"37","fieldName":"version.number","rightBracket":"","logic":"0","value":[{"id":"2JY1T0CX66I4","value":""}],"baseDataIds":[]}],"forList":false}',' ');
DELETE FROM t_msplan_entity_condition WHERE FDETAILID = 1456736646048308224;
INSERT INTO t_msplan_entity_condition(FFIELDSORTFLAG,FVERSIONFILED,FDETAILID,FCENTITYID,FCFILTERTEXT,FFIELDSORT,FENTRYID,FSEQ,FCFILTER_TAG,FCFILTER) VALUES ('number','version',1456736646048308224,'pmts_wbs','版本.版本号 为 不为空 ','单据头.WBS编码',1448404710410229760,2,'{"filterRow":[{"id":"2JY1W4Z5LBD4","leftBracket":"","compareType":"9","fieldName":"version.number","rightBracket":"","logic":"0","value":[{"id":"2JY1W4Z5M3/E","value":""}],"baseDataIds":[]}],"forList":false}',' ');
DELETE FROM t_msplan_entity_condition WHERE FDETAILID = 1448405437132119040;
INSERT INTO t_msplan_entity_condition(FFIELDSORTFLAG,FVERSIONFILED,FDETAILID,FCENTITYID,FCFILTERTEXT,FFIELDSORT,FENTRYID,FSEQ,FCFILTER_TAG,FCFILTER) VALUES ('orderno,number','version',1448405437132119040,'pmts_task','版本.版本号 为 为空 ','单据头.序号,单据头.任务编码',1448405437132118016,1,'{"filterRow":[{"id":"2IX5A0PTLGCK","leftBracket":"","compareType":"37","fieldName":"version.number","rightBracket":"","logic":"0","value":[{"id":"2IX5A0PTLFPA","value":""}],"baseDataIds":[]}],"forList":false}',' ');
DELETE FROM t_msplan_entity_condition WHERE FDETAILID = 1448397882938956800;
INSERT INTO t_msplan_entity_condition(FFIELDSORTFLAG,FVERSIONFILED,FDETAILID,FCENTITYID,FCFILTERTEXT,FFIELDSORT,FENTRYID,FSEQ,FCFILTER_TAG,FCFILTER) VALUES ('orderno,number','version',1448397882938956800,'pmts_task','版本.版本号 为 为空 ','单据头.序号,单据头.任务编码',1448397882938955776,1,'{"filterRow":[{"id":"2IX3VPJV2A=9","leftBracket":"","compareType":"37","fieldName":"version.number","rightBracket":"","logic":"0","value":[{"id":"2IX3VPJV2=M/","value":""}],"baseDataIds":[]}],"forList":false}',' ');
DELETE FROM t_msplan_entity_condition WHERE FDETAILID = 1448400037636806656;
INSERT INTO t_msplan_entity_condition(FFIELDSORTFLAG,FVERSIONFILED,FDETAILID,FCENTITYID,FCFILTERTEXT,FFIELDSORT,FENTRYID,FSEQ,FCFILTER_TAG,FCFILTER) VALUES ('orderno,number','version',1448400037636806656,'pmts_task','版本.版本号 为 不为空 ','单据头.序号,单据头.任务编码',1448400037636807680,1,'{"filterRow":[{"id":"2IX46Q8CFAHP","leftBracket":"","compareType":"9","fieldName":"version.number","rightBracket":"","logic":"0","value":[{"id":"2IX46Q8CFB5Z","value":""}],"baseDataIds":[]}],"forList":false}',' ');
DELETE FROM t_msplan_entity_condition WHERE FDETAILID = 1448401325246192640;
INSERT INTO t_msplan_entity_condition(FFIELDSORTFLAG,FVERSIONFILED,FDETAILID,FCENTITYID,FCFILTERTEXT,FFIELDSORT,FENTRYID,FSEQ,FCFILTER_TAG,FCFILTER) VALUES ('orderno,number','version',1448401325246192640,'pmts_task','版本.版本号 为 为空 ','单据头.序号,单据头.任务编码',1448401325246191616,1,'{"filterRow":[{"id":"2IX4FG9+876L","leftBracket":"","compareType":"37","fieldName":"version.number","rightBracket":"","logic":"0","value":[{"id":"2IX4FG9+86IB","value":""}],"baseDataIds":[]}],"forList":false}',' ');
DELETE FROM t_msplan_entity_condition WHERE FDETAILID = 1448402326401391616;
INSERT INTO t_msplan_entity_condition(FFIELDSORTFLAG,FVERSIONFILED,FDETAILID,FCENTITYID,FCFILTERTEXT,FFIELDSORT,FENTRYID,FSEQ,FCFILTER_TAG,FCFILTER) VALUES ('orderno,number','version',1448402326401391616,'pmts_task','版本.版本号 为 不为空 ','单据头.序号,单据头.任务编码',1448402326401390592,1,'{"filterRow":[{"id":"2IX4NEK+WQV3","leftBracket":"","compareType":"9","fieldName":"version.number","rightBracket":"","logic":"0","value":[{"id":"2IX4NEK+WRIC","value":""}],"baseDataIds":[]}],"forList":false}',' ');
DELETE FROM t_msplan_entity_condition WHERE FDETAILID = 1448403161520872448;
INSERT INTO t_msplan_entity_condition(FFIELDSORTFLAG,FVERSIONFILED,FDETAILID,FCENTITYID,FCFILTERTEXT,FFIELDSORT,FENTRYID,FSEQ,FCFILTER_TAG,FCFILTER) VALUES ('orderno,number','version',1448403161520872448,'pmts_task','版本.版本号 为 为空 ','单据头.序号,单据头.任务编码',1448403161520871424,1,'{"filterRow":[{"id":"2IX4TJ=X33X9","leftBracket":"","compareType":"37","fieldName":"version.number","rightBracket":"","logic":"0","value":[{"id":"2IX4TJ=X338/","value":""}],"baseDataIds":[]}],"forList":false}',' ');
DELETE FROM t_msplan_entity_condition WHERE FDETAILID = 1448404710410230784;
INSERT INTO t_msplan_entity_condition(FFIELDSORTFLAG,FVERSIONFILED,FDETAILID,FCENTITYID,FCFILTERTEXT,FFIELDSORT,FENTRYID,FSEQ,FCFILTER_TAG,FCFILTER) VALUES ('orderno,number','version',1448404710410230784,'pmts_task','版本.版本号 为 不为空 ','单据头.序号,单据头.任务编码',1448404710410229760,1,'{"filterRow":[{"id":"2IX4ZIBZLUNK","leftBracket":"","compareType":"9","fieldName":"version.number","rightBracket":"","logic":"0","value":[{"id":"2IX4ZIBZLU+A","value":""}],"baseDataIds":[]}],"forList":false}',' ');
DELETE FROM t_msplan_entity_condition WHERE FDETAILID = 1448406769066907648;
INSERT INTO t_msplan_entity_condition(FFIELDSORTFLAG,FVERSIONFILED,FDETAILID,FCENTITYID,FCFILTERTEXT,FFIELDSORT,FENTRYID,FSEQ,FCFILTER_TAG,FCFILTER) VALUES ('orderno,number','version',1448406769066907648,'pmts_task','版本.版本号 为 不为空 ','单据头.序号,单据头.任务编码',1448406769066908672,1,'{"filterRow":[{"id":"2J32GUL4HTY2","leftBracket":"","compareType":"9","fieldName":"version.number","rightBracket":"","logic":"0","value":[{"id":"2J32GUL4H1=T","value":""}],"baseDataIds":[]}],"forList":false}',' ');


DELETE FROM t_msplan_filter WHERE FENTRYID = 1505655050989511680;
INSERT INTO t_msplan_filter(FENTITYCONDFILTER,FID,FENTITYCONDALIGNDESC,FENTITYCONDID,FENTRYID,FISUNLIMITED,FISMULTI,FENTITYCONDFILTER_TAG,FCONTROLRANGEONE,FCONTROLRANGETWO,FCONTROLRANGEFOUR,FCONTROLRANGETHREE,FSEQ,FENTITYCONDALIGN,FENTITYCONDSET) VALUES (' ',1423370724491428864,'单据头.区域','fmm_area',1505655050989511680,'1','1','{"filterRow":[{"id":"2PYG+FOJJ1X2","leftBracket":"","compareType":"105","fieldName":"status","rightBracket":"","logic":"0","value":[{"id":"2PYG+FOJJ2KB","value":"C"}],"baseDataIds":[]}],"forList":false}','1','0','0','0',5,'area','数据状态 等于 已审核 ');
DELETE FROM t_msplan_filter WHERE FENTRYID = 1505655050989511681;
INSERT INTO t_msplan_filter(FENTITYCONDFILTER,FID,FENTITYCONDALIGNDESC,FENTITYCONDID,FENTRYID,FISUNLIMITED,FISMULTI,FENTITYCONDFILTER_TAG,FCONTROLRANGEONE,FCONTROLRANGETWO,FCONTROLRANGEFOUR,FCONTROLRANGETHREE,FSEQ,FENTITYCONDALIGN,FENTITYCONDSET) VALUES (' ',1423370724491428864,'单据头.区域属性','fmm_areaproperty',1505655050989511681,'1','1','{"filterRow":[{"id":"2PYG3L+WDACB","leftBracket":"","compareType":"105","fieldName":"status","rightBracket":"","logic":"0","value":[{"id":"2PYG3L+WDB0L","value":"C"}],"baseDataIds":[]}],"forList":false}','1','0','0','0',6,'areaproperty','数据状态 等于 已审核 ');
DELETE FROM t_msplan_filter WHERE FENTRYID = 1505676408679079936;
INSERT INTO t_msplan_filter(FENTITYCONDFILTER,FID,FENTITYCONDALIGNDESC,FENTITYCONDID,FENTRYID,FISUNLIMITED,FISMULTI,FENTITYCONDFILTER_TAG,FCONTROLRANGEONE,FCONTROLRANGETWO,FCONTROLRANGEFOUR,FCONTROLRANGETHREE,FSEQ,FENTITYCONDALIGN,FENTITYCONDSET) VALUES (' ',1438494107356890112,'单据头.区域','fmm_area',1505676408679079936,'1','0','{"filterRow":[{"id":"2PYJ40QN9SRT","leftBracket":"","compareType":"105","fieldName":"status","rightBracket":"","logic":"0","value":[{"id":"2PYJ40QN9S2J","value":"C"}],"baseDataIds":[]}],"forList":false}','1','0','0','0',5,'area','数据状态 等于 已审核 ');
DELETE FROM t_msplan_filter WHERE FENTRYID = 1505676408679079937;
INSERT INTO t_msplan_filter(FENTITYCONDFILTER,FID,FENTITYCONDALIGNDESC,FENTITYCONDID,FENTRYID,FISUNLIMITED,FISMULTI,FENTITYCONDFILTER_TAG,FCONTROLRANGEONE,FCONTROLRANGETWO,FCONTROLRANGEFOUR,FCONTROLRANGETHREE,FSEQ,FENTITYCONDALIGN,FENTITYCONDSET) VALUES (' ',1438494107356890112,'单据头.区域属性','fmm_areaproperty',1505676408679079937,'1','0','{"filterRow":[{"id":"2PYJ4PDIHCHA","leftBracket":"","compareType":"105","fieldName":"status","rightBracket":"","logic":"0","value":[{"id":"2PYJ4PDIHBU1","value":"C"}],"baseDataIds":[]}],"forList":false}','1','0','0','0',6,'areaproperty','数据状态 等于 已审核 ');
