From f9f8f90ac63d6ce3274410d3721b173f40db6e41 Mon Sep 17 00:00:00 2001
From: jinpengyong <jpy123456>
Date: Fri, 25 Aug 2023 14:12:48 +0800
Subject: [PATCH] chore:过滤海城小时数据

---
 screen-manage/src/main/java/com/moral/api/service/impl/ManageRoleServiceImpl.java |  190 +++++++++++++++++++++++++++++++++++++++--------
 1 files changed, 157 insertions(+), 33 deletions(-)

diff --git a/screen-manage/src/main/java/com/moral/api/service/impl/ManageRoleServiceImpl.java b/screen-manage/src/main/java/com/moral/api/service/impl/ManageRoleServiceImpl.java
index deb66a4..396e77b 100644
--- a/screen-manage/src/main/java/com/moral/api/service/impl/ManageRoleServiceImpl.java
+++ b/screen-manage/src/main/java/com/moral/api/service/impl/ManageRoleServiceImpl.java
@@ -1,27 +1,29 @@
 package com.moral.api.service.impl;
 
+import com.alibaba.fastjson.JSON;
 import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
-import com.moral.api.entity.ManageAccountRole;
-import com.moral.api.entity.ManageMenu;
-import com.moral.api.entity.ManageRole;
-import com.moral.api.mapper.ManageAccountRoleMapper;
-import com.moral.api.mapper.ManageRoleMapper;
-import com.moral.api.mapper.ManageRoleMenuMapper;
+import com.moral.api.entity.*;
+import com.moral.api.mapper.*;
+import com.moral.api.pojo.redisBean.AccountInfoDTO;
 import com.moral.api.service.ManageRoleService;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.moral.api.util.LogUtils;
 import com.moral.constant.Constants;
 import com.moral.constant.ResponseCodeEnum;
+import com.moral.util.TokenUtils;
 import org.springframework.beans.factory.annotation.Autowired;
-import org.springframework.data.domain.Page;
 import org.springframework.stereotype.Service;
 import org.springframework.transaction.annotation.Transactional;
+import org.springframework.util.ObjectUtils;
 import org.springframework.util.StringUtils;
+import org.springframework.web.context.request.RequestContextHolder;
+import org.springframework.web.context.request.ServletRequestAttributes;
 
 import javax.annotation.Resource;
