From b09e1a8b036553d1e161d127aa738a504593490a Mon Sep 17 00:00:00 2001
From: mrzcc <121184950@qq.com>
Date: 星期三, 19 二月 2020 12:14:55 +0800
Subject: [PATCH] 优化巡检路线查询sql
---
CommunityService/src/main/java/com/java110/community/dao/impl/RoomServiceDaoImpl.java | 37 ++++++++++++++++++++++++++++++++++---
1 files changed, 34 insertions(+), 3 deletions(-)
diff --git a/CommunityService/src/main/java/com/java110/community/dao/impl/RoomServiceDaoImpl.java b/CommunityService/src/main/java/com/java110/community/dao/impl/RoomServiceDaoImpl.java
index afced8e..b5ffd8e 100644
--- a/CommunityService/src/main/java/com/java110/community/dao/impl/RoomServiceDaoImpl.java
+++ b/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;
@@ -155,6 +155,18 @@
}
@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);
@@ -164,6 +176,15 @@
}
@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);
@@ -173,5 +194,15 @@
}
+ @Override
+ public List<Map> getRoomInfoWithSellByCommunityId(Map info) {
+ logger.debug("鏌ヨ灏忓尯鎴垮眿淇℃伅 鍏ュ弬 info : {}", info);
+
+ List<Map> businessRoomInfos = sqlSessionTemplate.selectList("roomServiceDaoImpl.getRoomInfoWithSellByCommunityId", info);
+
+ return businessRoomInfos;
+ }
+
+
}
--
Gitblit v1.8.0