-- 样式方案
DELETE FROM t_msplan_vwscheme WHERE FID = 1452066983423047680;
INSERT INTO t_msplan_vwscheme(FMONDAY,FAUDITORID,FSHOWDATAL,FSECONDYQ,FMASTERID,FWEDNESDAY,FCREATETIME,FENABLE,FSECONDYM,FFIRSTYM,FINTERNALCOL,FSUMMARYAREA,FID,FFIRSTYQ,FSECONDHOUR,FSHOWLVLLINE,FISSYS,FASSISLINETYPE,FASSISHLINETYPE,FSATURDAY,FFRIDAY,FAREA,FSTATUS,FFIRSTYEAR,FSHOWHLINE,FNUMBER,FTHURSDAY,FSECONDYEAR,FLINETYPE,FMODIFIERID,FINTERNALROW,FMODIFYTIME,FCOLORVALUE,FAUDITTIME,FTUESDAY,FCREATORID,FPLANAREA,FSUNDAY,FTODOAREA) VALUES ('0',1,'1','0',1452066983423047680,'0',{ts'2018-08-08  00:00:00'},'1','1','0',1,'0',1452066983423047680,'0','0','1','1','1','1','1','0',' ','C','0','1','planroom_S','0','0','1',1,1,{ts'2018-08-08  00:00:00'},'#d32d03',{ts'2018-08-08  00:00:00'},'0',1,'1','1','0'); 

DELETE FROM t_msplan_vwscheme_L WHERE FPKID = '2JBPG97YB1JA';
INSERT INTO t_msplan_vwscheme_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1452066983423047680,'2JBPG97YB1JA','zh_CN','计划室占用单样式方案'); 
DELETE FROM t_msplan_vwscheme_L WHERE FPKID = '2JBPG97YB1JB';
INSERT INTO t_msplan_vwscheme_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1452066983423047680,'2JBPG97YB1JB','zh_TW','計劃室占用單樣式方案'); 

DELETE FROM t_msplan_jvwschemset WHERE FENTRYID = 1452066983473379328;
INSERT INTO t_msplan_jvwschemset(FID,FCOLWIDTH,FFONTSIZE,FCOLUMNFLAG,FALIGN,FENTRYID,FSEQ) VALUES (1452066983423047680,100.0000000000,12.0000000000,'A','center',1452066983473379328,1); 
DELETE FROM t_msplan_jvwschemset WHERE FENTRYID = 1452066983473379329;
INSERT INTO t_msplan_jvwschemset(FID,FCOLWIDTH,FFONTSIZE,FCOLUMNFLAG,FALIGN,FENTRYID,FSEQ) VALUES (1452066983423047680,100.0000000000,12.0000000000,'B','center',1452066983473379329,2); 
DELETE FROM t_msplan_jvwschemset WHERE FENTRYID = 1452066983473379330;
INSERT INTO t_msplan_jvwschemset(FID,FCOLWIDTH,FFONTSIZE,FCOLUMNFLAG,FALIGN,FENTRYID,FSEQ) VALUES (1452066983423047680,100.0000000000,12.0000000000,'C','center',1452066983473379330,3); 
DELETE FROM t_msplan_jvwschemset WHERE FENTRYID = 1452066983473379331;
INSERT INTO t_msplan_jvwschemset(FID,FCOLWIDTH,FFONTSIZE,FCOLUMNFLAG,FALIGN,FENTRYID,FSEQ) VALUES (1452066983423047680,130.0000000000,12.0000000000,'D','center',1452066983473379331,4); 
DELETE FROM t_msplan_jvwschemset WHERE FENTRYID = 1452066983473379332;
INSERT INTO t_msplan_jvwschemset(FID,FCOLWIDTH,FFONTSIZE,FCOLUMNFLAG,FALIGN,FENTRYID,FSEQ) VALUES (1452066983423047680,130.0000000000,12.0000000000,'E','center',1452066983473379332,5); 

