From 0fd4853ab2cf6e8ff6775803f80c4970c484a529 Mon Sep 17 00:00:00 2001
From: lizijie <lzjiiie@163.com>
Date: Thu, 18 Mar 2021 15:37:01 +0800
Subject: [PATCH] 角色菜单配置

---
 screen-manage/src/main/java/com/moral/api/service/impl/ManageAccountServiceImpl.java |  363 +++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 363 insertions(+), 0 deletions(-)

diff --git a/screen-manage/src/main/java/com/moral/api/service/impl/ManageAccountServiceImpl.java b/screen-manage/src/main/java/com/moral/api/service/impl/ManageAccountServiceImpl.java
index 6dba8fb..a78cd9b 100644
--- a/screen-manage/src/main/java/com/moral/api/service/impl/ManageAccountServiceImpl.java
+++ b/screen-manage/src/main/java/com/moral/api/service/impl/ManageAccountServiceImpl.java
@@ -1,10 +1,36 @@
 package com.moral.api.service.impl;
 
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.moral.api.entity.ManageAccount;
+import com.moral.api.entity.ManageAccountRole;
+import com.moral.api.entity.ManageMenu;
+import com.moral.api.entity.ManageRole;
 import com.moral.api.mapper.ManageAccountMapper;
+import com.moral.api.mapper.ManageAccountRoleMapper;
+import com.moral.api.mapper.ManageMenuMapper;
+import com.moral.api.mapper.ManageRoleMapper;
+import com.moral.api.pojo.dto.account.AccountDTO;
+import com.moral.api.pojo.dto.account.AccountInsertDTO;
+import com.moral.api.pojo.dto.account.AccountQueryDTO;
+import com.moral.api.pojo.dto.account.AccountUpdateDTO;
+import com.moral.api.pojo.dto.login.AccountInfoDTO;
+import com.moral.api.pojo.dto.login.LoginDTO;
+import com.moral.api.pojo.request.*;
 import com.moral.api.service.ManageAccountService;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.moral.util.AESUtils;
+import com.moral.util.MD5Utils;
+import com.moral.util.TokenUtils;
+import org.springframework.beans.factory.annotation.Value;
 import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
