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/smo/impl/MenuInnerServiceSMOImpl.java |   69 +++++++++++++++++++++++++++++++---
 1 files changed, 62 insertions(+), 7 deletions(-)

diff --git a/CommunityService/src/main/java/com/java110/community/smo/impl/MenuInnerServiceSMOImpl.java b/CommunityService/src/main/java/com/java110/community/smo/impl/MenuInnerServiceSMOImpl.java
index 44dfe30..c7ef2c3 100644
--- a/CommunityService/src/main/java/com/java110/community/smo/impl/MenuInnerServiceSMOImpl.java
+++ b/CommunityService/src/main/java/com/java110/community/smo/impl/MenuInnerServiceSMOImpl.java
@@ -1,15 +1,18 @@
 package com.java110.community.smo.impl;
 
 
-import com.java110.common.util.BeanConvertUtil;
+import com.java110.utils.util.BeanConvertUtil;
 import com.java110.community.dao.IMenuServiceDao;
 import com.java110.core.base.smo.BaseServiceSMO;
 import com.java110.core.smo.menu.IMenuInnerServiceSMO;
 import com.java110.dto.PageDto;
 import com.java110.dto.basePrivilege.BasePrivilegeDto;
+import com.java110.dto.menu.MenuDto;
 import com.java110.dto.menuGroup.MenuGroupDto;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.web.bind.annotation.RequestBody;
+import org.springframework.web.bind.annotation.RequestMapping;
+import org.springframework.web.bind.annotation.RequestMethod;
 import org.springframework.web.bind.annotation.RestController;
 
 import java.util.List;
@@ -30,7 +33,7 @@
 
 
     @Override
-    public List<MenuGroupDto> queryMenuGroups(@RequestBody  MenuGroupDto menuGroupDto) {
+    public List<MenuGroupDto> queryMenuGroups(@RequestBody MenuGroupDto menuGroupDto) {
 
         //鏍￠獙鏄惁浼犱簡 鍒嗛〉淇℃伅
 
@@ -38,7 +41,6 @@
 
         if (page != PageDto.DEFAULT_PAGE) {
             menuGroupDto.setPage((page - 1) * menuGroupDto.getRow());
-            menuGroupDto.setRow(page * menuGroupDto.getRow());
         }
 
         List<MenuGroupDto> menuGroups = BeanConvertUtil.covertBeanList(menuServiceDaoImpl.getMenuGroupInfo(BeanConvertUtil.beanCovertMap(menuGroupDto)), MenuGroupDto.class);
@@ -65,7 +67,8 @@
 
     @Override
     public int queryMenuGroupsCount(@RequestBody MenuGroupDto menuGroupDto) {
-        return menuServiceDaoImpl.queryMenuGroupsCount(BeanConvertUtil.beanCovertMap(menuGroupDto));    }
+        return menuServiceDaoImpl.queryMenuGroupsCount(BeanConvertUtil.beanCovertMap(menuGroupDto));
+    }
 
     public IMenuServiceDao getMenuServiceDaoImpl() {
         return menuServiceDaoImpl;
@@ -77,7 +80,7 @@
 
 
     @Override
-    public List<BasePrivilegeDto> queryBasePrivileges(@RequestBody  BasePrivilegeDto basePrivilegeDto) {
+    public List<BasePrivilegeDto> queryBasePrivileges(@RequestBody BasePrivilegeDto basePrivilegeDto) {
 
         //鏍￠獙鏄惁浼犱簡 鍒嗛〉淇℃伅
 
@@ -85,7 +88,6 @@
 
         if (page != PageDto.DEFAULT_PAGE) {
             basePrivilegeDto.setPage((page - 1) * basePrivilegeDto.getRow());
-            basePrivilegeDto.setRow(page * basePrivilegeDto.getRow());
         }
 
         List<BasePrivilegeDto> basePrivileges = BeanConvertUtil.covertBeanList(menuServiceDaoImpl.getBasePrivilegeInfo(BeanConvertUtil.beanCovertMap(basePrivilegeDto)), BasePrivilegeDto.class);
@@ -112,5 +114,58 @@
 
     @Override
     public int queryBasePrivilegesCount(@RequestBody BasePrivilegeDto basePrivilegeDto) {
-        return menuServiceDaoImpl.queryBasePrivilegesCount(BeanConvertUtil.beanCovertMap(basePrivilegeDto));    }
+        return menuServiceDaoImpl.queryBasePrivilegesCount(BeanConvertUtil.beanCovertMap(basePrivilegeDto));
+    }
+
+    @Override
+    /**
+     * 鏌ヨ<p>灏忓尯妤�</p>鎬昏褰曟暟
+     *
+     * @param routeDto 鏁版嵁瀵硅薄鍒嗕韩
+     * @return 灏忓尯涓嬬殑灏忓尯妤艰褰曟暟
+     */
+    @RequestMapping(value = "/checkUserHasResource", method = RequestMethod.POST)
+    public boolean checkUserHasResource(@RequestBody BasePrivilegeDto basePrivilegeDto) {
+        return menuServiceDaoImpl.checkUserHasResource(BeanConvertUtil.beanCovertMap(basePrivilegeDto));
+    }
+
+
+    @Override
+    public List<MenuDto> queryMenus(@RequestBody MenuDto menuDto) {
+
+        //鏍￠獙鏄惁浼犱簡 鍒嗛〉淇℃伅
+
+        int page = menuDto.getPage();
+
+        if (page != PageDto.DEFAULT_PAGE) {
+            menuDto.setPage((page - 1) * menuDto.getRow());
+        }
+
+        List<MenuDto> menus = BeanConvertUtil.covertBeanList(menuServiceDaoImpl.getMenuInfo(BeanConvertUtil.beanCovertMap(menuDto)), MenuDto.class);
+
+
+        return menus;
+    }
+
+    @Override
+    public int updateMenu(@RequestBody MenuDto menuDto) {
+        return menuServiceDaoImpl.updateMenuInfo(BeanConvertUtil.beanCovertMap(menuDto));
+    }
+
+    @Override
+    public int saveMenu(@RequestBody MenuDto menuDto) {
+        return menuServiceDaoImpl.saveMenuInfo(BeanConvertUtil.beanCovertMap(menuDto));
+    }
+
+    @Override
+    public int deleteMenu(@RequestBody MenuDto menuDto) {
+        menuDto.setStatusCd("1");
+        return menuServiceDaoImpl.updateMenuInfo(BeanConvertUtil.beanCovertMap(menuDto));
+    }
+
+    @Override
+    public int queryMenusCount(@RequestBody MenuDto menuDto) {
+        return menuServiceDaoImpl.queryMenusCount(BeanConvertUtil.beanCovertMap(menuDto));
+    }
+
 }

--
Gitblit v1.8.0