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 | 247 +++++++++++++++++++++++++++++++++++++------------
1 files changed, 187 insertions(+), 60 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 389c024..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,6 +1,7 @@
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;
@@ -9,12 +10,13 @@
import com.moral.api.mapper.ManageAccountRoleMapper;
import com.moral.api.mapper.ManageMenuMapper;
import com.moral.api.mapper.ManageRoleMapper;
-import com.moral.api.pojo.dto.AccountDTO;
-import com.moral.api.pojo.dto.AccountInfoDTO;
-import com.moral.api.pojo.dto.LoginDTO;
-import com.moral.api.pojo.request.AccountAddRequest;
-import com.moral.api.pojo.request.LoginRequest;
-import com.moral.api.pojo.request.LogoutRequest;
+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;
@@ -52,15 +54,16 @@
@Resource
ManageAccountRoleMapper manageAccountRoleMapper;
- public final static String specialCharRegEx = "[ _`~!@#$%^&*()+=|{}':;',\\[\\].<>/?~���@#���%������&*������������+|{}������������������������������������]|\n|\r|\t";
+ 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
*/
@@ -125,85 +128,86 @@
/**
* @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(LogoutRequest logoutRequest) {
String accountId = logoutRequest.getAccountId();
- String token = logoutRequest.getToken();
- TokenUtils.destoryToken(accountId,token);
+ 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
- */
+ * @Description: ������������������
+ * @Param: [accountAddRequest]
+ * @return: com.moral.api.pojo.dto.AccountDTO
+ * @Author: ���������
+ * @Date: 2021/3/13
+ */
@Override
@Transactional
- public AccountDTO addAccount(AccountAddRequest accountAddRequest) {
- AccountDTO accountDTO = new AccountDTO();
+ public AccountInsertDTO insertAccount(AccountInsertRequest accountInsertRequest) {
+ AccountInsertDTO accountInsertDTO = new AccountInsertDTO();
//������
- String AESAccount = accountAddRequest.getAccount();
- String AESPassword = accountAddRequest.getPassword();
- String account = AESUtils.decrypt(AESAccount,AESKey);
- String password = MD5Utils.saltMD5(AESUtils.decrypt(AESPassword,AESKey));
- String userName = accountAddRequest.getUserName();
- String email = accountAddRequest.getEmail();
- String mobile = accountAddRequest.getMobile();
- String wechat = accountAddRequest.getWechat();
- String isDelete = accountAddRequest.getIsDelete();
- List<String> roleIdsStr = accountAddRequest.getRoleIds();
+ 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)){
- accountDTO.setCode(AccountDTO.ACCOUNT_EXIST_SPECIAL_CHAR);
- return accountDTO;
+ if (isSpecialChar(account)) {
+ accountInsertDTO.setCode(AccountInsertDTO.ACCOUNT_EXIST_SPECIAL_CHAR);
+ return accountInsertDTO;
}
/*������������������������������������*/
- if(isSpecialChar(password)){
- accountDTO.setCode(AccountDTO.PASSWORD_EXIST_SPECIAL_CHAR);
- return accountDTO;
+ if (isSpecialChar(password)) {
+ accountInsertDTO.setCode(AccountInsertDTO.PASSWORD_EXIST_SPECIAL_CHAR);
+ return accountInsertDTO;
}
/*���������������������������������*/
- if(account.length()>=20){
- accountDTO.setCode(AccountDTO.ACCOUNT_LENGTH_INVALID);
- return accountDTO;
+ if (account.length() >= 20||account.length()<=6) {
+ accountInsertDTO.setCode(AccountInsertDTO.ACCOUNT_LENGTH_INVALID);
+ return accountInsertDTO;
}
/*������������������������������*/
- if(AESUtils.decrypt(AESPassword,AESKey).length()>=20){
- accountDTO.setCode(AccountDTO.PASSWORD_LENGTH_INVALID);
- return accountDTO;
+ if (AESUtils.decrypt(AESPassword, AESKey).length() >= 20||AESUtils.decrypt(AESPassword, AESKey).length() <= 6) {
+ accountInsertDTO.setCode(AccountInsertDTO.PASSWORD_LENGTH_INVALID);
+ return accountInsertDTO;
}
/*���������������������������������*/
- if(!isValidMobile(mobile)){
- accountDTO.setCode(AccountDTO.MOBILE_INVALID);
- return accountDTO;
+ if (!isValidMobile(mobile)) {
+ accountInsertDTO.setCode(AccountInsertDTO.MOBILE_INVALID);
+ return accountInsertDTO;
}
/*������������������������������*/
- if(!isValidEmail(email)){
- accountDTO.setCode(AccountDTO.EMAIL_INVALID);
- return accountDTO;
+ 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)){
- accountDTO.setCode(AccountDTO.ACCOUNT_EXIST);
- return accountDTO;
+ 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)));
+ roleIdsStr.forEach(str -> roleIds.add(Integer.parseInt(str)));
//������account
ManageAccount manageAccount = new ManageAccount();
@@ -218,7 +222,7 @@
//������account_role
Integer accountId = manageAccount.getId();
roleIdsStr.forEach(
- value->{
+ value -> {
ManageAccountRole manageAccountRole = new ManageAccountRole();
manageAccountRole.setAccountId(accountId);
manageAccountRole.setRoleId(Integer.parseInt(value));
@@ -227,30 +231,153 @@
);
//������������������
List<ManageRole> roles = manageRoleMapper.selectBatchIds(roleIds);
- accountDTO.setAccount(manageAccount);
- accountDTO.setRoles(roles);
- accountDTO.setCode(AccountDTO.SUCCESS);
- return accountDTO;
+ accountInsertDTO.setAccount(manageAccount);
+ accountInsertDTO.setRoles(roles);
+ accountInsertDTO.setCode(AccountInsertDTO.SUCCESS);
+ return accountInsertDTO;
}
- private static boolean isSpecialChar(String str){
+ /**
+ * @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){
+ 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){
+ private static boolean isValidEmail(String str) {
Pattern pattern = Pattern.compile(emailRegEx);
Matcher matcher = pattern.matcher(str);
return matcher.find();
}
-
}
--
Gitblit v1.8.0