springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/dtos/community/ComMngPopulationDTO.java
@@ -214,4 +214,12 @@ @ApiModelProperty("关键词") private String keyWord; @ApiModelProperty("等级是否查询全部（1.是 2.否）") private Integer levelIsAll; public interface levelIsAll{ int yes = 1; int no = 2; } } springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/dtos/community/ComMngPopulationHouseAdminDTO.java
@@ -123,4 +123,12 @@ @ApiModelProperty(value = "房屋地址") private Long address; @ApiModelProperty("等级是否查询全部（1.是 2.否）") private Integer levelIsAll; public interface levelIsAll{ int yes = 1; int no = 2; } } springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/ComActReserveApi.java
@@ -27,6 +27,7 @@ import com.panzhihua.common.utlis.SFTPUtil; import com.panzhihua.common.utlis.StringUtils; import com.panzhihua.community_backstage.config.SFTPConfig; import com.panzhihua.community_backstage.excel.Custemhandler; import com.panzhihua.community_backstage.excel.CustomSheetWriteHandler; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; @@ -515,11 +516,9 @@ contentWriteCellStyle.setWrapped(true); HorizontalCellStyleStrategy horizontalCellStyleStrategy = new HorizontalCellStyleStrategy(headWriteCellStyle, contentWriteCellStyle); LongestMatchColumnWidthStyleStrategy longestMatchColumnWidthStyleStrategy = new LongestMatchColumnWidthStyleStrategy(); excelWriter = EasyExcel.write(fileName, ComMngPopulationExcelVo.class) .registerWriteHandler(horizontalCellStyleStrategy) .registerWriteHandler(longestMatchColumnWidthStyleStrategy) .registerWriteHandler(horizontalCellStyleStrategy).registerWriteHandler(new Custemhandler()) .registerWriteHandler(new CustomSheetWriteHandler()).build(); WriteSheet writeSheet = EasyExcel.writerSheet("登记明细导出数据").head(headList).build(); excelWriter.write(datalist, writeSheet); springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/excel/Custemhandler.java
New file @@ -0,0 +1,36 @@ package com.panzhihua.community_backstage.excel; import com.alibaba.excel.metadata.CellData; import com.alibaba.excel.metadata.Head; import com.alibaba.excel.write.metadata.holder.WriteSheetHolder; import com.alibaba.excel.write.style.column.AbstractColumnWidthStyleStrategy; import org.apache.poi.ss.usermodel.Cell; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import java.util.List; public class Custemhandler extends AbstractColumnWidthStyleStrategy { private static final int MAX_COLUMN_WIDTH = 100; //the maximum column width in Excel is 255 characters public Custemhandler() { } @Override protected void setColumnWidth(WriteSheetHolder writeSheetHolder, List<CellData> cellDataList, Cell cell, Head head, Integer relativeRowIndex, Boolean isHead) { if (isHead && cell.getRowIndex() != 0) { int columnWidth = cell.getStringCellValue().getBytes().length; if (columnWidth > MAX_COLUMN_WIDTH) { columnWidth = MAX_COLUMN_WIDTH; } else { columnWidth = columnWidth + 3; } writeSheetHolder.getSheet().setColumnWidth(cell.getColumnIndex(), columnWidth * 256); } } private final static Logger logger = LoggerFactory.getLogger(Custemhandler.class); } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComMngPopulationHouseServiceImpl.java
@@ -190,25 +190,27 @@ break; case 2: populationHouseAdminDTO.setRoad(houseDO.getAlley()); populationHouseAdminDTO.setDoorNo(houseDO.getHouseNum()); // populationHouseAdminDTO.setDoorNo(houseDO.getHouseNum()); break; case 3: populationHouseAdminDTO.setRoad(houseDO.getAlley()); populationHouseAdminDTO.setDoorNo(houseDO.getHouseNum()); populationHouseAdminDTO.setFloor(houseDO.getFloor()); // populationHouseAdminDTO.setFloor(houseDO.getFloor()); break; case 4: populationHouseAdminDTO.setRoad(houseDO.getAlley()); populationHouseAdminDTO.setDoorNo(houseDO.getHouseNum()); populationHouseAdminDTO.setFloor(houseDO.getFloor()); populationHouseAdminDTO.setUnitNo(houseDO.getUnitNo()); // populationHouseAdminDTO.setUnitNo(houseDO.getUnitNo()); break; case 5: populationHouseAdminDTO.setRoad(houseDO.getAlley()); populationHouseAdminDTO.setDoorNo(houseDO.getHouseNum()); populationHouseAdminDTO.setFloor(houseDO.getFloor()); populationHouseAdminDTO.setUnitNo(houseDO.getUnitNo()); populationHouseAdminDTO.setHouseNo(houseDO.getHouseNo()); if(populationHouseAdminDTO.getLevelIsAll() == null){ populationHouseAdminDTO.setHouseNo(houseDO.getHouseNo()); } break; default: break; springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComMngPopulationServiceImpl.java
@@ -472,25 +472,27 @@ break; case 2: comMngPopulationVO.setRoad(houseDO.getAlley()); comMngPopulationVO.setDoorNo(houseDO.getHouseNum()); // comMngPopulationVO.setDoorNo(houseDO.getHouseNum()); break; case 3: comMngPopulationVO.setRoad(houseDO.getAlley()); comMngPopulationVO.setDoorNo(houseDO.getHouseNum()); comMngPopulationVO.setFloor(houseDO.getFloor()); // comMngPopulationVO.setFloor(houseDO.getFloor()); break; case 4: comMngPopulationVO.setRoad(houseDO.getAlley()); comMngPopulationVO.setDoorNo(houseDO.getHouseNum()); comMngPopulationVO.setFloor(houseDO.getFloor()); comMngPopulationVO.setUnitNo(houseDO.getUnitNo()); // comMngPopulationVO.setUnitNo(houseDO.getUnitNo()); break; case 5: comMngPopulationVO.setRoad(houseDO.getAlley()); comMngPopulationVO.setDoorNo(houseDO.getHouseNum()); comMngPopulationVO.setFloor(houseDO.getFloor()); comMngPopulationVO.setUnitNo(houseDO.getUnitNo()); comMngPopulationVO.setHouseNo(houseDO.getHouseNo()); if(comMngPopulationVO.getLevelIsAll() == null){ comMngPopulationVO.setHouseNo(houseDO.getHouseNo()); } break; default: break;
