package com.product.server.report.service; import cn.hutool.core.util.IdUtil; import cn.hutool.core.util.NumberUtil; import com.alibaba.fastjson.JSONObject; import com.google.common.collect.Lists; import com.google.common.collect.Maps; import com.google.common.collect.Sets; import com.product.common.lang.StringUtils; import com.product.core.entity.DataTableEntity; import com.product.core.entity.FieldSetEntity; import com.product.core.service.support.AbstractBaseService; import com.product.core.spring.context.SpringMVCContextHolder; import com.product.server.report.config.CmnConst; import com.product.server.report.entity.ReportColumn; import com.product.util.BaseUtil; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Component; import java.util.*; /** * Copyright © 6c * * @Date: 2021-05-11 15:41 * @Author: 6c * @Description: */ @Component public class CommonReportService extends AbstractBaseService { @Autowired private DataListReportService dataListReportService; /** * 报表-解析 * * @param recordDte 业务数据dte * @param totalName 总计名称 * @param reportConfigMap 报表配置缓存map * @param unpivotInfoContainer 行列转换信息 * @return */ public List>[] getReport(DataTableEntity recordDte, String totalName, Map> reportConfigMap, Collection unpivotInfoContainer) { List>[] reportColumnList = new List[]{new ArrayList(), new ArrayList(), new ArrayList()}; // 数据区 Map> headAndTailTitleDataMap = Maps.newHashMap(); List> reportRows = getDataArea(reportConfigMap, headAndTailTitleDataMap, recordDte, totalName, unpivotInfoContainer); int totalColCount = reportConfigMap.get(0).size() + unpivotInfoContainer.size() - 1; // 头部标题区 if (!reportConfigMap.get(1).isEmpty()) { reportColumnList[0] = (dataListReportService.getTitleRows(reportConfigMap.get(1), totalColCount, headAndTailTitleDataMap, "head")); } //如果reportRows 行数大于0将第一行的数据放入头部标题区 if (reportRows.size() >= 0) { reportColumnList[0].add(reportRows.get(0)); reportRows.remove(0); } reportColumnList[1] = reportRows; // 底部标题区 if (!reportConfigMap.get(3).isEmpty()) { reportColumnList[2] = (dataListReportService.getTitleRows(reportConfigMap.get(3), totalColCount, headAndTailTitleDataMap, "tail")); } // reportHtml.append("\n\n") // .append(headTitleHtml == null ? "" : headTitleHtml) // .append(dataAreaHtml) // .append(tailTitleHtml == null ? "" : tailTitleHtml) // .append("\n

\n"); // // JSONObject resultObj = new JSONObject(); // resultObj.put(CmnConst.RETURN_ATTR_RESULT, true); // resultObj.put(CmnConst.RETURN_ATTR_MESSAGE, "获取报表成功！"); // resultObj.put(CmnConst.RETURN_ATTR_HTML, reportHtml); return reportColumnList; } /** * 获取报表数据区html * * @param reportConfigMap 报表缓存map * @param headAndTailTitleDataMap 头部、尾部标题区数据字段map * @param recordDte 业务数据集合 * @param totalName 总计名称，非空-需要总计 * @return */ private List> getDataArea(Map> reportConfigMap, Map> headAndTailTitleDataMap, DataTableEntity recordDte, String totalName, Collection unpivotInfoContainer) { List> reportColumnList = Lists.newArrayList(); // 数据区字段缓存map Map dataAreaFieldConfigMap = dataListReportService.groupAndDataJSONObject2Map(reportConfigMap.get(0)); // 获取指定数据集中包含的数据区字段集合 Set headAndTailFieldSet = Sets.newHashSet(); headAndTailFieldSet.addAll(dataListReportService.getDataFields(reportConfigMap.get(1))); headAndTailFieldSet.addAll(dataListReportService.getDataFields(reportConfigMap.get(3))); // 统计map Map statisticsMap = Maps.newLinkedHashMap(); // 将行列转换的信息添加到数据区字段缓存map里面 Map newDataAreaFieldConfigMap = Maps.newLinkedHashMap(); int x = 0; if (!unpivotInfoContainer.isEmpty()) { for (Map.Entry entry : dataAreaFieldConfigMap.entrySet()) { String fieldName = entry.getKey(); JSONObject fieldConfigObj = entry.getValue(); if (fieldConfigObj.getIntValue(CmnConst.IS_UNPIVOT) == 1) { x = fieldConfigObj.getIntValue(CmnConst.ATTR_X); fieldConfigObj.put(CmnConst.IS_UNPIVOT, 0); fieldConfigObj.put(CmnConst.ATTR_IS_CUSTOM_FIELD, 0); for (String unpivotField : unpivotInfoContainer) { JSONObject newFieldConfigObj = new JSONObject(); newFieldConfigObj.putAll(fieldConfigObj); newFieldConfigObj.put(CmnConst.ATTR_X, ++x); newFieldConfigObj.put(CmnConst.ATTR_SHOW_NAME, newFieldConfigObj.getString(CmnConst.ATTR_SHOW_NAME).replace("{#unpivot_name#}", unpivotField)); newDataAreaFieldConfigMap.put(unpivotField, newFieldConfigObj); } } else { if (x > fieldConfigObj.getIntValue(CmnConst.ATTR_X)) { fieldConfigObj.put(CmnConst.ATTR_X, ++x); } newDataAreaFieldConfigMap.put(fieldName, fieldConfigObj); } } } else { newDataAreaFieldConfigMap = dataAreaFieldConfigMap; } // 标题 reportColumnList.add(getDataAreaTitle(newDataAreaFieldConfigMap)); // 内容 List> dataAreaData = getDataAreaData(newDataAreaFieldConfigMap, recordDte, headAndTailTitleDataMap, headAndTailFieldSet, statisticsMap, totalName); reportColumnList.addAll(dataAreaData); return reportColumnList; } /** * 获取标题 * * @param dataAreaFieldConfigMap 数据区字段缓存map * @return */ private List getDataAreaTitle(Map dataAreaFieldConfigMap) { List columnRow = new ArrayList<>(); dataAreaFieldConfigMap.forEach((dataAreaFieldName, dataAreaFieldConfigObj) -> { ReportColumn column = new ReportColumn(); column.setContent(dataAreaFieldConfigObj.getString(CmnConst.ATTR_SHOW_NAME)); String width = dataAreaFieldConfigObj.getString(CmnConst.ATTR_WIDTH); //判断宽度是否为空并且是数字（正整数和小数都可以） if (StringUtils.isNotBlank(width) && width.matches("^[0-9]+(.[0-9]+)?$")) { //将宽度转换为double类型 column.setColumnWidth(NumberUtil.parseInt(width)); } columnRow.add(column); }); return columnRow; } /** * 获取内容，包含统计 * * @param dataAreaFieldConfigMap 数据区字段缓存map * @param recordDte 业务数据集合 * @param headAndTailFieldSet 头部、尾部标题区字段set * @param statisticsMap 统计map * @param totalName 总计名称 * @return */ private List> getDataAreaData(Map dataAreaFieldConfigMap, DataTableEntity recordDte, Map> headAndTailTitleDataMap, Set headAndTailFieldSet, Map statisticsMap, String totalName) { List> reportColumnList = Lists.newArrayList(); // 数据区分组统计字段名称list List dataAreaGroupStatisticsFieldNameList = Lists.newArrayList(); // 数据区分组字段名称list List dataAreaGroupFieldNameList = Lists.newArrayList(); dataAreaFieldConfigMap.forEach((dataAreaFieldName, dataAreaFieldConfigObj) -> { if ("1".equals(dataAreaFieldConfigObj.getString(CmnConst.ATTR_IS_GROUP))) { dataAreaGroupFieldNameList.add(dataAreaFieldName); if ("1".equals(dataAreaFieldConfigObj.getString(CmnConst.ATTR_IS_STATISTICS))) { dataAreaGroupStatisticsFieldNameList.add(dataAreaFieldName); } } }); // StringBuilder dataAreaDataHtml = new StringBuilder(1024); // StringBuilder curRowHtml = new StringBuilder(256); List curRowColumn = new ArrayList<>(); FieldSetEntity recordFse; FieldSetEntity preFse = null; String dataAreaFieldName; JSONObject dataAreaFieldConfigObj; String value; JSONObject keyObj; Map replaceMap = Maps.newHashMap(); Map dataAreaClosestGroupStatisticsFieldValueMap = Maps.newHashMap(); Map dataAreaClosestGroupFieldValueMap = Maps.newHashMap(); String closestGroupStatisticsFieldName = null; String closestGroupFieldName = null; String tempFieldName; String paramKey; boolean combineFlag; ReportColumn currentColumn = new ReportColumn(); JSONObject dataAreaGroupFieldRecordObj = new JSONObject(); for (int i = 0; i < recordDte.getRows(); i++) { recordFse = recordDte.getFieldSetEntity(i); // 获取头部、尾部标题区数据字段 dataListReportService.getHeadAndTailTitleDataMap(headAndTailTitleDataMap, headAndTailFieldSet, recordFse); // curRowHtml.setLength(0); curRowColumn = new ArrayList<>(); String rowUuid = IdUtil.simpleUUID(); // curRowHtml.append("\n\n "); combineFlag = true; for (Map.Entry entry : dataAreaFieldConfigMap.entrySet()) { dataAreaFieldName = entry.getKey(); dataAreaFieldConfigObj = entry.getValue(); value = dataListReportService.getValue(dataAreaFieldConfigObj, recordFse, dataAreaFieldName); // 若是自定义字段，则放入业务数据记录中 if ("1".equals(dataAreaFieldConfigObj.getString(CmnConst.ATTR_IS_CUSTOM_FIELD))) { recordFse.setValue(dataAreaFieldName, value); } if (dataAreaGroupFieldNameList.contains(dataAreaFieldName)) { int curFieldIndex = dataAreaGroupFieldNameList.indexOf(dataAreaFieldName); // 记录分组字段 recordDataAreaGroupField(dataAreaGroupFieldRecordObj, dataAreaGroupFieldNameList, curFieldIndex, recordFse); // 分组合字段并 closestGroupFieldName = dataAreaFieldName; if (preFse != null && combineFlag) { if (value.equals(dataAreaClosestGroupFieldValueMap.get(closestGroupFieldName))) { dealReplaceMapAddRowspan(replaceMap, dataAreaGroupFieldNameList.subList(0, curFieldIndex + 1), preFse, true); continue; } else { combineFlag = false; } } dataAreaClosestGroupFieldValueMap.put(dataAreaFieldName, value); } // 分组统计 if (dataAreaGroupStatisticsFieldNameList.contains(dataAreaFieldName)) { int minK = dataAreaGroupStatisticsFieldNameList.size(); for (int j = 0; j < dataAreaGroupStatisticsFieldNameList.size(); j++) { tempFieldName = dataAreaGroupStatisticsFieldNameList.get(j); if (!StringUtils.isEmpty(dataAreaClosestGroupStatisticsFieldValueMap.get(tempFieldName)) && !recordFse.getString(tempFieldName).equals(dataAreaClosestGroupStatisticsFieldValueMap.get(tempFieldName))) { minK = j; break; } } for (int k = dataAreaGroupStatisticsFieldNameList.size() - 1; k >= minK; k--) { tempFieldName = dataAreaGroupStatisticsFieldNameList.get(k); if (preFse != null && dataAreaClosestGroupStatisticsFieldValueMap.get(tempFieldName) != null) { reportColumnList.add(getDataAreaGroupStatisticsFieldStatisticsRow(dataAreaClosestGroupStatisticsFieldValueMap.get(tempFieldName), statisticsMap, dataAreaFieldConfigMap, tempFieldName, preFse, dataAreaGroupFieldNameList, replaceMap, dataAreaGroupFieldRecordObj)); dataAreaClosestGroupStatisticsFieldValueMap.remove(tempFieldName); } } closestGroupStatisticsFieldName = dataAreaFieldName; dataAreaClosestGroupStatisticsFieldValueMap.put(dataAreaFieldName, value); } // 非分组统计字段（普通+自定义） if (!"1".equals(dataAreaFieldConfigObj.getString(CmnConst.ATTR_IS_GROUP)) && !StringUtils.isEmpty(dataAreaFieldConfigObj.getString(CmnConst.ATTR_STATISTICS))) { addStatisticsRowInfo(statisticsMap, dataAreaGroupStatisticsFieldNameList, recordFse, dataAreaFieldConfigObj, dataAreaFieldName, value); } // 自定义统计字段（未指定统计类型，使用基础字段公式进行计算） if ("1".equals(dataAreaFieldConfigObj.getString(CmnConst.ATTR_IS_CUSTOM_FIELD)) && StringUtils.isEmpty(dataAreaFieldConfigObj.getString(CmnConst.ATTR_STATISTICS)) && !StringUtils.isEmpty(dataAreaFieldConfigObj.getString(CmnConst.ATTR_FORMULA))) { String formula = dataAreaFieldConfigObj.getString(CmnConst.ATTR_FORMULA); List formFieldList = dataListReportService.getSuitContent(formula, CmnConst.REGEXP_FORM_FIELD); Map formulaMap = Maps.newHashMap(); boolean statisticsFlag = true; JSONObject tempObj; for (String formFieldInfo : formFieldList) { tempObj = dataAreaFieldConfigMap.get(dataListReportService.fieldInfo2FieldName(formFieldInfo)); if (tempObj == null || StringUtils.isEmpty(tempObj.getString(CmnConst.ATTR_STATISTICS))) { statisticsFlag = false; break; } formulaMap.put(formFieldInfo, tempObj.getString(CmnConst.ATTR_STATISTICS)); } if (statisticsFlag) { addStatisticsRowInfo(statisticsMap, dataAreaGroupStatisticsFieldNameList, recordFse, dataAreaFieldConfigObj, dataAreaFieldName, value, formulaMap); } } if ("1".equals(dataAreaFieldConfigObj.getString(CmnConst.ATTR_IS_GROUP))) { keyObj = new JSONObject(); for (String dataAreaGroupFieldName : dataAreaGroupFieldNameList) { keyObj.put(dataAreaGroupFieldName, recordFse.getString(dataAreaGroupFieldName)); if (dataAreaGroupFieldName.equals(dataAreaFieldName)) { keyObj.put(CmnConst.ATTR_FIELD_INFO, dataListReportService.fieldName2FieldInfo(dataAreaGroupFieldName)); break; } } paramKey = dataListReportService.concat(keyObj, CmnConst.ATTR_ROWSPAN); // curRowHtml.append(" suitFieldList = BaseUtil.getSuitContent(urlParam, "\\{#\\w+#\\}"); for (String singleSuitFieldName : suitFieldList) { attrParam = singleSuitFieldName.substring(2, singleSuitFieldName.length() - 2); currentColumn.addProperty(attrParam, recordFse.getString(attrParam)); // curRowHtml.append(" ").append(attrParam).append("=\"").append(recordFse.getString(attrParam)).append("\""); } } // curRowHtml.append(">"); // 格式 value = dataListReportService.formatValue(dataAreaFieldConfigObj, value); // curRowHtml.append(value == null ? "" : value); // curRowHtml.append(""); currentColumn.setContent(value); curRowColumn.add(currentColumn); currentColumn = new ReportColumn(); } // curRowHtml.append("\n"); // dataAreaDataHtml.append(curRowHtml); reportColumnList.add(curRowColumn); preFse = recordFse; } // 补全末尾统计 if (!StringUtils.isEmpty(closestGroupStatisticsFieldName)) { int maxK = -1; for (int j = 0; j < dataAreaGroupStatisticsFieldNameList.size(); j++) { tempFieldName = dataAreaGroupStatisticsFieldNameList.get(j); if (closestGroupStatisticsFieldName.equals(tempFieldName)) { maxK = j; } } for (int k = maxK; k >= 0; k--) { tempFieldName = dataAreaGroupStatisticsFieldNameList.get(k); if (preFse != null) { reportColumnList.add(getDataAreaGroupStatisticsFieldStatisticsRow(dataAreaClosestGroupStatisticsFieldValueMap.get(tempFieldName), statisticsMap, dataAreaFieldConfigMap, tempFieldName, preFse, dataAreaGroupFieldNameList, replaceMap, dataAreaGroupFieldRecordObj)); } } } // 总计 if (!StringUtils.isEmpty(totalName)) { List reportColumns = getDataAreaTotalStatisticsRow(statisticsMap, dataAreaFieldConfigMap, dataAreaGroupFieldNameList, preFse, dataAreaGroupFieldRecordObj, totalName); if (reportColumns != null && reportColumns.size() > 0) { reportColumnList.add(reportColumns); } } //循环所有的column进行参数替换 for (List reportColumns : reportColumnList) { if (reportColumns != null) { for (ReportColumn reportColumn : reportColumns) { if (reportColumn != null) { for (Map.Entry entry : replaceMap.entrySet()) { reportColumn.replace(entry.getKey(), entry.getValue()); } } } } } return reportColumnList; } /** * 添加分组统计信息 * * @param statisticsMap 统计map * @param dataAreaGroupStatisticsFieldNameList 数据区分组统计字段名称list * @param recordFse 业务数据fse * @param dataAreaFieldConfigObj 数据区字段obj * @param dataAreaFieldName 数据区字段名称 * @param value 值 * @param formulaMap 公式map，字段info和统计类型的映射 */ private void addStatisticsRowInfo(Map statisticsMap, List dataAreaGroupStatisticsFieldNameList, FieldSetEntity recordFse, JSONObject dataAreaFieldConfigObj, String dataAreaFieldName, String value, Map formulaMap) { JSONObject keyObj = new JSONObject(); keyObj.put(CmnConst.ATTR_FIELD_INFO, dataListReportService.fieldName2FieldInfo(dataAreaFieldName)); String statisticsType = dataAreaFieldConfigObj.getString(CmnConst.ATTR_STATISTICS); if (StringUtils.isEmpty(statisticsType) && "1".equals(dataAreaFieldConfigObj.getString(CmnConst.ATTR_IS_STATISTICS))) { statisticsType = CmnConst.ATTR_STATISTICS_DEFAULT; } String statisticsValue; String formula = dataAreaFieldConfigObj.getString(CmnConst.ATTR_FORMULA); JSONObject formulaFieldKeyObj = new JSONObject(); // 总计 JSONObject cloneKeyObj = (JSONObject) keyObj.clone(); JSONObject valueObj = statisticsMap.computeIfAbsent(cloneKeyObj, k -> new JSONObject()); statisticsValue = getStatisticsValue(statisticsMap, formulaMap, formulaFieldKeyObj, formula, value); statisticsMap.put(keyObj, dataListReportService.getStatisticsValueObj(valueObj, dataAreaFieldConfigObj, statisticsValue, statisticsType, true)); // 分组统计 for (String dataAreaGroupStatisticsFieldName : dataAreaGroupStatisticsFieldNameList) { keyObj.put(dataAreaGroupStatisticsFieldName, recordFse.getString(dataAreaGroupStatisticsFieldName)); formulaFieldKeyObj.put(dataAreaGroupStatisticsFieldName, recordFse.getString(dataAreaGroupStatisticsFieldName)); cloneKeyObj = (JSONObject) keyObj.clone(); valueObj = statisticsMap.computeIfAbsent(cloneKeyObj, k -> new JSONObject()); statisticsValue = getStatisticsValue(statisticsMap, formulaMap, formulaFieldKeyObj, formula, value); statisticsMap.put(keyObj, dataListReportService.getStatisticsValueObj(valueObj, dataAreaFieldConfigObj, statisticsValue, statisticsType, true)); } } private void addStatisticsRowInfo(Map statisticsMap, List dataAreaGroupStatisticsFieldNameList, FieldSetEntity recordFse, JSONObject dataAreaFieldConfigObj, String dataAreaFieldName, String value) { addStatisticsRowInfo(statisticsMap, dataAreaGroupStatisticsFieldNameList, recordFse, dataAreaFieldConfigObj, dataAreaFieldName, value, null); } /** * 获取统计行的公式计算值 * * @param statisticsMap 统计map * @param formulaMap 公式map * @param formulaFieldKeyObj 公式字段keyobj * @param formula 公式 * @param value 原本的值 * @return */ private String getStatisticsValue(Map statisticsMap, Map formulaMap, JSONObject formulaFieldKeyObj, String formula, String value) { String statisticsValue = ""; String formulaFieldValue; if (formulaMap != null && !formulaMap.isEmpty()) { for (Map.Entry entry : formulaMap.entrySet()) { formulaFieldKeyObj.put(CmnConst.ATTR_FIELD_INFO, entry.getKey()); formulaFieldValue = statisticsMap.get(formulaFieldKeyObj).getString(entry.getValue()); if (formulaFieldValue != null && formulaFieldValue.matches(CmnConst.REGEXP_NUMBER)) { formulaFieldValue += "d"; } formula = formula.replace(entry.getKey(), StringUtils.isEmpty(formulaFieldValue) ? "" : formulaFieldValue); } try { statisticsValue = BaseUtil.executeExpression(formula, Maps.newHashMap()).toString(); } catch (Exception e) { SpringMVCContextHolder.getSystemLogger().error(e); statisticsValue = ""; } } return StringUtils.isEmpty(statisticsValue) ? value : statisticsValue; } /** * 获取数据区分组统计字段统计行html * * @param waitStatisticsValue 待统计的值 * @param statisticsMap 统计map * @param dataAreaFieldConfigMap 数据区字段缓存map * @param tempFieldName 本次操作的字段名称 * @param recordFse 业务数据记录 * @param dataAreaGroupFieldNameList 数据区分组字段名称list * @param replaceMap 替换map * @param dataAreaGroupFieldRecordObj 数据区分组字段记录obj * @return */ private List getDataAreaGroupStatisticsFieldStatisticsRow(String waitStatisticsValue, Map statisticsMap, Map dataAreaFieldConfigMap, String tempFieldName, FieldSetEntity recordFse, List dataAreaGroupFieldNameList, Map replaceMap, JSONObject dataAreaGroupFieldRecordObj) { List columnRow = new ArrayList<>(); String dataAreaFieldName; JSONObject dataAreaFieldConfigObj; boolean flag = false; JSONObject keyObj = new JSONObject(); String value; String statisticsType; int index = 0; List needAddRowspanDataAreaGroupFieldNameList = Lists.newArrayList(); for (Map.Entry entry : dataAreaFieldConfigMap.entrySet()) { index++; dataAreaFieldName = entry.getKey(); if (!flag) { if (dataAreaGroupFieldNameList.contains(dataAreaFieldName)) { keyObj.put(dataAreaFieldName, recordFse.getString(dataAreaFieldName)); if (dataAreaFieldName.equals(tempFieldName)) { ReportColumn column = new ReportColumn(); column.setColspan(dataAreaGroupFieldNameList.size() - index + 1); column.setContent(waitStatisticsValue); // html.append("").append(waitStatisticsValue).append(CmnConst.STATISTICS_NAME).append(""); flag = true; columnRow.add(column); } if (!flag) { needAddRowspanDataAreaGroupFieldNameList.add(dataAreaFieldName); } } } else { dataAreaFieldConfigObj = entry.getValue(); statisticsType = dataAreaFieldConfigObj.getString(CmnConst.ATTR_STATISTICS); if (!"1".equals(dataAreaFieldConfigObj.getString(CmnConst.ATTR_IS_CUSTOM_FIELD)) && StringUtils.isEmpty(statisticsType)) { if (!"1".equals(dataAreaFieldConfigObj.getString(CmnConst.ATTR_IS_GROUP))) { // html.append(""); columnRow.add(new ReportColumn()); } } else { keyObj.put(CmnConst.ATTR_FIELD_INFO, dataListReportService.fieldName2FieldInfo(dataAreaFieldName)); if (statisticsMap.get(keyObj) == null) { value = ""; } else { JSONObject valueObj = statisticsMap.get(keyObj); if (StringUtils.isEmpty(statisticsType)) { statisticsType = CmnConst.ATTR_STATISTICS_DEFAULT; } if (CmnConst.ATTR_STATISTICS_AVG.equals(statisticsType) && "1".equals(dataAreaFieldConfigObj.getString(CmnConst.ATTR_AVG_TYPE))) { int subCnt = getAimSubCnt(keyObj, dataAreaGroupFieldNameList, dataAreaGroupFieldRecordObj); valueObj.put(CmnConst.ATTR_STATISTICS_SUB_CNT, subCnt); dataListReportService.getAvgValue(valueObj, dataAreaFieldConfigObj, false); } value = valueObj.getString(statisticsType); } // 格式 value = dataListReportService.formatValue(dataAreaFieldConfigObj, value); // html.append("").append(value == null ? "" : value).append(""); columnRow.add(new ReportColumn(value == null ? "" : value)); } } } dealReplaceMapAddRowspan(replaceMap, needAddRowspanDataAreaGroupFieldNameList, recordFse, false); return columnRow; } /** * 获取总计html * * @param statisticsMap 统计map * @param dataAreaFieldConfigMap 数据区字段缓存map * @param dataAreaGroupFieldNameList 数据区分组字段名称list * @param preFse 最近操作的数据fse * @param dataAreaGroupFieldRecordObj 数据区分组字段记录obj * @param totalName 总计名称 * @return */ private List getDataAreaTotalStatisticsRow(Map statisticsMap, Map dataAreaFieldConfigMap, List dataAreaGroupFieldNameList, FieldSetEntity preFse, JSONObject dataAreaGroupFieldRecordObj, String totalName) { List reportColumns = new ArrayList<>(); String dataAreaFieldName; JSONObject dataAreaFieldConfigObj; String value; JSONObject keyObj = new JSONObject(); String statisticsType; // html.append("\n\n "); if (preFse == null) { return null; } int index = 0; for (Map.Entry entry : dataAreaFieldConfigMap.entrySet()) { index++; dataAreaFieldName = entry.getKey(); if (!dataAreaGroupFieldNameList.contains(dataAreaFieldName)) { dataAreaFieldConfigObj = entry.getValue(); statisticsType = dataAreaFieldConfigObj.getString(CmnConst.ATTR_STATISTICS); keyObj.put(CmnConst.ATTR_FIELD_INFO, dataAreaFieldConfigObj.getString(CmnConst.ATTR_FIELD_INFO)); if ((!"1".equals(dataAreaFieldConfigObj.getString(CmnConst.ATTR_IS_CUSTOM_FIELD)) && StringUtils.isEmpty(statisticsType)) || statisticsMap.get(keyObj) == null) { value = ""; } else { JSONObject valueObj = statisticsMap.get(keyObj); if (StringUtils.isEmpty(statisticsType)) { statisticsType = CmnConst.ATTR_STATISTICS_DEFAULT; } if (CmnConst.ATTR_STATISTICS_AVG.equals(statisticsType) && "1".equals(dataAreaFieldConfigObj.getString(CmnConst.ATTR_AVG_TYPE))) { int subCnt = dataAreaGroupFieldRecordObj.size(); valueObj.put(CmnConst.ATTR_STATISTICS_SUB_CNT, subCnt); dataListReportService.getAvgValue(valueObj, dataAreaFieldConfigObj, false); } value = valueObj.getString(statisticsType); } // 格式 value = dataListReportService.formatValue(dataAreaFieldConfigObj, value); reportColumns.add(new ReportColumn(value == null ? "" : value)); } else { if (index == 1) { ReportColumn column = new ReportColumn(); column.setColspan(dataAreaGroupFieldNameList.size()); column.setContent(totalName); reportColumns.add(column); } } } return reportColumns; } /** * 处理参数替换map-添加数据区分组字段的占行 * * @param replaceMap 替换map * @param needAddRowspanDataAreaGroupFieldNames 需要添加占行的数据区分组字段名称集合 * @param recordFse 业务数据记录 */ private void dealReplaceMapAddRowspan(Map replaceMap, Collection needAddRowspanDataAreaGroupFieldNames, FieldSetEntity recordFse, boolean commonFieldFlag) { JSONObject keyObj = new JSONObject(); String value; int rowspan; String paramKey; int index = 0; for (String fieldName : needAddRowspanDataAreaGroupFieldNames) { index++; keyObj.put(fieldName, recordFse.getString(fieldName)); if (commonFieldFlag && index != needAddRowspanDataAreaGroupFieldNames.size()) { continue; } keyObj.put(CmnConst.ATTR_FIELD_INFO, dataListReportService.fieldName2FieldInfo(fieldName)); paramKey = dataListReportService.concat(keyObj, CmnConst.ATTR_ROWSPAN); value = replaceMap.get(paramKey); rowspan = StringUtils.isEmpty(value) ? 1 : Integer.parseInt(value) + 1; replaceMap.put(paramKey, String.valueOf(rowspan)); } } /** * 记录分组字段 * * @param dataAreaGroupFieldRecordObj 数据区分组字段记录obj * @param dataAreaGroupFieldNameList 数据区分组字段名称list * @param curFieldIndex 当前字段下标 * @param recordFse 业务数据记录 */ private void recordDataAreaGroupField(JSONObject dataAreaGroupFieldRecordObj, List dataAreaGroupFieldNameList, int curFieldIndex, FieldSetEntity recordFse) { String tempFieldName; JSONObject parentObj = dataAreaGroupFieldRecordObj; JSONObject subObj; String value; for (int j = 0; j <= curFieldIndex; j++) { tempFieldName = dataAreaGroupFieldNameList.get(j); value = recordFse.getString(tempFieldName); subObj = parentObj.getJSONObject(value); if (subObj == null) { subObj = new JSONObject(); parentObj.put(value, subObj); } parentObj = subObj; } } /** * 获取指定的下级分组项 * * @param keyObj 指定的key * @param dataAreaGroupFieldNameList 数据区分组字段名称list * @param dataAreaGroupFieldRecordObj 数据区分组字段记录obj * @return */ private int getAimSubCnt(JSONObject keyObj, List dataAreaGroupFieldNameList, JSONObject dataAreaGroupFieldRecordObj) { String value; JSONObject parentObj = dataAreaGroupFieldRecordObj; JSONObject subObj = null; for (String fieldName : dataAreaGroupFieldNameList) { value = keyObj.getString(fieldName); if (value != null) { subObj = parentObj.getJSONObject(value); } else { break; } parentObj = subObj; } return subObj == null ? 0 : subObj.size(); } }