From 466ee3bc7c7bccf1e74ba46289900e24e6784d7b Mon Sep 17 00:00:00 2001 From: kaiyu <404897439@qq.com> Date: Wed, 17 Mar 2021 11:49:41 +0800 Subject: [PATCH] common模块: 添加常量枚举 --- screen-manage/src/main/java/com/moral/api/service/impl/ManageAccountServiceImpl.java | 362 ++++++++++++++++++++++++++++++++++++++++++++++----- 1 files changed, 326 insertions(+), 36 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..41b198b 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,20 @@ package com.moral.api.service.impl; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; +import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; +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.*; +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 +22,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,35 +44,52 @@ @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); - if (ObjectUtils.isEmpty(manageAccount)) { + List<ManageAccount> manageAccounts = manageAccountMapper.selectList(wrapper); + if (ObjectUtils.isEmpty(manageAccounts)) { loginDTO.setCode(LoginDTO.NOT_EXIST); return loginDTO; } //������������������������ - if (manageAccount.getIsDelete().equals("1")) { + ManageAccount manageAccount = null; + for (ManageAccount value : manageAccounts) { + if("0".equals(value.getIsDelete())) + manageAccount = value; + } + + if (ObjectUtils.isEmpty(manageAccount)) { loginDTO.setCode(LoginDTO.IS_DELETE); return loginDTO; } @@ -74,7 +100,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 +112,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 +132,300 @@ /** * @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(); + 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); + 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); + if(!ObjectUtils.isEmpty(isDelete)) + queryParams.put("is_delete", isDelete); + else + queryParams.put("is_delete","0"); + //���������null��������� + 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; + } + + /** + * @Description: ������������������ + * @Param: [accountUpdateRequest] + * @return: com.moral.api.pojo.dto.account.AccountUpdateDTO + * @Author: ��������� + * @Date: 2021/3/16 + */ + @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 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.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; + } + + + /** + * @Description: ������������������ + * @Param: [accountDeleteRequest] + * @return: com.moral.api.pojo.dto.account.AccountDeleteDTO + * @Author: ��������� + * @Date: 2021/3/16 + */ + @Override + @Transactional + public AccountDeleteDTO deleteAccount(AccountDeleteRequest accountDeleteRequest) { + AccountDeleteDTO accountDeleteDTO = new AccountDeleteDTO(); + //������ + Integer accountId = accountDeleteRequest.getAccountId(); + //������������������ + ManageAccount manageAccount = new ManageAccount(); + manageAccount.setIsDelete("0"); + manageAccount.setId(accountId); + QueryWrapper<ManageAccount> queryWrapper = new QueryWrapper<>(); + queryWrapper.setEntity(manageAccount); + ManageAccount existManageAccount = manageAccount.selectOne(queryWrapper); + if(ObjectUtils.isEmpty(existManageAccount)){ + accountDeleteDTO.setCode(AccountDeleteDTO.ACCOUNT_NOT_EXIST); + return accountDeleteDTO; + } + //������������������ + existManageAccount.setIsDelete("1"); + UpdateWrapper<ManageAccount> deleteAccountWrapper = new UpdateWrapper<>(); + deleteAccountWrapper.set("is_delete","1").eq("id",manageAccount.getId()); + manageAccountMapper.update(null,deleteAccountWrapper); + //������������������������������ + UpdateWrapper<ManageAccountRole> deleteManageAccountRoleWrapper = new UpdateWrapper<>(); + deleteManageAccountRoleWrapper.set("is_delete","1").eq("account_id",manageAccount.getId()); + manageAccountRoleMapper.update(null,deleteManageAccountRoleWrapper); + //������������������ + accountDeleteDTO.setCode(AccountDeleteDTO.SUCCESS); + accountDeleteDTO.setAccount(existManageAccount); + return accountDeleteDTO; + } + + + 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