| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930 |
- {
- "ID_KEY": "DUMMY_FLOW_SAMPLE",
- "GROUP_KEY": "RPT_B23.1 工程台帐分表一_SAMPLE_TPL",
- "主信息": {
- "单位": "厘米",
- "版本": {
- "主版本": "3",
- "功能版本": "0"
- },
- "页边距": {
- "Top": "1.0",
- "Left": "1.0",
- "Right": "1.0",
- "Bottom": "1.0"
- },
- "报表名称": "B23.1 工程台帐分表一",
- "打印页面_信息": {
- "方向": "LANDSCAPE",
- "页规格": "A4"
- }
- },
- "布局框_集合": [
- {
- "Alignment": "Top",
- "DisplayType": "EveryPage",
- "Height": "1.6",
- "Name": "TitleBand",
- "control": "Default",
- "style": "Default_None",
- "MergeBorder": "F"
- },
- {
- "Alignment": "Top",
- "DisplayType": "EveryPage",
- "Height": "1.2",
- "Name": "HeaderBand",
- "control": "Default",
- "style": "Default_None",
- "MergeBorder": "F"
- },
- {
- "Alignment": "Bottom",
- "DisplayType": "EveryPage",
- "Height": "0.6",
- "Name": "FooterBand",
- "control": "Default",
- "style": "Default_None",
- "MergeBorder": "F"
- },
- {
- "Alignment": "Fulfill",
- "DisplayType": "EveryPage",
- "Name": "Report Body",
- "control": "Default",
- "style": "BORDER_ALL_AROUND",
- "MergeBorder": "T",
- "band_s": [
- {
- "Alignment": "Top",
- "DisplayType": "EveryPage",
- "Height": "4.71",
- "Name": "ColumnBand",
- "control": "Default",
- "style": "Default_None",
- "MergeBorder": "F"
- },
- {
- "Alignment": "Bottom",
- "DisplayType": "SegmentEnd",
- "Height": "0.9",
- "Name": "ChapterBand",
- "control": "Default",
- "style": "Default_None",
- "MergeBorder": "F"
- },
- {
- "Alignment": "Fulfill",
- "DisplayType": "EveryPage",
- "Name": "ContentBand",
- "control": "Default",
- "style": "Default_None",
- "MergeBorder": "F"
- }
- ]
- }
- ],
- "计算式_集合": [
- {
- "Name": "获取打印时间",
- "run_type": "before_paging",
- "expression": "let rpt = $JE.P(5001,$CURRENT_RPT);\n let dt = new Date();\n rpt.Default_Value = dt.Format($ME.format);\n rpt = null;",
- "format": "yyyy 年 M 月 dd 日"
- },
- {
- "Name": "获取当前页",
- "run_type": "before_output",
- "expression": "let ttp = $JE.P(5010,$CURRENT_RPT);\n ttp.Default_Value = $ME.format.replace('($S)',$JE.getCurrentPage($CURRENT_RPT));\n ttp = null;",
- "format": "第 ($S) 页"
- },
- {
- "Name": "获取总页数",
- "run_type": "before_output",
- "expression": "let ttp = $JE.P(5011,$CURRENT_RPT);\n ttp.Default_Value = $ME.format.replace('($S)',$JE.getTotalPage($CURRENT_RPT));\n ttp = null;",
- "format": "共 ($S) 页"
- },
- {
- "Name": "处理主从关系",
- "run_type": "before_analyzing",
- "expression": "\n//标段属性章节数据\nlet chapterAllNo=$JE.F(1132,$CURRENT_RPT);\nlet chapterAllName=$JE.F(1133,$CURRENT_RPT);\nlet AllNoArray = $JE.getFieldValue(chapterAllNo, $CURRENT_DATA, 0, 0);\n//console.log(AllNoArray.length);\nlet AllNameArray = $JE.getFieldValue(chapterAllName, $CURRENT_DATA, 0, 0);\n//主数据章节、名称指标\nlet chaMasterNo=$JE.F(1199,$CURRENT_RPT);\nlet chaMasteName=$JE.F(1099,$CURRENT_RPT);\n\n//获取从数据章节\nlet chapterCNo=$JE.F(2552,$CURRENT_RPT);\nlet chapterBCode=$JE.F(2510,$CURRENT_RPT);\nlet chapterBCodeArr=$JE.getFieldValueArray(chapterBCode,$CURRENT_DATA);\nlet fLen1=$JE.getFieldDataLen(chapterBCode, $CURRENT_DATA);\n\n//处理原始列表(从数据)中章节编号为空的\nfor(let i=0;i<fLen1;i++){\n\t//非标准清单章节号都为空,要特殊处理\n\tlet chapterCode=$CTX_HELPER.getChapterCode(chapterBCodeArr[i], '-');\n\t//console.log('清单编号:%s,章节号:%s',chapterCode,chapterCode);\n\tlet orgChapterCode = $JE.getFieldValue(chapterCNo, $CURRENT_DATA, i, '');\n\t//拼接签约清单后,签约清单的章节为空,所以需要赋值\n\tif(orgChapterCode===null || orgChapterCode==='' || orgChapterCode==10000){\n\t\tif(chapterCode===null || chapterCode==='' || chapterCode==10000){\n\t\t\t//console.log('我是未计入章节');\n\t\t\t$JE.setFieldValue(chapterCNo, $CURRENT_DATA, i, '其他');\n\t\t}else{\n\t\t\t//console.log('我是签约清单');\n\t\t\t$JE.setFieldValue(chapterCNo, $CURRENT_DATA, i, chapterCode);\n\t\t}\t\t\n\t}\t\n}\n\nlet chapterNoArr=$JE.getFieldValueArray(chapterCNo,$CURRENT_DATA);\n\n//去重方法\nfunction unique(arr) {\n if (!Array.isArray(arr)) {\n console.log('type error!')\n return\n }\n var array = [];\n for (var i = 0; i < arr.length; i++) {\n if (array .indexOf(arr[i]) === -1) {\n array .push(arr[i])\n }\n }\n return array;\n}\n//去重后的章节数组\nlet uniqueChapArr=unique(chapterNoArr);\n//console.log(uniqueChapArr);\n\n//配置主数据\nfor(let i=0; i<uniqueChapArr.length;i++){\n\tfor(let j=0; j< AllNoArray.length;j++){\n\t\tlet tempno=AllNoArray[j];\t\t\n\t\tlet tempname=AllNameArray[j];\t\n\t\tif(uniqueChapArr[i]==tempno){\n\t\t\t//console.log('章节:%s 名称:%s',tempno,tempname);\n\t\t\t$JE.setFieldValue(chaMasterNo, $CURRENT_DATA, i, tempno);\n\t\t\t$JE.setFieldValue(chaMasteName, $CURRENT_DATA, i, tempname);\n\t\t\tbreak;\n\t\t}\n\t}\n\tif(uniqueChapArr[i]==='其他'){\n\t\t$JE.setFieldValue(chaMasterNo, $CURRENT_DATA, i,uniqueChapArr[i] );\n\t\t$JE.setFieldValue(chaMasteName, $CURRENT_DATA, i, '未计入章节清单项');\n\t}\n\n}\n\n//设置标题\nlet tLen0=$JE.getFieldDataLen(chaMasterNo, $CURRENT_DATA);\nlet newTitle=$JE.F(1145,$CURRENT_RPT);\nlet newSumName=$JE.F(12153,$CURRENT_RPT);\nfor(let k=0;k<tLen0;k++){\n\tlet tno=$JE.getFieldValue(chaMasterNo, $CURRENT_DATA, k, '');\n\tlet tname=$JE.getFieldValue(chaMasteName, $CURRENT_DATA, k, '');\n\tlet mergeTitle=tno+'章 ' +tname;\n\t$JE.setFieldValue(newTitle, $CURRENT_DATA, k, mergeTitle);\n $JE.setFieldValue(newSumName, $CURRENT_DATA, k, tno+'章金额小计');\n}\n\nlet cLen=$JE.getFieldDataLen(newSumName, $CURRENT_DATA);\nfor(let k=0;k<cLen;k++){\n\tlet cno=$JE.getFieldValue(newSumName, $CURRENT_DATA, k, '');\n\tconsole.log(cno);\n}\n//输出主从数据查看\n/*let mLen=$JE.getFieldDataLen(chaMasterNo, $CURRENT_DATA);\nfor(let k=0;k<mLen;k++){\n\tlet mno=$JE.getFieldValue(chaMasterNo, $CURRENT_DATA, k, '');\n\tconsole.log(mno);\n}\n\nlet cLen=$JE.getFieldDataLen(chapterCNo, $CURRENT_DATA);\nfor(let k=0;k<cLen;k++){\n\tlet cno=$JE.getFieldValue(chapterCNo, $CURRENT_DATA, k, '');\n\tconsole.log(cno);\n}\n*/\n\nconsole.log('处理后',$CURRENT_DATA);\n\n\n\t",
- "format": ""
- },
- {
- "Name": "设置新字段",
- "run_type": "before_analyzing",
- "expression": "let bCode=$JE.F(2510,$CURRENT_RPT); \nlet bPrice=$JE.F(2513,$CURRENT_RPT);\nlet dealQty=$JE.F(2553,$CURRENT_RPT); \nlet dealTp=$JE.F(2554,$CURRENT_RPT); \nlet tZQty=$JE.F(2522,$CURRENT_RPT); \nlet tZTp=$JE.F(2523,$CURRENT_RPT); \nlet chageJZQty=$JE.F(2545,$CURRENT_RPT); \nlet chageJZTp=$JE.F(2546,$CURRENT_RPT); \nlet bLen1=$JE.getFieldDataLen(bCode, $CURRENT_DATA);\n//let calcFieldArr=[dealQty,dealTp,tZQty,tZTp,chageJZQty,chageJZTp]\n\nlet newTzMdealQty=$JE.F(12146,$CURRENT_RPT); \nlet newTzMdealMTp=$JE.F(12147,$CURRENT_RPT); \nlet newTzAddJZQty=$JE.F(12148,$CURRENT_RPT); \nlet newTzAddJZTp=$JE.F(12149,$CURRENT_RPT); \nlet newPrice1=$JE.F(12150,$CURRENT_RPT); \nlet newPrice2=$JE.F(12151,$CURRENT_RPT);\nfor(let cIdx=0; cIdx<bLen1; cIdx++){\n\tlet tempPrice=$JE.getFieldValue(bPrice, $CURRENT_DATA, cIdx, '');\n\tlet tempDealQty=$JE.getFieldValue(dealQty, $CURRENT_DATA, cIdx, '');\t\n\tlet tempDealTp=$JE.getFieldValue(dealTp, $CURRENT_DATA, cIdx, '');\n\tlet temptZQty=$JE.getFieldValue(tZQty, $CURRENT_DATA, cIdx, '');\n\tlet temptZTp=$JE.getFieldValue(tZTp, $CURRENT_DATA, cIdx, '');\n\tlet tempCJZQty=$JE.getFieldValue(chageJZQty, $CURRENT_DATA, cIdx, '');\n\tlet tempCJZTp=$JE.getFieldValue(chageJZTp, $CURRENT_DATA, cIdx, '');\nlet subQty=$CTX_HELPER.sub(temptZQty,tempDealQty);\n\tlet subTp=$CTX_HELPER.sub(temptZTp,tempDealTp);\n\tlet addQty=$CTX_HELPER.add(temptZQty,tempCJZQty);\n\tlet addTp= $CTX_HELPER.add(temptZTp,tempCJZTp);\n\t\n\t$JE.setFieldValue(newTzMdealQty, $CURRENT_DATA, cIdx, subQty);\n\t$JE.setFieldValue(newTzMdealMTp, $CURRENT_DATA, cIdx, subTp);\n\t$JE.setFieldValue(newTzAddJZQty, $CURRENT_DATA, cIdx, addQty);\n\t$JE.setFieldValue(newTzAddJZTp, $CURRENT_DATA, cIdx, addTp);\nnewTzMdealMTp[JV.PROP_PRECISION] = subTp[JV.PROP_PRECISION];\n\tnewTzMdealMTp[JV.PROP_FIXED_PRECISION_AMT] = subTp[JV.PROP_FIXED_PRECISION_AMT];\n\tnewTzAddJZTp[JV.PROP_PRECISION] = addTp[JV.PROP_PRECISION];\n\tnewTzAddJZTp[JV.PROP_FIXED_PRECISION_AMT] = addTp[JV.PROP_FIXED_PRECISION_AMT];\t\n\tif(tempDealQty===undefined || tempDealQty===null || tempDealQty===''){\n\t\t//console.log('台账');\n\t\t$JE.setFieldValue(newPrice2, $CURRENT_DATA, cIdx, tempPrice);\n\t}else{\t\t\n\t\t$JE.setFieldValue(newPrice1, $CURRENT_DATA, cIdx, tempPrice);\n\t\t//console.log('签约');\n\t}\n\n}\t",
- "format": ""
- }
- ],
- "流水式表_信息": {
- "离散信息": [
- {
- "BandName": "TitleBand",
- "discrete_field_s": [
- {
- "FieldID": 1145,
- "font": "ReportTitle_Main",
- "control": "Title",
- "style": "Default_None",
- "Prefix": "B23.1 工程台帐分表一 (第",
- "Suffix": "汇总表)",
- "isAutoHeight": false,
- "area": {
- "Left": 0,
- "Right": "100.00",
- "Top": 0,
- "Bottom": "100.00",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- }
- ]
- },
- {
- "BandName": "HeaderBand",
- "discrete_field_s": [
- {
- "FieldID": 1101,
- "font": "Header",
- "control": "Header",
- "style": "Default_None",
- "Prefix": "建设项目:",
- "isAutoHeight": false,
- "area": {
- "Left": "43.46",
- "Right": "82.43",
- "Top": 0,
- "Bottom": "50",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "FieldID": 1102,
- "font": "Header",
- "control": "Header",
- "style": "Default_None",
- "Prefix": "合同号:",
- "isAutoHeight": false,
- "area": {
- "Left": "82.43",
- "Right": "100.00",
- "Top": 0,
- "Bottom": "50",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "FieldID": 1134,
- "font": "Header",
- "control": "Header",
- "style": "Default_None",
- "Prefix": "施工单位:",
- "isAutoHeight": false,
- "area": {
- "Left": 0,
- "Right": "43.46",
- "Top": 0,
- "Bottom": "50",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "FieldID": 1140,
- "font": "Header",
- "control": "Header",
- "style": "Default_None",
- "Prefix": "监理单位:",
- "isAutoHeight": false,
- "area": {
- "Left": 0,
- "Right": "43.46",
- "Top": "50",
- "Bottom": "100",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "FieldID": 1300,
- "font": "Header",
- "control": "Header",
- "style": "Default_None",
- "Prefix": "编 号:",
- "isAutoHeight": false,
- "area": {
- "Left": "82.43",
- "Right": "100.00",
- "Top": "49.12",
- "Bottom": "100.00",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- }
- ]
- },
- {
- "BandName": "FooterBand",
- "discrete_field_s": [
- {
- "FieldID": 12170,
- "font": "Content",
- "control": "Default",
- "style": "Default_None",
- "isAutoHeight": false,
- "area": {
- "Left": "5",
- "Right": "22.5",
- "Top": 0,
- "Bottom": 100,
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "FieldID": 12171,
- "font": "Content",
- "control": "Default",
- "style": "Default_None",
- "isAutoHeight": false,
- "area": {
- "Left": "28",
- "Right": "46",
- "Top": 0,
- "Bottom": 100,
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "FieldID": 12172,
- "font": "Content",
- "control": "Default",
- "style": "Default_None",
- "isAutoHeight": false,
- "area": {
- "Left": "54",
- "Right": "71",
- "Top": 0,
- "Bottom": 100,
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "FieldID": 12173,
- "font": "Content",
- "control": "Default",
- "style": "Default_None",
- "isAutoHeight": false,
- "area": {
- "Left": "82",
- "Right": "100",
- "Top": 0,
- "Bottom": 100,
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- }
- ],
- "text_s": [
- {
- "Label": "承包人:",
- "font": "Content",
- "control": "Footer",
- "style": "Default_None",
- "Title": "",
- "area": {
- "Left": 0,
- "Right": "5",
- "Top": 0,
- "Bottom": 100,
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "监理员:",
- "font": "Content",
- "control": "Footer",
- "style": "Default_None",
- "Title": "",
- "area": {
- "Left": "22.5",
- "Right": "28",
- "Top": 0,
- "Bottom": 100,
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "监理组组长:",
- "font": "Content",
- "control": "Footer",
- "style": "Default_None",
- "Title": "",
- "area": {
- "Left": "46",
- "Right": "54",
- "Top": 0,
- "Bottom": 100,
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "业主(业主代表):",
- "font": "Content",
- "control": "Footer",
- "style": "Default_None",
- "Title": "",
- "area": {
- "Left": "71",
- "Right": "82",
- "Top": 0,
- "Bottom": 100,
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- }
- ]
- },
- {
- "BandName": "ChapterBand",
- "discrete_field_s": [
- {
- "FieldID": 1199,
- "font": "Content",
- "control": "NewContent_Center",
- "style": "Default_Normal",
- "Suffix": "章金额小计",
- "isAutoHeight": false,
- "area": {
- "Left": 0,
- "Right": "17.29",
- "Top": 0,
- "Bottom": 100,
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- }
- ]
- }
- ],
- "流水式表_列": {
- "BandName": "ColumnBand",
- "text_s": [
- {
- "Label": "子目|编号",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": 0,
- "Right": "5.35",
- "Top": 0,
- "Bottom": "66.29",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "子目|名称",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "5.35",
- "Right": "17.29",
- "Top": 0,
- "Bottom": "66.29",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "单位",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "17.29",
- "Right": "21.01",
- "Top": 0,
- "Bottom": "66.29",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "单价(元)",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "21.01",
- "Right": "32.09",
- "Top": 0,
- "Bottom": "20.79",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "合 同",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "21.01",
- "Right": "26.65",
- "Top": "20.79",
- "Bottom": "66.29",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "新 增",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "26.65",
- "Right": "32.09",
- "Top": "20.79",
- "Bottom": "66.29",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "合同工程",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "32.09",
- "Right": "43.46",
- "Top": 0,
- "Bottom": "20.79",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "数 量",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "32.09",
- "Right": "37.82",
- "Top": "20.79",
- "Bottom": "66.29",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "金 额",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "37.82",
- "Right": "43.46",
- "Top": "20.79",
- "Bottom": "66.29",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "设计情况",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "43.46",
- "Right": "76.89",
- "Top": 0,
- "Bottom": "20.79",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "数量",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "43.46",
- "Right": "60.08",
- "Top": "20.79",
- "Bottom": "41.01",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "金额(元)",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "60.08",
- "Right": "76.89",
- "Top": "20.79",
- "Bottom": "41.01",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "变更情况",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "76.89",
- "Right": "88.16",
- "Top": 0,
- "Bottom": "20.79",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "变更数量|(±)",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "76.89",
- "Right": "82.43",
- "Top": "20.79",
- "Bottom": "66.29",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "金额|(±)|(元)",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "82.43",
- "Right": "88.16",
- "Top": "20.79",
- "Bottom": "66.29",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "设计+变更",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "88.16",
- "Right": "100.00",
- "Top": 0,
- "Bottom": "20.79",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "数量",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "88.16",
- "Right": "94.08",
- "Top": "20.79",
- "Bottom": "66.29",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "金额|(元)",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "94.08",
- "Right": "100.00",
- "Top": "20.79",
- "Bottom": "66.29",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "原设计|图纸数量",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "43.46",
- "Right": "48.90",
- "Top": "41.01",
- "Bottom": "66.29",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "复核",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "48.90",
- "Right": "54.54",
- "Top": "41.01",
- "Bottom": "66.29",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "复核增减|(±)",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "54.54",
- "Right": "60.08",
- "Top": "41.01",
- "Bottom": "66.29",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "原设计",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "60.08",
- "Right": "65.81",
- "Top": "41.01",
- "Bottom": "66.29",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "复核",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "65.81",
- "Right": "71.25",
- "Top": "41.01",
- "Bottom": "66.29",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "复核增减|(±)",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "71.25",
- "Right": "76.89",
- "Top": "41.01",
- "Bottom": "66.29",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "(1)",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": 0,
- "Right": "5.35",
- "Top": "66.29",
- "Bottom": "100.00",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "(2)",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "5.35",
- "Right": "17.29",
- "Top": "66.29",
- "Bottom": "100.00",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "(3)",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "17.29",
- "Right": "21.01",
- "Top": "66.29",
- "Bottom": "100.00",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "(4)",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "21.01",
- "Right": "26.65",
- "Top": "66.29",
- "Bottom": "100.00",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "(5)",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "26.65",
- "Right": "32.09",
- "Top": "66.29",
- "Bottom": "100.00",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "(6)",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "32.09",
- "Right": "37.82",
- "Top": "66.29",
- "Bottom": "100.00",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "(7)",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "37.82",
- "Right": "43.46",
- "Top": "66.29",
- "Bottom": "100.00",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "(8)",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "43.46",
- "Right": "48.90",
- "Top": "66.29",
- "Bottom": "100.00",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "(9)",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "48.90",
- "Right": "54.54",
- "Top": "66.29",
- "Bottom": "100.00",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "(10)",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "54.54",
- "Right": "60.08",
- "Top": "66.29",
- "Bottom": "100.00",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "(11)",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "60.08",
- "Right": "65.81",
- "Top": "66.29",
- "Bottom": "100.00",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "(12)",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "65.81",
- "Right": "71.25",
- "Top": "66.29",
- "Bottom": "100.00",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "(13)",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "71.25",
- "Right": "76.89",
- "Top": "66.29",
- "Bottom": "100.00",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "(14)",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "76.89",
- "Right": "82.43",
- "Top": "66.29",
- "Bottom": "100.00",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "(15)",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "82.43",
- "Right": "88.16",
- "Top": "66.29",
- "Bottom": "100.00",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "(16)=(9)+(14)",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "88.16",
- "Right": "94.08",
- "Top": "66.29",
- "Bottom": "100.00",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "(17)=(16)×(4)或(5)",
- "font": "Content",
- "control": "Column",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "94.08",
- "Right": "100.00",
- "Top": "66.29",
- "Bottom": "100.00",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- }
- ]
- },
- "多列显示数量": 1,
- "流水式表_数据": {
- "BandName": "ContentBand",
- "CommonHeight": "0.61",
- "flow_field_s": [
- {
- "FieldID": 2510,
- "font": "Content_Narrow",
- "control": "Column_Left",
- "style": "Default_Normal",
- "isAutoHeight": false,
- "area": {
- "Left": 0,
- "Right": "5.35",
- "Top": 0,
- "Bottom": "100.00",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "FieldID": 2511,
- "font": "Content_Narrow",
- "control": "Column_Left",
- "style": "Default_Normal",
- "isAutoHeight": true,
- "area": {
- "Left": "5.35",
- "Right": "17.29",
- "Top": 0,
- "Bottom": "100.00",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "FieldID": 2512,
- "font": "Content_Narrow",
- "control": "Column",
- "style": "Default_Normal",
- "isAutoHeight": false,
- "area": {
- "Left": "17.29",
- "Right": "21.01",
- "Top": 0,
- "Bottom": "100.00",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "FieldID": 12150,
- "font": "Content",
- "control": "Column_Right",
- "style": "Default_Normal",
- "isAutoHeight": false,
- "area": {
- "Left": "21.01",
- "Right": "26.65",
- "Top": 0,
- "Bottom": "100.00",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "FieldID": 12151,
- "font": "Content",
- "control": "Column_Right",
- "style": "Default_Normal",
- "isAutoHeight": false,
- "area": {
- "Left": "26.65",
- "Right": "32.09",
- "Top": 0,
- "Bottom": "100.00",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "FieldID": 2553,
- "font": "Content",
- "control": "Column_Right",
- "style": "Default_Normal",
- "isAutoHeight": false,
- "area": {
- "Left": "32.09",
- "Right": "37.82",
- "Top": 0,
- "Bottom": "100.00",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "FieldID": 2554,
- "font": "Content",
- "control": "Column_Right",
- "style": "Default_Normal",
- "isAutoHeight": false,
- "area": {
- "Left": "37.82",
- "Right": "43.46",
- "Top": 0,
- "Bottom": "100.00",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "FieldID": 2553,
- "font": "Content",
- "control": "Column_Right",
- "style": "Default_Normal",
- "isAutoHeight": false,
- "area": {
- "Left": "43.46",
- "Right": "48.9",
- "Top": 0,
- "Bottom": "100.00",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "FieldID": 2522,
- "font": "Content",
- "control": "Column_Right",
- "style": "Default_Normal",
- "isAutoHeight": false,
- "area": {
- "Left": "48.90",
- "Right": "54.54",
- "Top": 0,
- "Bottom": "100.00",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "FieldID": 12146,
- "font": "Content",
- "control": "Column_Right",
- "style": "Default_Normal",
- "isAutoHeight": false,
- "area": {
- "Left": "54.54",
- "Right": "60.08",
- "Top": 0,
- "Bottom": "100.00",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "FieldID": 2554,
- "font": "Content",
- "control": "Column_Right",
- "style": "Default_Normal",
- "isAutoHeight": false,
- "area": {
- "Left": "60.08",
- "Right": "65.81",
- "Top": 0,
- "Bottom": "100.00",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "FieldID": 2523,
- "font": "Content",
- "control": "Column_Right",
- "style": "Default_Normal",
- "isAutoHeight": false,
- "area": {
- "Left": "65.81",
- "Right": "71.25",
- "Top": 0,
- "Bottom": "100.00",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "FieldID": 12147,
- "font": "Content",
- "control": "Column_Right",
- "style": "Default_Normal",
- "isAutoHeight": false,
- "area": {
- "Left": "71.25",
- "Right": "76.89",
- "Top": 0,
- "Bottom": "100.00",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "FieldID": 2545,
- "font": "Content",
- "control": "Column_Right",
- "style": "Default_Normal",
- "isAutoHeight": false,
- "area": {
- "Left": "76.89",
- "Right": "82.43",
- "Top": 0,
- "Bottom": "100.00",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "FieldID": 2546,
- "font": "Content",
- "control": "Column_Right",
- "style": "Default_Normal",
- "isAutoHeight": false,
- "area": {
- "Left": "82.43",
- "Right": "88.16",
- "Top": 0,
- "Bottom": "100.00",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "FieldID": 12148,
- "font": "Content",
- "control": "Column_Right",
- "style": "Default_Normal",
- "isAutoHeight": false,
- "area": {
- "Left": "88.16",
- "Right": "94.08",
- "Top": 0,
- "Bottom": "100.00",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "FieldID": 12149,
- "font": "Content",
- "control": "Column_Right",
- "style": "Default_Normal",
- "isAutoHeight": false,
- "area": {
- "Left": "94.08",
- "Right": "100.00",
- "Top": 0,
- "Bottom": "100.00",
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- }
- ]
- },
- "流水式表_分组信息": {
- "group_field_s": [],
- "sum_field_s": [],
- "group_lines": []
- },
- "流水式表_段统计信息": {
- "BandName": "ChapterBand",
- "sum_field_s": [
- {
- "FieldID": 2554,
- "font": "Content",
- "control": "Currency",
- "style": "Default_Normal",
- "isAutoHeight": false,
- "area": {
- "Left": "37.82",
- "Right": "43.46",
- "Top": 0,
- "Bottom": 100,
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "FieldID": 2554,
- "font": "Content",
- "control": "Currency",
- "style": "Default_Normal",
- "isAutoHeight": false,
- "area": {
- "Left": "60.08",
- "Right": "65.81",
- "Top": 0,
- "Bottom": 100,
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "FieldID": 2523,
- "font": "Content",
- "control": "Currency",
- "style": "Default_Normal",
- "isAutoHeight": false,
- "area": {
- "Left": "65.81",
- "Right": "71.25",
- "Top": 0,
- "Bottom": 100,
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "FieldID": 12147,
- "font": "Content",
- "control": "Currency",
- "style": "Default_Normal",
- "isAutoHeight": false,
- "area": {
- "Left": "71.25",
- "Right": "76.89",
- "Top": 0,
- "Bottom": 100,
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "FieldID": 2546,
- "font": "Content",
- "control": "Currency",
- "style": "Default_Normal",
- "isAutoHeight": false,
- "area": {
- "Left": "82.43",
- "Right": "88.16",
- "Top": 0,
- "Bottom": 100,
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "FieldID": 12149,
- "font": "Content",
- "control": "Currency",
- "style": "Default_Normal",
- "isAutoHeight": false,
- "area": {
- "Left": "94.08",
- "Right": 100,
- "Top": 0,
- "Bottom": 100,
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- }
- ],
- "text_s": [
- {
- "Label": "",
- "font": "Content",
- "control": "Default",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "17.29",
- "Right": "21.01",
- "Top": 0,
- "Bottom": 100,
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "",
- "font": "Content",
- "control": "Default",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "21.01",
- "Right": "26.65",
- "Top": 0,
- "Bottom": 100,
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "",
- "font": "Content",
- "control": "Default",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "26.65",
- "Right": "32.09",
- "Top": 0,
- "Bottom": 100,
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "",
- "font": "Content",
- "control": "Default",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "32.09",
- "Right": "37.82",
- "Top": 0,
- "Bottom": 100,
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "",
- "font": "Content",
- "control": "Default",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "43.46",
- "Right": "48.9",
- "Top": 0,
- "Bottom": 100,
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "",
- "font": "Content",
- "control": "Default",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "48.9",
- "Right": "54.54",
- "Top": 0,
- "Bottom": 100,
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "",
- "font": "Content",
- "control": "Default",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "54.54",
- "Right": "60.08",
- "Top": 0,
- "Bottom": 100,
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "",
- "font": "Content",
- "control": "Default",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "76.89",
- "Right": "82.43",
- "Top": 0,
- "Bottom": 100,
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- },
- {
- "Label": "",
- "font": "Content",
- "control": "Default",
- "style": "Default_Normal",
- "Title": "",
- "area": {
- "Left": "88.16",
- "Right": "94.08",
- "Top": 0,
- "Bottom": 100,
- "H_CalculationType": "percentage",
- "V_CalculationType": "percentage"
- }
- }
- ]
- },
- "流水式表_页统计信息": {
- "BandName": "",
- "sum_field_s": [],
- "text_s": []
- }
- },
- "离散参数_集合": [
- {
- "ID": "5001",
- "Name": "打印时间",
- "DataType": "String",
- "Default_Value": ""
- },
- {
- "ID": "5010",
- "Name": "当前页",
- "DataType": "String",
- "Default_Value": "第 X 页"
- },
- {
- "ID": "5011",
- "Name": "总页数",
- "DataType": "String",
- "Default_Value": "共 X 页"
- }
- ],
- "指标_数据_映射": {
- "离散指标_集合": [
- {
- "ID": 1101,
- "Name": "标段_项目名称",
- "DataType": "string",
- "TableName": "tender_info",
- "mapExpression": "$PROJECT.REPORT.getProperty(\"tender_info\", \"deal_info.buildName\")",
- "descr": "",
- "Title": "ID: 1101"
- },
- {
- "ID": 1134,
- "Name": "标段_标段清单_承包单位1_单位名称",
- "DataType": "string",
- "TableName": "tender_info",
- "mapExpression": "$PROJECT.REPORT.getProperty(\"tender_info\", \"construction_unit.contract1.company\")",
- "descr": "",
- "Title": "ID: 1134"
- },
- {
- "ID": 1140,
- "Name": "标段_标段清单_监理单位1_单位名称",
- "DataType": "string",
- "TableName": "tender_info",
- "mapExpression": "$PROJECT.REPORT.getProperty(\"tender_info\", \"construction_unit.supervision1.company\")",
- "descr": "",
- "Title": "ID: 1140"
- },
- {
- "ID": 1102,
- "Name": "标段_合同编号",
- "DataType": "string",
- "TableName": "tender_info",
- "mapExpression": "$PROJECT.REPORT.getProperty(\"tender_info\", \"deal_info.dealCode\")",
- "descr": "",
- "Title": "ID: 1102"
- },
- {
- "ID": 1132,
- "Name": "标段_标段清单_章节代码",
- "DataType": "array",
- "TableName": "tender_info",
- "mapExpression": "$PROJECT.REPORT.getArrayProperty(\"tender_info\", \"chapter.code\")",
- "descr": "",
- "Title": "ID: 1132"
- },
- {
- "ID": 1133,
- "Name": "标段_标段清单_章节名称",
- "DataType": "array",
- "TableName": "tender_info",
- "mapExpression": "$PROJECT.REPORT.getArrayProperty(\"tender_info\", \"chapter.name\")",
- "descr": "",
- "Title": "ID: 1133"
- },
- {
- "ID": 1300,
- "Name": "期计量信息_期数",
- "DataType": "number",
- "TableName": "stage",
- "mapExpression": "$PROJECT.REPORT.getProperty(\"stage\", \"order\")",
- "descr": "",
- "Title": "ID: 1300"
- }
- ],
- "主数据指标_集合": [
- {
- "ID": 1199,
- "Name": "标段_空白",
- "DataType": "string",
- "TableName": "tender_info",
- "mapExpression": "$PROJECT.REPORT.getBlank(\"tender_info\", \"\")",
- "descr": "",
- "Title": "ID: 1199",
- "isID": true,
- "IDSeq": 1
- },
- {
- "ID": 1099,
- "Name": "项目_空白",
- "DataType": "string",
- "TableName": "project",
- "mapExpression": "$PROJECT.REPORT.getBlank(\"project\", \"\")",
- "descr": "",
- "Title": "ID: 1099"
- },
- {
- "ID": 1145,
- "Name": "标段_标段清单_监理单位2_签订日期",
- "DataType": "string",
- "TableName": "tender_info",
- "mapExpression": "$PROJECT.REPORT.getProperty(\"tender_info\", \"construction_unit.supervision2.date\")",
- "descr": "",
- "Title": "ID: 1145"
- }
- ],
- "从数据指标_集合": [
- {
- "ID": 2553,
- "Name": "预留扩展字段_1(ex_value1)",
- "DataType": "string",
- "TableName": "mem_stage_bills",
- "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'ex_value1')",
- "descr": "",
- "Title": "ID: 2553"
- },
- {
- "ID": 2554,
- "Name": "预留扩展字段_2(ex_value2)",
- "DataType": "string",
- "TableName": "mem_stage_bills",
- "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'ex_value2')",
- "descr": "",
- "Title": "ID: 2554"
- },
- {
- "ID": 1600,
- "Name": "签约清单信息_清单编号(code)",
- "DataType": "string",
- "TableName": "deal_bills",
- "mapExpression": "$PROJECT.REPORT.getProperty(\"deal_bills\", \"code\")",
- "descr": "",
- "Title": "ID: 1600"
- },
- {
- "ID": 1601,
- "Name": "签约清单信息_名称(name)",
- "DataType": "string",
- "TableName": "deal_bills",
- "mapExpression": "$PROJECT.REPORT.getProperty(\"deal_bills\", \"name\")",
- "descr": "",
- "Title": "ID: 1601"
- },
- {
- "ID": 1602,
- "Name": "签约清单信息_单位(unit)",
- "DataType": "string",
- "TableName": "deal_bills",
- "mapExpression": "$PROJECT.REPORT.getProperty(\"deal_bills\", \"unit\")",
- "descr": "",
- "Title": "ID: 1602"
- },
- {
- "ID": 1604,
- "Name": "签约清单信息_单价(unit_price)",
- "DataType": "currency",
- "TableName": "deal_bills",
- "mapExpression": "$PROJECT.REPORT.getProperty(\"deal_bills\", \"unit_price\")",
- "descr": "",
- "Title": "ID: 1604",
- "Precision": {
- "type": "fixed",
- "fixedMapExpression": "$PROJECT.REPORT.getProperty(\"tender_info\", \"decimal.up\")"
- }
- },
- {
- "ID": 1603,
- "Name": "签约清单信息_数量(quanitty)",
- "DataType": "number",
- "TableName": "deal_bills",
- "mapExpression": "$PROJECT.REPORT.getProperty(\"deal_bills\", \"quantity\")",
- "descr": "",
- "Title": "ID: 1603",
- "Precision": {
- "type": "flexible",
- "flexibleRefFieldID": 1602,
- "flexibleMapExpression": "$PROJECT.REPORT.getProperty(\"tender_info\", \"precision\")"
- }
- },
- {
- "ID": 1605,
- "Name": "签约清单信息_合价(total_price)",
- "DataType": "currency",
- "TableName": "deal_bills",
- "mapExpression": "$PROJECT.REPORT.getProperty(\"deal_bills\", \"total_price\")",
- "descr": "",
- "Title": "ID: 1605",
- "Precision": {
- "type": "fixed",
- "fixedMapExpression": "$PROJECT.REPORT.getProperty(\"tender_info\", \"decimal.tp\")"
- }
- },
- {
- "ID": 2510,
- "Name": "清单编号(b_code)",
- "DataType": "string",
- "TableName": "mem_stage_bills",
- "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'b_code')",
- "descr": "",
- "Title": "ID: 2510"
- },
- {
- "ID": 2511,
- "Name": "名称(name)",
- "DataType": "string",
- "TableName": "mem_stage_bills",
- "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'name')",
- "descr": "",
- "Title": "ID: 2511"
- },
- {
- "ID": 2512,
- "Name": "单位(unit)",
- "DataType": "string",
- "TableName": "mem_stage_bills",
- "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'unit')",
- "descr": "",
- "Title": "ID: 2512"
- },
- {
- "ID": 2513,
- "Name": "单价(unit_price)",
- "DataType": "currency",
- "TableName": "mem_stage_bills",
- "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'unit_price')",
- "descr": "",
- "Title": "ID: 2513"
- },
- {
- "ID": 2522,
- "Name": "台账-数量(quantity)",
- "DataType": "currency",
- "TableName": "mem_stage_bills",
- "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'quantity')",
- "descr": "",
- "Title": "ID: 2522"
- },
- {
- "ID": 2545,
- "Name": "截止本期-数量变更-数量(end_qc_qty)",
- "DataType": "currency",
- "TableName": "mem_stage_bills",
- "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'end_qc_qty')",
- "descr": "",
- "Title": "ID: 2545"
- },
- {
- "ID": 2508,
- "Name": "树结构-是否子项(is_leaf)",
- "DataType": "int",
- "TableName": "mem_stage_bills",
- "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'is_leaf')",
- "descr": "",
- "Title": "ID: 2508"
- },
- {
- "ID": 2536,
- "Name": "本期批注(postil)",
- "DataType": "string",
- "TableName": "mem_stage_bills",
- "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'postil')",
- "descr": "",
- "Title": "ID: 2536"
- },
- {
- "ID": 2552,
- "Name": "章节编号(chapter)",
- "DataType": "string",
- "TableName": "mem_stage_bills",
- "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'chapter')",
- "descr": "",
- "Title": "ID: 2552",
- "isID": true,
- "IDSeq": 1
- },
- {
- "ID": 2523,
- "Name": "台账-金额(total_price)",
- "DataType": "currency",
- "TableName": "mem_stage_bills",
- "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'total_price')",
- "descr": "",
- "Title": "ID: 2523",
- "Precision": {
- "type": "fixed",
- "fixedMapExpression": "$PROJECT.REPORT.getProperty('tender_info', 'decimal.tp')"
- }
- },
- {
- "ID": 2546,
- "Name": "截止本期-数量变更-金额(end_qc_tp)",
- "DataType": "currency",
- "TableName": "mem_stage_bills",
- "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'end_qc_tp')",
- "descr": "",
- "Title": "ID: 2546",
- "Precision": {
- "type": "fixed",
- "fixedMapExpression": "$PROJECT.REPORT.getProperty('tender_info', 'decimal.tp')"
- }
- }
- ],
- "主数据指标_拓展集合": [],
- "从数据指标_拓展集合": []
- },
- "映射数据预处理": [
- {
- "预处理类型": "指定方式",
- "映射数据对象": "",
- "方式Key": "gatherGcl",
- "hint": "请使用mem_stage_bills下指标,注意事项:\n1. 以下字段,不管报表是否实际使用,均应添加至指标映射,且在此处应勾选(不要求顺序):\n 清单编号(b_code), 名称(name), 单位(unit), 单价(unit_price), 树结构-是否子项(is_leaf)\n2. 汇总后,以下字段,均会失效, 请勿使用:\n 台账ID(id), 树结构-ID(ledger_id), 树结构父项-ID(ledger_pid),\n 树结构-层级(level), 树结构-同层排序(order), 树结构-完整路径(full_path),\n 图册号(drawing_code), 备注(memo), 节点类型(node_type), 总额计量(is_tp)\n3. 如需汇总\"未计入清单章节项\",请勾选\"章节编号(chapter)\"字段\n",
- "fields": [
- {
- "Name": "清单编号(b_code)",
- "FieldID": 2510
- },
- {
- "Name": "名称(name)",
- "FieldID": 2511
- },
- {
- "Name": "单位(unit)",
- "FieldID": 2512
- },
- {
- "Name": "单价(unit_price)",
- "FieldID": 2513
- },
- {
- "Name": "树结构-是否子项(is_leaf)",
- "FieldID": 2508
- }
- ],
- "自定义设置": ""
- },
- {
- "预处理类型": "指定方式",
- "映射数据对象": "",
- "方式Key": "join",
- "hint": "用于处理类似于关联签约清单的情况,会改变主表的数据",
- "fields": [],
- "自定义设置": "{\n\t\"main\": \"mem_stage_bills\",\n\t\"sub\": \"deal_bills\",\n\t\"keyFields\": [\n\t\t{\n\t\t\t\"main\": \"b_code\",\n\t\t\t\"sub\": \"code\",\n\t\t\t\"type\": \"string\"\n\t\t},\n\t\t{\n\t\t\t\"main\": \"name\",\n\t\t\t\"sub\": \"name\",\n\t\t\t\"type\": \"string\"\n\t\t},\n\t\t{\n\t\t\t\"main\": \"unit\",\n\t\t\t\"sub\": \"unit\",\n\t\t\t\"type\": \"string\"\n\t\t},\n\t\t{\n\t\t\t\"main\": \"unit_price\",\n\t\t\t\"sub\": \"unit_price\",\n\t\t\t\"type\": \"number\"\n\t\t}\n\t],\n\t\"importFields\": [\n\t\t{\n\t\t\t\"main\": \"ex_value1\",\n\t\t\t\"sub\": \"quantity\"\n\t\t},\n\t\t{\n\t\t\t\"main\": \"ex_value2\",\n\t\t\t\"sub\": \"total_price\"\n\t\t}\n\t],\n\t\"joinType\": \"outer\"\n}"
- },
- {
- "预处理类型": "指定方式",
- "映射数据对象": "",
- "方式Key": "sortGcl",
- "hint": "只对一张表,进行工程量清单排序,排序哪张表,根据勾选的清单编号字段决定:\ne.g.1 要对mem_stage_bills排序,需要勾选mem_stage_bills下的\"清单编号(b_code)\"字段\ne.g.2 要对mem_stage_im_zl排序,需要勾选mem_stage_im_zl下的\"中间计量总量信息_编号(code)\"字段\n特别的,如有\"未计入清单章节项\": \n 1. 默认\"未计入清单章节项\"排列在最后\n 2. 如须\"未计入清单章节项\"排在100章之后,请在清单编号字段后,依次勾选\"章节编号(chapter)\", \"名称(name)\"\n",
- "fields": [
- {
- "Name": "清单编号(b_code)",
- "FieldID": 2510
- }
- ],
- "自定义设置": ""
- }
- ],
- "无映射离散指标_集合": [
- {
- "ID": 12146,
- "Name": "新台账减签约_数量",
- "DataType": "string"
- },
- {
- "ID": 12147,
- "Name": "新台账减签约_金额",
- "DataType": "string"
- },
- {
- "ID": 12148,
- "Name": "新台账加截止本期_数量",
- "DataType": "string"
- },
- {
- "ID": 12149,
- "Name": "新台账加截止本期_金额",
- "DataType": "string"
- },
- {
- "ID": 12150,
- "Name": "新单价",
- "DataType": "string"
- },
- {
- "ID": 12151,
- "Name": "新单价2",
- "DataType": "string"
- },
- {
- "ID": 12153,
- "Name": "新合计名称",
- "DataType": "string"
- }
- ],
- "动态日期离散参数_集合": [],
- "电子签名离散指标_集合": [
- {
- "ID": 12170,
- "Name": "承包人",
- "DataType": "string"
- },
- {
- "ID": 12171,
- "Name": "监理员",
- "DataType": "string"
- },
- {
- "ID": 12172,
- "Name": "监理组组长",
- "DataType": "string"
- },
- {
- "ID": 12173,
- "Name": "业主(业主代表)",
- "DataType": "string"
- }
- ]
- }
|