{ "ID_KEY": "DUMMY_FLOW_SAMPLE", "GROUP_KEY": "RPT_B25 变更台帐汇总表_SAMPLE_TPL", "主信息": { "单位": "厘米", "版本": { "主版本": "3", "功能版本": "0" }, "页边距": { "Top": "1.0", "Left": "1.0", "Right": "1.0", "Bottom": "1.0" }, "报表名称": "B25 变更台帐汇总表", "打印页面_信息": { "方向": "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.86", "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_analyzing", "expression": "let XMJcode = $JE.F(2509,$CURRENT_RPT);\nlet chkField = $JE.F(2510,$CURRENT_RPT);\nlet XMJname = $JE.F(2511,$CURRENT_RPT);\nlet Endtotalprice = $JE.F(2546,$CURRENT_RPT);\n\nlet ledgerBillsCodeField= $JE.F(1200,$CURRENT_RPT);\n\nlet newXMJcode= $JE.F(12128,$CURRENT_RPT);\nlet newXMJname= $JE.F(12129,$CURRENT_RPT);\nlet newEND= $JE.F(12130,$CURRENT_RPT);\nlet Xhao= $JE.F(12131,$CURRENT_RPT);\n\nlet fLen0 = $JE.getFieldDataLen(ledgerBillsCodeField, $CURRENT_DATA);\nlet fLen1 = $JE.getFieldDataLen(XMJcode, $CURRENT_DATA);\n\n\nconsole.log($CURRENT_DATA);\n//console.log(fLen0);\nlet codeArrt=[];\n\n//获取清单所属章节\nfor (let chkIdx = 0; chkIdx < fLen0; chkIdx++) {\n let bCode = $JE.getFieldValue(ledgerBillsCodeField, $CURRENT_DATA, chkIdx, '');\n let firstIdx = bCode.indexOf('-');\n\tif (firstIdx === 3) {\n\t let first=bCode.substring(0,1)*100; \n\t codeArrt.push(first);\n\t}else if (firstIdx === 4) {\n\t let LW=bCode.substring(0,2)*100; \n\t codeArrt.push(LW);\n\t}\n\n}\nlet newXMJ=[];\nlet newXMN=[];\nlet newTP=[];\nfor(let K = 0;K < fLen1;K++){\t\t\nlet XMcode = $JE.getFieldValue(XMJcode,$CURRENT_DATA,K,'');\nlet XMname = $JE.getFieldValue(XMJname,$CURRENT_DATA,K,'');\nlet TP = $JE.getFieldValue(Endtotalprice, $CURRENT_DATA, K, '');\n if(XMcode>700 && XMcode !== ''){\t\n //console.log('判断前',XMcode);\n for(let X = 0; X < codeArrt.length; X++){\n if(XMcode==codeArrt[X]){\n newXMJ.push(XMcode+'章');\n newXMN.push(XMname);\n\t\t newTP.push(TP);\n\t\t break;\t \n\t }\n }\n }\n else if(XMcode !== ''){\n\t\tnewXMJ.push(XMcode+'章');\n newXMN.push(XMname);\n\t\tnewTP.push(TP);\n }\n}\n\nfunction sortBy(field1,field2) {\n\tfor(let i=0;i 0) {\n\tfor (let ix = 1; ix <= diff; ix++) {\n\t\t$JE.removeFieldValue(chkField, $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(chkField, $CURRENT_DATA, dtlLen + ix, 0);\n\t}\n}\t\n\n\n\n\n", "format": "" } ], "流水式表_信息": { "离散信息": [ { "BandName": "TitleBand", "text_s": [ { "Label": "B25 变更台帐汇总表", "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": "29.99", "Top": 0, "Bottom": "50", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "FieldID": 1101, "font": "Header", "control": "Header", "style": "Default_None", "Prefix": "建设项目：", "isAutoHeight": false, "area": { "Left": "29.99", "Right": "75.55", "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": "29.99", "Top": "50", "Bottom": "100", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "FieldID": 1102, "font": "Header", "control": "Header", "style": "Default_None", "Prefix": "合同号：", "isAutoHeight": false, "area": { "Left": "75.55", "Right": "100.00", "Top": "0", "Bottom": "50", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "FieldID": 1300, "font": "Content", "control": "Header", "style": "Default_None", "Prefix": "编 号：", "isAutoHeight": false, "area": { "Left": "75.55", "Right": "100.00", "Top": "50", "Bottom": "100", "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": "9.26", "Top": 0, "Bottom": "100.00", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "Label": "变更金额（±）（元）", "font": "Content", "control": "Column", "style": "Default_Normal", "Title": "", "area": { "Left": "51.00", "Right": "100.00", "Top": 0, "Bottom": "50.00", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "Label": "（3）", "font": "Content", "control": "Column", "style": "Default_Normal", "Title": "", "area": { "Left": "51.00", "Right": "100.00", "Top": "50.00", "Bottom": "100.00", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "Label": "章 次", "font": "Content", "control": "Column", "style": "Default_Normal", "Title": "", "area": { "Left": "9.26", "Right": "29.99", "Top": 0, "Bottom": "50.00", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "Label": "科目名称", "font": "Content", "control": "Column", "style": "Default_Normal", "Title": "", "area": { "Left": "29.99", "Right": "51.00", "Top": 0, "Bottom": "50.00", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "Label": "（1）", "font": "Content", "control": "Column", "style": "Default_Normal", "Title": "", "area": { "Left": "9.26", "Right": "29.99", "Top": "50.00", "Bottom": "100.00", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "Label": "（2）", "font": "Content", "control": "Column", "style": "Default_Normal", "Title": "", "area": { "Left": "29.99", "Right": "51.00", "Top": "50.00", "Bottom": "100.00", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } } ] }, "多列显示数量": 1, "流水式表_数据": { "BandName": "ContentBand", "CommonHeight": "1.43", "flow_field_s": [ { "FieldID": 12128, "font": "Content", "control": "Column", "style": "Default_Normal", "isAutoHeight": false, "combineType": "horizon", "area": { "Left": "9.26", "Right": "29.99", "Top": 0, "Bottom": "100.00", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "FieldID": 12129, "font": "Content", "control": "Column", "style": "Default_Normal", "isAutoHeight": false, "combineType": "horizon", "area": { "Left": "29.99", "Right": "51.00", "Top": 0, "Bottom": "100.00", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "FieldID": 12130, "font": "Content", "control": "Column", "style": "Default_Normal", "isAutoHeight": false, "area": { "Left": "51.00", "Right": "100.00", "Top": 0, "Bottom": "100.00", "H_CalculationType": "percentage", "V_CalculationType": "percentage" } }, { "FieldID": 12131, "font": "Content", "control": "Column", "style": "Default_Normal", "isAutoHeight": false, "area": { "Left": 0, "Right": "9.26", "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": 1134, "Name": "标段_标段清单_承包单位1_单位名称", "DataType": "string", "TableName": "tender_info", "mapExpression": "$PROJECT.REPORT.getProperty(\"tender_info\", \"construction_unit.contract1.company\")", "descr": "", "Title": "ID: 1134" }, { "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": 1140, "Name": "标段_标段清单_监理单位1_单位名称", "DataType": "string", "TableName": "tender_info", "mapExpression": "$PROJECT.REPORT.getProperty(\"tender_info\", \"construction_unit.supervision1.company\")", "descr": "", "Title": "ID: 1140" } ], "主数据指标_集合": [], "从数据指标_集合": [ { "ID": 2510, "Name": "清单编号", "DataType": "string", "TableName": "mem_stage_bills", "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'b_code')", "descr": "", "Title": "ID: 2510" }, { "ID": 2509, "Name": "项目节编号", "DataType": "string", "TableName": "mem_stage_bills", "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'code')", "descr": "", "Title": "ID: 2509" }, { "ID": 2508, "Name": "树结构-是否子项", "DataType": "int", "TableName": "mem_stage_bills", "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'is_leaf')", "descr": "", "Title": "ID: 2508" }, { "ID": 2511, "Name": "名称", "DataType": "string", "TableName": "mem_stage_bills", "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'name')", "descr": "", "Title": "ID: 2511" }, { "ID": 2548, "Name": "截止本期-完成-金额", "DataType": "currency", "TableName": "mem_stage_bills", "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'end_gather_tp')", "descr": "", "Title": "ID: 2548" }, { "ID": 1200, "Name": "台账清单信息_清单编号", "DataType": "string", "TableName": "ledger", "mapExpression": "$PROJECT.REPORT.getProperty(\"ledger\", \"b_code\")", "descr": "", "Title": "ID: 1200" }, { "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')" } }, { "ID": 2540, "Name": "截止上期-数量变更-金额(pre_qc_tp)", "DataType": "currency", "TableName": "mem_stage_bills", "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'pre_qc_tp')", "descr": "", "Title": "ID: 2540", "Precision": { "type": "fixed", "fixedMapExpression": "$PROJECT.REPORT.getProperty('tender_info', 'decimal.tp')" } }, { "ID": 2533, "Name": "本期-数量变更-金额(qc_tp)", "DataType": "currency", "TableName": "mem_stage_bills", "mapExpression": "$PROJECT.REPORT.getProperty('mem_stage_bills', 'qc_tp')", "descr": "", "Title": "ID: 2533", "Precision": { "type": "fixed", "fixedMapExpression": "$PROJECT.REPORT.getProperty('tender_info', 'decimal.tp')" } } ], "主数据指标_拓展集合": [], "从数据指标_拓展集合": [] }, "映射数据预处理": [ { "预处理类型": "指定方式", "映射数据对象": "", "方式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": 2508 }, { "Name": "清单编号", "FieldID": 2510 } ], "自定义设置": "{\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": 12128, "Name": "章节编号", "DataType": "string" }, { "ID": 12129, "Name": "章节名称", "DataType": "string" }, { "ID": 12130, "Name": "章节金额", "DataType": "string" }, { "ID": 12131, "Name": "新序号", "DataType": "string" }, { "ID": 12132, "Name": "合计序号", "DataType": "string" } ], "动态日期离散参数_集合": [ { "ID": 12133, "Name": "新动态日期离散参数", "DataType": "string", "Default_Value": "" } ], "电子签名离散指标_集合": [ { "ID": 12170, "Name": "承包人", "DataType": "string" }, { "ID": 12171, "Name": "监理员", "DataType": "string" }, { "ID": 12172, "Name": "监理组组长", "DataType": "string" }, { "ID": 12173, "Name": "业主（业主代表）", "DataType": "string" } ] }