From 3da0feec9d4825c7ee18eaf948d0f7d5d206eca4 Mon Sep 17 00:00:00 2001
From: java110 <928255095@qq.com>
Date: 星期一, 05 六月 2023 10:24:02 +0800
Subject: [PATCH] finish report export excel
---
service-job/src/main/java/com/java110/job/export/adapt/DataReportEarnedDetailStatisticsAdapt.java | 33 ++++++++++++++++++++++++---------
1 files changed, 24 insertions(+), 9 deletions(-)
diff --git a/service-job/src/main/java/com/java110/job/export/adapt/DataReportEarnedDetailStatisticsAdapt.java b/service-job/src/main/java/com/java110/job/export/adapt/DataReportEarnedDetailStatisticsAdapt.java
index 2529c5a..e296cad 100644
--- a/service-job/src/main/java/com/java110/job/export/adapt/DataReportEarnedDetailStatisticsAdapt.java
+++ b/service-job/src/main/java/com/java110/job/export/adapt/DataReportEarnedDetailStatisticsAdapt.java
@@ -114,22 +114,37 @@
*/
private void appendData(JSONArray datas, Sheet sheet, List<DictDto> dictDtos,int step) {
Row row = null;
- Map dataObj = null;
+ JSONObject dataObj = null;
String receivedFee = "";
+ String feeTypeCd = "";
+ JSONArray feeTypeCdData = null;
+ String feeTypeCdValue = "";
+ JSONObject feeTypeData = null;
for (int roomIndex = 0; roomIndex < datas.size(); roomIndex++) {
row = sheet.createRow(roomIndex + 1);
dataObj = datas.getJSONObject(roomIndex);
- 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());
+ row.createCell(0).setCellValue(dataObj.getString("roomName"));
+ row.createCell(1).setCellValue(dataObj.getString("ownerName")+"("+dataObj.getString("link")+")");
+ row.createCell(3).setCellValue(dataObj.getString("receivedFee"));
for (int dictIndex = 0; dictIndex < dictDtos.size(); dictIndex++) {
- receivedFee = dataObj.get("receivedFee" + dictDtos.get(0).getStatusCd()).toString();
- if (StringUtil.isEmpty(receivedFee)) {
- receivedFee = "0";
+ feeTypeCd = "receivedFee"+dictDtos.get(dictIndex).getStatusCd();
+ if(!dataObj.containsKey(feeTypeCd)){
+ row.createCell(3 + dictIndex).setCellValue(0);
+ continue;
}
- row.createCell(4 + dictIndex).setCellValue(receivedFee);
+ feeTypeCdData = dataObj.getJSONArray(feeTypeCd);
+ if(feeTypeCdData == null || feeTypeCdData.size() < 1){
+ row.createCell(3 + dictIndex).setCellValue(0);
+ continue;
+ }
+ feeTypeCdValue = "";
+ for(int feeTypeIndex = 0;feeTypeIndex < feeTypeCdData.size(); feeTypeIndex++) {
+ feeTypeData = feeTypeCdData.getJSONObject(feeTypeIndex);
+ feeTypeCdValue += (feeTypeData.getString("feeName")+"("+feeTypeData.getString("startTime")+"~"+feeTypeData.getString("endTime"))+")="+feeTypeData.getString("receivedAmount");
+ feeTypeCdValue +="\r\n";
+ }
+ row.createCell(3 + dictIndex).setCellValue(feeTypeCdValue);
}
}
--
Gitblit v1.8.0