From 7e3a731b960455b16016c3c4e2e727caa8190bb0 Mon Sep 17 00:00:00 2001
From: java110 <928255095@qq.com>
Date: 星期一, 01 六月 2020 12:03:04 +0800
Subject: [PATCH] 优化查询小区多条是报错问题
---
CommunityService/src/main/java/com/java110/community/dao/impl/MenuServiceDaoImpl.java | 42 +++++++++++++++++++++++++-----------------
1 files changed, 25 insertions(+), 17 deletions(-)
diff --git a/CommunityService/src/main/java/com/java110/community/dao/impl/MenuServiceDaoImpl.java b/CommunityService/src/main/java/com/java110/community/dao/impl/MenuServiceDaoImpl.java
index 7ac1d0a..bdf20f1 100644
--- a/CommunityService/src/main/java/com/java110/community/dao/impl/MenuServiceDaoImpl.java
+++ b/CommunityService/src/main/java/com/java110/community/dao/impl/MenuServiceDaoImpl.java
@@ -1,12 +1,9 @@
package com.java110.community.dao.impl;
-import com.alibaba.fastjson.JSONObject;
-import com.java110.common.cache.MappingCache;
-import com.java110.common.constant.DomainContant;
-import com.java110.common.constant.ResponseConstant;
-import com.java110.common.constant.StatusConstant;
-import com.java110.common.exception.DAOException;
-import com.java110.common.util.DateUtil;
+import com.java110.utils.cache.MappingCache;
+import com.java110.utils.constant.DomainContant;
+import com.java110.utils.constant.StatusConstant;
+import com.java110.utils.exception.DAOException;
import com.java110.community.dao.IMenuServiceDao;
import com.java110.core.base.dao.BaseServiceDao;
import org.slf4j.Logger;
@@ -114,9 +111,9 @@
// 灏嗘潈闄愮粍鍒嗛厤缁欏搴斿晢鎴风被鍨嬬鐞嗗憳
- info.put("pgId",MappingCache.getValue(DomainContant.DEFAULT_PRIVILEGE_ADMIN, info.get("domain").toString()));
+ info.put("pgId", MappingCache.getValue(DomainContant.DEFAULT_PRIVILEGE_ADMIN, info.get("domain").toString()));
- saveFlag = sqlSessionTemplate.insert("menuServiceDaoImpl.saveBasePrivilegeRelInfo", info);
+ saveFlag = sqlSessionTemplate.insert("menuServiceDaoImpl.saveBasePrivilegeRelInfo", info);
return saveFlag;
@@ -151,14 +148,14 @@
logger.debug("淇敼璺敱淇℃伅Instance 鍏ュ弬 info : {}", info);
int saveFlag = 0;
//鍒ゆ柇鏄惁涓哄垹闄�
- if(info.containsKey("statusCd") && StatusConstant.STATUS_CD_INVALID.equals(info.get("statusCd"))){
- //鍋氭煡璇�
+ if (info.containsKey("statusCd") && StatusConstant.STATUS_CD_INVALID.equals(info.get("statusCd"))) {
+ //鍋氭煡璇�
List<Map> basePrivileges = getBasePrivilegeInfo(info);
- if(basePrivileges != null && basePrivileges.size() > 0){
+ if (basePrivileges != null && basePrivileges.size() > 0) {
saveFlag = sqlSessionTemplate.update("menuServiceDaoImpl.updateBasePrivilegeRelInfo", info);
- if(saveFlag < 1){
+ if (saveFlag < 1) {
return saveFlag;
}
}
@@ -185,6 +182,17 @@
}
return Integer.parseInt(businessBasePrivilegeInfos.get(0).get("count").toString());
+ }
+
+ @Override
+ public boolean checkUserHasResource(Map info) {
+ logger.debug("鏌ヨ璺敱淇℃伅 鍏ュ弬 info : {}", info);
+
+ List<Map> businessBasePrivilegeInfos = sqlSessionTemplate.selectList("menuServiceDaoImpl.checkUserHasResource", info);
+ if (businessBasePrivilegeInfos != null && businessBasePrivilegeInfos.size() > 0) {
+ return true;
+ }
+ return false;
}
@@ -234,24 +242,24 @@
int saveFlag = 0;
//鍒ゆ柇鏄惁涓哄垹闄�
- if(info.containsKey("statusCd") && StatusConstant.STATUS_CD_INVALID.equals(info.get("statusCd"))){
+ if (info.containsKey("statusCd") && StatusConstant.STATUS_CD_INVALID.equals(info.get("statusCd"))) {
//鍋氭煡璇�
List<Map> baseMenus = getMenuInfo(info);
- if(baseMenus != null && baseMenus.size() > 0){
+ if (baseMenus != null && baseMenus.size() > 0) {
Map privilegeInfo = new HashMap();
privilegeInfo.put("pId", baseMenus.get(0).get("pId"));
privilegeInfo.put("statusCd", StatusConstant.STATUS_CD_INVALID);
//鍒犻櫎鏉冮檺 鏉冮檺缁勫叧绯�
saveFlag = sqlSessionTemplate.update("menuServiceDaoImpl.updateBasePrivilegeRelInfo", info);
- if(saveFlag < 1){
+ if (saveFlag < 1) {
return saveFlag;
}
//鍒犻櫎鏉冮檺
saveFlag = sqlSessionTemplate.update("menuServiceDaoImpl.updateBasePrivilegeInfo", info);
- if(saveFlag < 1){
+ if (saveFlag < 1) {
return saveFlag;
}
}
--
Gitblit v1.8.0