package com.moral.api.service.impl;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
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.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.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;
/**
*
* 后台账户表 服务实现类
*
*
* @author moral
* @since 2021-03-09
*/
@Service
public class ManageAccountServiceImpl extends ServiceImpl 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
* @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 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 roles = manageRoleMapper.getManageRoleByAccountId(manageAccount.getId());
if (ObjectUtils.isEmpty(roles)) {//判断账号是否存在角色
loginDTO.setCode(LoginDTO.ROLE_EMPTY);
return loginDTO;
}
//查询菜单
List 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
* @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 AccountDTO addAccount(AccountAddRequest accountAddRequest) {
AccountDTO accountDTO = new AccountDTO();
//取参
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 roleIdsStr = accountAddRequest.getRoleIds();
//校验参数是否符合业务逻辑
/*判断用户名是否包含特殊字符*/
if(isSpecialChar(account)){
accountDTO.setCode(AccountDTO.ACCOUNT_EXIST_SPECIAL_CHAR);
return accountDTO;
}
/*判断密码是否包含特殊字符*/
if(isSpecialChar(password)){
accountDTO.setCode(AccountDTO.PASSWORD_EXIST_SPECIAL_CHAR);
return accountDTO;
}
/*判断用户名是否超过长度*/
if(account.length()>=20){
accountDTO.setCode(AccountDTO.ACCOUNT_LENGTH_INVALID);
return accountDTO;
}
/*判断密码是否超过长度*/
if(AESUtils.decrypt(AESPassword,AESKey).length()>=20){
accountDTO.setCode(AccountDTO.PASSWORD_LENGTH_INVALID);
return accountDTO;
}
/*判断手机号是否符合规则*/
if(!isValidMobile(mobile)){
accountDTO.setCode(AccountDTO.MOBILE_INVALID);
return accountDTO;
}
/*判断邮箱是否符合规则*/
if(!isValidEmail(email)){
accountDTO.setCode(AccountDTO.EMAIL_INVALID);
return accountDTO;
}
/*判断用户名是否存在*/
ManageAccount exitAccount = new ManageAccount();
exitAccount.setAccount(account);
QueryWrapper wrapper = new QueryWrapper<>();
wrapper.setEntity(exitAccount);
List exitAccounts = manageAccountMapper.selectList(wrapper);
if(!ObjectUtils.isEmpty(exitAccounts)){
accountDTO.setCode(AccountDTO.ACCOUNT_EXIST);
return accountDTO;
}
//String to Integer
List 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 roles = manageRoleMapper.selectBatchIds(roleIds);
accountDTO.setAccount(manageAccount);
accountDTO.setRoles(roles);
accountDTO.setCode(AccountDTO.SUCCESS);
return accountDTO;
}
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();
}
}