| | |
| | | @Override |
| | | public R listSaveMngCarExcelVO(List<ComMngCarExcelVO> list, Long communityId) { |
| | | // 获取社区下所有的小区 |
| | | List<ComMngStructAreaDO> comMngStructAreaDOs = comMngStructAreaDAO.selectList( |
| | | new QueryWrapper<ComMngStructAreaDO>().lambda().eq(ComMngStructAreaDO::getCommunityId, communityId)); |
| | | Map<String, ComMngStructAreaDO> areaMap = new HashMap<>(comMngStructAreaDOs.size()); |
| | | comMngStructAreaDOs.forEach(comMngStructAreaDO -> { |
| | | areaMap.put(comMngStructAreaDO.getAreaName(), comMngStructAreaDO); |
| | | List<ComMngVillageDO> comMngVillageDOS = comMngVillageDAO.selectList( |
| | | new QueryWrapper<ComMngVillageDO>().lambda().eq(ComMngVillageDO::getCommunityId, communityId)); |
| | | Map<String, ComMngVillageDO> areaMap = new HashMap<>(comMngVillageDOS.size()); |
| | | comMngVillageDOS.forEach(comMngVillageDO -> { |
| | | areaMap.put(comMngVillageDO.getName(),comMngVillageDO); |
| | | }); |
| | | List<ComMngCarDO> comMngCarDOS = new ArrayList<>(); |
| | | list.forEach(vo -> { |
| | |
| | | |
| | | } |
| | | comMngCarDO.setCommunityId(communityId); |
| | | comMngCarDO.setAreaId(areaMap.get(vo.getAreaName()).getId()); |
| | | comMngCarDO.setAreaId(areaMap.get(vo.getAreaName()).getVillageId()); |
| | | R<SysUserVO> sysUserVOR = userService.getSysUserVOByPhone(vo.getMobile()); |
| | | if (R.isOk(sysUserVOR)) { |
| | | SysUserVO sysUserVO = |
| | |
| | | comMngCarDOS.add(comMngCarDO); |
| | | } |
| | | }); |
| | | this.saveBatch(comMngCarDOS); |
| | | return R.ok("共计导入车辆数量:" + comMngCarDOS.size()); |
| | | if(comMngCarDOS.isEmpty()){ |
| | | return R.fail("导入数据有误"); |
| | | } |
| | | else { |
| | | this.saveBatch(comMngCarDOS); |
| | | return R.ok("共计导入车辆数量:" + comMngCarDOS.size()); |
| | | } |
| | | } |
| | | |
| | | @Override |