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/MenuServiceDaoImpl.java | 31 +++++++++++++++++++++----------
1 files changed, 21 insertions(+), 10 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 0c82764..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
@@ -111,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;
@@ -148,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;
}
}
@@ -182,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;
}
@@ -231,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