package com.whyc.service;
|
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.whyc.constant.UserConstant;
|
import com.whyc.dto.Response;
|
import com.whyc.mapper.UserMapper;
|
import com.whyc.mapper.UserPermitGroupDataMapper;
|
import com.whyc.pojo.UserClient;
|
import com.whyc.pojo.UserInf;
|
import com.whyc.pojo.UserPermitGroupData;
|
import com.whyc.util.ActionUtil;
|
import com.whyc.util.RSAUtil;
|
import lombok.extern.slf4j.Slf4j;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.context.ApplicationContext;
|
import org.springframework.stereotype.Service;
|
|
import javax.annotation.Resource;
|
import javax.servlet.ServletContext;
|
import java.io.UnsupportedEncodingException;
|
import java.net.URLDecoder;
|
import java.security.InvalidParameterException;
|
import java.util.Date;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
|
@Service
|
@Slf4j
|
public class UserService {
|
|
@Resource
|
private UserMapper userMapper;
|
|
@Resource
|
private UserPermitGroupDataMapper permitMapper;
|
@Resource
|
private UserBridgeService userBridgeService;
|
|
@Autowired
|
private ApplicationContext applicationContext;
|
|
public Response add(UserInf user) {
|
try {
|
UserInf userFound = userBridgeService.findPasswordByUserName(user.getUName());
|
if (userFound.getUId() != 0) {
|
return new Response<>().set(1, false, "用户已存在");
|
}
|
if (userMapper.addJudge(user.getUName(),user.getUMobilephone())>0){
|
return new Response<>().set(1, false, "用户已存在");
|
}
|
//user.setCreateTime(new Date());
|
String[] dataArr = RSAUtil.decryptFrontP(user.getUpassword(), RSAUtil.fontSeparator);
|
String password = dataArr[0];
|
String passwordMD5 = dataArr[1];
|
if(!ActionUtil.EncryptionMD5(password).equals(passwordMD5)){
|
throw new InvalidParameterException("参数校验失败");
|
}
|
user.setUpassword(RSAUtil.encrypt(password,RSAUtil.getPublicKey()));
|
int flag = userMapper.insert(user);
|
if (flag > 0) {
|
Integer uId= userMapper.getUserInfoByPhoneNumber(user.getUMobilephone()).getUId().intValue();
|
UserPermitGroupData permitGroupData = new UserPermitGroupData();
|
permitGroupData.setPermitGroupId(user.getPermitGroupId());
|
permitGroupData.setUId(uId);
|
permitMapper.insert(permitGroupData);
|
return new Response<>().set(1, true);
|
} else {
|
return new Response<>().set(1, false, "添加失败");
|
}
|
}catch (Exception e){
|
e.printStackTrace();
|
return new Response<>().set(0);
|
}
|
}
|
public Response addByRSA(UserInf user) {
|
try {
|
UserInf userFound = userBridgeService.findPasswordByUserName(user.getUName());
|
if (userFound.getUId() != 0) {
|
return new Response<>().set(1, false, "用户已存在");
|
}
|
String password = "";
|
try {
|
password = URLDecoder.decode(user.getUpassword(), "utf-8");
|
}catch (UnsupportedEncodingException e){
|
e.printStackTrace();
|
}
|
String[] dataArr = RSAUtil.decryptFront(password, RSAUtil.fontSeparator);
|
String pwd = RSAUtil.encrypt(dataArr[0],RSAUtil.getPublicKey());
|
user.setUpassword(pwd);
|
int flag = userMapper.insert(user);
|
if (flag > 0) {
|
Integer uId= userMapper.getUserInfoByPhoneNumber(user.getUMobilephone()).getUId().intValue();
|
UserPermitGroupData permitGroupData = new UserPermitGroupData();
|
permitGroupData.setPermitGroupId(user.getPermitGroupId());
|
permitGroupData.setUId(uId);
|
permitMapper.insert(permitGroupData);
|
return new Response<>().set(1, true);
|
} else {
|
return new Response<>().set(1, false, "添加失败");
|
}
|
}catch (Exception e){
|
e.printStackTrace();
|
return new Response<>().set(0);
|
}
|
}
|
|
public UserInf getById(int id) {
|
return userMapper.selectById(id);
|
}
|
|
public List<UserInf> getAll() {
|
List<UserInf> users = userMapper.selectList(null);
|
return users;
|
}
|
|
public IPage<UserInf> getAllWithPage(Page page) {
|
return userMapper.selectPage(page, null);
|
}
|
|
public boolean update(UserInf user) {
|
//非系统管理员用户,禁止修改访问ip和访问时间
|
if(user.getUId()!=1 && user.getUName().equals("sys_admin")){
|
user.setVisitIp(null);
|
user.setVisitTime(null);
|
}
|
return userMapper.updateById(user)>0;
|
}
|
|
public boolean delete(int id) {
|
return userMapper.deleteById(id)>0;
|
}
|
|
// 将所有登陆的用户的信息存到application中
|
public void setApplication(UserInf user) {
|
ServletContext application = ActionUtil.getApplication();
|
//查看全局中存储的users的Map的key-value集合
|
Map<String, UserClient> map = (Map) application.getAttribute("users");
|
if (map == null) {
|
map = new HashMap<String, UserClient>();
|
} else {
|
//如果集合中有值,则获取当前用户对应的用户信息,key为用户名username,Value为用户名,存储的时间
|
UserClient client = map.get(user.getUName());
|
if (client != null) { //已存在
|
map.remove(user.getUName());
|
}
|
}
|
Long login_time = new Date().getTime();
|
ActionUtil.getSession().setAttribute("login_time", login_time);
|
map.put(user.getUName(), new UserClient(ActionUtil.getRequest().getRemoteAddr(),user,login_time));
|
application.setAttribute("users", map);
|
}
|
|
public UserInf getUserByUKeyId(String uKeyId){
|
QueryWrapper queryWrapper = new QueryWrapper();
|
queryWrapper.eq("uKey_ID",uKeyId);
|
UserInf userInf = userMapper.selectOne(queryWrapper);
|
return userInf;
|
}
|
|
public UserInf getUserByUserName(String userName){
|
QueryWrapper queryWrapper = new QueryWrapper();
|
queryWrapper.eq("Uname",userName);
|
UserInf userInf = userMapper.selectOne(queryWrapper);
|
return userInf;
|
}
|
|
public boolean bindUkey(UserInf userInf){
|
UpdateWrapper updateWrapper = new UpdateWrapper();
|
updateWrapper.eq("uName",userInf.getUName());
|
int affectRows = userMapper.update(userInf,updateWrapper);
|
return affectRows>0;
|
}
|
|
|
public Response updatePassword(UserInf userInf,String password){
|
String[] dataArr = RSAUtil.decryptFrontP(password, RSAUtil.fontSeparator);
|
password = dataArr[0];
|
String passwordMD5 = dataArr[1];
|
if(!ActionUtil.EncryptionMD5(password).equals(passwordMD5)){
|
throw new InvalidParameterException("参数校验失败");
|
}
|
userInf.setUpassword(RSAUtil.encrypt(password,RSAUtil.getPublicKey()));
|
if (userMapper.updateById(userInf)>0){
|
return new Response().set(1,"修改成功");
|
}else {
|
return new Response().set(0,"修改失败");
|
}
|
}
|
|
public Response updatePasswordByRSA(UserInf user,String newPwd){
|
String[] dataArr = RSAUtil.decryptFrontP(newPwd, RSAUtil.fontSeparator);
|
newPwd = dataArr[0];
|
String passwordMD5 = dataArr[1];
|
if(!ActionUtil.EncryptionMD5(newPwd).equals(passwordMD5)){
|
throw new InvalidParameterException("参数校验失败");
|
}
|
user.setUpassword(RSAUtil.encrypt(newPwd,RSAUtil.getPublicKey()));
|
if (userMapper.updateById(user)>0){
|
return new Response().set(1,"修改成功");
|
}else {
|
return new Response().set(0,"修改失败");
|
}
|
}
|
|
|
public Response updatePassword2(UserInf userInf, String passwordOld, String passwordNew) {
|
//检查旧密码
|
QueryWrapper<UserInf> queryWrapper = Wrappers.query();
|
queryWrapper.select("upassword").eq("uName",userInf.getUName()).last(" limit 1");
|
String passwordDB = userMapper.selectOne(queryWrapper).getUpassword();
|
if(!RSAUtil.decrypt(passwordDB,RSAUtil.getPrivateKey()).equals(passwordOld)){
|
return new Response().set(1,false,"旧密码输入错误");
|
}
|
//更新新密码
|
UpdateWrapper<UserInf> updateWrapper = Wrappers.update();
|
updateWrapper.set("upassword",RSAUtil.encrypt(passwordNew,RSAUtil.getPublicKey())).eq("uName",userInf.getUName());
|
userMapper.update(null,updateWrapper);
|
return new Response().set(1,true,"密码修改成功");
|
}
|
|
/**锁定账号*/
|
public void lock(Long uId) {
|
UpdateWrapper<UserInf> wrapper = Wrappers.update();
|
wrapper.set("status", UserConstant.ACCOUNT_STATUS_LOCK_FAIL.getValue()).eq("uId",uId);
|
userMapper.update(null,wrapper);
|
}
|
|
/**更新登录时间*/
|
public void updateLoginTime(Long uId) {
|
UpdateWrapper<UserInf> wrapper = Wrappers.update();
|
wrapper.set("last_login_time", new Date()).eq("uId",uId);
|
userMapper.update(null,wrapper);
|
}
|
|
|
public void updateExpiredAccount() {
|
UpdateWrapper<UserInf> wrapper = Wrappers.update();
|
wrapper.set("status",UserConstant.ACCOUNT_STATUS_CANCEL).eq("type",UserConstant.ACCOUNT_TYPE_TEMP).gt("expiration_time",new Date());
|
userMapper.update(null,wrapper);
|
}
|
|
public void unLock() {
|
UpdateWrapper<UserInf> wrapper = Wrappers.update();
|
wrapper.set("status", UserConstant.ACCOUNT_STATUS_ACTIVE.getValue()).set("lock_time",null)
|
.eq("status",UserConstant.ACCOUNT_STATUS_LOCK_FAIL.getValue())
|
.last(" and date_add(lock_time,interval 20 MINUTE)<now() and uId is not null");
|
userMapper.update(null,wrapper);
|
}
|
|
public void updateAccountStatus(int status) {
|
UpdateWrapper<UserInf> wrapper = Wrappers.update();
|
wrapper.set("status", status)
|
.eq("status",UserConstant.ACCOUNT_STATUS_ACTIVE.getValue())
|
.last(" and date_add(last_login_time,interval 3 MONTH)<now() and uId is not null");
|
userMapper.update(null,wrapper);
|
}
|
|
public void unLock(int uId, int unLockType) {
|
UpdateWrapper<UserInf> wrapper = Wrappers.update();
|
wrapper.set("status",1).eq("uId",uId);
|
if(unLockType==1){
|
wrapper.set("lock_time",null);
|
}else{
|
wrapper.set("last_login_time",new Date());
|
}
|
userMapper.update(null,wrapper);
|
}
|
|
public List<UserInf> searchCS_All2() {
|
return userMapper.searchCS_All2();
|
}
|
}
|