+import org.springframework.util.ObjectUtils;
+
+import javax.annotation.Resource;
+import java.util.*;
+import java.util.regex.Matcher;
+import java.util.regex.Pattern;
 
 /**
  * <p>
@@ -17,4 +43,341 @@
 @Service
 public class ManageAccountServiceImpl extends ServiceImpl<ManageAccountMapper, ManageAccount> implements ManageAccountService {
 
+    @Value("${AES.KEY}")
+    private String AESKey;
+    @Resource
+    ManageAccountMapper manageAccountMapper;
+    @Resource
+    ManageRoleMapper manageRoleMapper;
+    @Resource
+    ManageMenuMapper manageMenuMapper;
+    @Resource
+    ManageAccountRoleMapper manageAccountRoleMapper;
+
+    public final static String specialCharRegEx = "[ _`~!@#$%^&*()+=|{}':;',\\[\\].<>/?~���@#���%������&*������������+|{}������������������������������������]|\n|\r|\t";
+
+    public final static String mobileRegEx = "^((13[0-9])|(14[0,1,4-9])|(15[0-3,5-9])|(16[2,5,6,7])|(17[0-8])|(18[0-9])|(19[0-3,5-9]))\\d{8}$";
+
+    public final static String emailRegEx = "^\\w+([-+.]\\w+)*@\\w+([-.]\\w+)*\\.\\w+([-.]\\w+)*$";
+
+    /**
+     * @Description: ������
+     * @Param: [parameters]
+     * @return: java.util.Map<java.lang.String               ,               java.lang.Object>
+     * @Author: ���������
+     * @Date: 2021/3/11
+     */
+    @Override
+    public LoginDTO login(LoginRequest loginRequest) {
+        LoginDTO loginDTO = new LoginDTO();
+        //������
+        String AESAccount = loginRequest.getAccount();
+        String AESPassword = loginRequest.getPassword();
+        //������
+        String account = AESUtils.decrypt(AESAccount, AESKey);
+        String password = AESUtils.decrypt(AESPassword, AESKey);
+        //������������������
+        QueryWrapper<ManageAccount> wrapper = new QueryWrapper<>();
+        wrapper.eq("account", account);
+        ManageAccount manageAccount = manageAccountMapper.selectOne(wrapper);
+        if (ObjectUtils.isEmpty(manageAccount)) {
+            loginDTO.setCode(LoginDTO.NOT_EXIST);
+            return loginDTO;
+        }
+        //������������������������
+        if (manageAccount.getIsDelete().equals("1")) {
+            loginDTO.setCode(LoginDTO.IS_DELETE);
+            return loginDTO;
+        }
+        //������������
+        if (!MD5Utils.saltMD5Verify(password, manageAccount.getPassword())) {
+            loginDTO.setCode(LoginDTO.PASSWORD_ERROR);
+            return loginDTO;
+        }
+
+        //������������
+        List<ManageRole> roles = manageRoleMapper.getManageRoleByAccountId(manageAccount.getId());
+        if (ObjectUtils.isEmpty(roles)) {//������������������������������
+            loginDTO.setCode(LoginDTO.ROLE_EMPTY);
+            return loginDTO;
+        }
+        //������������
+        List<ManageMenu> menus = manageMenuMapper.getParentChildrenMenusByRoles(roles);
+        if (ObjectUtils.isEmpty(menus)) {//������������������������������
+            loginDTO.setCode(LoginDTO.MENU_EMPTY);
+            return loginDTO;
+        }
+
+        //������������������
+        AccountInfoDTO accountInfoDTO = new AccountInfoDTO();
+        accountInfoDTO.setAccount(manageAccount);
+        accountInfoDTO.setMenus(menus);
+        accountInfoDTO.setRoles(roles);
+
+        //������token ������������������
+        String token = TokenUtils.getToken(String.valueOf(manageAccount.getId()), accountInfoDTO);
+
+        //������������������
+        loginDTO.setCode(LoginDTO.SUCCESS);
+        loginDTO.setAccountInfoDTO(accountInfoDTO);
+        loginDTO.setToken(token);
+
+        return loginDTO;
+    }
+
+    /**
+     * @Description: ������
+     * @Param: [parameters]
+     * @return: java.util.Map<java.lang.String               ,               java.lang.Object>
+     * @Author: ���������
+     * @Date: 2021/3/11
+     */
+    @Override
+    public boolean logout(LogoutRequest logoutRequest) {
+        String accountId = logoutRequest.getAccountId();
+        String token = logoutRequest.getToken();
+        TokenUtils.destoryToken(accountId, token);
+        return true;
+    }
+
+    /**
+     * @Description: ������������������
+     * @Param: [accountAddRequest]
+     * @return: com.moral.api.pojo.dto.AccountDTO
+     * @Author: ���������
+     * @Date: 2021/3/13
+     */
+    @Override
+    @Transactional
+    public AccountInsertDTO insertAccount(AccountInsertRequest accountInsertRequest) {
+        AccountInsertDTO accountInsertDTO = new AccountInsertDTO();
+        //������
+        String AESAccount = accountInsertRequest.getAccount();
+        String AESPassword = accountInsertRequest.getPassword();
+        String account = AESUtils.decrypt(AESAccount, AESKey);
+        String password = MD5Utils.saltMD5(AESUtils.decrypt(AESPassword, AESKey));
+        String userName = accountInsertRequest.getUserName();
+        String email = accountInsertRequest.getEmail();
+        String mobile = accountInsertRequest.getMobile();
+        String wechat = accountInsertRequest.getWechat();
+        String isDelete = accountInsertRequest.getIsDelete();
+        List<String> roleIdsStr = accountInsertRequest.getRoleIds();
+        //������������������������������������
+        /*���������������������������������������*/
+        if (isSpecialChar(account)) {
+            accountInsertDTO.setCode(AccountInsertDTO.ACCOUNT_EXIST_SPECIAL_CHAR);
+            return accountInsertDTO;
+        }
+        /*������������������������������������*/
+        if (isSpecialChar(password)) {
+            accountInsertDTO.setCode(AccountInsertDTO.PASSWORD_EXIST_SPECIAL_CHAR);
+            return accountInsertDTO;
+        }
+        /*���������������������������������*/
+        if (account.length() >= 20||account.length()<=6) {
+            accountInsertDTO.setCode(AccountInsertDTO.ACCOUNT_LENGTH_INVALID);
+            return accountInsertDTO;
+        }
+        /*������������������������������*/
+        if (AESUtils.decrypt(AESPassword, AESKey).length() >= 20||AESUtils.decrypt(AESPassword, AESKey).length() <= 6) {
+            accountInsertDTO.setCode(AccountInsertDTO.PASSWORD_LENGTH_INVALID);
+            return accountInsertDTO;
+        }
+        /*���������������������������������*/
+        if (!isValidMobile(mobile)) {
+            accountInsertDTO.setCode(AccountInsertDTO.MOBILE_INVALID);
+            return accountInsertDTO;
+        }
+        /*������������������������������*/
+        if (!isValidEmail(email)) {
+            accountInsertDTO.setCode(AccountInsertDTO.EMAIL_INVALID);
+            return accountInsertDTO;
+        }
+        /*���������������������������*/
+        ManageAccount exitAccount = new ManageAccount();
+        exitAccount.setAccount(account);
+        exitAccount.setIsDelete("0");
+        QueryWrapper<ManageAccount> wrapper = new QueryWrapper<>();
+        wrapper.setEntity(exitAccount);
+        List<ManageAccount> exitAccounts = manageAccountMapper.selectList(wrapper);
+        if (!ObjectUtils.isEmpty(exitAccounts)) {
+            accountInsertDTO.setCode(AccountInsertDTO.ACCOUNT_EXIST);
+            return accountInsertDTO;
+        }
+
+        //String to Integer
+        List<Integer> roleIds = new ArrayList<>();
+        roleIdsStr.forEach(str -> roleIds.add(Integer.parseInt(str)));
+
+        //������account
+        ManageAccount manageAccount = new ManageAccount();
+        manageAccount.setAccount(account);
+        manageAccount.setPassword(password);
+        manageAccount.setUserName(userName);
+        manageAccount.setEmail(email);
+        manageAccount.setMobile(mobile);
+        manageAccount.setWechat(wechat);
+        manageAccount.setIsDelete(isDelete);
+        manageAccountMapper.insert(manageAccount);
+        //������account_role
+        Integer accountId = manageAccount.getId();
+        roleIdsStr.forEach(
+                value -> {
+                    ManageAccountRole manageAccountRole = new ManageAccountRole();
+                    manageAccountRole.setAccountId(accountId);
+                    manageAccountRole.setRoleId(Integer.parseInt(value));
+                    manageAccountRoleMapper.insert(manageAccountRole);
+                }
+        );
+        //������������������
+        List<ManageRole> roles = manageRoleMapper.selectBatchIds(roleIds);
+        accountInsertDTO.setAccount(manageAccount);
+        accountInsertDTO.setRoles(roles);
+        accountInsertDTO.setCode(AccountInsertDTO.SUCCESS);
+        return accountInsertDTO;
+    }
+
+    /**
+     * @Description: ������������������
+     * @Param: [accountQueryRequest]
+     * @return: com.moral.api.pojo.dto.AccountDTO
+     * @Author: ���������
+     * @Date: 2021/3/15
+     */
+    @Override
+    public AccountQueryDTO queryAccount(AccountQueryRequest accountQueryRequest) {
+        AccountQueryDTO accountQueryDTO = new AccountQueryDTO();
+        //������
+        Integer pageCount = accountQueryRequest.getPage();
+        Integer size = accountQueryRequest.getSize();
+        Integer accountId = accountQueryRequest.getAccountId();
+        String account = accountQueryRequest.getAccount();
+        String userName = accountQueryRequest.getUserName();
+        String email = accountQueryRequest.getEmail();
+        String mobile = accountQueryRequest.getMobile();
+        String wechat = accountQueryRequest.getWechat();
+        String isDelete = accountQueryRequest.getIsDelete();
+        //������������������
+        Map<String, Object> queryParams = new HashMap<>();
+        queryParams.put("id", accountId);
+        queryParams.put("account", account);
+        queryParams.put("user_name", userName);
+        queryParams.put("email", email);
+        queryParams.put("mobile", mobile);
+        queryParams.put("wechat", wechat);
+        queryParams.put("is_delete", isDelete);
+        queryParams.values().removeIf(value -> ObjectUtils.isEmpty(value));
+        //������������
+        Page<ManageAccount> page = new Page<>(pageCount, size);
+        QueryWrapper<ManageAccount> wrapper = new QueryWrapper();
+        wrapper.allEq(queryParams);
+        Page resultPage = manageAccountMapper.selectPage(page, wrapper);
+        //���������������������������
+        List<ManageAccount> accounts = resultPage.getRecords();
+        List<AccountDTO> accountDTOS = new ArrayList<>();
+        for (ManageAccount manageAccount : accounts) {
+            AccountDTO accountDTO = new AccountDTO();
+            List<ManageRole> roles = manageRoleMapper.getManageRoleByAccountId(manageAccount.getId());
+            accountDTO.setRoles(roles);
+            accountDTO.setAccount(manageAccount);
+            accountDTOS.add(accountDTO);
+        }
+        //������������������
+        accountQueryDTO.setAccountDTOS(accountDTOS);
+        accountQueryDTO.setCurrent(resultPage.getCurrent());
+        accountQueryDTO.setPages(resultPage.getPages());
+        accountQueryDTO.setSize(resultPage.getSize());
+        accountQueryDTO.setTotal(resultPage.getTotal());
+
+        return accountQueryDTO;
+    }
+
+    @Override
+    @Transactional
+    public AccountUpdateDTO updateAccount(AccountUpdateRequest accountUpdateRequest) {
+        AccountUpdateDTO accountUpdateDTO = new AccountUpdateDTO();
+        //������
+        Integer accountId = accountUpdateRequest.getAccountId();
+        String email = accountUpdateRequest.getEmail();
+        String mobile = accountUpdateRequest.getMobile();
+        String wechat = accountUpdateRequest.getWechat();
+        String isDelete = accountUpdateRequest.getIsDelete();
+        String userName = accountUpdateRequest.getUserName();
+        List<Integer> roleIds = accountUpdateRequest.getRoleIds();
+        //������������������������������
+        /*������������������������������������*/
+        QueryWrapper<ManageAccount> exitWrapper = new QueryWrapper<>();
+        ManageAccount exitManageAccount = new ManageAccount();
+        exitManageAccount.setId(accountId);
+        exitManageAccount.setIsDelete("0");
+        exitWrapper.setEntity(exitManageAccount);
+        List<ManageAccount> manageAccounts = manageAccountMapper.selectList(exitWrapper);
+        if(ObjectUtils.isEmpty(manageAccounts)){
+            accountUpdateDTO.setCode(AccountUpdateDTO.ACCOUNT_NOT_EXIST);
+            return accountUpdateDTO;
+        }
+        /*���������������������������������*/
+        if (!isValidMobile(mobile)) {
+            accountUpdateDTO.setCode(AccountUpdateDTO.MOBILE_INVALID);
+            return accountUpdateDTO;
+        }
+        /*������������������������������*/
+        if (!isValidEmail(email)) {
+            accountUpdateDTO.setCode(AccountUpdateDTO.EMAIL_INVALID);
+            return accountUpdateDTO;
+        }
+        //������ManageAccount���
+        ManageAccount manageAccount = new ManageAccount();
+        manageAccount.setEmail(email);
+        manageAccount.setMobile(mobile);
+        manageAccount.setWechat(wechat);
+        manageAccount.setIsDelete(isDelete);
+        manageAccount.setUserName(userName);
+        QueryWrapper<ManageAccount> wrapper = new QueryWrapper<>();
+        wrapper.eq("id",accountId);
+        manageAccountMapper.update(manageAccount,wrapper);
+        //������ManageAccountRole���
+        /*������������������������������*/
+        QueryWrapper<ManageAccountRole> deleteWrapper = new QueryWrapper<>();
+        deleteWrapper.eq("account_id",accountId);
+        manageAccountRoleMapper.delete(deleteWrapper);
+        /*������������������*/
+        for (Integer roleId : roleIds) {
+            ManageAccountRole manageAccountRole = new ManageAccountRole();
+            manageAccountRole.setAccountId(accountId);
+            manageAccountRole.setRoleId(roleId);
+            manageAccountRoleMapper.insert(manageAccountRole);
+        }
+        //������������������������
+        List<ManageRole> manageRoles = manageRoleMapper.selectBatchIds(roleIds);
+        //������������������
+        accountUpdateDTO.setCode(AccountUpdateDTO.SUCCESS);
+        accountUpdateDTO.setRoles(manageRoles);
+        accountUpdateDTO.setAccount(manageAccountMapper.selectById(accountId));
+        return accountUpdateDTO;
+    }
+
+
+
+
+
+    private static boolean isSpecialChar(String str) {
+        Pattern pattern = Pattern.compile(specialCharRegEx);
+        Matcher matcher = pattern.matcher(str);
+        return matcher.find();
+    }
+
+    private static boolean isValidMobile(String str) {
+        Pattern pattern = Pattern.compile(mobileRegEx);
+        Matcher matcher = pattern.matcher(str);
+        return matcher.find();
+    }
+
+    private static boolean isValidEmail(String str) {
+        Pattern pattern = Pattern.compile(emailRegEx);
+        Matcher matcher = pattern.matcher(str);
+        return matcher.find();
+    }
+
+
 }

--
Gitblit v1.8.0