From ee78c9967bf142441e967e6c18d1459e44652acb Mon Sep 17 00:00:00 2001
From: java110 <928255095@qq.com>
Date: 星期日, 13 十二月 2020 00:09:59 +0800
Subject: [PATCH] 加入根据权限ID 和商户ID查询员工ID

---
 service-order/src/main/java/com/java110/order/dao/impl/PrivilegeDAOImpl.java |  120 +++++++++++++++++++++++++++++++++++------------------------
 1 files changed, 71 insertions(+), 49 deletions(-)

diff --git a/service-order/src/main/java/com/java110/order/dao/impl/PrivilegeDAOImpl.java b/service-order/src/main/java/com/java110/order/dao/impl/PrivilegeDAOImpl.java
index a8e8f2c..c58c84c 100644
--- a/service-order/src/main/java/com/java110/order/dao/impl/PrivilegeDAOImpl.java
+++ b/service-order/src/main/java/com/java110/order/dao/impl/PrivilegeDAOImpl.java
@@ -1,10 +1,10 @@
 package com.java110.order.dao.impl;
 
 import com.alibaba.fastjson.JSONObject;
-import com.java110.utils.constant.ResponseConstant;
-import com.java110.utils.exception.DAOException;
 import com.java110.core.base.dao.BaseServiceDao;
 import com.java110.order.dao.IPrivilegeDAO;
+import com.java110.utils.constant.ResponseConstant;
+import com.java110.utils.exception.DAOException;
 import org.slf4j.Logger;
 import org.slf4j.LoggerFactory;
 import org.springframework.stereotype.Service;
