From 69872a9b4929a4bbc61932c08187d7433cdb9fc0 Mon Sep 17 00:00:00 2001
From: wuxw <928255095@qq.com>
Date: 星期六, 03 六月 2023 17:57:21 +0800
Subject: [PATCH] 优化报表导出功能
---
service-job/src/main/java/com/java110/job/export/adapt/DataReportEarnedStatisticsAdapt.java | 17 ++++++++++++-----
1 files changed, 12 insertions(+), 5 deletions(-)
diff --git a/service-job/src/main/java/com/java110/job/export/adapt/DataReportEarnedStatisticsAdapt.java b/service-job/src/main/java/com/java110/job/export/adapt/DataReportEarnedStatisticsAdapt.java
index 56169cc..03e79bd 100644
--- a/service-job/src/main/java/com/java110/job/export/adapt/DataReportEarnedStatisticsAdapt.java
+++ b/service-job/src/main/java/com/java110/job/export/adapt/DataReportEarnedStatisticsAdapt.java
@@ -57,6 +57,7 @@
row.createCell(0).setCellValue("妤兼爧");
row.createCell(1).setCellValue("鎴锋暟");
row.createCell(2).setCellValue("鏀惰垂鎴锋暟");
+ row.createCell(3).setCellValue("瀹炴敹");
DictDto dictDto = new DictDto();
dictDto.setTableName("pay_fee_config");
dictDto.setTableColumns("fee_type_cd_show");
@@ -86,10 +87,15 @@
return workbook;
}
+ /**
+ * 灏佽鏁版嵁鍒癊xcel涓�
+ * @param datas
+ * @param sheet
+ * @param dictDtos
+ */
private void appendData(List<Map> datas, Sheet sheet, List<DictDto> dictDtos) {
Row row = null;
Map dataObj = null;
- String oweFee = "";
String receivedFee = "";
for (int roomIndex = 0; roomIndex < datas.size(); roomIndex++) {
row = sheet.createRow(roomIndex + 1);
@@ -97,13 +103,14 @@
row.createCell(0).setCellValue(dataObj.get("floorNum").toString());
row.createCell(1).setCellValue(dataObj.get("roomCount").toString());
row.createCell(2).setCellValue(dataObj.get("feeRoomCount").toString());
+ row.createCell(3).setCellValue(dataObj.get("receivedFee").toString());
for (int dictIndex = 0; dictIndex < dictDtos.size(); dictIndex++) {
- oweFee = dataObj.get("oweFee" + dictDtos.get(0).getStatusCd()).toString();
- if (StringUtil.isEmpty(oweFee)) {
- oweFee = "0";
+ receivedFee = dataObj.get("receivedFee" + dictDtos.get(0).getStatusCd()).toString();
+ if (StringUtil.isEmpty(receivedFee)) {
+ receivedFee = "0";
}
- row.createCell(3 + dictIndex).setCellValue(oweFee);
+ row.createCell(4 + dictIndex).setCellValue(receivedFee);
}
}
--
Gitblit v1.8.0