-import java.util.ArrayList;
-import java.util.HashMap;
-import java.util.List;
-import java.util.Map;
+import javax.servlet.http.HttpServletRequest;
+import java.text.SimpleDateFormat;
+import java.util.*;
+import java.util.function.Predicate;
 
 /**
  * <p>
@@ -47,25 +49,65 @@
     private ManageRoleMapper manageRoleMapper;
 
     @Autowired(required = false)
+    private ManageMenuMapper manageMenuMapper;
+
+    @Autowired(required = false)
     private ManageRoleMenuMapper manageRoleMenuMapper;
 
     @Autowired(required = false)
     private ManageAccountRoleMapper manageAccountRoleMapper;
 
+
     @Override
-    @Transactional
-    public List<ManageRole> getAllWithPagingQuery(Map map) {
-        com.baomidou.mybatisplus.extension.plugins.pagination.Page<ManageRole> page = new com.baomidou.mybatisplus.extension.plugins.pagination.Page<>(Integer.parseInt(map.get("current").toString()), Integer.parseInt(map.get("size").toString()));
+    public Map<String,Object> getAllWithPagingQuery(Map map) {
+        Map<String,Object> resultMap = new HashMap<>();
+        int current = Integer.parseInt(map.get("current").toString());
+        int size = Integer.parseInt(map.get("size").toString());
+        com.baomidou.mybatisplus.extension.plugins.pagination.Page<ManageRole> page = new com.baomidou.mybatisplus.extension.plugins.pagination.Page<>(current, size);
         QueryWrapper<ManageRole> wrapper = new QueryWrapper();
         wrapper.eq("is_delete",0);
+        wrapper.orderByDesc("create_time");
         com.baomidou.mybatisplus.extension.plugins.pagination.Page resultpage = manageRoleMapper.selectPage(page,wrapper);
         List<ManageRole> manageRoles = resultpage.getRecords();
-        return manageRoles;
+        SimpleDateFormat SDF = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
+        List<Map<String,Object>> manageRolesList = new ArrayList<>();
+        for (ManageRole manageRole:manageRoles) {
+            Map manageRoleMap = JSON.parseObject(JSON.toJSONString(manageRole),Map.class);
+            String createTime = SDF.format(manageRole.getCreateTime());
+            String updateTime = SDF.format(manageRole.getUpdateTime());
+            manageRoleMap.put("createTime",createTime);
+            manageRoleMap.put("updateTime",updateTime);
+            manageRoleMap.put("key",manageRole.getId());
+            manageRolesList.add(manageRoleMap);
+        }
+        //���admin���������  admin���������������
+        AccountInfoDTO accountInfo = (AccountInfoDTO) TokenUtils.getUserInfo();
+        List<ManageRole> roles = accountInfo.getRoles();
+        if(!roles.get(0).getName().equals("admin")){
+            manageRolesList.removeIf(new Predicate<Map<String, Object>>() {
+                @Override
+                public boolean test(Map<String, Object> map) {
+                    if(map.get("name").equals("admin"))
+                        return true;
+                    return false;
+                }
+            });
+        }
+        resultMap.put("manageRoles",manageRolesList);
+        int totalNumber = manageRoleMapper.selectCount(wrapper);
+        resultMap.put("totalNumber",totalNumber);
+        resultMap.put("current",current);
+        int totalPageNumber = totalNumber/size;
+        if(totalNumber%size != 0){
+            totalPageNumber += 1;
+        }
+        resultMap.put("totalPageNumber",totalPageNumber);
+        return resultMap;
     }
 
     @Override
     @Transactional
-    public Map<String,Object> insertOne(ManageRole manageRole,List list) {
+    public Map<String,Object> insertOne(ManageRole manageRole, List list) {
         Map<String,Object> resultMap = new HashMap<>();
         if (manageRole.getName()==null){
             resultMap.put("code",ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode());
@@ -73,28 +115,37 @@
             return resultMap;
         }
         if (manageRoleMapper.getManageRoleByName(manageRole.getName()) != null){
-            resultMap.put("code",ResponseCodeEnum.ROLE_IS_EXPIRE.getCode());
-            resultMap.put("msg",ResponseCodeEnum.ROLE_IS_EXPIRE.getMsg());
-        }else {
-            manageRoleMapper.insertOne(manageRole);
-            resultMap.put("code",ResponseCodeEnum.SUCCESS.getCode());
-            resultMap.put("msg",ResponseCodeEnum.SUCCESS.getMsg());
+            resultMap.put("code",ResponseCodeEnum.ROLE_IS_EXIST.getCode());
+            resultMap.put("msg",ResponseCodeEnum.ROLE_IS_EXIST.getMsg());
+            return resultMap;
         }
-        Integer code = Integer.parseInt(resultMap.get("code").toString());
-        if (code.equals(ResponseCodeEnum.SUCCESS.getCode())){
-            ManageRole manageRoleIns = manageRoleMapper.getManageRoleByName(manageRole.getName());
-            int role_id = manageRoleIns.getId();
-            System.out.println(role_id);
+        manageRoleMapper.insertOne(manageRole);
+        ManageRole manageRoleIns = manageRoleMapper.getManageRoleByName(manageRole.getName());
+        int role_id = manageRoleIns.getId();
+        if (list.size()>0){
+            //���������������
+            List supplementList = new ArrayList();
+            supplementList.addAll(list);
+            for (int i=0;i<supplementList.size();i++) {
+                supplementList.addAll(supplementParentMenus(Integer.parseInt(supplementList.get(i).toString())));
+            }
+            LinkedHashSet<Object> hashSet = new LinkedHashSet<>(supplementList);
+            ArrayList<Object> menuList = new ArrayList<>(hashSet);
             List insertList = new ArrayList();
-            for (Object temp: list) {
+            for (Object temp: menuList) {
                 Map<String,Integer> insertMap = new HashMap<>();
                 insertMap.put("role_id",role_id);
                 insertMap.put("menu_id",Integer.parseInt(temp.toString()));
                 insertList.add(insertMap);
             }
-            System.out.println(insertList);
             manageRoleMenuMapper.insertBatch(insertList);
         }
+        //������������������
+        HttpServletRequest request = ((ServletRequestAttributes) RequestContextHolder.getRequestAttributes()).getRequest();
+        String content = "������������:"+manageRole.getName()+";";
+        LogUtils.saveOperationForManage(request,content,Constants.INSERT_OPERATE_TYPE);
+        resultMap.put("code",ResponseCodeEnum.SUCCESS.getCode());
+        resultMap.put("msg",ResponseCodeEnum.SUCCESS.getMsg());
         return resultMap;
     }
 
@@ -111,7 +162,21 @@
             resultMap.put("code",ResponseCodeEnum.ROLE_IS_NULL.getCode());
             resultMap.put("msg",ResponseCodeEnum.ROLE_IS_NULL.getMsg());
         }else {
+            //���������������������������������
+            ManageRole manageRoleOld = manageRoleMapper.selectById(Integer.parseInt(map.get("id").toString()));
             manageRoleMapper.updateManageRoleById(map);
+            //������������������
+            HttpServletRequest request = ((ServletRequestAttributes) RequestContextHolder.getRequestAttributes()).getRequest();
+            String content = "���������������:"+manageRoleOld.getName()+";";
+            for (Object key:map.keySet()) {
+                if (key.toString().equals("name")&&map.get(key)!=null){
+                    content = content+"���������:"+manageRoleOld.getName()+"->"+map.get(key)+";";
+                }
+                if (key.toString().equals("desc")&&map.get(key)!=null){
+                    content = content+"������:"+manageRoleOld.getDesc()+"->"+map.get(key)+";";
+                }
+            }
+            LogUtils.saveOperationForManage(request,content,Constants.UPDATE_OPERATE_TYPE);
             resultMap.put("code",ResponseCodeEnum.SUCCESS.getCode());
             resultMap.put("msg",ResponseCodeEnum.SUCCESS.getMsg());
         }
@@ -119,15 +184,37 @@
     }
 
     @Override
-    @Transactional
-    public List<ManageRole> getManageRoleByNameFuzzy(Map map) {
-        com.baomidou.mybatisplus.extension.plugins.pagination.Page<ManageRole> page = new com.baomidou.mybatisplus.extension.plugins.pagination.Page<>(Integer.parseInt(map.get("current").toString()), Integer.parseInt(map.get("size").toString()));
+    public Map<String,Object> getManageRoleByNameFuzzy(Map map) {
+        Map<String,Object> resultMap = new HashMap<>();
+        int current = Integer.parseInt(map.get("current").toString());
+        int size = Integer.parseInt(map.get("size").toString());
+        com.baomidou.mybatisplus.extension.plugins.pagination.Page<ManageRole> page = new com.baomidou.mybatisplus.extension.plugins.pagination.Page<>(current, size);
         QueryWrapper<ManageRole> wrapper = new QueryWrapper();
         wrapper.eq("is_delete",0);
         wrapper.like("name",map.get("name"));
+        wrapper.orderByDesc("create_time");
         com.baomidou.mybatisplus.extension.plugins.pagination.Page resultpage = manageRoleMapper.selectPage(page,wrapper);
         List<ManageRole> manageRoles = resultpage.getRecords();
-        return manageRoles;
+        SimpleDateFormat SDF = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
+        List<Map<String,Object>> manageRolesList = new ArrayList<>();
+        for (ManageRole manageRole:manageRoles) {
+            Map manageRoleMap = JSON.parseObject(JSON.toJSONString(manageRole),Map.class);
+            String createTime = SDF.format(manageRole.getCreateTime());
+            String updateTime = SDF.format(manageRole.getUpdateTime());
+            manageRoleMap.put("createTime",createTime);
+            manageRoleMap.put("updateTime",updateTime);
+            manageRolesList.add(manageRoleMap);
+        }
+        resultMap.put("manageRoles",manageRolesList);
+        int totalNumber = manageRoleMapper.selectCount(wrapper);
+        resultMap.put("totalNumber",totalNumber);
+        resultMap.put("current",current);
+        int totalPageNumber = totalNumber/size;
+        if(totalNumber%size != 0){
+            totalPageNumber += 1;
+        }
+        resultMap.put("totalPageNumber",totalPageNumber);
+        return resultMap;
     }
 
     @Override
@@ -154,9 +241,46 @@
             QueryWrapper<ManageAccountRole> wrapper = new QueryWrapper();
             wrapper.eq("role_id",Integer.parseInt(map.get("id").toString()));
             manageAccountRoleMapper.update(manageAccountRole,wrapper);
+            //������������������
+            HttpServletRequest request = ((ServletRequestAttributes) RequestContextHolder.getRequestAttributes()).getRequest();
+            ManageRole manageRole1 = manageRoleMapper.selectById(Integer.parseInt(map.get("id").toString()));
+            String content = "������������:"+manageRole1.getName()+";";
+            LogUtils.saveOperationForManage(request,content,Constants.DELETE_OPERATE_TYPE);
             resultMap.put("code",ResponseCodeEnum.SUCCESS.getCode());
             resultMap.put("msg",ResponseCodeEnum.SUCCESS.getMsg());
         }
         return resultMap;
     }
+
+    @Override
+    public ManageRole getRoleByAccountId(Integer accountId) {
+        QueryWrapper<ManageAccountRole> queryAccountRoleWrapper = new QueryWrapper<>();
+        queryAccountRoleWrapper.eq("is_delete",Constants.NOT_DELETE);
+        queryAccountRoleWrapper.eq("account_id",accountId);
+        ManageAccountRole accountRole = manageAccountRoleMapper.selectOne(queryAccountRoleWrapper);
+        if(ObjectUtils.isEmpty(accountRole))
+            return null;
+        Integer roleId = accountRole.getRoleId();
+        QueryWrapper<ManageRole> queryRoleWrapper = new QueryWrapper();
+        queryRoleWrapper.eq("is_delete", Constants.NOT_DELETE);
+        queryRoleWrapper.eq("id", roleId);
+        return  manageRoleMapper.selectOne(queryRoleWrapper);
+    }
+
+    /**
+     * @Description: ���������������
+     * @Param: [list, menuId]list���menuId������
+     * @return: void
+     * @Author: ���������
+     * @Date: 2021/4/28
+     */
+    private List supplementParentMenus(int menuId) {
+        List list = new ArrayList();
+        ManageMenu manageMenu = manageMenuMapper.getManageMenuById(menuId);
+        if (manageMenu.getParentId()!=0){
+            list.add(manageMenu.getParentId());
+            list.addAll(supplementParentMenus(manageMenu.getParentId()));
+        }
+        return list;
+    }
 }

--
Gitblit v1.8.0