package com.moral.api.service.impl;
import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONObject;
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.account.*;
import com.moral.api.pojo.dto.login.AccountInfoDTO;
import com.moral.api.pojo.dto.login.LoginDTO;
import com.moral.api.pojo.form.account.AccountDeleteForm;
import com.moral.api.pojo.form.account.AccountInsertForm;
import com.moral.api.pojo.form.account.AccountQueryForm;
import com.moral.api.pojo.form.account.AccountUpdateForm;
import com.moral.api.pojo.form.login.LoginForm;
import com.moral.api.pojo.form.login.LogoutForm;
import com.moral.api.service.ManageAccountService;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.moral.api.config.mybatis.wrapper.NullFilterWrapper;
import com.moral.api.service.ManageMenuService;
import com.moral.api.util.LogUtils;
import com.moral.constant.Constants;
import com.moral.constant.ResponseCodeEnum;
import com.moral.util.*;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.util.ObjectUtils;
import org.springframework.web.context.request.RequestContextHolder;
import org.springframework.web.context.request.ServletRequestAttributes;
import javax.servlet.http.HttpServletRequest;
import java.util.*;
/**
*
* 后台账户表 服务实现类
*
*
* @author moral
* @since 2021-03-09
*/
@Service
@ConfigurationProperties(prefix = "log-aspect")
public class ManageAccountServiceImpl extends ServiceImpl implements ManageAccountService {
@Autowired
ManageAccountMapper manageAccountMapper;
@Autowired
ManageRoleMapper manageRoleMapper;
@Autowired
ManageMenuService manageMenuService;
@Autowired
ManageAccountRoleMapper manageAccountRoleMapper;
@Autowired
LogUtils logUtils;
Map manageAccountFormMap;
public void setManageAccountFormMap(Map manageAccountFormMap) {
this.manageAccountFormMap = manageAccountFormMap;
}
/**
* @Description: 登陆接口
* @Param: [loginForm]
* @return: com.moral.api.pojo.dto.login.LoginDTO
* @Author: 陈凯裕
* @Date: 2021/3/30
*/
@Override
public LoginDTO login(LoginForm loginForm) {
LoginDTO loginDTO = new LoginDTO();
//取参
String account = loginForm.getAccount();
String AESPassword = loginForm.getPassword();
//解密
String password = AESUtils.decrypt(AESPassword);
//查询是否存在
QueryWrapper wrapper = new QueryWrapper<>();
wrapper.eq("account", account);
List manageAccounts = manageAccountMapper.selectList(wrapper);
if (ObjectUtils.isEmpty(manageAccounts)) {
loginDTO.setCode(ResponseCodeEnum.ACCOUNT_NOT_EXIST.getCode());
loginDTO.setMsg(ResponseCodeEnum.ACCOUNT_NOT_EXIST.getMsg());
return loginDTO;
}
//查询是否逻辑删除
ManageAccount manageAccount = null;
for (ManageAccount value : manageAccounts) {
if (Constants.NOT_DELETE.equals(value.getIsDelete()))
manageAccount = value;
}
if (ObjectUtils.isEmpty(manageAccount)) {
loginDTO.setCode(ResponseCodeEnum.ACCOUNT_IS_DELETE.getCode());
loginDTO.setMsg(ResponseCodeEnum.ACCOUNT_NOT_EXIST.getMsg());
return loginDTO;
}
//校验密码
if (!MD5Utils.saltMD5Verify(password, manageAccount.getPassword())) {
loginDTO.setCode(ResponseCodeEnum.PASSWORD_ERROR.getCode());
loginDTO.setMsg(ResponseCodeEnum.PASSWORD_ERROR.getMsg());
return loginDTO;
}
//查询角色
List roles = manageRoleMapper.getManageRoleByAccountId(manageAccount.getId());
//查询菜单
List menus = new ArrayList<>();
if (!ObjectUtils.isEmpty(roles)) {
menus = manageMenuService.getParentChildrenMenusByRoles(roles);
}
//封装用户信息
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(ResponseCodeEnum.SUCCESS.getCode());
loginDTO.setMsg(ResponseCodeEnum.SUCCESS.getMsg());
loginDTO.setAccountInfoDTO(accountInfoDTO);
loginDTO.setToken(token);
//登陆插入日志
HttpServletRequest request = ((ServletRequestAttributes) RequestContextHolder.getRequestAttributes()).getRequest();
StringBuilder content = new StringBuilder();
content.append(manageAccount.getUserName()).append("登陆了后台系统;");
logUtils.saveLoginForManage(request, content.toString(), manageAccount, manageAccount.getUserName());
return loginDTO;
}
/**
* @Description: 注销
* @Param: [parameters]
* @return:
* @Author: 陈凯裕
* @Date: 2021/3/11
*/
@Override
public boolean logout(LogoutForm logoutForm) {
String accountId = logoutForm.getAccountId();
String token = logoutForm.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 insertAccount(AccountInsertForm accountInsertForm) {
AccountDTO accountDTO = new AccountDTO();
//取参
ManageAccount manageAccount = accountInsertForm.formConvertEntity();
List roleIds = accountInsertForm.getRoleIds();
/*判断账号是否存在*/
ManageAccount existAccount = new ManageAccount();
existAccount.setAccount(manageAccount.getAccount());
existAccount.setIsDelete(Constants.NOT_DELETE);
QueryWrapper wrapper = new QueryWrapper<>();
wrapper.setEntity(existAccount);
ManageAccount exitAccountResult = manageAccountMapper.selectOne(wrapper);
if (!ObjectUtils.isEmpty(exitAccountResult)) {
accountDTO.setCode(ResponseCodeEnum.ACCOUNT_EXIST.getCode());
accountDTO.setMsg(ResponseCodeEnum.ACCOUNT_EXIST.getMsg());
return accountDTO;
}
//插入
manageAccountMapper.insert(manageAccount);
//如果新建账号没有分配角色则不进行操作
if (!ObjectUtils.isEmpty(roleIds)) {
Integer accountId = manageAccount.getId();
roleIds.forEach(
value -> {
ManageAccountRole manageAccountRole = new ManageAccountRole();
manageAccountRole.setAccountId(accountId);
manageAccountRole.setRoleId(value);
manageAccountRoleMapper.insert(manageAccountRole);
}
);
}
//封装返回结果
accountDTO.setCode(ResponseCodeEnum.SUCCESS.getCode());
accountDTO.setMsg(ResponseCodeEnum.SUCCESS.getMsg());
//操作插入日志
HttpServletRequest request = ((ServletRequestAttributes) RequestContextHolder.getRequestAttributes()).getRequest();
StringBuilder content = new StringBuilder();
content.append("添加了用户:").append(manageAccount.getUserName() + ";")
.append("account:" + manageAccount.getAccount() + ";");
logUtils.saveOperationForManage(request, content.toString(), Constants.INSERT_OPERATE_TYPE);
return accountDTO;
}
/**
* @Description: 查询后台账号
* @Param: [accountQueryRequest]
* @return: com.moral.api.pojo.dto.AccountDTO
* @Author: 陈凯裕
* @Date: 2021/3/15
*/
@Override
public AccountQueryDTO queryAccount(AccountQueryForm accountQueryForm) {
AccountQueryDTO accountQueryDTO = new AccountQueryDTO();
//取参
Integer page = accountQueryForm.getPage();
Integer size = accountQueryForm.getSize();
String userName = accountQueryForm.getUserName();
String email = accountQueryForm.getEmail();
String mobile = accountQueryForm.getMobile();
String wechat = accountQueryForm.getWechat();
String isDelete = accountQueryForm.getIsDelete();
String order = accountQueryForm.getOrder();
String orderType = accountQueryForm.getOrderType();
Date createStartTime = accountQueryForm.getCreateStartTime();
Date createEndTime = accountQueryForm.getCreateEndTime();
//组装查询条件
Page queryPage = new Page<>(page, size);
NullFilterWrapper wrapper = new NullFilterWrapper<>();
wrapper.like("user_name", userName);
wrapper.like("email", email);
wrapper.like("mobile", mobile);
wrapper.like("wechat", wechat);
wrapper.between("create_time", createStartTime, createEndTime);
if (!ObjectUtils.isEmpty(order) && !ObjectUtils.isEmpty(orderType)) { //排序顺序条件构造
if (orderType.equals(Constants.ORDER_ASC))
wrapper.orderByAsc(ConvertUtils.toLine(order));
else
wrapper.orderByDesc(ConvertUtils.toLine(order));
}
if (!ObjectUtils.isEmpty(isDelete))//逻辑删除条件构造
wrapper.eq("is_delete", isDelete);
else
wrapper.eq("is_delete", Constants.NOT_DELETE);
//查询结果
Page resultPage = manageAccountMapper.selectPage(queryPage, wrapper);
//查询用户对应的角色
List accounts = resultPage.getRecords();
List accountDTOS = new ArrayList<>();
for (ManageAccount manageAccount : accounts) {
AccountDTO accountDTO = new AccountDTO();
List 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());
accountQueryDTO.setCode(ResponseCodeEnum.SUCCESS.getCode());
accountQueryDTO.setMsg(ResponseCodeEnum.SUCCESS.getMsg());
return accountQueryDTO;
}
/**
* @Description: 删除后台账号
* @Param: [accountDeleteRequest]
* @return: com.moral.api.pojo.dto.account.AccountDeleteDTO
* @Author: 陈凯裕
* @Date: 2021/3/16
*/
@Override
@Transactional
public AccountDTO deleteAccount(AccountDeleteForm accountDeleteForm) {
AccountDTO accountDTO = new AccountDTO();
//取参
Integer accountId = accountDeleteForm.getAccountId();
//查询要删除的账号,用于插入日志
ManageAccount manageAccount = new ManageAccount();
manageAccount.setIsDelete(Constants.NOT_DELETE);
manageAccount.setId(accountId);
QueryWrapper queryWrapper = new QueryWrapper<>();
queryWrapper.setEntity(manageAccount);
ManageAccount existManageAccount = manageAccountMapper.selectOne(queryWrapper);
if (ObjectUtils.isEmpty(existManageAccount)) {
accountDTO.setCode(ResponseCodeEnum.ACCOUNT_NOT_EXIST.getCode());
accountDTO.setMsg(ResponseCodeEnum.ACCOUNT_NOT_EXIST.getMsg());
return accountDTO;
}
//逻辑删除账号
UpdateWrapper deleteAccountWrapper = new UpdateWrapper<>();
deleteAccountWrapper.eq("id", accountId);
deleteAccountWrapper.set("is_delete", Constants.DELETE);
manageAccountMapper.update(null, deleteAccountWrapper);
//逻辑删除账号相关角色
UpdateWrapper deleteManageAccountRoleWrapper = new UpdateWrapper<>();
deleteManageAccountRoleWrapper.set("is_delete", Constants.DELETE).eq("account_id", manageAccount.getId());
manageAccountRoleMapper.update(null, deleteManageAccountRoleWrapper);
//销毁token
TokenUtils.destoryToken(accountId);
//封装返回结果
accountDTO.setCode(ResponseCodeEnum.SUCCESS.getCode());
accountDTO.setMsg(ResponseCodeEnum.SUCCESS.getMsg());
//操作插入日志
HttpServletRequest request = ((ServletRequestAttributes) RequestContextHolder.getRequestAttributes()).getRequest();
StringBuilder content = new StringBuilder();
content.append("删除了用户:").append(existManageAccount.getUserName() + ";")
.append("账号:" + existManageAccount.getAccount() + ";");
logUtils.saveOperationForManage(request, content.toString(), Constants.DELETE_OPERATE_TYPE);
return accountDTO;
}
/**
* @Description: 更新后台账号
* @Param: [accountUpdateRequest]
* @return: com.moral.api.pojo.dto.account.AccountUpdateDTO
* @Author: 陈凯裕
* @Date: 2021/3/16
*/
@Override
@Transactional
public AccountDTO updateAccount(AccountUpdateForm accountUpdateForm) {
AccountDTO accountDTO = new AccountDTO();
//取参
ManageAccount manageAccount = accountUpdateForm.formConvertEntity();
List roleIds = accountUpdateForm.getRoleIds();
//查找要更新的用户用于插入日志
QueryWrapper oldAccountWrapper = new QueryWrapper<>();
ManageAccount oldManageAccount = new ManageAccount();
oldManageAccount.setId(manageAccount.getId());
oldManageAccount.setIsDelete(Constants.NOT_DELETE);
oldAccountWrapper.setEntity(oldManageAccount);
oldManageAccount = manageAccountMapper.selectOne(oldAccountWrapper);
if (ObjectUtils.isEmpty(oldManageAccount)) {
accountDTO.setCode(ResponseCodeEnum.ACCOUNT_NOT_EXIST.getCode());
accountDTO.setMsg(ResponseCodeEnum.ACCOUNT_NOT_EXIST.getMsg());
return accountDTO;
}
//更新ManageAccount表
Map manageAccountMap = JSONObject.parseObject(JSON.toJSONString(manageAccount), Map.class);//转换为Map判断属性是否有更新
if (manageAccountMap.size() > 1) {//判断如果没有除了id以外的任何属性则不更新
manageAccountMapper.updateById(manageAccount);
}
//获取账号更新前的角色
List oldRoles = manageRoleMapper.getManageRoleByAccountId(manageAccount.getId());
//如果角色有变动,则更新ManageAccountRole表
/*
* 如果roleIds为null,则是该账号角色没有发生改变
* 如果roleIds为空,则是该账号所有的角色都被移除
* 如果roleIds有元素,则是该账号的角色有更新
* */
if (roleIds != null) {
//删除原有角色
UpdateWrapper deleteWrapper = new UpdateWrapper<>();
deleteWrapper.eq("account_id", manageAccount.getId()).set("is_delete", Constants.DELETE);
manageAccountRoleMapper.update(null, deleteWrapper);
/*重新添加角色*/
for (Integer roleId : roleIds) {
ManageAccountRole manageAccountRole = new ManageAccountRole();
manageAccountRole.setAccountId(manageAccount.getId());
manageAccountRole.setRoleId(roleId);
manageAccountRoleMapper.insert(manageAccountRole);
}
}
//操作插入日志
insertUpdateLog(accountUpdateForm, oldManageAccount, oldRoles);
//销毁token
TokenUtils.destoryToken(manageAccount.getId());
//封装返回结果
accountDTO.setCode(ResponseCodeEnum.SUCCESS.getCode());
accountDTO.setMsg(ResponseCodeEnum.SUCCESS.getMsg());
return accountDTO;
}
/**
* @Description: 将更新操作插入日志
* @Param: [form, newAccount, oldAccount]
* @return: void
* @Author: 陈凯裕
* @Date: 2021/4/8
*/
private void insertUpdateLog(AccountUpdateForm updateForm, ManageAccount oldAccount, List oldRoles) {
//操作插入日志
HttpServletRequest request = ((ServletRequestAttributes) RequestContextHolder.getRequestAttributes()).getRequest();
StringBuilder content = new StringBuilder();
content.append("修改了用户:").append(oldAccount.getUserName() + ";")
.append("账号:" + oldAccount.getAccount() + ";");
//对象转为Map,获取对象更新前后的属性
Map newParameters = JSONObject.parseObject(JSON.toJSONString(updateForm), Map.class);
Map oldParameters = JSONObject.parseObject(JSON.toJSONString(oldAccount), Map.class);
//遍历配置文件中的Map,将属性转化为汉字
Set keys = manageAccountFormMap.keySet();
for (String key : keys) {
String value = manageAccountFormMap.get(key);//属性对应的汉字
if ("password".equals(key)) {//密码特殊处理,不显示在日志上
if (!ObjectUtils.isEmpty(updateForm.getPassword())) {//判断密码是否进行了更新
content.append("修改了密码;");
}
} else if ("roleIds".equals(key)) {//角色特殊处理,将Id转化为角色名称
List newRoleIds = updateForm.getRoleIds();
if (newRoleIds != null && 0 == newRoleIds.size()) {//如果新的角色集合为空,则是删除了所有的角色
content.append("角色:删除了所有角色;");
}
if ((newRoleIds != null) && (newRoleIds.size() != 0)) {//如果新的角色集合不为空,且不为null,则角色进行了更新
StringBuilder oldRolesName = new StringBuilder("空");
StringBuilder newRolesName = new StringBuilder("空");
List newRoles = null;
if (!ObjectUtils.isEmpty(updateForm.getRoleIds())) {
newRoles = manageRoleMapper.selectBatchIds(updateForm.getRoleIds());
}
if (!ObjectUtils.isEmpty(oldRoles)) {
oldRolesName.deleteCharAt(oldRolesName.length() - 1);//删除 "空"
oldRolesName.append("[");
for (ManageRole role : oldRoles) {
oldRolesName.append(role.getName() + ",");
}
oldRolesName.deleteCharAt(oldRolesName.length() - 1);//移除最后一个逗号
oldRolesName.append("]");
}
if (!ObjectUtils.isEmpty(newRoles)) {
newRolesName.deleteCharAt(newRolesName.length() - 1);//删除 "空"
newRolesName.append("[");
for (ManageRole role : newRoles) {
newRolesName.append(role.getName() + ",");
}
newRolesName.deleteCharAt(newRolesName.length() - 1);//移除最后一个逗号
newRolesName.append("]");
}
//拼接完整content
content.append(value + ":" + oldRolesName + "->" + newRolesName + ";");
}
} else {//其他属性处理
if (newParameters.get(key) != null) {
String newValue = "空";
String oldValue = "空";
if (newParameters.get(key) != null && !newParameters.get(key).equals(" ")) {
newValue = String.valueOf(newParameters.get(key));
}
if (oldParameters.get(key) != null && !oldParameters.get(key).equals(" ")) {
oldValue = String.valueOf(oldParameters.get(key));
}
content.append(value + ":" + oldValue + "->" + newValue + ";");
}
}
}
logUtils.saveOperationForManage(request, content.toString(), Constants.UPDATE_OPERATE_TYPE);
}
}