From ba4993e6eb1c9456d4c40a186fd8284ad7ad9ac2 Mon Sep 17 00:00:00 2001
From: lizijie <lzjiiie@163.com>
Date: Thu, 15 Apr 2021 17:44:26 +0800
Subject: [PATCH] 添加列表根据父菜单和order排序

---
 screen-manage/src/main/java/com/moral/api/service/ManageMenuService.java          |    2 +-
 screen-manage/src/main/java/com/moral/api/controller/ManageMenuController.java    |    3 ++-
 screen-manage/src/main/java/com/moral/api/service/impl/ManageMenuServiceImpl.java |   25 ++++++++++++++++++++++---
 screen-manage/src/main/resources/mapper/ManageMenuMapper.xml                      |    1 +
 4 files changed, 26 insertions(+), 5 deletions(-)

diff --git a/screen-manage/src/main/java/com/moral/api/controller/ManageMenuController.java b/screen-manage/src/main/java/com/moral/api/controller/ManageMenuController.java
index 69fced5..fc71ae0 100644
--- a/screen-manage/src/main/java/com/moral/api/controller/ManageMenuController.java
+++ b/screen-manage/src/main/java/com/moral/api/controller/ManageMenuController.java
@@ -65,6 +65,7 @@
     })
     @RequestMapping(value = "updateManageMenuById", method = RequestMethod.POST)
     public ResultMessage updateManageMenuById(@RequestBody Map<String, Object> parameters) {
+        System.out.println("parameters:"+parameters);
         Map<String,Object> resultMap = manageMenuService.updateManageMenu(parameters);
         String msg = resultMap.get("msg").toString();
         int code = Integer.parseInt(resultMap.get("code").toString());
@@ -153,7 +154,7 @@
     @RequestMapping(value = "getManageMenuList", method = RequestMethod.GET)
     public ResultMessage getManageMenuList(HttpServletRequest request) {
         Map<String, Object> parameters = getParametersStartingWith(request, null);
-        List<ManageMenu> result = manageMenuService.getAllWithPagingQuery(parameters);
+        List<Map<String,Object>> result = manageMenuService.getAllWithPagingQuery(parameters);
         return ResultMessage.ok(result);
     }
 }
diff --git a/screen-manage/src/main/java/com/moral/api/service/ManageMenuService.java b/screen-manage/src/main/java/com/moral/api/service/ManageMenuService.java
index df78a6e..2a7f7a5 100644
--- a/screen-manage/src/main/java/com/moral/api/service/ManageMenuService.java
+++ b/screen-manage/src/main/java/com/moral/api/service/ManageMenuService.java
@@ -28,7 +28,7 @@
     @Transactional
     Map<String,Object> deleteManageMenu(Map map);
 
-    List<ManageMenu> getAllWithPagingQuery(Map map);
+    List<Map<String,Object>> getAllWithPagingQuery(Map map);
 
     List<ManageMenu> getAllMenus();
 
diff --git a/screen-manage/src/main/java/com/moral/api/service/impl/ManageMenuServiceImpl.java b/screen-manage/src/main/java/com/moral/api/service/impl/ManageMenuServiceImpl.java
index f665091..577e189 100644
--- a/screen-manage/src/main/java/com/moral/api/service/impl/ManageMenuServiceImpl.java
+++ b/screen-manage/src/main/java/com/moral/api/service/impl/ManageMenuServiceImpl.java
@@ -1,5 +1,6 @@
 package com.moral.api.service.impl;
 
+import com.alibaba.fastjson.JSON;
 import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.moral.api.entity.ManageMenu;
@@ -20,6 +21,7 @@
 
 import javax.annotation.Resource;
 import javax.servlet.http.HttpServletRequest;
+import java.text.SimpleDateFormat;
 import java.util.ArrayList;
 import java.util.HashMap;
 import java.util.List;
@@ -126,6 +128,8 @@
             resultMap.put("code", ResponseCodeEnum.MENU_IS_NULL.getCode());
             resultMap.put("msg", ResponseCodeEnum.MENU_IS_NULL.getMsg());
         } else {
+            //������������������������������
+            ManageMenu manageMenuDelete = manageMenuMapper.getManageMenuById(Integer.parseInt(map.get("id").toString()));
             Map deleteMap = new HashMap();
             int id = Integer.parseInt(map.get("id").toString());
             deleteMap.put("id", id);
@@ -136,7 +140,6 @@
             manageRoleMenuMapper.updateDeleteStateByMenu_id(role_menuDeleteMap);
             //������������������
             HttpServletRequest request = ((ServletRequestAttributes) RequestContextHolder.getRequestAttributes()).getRequest();
-            ManageMenu manageMenuDelete = manageMenuMapper.getManageMenuById(Integer.parseInt(map.get("id").toString()));
             String content = "������������:"+manageMenuDelete.getName()+";";
             logUtils.saveOperationForManage(request,content,Constants.DELETE_OPERATE_TYPE);
             resultMap.put("code", ResponseCodeEnum.SUCCESS.getCode());
@@ -146,12 +149,28 @@
     }
 
     @Override
-    public List<ManageMenu> getAllWithPagingQuery(Map map) {
+    public List<Map<String,Object>> getAllWithPagingQuery(Map map) {
         Map limitMap = new HashMap();
         limitMap.put("start", (Integer.parseInt(map.get("current").toString()) - 1) * Integer.parseInt(map.get("size").toString()));
         limitMap.put("number", Integer.parseInt(map.get("size").toString()));
         List<ManageMenu> manageMenus = manageMenuMapper.getDataWithPage(limitMap);
-        return manageMenus;
+        SimpleDateFormat SDF = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
+        List<Map<String,Object>> resultList = new ArrayList<>();
+        for (ManageMenu manageMenu:manageMenus) {
+            Map manegeMenuMap = JSON.parseObject(JSON.toJSONString(manageMenu));
+            if (manageMenu.getParentId().equals(0)){
+                manegeMenuMap.put("parent_name","");
+            }else {
+                String parent_name = manageMenuMapper.getManageMenuById(manageMenu.getParentId()).getName();
+                manegeMenuMap.put("parent_name",parent_name);
+            }
+            String createTime = SDF.format(manageMenu.getCreateTime());
+            String updateTime = SDF.format(manageMenu.getUpdateTime());
+            manegeMenuMap.put("createTime",createTime);
+            manegeMenuMap.put("updateTime",updateTime);
+            resultList.add(manegeMenuMap);
+        }
+        return resultList;
     }
 
     @Override
diff --git a/screen-manage/src/main/resources/mapper/ManageMenuMapper.xml b/screen-manage/src/main/resources/mapper/ManageMenuMapper.xml
index 41a065c..1d85053 100644
--- a/screen-manage/src/main/resources/mapper/ManageMenuMapper.xml
+++ b/screen-manage/src/main/resources/mapper/ManageMenuMapper.xml
@@ -123,6 +123,7 @@
         <include refid="Base_Column_List"></include>
         from manage_menu mm
         where mm.is_delete = 0
+        ORDER BY parent_id ASC,`order` ASC
         limit #{start},#{number}
     </select>
 

--
Gitblit v1.8.0