| | |
| | | import org.springblade.core.tool.utils.Func; |
| | | import org.springblade.modules.house.entity.HouseholdEntity; |
| | | import org.springblade.modules.house.entity.UserHouseLabelEntity; |
| | | import org.springblade.modules.house.excel.ExportHouseholdExcel; |
| | | import org.springblade.modules.house.excel.ImportHouseholdExcel; |
| | | import org.springblade.modules.house.mapper.HouseholdMapper; |
| | | import org.springblade.modules.house.service.IHouseService; |
| | |
| | | return baseMapper.getHouseholdListById(household); |
| | | } |
| | | |
| | | /** |
| | | * 导出住户信息 |
| | | * @param household |
| | | * @return |
| | | */ |
| | | @Override |
| | | public List<ImportHouseholdExcel> export(HouseholdVO household) { |
| | | List<ImportHouseholdExcel> userHouseHoldExcels = baseMapper.export(household); |
| | | public List<ExportHouseholdExcel> export(HouseholdVO household) { |
| | | CommonParamSet commonParamSet = new CommonParamSet().invoke(HouseholdVO.class, household); |
| | | // 重点人员与关注人员 |
| | | if (Objects.nonNull(household.getLabelType())) { |
| | | extracted(household); |
| | | } |
| | | List<ExportHouseholdExcel> userHouseHoldExcels = baseMapper.export(household, |
| | | commonParamSet.getIsAdministrator(), |
| | | commonParamSet.getRegionChildCodesList(), |
| | | commonParamSet.getGridCodeList() |
| | | ); |
| | | return userHouseHoldExcels; |
| | | } |
| | | |
| | |
| | | for (ImportHouseholdExcel houseHoldExcel : data) { |
| | | HouseholdEntity householdEntity = Objects.requireNonNull(BeanUtil.copy(houseHoldExcel, HouseholdEntity.class)); |
| | | // 判断姓名,手机号 |
| | | if (Strings.isBlank(householdEntity.getName()) || Strings.isBlank(householdEntity.getPhoneNumber())){ |
| | | if (Strings.isBlank(householdEntity.getName()) |
| | | || Strings.isBlank(householdEntity.getPhoneNumber()) |
| | | || Strings.isBlank(householdEntity.getHouseCode()) |
| | | ){ |
| | | errorNum ++; |
| | | continue; |
| | | } |
| | |
| | | } |
| | | StringBuilder builder = new StringBuilder("导入完成!"); |
| | | builder.append("其中本次表格共有 ").append(totalNum).append(" 条数据,") |
| | | .append("成功导入 ").append(importNum).append(" 条数据,") |
| | | .append("其中有 ").append(updateNum).append(" 条数据已存在。"); |
| | | .append("成功导入 ").append(importNum).append(" 条数据。"); |
| | | if (updateNum>0) { |
| | | builder.append("其中有 ").append(updateNum).append(" 条数据已存在。"); |
| | | } |
| | | if (errorNum>0){ |
| | | builder.append("共有 ").append(errorNum).append(" 条数据由于无姓名或手机号信息未导入!"); |
| | | builder.append("共有 ").append(errorNum).append(" 条数据由于无姓名或手机号或门牌地址编码信息未导入!"); |
| | | } |
| | | return builder.toString(); |
| | | } |