优化巡检路线查询sql

mrzcc

2020-02-19 b09e1a8b036553d1e161d127aa738a504593490a

 CommunityService/src/main/java/com/java110/community/dao/impl/RoomServiceDaoImpl.java

@@ -1,9 +1,9 @@
package com.java110.community.dao.impl;

import com.alibaba.fastjson.JSONObject;
import com.java110.common.constant.ResponseConstant;
import com.java110.common.exception.DAOException;
import com.java110.common.util.DateUtil;
import com.java110.utils.constant.ResponseConstant;
import com.java110.utils.exception.DAOException;
import com.java110.utils.util.DateUtil;
import com.java110.community.dao.IRoomServiceDao;
import com.java110.core.base.dao.BaseServiceDao;
import org.slf4j.Logger;
@@ -130,5 +130,79 @@
        return Integer.parseInt(businessRoomInfos.get(0).get("count").toString());
    }

    @Override
    public int queryRoomsByCommunityIdCount(Map info) {
        logger.debug("查询小区房屋数据 入参 info : {}", info);

        List<Map> businessRoomInfos = sqlSessionTemplate.selectList("roomServiceDaoImpl.queryRoomsByCommunityIdCount", info);
        if (businessRoomInfos.size() < 1) {
            return 0;
        }

        return Integer.parseInt(businessRoomInfos.get(0).get("count").toString());
    }

    @Override
    public int queryRoomsWithOutSellByCommunityIdCount(Map info) {
        logger.debug("查询小区房屋数据 入参 info : {}", info);

        List<Map> businessRoomInfos = sqlSessionTemplate.selectList("roomServiceDaoImpl.queryRoomsWithOutSellByCommunityIdCount", info);
        if (businessRoomInfos.size() < 1) {
            return 0;
        }

        return Integer.parseInt(businessRoomInfos.get(0).get("count").toString());
    }

    @Override
    public int queryRoomsWithSellByCommunityIdCount(Map info) {
        logger.debug("查询小区房屋数据 入参 info : {}", info);

        List<Map> businessRoomInfos = sqlSessionTemplate.selectList("roomServiceDaoImpl.queryRoomsWithSellByCommunityIdCount", info);
        if (businessRoomInfos.size() < 1) {
            return 0;
        }

        return Integer.parseInt(businessRoomInfos.get(0).get("count").toString());
    }

    @Override
    public List<Map> getRoomInfoByCommunityId(Map info) {
        logger.debug("查询小区房屋信息 入参 info : {}", info);

        List<Map> businessRoomInfos = sqlSessionTemplate.selectList("roomServiceDaoImpl.getRoomInfoByCommunityId", info);

        return businessRoomInfos;
    }

    @Override
    public List<Map> getRoomInfoByOwner(Map info) {
        logger.debug("查询小区房屋信息 入参 info : {}", info);

        List<Map> businessRoomInfos = sqlSessionTemplate.selectList("roomServiceDaoImpl.getRoomInfoByOwner", info);

        return businessRoomInfos;
    }

    @Override
    public List<Map> getRoomInfoWithOutSellByCommunityId(Map info) {
        logger.debug("查询小区房屋信息 入参 info : {}", info);

        List<Map> businessRoomInfos = sqlSessionTemplate.selectList("roomServiceDaoImpl.getRoomInfoWithOutSellByCommunityId", info);

        return businessRoomInfos;
    }


    @Override
    public List<Map> getRoomInfoWithSellByCommunityId(Map info) {
        logger.debug("查询小区房屋信息 入参 info : {}", info);

        List<Map> businessRoomInfos = sqlSessionTemplate.selectList("roomServiceDaoImpl.getRoomInfoWithSellByCommunityId", info);

        return businessRoomInfos;
    }



}