@@ -22,15 +22,15 @@
 
     @Override
     public boolean saveUserDefaultPrivilege(Map info) {
-        logger.debug("鐢ㄦ埛榛樿鏉冮檺淇濆瓨鍏ュ弬锛歿}",info);
-        List<Map> ps = sqlSessionTemplate.selectList("privilegeDAOImpl.queryUserDefaultPrivilege",info);
-        if(ps.size()>0){
+        logger.debug("鐢ㄦ埛榛樿鏉冮檺淇濆瓨鍏ュ弬锛歿}", info);
+        List<Map> ps = sqlSessionTemplate.selectList("privilegeDAOImpl.queryUserDefaultPrivilege", info);
+        if (ps.size() > 0) {
             //璇存槑鐢ㄦ埛宸茬粡娣诲姞浜嗛粯璁ゆ潈闄愮粍锛岃繖閲屼笉鍋氬鐞嗙洿鎺ヨ繑鍥�
             return true;
         }
-        int saveFlag = sqlSessionTemplate.insert("privilegeDAOImpl.saveUserDefaultPrivilege",info);
-        if(saveFlag < 1){
-            throw new DAOException(ResponseConstant.RESULT_CODE_INNER_ERROR,"淇濆瓨鏉冮檺淇℃伅澶辫触锛�"+ JSONObject.toJSONString(info));
+        int saveFlag = sqlSessionTemplate.insert("privilegeDAOImpl.saveUserDefaultPrivilege", info);
+        if (saveFlag < 1) {
+            throw new DAOException(ResponseConstant.RESULT_CODE_INNER_ERROR, "淇濆瓨鏉冮檺淇℃伅澶辫触锛�" + JSONObject.toJSONString(info));
         }
         return true;
     }
@@ -38,154 +38,176 @@
 
     /**
      * 鍒犻櫎鐢ㄦ墍鏈夋潈闄�
+     *
      * @param info
      * @return
      */
-    public boolean deleteUserAllPrivilege(Map info){
-        logger.debug("鐢ㄦ埛榛樿鏉冮檺淇濆瓨鍏ュ弬锛歿}",info);
-        int saveFlag = sqlSessionTemplate.insert("privilegeDAOImpl.deleteUserAllPrivilege",info);
-        if(saveFlag < 1){
-            throw new DAOException(ResponseConstant.RESULT_CODE_INNER_ERROR,"鍒犻櫎鏉冮檺淇℃伅澶辫触锛�"+ JSONObject.toJSONString(info));
+    public boolean deleteUserAllPrivilege(Map info) {
+        logger.debug("鐢ㄦ埛榛樿鏉冮檺淇濆瓨鍏ュ弬锛歿}", info);
+        int saveFlag = sqlSessionTemplate.insert("privilegeDAOImpl.deleteUserAllPrivilege", info);
+        if (saveFlag < 1) {
+            throw new DAOException(ResponseConstant.RESULT_CODE_INNER_ERROR, "鍒犻櫎鏉冮檺淇℃伅澶辫触锛�" + JSONObject.toJSONString(info));
         }
         return true;
     }
 
     /**
      * 淇濆瓨鏉冮檺缁�
+     *
      * @param info
      * @return
      */
     @Override
     public boolean savePrivilegeGroup(Map info) {
-        logger.debug("淇濆瓨鏉冮檺缁勪俊鎭叆鍙傦細{}",info);
-        int saveFlag = sqlSessionTemplate.insert("privilegeDAOImpl.savePrivilegeGroup",info);
-        if(saveFlag < 1){
-            throw new DAOException(ResponseConstant.RESULT_CODE_INNER_ERROR,"淇濆瓨鏉冮檺缁勪俊鎭け璐ワ細"+ JSONObject.toJSONString(info));
+        logger.debug("淇濆瓨鏉冮檺缁勪俊鎭叆鍙傦細{}", info);
+        int saveFlag = sqlSessionTemplate.insert("privilegeDAOImpl.savePrivilegeGroup", info);
+        if (saveFlag < 1) {
+            throw new DAOException(ResponseConstant.RESULT_CODE_INNER_ERROR, "淇濆瓨鏉冮檺缁勪俊鎭け璐ワ細" + JSONObject.toJSONString(info));
         }
         return true;
     }
 
     /**
      * 淇濆瓨鏉冮檺缁�
+     *
      * @param info
      * @return
      */
     @Override
     public boolean updatePrivilegeGroup(Map info) {
-        logger.debug("缂栬緫鏉冮檺缁勪俊鎭叆鍙傦細{}",info);
-        int saveFlag = sqlSessionTemplate.insert("privilegeDAOImpl.updatePrivilegeGroup",info);
-        if(saveFlag < 1){
-            throw new DAOException(ResponseConstant.RESULT_CODE_INNER_ERROR,"缂栬緫鏉冮檺缁勪俊鎭け璐ワ細"+ JSONObject.toJSONString(info));
+        logger.debug("缂栬緫鏉冮檺缁勪俊鎭叆鍙傦細{}", info);
+        int saveFlag = sqlSessionTemplate.insert("privilegeDAOImpl.updatePrivilegeGroup", info);
+        if (saveFlag < 1) {
+            throw new DAOException(ResponseConstant.RESULT_CODE_INNER_ERROR, "缂栬緫鏉冮檺缁勪俊鎭け璐ワ細" + JSONObject.toJSONString(info));
         }
         return true;
     }
 
     /**
      * 鍒犻櫎鏉冮檺缁�
+     *
      * @param info
      * @return
      */
     @Override
     public boolean deletePrivilegeGroup(Map info) {
-        logger.debug("鍒犻櫎鏉冮檺缁勪俊鎭叆鍙傦細{}",info);
-        int saveFlag = sqlSessionTemplate.insert("privilegeDAOImpl.deletePrivilegeGroup",info);
-        if(saveFlag < 1){
-            throw new DAOException(ResponseConstant.RESULT_CODE_INNER_ERROR,"鍒犻櫎鏉冮檺缁勪俊鎭け璐ワ細"+ JSONObject.toJSONString(info));
+        logger.debug("鍒犻櫎鏉冮檺缁勪俊鎭叆鍙傦細{}", info);
+        int saveFlag = sqlSessionTemplate.insert("privilegeDAOImpl.deletePrivilegeGroup", info);
+        if (saveFlag < 1) {
+            throw new DAOException(ResponseConstant.RESULT_CODE_INNER_ERROR, "鍒犻櫎鏉冮檺缁勪俊鎭け璐ワ細" + JSONObject.toJSONString(info));
         }
         return true;
     }
 
     /**
      * 鍒犻櫎鏉冮檺缁勪笅鏉冮檺
+     *
      * @param info
      * @return
      */
     @Override
     public boolean deletePrivilegeRel(Map info) {
-        logger.debug("鍒犻櫎鏉冮檺缁勪笅鏉冮檺淇℃伅鍏ュ弬锛歿}",info);
-        int saveFlag = sqlSessionTemplate.insert("privilegeDAOImpl.deletePrivilegeRel",info);
-        if(saveFlag < 1){
-            throw new DAOException(ResponseConstant.RESULT_CODE_INNER_ERROR,"鍒犻櫎鏉冮檺缁勪笅鏉冮檺淇℃伅澶辫触锛�"+ JSONObject.toJSONString(info));
+        logger.debug("鍒犻櫎鏉冮檺缁勪笅鏉冮檺淇℃伅鍏ュ弬锛歿}", info);
+        int saveFlag = sqlSessionTemplate.insert("privilegeDAOImpl.deletePrivilegeRel", info);
+        if (saveFlag < 1) {
+            throw new DAOException(ResponseConstant.RESULT_CODE_INNER_ERROR, "鍒犻櫎鏉冮檺缁勪笅鏉冮檺淇℃伅澶辫触锛�" + JSONObject.toJSONString(info));
         }
         return true;
     }
 
     /**
      * 鏌ヨ鏉冮檺缁勪笅鏉冮檺
+     *
      * @param info
      * @return
      */
     @Override
     public List<Map> queryPrivilegeRel(Map info) {
-        logger.debug("鏌ヨ鏉冮檺缁勪笅鏉冮檺淇℃伅鍏ュ弬锛歿}",info);
-        return sqlSessionTemplate.selectList("privilegeDAOImpl.queryPrivilegeRel",info);
+        logger.debug("鏌ヨ鏉冮檺缁勪笅鏉冮檺淇℃伅鍏ュ弬锛歿}", info);
+        return sqlSessionTemplate.selectList("privilegeDAOImpl.queryPrivilegeRel", info);
     }
 
-    public List<Map> queryPrivilegeGroup(Map info){
-        logger.debug("鏌ヨ鏉冮檺缁勪笅鏉冮檺淇℃伅鍏ュ弬锛歿}",info);
-        return sqlSessionTemplate.selectList("privilegeDAOImpl.queryPrivilegeGroup",info);
+    public List<Map> queryPrivilegeGroup(Map info) {
+        logger.debug("鏌ヨ鏉冮檺缁勪笅鏉冮檺淇℃伅鍏ュ弬锛歿}", info);
+        return sqlSessionTemplate.selectList("privilegeDAOImpl.queryPrivilegeGroup", info);
     }
 
     @Override
     public boolean addPrivilegeRel(Map info) {
-        logger.debug("娣诲姞鏉冮檺缁勪笅鏉冮檺淇℃伅鍏ュ弬锛歿}",info);
-        int saveFlag = sqlSessionTemplate.insert("privilegeDAOImpl.addPrivilegeRel",info);
-        if(saveFlag < 1){
-            throw new DAOException(ResponseConstant.RESULT_CODE_INNER_ERROR,"娣诲姞鏉冮檺缁勪笅鏉冮檺淇℃伅澶辫触锛�"+ JSONObject.toJSONString(info));
+        logger.debug("娣诲姞鏉冮檺缁勪笅鏉冮檺淇℃伅鍏ュ弬锛歿}", info);
+        int saveFlag = sqlSessionTemplate.insert("privilegeDAOImpl.addPrivilegeRel", info);
+        if (saveFlag < 1) {
+            throw new DAOException(ResponseConstant.RESULT_CODE_INNER_ERROR, "娣诲姞鏉冮檺缁勪笅鏉冮檺淇℃伅澶辫触锛�" + JSONObject.toJSONString(info));
         }
         return true;
     }
 
     /**
      * 鏌ヨ鏉冮檺
+     *
      * @param info
      * @return
      */
     @Override
     public List<Map> queryPrivilege(Map info) {
-        logger.debug("鏌ヨ鏉冮檺淇℃伅鍏ュ弬锛歿}",info);
-        return sqlSessionTemplate.selectList("privilegeDAOImpl.queryPrivilege",info);
+        logger.debug("鏌ヨ鏉冮檺淇℃伅鍏ュ弬锛歿}", info);
+        return sqlSessionTemplate.selectList("privilegeDAOImpl.queryPrivilege", info);
     }
 
     /**
      * 鏌ヨ鐢ㄦ埛榛樿鏉冮檺
+     *
      * @param info
      * @return
      */
     @Override
     public List<Map> queryUserPrivilege(Map info) {
-        logger.debug("鏌ヨ鐢ㄦ埛鏉冮檺淇℃伅鍏ュ弬锛歿}",info);
-        return sqlSessionTemplate.selectList("privilegeDAOImpl.queryUserPrivilege",info);
+        logger.debug("鏌ヨ鐢ㄦ埛鏉冮檺淇℃伅鍏ュ弬锛歿}", info);
+        return sqlSessionTemplate.selectList("privilegeDAOImpl.queryUserPrivilege", info);
     }
 
     /**
      * 娣诲姞鐢ㄦ埛鏉冮檺
+     *
      * @param info
      * @return
      */
     @Override
     public boolean addUserPrivilege(Map info) {
-        logger.debug("娣诲姞鐢ㄦ埛鏉冮檺淇℃伅鍏ュ弬锛歿}",info);
-        int saveFlag = sqlSessionTemplate.insert("privilegeDAOImpl.addUserPrivilege",info);
-        if(saveFlag < 1){
-            throw new DAOException(ResponseConstant.RESULT_CODE_INNER_ERROR,"娣诲姞鐢ㄦ埛鏉冮檺淇℃伅澶辫触锛�"+ JSONObject.toJSONString(info));
+        logger.debug("娣诲姞鐢ㄦ埛鏉冮檺淇℃伅鍏ュ弬锛歿}", info);
+        int saveFlag = sqlSessionTemplate.insert("privilegeDAOImpl.addUserPrivilege", info);
+        if (saveFlag < 1) {
+            throw new DAOException(ResponseConstant.RESULT_CODE_INNER_ERROR, "娣诲姞鐢ㄦ埛鏉冮檺淇℃伅澶辫触锛�" + JSONObject.toJSONString(info));
         }
         return true;
     }
 
     /**
      * 鍒犻櫎鐢ㄦ埛鏉冮檺
+     *
      * @param info
      * @return
      */
     @Override
     public boolean deleteUserPrivilege(Map info) {
-        int saveFlag = sqlSessionTemplate.insert("privilegeDAOImpl.deleteUserPrivilege",info);
-        if(saveFlag < 1){
-            throw new DAOException(ResponseConstant.RESULT_CODE_INNER_ERROR,"鍒犻櫎鏉冮檺淇℃伅澶辫触锛�"+ JSONObject.toJSONString(info));
+        int saveFlag = sqlSessionTemplate.insert("privilegeDAOImpl.deleteUserPrivilege", info);
+        if (saveFlag < 1) {
+            throw new DAOException(ResponseConstant.RESULT_CODE_INNER_ERROR, "鍒犻櫎鏉冮檺淇℃伅澶辫触锛�" + JSONObject.toJSONString(info));
         }
         return true;
     }
 
+    /**
+     * Query employees with this permission
+     *
+     * @param info this permission
+     * @return employees
+     */
+    @Override
+    public List<Map> queryPrivilegeUsers(Map info) {
+        logger.debug("鏌ヨ鐗瑰畾鏉冮檺鍛樺伐鍏ュ弬锛歿}", info);
+        return sqlSessionTemplate.selectList("privilegeDAOImpl.queryPrivilegeUsers", info);
+    }
+
 
 }

--
Gitblit v1.8.0