优化查询业主功能

Your Name

2023-03-28 aa0a6c4c7a8e8b21762314d10901b85612e19f4e

 service-community/src/main/java/com/java110/community/smo/impl/RoomInnerServiceSMOImpl.java

old mode 100644
new mode 100755
@@ -1,20 +1,25 @@
package com.java110.community.smo.impl;


import com.java110.utils.cache.MappingCache;
import com.java110.utils.constant.StatusConstant;
import com.java110.utils.util.BeanConvertUtil;
import com.java110.community.dao.IRoomAttrServiceDao;
import com.java110.community.dao.IRoomServiceDao;
import com.java110.core.base.smo.BaseServiceSMO;
import com.java110.intf.community.IRoomInnerServiceSMO;
import com.java110.intf.user.IUserInnerServiceSMO;
import com.java110.core.log.LoggerFactory;
import com.java110.dto.PageDto;
import com.java110.dto.RoomAttrDto;
import com.java110.dto.RoomDto;
import com.java110.dto.owner.OwnerRoomRelDto;
import com.java110.dto.user.UserDto;
import com.java110.entity.assetImport.ImportCustomCreateFeeDto;
import com.java110.entity.assetImport.ImportRoomFee;
import com.java110.intf.community.IRoomInnerServiceSMO;
import com.java110.intf.user.IOwnerRoomRelV1InnerServiceSMO;
import com.java110.intf.user.IUserInnerServiceSMO;
import com.java110.po.room.RoomPo;
import com.java110.utils.cache.MappingCache;
import com.java110.utils.constant.StatusConstant;
import com.java110.utils.util.BeanConvertUtil;
import com.java110.utils.util.StringUtil;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RestController;
@@ -46,6 +51,9 @@
    @Autowired
    private IUserInnerServiceSMO userInnerServiceSMOImpl;

    @Autowired
    private IOwnerRoomRelV1InnerServiceSMO ownerRoomRelV1InnerServiceSMOImpl;

    @Override
    public List<RoomDto> queryRooms(@RequestBody RoomDto roomDto) {

@@ -63,15 +71,23 @@
            return rooms;
        }

        if (rooms.size() > 50) {
            return rooms;
        }

        String[] roomIds = getRoomIds(rooms);
        Map attrParamInfo = new HashMap();
        attrParamInfo.put("roomIds", roomIds);
        attrParamInfo.put("statusCd", StatusConstant.STATUS_CD_VALID);
        List<RoomAttrDto> roomAttrDtos = BeanConvertUtil.covertBeanList(roomAttrServiceDaoImpl.getRoomAttrInfo(attrParamInfo), RoomAttrDto.class);

        String[] userIds = getUserIds(rooms);
        //根据 userId 查询用户信息
        List<UserDto> users = userInnerServiceSMOImpl.getUserInfo(userIds);
        List<UserDto> users = null;
        if (rooms.size() < 2) {
            String[] userIds = getUserIds(rooms);
            //根据 userId 查询用户信息
            users = userInnerServiceSMOImpl.getUserInfo(userIds);
        } else {
            users = new ArrayList<>();
        }

        for (RoomDto room : rooms) {
            try {
@@ -82,6 +98,12 @@
            refreshRoom(room, users, roomAttrDtos);
        }
        return rooms;
    }

    @Override
    public int updateRooms(@RequestBody RoomPo roomPo) {
        roomServiceDaoImpl.updateRoomInfoInstance(BeanConvertUtil.beanCovertMap(roomPo));
        return 1;
    }

    /**
@@ -102,19 +124,17 @@
            return;
        }

        List<RoomAttrDto> tmpRoomAttrDtos = new ArrayList<>();
        for (RoomAttrDto roomAttrDto : roomAttrDtos) {
            if (!roomAttrDto.getRoomId().equals(room.getRoomId())) {
                continue;
            }

            List<RoomAttrDto> tmpRoomAttrDtos = room.getRoomAttrDto();

            if (tmpRoomAttrDtos == null) {
                tmpRoomAttrDtos = new ArrayList<>();
            if (StringUtil.isEmpty(roomAttrDto.getValueName())) {
                roomAttrDto.setValueName(roomAttrDto.getValue());
            }

            tmpRoomAttrDtos.add(roomAttrDto);
        }
        room.setRoomAttrDto(tmpRoomAttrDtos);
    }

    /**
@@ -242,33 +262,77 @@
    @Override
    public List<RoomDto> queryRoomsByOwner(@RequestBody RoomDto roomDto) {

        List<RoomDto> rooms = BeanConvertUtil.covertBeanList(roomServiceDaoImpl.getRoomInfoByOwner(BeanConvertUtil.beanCovertMap(roomDto)),
                RoomDto.class);
//        List<RoomDto> rooms = BeanConvertUtil.covertBeanList(roomServiceDaoImpl.getRoomInfoByOwner(BeanConvertUtil.beanCovertMap(roomDto)),
//                RoomDto.class);
//
//        if (rooms == null || rooms.size() == 0) {
//            return rooms;
//        }

        if (rooms == null || rooms.size() == 0) {
            return rooms;
        OwnerRoomRelDto ownerRoomRelDto = new OwnerRoomRelDto();
        ownerRoomRelDto.setOwnerId(roomDto.getOwnerId());
        ownerRoomRelDto.setOwnerNameLike(roomDto.getOwnerNameLike());
        List<OwnerRoomRelDto> ownerRoomRelDtos = ownerRoomRelV1InnerServiceSMOImpl.queryOwnerRoomRels(ownerRoomRelDto);
        if (ownerRoomRelDtos == null || ownerRoomRelDtos.size() < 1) {
            return new ArrayList<>();
        }

        String[] roomIds = getRoomIds(rooms);
        Map attrParamInfo = new HashMap();
        attrParamInfo.put("roomIds", roomIds);
        attrParamInfo.put("statusCd", StatusConstant.STATUS_CD_VALID);
        List<RoomAttrDto> roomAttrDtos = BeanConvertUtil.covertBeanList(roomAttrServiceDaoImpl.getRoomAttrInfo(attrParamInfo), RoomAttrDto.class);
        List<String> roomIds = new ArrayList<>();
        for (OwnerRoomRelDto tmpOwnerRoomRelDto : ownerRoomRelDtos) {
            roomIds.add(tmpOwnerRoomRelDto.getRoomId());
        }
        RoomDto tmpRoomDto = new RoomDto();
        tmpRoomDto.setRoomIds(roomIds.toArray(new String[roomIds.size()]));
        tmpRoomDto.setRoomNum(roomDto.getRoomNum());
        tmpRoomDto.setCommunityId(roomDto.getCommunityId());
        return queryRooms(tmpRoomDto);

        String[] userIds = getUserIds(rooms);
        //根据 userId 查询用户信息
        List<UserDto> users = userInnerServiceSMOImpl.getUserInfo(userIds);
    }

        for (RoomDto room : rooms) {
            //处理下户型转义问题
            try {
                room.setApartment(MappingCache.getValue(room.getApartment().substring(0, 2).toString()) + MappingCache.getValue(room.getApartment().substring(2, 5).toString()));
            } catch (Exception e) {
                logger.error("设置房屋户型失败", e);
    /**
     * 刷新roomId
     *
     * @param importRoomFees 数据对象分享
     * @return
     */
    @Override
    public List<ImportRoomFee> freshRoomIds(@RequestBody List<ImportRoomFee> importRoomFees) {
        for (ImportRoomFee importRoomFee : importRoomFees) {
            List<Map> infos = null;
            if (!StringUtil.isEmpty(importRoomFee.getRoomId()) && !importRoomFee.getRoomId().startsWith("-")) {
                Map paramIn = new HashMap();
                paramIn.put("communityId", importRoomFee.getCommunityId());
                paramIn.put("roomId", importRoomFee.getRoomId());
                infos = roomServiceDaoImpl.getRoomInfos(BeanConvertUtil.beanCovertMap(importRoomFee));
            } else {
                infos = roomServiceDaoImpl.getRoomInfos(BeanConvertUtil.beanCovertMap(importRoomFee));
            }
            refreshRoom(room, users, roomAttrDtos);

            if (infos == null || infos.size() < 1) {
                continue;
            }
            importRoomFee.setRoomId(infos.get(0).get("roomId").toString());
            importRoomFee.setFloorNum(infos.get(0).get("floorNum").toString());
            importRoomFee.setUnitNum(infos.get(0).get("unitNum").toString());
            importRoomFee.setRoomNum(infos.get(0).get("roomNum").toString());

        }
        return rooms;
        return importRoomFees;
    }

    public List<ImportCustomCreateFeeDto> freshRoomIdsByImportCustomCreateFee(@RequestBody List<ImportCustomCreateFeeDto> importCustomCreateFeeDtos) {
        for (ImportCustomCreateFeeDto importRoomFee : importCustomCreateFeeDtos) {
            List<Map> infos = null;
            infos = roomServiceDaoImpl.getRoomInfos(BeanConvertUtil.beanCovertMap(importRoomFee));
            if (infos == null || infos.size() < 1) {
                continue;
            }
            importRoomFee.setPayObjId(infos.get(0).get("roomId").toString());
            importRoomFee.setFloorNum(infos.get(0).get("floorNum").toString());
            importRoomFee.setUnitNum(infos.get(0).get("unitNum").toString());
            importRoomFee.setRoomNum(infos.get(0).get("roomNum").toString());
        }
        return importCustomCreateFeeDtos;
    }

    public IRoomServiceDao getRoomServiceDaoImpl() {