From 0a090d236f0bd70d1cff62370942196c9ac1c941 Mon Sep 17 00:00:00 2001
From: wuxw <928255095@qq.com>
Date: 星期三, 21 八月 2024 11:41:15 +0800
Subject: [PATCH] 优化采购提示消息不准确问题
---
springboot/src/main/java/com/java110/boot/smo/assetExport/impl/ExportReportFeeSMOImpl.java | 33 ++++++++++++++++++++-------------
1 files changed, 20 insertions(+), 13 deletions(-)
diff --git a/springboot/src/main/java/com/java110/boot/smo/assetExport/impl/ExportReportFeeSMOImpl.java b/springboot/src/main/java/com/java110/boot/smo/assetExport/impl/ExportReportFeeSMOImpl.java
index c66fe4d..cad8768 100644
--- a/springboot/src/main/java/com/java110/boot/smo/assetExport/impl/ExportReportFeeSMOImpl.java
+++ b/springboot/src/main/java/com/java110/boot/smo/assetExport/impl/ExportReportFeeSMOImpl.java
@@ -979,7 +979,6 @@
}
-
private void resourceStoreUseRecordManage(IPageData pd, ComponentValidateResult result, Workbook workbook) {
Sheet sheet = workbook.createSheet("鐗╁搧浣跨敤璁板綍");
Row row = sheet.createRow(0);
@@ -1616,30 +1615,38 @@
row.createCell(0).setCellValue("璐圭敤缂栧彿");
row.createCell(1).setCellValue("鎴垮彿");
row.createCell(2).setCellValue("涓氫富");
- row.createCell(3).setCellValue("闈㈢Н");
- row.createCell(4).setCellValue("璐圭敤椤�");
- row.createCell(5).setCellValue("璐圭敤寮�濮嬫椂闂�");
- row.createCell(6).setCellValue("鏇存柊鏃堕棿");
- row.createCell(7).setCellValue("娆犺垂鏃堕暱锛堝ぉ锛�");
- row.createCell(8).setCellValue("娆犺垂閲戦");
+ row.createCell(3).setCellValue("涓氫富鐢佃瘽");
+ row.createCell(4).setCellValue("闈㈢Н");
+ row.createCell(5).setCellValue("璐圭敤椤�");
+ row.createCell(6).setCellValue("璐圭敤寮�濮嬫椂闂�");
+ row.createCell(7).setCellValue("鏇存柊鏃堕棿");
+ row.createCell(8).setCellValue("娆犺垂鏃堕暱锛堝ぉ锛�");
+ row.createCell(9).setCellValue("娆犺垂鏃堕暱锛堟湀锛�");
+ row.createCell(10).setCellValue("娆犺垂閲戦");
+
//鏌ヨ妤兼爧淇℃伅
JSONArray rooms = this.getReportOweFeeDetail(pd, result);
if (rooms == null || rooms.size() == 0) {
return;
}
JSONObject dataObj = null;
+ BigDecimal monthDec = null;
for (int roomIndex = 0; roomIndex < rooms.size(); roomIndex++) {
row = sheet.createRow(roomIndex + 1);
dataObj = rooms.getJSONObject(roomIndex);
row.createCell(0).setCellValue(roomIndex + 1);
row.createCell(1).setCellValue(dataObj.getString("objName"));
row.createCell(2).setCellValue(dataObj.getString("ownerName"));
- row.createCell(3).setCellValue(dataObj.getString("builtUpArea"));
- row.createCell(4).setCellValue(dataObj.getString("feeName"));
- row.createCell(5).setCellValue(dataObj.getString("feeCreateTime"));
- row.createCell(6).setCellValue(dataObj.getString("updateTime"));
- row.createCell(7).setCellValue(dataObj.getString("oweDay"));
- row.createCell(8).setCellValue(dataObj.getString("oweAmount"));
+ row.createCell(3).setCellValue(dataObj.getString("ownerTel"));
+ row.createCell(4).setCellValue(dataObj.getString("builtUpArea"));
+ row.createCell(5).setCellValue(dataObj.getString("feeName"));
+ row.createCell(6).setCellValue(dataObj.getString("feeCreateTime"));
+ row.createCell(7).setCellValue(dataObj.getString("updateTime"));
+ row.createCell(8).setCellValue(dataObj.getString("oweDay"));
+ monthDec = new BigDecimal(dataObj.getString("oweDay"));
+ monthDec = monthDec.divide(new BigDecimal("30"), 2, BigDecimal.ROUND_HALF_UP);
+ row.createCell(9).setCellValue(monthDec.doubleValue());
+ row.createCell(10).setCellValue(dataObj.getString("oweAmount"));
}
}
--
Gitblit v1.8.0