-- 数据源配置
DELETE FROM t_msplan_jvwschcross WHERE FENTRYID = 1452066983473380354;
INSERT INTO t_msplan_jvwschcross(FID,FPOSITION,FLIMITVALUE,FHEIGHT,FLABELISSHOW,FCROSSTYPEID,FCROSSOBJ,FENTRYID,FSEQ,FCROSSSHAP,FISLINE,FCROSSCOLOR) VALUES (1452066983423047680,'3',0,'16','1',1078085411659881472,'1',1452066983473380354,1,'3','1','rgba(85, 160, 245, 1)'); 
DELETE FROM t_msplan_jvwschcross WHERE FENTRYID = 1452066983473380355;
INSERT INTO t_msplan_jvwschcross(FID,FPOSITION,FLIMITVALUE,FHEIGHT,FLABELISSHOW,FCROSSTYPEID,FCROSSOBJ,FENTRYID,FSEQ,FCROSSSHAP,FISLINE,FCROSSCOLOR) VALUES (1452066983423047680,'2',0,'16','1',1078160656248782848,'1',1452066983473380355,2,'3','0','rgba(80, 151, 156, 1)'); 
DELETE FROM t_msplan_jvwschcross WHERE FENTRYID = 1452066983473380356;
INSERT INTO t_msplan_jvwschcross(FID,FPOSITION,FLIMITVALUE,FHEIGHT,FLABELISSHOW,FCROSSTYPEID,FCROSSOBJ,FENTRYID,FSEQ,FCROSSSHAP,FISLINE,FCROSSCOLOR) VALUES (1452066983423047680,'2',0,'16','0',1078161020498919424,'1',1452066983473380356,3,'3','0','rgba(113, 173, 206, 1)'); 
DELETE FROM t_msplan_jvwschcross WHERE FENTRYID = 1452066983473380357;
INSERT INTO t_msplan_jvwschcross(FID,FPOSITION,FLIMITVALUE,FHEIGHT,FLABELISSHOW,FCROSSTYPEID,FCROSSOBJ,FENTRYID,FSEQ,FCROSSSHAP,FISLINE,FCROSSCOLOR) VALUES (1452066983423047680,'2',0,'12','0',1078161460598849536,'1',1452066983473380357,4,'3','0','rgba(161, 171, 195, 1)'); 
DELETE FROM t_msplan_jvwschcross WHERE FENTRYID = 1452066983473380358;
INSERT INTO t_msplan_jvwschcross(FID,FPOSITION,FLIMITVALUE,FHEIGHT,FLABELISSHOW,FCROSSTYPEID,FCROSSOBJ,FENTRYID,FSEQ,FCROSSSHAP,FISLINE,FCROSSCOLOR) VALUES (1452066983423047680,'2',0,'16','0',1078083769187212288,'1',1452066983473380358,5,'3','0','rgba(196, 101, 164, 1)'); 
DELETE FROM t_msplan_jvwschcross WHERE FENTRYID = 1452066983473380359;
INSERT INTO t_msplan_jvwschcross(FID,FPOSITION,FLIMITVALUE,FHEIGHT,FLABELISSHOW,FCROSSTYPEID,FCROSSOBJ,FENTRYID,FSEQ,FCROSSSHAP,FISLINE,FCROSSCOLOR) VALUES (1452066983423047680,'2',0,'20','1',0,'2',1452066983473380359,6,'2','0','rgba(199, 153, 81, 1)'); 
DELETE FROM t_msplan_jvwschcross WHERE FENTRYID = 1452066983473380360;
INSERT INTO t_msplan_jvwschcross(FID,FPOSITION,FLIMITVALUE,FHEIGHT,FLABELISSHOW,FCROSSTYPEID,FCROSSOBJ,FENTRYID,FSEQ,FCROSSSHAP,FISLINE,FCROSSCOLOR) VALUES (1452066983423047680,'2',0,'4','0',1078186295450442752,'3',1452066983473380360,7,'3','0','rgba(184, 76, 82, 1)'); 
DELETE FROM t_msplan_jvwschcross WHERE FENTRYID = 1452066983473380361;
INSERT INTO t_msplan_jvwschcross(FID,FPOSITION,FLIMITVALUE,FHEIGHT,FLABELISSHOW,FCROSSTYPEID,FCROSSOBJ,FENTRYID,FSEQ,FCROSSSHAP,FISLINE,FCROSSCOLOR) VALUES (1452066983423047680,'2',0,'20','0',0,'4',1452066983473380361,8,'3','0','rgba(128, 113, 166, 1)'); 
DELETE FROM t_msplan_jvwschcross WHERE FENTRYID = 1452066983473380362;
INSERT INTO t_msplan_jvwschcross(FID,FPOSITION,FLIMITVALUE,FHEIGHT,FLABELISSHOW,FCROSSTYPEID,FCROSSOBJ,FENTRYID,FSEQ,FCROSSSHAP,FISLINE,FCROSSCOLOR) VALUES (1452066983423047680,'2',0,'4','1',0,'5',1452066983473380362,9,'3','0','rgba(206, 206, 206, 0.75)'); 

