{ "ID_KEY": "DUMMY_FLOW_SAMPLE", "GROUP_KEY": "RPT_B25.1 变更台帐分表一_SAMPLE_TPL", "主信息": { "单位": "厘米", "版本": { "主版本": "3", "功能版本": "0" }, "页边距": { "Top": "1.0", "Left": "1.0", "Right": "1.0", "Bottom": "1.0" }, "报表名称": "B25.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": "3.20", "Name": "ColumnBand", "control": "Default", "style": "Default_None", "MergeBorder": "F" }, { "Alignment": "Bottom", "DisplayType": "SegmentEnd", "Height": "1.11", "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": "\nlet KBnull = $JE.F(1199,$CURRENT_RPT);\nlet BGJEnull = $JE.F(1099,$CURRENT_RPT);\n\nlet LJJEnull = $JE.F(1699,$CURRENT_RPT);\nlet BTJEnull = $JE.F(1899,$CURRENT_RPT);\n\nlet chapterAllNo=$JE.F(1132,$CURRENT_RPT);\nlet chapterAllName=$JE.F(1133,$CURRENT_RPT);\n\nlet chapterBCNo = $JE.F(2552,$CURRENT_RPT);\nlet chapterBCode=$JE.F(2510,$CURRENT_RPT);\n\nlet EndTP = $JE.F(2548,$CURRENT_RPT);\nlet EndQT = $JE.F(2546,$CURRENT_RPT);\n\nlet NewKBnull = $JE.F(1138,$CURRENT_RPT);\n\nlet fLen1=$JE.getFieldDataLen(chapterBCode, $CURRENT_DATA);\n\nlet chapterBCNoArr=$JE.getFieldValueArray(chapterBCode,$CURRENT_DATA);\nlet AllNameArray = $JE.getFieldValue(chapterAllName, $CURRENT_DATA, 0, 0);\nlet AllNameArrNO = $JE.getFieldValue(chapterAllNo, $CURRENT_DATA, 0, 0);\n\nfor(let j=0; j< fLen1;j++){\n\tlet chapterCode=$CTX_HELPER.getChapterCode(chapterBCNoArr[j], '-');\n\tconsole.log('清单编号:%s,章节号:%s',chapterCode,chapterCode);\n\tlet tempno=$JE.getFieldValue(chapterBCNo, $CURRENT_DATA, j, '');\n\tconsole.log('主数',tempno);\n\tif(tempno===null || tempno==='' || tempno==10000){\n\t\tif(chapterCode===null || chapterCode==='' || chapterCode==10000){\n\t\t\tconsole.log('我是未计入章节');\n\t\t\t$JE.setFieldValue(chapterBCNo, $CURRENT_DATA, j, '其他');\n\t\t}else{\n\t\t\tconsole.log('我是签约清单');\n\t\t\t$JE.setFieldValue(chapterBCNo, $CURRENT_DATA, j, chapterCode);\n\t\t\tconsole.log('主数据1',chapterCode);\n\t\t}\t\t\n\t} \n\t\n} \n\nlet chapterNoArr=$JE.getFieldValueArray(chapterBCNo,$CURRENT_DATA);\n\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\n//调用方法\nlet uniqueChapArr=unique(chapterNoArr);\n\nconsole.log('我是去重后',uniqueChapArr);\nconsole.log('我是去重前',chapterNoArr);\nconsole.log('我是编号',AllNameArrNO);\n//console.log('我是名称',AllNameArray);\n\nfor(let i=0;i