| | |
| | | |
| | | import com.alibaba.excel.annotation.ExcelProperty; |
| | | import com.google.common.collect.Lists; |
| | | import com.panzhihua.common.model.helper.encrypt.EncryptDecryptClass; |
| | | import com.panzhihua.common.model.helper.encrypt.EncryptDecryptField; |
| | | import lombok.Data; |
| | | |
| | | import java.io.Serializable; |
| | |
| | | * @author: llming |
| | | */ |
| | | @Data |
| | | @EncryptDecryptClass |
| | | public class ComMngPopulationServeExcelVO implements Serializable { |
| | | |
| | | @ExcelProperty(value = "姓名", index = 0) |
| | | private String name; |
| | | |
| | | @ExcelProperty(value = "身份证号码", index = 1) |
| | | @EncryptDecryptField |
| | | private String cardNo; |
| | | |
| | | @ExcelProperty(value = "民族", index = 2) |
| | |
| | | |
| | | @Select("<script> " + |
| | | "select id as houseId,cmv.alley from com_mng_population_house as cmph left join com_mng_village as cmv on cmv.village_id = cmph.village_id where cmph.community_id = #{communityId}" + |
| | | "<if test='villageId != null'>" + |
| | | "<if test='villageId != null and villageId != ""'>" + |
| | | "and cmv.village_id = #{villageId}" + |
| | | " </if> " + |
| | | " </script>") |
| | |
| | | cascadeHouseVOList = cascadeHouseVOList.stream().collect(Collectors.collectingAndThen(Collectors.toCollection(() -> new TreeSet<>(Comparator.comparing(o -> o.getAlley()))), ArrayList::new)); |
| | | cascadeHouseVOList.forEach(cascade -> { |
| | | cascade.setName(cascade.getAlley()); |
| | | }); |
| | | }); |
| | | break; |
| | | case 2: |
| | | if(houseDO != null){ |
| | |
| | | // if (StringUtils.isNotEmpty(populationDO.getPhone())) { |
| | | // update.setPhone(populationDO.getPhone()); |
| | | // } |
| | | String cardNoAES = AESUtil.encrypt128(vo.getCardNo(), aesKey); |
| | | BeanUtils.copyProperties(vo, update); |
| | | update.setCardNo(cardNoAES); |
| | | this.baseMapper.update(update,updateWrapper); |
| | | return populationDO; |
| | | } |