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 | 52 +++++++++++++++++++++++++++++++++++++--------------- 1 files changed, 37 insertions(+), 15 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 bf0b6f3..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 @@ -137,8 +137,8 @@ return baseDao.getNo(pid, productType); } - public List<XhProductModel> getProductList() { - List<XhProductModel> ProductList = baseDao.getProductList(); + public List<XhProductModel> getProductList(Long shipId, Integer type) { + List<XhProductModel> ProductList = baseDao.getProductList(shipId,type); return TreeUtils.build(ProductList); } @@ -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); @@ -582,4 +589,19 @@ writeList(dto.getChildren(), List); } } + public void refreshCache() { + List<XhProductModel> productList = baseDao.getProductListAll(); + Map<Long, XhProductModel> imgMap = new HashMap<>(); + for (XhProductModel product : productList) { + imgMap.put(product.getId(), product); + } + CacheUtils.put("sysImgCache", "sysImgCache", imgMap); + } + + public void getImg(HttpServletResponse response, Long id) { + Map<Long, XhProductModel> imgMap = new HashMap<>(); + imgMap = (Map<Long, XhProductModel>) CacheUtils.get("sysImgCache","sysImgCache"); + XhProductModel product = imgMap.get(id); + sysPictureBaseService.getSvgImage(response,product.getOperatImg()); + } } -- Gitblit v1.9.1