DELETE FROM t_msplan_holiday WHERE FENTRYID = 1452066983473379333;
INSERT INTO t_msplan_holiday(FID,FENDDATERANGE,FFESTIVALNAME,FSTARTDATERANGE,FENTRYID,FSEQ,FFCOLORVALUE) VALUES (1452066983423047680,{ts'2022-05-04  00:00:00'},'2022劳动节',{ts'2022-04-30  00:00:00'},1452066983473379333,1,' '); 
DELETE FROM t_msplan_holiday WHERE FENTRYID = 1452066983473379334;
INSERT INTO t_msplan_holiday(FID,FENDDATERANGE,FFESTIVALNAME,FSTARTDATERANGE,FENTRYID,FSEQ,FFCOLORVALUE) VALUES (1452066983423047680,{ts'2022-06-05  00:00:00'},'2022端午节',{ts'2022-06-03  00:00:00'},1452066983473379334,2,' '); 
DELETE FROM t_msplan_holiday WHERE FENTRYID = 1452066983473379335;
INSERT INTO t_msplan_holiday(FID,FENDDATERANGE,FFESTIVALNAME,FSTARTDATERANGE,FENTRYID,FSEQ,FFCOLORVALUE) VALUES (1452066983423047680,{ts'2022-09-12  00:00:00'},'2022中秋节',{ts'2022-09-10  00:00:00'},1452066983473379335,3,' '); 
DELETE FROM t_msplan_holiday WHERE FENTRYID = 1452066983473379336;
INSERT INTO t_msplan_holiday(FID,FENDDATERANGE,FFESTIVALNAME,FSTARTDATERANGE,FENTRYID,FSEQ,FFCOLORVALUE) VALUES (1452066983423047680,{ts'2022-10-07  00:00:00'},'2022国庆节',{ts'2022-10-01  00:00:00'},1452066983473379336,4,' '); 

DELETE FROM t_msplan_dataline WHERE FENTRYID = 1452066983473380363;
INSERT INTO t_msplan_dataline(FID,FDATALINETYPE,FISSHOW,FLINESHAPE,FLINECOLORVALUE,FENTRYID,FSEQ,FISSHOWCURRENT,FLINECOLOR) VALUES (1452066983423047680,'1','1','1','rgba(255, 69, 0, 1)',1452066983473380363,1,'0',' '); 
DELETE FROM t_msplan_dataline WHERE FENTRYID = 1452066983473380364;
INSERT INTO t_msplan_dataline(FID,FDATALINETYPE,FISSHOW,FLINESHAPE,FLINECOLORVALUE,FENTRYID,FSEQ,FISSHOWCURRENT,FLINECOLOR) VALUES (1452066983423047680,'3','1','1','rgba(255, 69, 0, 1)',1452066983473380364,2,'0',' '); 
DELETE FROM t_msplan_dataline WHERE FENTRYID = 1452066983473380365;
INSERT INTO t_msplan_dataline(FID,FDATALINETYPE,FISSHOW,FLINESHAPE,FLINECOLORVALUE,FENTRYID,FSEQ,FISSHOWCURRENT,FLINECOLOR) VALUES (1452066983423047680,'2','1','1','rgba(144, 238, 144, 1)',1452066983473380365,3,'1',' '); 
DELETE FROM t_msplan_dataline WHERE FENTRYID = 1452066983473380366;
INSERT INTO t_msplan_dataline(FID,FDATALINETYPE,FISSHOW,FLINESHAPE,FLINECOLORVALUE,FENTRYID,FSEQ,FISSHOWCURRENT,FLINECOLOR) VALUES (1452066983423047680,'4','1','1','rgba(226, 224, 224, 1)',1452066983473380366,4,'0',' '); 


