springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/ComMngCarExcelVO.java
@@ -2,6 +2,8 @@ import com.alibaba.excel.annotation.ExcelProperty; import com.fasterxml.jackson.annotation.JsonFormat; import com.panzhihua.common.model.helper.encrypt.EncryptDecryptClass; import com.panzhihua.common.model.helper.encrypt.EncryptDecryptField; import io.swagger.annotations.ApiModelProperty; import lombok.Data; @@ -14,6 +16,7 @@ * @date: 2021/3/11 17:11 */ @Data @EncryptDecryptClass public class ComMngCarExcelVO implements Serializable { /** * 小区名称 @@ -29,6 +32,7 @@ /** * 车主身份证号码 */ @EncryptDecryptField @ExcelProperty(value = "车主身份证号码" ,index = 2) private String cardNo; @@ -55,12 +59,6 @@ */ @ExcelProperty(value = "联系方式" ,index = 6) private String mobile; /** * 详细住址 */ @ExcelProperty(value = "详细住址" ,index = 7) private String address; } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActWorkGuideDAO.java
@@ -23,7 +23,7 @@ "title like concat('%',#{pageActWorkGuideDTO.title},'%')"+ " </if> " + " </where>" + "order by create_at desc"+ "order by update_at desc"+ "</script>") IPage<ComActWorkGuideVO> pageWorkGuide(Page page, @Param("pageActWorkGuideDTO") PageActWorkGuideDTO pageActWorkGuideDTO); } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngCarDAO.java
@@ -75,6 +75,7 @@ " SELECT " + " t.area_name AS areaName, " + " t.user_name AS userName, " + " t.card_no AS cardNo, " + " t.brand, " + " t.plate_num AS plateNum, " + " t.color, " + springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComMngPopulationServiceImpl.java
@@ -298,14 +298,15 @@ comMngPopulationVO.setAgeEndTime(ageEndTime); } } if (comMngPopulationVO.getAgeStartTime().equals(comMngPopulationVO.getAgeEndTime())) { Date endAge = DateUtils.stringToDate(comMngPopulationVO.getAgeEndTime(),new SimpleDateFormat("yyyy-MM-dd")); String ageStartTime = DateUtils.getDateFormatString(DateUtils.yearAddNum(endAge, -1),"yyyy-MM-dd"); if (StringUtils.isNotEmpty(ageStartTime)) { comMngPopulationVO.setAgeStartTimeEnd(ageStartTime); if (comMngPopulationVO.getAgeStartTime() !=null && !"".equals(comMngPopulationVO.getAgeStartTime()) && comMngPopulationVO.getAgeEndTime() !=null && !"".equals(comMngPopulationVO.getAgeEndTime())){ if (comMngPopulationVO.getAgeStartTime().equals(comMngPopulationVO.getAgeEndTime())) { Date endAge = DateUtils.stringToDate(comMngPopulationVO.getAgeEndTime(),new SimpleDateFormat("yyyy-MM-dd")); String ageStartTime = DateUtils.getDateFormatString(DateUtils.yearAddNum(endAge, -1),"yyyy-MM-dd"); if (StringUtils.isNotEmpty(ageStartTime)) { comMngPopulationVO.setAgeStartTimeEnd(ageStartTime); } } } IPage<ComMngPopulationVO> iPage = populationDAO.pagePopulation(page, comMngPopulationVO); if (!iPage.getRecords().isEmpty()) { iPage.getRecords().forEach(populDO -> {