~chenjialiang/moral.git

			@@ -14,23 +14,25 @@
			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.*;
			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.constant.Constants;
			import com.moral.constant.ResponseCodeEnum;
			import com.moral.util.AESUtils;
			import com.moral.util.MD5Utils;
			import com.moral.util.TokenUtils;
			import org.springframework.beans.factory.annotation.Autowired;
			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>
			@@ -43,8 +45,7 @@
			@Service
			public class ManageAccountServiceImpl extends ServiceImpl<ManageAccountMapper, ManageAccount> implements ManageAccountService {

			@Value("${AES.KEY}")
			private String AESKey;

			@Autowired
			ManageAccountMapper manageAccountMapper;
			@Autowired
			@@ -54,16 +55,11 @@
			@Autowired
			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
			*/
			@@ -74,7 +70,7 @@
			String account = loginForm.getAccount();
			String AESPassword = loginForm.getPassword();
			//解密
			String password = AESUtils.decrypt(AESPassword, AESKey);
			String password = AESUtils.decrypt(AESPassword);
			//查询是否存在
			QueryWrapper<ManageAccount> wrapper = new QueryWrapper<>();
			wrapper.eq("account", account);
			@@ -87,7 +83,7 @@
			//查询是否逻辑删除
			ManageAccount manageAccount = null;
			for (ManageAccount value : manageAccounts) {
			if ("0".equals(value.getIsDelete()))
			if (Constants.NOT_DELETE.equals(value.getIsDelete()))
			manageAccount = value;
			}

			@@ -98,8 +94,8 @@
			}
			//校验密码
			if (!MD5Utils.saltMD5Verify(password, manageAccount.getPassword())) {
			loginDTO.setCode(ResponseCodeEnum.PASSWORD_INVALID.getCode());
			loginDTO.setMsg(ResponseCodeEnum.PASSWORD_INVALID.getMsg());
			loginDTO.setCode(ResponseCodeEnum.PASSWORD_ERROR.getCode());
			loginDTO.setMsg(ResponseCodeEnum.PASSWORD_ERROR.getMsg());
			return loginDTO;
			}

			@@ -133,7 +129,7 @@
			/**
			* @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
			*/
			@@ -159,55 +155,19 @@
			//取参
			String account = accountInsertForm.getAccount();
			String AESPassword = accountInsertForm.getPassword();
			String password = MD5Utils.saltMD5(AESUtils.decrypt(AESPassword, AESKey));
			String password = MD5Utils.saltMD5(AESUtils.decrypt(AESPassword));
			String userName = accountInsertForm.getUserName();
			String email = accountInsertForm.getEmail();
			String mobile = accountInsertForm.getMobile();
			String wechat = accountInsertForm.getWechat();
			List<String> roleIdsStr = accountInsertForm.getRoleIds();
			//校验参数是否符合业务逻辑
			/判断用户名是否包含特殊字符/
			if (isSpecialChar(account)) {
			accountInsertDTO.setCode(ResponseCodeEnum.ACCOUNT_EXIST_SPECIAL_CHAR.getCode());
			accountInsertDTO.setMsg(ResponseCodeEnum.ACCOUNT_EXIST_SPECIAL_CHAR.getMsg());
			return accountInsertDTO;
			}
			/判断密码是否包含特殊字符/
			if (isSpecialChar(password)) {
			accountInsertDTO.setCode(ResponseCodeEnum.PASSWORD_EXIST_SPECIAL_CHAR.getCode());
			accountInsertDTO.setMsg(ResponseCodeEnum.PASSWORD_EXIST_SPECIAL_CHAR.getMsg());
			return accountInsertDTO;
			}
			/判断用户名是否超过长度/
			if (account.length() >= 20 \|\| account.length() <= 6) {
			accountInsertDTO.setCode(ResponseCodeEnum.ACCOUNT_LENGTH_INVALID.getCode());
			accountInsertDTO.setMsg(ResponseCodeEnum.ACCOUNT_LENGTH_INVALID.getMsg());
			return accountInsertDTO;
			}
			/判断密码是否超过长度/
			if (AESUtils.decrypt(AESPassword, AESKey).length() >= 20 \|\| AESUtils.decrypt(AESPassword, AESKey).length() <= 6) {
			accountInsertDTO.setCode(ResponseCodeEnum.PASSWORD_LENGTH_INVALID.getCode());
			accountInsertDTO.setMsg(ResponseCodeEnum.PASSWORD_LENGTH_INVALID.getMsg());
			return accountInsertDTO;
			}
			/判断手机号是否符合规则/
			if (!isValidMobile(mobile)) {
			accountInsertDTO.setCode(ResponseCodeEnum.MOBILE_INVALID.getCode());
			accountInsertDTO.setMsg(ResponseCodeEnum.MOBILE_INVALID.getMsg());
			return accountInsertDTO;
			}
			/判断邮箱是否符合规则/
			if (!isValidEmail(email)) {
			accountInsertDTO.setCode(ResponseCodeEnum.EMAIL_INVALID.getCode());
			accountInsertDTO.setMsg(ResponseCodeEnum.EMAIL_INVALID.getMsg());
			return accountInsertDTO;
			}

			/判断账号是否存在/
			ManageAccount exitAccount = new ManageAccount();
			exitAccount.setAccount(account);
			exitAccount.setIsDelete("0");
			ManageAccount existAccount = new ManageAccount();
			existAccount.setAccount(account);
			existAccount.setIsDelete(Constants.NOT_DELETE);
			QueryWrapper<ManageAccount> wrapper = new QueryWrapper<>();
			wrapper.setEntity(exitAccount);
			wrapper.setEntity(existAccount);
			List<ManageAccount> exitAccounts = manageAccountMapper.selectList(wrapper);
			if (!ObjectUtils.isEmpty(exitAccounts)) {
			accountInsertDTO.setCode(ResponseCodeEnum.ACCOUNT_EXIST.getCode());
			@@ -271,38 +231,49 @@
			String mobile = accountQueryForm.getMobile();
			String wechat = accountQueryForm.getWechat();
			String isDelete = accountQueryForm.getIsDelete();
			String order = accountQueryForm.getOrder();
			String orderType = accountQueryForm.getOrderType();

			//查询用户
			Page<ManageAccount> page = new Page<>(pageCount, size);
			QueryWrapper<ManageAccount> wrapper = new QueryWrapper();
			if(!ObjectUtils.isEmpty(accountId)){
			wrapper.eq("id",accountId);
			if (!ObjectUtils.isEmpty(accountId)) {
			wrapper.eq("id", accountId);
			}

			if(!ObjectUtils.isEmpty(userName)){
			wrapper.like("user_name",userName);
			if (!ObjectUtils.isEmpty(userName)) {
			wrapper.like("user_name", userName);
			}

			if(!ObjectUtils.isEmpty(account)){
			wrapper.like("account",account);
			if (!ObjectUtils.isEmpty(account)) {
			wrapper.like("account", account);
			}

			if(!ObjectUtils.isEmpty(email)){
			wrapper.like("email",email);
			if (!ObjectUtils.isEmpty(email)) {
			wrapper.like("email", email);
			}

			if(!ObjectUtils.isEmpty(mobile)){
			wrapper.like("mobile",mobile);
			if (!ObjectUtils.isEmpty(mobile)) {
			wrapper.like("mobile", mobile);
			}

			if(!ObjectUtils.isEmpty(wechat)){
			wrapper.like("wechat",wechat);
			if (!ObjectUtils.isEmpty(wechat)) {
			wrapper.like("wechat", wechat);
			}

			if (!ObjectUtils.isEmpty(order)) {
			if (!ObjectUtils.isEmpty(orderType)) {
			if (orderType.equals(Constants.ORDER_ASC))
			wrapper.orderByAsc(order);
			else
			wrapper.orderByDesc(order);
			}
			}

			if (!ObjectUtils.isEmpty(isDelete))
			wrapper.eq("is_delete", isDelete);
			else
			wrapper.eq("is_delete", "0");
			wrapper.eq("is_delete", Constants.NOT_DELETE);

			Page resultPage = manageAccountMapper.selectPage(page, wrapper);
			//查询用户对应的角色
			@@ -342,17 +313,17 @@
			AccountUpdateDTO accountUpdateDTO = new AccountUpdateDTO();
			//取参
			Integer accountId = accountUpdateForm.getAccountId();
			String password = accountUpdateForm.getPassword();
			String email = accountUpdateForm.getEmail();
			String mobile = accountUpdateForm.getMobile();
			String wechat = accountUpdateForm.getWechat();
			String userName = accountUpdateForm.getUserName();
			List<Integer> roleIds = accountUpdateForm.getRoleIds();
			//校验参数是否符合逻辑
			/判断要更新的用户是否存在/
			//判断要更新的用户是否存在
			QueryWrapper<ManageAccount> exitWrapper = new QueryWrapper<>();
			ManageAccount exitManageAccount = new ManageAccount();
			exitManageAccount.setId(accountId);
			exitManageAccount.setIsDelete("0");
			exitManageAccount.setIsDelete(Constants.NOT_DELETE);
			exitWrapper.setEntity(exitManageAccount);
			List<ManageAccount> manageAccounts = manageAccountMapper.selectList(exitWrapper);
			if (ObjectUtils.isEmpty(manageAccounts)) {
			@@ -360,20 +331,13 @@
			accountUpdateDTO.setMsg(ResponseCodeEnum.ACCOUNT_NOT_EXIST.getMsg());
			return accountUpdateDTO;
			}
			/判断手机号是否符合规则/
			if (!isValidMobile(mobile)) {
			accountUpdateDTO.setCode(ResponseCodeEnum.MOBILE_INVALID.getCode());
			accountUpdateDTO.setMsg(ResponseCodeEnum.MOBILE_INVALID.getMsg());
			return accountUpdateDTO;
			}
			/判断邮箱是否符合规则/
			if (!isValidEmail(email)) {
			accountUpdateDTO.setCode(ResponseCodeEnum.EMAIL_INVALID.getCode());
			accountUpdateDTO.setMsg(ResponseCodeEnum.EMAIL_INVALID.getMsg());
			return accountUpdateDTO;
			//转换password
			if(!ObjectUtils.isEmpty(password)){
			password = MD5Utils.saltMD5(AESUtils.decrypt(password));
			}
			//更新ManageAccount表
			ManageAccount manageAccount = new ManageAccount();
			manageAccount.setPassword(password);
			manageAccount.setEmail(email);
			manageAccount.setMobile(mobile);
			manageAccount.setWechat(wechat);
			@@ -381,24 +345,26 @@
			QueryWrapper<ManageAccount> wrapper = new QueryWrapper<>();
			wrapper.eq("id", accountId);
			manageAccountMapper.update(manageAccount, wrapper);
			//更新ManageAccountRole表
			//如果角色有变动，则更新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);
			if (!ObjectUtils.isEmpty(roleIds)) {
			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.setRoles(manageRoles);
			}
			//获取用户所有角色
			List<ManageRole> manageRoles = manageRoleMapper.selectBatchIds(roleIds);
			//封装返回结果
			accountUpdateDTO.setCode(ResponseCodeEnum.SUCCESS.getCode());
			accountUpdateDTO.setMsg(ResponseCodeEnum.SUCCESS.getMsg());
			accountUpdateDTO.setRoles(manageRoles);
			accountUpdateDTO.setAccount(manageAccountMapper.selectById(accountId));
			return accountUpdateDTO;
			}
			@@ -419,49 +385,30 @@
			Integer accountId = accountDeleteForm.getAccountId();
			//查询是否存在
			ManageAccount manageAccount = new ManageAccount();
			manageAccount.setIsDelete("0");
			manageAccount.setIsDelete(Constants.NOT_DELETE);
			manageAccount.setId(accountId);
			QueryWrapper<ManageAccount> queryWrapper = new QueryWrapper<>();
			queryWrapper.setEntity(manageAccount);
			ManageAccount existManageAccount = manageAccount.selectOne(queryWrapper);
			ManageAccount existManageAccount = manageAccountMapper.selectOne(queryWrapper);
			if (ObjectUtils.isEmpty(existManageAccount)) {
			accountDeleteDTO.setCode(ResponseCodeEnum.ACCOUNT_NOT_EXIST.getCode());
			accountDeleteDTO.setMsg(ResponseCodeEnum.ACCOUNT_NOT_EXIST.getMsg());
			return accountDeleteDTO;
			}
			//逻辑删除账号
			existManageAccount.setIsDelete("1");
			existManageAccount.setIsDelete(Constants.DELETE);
			UpdateWrapper<ManageAccount> deleteAccountWrapper = new UpdateWrapper<>();
			deleteAccountWrapper.set("is_delete", "1").eq("id", manageAccount.getId());
			deleteAccountWrapper.set("is_delete", Constants.DELETE).eq("id", manageAccount.getId());
			manageAccountMapper.update(null, deleteAccountWrapper);
			//逻辑删除账号相关角色
			UpdateWrapper<ManageAccountRole> deleteManageAccountRoleWrapper = new UpdateWrapper<>();
			deleteManageAccountRoleWrapper.set("is_delete", "1").eq("account_id", manageAccount.getId());
			deleteManageAccountRoleWrapper.set("is_delete", Constants.DELETE).eq("account_id", manageAccount.getId());
			manageAccountRoleMapper.update(null, deleteManageAccountRoleWrapper);
			//封装返回结果
			accountDeleteDTO.setCode(ResponseCodeEnum.SUCCESS.getCode());
			accountDeleteDTO.setMsg(ResponseCodeEnum.SUCCESS.getMsg());
			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();
			}