DELETE FROM t_msplan_gttsource WHERE FID = 1452051815477552128;
INSERT INTO t_msplan_gttsource(FPOSTRALATIONFLAG,FGTENTITYID,FMASTERID,FHIGHCOLORVALUE,FPOSTENTITY,FCREATETIME,FENABLE,FPRERALATIONFLAG,FTTIMEFIELD,FID,FRALATIONENTITYID,FHIGHLIGHTGROUPFLAG,FENTITYLAYOUTID,FSTATUS,FHIGHLIGHTGROUP,FNUMBER,FTASKENTITYID,FDATAMODELMUTL,FPRERALATION,FPOSTRALATION,FMODIFIERID,FPREENTITY,FMODIFYTIME,FTTIMEFIELDDESC,FPOSTRALATIONNAME,FCREATORID,FPRERALATIONNAME) VALUES (' ',' ',1452051815477552128,' ',' ',{ts'2018-08-08  00:00:00'},'1','mpdm_planroom','occstarttime',1452051815477552128,' ',' ',' ','C',' ','planroom_S','pmpd_planroomuse','0',' ',' ',1,' ',{ts'2018-08-08  00:00:00'},'单据头.占用开始时间',' ',1,'mpdm_planroom'); 

DELETE FROM t_msplan_gttsource_L WHERE FPKID = '2JBMMQM9KXM7';
INSERT INTO t_msplan_gttsource_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1452051815477552128,'2JBMMQM9KXM7','zh_CN','计划室占用单默认数据源'); 
DELETE FROM t_msplan_gttsource_L WHERE FPKID = '2JBMMQM9KXM8';
INSERT INTO t_msplan_gttsource_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1452051815477552128,'2JBMMQM9KXM8','zh_TW','計劃室占用單默認數據源'); 

DELETE FROM t_msplan_souceviewscheme WHERE FPKID = 1452067219788855296;
INSERT INTO t_msplan_souceviewscheme(FID,FBASEDATAID,FPKID) VALUES (1452051815477552128,1452066983423047680,1452067219788855296); 

DELETE FROM t_msplan_entity WHERE FENTRYID = 1452051815553049600;
INSERT INTO t_msplan_entity(FGROUPENTITYID,FFILTERTEXT,FGROUPFIELDDESC,FTASKENTITYFLAGDESC,FFILTER_TAG,FTIMEFIELDDESC,FENTITYID,FUPUPGROUPFIELD,FISMAPPINGENTITY,FSEQ,FUPUPGROUPENTITYID,FVIEWID,FTIMEFIELD,FID,FGROUPFIELD,FUPGROUPENTITYID,FVIEWALIAS,FENTRYID,FUPGROUPFIELDDESC,FGANTTTYPE,FDEFAULTVIEW,FJOINFILTER,FFILTER,FTASKENTITYFLAG,FUPGROUPFIELD,FUPUPGROUPFIELDDESC) VALUES ('mpdm_planroom',' ','单据头.计划室编码',' ',' ',' ','pmpd_planroomuse',' ','0',1,' ',1503497506330284032,' ',1452051815477552128,'planroom',' ','计划室',1452051815553049600,' ','A','0','1',' ',' ',' ',' '); 

DELETE FROM t_msplan_entity_condition WHERE FDETAILID = 1452051815553048578;
INSERT INTO t_msplan_entity_condition(FVERSIONFILED,FFIELDSORTFLAG,FDETAILID,FCENTITYID,FCFILTERTEXT,FFIELDSORT,FENTRYID,FSEQ,FCFILTER_TAG,FCFILTER) VALUES (' ',' ',1452051815553048578,'pmpd_planroomuse','单据状态 等于 已审核 ',' ',1452051815553049600,1,'{"filterRow":[{"id":"2JBMLJCFZP=+","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2JBMLJCFZPZ8","value":"C"}],"baseDataIds":[]}],"forList":false}',' '); 

DELETE FROM t_msplan_entity_relation WHERE FDETAILID = 1452051815553049601;
INSERT INTO t_msplan_entity_relation(FRENTITYID,FDETAILID,FENTRYID,FSEQ,FRENTITYFLAG,FRUPLEVELENTITYID,FRENTITYFLAGDESC,FRENTRYFLAG) VALUES ('pmpd_planroomuse',1452051815553049601,1452051815553049600,1,'planroom','mpdm_planroom','单据头.计划室编码',' '); 

