From 7f56cfa5ec12682d53809e0f4d77a8f3277d36a0 Mon Sep 17 00:00:00 2001
From: kaiyu <404897439@qq.com>
Date: Mon, 15 Mar 2021 17:42:01 +0800
Subject: [PATCH] Manage模块： 完成后台账号查询功能 完成后台账号更新功能
---
screen-manage/src/main/java/com/moral/api/service/impl/ManageAccountServiceImpl.java | 310 ++++++++++++++++++++++++++++++++++++++++++++++-----
1 files changed, 276 insertions(+), 34 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 07f3022..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,14 +1,22 @@
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.AccountInfoDTO;
-import com.moral.api.pojo.dto.LoginDTO;
+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;
@@ -16,10 +24,13 @@
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>
@@ -35,29 +46,40 @@
@Value("${AES.KEY}")
private String AESKey;
@Resource
- ManageAccountMapper accountMapper;
+ ManageAccountMapper manageAccountMapper;
@Resource
- ManageRoleMapper roleMapper;
+ 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>
+ * @return: java.util.Map<java.lang.String , java.lang.Object>
* @Author: ���������
* @Date: 2021/3/11
*/
@Override
- public LoginDTO login(String AESAccount,String AESPassword) {
+ 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 = accountMapper.selectOne(wrapper);
+ ManageAccount manageAccount = manageAccountMapper.selectOne(wrapper);
if (ObjectUtils.isEmpty(manageAccount)) {
loginDTO.setCode(LoginDTO.NOT_EXIST);
return loginDTO;
@@ -74,7 +96,7 @@
}
//������������
- List<ManageRole> roles = roleMapper.getManageRoleByAccountId(manageAccount.getId());
+ List<ManageRole> roles = manageRoleMapper.getManageRoleByAccountId(manageAccount.getId());
if (ObjectUtils.isEmpty(roles)) {//������������������������������
loginDTO.setCode(LoginDTO.ROLE_EMPTY);
return loginDTO;
@@ -86,38 +108,18 @@
return loginDTO;
}
-
//������������������
AccountInfoDTO accountInfoDTO = new AccountInfoDTO();
- /*������������������������*/
- ArrayList<String> roleNames = new ArrayList<>();
- roles.forEach(role->roleNames.add(role.getName()));
- /*������menu������������*/
- for (ManageMenu menu : menus) {
- menu.setCreateTime(null);
- menu.setIsDelete(null);
- menu.setUpdateTime(null);
- menu.setParentId(null);
- List<ManageMenu> children = menu.getChildren();
- for (ManageMenu child : children) {
- child.setCreateTime(null);
- child.setIsDelete(null);
- child.setUpdateTime(null);
- child.setParentId(null);
- }
- }
- accountInfoDTO.setAccountId(String.valueOf(manageAccount.getId()));
- accountInfoDTO.setAccountName(manageAccount.getUserName());
+ accountInfoDTO.setAccount(manageAccount);
accountInfoDTO.setMenus(menus);
- accountInfoDTO.setRoles(roleNames);
-
+ accountInfoDTO.setRoles(roles);
//������token ������������������
String token = TokenUtils.getToken(String.valueOf(manageAccount.getId()), accountInfoDTO);
//������������������
loginDTO.setCode(LoginDTO.SUCCESS);
- loginDTO.setAccountInfo(accountInfoDTO);
+ loginDTO.setAccountInfoDTO(accountInfoDTO);
loginDTO.setToken(token);
return loginDTO;
@@ -126,16 +128,256 @@
/**
* @Description: ������
* @Param: [parameters]
- * @return: java.util.Map<java.lang.String , java.lang.Object>
+ * @return: java.util.Map<java.lang.String , java.lang.Object>
* @Author: ���������
* @Date: 2021/3/11
*/
@Override
- public boolean logout(String accountId,String token) {
- TokenUtils.destoryToken(accountId,token);
+ 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