From 6ff51cb81fe0e48db554f5f7ebde0d167650cef3 Mon Sep 17 00:00:00 2001
From: wuxw <928255095@qq.com>
Date: 星期四, 14 十一月 2019 20:05:55 +0800
Subject: [PATCH] 优化业主查询

---
 UserService/src/main/java/com/java110/user/dao/impl/OwnerServiceDaoImpl.java |   88 ++++++++++++++++++++++++++++++++++++++++++-
 1 files changed, 85 insertions(+), 3 deletions(-)

diff --git a/UserService/src/main/java/com/java110/user/dao/impl/OwnerServiceDaoImpl.java b/UserService/src/main/java/com/java110/user/dao/impl/OwnerServiceDaoImpl.java
index 28d34d5..e422ed1 100644
--- a/UserService/src/main/java/com/java110/user/dao/impl/OwnerServiceDaoImpl.java
+++ b/UserService/src/main/java/com/java110/user/dao/impl/OwnerServiceDaoImpl.java
@@ -1,9 +1,9 @@
 package com.java110.user.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.core.base.dao.BaseServiceDao;
 import com.java110.user.dao.IOwnerServiceDao;
 import org.slf4j.Logger;
@@ -94,6 +94,25 @@
         return businessOwnerInfos;
     }
 
+    /**
+     * 鏌ヨ涓氫富淇℃伅锛坕nstance锛�
+     *
+     * @param info bId 淇℃伅
+     * @return List<Map>
+     * @throws DAOException DAO寮傚父
+     */
+    @Override
+    public int getOwnerInfoCount(Map info) throws DAOException {
+        logger.debug("鏌ヨ涓氫富淇℃伅 鍏ュ弬 info : {}", info);
+        List<Map> businessOwnerInfos = sqlSessionTemplate.selectList("ownerServiceDaoImpl.getOwnerInfoCount", info);
+        if (businessOwnerInfos.size() < 1) {
+            return 0;
+        }
+
+        return Integer.parseInt(businessOwnerInfos.get(0).get("count").toString());
+    }
+
+
 
     /**
      * 淇敼涓氫富淇℃伅
@@ -130,5 +149,68 @@
         return Integer.parseInt(businessOwnerInfos.get(0).get("count").toString());
     }
 
+    /**
+     * 鏌ヨ涓氫富鏁伴噺
+     *
+     * @param info 涓氫富淇℃伅
+     * @return 涓氫富鏁伴噺
+     */
+    @Override
+    public int queryOwnersCountByCondition(Map info) {
+        logger.debug("鏌ヨ涓氫富鏁版嵁 鍏ュ弬 info : {}", info);
+
+        List<Map> businessOwnerInfos = sqlSessionTemplate.selectList("ownerServiceDaoImpl.queryOwnersCountByCondition", info);
+        if (businessOwnerInfos.size() < 1) {
+            return 0;
+        }
+
+        return Integer.parseInt(businessOwnerInfos.get(0).get("count").toString());
+    }
+
+    /**
+     * 鏌ヨ涓氫富淇℃伅锛坕nstance锛�
+     *
+     * @param info bId 淇℃伅
+     * @return List<Map>
+     * @throws DAOException DAO寮傚父
+     */
+    @Override
+    public List<Map> getOwnerInfoByCondition(Map info) throws DAOException {
+        logger.debug("鏌ヨ涓氫富淇℃伅 鍏ュ弬 info : {}", info);
+
+        List<Map> businessOwnerInfos = sqlSessionTemplate.selectList("ownerServiceDaoImpl.getOwnerInfoByCondition", info);
+
+        return businessOwnerInfos;
+    }
+
+    @Override
+    public int queryNoEnterRoomOwnerCount(Map info) {
+        logger.debug("鏌ヨ涓氫富鏁版嵁 鍏ュ弬 info : {}", info);
+
+        List<Map> businessOwnerInfos = sqlSessionTemplate.selectList("ownerServiceDaoImpl.queryNoEnterRoomOwnerCount", info);
+        if (businessOwnerInfos.size() < 1) {
+            return 0;
+        }
+
+        return Integer.parseInt(businessOwnerInfos.get(0).get("count").toString());
+    }
+
+    @Override
+    public List<Map> queryOwnersByRoom(Map info) throws DAOException {
+        logger.debug("queryOwnersByRoom 鍏ュ弬 info : {}", info);
+
+        List<Map> businessOwnerInfos = sqlSessionTemplate.selectList("ownerServiceDaoImpl.queryOwnersByRoom", info);
+
+        return businessOwnerInfos;
+    }
+
+    @Override
+    public List<Map> queryOwnersByParkingSpace(Map info) throws DAOException {
+        logger.debug("queryOwnersByParkingSpace 鍏ュ弬 info : {}", info);
+
+        List<Map> businessOwnerInfos = sqlSessionTemplate.selectList("ownerServiceDaoImpl.queryOwnersByParkingSpace", info);
+
+        return businessOwnerInfos;    }
+
 
 }

--
Gitblit v1.8.0