From 8e160bc439ddd35c02a3866926be13f4f579e9f0 Mon Sep 17 00:00:00 2001
From: java110 <928255095@qq.com>
Date: 星期二, 16 五月 2023 18:59:16 +0800
Subject: [PATCH] optimize report
---
service-job/src/main/java/com/java110/job/export/adapt/ReportFeeSummaryAdapt.java | 14 +++++++-------
1 files changed, 7 insertions(+), 7 deletions(-)
diff --git a/service-job/src/main/java/com/java110/job/export/adapt/ReportFeeSummaryAdapt.java b/service-job/src/main/java/com/java110/job/export/adapt/ReportFeeSummaryAdapt.java
index aa3e8ff..56849d0 100644
--- a/service-job/src/main/java/com/java110/job/export/adapt/ReportFeeSummaryAdapt.java
+++ b/service-job/src/main/java/com/java110/job/export/adapt/ReportFeeSummaryAdapt.java
@@ -75,23 +75,23 @@
Row row = null;
row = sheet.createRow(step);
row.createCell(0).setCellValue(floorDto.getFloorName());
- row.createCell(1).setCellValue(dataObj.getString("feeRoomCount"));
- row.createCell(2).setCellValue(dataObj.getString("oweRoomCount"));
- row.createCell(3).setCellValue(dataObj.getString("hisOweFee"));
- row.createCell(4).setCellValue(dataObj.getString("curOweFee"));
+ row.createCell(1).setCellValue(dataObj.getIntValue("feeRoomCount"));
+ row.createCell(2).setCellValue(dataObj.getIntValue("oweRoomCount"));
+ row.createCell(3).setCellValue(dataObj.getDouble("hisOweFee"));
+ row.createCell(4).setCellValue(dataObj.getDouble("curOweFee"));
BigDecimal curOweFee = new BigDecimal(dataObj.getDouble("curOweFee"));
BigDecimal hisOweFee = new BigDecimal(dataObj.getDouble("hisOweFee"));
row.createCell(5).setCellValue(curOweFee.add(hisOweFee).setScale(2, BigDecimal.ROUND_HALF_UP).doubleValue());
- row.createCell(6).setCellValue(dataObj.getString("hisReceivedFee"));
+ row.createCell(6).setCellValue(dataObj.getDouble("hisReceivedFee"));
//(fee.receivedFee-fee.hisReceivedFee-fee.preReceivedFee)
BigDecimal receivedFee = new BigDecimal(dataObj.getDouble("receivedFee"));
BigDecimal hisReceivedFee = new BigDecimal(dataObj.getDouble("hisReceivedFee"));
BigDecimal preReceivedFee = new BigDecimal(dataObj.getDouble("preReceivedFee"));
row.createCell(7).setCellValue(receivedFee.subtract(hisReceivedFee).subtract(preReceivedFee).setScale(2, BigDecimal.ROUND_HALF_UP).doubleValue());
- row.createCell(8).setCellValue(dataObj.getString("preReceivedFee"));
- row.createCell(9).setCellValue(dataObj.getString("receivedFee"));
+ row.createCell(8).setCellValue(dataObj.getDouble("preReceivedFee"));
+ row.createCell(9).setCellValue(dataObj.getDouble("receivedFee"));
//((fee.feeRoomCount-fee.oweRoomCount)/fee.feeRoomCount*100).toFixed(2)
BigDecimal feeRoomCount = new BigDecimal(dataObj.getDouble("feeRoomCount"));
--
Gitblit v1.8.0