From cddcf22a61489ee9c2dfee169d817ccd66f95430 Mon Sep 17 00:00:00 2001
From: java110 <928255095@qq.com>
Date: 星期五, 03 九月 2021 02:23:43 +0800
Subject: [PATCH] 优化代码
---
service-front/src/main/java/com/java110/front/smo/assetExport/impl/ExportFeeManualCollectionSMOImpl.java | 36 +++++++++++++++++++++++++-----------
1 files changed, 25 insertions(+), 11 deletions(-)
diff --git a/service-front/src/main/java/com/java110/front/smo/assetExport/impl/ExportFeeManualCollectionSMOImpl.java b/service-front/src/main/java/com/java110/front/smo/assetExport/impl/ExportFeeManualCollectionSMOImpl.java
index 380c817..5735f16 100755
--- a/service-front/src/main/java/com/java110/front/smo/assetExport/impl/ExportFeeManualCollectionSMOImpl.java
+++ b/service-front/src/main/java/com/java110/front/smo/assetExport/impl/ExportFeeManualCollectionSMOImpl.java
@@ -186,7 +186,7 @@
int line = 0;
double totalPageHeight = 0;
for (int roomIndex = 0; roomIndex < rooms.size(); roomIndex++) {
- Map info = generatorRoomOweFee(sheet, workbook, rooms.getJSONObject(roomIndex), line, totalPageHeight, patriarch, feePrint);
+ Map<String, Object> info = generatorRoomOweFee(sheet, workbook, rooms.getJSONObject(roomIndex), line, totalPageHeight, patriarch, feePrint);
line = Integer.parseInt(info.get("line").toString()) + 1;
totalPageHeight = Double.parseDouble(info.get("totalPageHeight").toString());
}
@@ -197,7 +197,7 @@
String[] feePrintRemarks = null;
if (feePrint != null) {
feePrintRemarks = feePrint.getString("content").toLowerCase().replace("</br>", "").split("\n");
- }else{
+ } else {
feePrintRemarks = new String[]{""};
}
int defaultRowHeight = 280;
@@ -244,7 +244,11 @@
Row row = sheet.createRow(0 + line);
Cell cell0 = row.createCell(0);
//cell0.setCellValue("缂磋垂閫氱煡鍗晅otalHeight:" + totalHeight + "-totalPageHeight:" + totalPageHeight + "-curPageHeight:" + curPageHeight + "-freePageHeight:" + freePageHeight + "-line:" + line);
- cell0.setCellValue("缂磋垂閫氱煡鍗�");
+ if (feePrint != null) {
+ cell0.setCellValue(feePrint.getString("printName") + "缂磋垂閫氱煡鍗�");
+ } else {
+ cell0.setCellValue("缂磋垂閫氱煡鍗�");
+ }
//鏍囬璁剧疆瀛椾綋
Font font = workbook.createFont();
font.setFontName("榛戜綋");
@@ -277,14 +281,20 @@
subTitleCellStyle.setAlignment(HorizontalAlignment.CENTER);
subTitleCellStyle.setVerticalAlignment(VerticalAlignment.BOTTOM);
row = sheet.createRow(1 + line);
-
Cell cell1 = row.createCell(1);
- cell1.setCellValue("鎴垮彿锛�" + room.getString("floorNum")
- + "-" + room.getString("unitNum")
- + "-" + room.getString("roomNum"));
+ if (fees != null && fees.size() > 0) {
+ cell1.setCellValue("涓氫富锛�" + fees.getJSONObject(0).getString("ownerName"));
+ } else {
+ cell1.setCellValue("涓氫富锛氭棤");
+ }
cell1.setCellStyle(subTitleCellStyle);
- row.createCell(2).setCellValue("");
+ Cell cell2 = row.createCell(2);
+ cell2.setCellValue("鎴垮彿锛�" + room.getString("floorNum")
+ + "-" + room.getString("unitNum")
+ + "-" + room.getString("roomNum"));
+ cell2.setCellStyle(subTitleCellStyle);
+
row.createCell(3).setCellValue("");
row.createCell(4).setCellValue("");
Cell cell5 = row.createCell(5);
@@ -295,7 +305,7 @@
row.setRowStyle(rowCellStyle);
//璁剧疆琛ㄥご涔嬩笂
- region = new CellRangeAddress(1 + line, 1 + line, 1, 3);
+ region = new CellRangeAddress(1 + line, 1 + line, 2, 3);
sheet.addMergedRegion(region);
region = new CellRangeAddress(1 + line, 1 + line, 5, 6);
sheet.addMergedRegion(region);
@@ -310,7 +320,7 @@
cell1 = row.createCell(1);
cell1.setCellValue("鏀惰垂鏍囧噯");
cell1.setCellStyle(cellStyle);
- Cell cell2 = row.createCell(2);
+ cell2 = row.createCell(2);
cell2.setCellValue("鏁伴噺/闈㈢Н");
cell2.setCellStyle(cellStyle);
Cell cell3 = row.createCell(3);
@@ -347,7 +357,11 @@
cell2.setCellValue(room.getString("builtUpArea"));
cell2.setCellStyle(cellStyle);
cell3 = row.createCell(3);
- cell3.setCellValue(startTime + "鑷�" + endTime);
+ if (feeObj.containsKey("curDegrees")) {
+ cell3.setCellValue(startTime + "鑷�" + endTime + " " + feeObj.getString("preDegrees") + "鑷�" + feeObj.getString("curDegrees"));
+ } else {
+ cell3.setCellValue(startTime + "鑷�" + endTime);
+ }
cell3.setCellStyle(cellStyle);
cell4 = row.createCell(4);
cell4.setCellValue(feeObj.getString("feePrice"));
--
Gitblit v1.8.0