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