ReportSaas/02.定制报表/01.重庆/01.峨山县定制报表/B23 工程台帐汇总表

{
    "ID_KEY": "DUMMY_FLOW_SAMPLE",
    "GROUP_KEY": "RPT_B23 工程台帐汇总表_SAMPLE_TPL",
    "主信息": {
        "单位": "厘米",
        "版本": {
            "主版本": "3",
            "功能版本": "0"
        },
        "页边距": {
            "Top": "1.0",
            "Left": "1.0",
            "Right": "1.0",
            "Bottom": "1.0"
        },
        "报表名称": "B23 工程台帐汇总表",
        "打印页面_信息": {
            "方向": "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": "2.70",
                    "Name": "ColumnBand",
                    "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_paging",
            "expression": "let ZJQYBH = $JE.F(1600,$CURRENT_RPT); //签约编号\nlet ZJQYT = $JE.F(1605,$CURRENT_RPT); //签约清单金额\nlet ZJname = $JE.F(2511,$CURRENT_RPT); //章节名称\nlet ZJTPT = $JE.F(2523,$CURRENT_RPT); //台账金额\nlet ZJXml = $JE.F(2509,$CURRENT_RPT); //章节编号\n\nlet newZJXhao= $JE.F(12134,$CURRENT_RPT); //新序号\nlet newZJFH= $JE.F(12135,$CURRENT_RPT); //新符合增减\nlet newZJXml= $JE.F(12144,$CURRENT_RPT); //新章节编号\nlet newZJQYT= $JE.F(12145,$CURRENT_RPT); //新签约清单金额\n\n\nlet fLen0 = $JE.getFieldDataLen(ZJname, $CURRENT_DATA);\nlet fLen1 = $JE.getFieldDataLen(ZJXml, $CURRENT_DATA);\nlet fLen2 = $JE.getFieldDataLen(ZJQYBH, $CURRENT_DATA);\nlet fLen3 = $JE.getFieldDataLen(ZJname, $CURRENT_DATA);\nlet ZJXmlarrt=[];\nlet Aarry=[];\n\nfunction sortBy(field1,field2) {\n\tfor(let i=0;i<field1.length;i++){\n\t\t$JE.setFieldValue(field2, $CURRENT_DATA, i,field1[i]);\n\t}\n}\n\n//获取章节长度\nlet lenQD=0;\nfor(let m=0;m<fLen1;m++){\n\tlet bZJXml = $JE.getFieldValue(ZJXml, $CURRENT_DATA, m, '');\n\tif(bZJXml!==''){\n\t\tlenQD++;\t\n\t}\n}\n\nfor(let m=0;m<lenQD;m++){//循环每一个章节\n    let bZJXml = $JE.getFieldValue(ZJXml, $CURRENT_DATA, m, '');\n\tlet sum=0;\n\tfor(let a=0;a<fLen2;a++){\n\t\tlet bQyqd= $JE.getFieldValue(ZJQYBH, $CURRENT_DATA, a, '');//签约清单\n\t\tlet bQyTP= $JE.getFieldValue(ZJQYT, $CURRENT_DATA, a, '');//签约金额\n\t\tlet firstIdx = bQyqd.indexOf('-');//获取清单'-'之前的长度\n\t\tlet QycodeKey='';\n\t\tif(firstIdx===3){//清单长度判断：为3或者为4的清单\n           QycodeKey=bQyqd.slice(0,1)*100;//\n\t    }\n\t    else if(firstIdx===4){\n\t       QycodeKey=bQyqd.slice(0,2)*100;\n\t    }\n\t\tif(QycodeKey==bZJXml){//进行签约清单与章节匹配\n\t\t  sum=$CTX_HELPER.add(sum,bQyTP);\n\t\t}\n\t}\n  Aarry.push(sum);\t\n}\nlet Aarrylen0=Aarry.length; //获取数组目前长度\nfor(let T=0;T<fLen0;T++){//循环项目名称进行匹配\n\tlet bZJname = $JE.getFieldValue(ZJname, $CURRENT_DATA, T, '');\n\tif(bZJname==='第100章至700章清单合计' || T===fLen0-1){//第100章至700章清单合计 与最后一行需要签约金额\n\t\tlet hj=0;\n\t\tfor(let u=0;u<Aarrylen0;u++){//使用数组的目前长度，避免循环相加\n\t\t    hj=$CTX_HELPER.add(hj,Aarry[u]);\n\t\t}\n\t\tAarry[T]=hj;\t\t\n\t}\n}\nconsole.log(Aarry);\n\t\nsortBy(Aarry,newZJQYT);\n\n//处理单元格合并问题\nfor (let chkIdx = 0; chkIdx < fLen0; chkIdx++) {\n     let bZJQYT = $JE.getFieldValue(newZJQYT, $CURRENT_DATA, chkIdx, '');\n\t let bZJTPT = $JE.getFieldValue(ZJTPT, $CURRENT_DATA, chkIdx, '');\n\t let bZJXml = $JE.getFieldValue(ZJXml, $CURRENT_DATA, chkIdx, '');\n\t let bZJname = $JE.getFieldValue(ZJname, $CURRENT_DATA, chkIdx, '');\n\t $JE.setFieldValue(newZJXhao, $CURRENT_DATA, chkIdx,chkIdx+1);\n     $JE.setFieldValue(newZJFH, $CURRENT_DATA, chkIdx,$CTX_HELPER.sub(bZJTPT,bZJQYT));\n\t if(bZJXml ==''){//判断章次是否为空，如果为空则给予赋值\n\t    ZJXmlarrt.push(bZJname);//章次为空，在数组中该位置加上章节名称\n\t }\n\t else{\n\t    ZJXmlarrt.push(bZJXml);\t\n\t }\n}\n\nsortBy(ZJXmlarrt,newZJXml);\n\n",
            "format": ""
        },
        {
            "Name": "章次加后缀",
            "run_type": "before_paging",
            "expression": "let zhangJie_num = $JE.F(12144,$CURRENT_RPT); \n\nlet fLen0 = $JE.getFieldDataLen(zhangJie_num, $CURRENT_DATA);\n\nfor(let i = 0 ; i < fLen0 ; i++){\n\tlet new_zhangJie_num = $JE.getFieldValue(zhangJie_num, $CURRENT_DATA, i, '');\n\tlet a = new_zhangJie_num.slice(0,1);\n\tif(new_zhangJie_num !== '' && !(isNaN(a))){\n\t\t$JE.setFieldValue(zhangJie_num,$CURRENT_DATA,i,new_zhangJie_num + '章');\n\t}\n}\n",
            "format": ""
        }
    ],
    "流水式表_信息": {
        "离散信息": [
            {
                "BandName": "TitleBand",
                "text_s": [
                    {
                        "Label": "B23 工程台帐汇总表",
                        "font": "ReportTitle_Main",
                        "control": "Title",
                        "style": "Default_None",
                        "Title": "",
                        "area": {
                            "Left": 0,
                            "Right": "100.00",
                            "Top": 0,
                            "Bottom": "100.00",
                            "H_CalculationType": "percentage",
                            "V_CalculationType": "percentage"
                        }
                    }
                ]
            },
            {
                "BandName": "HeaderBand",
                "discrete_field_s": [
                    {
                        "FieldID": 1134,
                        "font": "Header",
                        "control": "Header",
                        "style": "Default_None",
                        "Prefix": "施工单位：",
                        "isAutoHeight": false,
                        "area": {
                            "Left": 0,
                            "Right": "47.95",
                            "Top": 0,
                            "Bottom": "50.00",
                            "H_CalculationType": "percentage",
                            "V_CalculationType": "percentage"
                        }
                    },
                    {
                        "FieldID": 1140,
                        "font": "Header",
                        "control": "Header",
                        "style": "Default_None",
                        "Prefix": "监理单位：",
                        "isAutoHeight": false,
                        "area": {
                            "Left": 0,
                            "Right": "47.95",
                            "Top": "50.00",
                            "Bottom": "100.00",
                            "H_CalculationType": "percentage",
                            "V_CalculationType": "percentage"
                        }
                    },
                    {
                        "FieldID": 1101,
                        "font": "Header",
                        "control": "Header",
                        "style": "Default_None",
                        "Prefix": "建设项目：",
                        "isAutoHeight": false,
                        "area": {
                            "Left": "47.95",
                            "Right": "76.31",
                            "Top": 0,
                            "Bottom": "50.00",
                            "H_CalculationType": "percentage",
                            "V_CalculationType": "percentage"
                        }
                    },
                    {
                        "FieldID": 1102,
                        "font": "Header",
                        "control": "Header",
                        "style": "Default_None",
                        "Prefix": "合同号：",
                        "isAutoHeight": false,
                        "area": {
                            "Left": "76.31",
                            "Right": "100.00",
                            "Top": 0,
                            "Bottom": "50.00",
                            "H_CalculationType": "percentage",
                            "V_CalculationType": "percentage"
                        }
                    },
                    {
                        "FieldID": 1300,
                        "font": "Content",
                        "control": "Header",
                        "style": "Default_None",
                        "Prefix": "编  号：",
                        "isAutoHeight": false,
                        "area": {
                            "Left": "76.31",
                            "Right": "100.00",
                            "Top": "50.00",
                            "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": "ColumnBand",
            "text_s": [
                {
                    "Label": "序号",
                    "font": "Content",
                    "control": "Column",
                    "style": "Default_Normal",
                    "Title": "",
                    "area": {
                        "Left": 0,
                        "Right": "5.16",
                        "Top": 0,
                        "Bottom": "100.00",
                        "H_CalculationType": "percentage",
                        "V_CalculationType": "percentage"
                    }
                },
                {
                    "Label": "章 次",
                    "font": "Content",
                    "control": "Column",
                    "style": "Default_Normal",
                    "Title": "",
                    "area": {
                        "Left": "5.16",
                        "Right": "16.71",
                        "Top": 0,
                        "Bottom": "66.67",
                        "H_CalculationType": "percentage",
                        "V_CalculationType": "percentage"
                    }
                },
                {
                    "Label": "科目名称",
                    "font": "Content",
                    "control": "Column",
                    "style": "Default_Normal",
                    "Title": "",
                    "area": {
                        "Left": "16.71",
                        "Right": "38.20",
                        "Top": 0,
                        "Bottom": "66.67",
                        "H_CalculationType": "percentage",
                        "V_CalculationType": "percentage"
                    }
                },
                {
                    "Label": "合同金额（元）",
                    "font": "Content",
                    "control": "Column",
                    "style": "Default_Normal",
                    "Title": "",
                    "area": {
                        "Left": "38.20",
                        "Right": "47.95",
                        "Top": 0,
                        "Bottom": "66.67",
                        "H_CalculationType": "percentage",
                        "V_CalculationType": "percentage"
                    }
                },
                {
                    "Label": "设计金额（元）",
                    "font": "Content",
                    "control": "Column",
                    "style": "Default_Normal",
                    "Title": "",
                    "area": {
                        "Left": "47.95",
                        "Right": "76.31",
                        "Top": 0,
                        "Bottom": "33.33",
                        "H_CalculationType": "percentage",
                        "V_CalculationType": "percentage"
                    }
                },
                {
                    "Label": "变更金额（±）（元）",
                    "font": "Content",
                    "control": "Column",
                    "style": "Default_Normal",
                    "Title": "",
                    "area": {
                        "Left": "76.31",
                        "Right": "88.35",
                        "Top": 0,
                        "Bottom": "66.67",
                        "H_CalculationType": "percentage",
                        "V_CalculationType": "percentage"
                    }
                },
                {
                    "Label": "设计+变更金额（元）",
                    "font": "Content",
                    "control": "Column",
                    "style": "Default_Normal",
                    "Title": "",
                    "area": {
                        "Left": "88.35",
                        "Right": "100.00",
                        "Top": 0,
                        "Bottom": "66.67",
                        "H_CalculationType": "percentage",
                        "V_CalculationType": "percentage"
                    }
                },
                {
                    "Label": "原设计",
                    "font": "Content",
                    "control": "Column",
                    "style": "Default_Normal",
                    "Title": "",
                    "area": {
                        "Left": "47.95",
                        "Right": "57.69",
                        "Top": "33.33",
                        "Bottom": "66.67",
                        "H_CalculationType": "percentage",
                        "V_CalculationType": "percentage"
                    }
                },
                {
                    "Label": "复核",
                    "font": "Content",
                    "control": "Column",
                    "style": "Default_Normal",
                    "Title": "",
                    "area": {
                        "Left": "57.69",
                        "Right": "67.05",
                        "Top": "33.33",
                        "Bottom": "66.67",
                        "H_CalculationType": "percentage",
                        "V_CalculationType": "percentage"
                    }
                },
                {
                    "Label": "复核增减|（±）",
                    "font": "Content",
                    "control": "Column",
                    "style": "Default_Normal",
                    "Title": "",
                    "area": {
                        "Left": "67.05",
                        "Right": "76.31",
                        "Top": "33.33",
                        "Bottom": "66.67",
                        "H_CalculationType": "percentage",
                        "V_CalculationType": "percentage"
                    }
                },
                {
                    "Label": "（1）",
                    "font": "Content",
                    "control": "Column",
                    "style": "Default_Normal",
                    "Title": "",
                    "area": {
                        "Left": "5.16",
                        "Right": "16.71",
                        "Top": "66.67",
                        "Bottom": "100.00",
                        "H_CalculationType": "percentage",
                        "V_CalculationType": "percentage"
                    }
                },
                {
                    "Label": "（2）",
                    "font": "Content",
                    "control": "Column",
                    "style": "Default_Normal",
                    "Title": "",
                    "area": {
                        "Left": "16.71",
                        "Right": "38.20",
                        "Top": "66.67",
                        "Bottom": "100.00",
                        "H_CalculationType": "percentage",
                        "V_CalculationType": "percentage"
                    }
                },
                {
                    "Label": "（3）",
                    "font": "Content",
                    "control": "Column",
                    "style": "Default_Normal",
                    "Title": "",
                    "area": {
                        "Left": "38.20",
                        "Right": "47.95",
                        "Top": "66.67",
                        "Bottom": "100.00",
                        "H_CalculationType": "percentage",
                        "V_CalculationType": "percentage"
                    }
                },
                {
                    "Label": "（4）",
                    "font": "Content",
                    "control": "Column",
                    "style": "Default_Normal",
                    "Title": "",
                    "area": {
                        "Left": "47.95",
                        "Right": "57.69",
                        "Top": "66.67",
                        "Bottom": "100.00",
                        "H_CalculationType": "percentage",
                        "V_CalculationType": "percentage"
                    }
                },
                {
                    "Label": "（5）",
                    "font": "Content",
                    "control": "Column",
                    "style": "Default_Normal",
                    "Title": "",
                    "area": {
                        "Left": "57.69",
                        "Right": "67.05",
                        "Top": "66.67",
                        "Bottom": "100.00",
                        "H_CalculationType": "percentage",
                        "V_CalculationType": "percentage"
                    }
                },
                {
                    "Label": "（6）",
                    "font": "Content",
                    "control": "Column",
                    "style": "Default_Normal",
                    "Title": "",
                    "area": {
                        "Left": "67.05",
                        "Right": "76.31",
                        "Top": "66.67",
                        "Bottom": "100.00",
                        "H_CalculationType": "percentage",
                        "V_CalculationType": "percentage"
                    }
                },
                {
                    "Label": "（7）",
                    "font": "Content",
                    "control": "Column",
                    "style": "Default_Normal",
                    "Title": "",
                    "area": {
                        "Left": "76.31",
                        "Right": "88.35",
                        "Top": "66.67",
                        "Bottom": "100.00",
                        "H_CalculationType": "percentage",
                        "V_CalculationType": "percentage"
                    }
                },
                {
                    "Label": "（8）=（5）+（7）",
                    "font": "Content",
                    "control": "Column",
                    "style": "Default_Normal",
                    "Title": "",
                    "area": {
                        "Left": "88.35",
                        "Right": "100.00",
                        "Top": "66.67",
                        "Bottom": "100.00",
                        "H_CalculationType": "percentage",
                        "V_CalculationType": "percentage"
                    }
                }
            ]
        },
        "多列显示数量": 1,
        "流水式表_数据": {
            "BandName": "ContentBand",
            "CommonHeight": "0.95",
            "flow_field_s": [
                {
                    "FieldID": 12134,
                    "font": "Content",
                    "control": "Column",
                    "style": "Default_Normal",
                    "isAutoHeight": false,
                    "area": {
                        "Left": 0,
                        "Right": "5.16",
                        "Top": 0,
                        "Bottom": "100.00",
                        "H_CalculationType": "percentage",
                        "V_CalculationType": "percentage"
                    }
                },
                {
                    "FieldID": 12144,
                    "font": "Content",
                    "control": "Column",
                    "style": "Default_Normal",
                    "isAutoHeight": false,
                    "combineType": "horizon",
                    "area": {
                        "Left": "5.16",
                        "Right": "16.71",
                        "Top": 0,
                        "Bottom": "100.00",
                        "H_CalculationType": "percentage",
                        "V_CalculationType": "percentage"
                    }
                },
                {
                    "FieldID": 2511,
                    "font": "Content",
                    "control": "Column",
                    "style": "Default_Normal",
                    "isAutoHeight": false,
                    "combineType": "horizon",
                    "area": {
                        "Left": "16.71",
                        "Right": "38.20",
                        "Top": 0,
                        "Bottom": "100.00",
                        "H_CalculationType": "percentage",
                        "V_CalculationType": "percentage"
                    }
                },
                {
                    "FieldID": 12145,
                    "font": "Content",
                    "control": "Column_Right",
                    "style": "Default_Normal",
                    "isAutoHeight": false,
                    "area": {
                        "Left": "38.20",
                        "Right": "47.95",
                        "Top": 0,
                        "Bottom": "100.00",
                        "H_CalculationType": "percentage",
                        "V_CalculationType": "percentage"
                    }
                },
                {
                    "FieldID": 12145,
                    "font": "Content",
                    "control": "Column_Right",
                    "style": "Default_Normal",
                    "isAutoHeight": false,
                    "area": {
                        "Left": "47.95",
                        "Right": "57.69",
                        "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": "57.69",
                        "Right": "67.05",
                        "Top": 0,
                        "Bottom": "100.00",
                        "H_CalculationType": "percentage",
                        "V_CalculationType": "percentage"
                    }
                },
                {
                    "FieldID": 12135,
                    "font": "Content",
                    "control": "Column_Right",
                    "style": "Default_Normal",
                    "isAutoHeight": false,
                    "area": {
                        "Left": "67.05",
                        "Right": "76.31",
                        "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": "76.31",
                        "Right": "88.35",
                        "Top": 0,
                        "Bottom": "100.00",
                        "H_CalculationType": "percentage",
                        "V_CalculationType": "percentage"
                    }
                },
                {
                    "FieldID": 2549,
                    "font": "Content",
                    "control": "Column_Right",
                    "style": "Default_Normal",
                    "isAutoHeight": false,
                    "area": {
                        "Left": "88.35",
                        "Right": "100.00",
                        "Top": 0,
                        "Bottom": "100.00",
                        "H_CalculationType": "percentage",
                        "V_CalculationType": "percentage"
                    }
                }
            ]
        },
        "流水式表_分组信息": {
            "group_field_s": [],
            "sum_field_s": [],
            "group_lines": []
        },
        "流水式表_段统计信息": {
            "BandName": "",
            "sum_field_s": [],
            "text_s": []
        },
        "流水式表_页统计信息": {
            "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": 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": 1104,
                "Name": "标段_建设单位",
                "DataType": "string",
                "TableName": "tender_info",
                "mapExpression": "$PROJECT.REPORT.getProperty(\"tender_info\", \"construction_unit.build.company\")",
                "descr": "",
                "Title": "ID: 1104"
            },
            {
                "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": 1101,
                "Name": "标段_项目名称",
                "DataType": "string",
                "TableName": "tender_info",
                "mapExpression": "$PROJECT.REPORT.getProperty(\"tender_info\", \"deal_info.buildName\")",
                "descr": "",
                "Title": "ID: 1101"
            },
            {
                "ID": 1102,
                "Name": "标段_合同编号",
                "DataType": "string",
                "TableName": "tender_info",
                "mapExpression": "$PROJECT.REPORT.getProperty(\"tender_info\", \"deal_info.dealCode\")",
                "descr": "",
                "Title": "ID: 1102"
            },
            {
                "ID": 1300,
                "Name": "期计量信息_期数",
                "DataType": "number",
                "TableName": "stage",
                "mapExpression": "$PROJECT.REPORT.getProperty(\"stage\", \"order\")",
                "descr": "",
                "Title": "ID: 1300"
            }
        ],
        "主数据指标_集合": [],
        "从数据指标_集合": [
            {
                "ID": 2523,
                "Name": "台账-金额",
                "DataType": "currency",
                "TableName": "mem_stage_bills",
                "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'total_price')",
                "descr": "",
                "Title": "ID: 2523"
            },
            {
                "ID": 2510,
                "Name": "清单编号",
                "DataType": "string",
                "TableName": "mem_stage_bills",
                "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'b_code')",
                "descr": "",
                "Title": "ID: 2510"
            },
            {
                "ID": 2508,
                "Name": "树结构-是否子项",
                "DataType": "int",
                "TableName": "mem_stage_bills",
                "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'is_leaf')",
                "descr": "",
                "Title": "ID: 2508"
            },
            {
                "ID": 2509,
                "Name": "项目节编号",
                "DataType": "string",
                "TableName": "mem_stage_bills",
                "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'code')",
                "descr": "",
                "Title": "ID: 2509"
            },
            {
                "ID": 2511,
                "Name": "名称",
                "DataType": "string",
                "TableName": "mem_stage_bills",
                "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'name')",
                "descr": "",
                "Title": "ID: 2511"
            },
            {
                "ID": 1605,
                "Name": "签约清单信息_合价",
                "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": 2549,
                "Name": "(台账 + 截止本期变更)-金额",
                "DataType": "currency",
                "TableName": "mem_stage_bills",
                "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'final_tp')",
                "descr": "",
                "Title": "ID: 2549"
            },
            {
                "ID": 2546,
                "Name": "截止本期-数量变更-金额",
                "DataType": "currency",
                "TableName": "mem_stage_bills",
                "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'end_qc_tp')",
                "descr": "",
                "Title": "ID: 2546"
            },
            {
                "ID": 2540,
                "Name": "截止上期-数量变更-金额",
                "DataType": "currency",
                "TableName": "mem_stage_bills",
                "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'pre_qc_tp')",
                "descr": "",
                "Title": "ID: 2540"
            },
            {
                "ID": 1600,
                "Name": "签约清单信息_清单编号",
                "DataType": "string",
                "TableName": "deal_bills",
                "mapExpression": "$PROJECT.REPORT.getProperty(\"deal_bills\", \"code\")",
                "descr": "",
                "Title": "ID: 1600"
            }
        ],
        "主数据指标_拓展集合": [],
        "从数据指标_拓展集合": []
    },
    "映射数据预处理": [
        {
            "预处理类型": "指定方式",
            "映射数据对象": "",
            "方式Key": "gatherChapter",
            "hint": "请使用mem_stage_bills/mem_stage_bills_compare/ledger，仅对一张表进行汇总，并生成数据：\n1. 因为是汇总章级数据，必须在离散数据中添加\"章节代码\"&\"章节名称\"\n2. 需勾选\"清单编号(b_code)\", \"树结构-是否子项(is_leaf)\"字段，可以对任何含有这些字段的表汇总\n注意事项：\n1. 算法对数据表没有要求，保证有上述字段，且按顺序勾选即可, 仅汇总金额\n2. 算法计算后，原数据表中非数字类型的字段全部失效(除清单编号、名称外)，请勿在指标映射中添加\n示例：\ne.g.1 要对mem_stage_bills汇总，须勾选mem_stage_bills下的\"清单编号(b_code)\", \"树结构-是否子项((is_leaf)\"字段\ne.g.2 要对mem_stage_bills_compare汇总，须勾选mem_stage_bills_compare下的\"清单编号(b_code)\", \"树结构-是否子项((is_leaf)\"字段\n结果：\n汇总结果可参照 清单汇总--章节合计，但是不过滤1000-1300章数据",
            "fields": [
                {
                    "Name": "清单编号",
                    "FieldID": 2510
                },
                {
                    "Name": "树结构-是否子项",
                    "FieldID": 2508
                }
            ],
            "自定义设置": "{\n\t\"count\":7,\n\t\"gclSum\": {\n\t\t\"name\": \"第100章至700章清单合计\",\n\t\t\"order\": 1\n\t},\n\t\"custom\": [{\n\t\t\"name\": \"已包含在清单合计中的材料、工程设备、专业工程暂估价\",\n\t\t\"order\": 2\n\t}, {\n\t\t\"name\": \"清单合计减去材料、工程设备、专业工程暂估价(即8-9=10)\",\n\t\t\"order_calc\": \"o1-o2\",\n\t\t\"order\": 3\n\t}, {\n\t\t\"name\": \"计日工合计\",\n\t\t\"node_type\": \"计日工\",\n\t\t\"order\": 4\n\t}, {\n\t\t\"name\": \"暂列金额(不含计日工总额)(即10×暂列金额比列)\",\n\t\t\"node_type\": \"暂列金额\",\n\t\t\"order\": 5\n\t}, {\n\t\t\"name\": \"投标报价、台账价(8+11+12)=13\",\n\t\t\"order_calc\": \"o1+o4+o5\",\n\t\t\"order\": 6\n\t}]\n}"
        }
    ],
    "无映射离散指标_集合": [
        {
            "ID": 12134,
            "Name": "新序号",
            "DataType": "string"
        },
        {
            "ID": 12135,
            "Name": "新签约-台账",
            "DataType": "string"
        },
        {
            "ID": 12144,
            "Name": "新章次",
            "DataType": "string"
        },
        {
            "ID": 12145,
            "Name": "新签约金额",
            "DataType": "string"
        }
    ],
    "动态日期离散参数_集合": [],
    "电子签名离散指标_集合": [
        {
            "ID": 12170,
            "Name": "承包人",
            "DataType": "string"
        },
        {
            "ID": 12171,
            "Name": "监理员",
            "DataType": "string"
        },
        {
            "ID": 12172,
            "Name": "监理组组长",
            "DataType": "string"
        },
        {
            "ID": 12173,
            "Name": "业主（业主代表）",
            "DataType": "string"
        }
    ]
}