Merge remote-tracking branch 'origin/test' into test
| | |
| | | |
| | | 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; |
| | | |
| | |
| | | * @date: 2021/3/11 17:11 |
| | | */ |
| | | @Data |
| | | @EncryptDecryptClass |
| | | public class ComMngCarExcelVO implements Serializable { |
| | | /** |
| | | * 小区名称 |
| | |
| | | /** |
| | | * 车主身份证号码 |
| | | */ |
| | | @EncryptDecryptField |
| | | @ExcelProperty(value = "车主身份证号码" ,index = 2) |
| | | private String cardNo; |
| | | |
| | |
| | | */ |
| | | @ExcelProperty(value = "联系方式" ,index = 6) |
| | | private String mobile; |
| | | |
| | | /** |
| | | * 详细住址 |
| | | */ |
| | | @ExcelProperty(value = "详细住址" ,index = 7) |
| | | private String address; |
| | | |
| | | } |
| | | |
| | |
| | | "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); |
| | | } |
| | |
| | | " 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, " + |
| | |
| | | comMngPopulationVO.setAgeEndTime(ageEndTime); |
| | | } |
| | | } |
| | | 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"); |
| | |
| | | comMngPopulationVO.setAgeStartTimeEnd(ageStartTime); |
| | | } |
| | | } |
| | | |
| | | } |
| | | IPage<ComMngPopulationVO> iPage = populationDAO.pagePopulation(page, comMngPopulationVO); |
| | | if (!iPage.getRecords().isEmpty()) { |
| | | iPage.getRecords().forEach(populDO -> { |