DELETE FROM t_msplan_crossset WHERE FENTRYID = 1452051815553048579;
INSERT INTO t_msplan_crossset(FID,FCROSSFLAGDETAILCONTENT,FENDDATEFILED,FCROSSFLAGDETAILDESC,FCROSSFCONE,FSTARTDATEFILED,FENTRYID,FCROSSFLAGCONTENTDESC,FCROSSFLAGCONTENT,FFLAGCONNECTOR,FFLAGDETAILCONNECTOR,FISGROUPCOUNT,FCROSSTYPEID,FCROSSOBJ,FLANDMARKSFILED,FSTARTDATEFILEDDESC,FSEQ,FCROSSFCDESCONE,FCROSSENTITYID,FENDDATEFILEDDESC,FFLAGCONNECTORONE) VALUES (1452051815477552128,' ','occendtime',' ',' ','occstarttime',1452051815553048579,'单据头.单据编号','billno',' ',' ','0',1078085411659881472,'1',' ','单据头.占用开始时间',1,' ','pmpd_planroomuse','单据头.占用结束时间',' '); 

DELETE FROM t_msplan_filter WHERE FENTRYID = 1452051815561437184;
INSERT INTO t_msplan_filter(FID,FENTITYCONDFILTER,FENTITYCONDALIGNDESC,FENTITYCONDID,FENTRYID,FISUNLIMITED,FISMULTI,FENTITYCONDFILTER_TAG,FCONTROLRANGEONE,FCONTROLRANGETWO,FCONTROLRANGEFOUR,FCONTROLRANGETHREE,FSEQ,FENTITYCONDALIGN,FENTITYCONDSET) VALUES (1452051815477552128,' ','单据头.计划室编码','mpdm_planroom',1452051815561437184,'1','0','{"filterRow":[{"id":"2JBMG4JRPBMS","leftBracket":"","compareType":"105","fieldName":"status","rightBracket":"","logic":"0","value":[{"id":"2JBMG4JRPCA0","value":"C"}],"baseDataIds":[]},{"id":"2JBMG4JRPBMT","leftBracket":"","compareType":"105","fieldName":"enable","rightBracket":"","logic":"0","value":[{"id":"2JBMG4JRPCA1","value":"1"}],"baseDataIds":[]}],"forList":false}','1','0','0','0',1,'planroom','数据状态 等于 已审核 并且 使用状态 等于 可用 '); 

DELETE FROM t_msplan_filterentry WHERE FDETAILID = 1452051815561438208;
INSERT INTO t_msplan_filterentry(FDETAILID,FCHILDENTITYFLAG,FTOFILTERFLAGDESC,FTOFILTERFLAG,FENTRYID,FSEQ) VALUES (1452051815561438208,'mpdm_planroom','单据头.mpdm_planroom','mpdm_planroom',1452051815561437184,1); 


-- 实体对照数据源
DELETE FROM t_msplan_gemapping WHERE FID = 1452052565133893632;
INSERT INTO t_msplan_gemapping(FID,FCREATETIME,FMODIFIERID,FENABLE,FMODELENTITYID,FMODIFYTIME,FMASTERID,FSTATUS,FVERSIONFIELD,FCREATORID,FDATASOURCEID,FNUMBER) VALUES (1452052565133893632,{ts'2018-08-08  00:00:00'},1,'1','2JBLEG5/CKV8',{ts'2018-08-08  00:00:00'},1452052565133893632,'C',' ',1,1452051815477552128,'planroom_S'); 

DELETE FROM t_msplan_gemapping_L WHERE FPKID = '2JBMS6NX6H15';
INSERT INTO t_msplan_gemapping_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1452052565133893632,'2JBMS6NX6H15','zh_CN','计划室占用单对照数据源'); 
DELETE FROM t_msplan_gemapping_L WHERE FPKID = '2JBMS6NX6H16';
INSERT INTO t_msplan_gemapping_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1452052565133893632,'2JBMS6NX6H16','zh_TW','計劃室占用單對照數據源'); 
