花城E+防疫修改

101captain

2022-04-20 1f2a435fd319c159fe355be168f6023229b3045a

花城E+防疫修改

 springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/ComMngPopulationSpecialExcelVo.java

New file
@@ -0,0 +1,21 @@
package com.panzhihua.common.model.vos.community;

import com.alibaba.excel.annotation.ExcelProperty;
import lombok.Data;

@Data
public class ComMngPopulationSpecialExcelVo {

    @ExcelProperty(value = "所在小区", index = 0)
    private String areaName;

    @ExcelProperty(value = "姓名", index = 1)
    private String name;

    @ExcelProperty(value = "人员标签", index = 2)
    private String tags;

    @ExcelProperty(value = "联系方式", index = 3)
    private String phone;

}

 springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/CommonDataApi.java

@@ -521,26 +521,20 @@
                    List<InputUserInfoVO> populList = JSON.parseArray(
                        JSON.toJSONString(communityService.specialInputUserExport(pageInputUserDTO).getData()),
                            InputUserInfoVO.class);
                    List<ComMngPopulationExcelVo> populationExcelVoList = new ArrayList<>();
                    List<ComMngPopulationSpecialExcelVo> populationExcelVoList = new ArrayList<>();
                    if (populList != null && populList.size() > 0) {
                        for (InputUserInfoVO popul : populList) {
                            if (popul.getTags() == null) {
                                continue;
                            }
                            ComMngPopulationExcelVo populationExcelVo = new ComMngPopulationExcelVo();
                            ComMngPopulationSpecialExcelVo populationExcelVo = new ComMngPopulationSpecialExcelVo();
                            BeanUtils.copyProperties(popul, populationExcelVo);
                            // 设置性别
                            populationExcelVo.setSex(PopulSexEnum.getCnDescByName(popul.getSex()));
                            // 设置政治面貌
                            populationExcelVo.setPoliticalOutlook(
                                PopulPoliticalOutlookEnum.getCnDescByName(popul.getPoliticalOutlook()));
                            // 设置是否租住
                            // populationExcelVo.setIsRent(PopulIsOkEnum.getCnDescByName(popul.getIsRent()));
                            populationExcelVoList.add(populationExcelVo);
                        }
                    }

                    excelWriter = EasyExcel.write(fileName, ComMngPopulationExcelVo.class)
                    excelWriter = EasyExcel.write(fileName, ComMngPopulationSpecialExcelVo.class)
                        .registerWriteHandler(new LongestMatchColumnWidthStyleStrategy())
                        .registerWriteHandler(new CustomSheetWriteHandler()).build();
                    WriteSheet writeSheet = EasyExcel.writerSheet("特殊群体导出数据").build();