From d0e1a3fb24d0ee76aa4ef1b0e042392b4d3ac794 Mon Sep 17 00:00:00 2001
From: jinlin <jinlin>
Date: 星期四, 07 十一月 2024 16:38:26 +0800
Subject: [PATCH] 预计参数多层次分级,新增型号增加namePath
---
modules/mainPart/src/main/java/com/zt/life/modules/mainPart/basicInfo/service/XhProductModelService.java | 33 ++++++++++++++++++++-------------
1 files changed, 20 insertions(+), 13 deletions(-)
diff --git a/modules/mainPart/src/main/java/com/zt/life/modules/mainPart/basicInfo/service/XhProductModelService.java b/modules/mainPart/src/main/java/com/zt/life/modules/mainPart/basicInfo/service/XhProductModelService.java
index 75a409d..946c469 100644
--- a/modules/mainPart/src/main/java/com/zt/life/modules/mainPart/basicInfo/service/XhProductModelService.java
+++ b/modules/mainPart/src/main/java/com/zt/life/modules/mainPart/basicInfo/service/XhProductModelService.java
@@ -451,23 +451,37 @@
Workbook workbook = new XSSFWorkbook(inputStream);
// 鑾峰彇绗竴涓伐浣滆〃
Sheet sheet = workbook.getSheetAt(0);
+ List.sort((o1, o2) -> {
+ String[] parentList1 = o1.getNamePath().split(",");
+ String[] parentList2 = o2.getNamePath().split(",");
+ String xt1 = parentList1.length > 0 ? parentList1[0] : "";
+ String xt2 = parentList2.length > 0 ? parentList2[0] : "";
+
+ // 棣栧厛姣旇緝xt鍊�
+ int xtCompare = xt1.compareTo(xt2);
+ if (xtCompare != 0) {
+ return xtCompare;
+ }
+
+ // 濡傛灉xt鐩稿悓锛屾瘮杈僷arentList鐨勯暱搴︼紝纭繚parentList.length = 2鐨勬暟鎹帓鍦ㄥ墠闈�
+ return Integer.compare(parentList1.length, parentList2.length);
+ });
int num = 0;
String xt = "";
String fxt = "";
String sb = "";
for (int i = 0; i < List.size(); i++) {
- if (List.get(i).getProductType() == 5) {
num = num + 1;
String[] parentList = List.get(i).getNamePath().split(",");
Row row = sheet.createRow(sheet.getLastRowNum() + 1); // 鍒涘缓鏂拌
Cell cell = row.createCell(0);
cell.setCellValue(num);
+ if (!xt.equals(parentList[0])) {
+ xt = parentList[0];
+ cell = row.createCell(1);
+ cell.setCellValue(xt);
+ }
if (parentList.length > 2) {
- if (!xt.equals(parentList[0])) {
- xt = parentList[0];
- cell = row.createCell(1);
- cell.setCellValue(xt);
- }
if (!fxt.equals(parentList[1])) {
fxt = parentList[1];
cell = row.createCell(2);
@@ -479,12 +493,6 @@
cell.setCellValue(sb);
}
} else {
- if (!xt.equals(parentList[0])) {
- xt = parentList[0];
- cell = row.createCell(1);
- cell.setCellValue(xt);
- }
-
if (!sb.equals(parentList[1])) {
sb = parentList[1];
cell = row.createCell(3);
@@ -563,7 +571,6 @@
cell.setCellValue(List.get(i).getRepairMttcrOtherParams3());
}
}
- }
response.setContentType("application/octet-stream;charset=UTF-8");
String encodedFilename = DownloadService.getNameEncoder(request, name + "_浜у搧缁撴瀯鏍�.xlsx");
response.addHeader("Content-Disposition", "attachment;filename=" + encodedFilename);
--
Gitblit v1.9.1