package com.product.server.report.service;
|
|
import cn.hutool.core.collection.CollectionUtil;
|
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.server.report.entity.ReportEntity;
|
import com.product.util.BaseUtil;
|
import com.product.util.SystemParamReplace;
|
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 totalStatisticsFlag 是否合计标识
|
* @param reportConfigMap 报表配置缓存map
|
* @param tableStyle
|
* @return
|
*/
|
public ReportEntity getReportEntity(DataTableEntity recordDte, String totalName, Map<Integer, List<JSONObject>> reportConfigMap) {
|
ReportEntity report = null;
|
Map<String, Set<String>> headAndTailTitleDataMap = Maps.newHashMap();
|
// 数据区
|
report = getDataArea(reportConfigMap, headAndTailTitleDataMap, recordDte, totalName);
|
|
int totalColCount = reportConfigMap.get(0).size();
|
|
// 头部标题区
|
List<List<ReportColumn>> headTitleRows = null;
|
if (!reportConfigMap.get(1).isEmpty()) {
|
headTitleRows = dataListReportService.getTitle(reportConfigMap.get(1), totalColCount, headAndTailTitleDataMap, "head");
|
}
|
// 底部标题区
|
List<List<ReportColumn>> tailTitleRows = null;
|
if (!reportConfigMap.get(3).isEmpty()) {
|
tailTitleRows = dataListReportService.getTitle(reportConfigMap.get(3), totalColCount, headAndTailTitleDataMap, "tail");
|
}
|
|
if (!CollectionUtil.isEmpty(headTitleRows)) {
|
List<List<ReportColumn>> reportHeader = report.getReportHeader();
|
headTitleRows.addAll(reportHeader);
|
report.setReportHeader(headTitleRows);
|
}
|
if (!CollectionUtil.isEmpty(tailTitleRows)) {
|
report.setReportTail(tailTitleRows);
|
}
|
|
|
return report;
|
}
|
|
/**
|
* 报表-解析
|
*
|
* @param recordDte 业务数据dte
|
* @param totalStatisticsFlag 是否合计标识
|
* @param reportConfigMap 报表配置缓存map
|
* @param tableStyle
|
* @return
|
*/
|
public JSONObject getReport(DataTableEntity recordDte, String totalName, Map<Integer, List<JSONObject>> reportConfigMap, StringBuilder tableStyle) {
|
StringBuilder reportHtml = new StringBuilder(4096);
|
|
// css
|
StringBuilder cssHtml = dataListReportService.getCssHtml();
|
|
// 数据区
|
Map<String, Set<String>> headAndTailTitleDataMap = Maps.newHashMap();
|
String dataAreaHtml = getDataAreaHtml(reportConfigMap, headAndTailTitleDataMap, recordDte, totalName);
|
|
int totalColCount = reportConfigMap.get(0).size();
|
// 头部标题区
|
StringBuilder headTitleHtml = null;
|
if (!reportConfigMap.get(1).isEmpty()) {
|
headTitleHtml = dataListReportService.getTitleHtml(reportConfigMap.get(1), totalColCount, headAndTailTitleDataMap, "head");
|
}
|
|
// 底部标题区
|
StringBuilder tailTitleHtml = null;
|
if (!reportConfigMap.get(3).isEmpty()) {
|
tailTitleHtml = dataListReportService.getTitleHtml(reportConfigMap.get(3), totalColCount, headAndTailTitleDataMap, "tail");
|
}
|
|
reportHtml.append("\n<body>\n<table class=\"report_main\"").append(tableStyle).append(">")
|
.append(cssHtml)
|
.append(headTitleHtml == null ? "" : headTitleHtml)
|
.append(dataAreaHtml)
|
.append(tailTitleHtml == null ? "" : tailTitleHtml)
|
.append("\n</table>\n</body>");
|
|
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 resultObj;
|
}
|
|
/**
|
* 获取报表数据区html
|
*
|
* @param reportConfigMap 报表缓存map
|
* @param headAndTailTitleDataMap 头部、尾部标题区数据字段map
|
* @param recordDte 业务数据集合
|
* @param totalName 总计名称，非空-需要总计
|
* @return
|
*/
|
private String getDataAreaHtml(Map<Integer, List<JSONObject>> reportConfigMap, Map<String, Set<String>> headAndTailTitleDataMap, DataTableEntity recordDte, String totalName) {
|
// 数据区字段缓存map
|
Map<String, JSONObject> dataAreaFieldConfigMap = dataListReportService.groupAndDataJSONObject2Map(reportConfigMap.get(0));
|
// 获取指定数据集中包含的数据区字段集合
|
Set<String> headAndTailFieldSet = Sets.newHashSet();
|
headAndTailFieldSet.addAll(dataListReportService.getDataFields(reportConfigMap.get(1)));
|
headAndTailFieldSet.addAll(dataListReportService.getDataFields(reportConfigMap.get(3)));
|
// 统计map
|
Map<JSONObject, JSONObject> statisticsMap = Maps.newLinkedHashMap();
|
|
StringBuilder dataAreaHtml = new StringBuilder(1024);
|
// 标题
|
dataAreaHtml.append(getDataAreaTitleHtml(dataAreaFieldConfigMap));
|
// 内容
|
dataAreaHtml.append(getDataAreaDataHtml(dataAreaFieldConfigMap, recordDte, headAndTailTitleDataMap, headAndTailFieldSet, statisticsMap, totalName));
|
return dataAreaHtml.toString();
|
}
|
|
private ReportEntity getDataArea(Map<Integer, List<JSONObject>> reportConfigMap, Map<String, Set<String>> headAndTailTitleDataMap, DataTableEntity recordDte, String totalName) {
|
// 数据区字段缓存map
|
Map<String, JSONObject> dataAreaFieldConfigMap = dataListReportService.groupAndDataJSONObject2Map(reportConfigMap.get(0));
|
// 获取指定数据集中包含的数据区字段集合
|
Set<String> headAndTailFieldSet = Sets.newHashSet();
|
headAndTailFieldSet.addAll(dataListReportService.getDataFields(reportConfigMap.get(1)));
|
headAndTailFieldSet.addAll(dataListReportService.getDataFields(reportConfigMap.get(3)));
|
// 统计map
|
Map<JSONObject, JSONObject> statisticsMap = Maps.newLinkedHashMap();
|
List<ReportColumn> reportHeader = getReportHeader(dataAreaFieldConfigMap);
|
List<List<ReportColumn>> reportData = getReportData(dataAreaFieldConfigMap, recordDte, headAndTailTitleDataMap, headAndTailFieldSet, statisticsMap, totalName);
|
ReportEntity report = new ReportEntity();
|
report.addReportHeader(reportHeader);
|
report.setReportData(reportData);
|
return report;
|
}
|
|
private List<ReportColumn> getReportHeader(Map<String, JSONObject> dataAreaFieldConfigMap) {
|
if (CollectionUtil.isEmpty(dataAreaFieldConfigMap)) {
|
return null;
|
}
|
List<ReportColumn> reportColumnList = new ArrayList<>();
|
dataAreaFieldConfigMap.forEach((k, v) -> {
|
ReportColumn column = new ReportColumn();
|
column.setContent(v.getString(CmnConst.ATTR_SHOW_NAME));
|
column.setColumnWidth(NumberUtil.isNumber(v.getString(CmnConst.ATTR_WIDTH)) ? NumberUtil.parseInt(v.getString(CmnConst.ATTR_WIDTH)) : 0);
|
reportColumnList.add(column);
|
});
|
return reportColumnList;
|
}
|
|
private List<List<ReportColumn>> getReportData(Map<String, JSONObject> dataAreaFieldConfigMap, DataTableEntity recordDte, Map<String, Set<String>> headAndTailTitleDataMap, Set<String> headAndTailFieldSet, Map<JSONObject, JSONObject> statisticsMap, String totalName) {
|
List<List<ReportColumn>> reportData = new ArrayList<>();
|
// 数据区分组统计字段名称list
|
List<String> dataAreaGroupStatisticsFieldNameList = Lists.newArrayList();
|
// 数据区分组字段名称list
|
List<String> 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);
|
}
|
}
|
});
|
|
FieldSetEntity recordFse;
|
FieldSetEntity preFse = null;
|
String dataAreaFieldName;
|
JSONObject dataAreaFieldConfigObj;
|
String value;
|
JSONObject keyObj;
|
Map<String, String> replaceMap = Maps.newHashMap();
|
Map<String, String> dataAreaClosestGroupStatisticsFieldValueMap = Maps.newHashMap();
|
Map<String, String> dataAreaClosestGroupFieldValueMap = Maps.newHashMap();
|
String closestGroupStatisticsFieldName = null;
|
String closestGroupFieldName = null;
|
String tempFieldName;
|
String paramKey;
|
boolean combineFlag;
|
JSONObject dataAreaGroupFieldRecordObj = new JSONObject();
|
for (int i = 0; i < recordDte.getRows(); i++) {
|
recordFse = recordDte.getFieldSetEntity(i);
|
// 获取头部、尾部标题区数据字段
|
dataListReportService.getHeadAndTailTitleDataMap(headAndTailTitleDataMap, headAndTailFieldSet, recordFse);
|
|
combineFlag = true;
|
|
List<ReportColumn> columns = new ArrayList<>();
|
for (Map.Entry<String, JSONObject> entry : dataAreaFieldConfigMap.entrySet()) {
|
ReportColumn column = new ReportColumn();
|
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) {
|
reportData.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<String> formFieldList = dataListReportService.getSuitContent(formula, CmnConst.REGEXP_FORM_FIELD);
|
Map<String, String> 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);
|
column.setRowspan(NumberUtil.parseInt(paramKey));
|
replaceMap.put(paramKey, "1");
|
}
|
// class
|
if (!StringUtils.isEmpty(dataAreaFieldConfigObj.getString(CmnConst.ATTR_URL))) {
|
//子报表
|
String url = dataAreaFieldConfigObj.getString(CmnConst.ATTR_URL);
|
url = SystemParamReplace.replaceParams(url, recordFse);
|
column.setSubReport("true".equals(dataAreaFieldConfigObj.getString("~isSubReport~")));
|
if (!column.isSubReport()) {
|
column.setPenetrate(true);
|
column.setPenetrateProperty(url);
|
} else {
|
column.setSubReportProperty(url);
|
}
|
}
|
String attrValue = recordFse.getString(dataAreaFieldName + CmnConst.PROMPT_REAL_VALUE_TAIL);
|
if (StringUtils.isEmpty(attrValue)) {
|
attrValue = recordFse.getString(dataAreaFieldName);
|
}
|
column.addProperty(dataAreaFieldName, attrValue);
|
// 格式
|
value = dataListReportService.formatValue(dataAreaFieldConfigObj, value);
|
column.setContent(value);
|
columns.add(column);
|
}
|
reportData.add(columns);
|
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) {
|
reportData.add(getDataAreaGroupStatisticsFieldStatisticsRow(dataAreaClosestGroupStatisticsFieldValueMap.get(tempFieldName), statisticsMap, dataAreaFieldConfigMap, tempFieldName, preFse, dataAreaGroupFieldNameList, replaceMap, dataAreaGroupFieldRecordObj));
|
}
|
}
|
}
|
|
// 总计
|
if (!StringUtils.isEmpty(totalName)) {
|
reportData.add(getDataAreaTotalStatistics(statisticsMap, dataAreaFieldConfigMap, dataAreaGroupFieldNameList, preFse, dataAreaGroupFieldRecordObj, totalName));
|
}
|
for (Map.Entry<String, String> entry : replaceMap.entrySet()) {
|
reportData.stream().forEach(item -> {
|
item.stream().forEach(column -> {
|
column.replace(entry.getKey(), entry.getValue());
|
});
|
});
|
}
|
|
return reportData;
|
}
|
|
/**
|
* 获取总计行
|
*
|
* @param statisticsMap 统计map
|
* @param dataAreaFieldConfigMap 数据区字段缓存map
|
* @param dataAreaGroupFieldNameList 数据区分组字段名称list
|
* @param preFse 最近操作的数据fse
|
* @param dataAreaGroupFieldRecordObj 数据区分组字段记录obj
|
* @param totalName 总计名称
|
* @return
|
*/
|
private List<ReportColumn> getDataAreaTotalStatistics(Map<JSONObject, JSONObject> statisticsMap, Map<String, JSONObject> dataAreaFieldConfigMap, List<String> dataAreaGroupFieldNameList, FieldSetEntity preFse, JSONObject dataAreaGroupFieldRecordObj, String totalName) {
|
List<ReportColumn> columns = new ArrayList<>();
|
// StringBuilder html = new StringBuilder(512);
|
String dataAreaFieldName;
|
JSONObject dataAreaFieldConfigObj;
|
String value;
|
JSONObject keyObj = new JSONObject();
|
String statisticsType;
|
// html.append("\n<tr class=\"").append(CmnConst.CLASS_TR_DATA_STATISTICS).append("\">\n ");
|
if (preFse == null) {
|
return null;
|
}
|
int index = 0;
|
for (Map.Entry<String, JSONObject> entry : dataAreaFieldConfigMap.entrySet()) {
|
ReportColumn column = new ReportColumn();
|
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);
|
column.setContent(value);
|
// html.append("<td>").append(value == null ? "" : value).append("</td>");
|
} else {
|
if (index == 1) {
|
column.setColspan(dataAreaGroupFieldNameList.size());
|
column.setContent(totalName);
|
// html.append("<td colspan=\"").append(dataAreaGroupFieldNameList.size()).append("\">").append(totalName).append("</td>");
|
}
|
}
|
columns.add(column);
|
}
|
// html.append("\n</tr>");
|
return columns;
|
}
|
|
private List<ReportColumn> getDataAreaGroupStatisticsFieldStatisticsRow(String waitStatisticsValue, Map<JSONObject, JSONObject> statisticsMap, Map<String, JSONObject> dataAreaFieldConfigMap,
|
String tempFieldName, FieldSetEntity recordFse, List<String> dataAreaGroupFieldNameList, Map<String, String> replaceMap, JSONObject dataAreaGroupFieldRecordObj) {
|
List<ReportColumn> columns = new ArrayList<>();
|
// StringBuilder html = new StringBuilder();
|
// html.append("\n<tr class=\"").append(CmnConst.CLASS_TR_DATA_STATISTICS).append("\">\n ");
|
String dataAreaFieldName;
|
JSONObject dataAreaFieldConfigObj;
|
boolean flag = false;
|
JSONObject keyObj = new JSONObject();
|
String value;
|
String statisticsType;
|
int index = 0;
|
List<String> needAddRowspanDataAreaGroupFieldNameList = Lists.newArrayList();
|
for (Map.Entry<String, JSONObject> entry : dataAreaFieldConfigMap.entrySet()) {
|
ReportColumn column = new ReportColumn();
|
index++;
|
dataAreaFieldName = entry.getKey();
|
if (!flag) {
|
if (dataAreaGroupFieldNameList.contains(dataAreaFieldName)) {
|
keyObj.put(dataAreaFieldName, recordFse.getString(dataAreaFieldName));
|
if (dataAreaFieldName.equals(tempFieldName)) {
|
column.setColspan(dataAreaGroupFieldNameList.size() - index + 1);
|
column.setContent(waitStatisticsValue + CmnConst.STATISTICS_NAME);
|
}
|
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("<td></td>");
|
}
|
} 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);
|
column.setContent(value);
|
// html.append("<td>").append(value == null ? "" : value).append("</td>");
|
}
|
}
|
columns.add(column);
|
}
|
// html.append("\n</tr>");
|
dealReplaceMapAddRowspan(replaceMap, needAddRowspanDataAreaGroupFieldNameList, recordFse, false);
|
return null;
|
}
|
|
|
/**
|
* 获取标题
|
*
|
* @param dataAreaFieldConfigMap 数据区字段缓存map
|
* @return
|
*/
|
private StringBuilder getDataAreaTitleHtml(Map<String, JSONObject> dataAreaFieldConfigMap) {
|
StringBuilder html = new StringBuilder(256);
|
html.append("<tr class=\"").append(CmnConst.CLASS_TR_DATA_TITLE).append("\">");
|
dataAreaFieldConfigMap.forEach((dataAreaFieldName, dataAreaFieldConfigObj) -> {
|
html.append("<td>").append(dataListReportService.dealTdWidth(dataAreaFieldConfigObj, dataAreaFieldConfigObj.getString(CmnConst.ATTR_SHOW_NAME))).append("</td>");
|
});
|
html.append("</tr>");
|
return html;
|
}
|
|
/**
|
* 获取内容，包含统计
|
*
|
* @param dataAreaFieldConfigMap 数据区字段缓存map
|
* @param recordDte 业务数据集合
|
* @param headAndTailFieldSet 头部、尾部标题区字段set
|
* @param statisticsMap 统计map
|
* @param totalName 总计名称
|
* @return
|
*/
|
private String getDataAreaDataHtml(Map<String, JSONObject> dataAreaFieldConfigMap, DataTableEntity recordDte, Map<String, Set<String>> headAndTailTitleDataMap, Set<String> headAndTailFieldSet, Map<JSONObject, JSONObject> statisticsMap, String totalName) {
|
// 数据区分组统计字段名称list
|
List<String> dataAreaGroupStatisticsFieldNameList = Lists.newArrayList();
|
// 数据区分组字段名称list
|
List<String> 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);
|
FieldSetEntity recordFse;
|
FieldSetEntity preFse = null;
|
String dataAreaFieldName;
|
JSONObject dataAreaFieldConfigObj;
|
String value;
|
JSONObject keyObj;
|
Map<String, String> replaceMap = Maps.newHashMap();
|
Map<String, String> dataAreaClosestGroupStatisticsFieldValueMap = Maps.newHashMap();
|
Map<String, String> dataAreaClosestGroupFieldValueMap = Maps.newHashMap();
|
String closestGroupStatisticsFieldName = null;
|
String closestGroupFieldName = null;
|
String tempFieldName;
|
String paramKey;
|
boolean combineFlag;
|
JSONObject dataAreaGroupFieldRecordObj = new JSONObject();
|
for (int i = 0; i < recordDte.getRows(); i++) {
|
recordFse = recordDte.getFieldSetEntity(i);
|
// 获取头部、尾部标题区数据字段
|
dataListReportService.getHeadAndTailTitleDataMap(headAndTailTitleDataMap, headAndTailFieldSet, recordFse);
|
|
curRowHtml.setLength(0);
|
String rowUuid = IdUtil.simpleUUID();
|
curRowHtml.append("\n<tr rowIndex=\"" + (i + 1) + "\" id=\"" + rowUuid + "\" class=\"").append(CmnConst.CLASS_TR_DATA_COMMON).append("\">\n ");
|
combineFlag = true;
|
for (Map.Entry<String, JSONObject> 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) {
|
dataAreaDataHtml.append(getDataAreaGroupStatisticsFieldStatisticsRowHtml(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<String> formFieldList = dataListReportService.getSuitContent(formula, CmnConst.REGEXP_FORM_FIELD);
|
Map<String, String> 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("<td rowspan=\"").append(paramKey).append("\"");
|
replaceMap.put(paramKey, "1");
|
} else {
|
curRowHtml.append("<td");
|
}
|
// class
|
if (!StringUtils.isEmpty(dataAreaFieldConfigObj.getString(CmnConst.ATTR_URL))) {
|
curRowHtml.append(" class=\"").append(CmnConst.CLASS_TD_CAN_TURN).append("true".equals(dataAreaFieldConfigObj.getString("~isSubReport~")) ? "\"skipSubReport=true" : "\"").append(" router=\"").append(dataAreaFieldConfigObj.getString(CmnConst.ATTR_URL)).append("\"");
|
}
|
String attrValue = recordFse.getString(dataAreaFieldName + CmnConst.PROMPT_REAL_VALUE_TAIL);
|
if (StringUtils.isEmpty(attrValue)) {
|
attrValue = recordFse.getString(dataAreaFieldName);
|
}
|
curRowHtml.append(" ").append(dataAreaFieldName).append("=\"").append(attrValue).append("\"");
|
curRowHtml.append(">");
|
// 格式
|
value = dataListReportService.formatValue(dataAreaFieldConfigObj, value);
|
curRowHtml.append(value == null ? "" : value);
|
curRowHtml.append("</td>");
|
}
|
curRowHtml.append("\n</tr>");
|
dataAreaDataHtml.append(curRowHtml);
|
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) {
|
dataAreaDataHtml.append(getDataAreaGroupStatisticsFieldStatisticsRowHtml(dataAreaClosestGroupStatisticsFieldValueMap.get(tempFieldName), statisticsMap, dataAreaFieldConfigMap, tempFieldName, preFse, dataAreaGroupFieldNameList, replaceMap, dataAreaGroupFieldRecordObj));
|
}
|
}
|
}
|
|
// 总计
|
if (!StringUtils.isEmpty(totalName)) {
|
dataAreaDataHtml.append(getDataAreaTotalStatisticsHtml(statisticsMap, dataAreaFieldConfigMap, dataAreaGroupFieldNameList, preFse, dataAreaGroupFieldRecordObj, totalName));
|
}
|
|
String str = dataAreaDataHtml.toString();
|
for (Map.Entry<String, String> entry : replaceMap.entrySet()) {
|
str = str.replace(entry.getKey(), entry.getValue());
|
}
|
|
return str;
|
}
|
|
/**
|
* 添加分组统计信息
|
*
|
* @param statisticsMap 统计map
|
* @param dataAreaGroupStatisticsFieldNameList 数据区分组统计字段名称list
|
* @param recordFse 业务数据fse
|
* @param dataAreaFieldConfigObj 数据区字段obj
|
* @param dataAreaFieldName 数据区字段名称
|
* @param value 值
|
* @param formulaMap 公式map，字段info和统计类型的映射
|
*/
|
private void addStatisticsRowInfo(Map<JSONObject, JSONObject> statisticsMap, List<String> dataAreaGroupStatisticsFieldNameList, FieldSetEntity recordFse, JSONObject dataAreaFieldConfigObj, String dataAreaFieldName, String value, Map<String, String> 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<JSONObject, JSONObject> statisticsMap, List<String> 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<JSONObject, JSONObject> statisticsMap, Map<String, String> formulaMap, JSONObject formulaFieldKeyObj, String formula, String value) {
|
String statisticsValue = "";
|
String formulaFieldValue;
|
if (formulaMap != null && !formulaMap.isEmpty()) {
|
for (Map.Entry<String, String> 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 StringBuilder getDataAreaGroupStatisticsFieldStatisticsRowHtml(String waitStatisticsValue, Map<JSONObject, JSONObject> statisticsMap, Map<String, JSONObject> dataAreaFieldConfigMap,
|
String tempFieldName, FieldSetEntity recordFse, List<String> dataAreaGroupFieldNameList, Map<String, String> replaceMap, JSONObject dataAreaGroupFieldRecordObj) {
|
StringBuilder html = new StringBuilder();
|
html.append("\n<tr class=\"").append(CmnConst.CLASS_TR_DATA_STATISTICS).append("\">\n ");
|
String dataAreaFieldName;
|
JSONObject dataAreaFieldConfigObj;
|
boolean flag = false;
|
JSONObject keyObj = new JSONObject();
|
String value;
|
String statisticsType;
|
int index = 0;
|
List<String> needAddRowspanDataAreaGroupFieldNameList = Lists.newArrayList();
|
for (Map.Entry<String, JSONObject> entry : dataAreaFieldConfigMap.entrySet()) {
|
index++;
|
dataAreaFieldName = entry.getKey();
|
if (!flag) {
|
if (dataAreaGroupFieldNameList.contains(dataAreaFieldName)) {
|
keyObj.put(dataAreaFieldName, recordFse.getString(dataAreaFieldName));
|
if (dataAreaFieldName.equals(tempFieldName)) {
|
html.append("<td colspan=\"").append(dataAreaGroupFieldNameList.size() - index + 1).append("\">").append(waitStatisticsValue).append(CmnConst.STATISTICS_NAME).append("</td>");
|
flag = true;
|
}
|
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("<td></td>");
|
}
|
} 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("<td>").append(value == null ? "" : value).append("</td>");
|
}
|
}
|
}
|
html.append("\n</tr>");
|
dealReplaceMapAddRowspan(replaceMap, needAddRowspanDataAreaGroupFieldNameList, recordFse, false);
|
return html;
|
}
|
|
/**
|
* 获取总计html
|
*
|
* @param statisticsMap 统计map
|
* @param dataAreaFieldConfigMap 数据区字段缓存map
|
* @param dataAreaGroupFieldNameList 数据区分组字段名称list
|
* @param preFse 最近操作的数据fse
|
* @param dataAreaGroupFieldRecordObj 数据区分组字段记录obj
|
* @param totalName 总计名称
|
* @return
|
*/
|
private String getDataAreaTotalStatisticsHtml(Map<JSONObject, JSONObject> statisticsMap, Map<String, JSONObject> dataAreaFieldConfigMap, List<String> dataAreaGroupFieldNameList, FieldSetEntity preFse, JSONObject dataAreaGroupFieldRecordObj, String totalName) {
|
StringBuilder html = new StringBuilder(512);
|
String dataAreaFieldName;
|
JSONObject dataAreaFieldConfigObj;
|
String value;
|
JSONObject keyObj = new JSONObject();
|
String statisticsType;
|
html.append("\n<tr class=\"").append(CmnConst.CLASS_TR_DATA_STATISTICS).append("\">\n ");
|
if (preFse == null) {
|
return html.toString();
|
}
|
int index = 0;
|
for (Map.Entry<String, JSONObject> 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);
|
html.append("<td>").append(value == null ? "" : value).append("</td>");
|
} else {
|
if (index == 1) {
|
html.append("<td colspan=\"").append(dataAreaGroupFieldNameList.size()).append("\">").append(totalName).append("</td>");
|
}
|
}
|
}
|
html.append("\n</tr>");
|
return html.toString();
|
}
|
|
/**
|
* 处理参数替换map-添加数据区分组字段的占行
|
*
|
* @param replaceMap 替换map
|
* @param needAddRowspanDataAreaGroupFieldNames 需要添加占行的数据区分组字段名称集合
|
* @param recordFse 业务数据记录
|
*/
|
private void dealReplaceMapAddRowspan(Map<String, String> replaceMap, Collection<String> 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<String> 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<String> 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();
|
}
|
}
|
