{ "ID_KEY": "DUMMY_FLOW_SAMPLE", "GROUP_KEY": "RPT_B12中间计量支付汇总表_SAMPLE_TPL", "主信息": { "单位": "厘米", "版本": { "主版本": "3", "功能版本": "0" }, "页边距": { "Top": "1.0", "Left": "1.0", "Right": "1.0", "Bottom": "1.0" }, "报表名称": "B12中间计量支付汇总表", "打印页面_信息": { "方向": "PORTRAIT", "页规格": "A4" } }, "布局框_集合": [ { "Alignment": "Top", "DisplayType": "EveryPage", "Height": "2.59", "Name": "TitleBand", "control": "Default", "style": "Default_None", "MergeBorder": "F" }, { "Alignment": "Top", "DisplayType": "EveryPage", "Height": "1.19", "Name": "HeaderBand", "control": "Default", "style": "Default_None", "MergeBorder": "F" }, { "Alignment": "Bottom", "DisplayType": "EveryPage", "Height": "0.6", "Name": "newBand_2", "control": "Default", "style": "Default_None", "MergeBorder": "F" }, { "Alignment": "Bottom", "DisplayType": "EveryPage", "Height": "1", "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": "1.01", "Name": "ColumnBand", "control": "Default", "style": "Default_None", "MergeBorder": "F" }, { "Alignment": "Bottom", "DisplayType": "LastPage", "Height": "0.61", "Name": "newBand_1", "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": "let rpt = $JE.F(1312,$CURRENT_RPT);\nlet jzrq = $JE.getFieldValue(rpt, $CURRENT_DATA, 0, '')\nlet shiJian = jzrq.split('-');\n\nif(shiJian[0]!==''){\n\tlet newRiQiValue = shiJian[0]+\"年\"+shiJian[1]+\"月\"+shiJian[2]+\"日\";\n\t$JE.setFieldValue(rpt, $CURRENT_DATA, 0, newRiQiValue);\n}", "format": "" }, { "Name": "综合设置", "run_type": "before_analyzing", "expression": "let QDFCodeID = $JE.F(2504,$CURRENT_RPT);\nlet XH = $JE.F(1900,$CURRENT_RPT);\nlet TZid = $JE.F(2501,$CURRENT_RPT);\nlet ZJid = $JE.F(1901,$CURRENT_RPT);\n\nlet Bcode = $JE.F(2510,$CURRENT_RPT);\nlet Name = $JE.F(2511,$CURRENT_RPT);\nlet Unitt = $JE.F(2512,$CURRENT_RPT);\nlet UnittP = $JE.F(2513,$CURRENT_RPT);\nlet GtpQ = $JE.F(2534,$CURRENT_RPT);\nlet GtpT = $JE.F(2535,$CURRENT_RPT);\nlet LedId = $JE.F(2503,$CURRENT_RPT);\n\nlet BH = $JE.F(1915,$CURRENT_RPT);\n\n//新指标\nlet NewBcode = $JE.F(12161,$CURRENT_RPT);\nlet NewName = $JE.F(12221,$CURRENT_RPT);\nlet NewUnitt = $JE.F(12222,$CURRENT_RPT);\nlet NewUnittP = $JE.F(12223,$CURRENT_RPT);\nlet NewGtpQ = $JE.F(12224,$CURRENT_RPT);\nlet NewGtpT = $JE.F(12225,$CURRENT_RPT);\nlet NewBH = $JE.F(12226,$CURRENT_RPT);\nlet NewLedId = $JE.F(12227,$CURRENT_RPT);\n\nlet fLen0 = $JE.getFieldDataLen(Bcode, $CURRENT_DATA);\nlet fLen1 = $JE.getFieldDataLen(XH, $CURRENT_DATA);\n\n//获取LedId并进行赋值给中间计量窗口的项目节\nfor(let J=0;J 0) {\n\tfor (let ix = 1; ix <= diff; ix++) {\n\t\t$JE.removeFieldValue(Bcode, $CURRENT_DATA, dtlLen - ix);\n\t}\n} else if (diff < 0) {\n\tfor (let ix = 0; ix < (0 - diff); ix++) {\n\t\t$JE.setFieldValue(Bcode, $CURRENT_DATA, dtlLen + ix, 0);\n\t}\n}\n", "format": "" } ], "流水式表_信息": { "离散信息": [ { "BandName": "TitleBand", "discrete_field_s": [ { "FieldID": 1101, "font": "ReportTitle_Vice_1", "control": "Title", "style": "Default_None", "isAutoHeight": false, "area": { "Left": 0, "Right": "100.00", "Top": 0, "Bottom": "40", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } } ], "text_s": [ { "Label": "中间计量支付汇总表", "font": "ReportTitle_Main", "control": "Title", "style": "Default_None", "Title": "", "area": { "Left": 0, "Right": "100.00", "Top": "40", "Bottom": "100", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } } ] }, { "BandName": "HeaderBand", "discrete_field_s": [ { "FieldID": 1134, "font": "Content", "control": "Header", "style": "Default_None", "Prefix": "承包单位:", "isAutoHeight": false, "area": { "Left": 0, "Right": "28", "Top": 0, "Bottom": "51.11", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "FieldID": 1300, "font": "Content", "control": "Header", "style": "Default_None", "Prefix": "期次:第", "Suffix": "期", "isAutoHeight": false, "area": { "Left": "28", "Right": "56", "Top": 0, "Bottom": "51.11", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "FieldID": 1140, "font": "Content", "control": "Header", "style": "Default_None", "Prefix": "监理单位:", "isAutoHeight": false, "area": { "Left": "56", "Right": "84", "Top": 0, "Bottom": "51.11", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "FieldID": 1103, "font": "Content", "control": "Header", "style": "Default_None", "Prefix": "合同段号:", "isAutoHeight": false, "area": { "Left": 0, "Right": "28", "Top": "51.11", "Bottom": "100.00", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "FieldID": 1102, "font": "Content", "control": "Header", "style": "Default_None", "Prefix": "合同编号:", "isAutoHeight": false, "area": { "Left": "28", "Right": "56", "Top": "51.11", "Bottom": "100.00", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "FieldID": 1312, "font": "Content", "control": "Header", "style": "Default_None", "Prefix": "截止日期:", "isAutoHeight": false, "area": { "Left": "56", "Right": "84", "Top": "51.11", "Bottom": "100.00", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "ParamID": "5010", "font": "Content", "control": "NewContent_Center", "style": "Label_Underline", "Default_Value": "第 X 页", "area": { "Left": "84", "Right": "92", "Top": "51.11", "Bottom": "100.00", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "ParamID": "5011", "font": "Content", "control": "NewContent_Center", "style": "Default_None", "Default_Value": "共 X 页", "area": { "Left": "92", "Right": "100", "Top": "51.11", "Bottom": "100.00", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } } ] }, { "BandName": "newBand_2", "discrete_field_s": [ { "ParamID": 12229, "font": "Content", "control": "Column_Left", "style": "Default_None", "Default_Value": "", "area": { "Left": "8", "Right": "33", "Top": "0", "Bottom": "100", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "ParamID": 12230, "font": "Content", "control": "Column_Left", "style": "Default_None", "Default_Value": "", "area": { "Left": "44", "Right": "66", "Top": "0", "Bottom": "100", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "ParamID": 12231, "font": "Content", "control": "Column_Left", "style": "Default_None", "Default_Value": "", "area": { "Left": "74", "Right": "100", "Top": "0", "Bottom": 100, "H_CalculationType": "percentage", "V_CalculationType": "percentage" } } ], "text_s": [ { "Label": "日期:", "font": "Content", "control": "Header_Right", "style": "Default_None", "Title": "", "area": { "Left": 0, "Right": "8", "Top": "0", "Bottom": "100.00", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "Label": "日期:", "font": "Content", "control": "Header_Right", "style": "Default_None", "Title": "", "area": { "Left": "33", "Right": "44", "Top": "0", "Bottom": "100.00", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "Label": "日期:", "font": "Content", "control": "Column_Right", "style": "Default_None", "Title": "", "area": { "Left": "66", "Right": "74", "Top": "0", "Bottom": 100, "H_CalculationType": "percentage", "V_CalculationType": "percentage" } } ] }, { "BandName": "FooterBand", "discrete_field_s": [ { "FieldID": 12164, "font": "Content", "control": "Column_Left", "style": "Default_None", "isAutoHeight": false, "area": { "Left": "8", "Right": "33", "Top": 0, "Bottom": 100, "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "FieldID": 12165, "font": "Content", "control": "Column_Left", "style": "Default_None", "isAutoHeight": false, "area": { "Left": "44", "Right": "66", "Top": 0, "Bottom": 100, "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "FieldID": 12228, "font": "Content", "control": "Column_Left", "style": "Default_None", "isAutoHeight": false, "area": { "Left": "74", "Right": 100, "Top": 0, "Bottom": 100, "H_CalculationType": "percentage", "V_CalculationType": "percentage" } } ], "text_s": [ { "Label": "承包人:", "font": "Content", "control": "Column_Right", "style": "Default_None", "Title": "", "area": { "Left": "0", "Right": "8", "Top": 0, "Bottom": 100, "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "Label": "工程管理部:", "font": "Content", "control": "Column_Right", "style": "Default_None", "Title": "", "area": { "Left": "33", "Right": "44", "Top": 0, "Bottom": 100, "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "Label": "经营部:", "font": "Content", "control": "Column_Right", "style": "Default_None", "Title": "", "area": { "Left": "66", "Right": "74", "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": "80.92", "Right": "100.00", "Top": 0, "Bottom": "100.00", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "Label": "项目名称", "font": "Content", "control": "Column", "style": "Default_Normal", "Title": "", "area": { "Left": "9.05", "Right": "29.67", "Top": 0, "Bottom": "100.00", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "Label": "单位", "font": "Content", "control": "Column", "style": "Default_Normal", "Title": "", "area": { "Left": "45.54", "Right": "54.60", "Top": 0, "Bottom": "100.00", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "Label": "单价(元)", "font": "Content", "control": "Column", "style": "Default_Normal", "Title": "", "area": { "Left": "70.33", "Right": "80.92", "Top": 0, "Bottom": "100.00", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "Label": "清单编号", "font": "Content", "control": "Column", "style": "Default_Normal", "Title": "", "area": { "Left": 0, "Right": "9.05", "Top": 0, "Bottom": "100.00", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "Label": "凭证号", "font": "Content", "control": "Column", "style": "Default_Normal", "Title": "", "area": { "Left": "29.67", "Right": "45.54", "Top": 0, "Bottom": "100.00", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "Label": "数量", "font": "Content", "control": "Column", "style": "Default_Normal", "Title": "", "area": { "Left": "54.60", "Right": "70.33", "Top": 0, "Bottom": "100.00", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } } ] }, "多列显示数量": 1, "流水式表_数据": { "BandName": "ContentBand", "CommonHeight": "0.79", "flow_field_s": [ { "FieldID": 12225, "font": "Content", "control": "Column_Right", "style": "Default_Normal", "isAutoHeight": false, "area": { "Left": "80.92", "Right": "100.00", "Top": 0, "Bottom": "100.00", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "FieldID": 12221, "font": "Content", "control": "Column_Left", "style": "Default_Normal", "isAutoHeight": false, "area": { "Left": "9.05", "Right": "29.67", "Top": 0, "Bottom": "100.00", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "FieldID": 12222, "font": "Content", "control": "NewContent_Center", "style": "Default_Normal", "isAutoHeight": false, "area": { "Left": "45.54", "Right": "54.60", "Top": 0, "Bottom": "100.00", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "FieldID": 12223, "font": "Content", "control": "Column_Right", "style": "Default_Normal", "isAutoHeight": false, "area": { "Left": "70.33", "Right": "80.92", "Top": 0, "Bottom": "100.00", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "FieldID": 12161, "font": "Content", "control": "Column_Left", "style": "Default_Normal", "isAutoHeight": false, "area": { "Left": 0, "Right": "9.05", "Top": 0, "Bottom": "100.00", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "FieldID": 12226, "font": "Content", "control": "Column", "style": "Default_Normal", "isAutoHeight": false, "area": { "Left": "29.67", "Right": "45.54", "Top": 0, "Bottom": "100.00", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "FieldID": 12224, "font": "Content", "control": "Column_Right", "style": "Default_Normal", "isAutoHeight": false, "area": { "Left": "54.60", "Right": "70.33", "Top": 0, "Bottom": "100.00", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } } ] }, "流水式表_分组信息": { "group_field_s": [], "sum_field_s": [], "group_lines": [] }, "流水式表_段统计信息": { "BandName": "newBand_1", "sum_field_s": [ { "FieldID": 12225, "font": "Content", "control": "Column_Right", "style": "Default_None", "isAutoHeight": false, "area": { "Left": "80.92", "Right": 100, "Top": 0, "Bottom": 100, "H_CalculationType": "percentage", "V_CalculationType": "percentage" } } ], "text_s": [ { "Label": "合计", "font": "Content", "control": "Column", "style": "Default_Normal", "Title": "", "area": { "Left": "9.05", "Right": "29.67", "Top": 0, "Bottom": "100.00", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "Label": "", "font": "Content", "control": "Content_Left", "style": "Default_Normal", "Title": "", "area": { "Left": "45.54", "Right": "54.60", "Top": 0, "Bottom": "100.00", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "Label": "", "font": "Content", "control": "Content_Left", "style": "Default_Normal", "Title": "", "area": { "Left": "70.33", "Right": "80.92", "Top": 0, "Bottom": "100.00", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "Label": "", "font": "Content", "control": "Content_Left", "style": "Default_Normal", "Title": "", "area": { "Left": 0, "Right": "9.05", "Top": 0, "Bottom": "100.00", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "Label": "", "font": "Content", "control": "Content_Left", "style": "Default_Normal", "Title": "", "area": { "Left": "29.67", "Right": "45.54", "Top": 0, "Bottom": "100.00", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "Label": "", "font": "Content", "control": "Content_Left", "style": "Default_Normal", "Title": "", "area": { "Left": "54.60", "Right": "70.33", "Top": 0, "Bottom": "100.00", "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": 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": 1104, "Name": "标段_建设单位", "DataType": "string", "TableName": "tender_info", "mapExpression": "$PROJECT.REPORT.getProperty('tender_info', 'construction_unit.build.company')", "descr": "", "Title": "ID: 1104" }, { "ID": 1101, "Name": "标段_项目名称", "DataType": "string", "TableName": "tender_info", "mapExpression": "$PROJECT.REPORT.getProperty('tender_info', 'deal_info.buildName')", "descr": "", "Title": "ID: 1101" }, { "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": 1312, "Name": "期计量信息_截至日期", "DataType": "string", "TableName": "stage", "mapExpression": "$PROJECT.REPORT.getSplitProperty(\"stage\", \"period\", \" ~ \", 1, \"\")", "descr": "", "Title": "ID: 1312" }, { "ID": 1300, "Name": "期计量信息_期数", "DataType": "number", "TableName": "stage", "mapExpression": "$PROJECT.REPORT.getProperty(\"stage\", \"order\")", "descr": "", "Title": "ID: 1300" }, { "ID": 2903, "Name": "变更清单-清单编号(code)", "DataType": "string", "TableName": "mem_change_bills", "mapExpression": "$PROJECT.REPORT.getProperty('mem_change_bills', 'code')", "descr": "", "Title": "ID: 2903" }, { "ID": 2904, "Name": "变更清单-名称(name)", "DataType": "string", "TableName": "mem_change_bills", "mapExpression": "$PROJECT.REPORT.getProperty('mem_change_bills', 'name')", "descr": "", "Title": "ID: 2904" }, { "ID": 2905, "Name": "变更清单-单位(unit)", "DataType": "string", "TableName": "mem_change_bills", "mapExpression": "$PROJECT.REPORT.getProperty('mem_change_bills', 'unit')", "descr": "", "Title": "ID: 2905" }, { "ID": 2906, "Name": "变更清单-单价(unit_price)", "DataType": "currency", "TableName": "mem_change_bills", "mapExpression": "$PROJECT.REPORT.getProperty('mem_change_bills', 'unit_price')", "descr": "", "Title": "ID: 2906" }, { "ID": 2909, "Name": "变更清单-审批变更后数量(s_qty)", "DataType": "currency", "TableName": "mem_change_bills", "mapExpression": "$PROJECT.REPORT.getProperty('mem_change_bills', 's_qty')", "descr": "", "Title": "ID: 2909" }, { "ID": 2912, "Name": "变更清单-审批变更后-金额(s_tp)", "DataType": "currency", "TableName": "mem_change_bills", "mapExpression": "$PROJECT.REPORT.getProperty('mem_change_bills', 's_tp')", "descr": "", "Title": "ID: 2912" }, { "ID": 1103, "Name": "标段_合同名称", "DataType": "string", "TableName": "tender_info", "mapExpression": "$PROJECT.REPORT.getProperty(\"tender_info\", \"deal_info.dealName\")", "descr": "", "Title": "ID: 1103" }, { "ID": 1102, "Name": "标段_合同编号", "DataType": "string", "TableName": "tender_info", "mapExpression": "$PROJECT.REPORT.getProperty(\"tender_info\", \"deal_info.dealCode\")", "descr": "", "Title": "ID: 1102" } ], "主数据指标_集合": [], "从数据指标_集合": [ { "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": 2508, "Name": "树结构-是否子项(is_leaf)", "DataType": "int", "TableName": "mem_stage_bills", "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'is_leaf')", "descr": "", "Title": "ID: 2508" }, { "ID": 2514, "Name": "签约-数量(deal_qty)", "DataType": "currency", "TableName": "mem_stage_bills", "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'deal_qty')", "descr": "", "Title": "ID: 2514" }, { "ID": 2515, "Name": "签约-金额(deal_tp)", "DataType": "currency", "TableName": "mem_stage_bills", "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'deal_tp')", "descr": "", "Title": "ID: 2515" }, { "ID": 2534, "Name": "本期-完成-数量(gather_qty)", "DataType": "currency", "TableName": "mem_stage_bills", "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'gather_qty')", "descr": "", "Title": "ID: 2534" }, { "ID": 2535, "Name": "本期-完成-金额(gather_tp)", "DataType": "currency", "TableName": "mem_stage_bills", "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'gather_tp')", "descr": "", "Title": "ID: 2535" }, { "ID": 2516, "Name": "施工复核-数量(sgfh_qty)", "DataType": "currency", "TableName": "mem_stage_bills", "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'sgfh_qty')", "descr": "", "Title": "ID: 2516", "Precision": { "type": "flexible", "flexibleRefFieldID": 2512, "flexibleMapExpression": "$PROJECT.REPORT.getProperty('tender_info', 'precision')" } }, { "ID": 2517, "Name": "施工复核-金额(sgfh_tp)", "DataType": "currency", "TableName": "mem_stage_bills", "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'sgfh_tp')", "descr": "", "Title": "ID: 2517", "Precision": { "type": "fixed", "fixedMapExpression": "$PROJECT.REPORT.getProperty('tender_info', 'decimal.tp')" } }, { "ID": 2541, "Name": "截止上期-完成-数量(pre_gather_qty)", "DataType": "currency", "TableName": "mem_stage_bills", "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'pre_gather_qty')", "descr": "", "Title": "ID: 2541" }, { "ID": 2542, "Name": "截止上期-完成-金额(pre_gather_tp)", "DataType": "currency", "TableName": "mem_stage_bills", "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'pre_gather_tp')", "descr": "", "Title": "ID: 2542" }, { "ID": 2547, "Name": "截止本期-完成-数量(end_gather_qty)", "DataType": "currency", "TableName": "mem_stage_bills", "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'end_gather_qty')", "descr": "", "Title": "ID: 2547" }, { "ID": 2548, "Name": "截止本期-完成-金额(end_gather_tp)", "DataType": "currency", "TableName": "mem_stage_bills", "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'end_gather_tp')", "descr": "", "Title": "ID: 2548" }, { "ID": 2550, "Name": "截止本期完成率(%)(final_ratio)", "DataType": "double", "TableName": "mem_stage_bills", "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'final_ratio')", "descr": "", "Title": "ID: 2550" }, { "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": 2552, "Name": "章节编号(chapter)", "DataType": "string", "TableName": "mem_stage_bills", "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'chapter')", "descr": "", "Title": "ID: 2552" }, { "ID": 1916, "Name": "中间计量0号台账信息_交工证书", "DataType": "string", "TableName": "mem_stage_im_tz", "mapExpression": "$PROJECT.REPORT.getProperty(\"mem_stage_im_tz\", \"doc_code\")", "descr": "", "Title": "ID: 1916" }, { "ID": 1900, "Name": "中间计量0号台账信息_id", "DataType": "int", "TableName": "mem_stage_im_tz", "mapExpression": "$PROJECT.REPORT.getProperty(\"mem_stage_im_tz\", \"id\")", "descr": "", "Title": "ID: 1900" }, { "ID": 1901, "Name": "中间计量0号台账信息_台账id", "DataType": "string", "TableName": "mem_stage_im_tz", "mapExpression": "$PROJECT.REPORT.getProperty(\"mem_stage_im_tz\", \"lid\")", "descr": "", "Title": "ID: 1901" }, { "ID": 2504, "Name": "树结构-父项ID(ledger_pid)", "DataType": "int", "TableName": "mem_stage_bills", "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'ledger_pid')", "descr": "", "Title": "ID: 2504" }, { "ID": 2501, "Name": "台账ID(id)", "DataType": "int", "TableName": "mem_stage_bills", "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'id')", "descr": "", "Title": "ID: 2501" }, { "ID": 1915, "Name": "中间计量0号台账信息_中间计量表号", "DataType": "string", "TableName": "mem_stage_im_tz", "mapExpression": "$PROJECT.REPORT.getProperty(\"mem_stage_im_tz\", \"im_code\")", "descr": "", "Title": "ID: 1915" }, { "ID": 2503, "Name": "树结构-ID(ledger_id)", "DataType": "int", "TableName": "mem_stage_bills", "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'ledger_id')", "descr": "", "Title": "ID: 2503" } ], "主数据指标_拓展集合": [], "从数据指标_拓展集合": [] }, "映射数据预处理": [ { "预处理类型": "指定方式", "映射数据对象": "", "方式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": 12161, "Name": "新清单编号", "DataType": "string" }, { "ID": 12221, "Name": "新名称", "DataType": "string" }, { "ID": 12222, "Name": "单位", "DataType": "string" }, { "ID": 12223, "Name": "单价", "DataType": "string" }, { "ID": 12224, "Name": "本期完成数量", "DataType": "string" }, { "ID": 12225, "Name": "本期完成金额", "DataType": "string" }, { "ID": 12226, "Name": "中间计量表号", "DataType": "string" }, { "ID": 12227, "Name": "中间计量节点ID", "DataType": "string" }, { "ID": 12244, "Name": "总合计", "DataType": "string" } ], "动态日期离散参数_集合": [ { "ID": 12229, "Name": "承包人_签字日期", "DataType": "string", "Default_Value": "" }, { "ID": 12230, "Name": "工程管理部_签字日期", "DataType": "string", "Default_Value": "" }, { "ID": 12231, "Name": "经营部_签字日期", "DataType": "string", "Default_Value": "" } ], "电子签名离散指标_集合": [ { "ID": 12164, "Name": "承包人", "DataType": "string" }, { "ID": 12165, "Name": "工程管理部", "DataType": "string" }, { "ID": 12228, "Name": "经营部", "DataType": "string" } ] }