From 983bdb5b89932b38d08a11ad1eed6ea89d1597e1 Mon Sep 17 00:00:00 2001
From: kongzy <kongzy>
Date: 星期一, 29 一月 2024 10:07:31 +0800
Subject: [PATCH] 更新

---
 assess-system/src/main/java/com/gkhy/assess/system/service/impl/SysUserServiceImpl.java |  272 ++++++++++++++++++++++++++++++++++-------------------
 1 files changed, 173 insertions(+), 99 deletions(-)

diff --git a/assess-system/src/main/java/com/gkhy/assess/system/service/impl/SysUserServiceImpl.java b/assess-system/src/main/java/com/gkhy/assess/system/service/impl/SysUserServiceImpl.java
index a552f44..5004259 100644
--- a/assess-system/src/main/java/com/gkhy/assess/system/service/impl/SysUserServiceImpl.java
+++ b/assess-system/src/main/java/com/gkhy/assess/system/service/impl/SysUserServiceImpl.java
@@ -2,19 +2,22 @@
 
 import cn.hutool.core.codec.Base64;
 import cn.hutool.core.util.ObjectUtil;
+import com.alibaba.fastjson.JSONObject;
+import com.baomidou.mybatisplus.core.toolkit.Wrappers;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
 import com.gkhy.assess.common.api.CommonPage;
 import com.gkhy.assess.common.constant.CacheConstant;
 import com.gkhy.assess.common.domain.vo.AccountVO;
 import com.gkhy.assess.common.domain.vo.LoginBody;
 import com.gkhy.assess.common.enums.AttachTypeEnum;
+import com.gkhy.assess.common.enums.DeleteFlagEnum;
 import com.gkhy.assess.common.enums.UserIdentityEnum;
 import com.gkhy.assess.common.exception.ApiException;
 import com.gkhy.assess.common.utils.*;
-import com.gkhy.assess.system.domain.SysAgency;
-import com.gkhy.assess.system.domain.SysAttach;
-import com.gkhy.assess.system.domain.SysUser;
-import com.gkhy.assess.system.mapper.SysAgencyMapper;
+import com.gkhy.assess.system.domain.*;
+import com.gkhy.assess.system.domain.vo.PersonProjectVO;
+import com.gkhy.assess.system.mapper.AssProjectMapper;
+import com.gkhy.assess.system.mapper.SysUserFaceMapper;
 import com.gkhy.assess.system.mapper.SysUserMapper;
 import com.gkhy.assess.system.service.SysAgencyService;
 import com.gkhy.assess.system.service.SysAttachService;
@@ -24,6 +27,7 @@
 import org.apache.shiro.SecurityUtils;
 import org.apache.shiro.authc.*;
 import org.apache.shiro.subject.Subject;
+import org.checkerframework.checker.units.qual.A;
 import org.springframework.beans.BeanUtils;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
@@ -31,9 +35,8 @@
 
 import javax.servlet.http.HttpServletRequest;
 import javax.validation.Validator;
-import java.util.ArrayList;
-import java.util.List;
-import java.util.Objects;
+import java.util.*;
+import java.util.stream.Collectors;
 
 
 /**
@@ -55,18 +58,20 @@
 
     @Autowired
     private HttpServletRequest request;
-    @Autowired
-    private SysAgencyMapper agencyMapper;
+
     @Autowired
     private SysAgencyService agencyService;
     @Autowired
     private SysAttachService attachService;
-
+    @Autowired
+    private SysUserFaceMapper userFaceMapper;
+    @Autowired
+    private AssProjectMapper projectMapper;
 
     @Override
     public AccountVO login(LoginBody loginBody) {
         // 验证码校验
-      //  validateCaptcha(loginBody.getUsername(), loginBody.getCode(), loginBody.getUuid());
+        //validateCaptcha(loginBody.getUsername(), loginBody.getCode(), loginBody.getUuid());
         UsernamePasswordToken usernamePasswordToken = new UsernamePasswordToken(loginBody.getUsername(), Base64.decodeStr(loginBody.getPassword()), false);
         Subject subject= SecurityUtils.getSubject();
         String msg ;
@@ -75,10 +80,52 @@
             SysUser sysUser = (SysUser) subject.getPrincipal();
             AccountVO accountVO = new AccountVO();
             BeanUtils.copyProperties(sysUser, accountVO);
-
+            if(sysUser.getAgencyId()!=null){
+                SysAgency agency=agencyService.getOne(Wrappers.<SysAgency>lambdaQuery()
+                        .select(SysAgency::getId,SysAgency::getName)
+                        .eq(SysAgency::getId,sysUser.getAgencyId()));
+                accountVO.setAgentName(agency.getName());
+                accountVO.setAgentId(agency.getId());
+            }
             String token = JwtTokenUtil.sign(sysUser.getUsername(),sysUser.getPassword());
             accountVO.setToken(token);
             cacheUserToken(sysUser.getUsername(),token);
+            return accountVO;
+        }catch (UnknownAccountException | IncorrectCredentialsException uae){
+            throw new ApiException("用户名/密码错误,请重新输入");
+        } catch (LockedAccountException lae) { // 账号已被锁定
+            msg = "账号已被锁定";
+            throw new ApiException(msg);
+        }catch (AuthenticationException ae) { // 其他身份验证异常
+            msg = "用户认证失败:"+ae.getMessage();
+            throw new ApiException(msg);
+        }
+    }
+
+
+
+    @Override
+    public AccountVO appLogin(LoginBody loginBody) {
+        // 验证码校验
+        UsernamePasswordToken usernamePasswordToken = new UsernamePasswordToken(loginBody.getUsername(), Base64.decodeStr(loginBody.getPassword()), false);
+        Subject subject= SecurityUtils.getSubject();
+        String msg ;
+        try {
+            subject.login(usernamePasswordToken);
+            SysUser sysUser = (SysUser) subject.getPrincipal();
+            AccountVO accountVO = new AccountVO();
+            BeanUtils.copyProperties(sysUser, accountVO);
+            if(sysUser.getAgencyId()!=null){
+                SysAgency agency=agencyService.getOne(Wrappers.<SysAgency>lambdaQuery()
+                        .select(SysAgency::getId,SysAgency::getName)
+                        .eq(SysAgency::getId,sysUser.getAgencyId()));
+                accountVO.setAgentName(agency.getName());
+                accountVO.setAgentId(agency.getId());
+            }
+            String token = JwtTokenUtil.sign(sysUser.getUsername(),sysUser.getPassword());
+            accountVO.setToken(token);
+            cacheUserToken(sysUser.getUsername(),token);
+            accountVO.setUserFace(userFaceMapper.getFaceByUserId(sysUser.getId()));
             return accountVO;
         }catch (UnknownAccountException | IncorrectCredentialsException uae){
             throw new ApiException("用户名/密码错误,请重新输入");
@@ -97,14 +144,14 @@
      */
     public void cacheUserToken(String username,String newToken){
 
-//        String userKey = redisUtils.generateKey(CacheConstant.SYS_USER_TOKEN + ":" + username);
-//        String oldToken = (String) redisUtils.get(userKey);
-//        if (StrUtil.isNotBlank(oldToken)) {
-//            String oldTokenkey = redisUtils.generateKey(CacheConstant.SYS_USER_TOKEN + ":" + JwtTokenUtil.md5Encode(oldToken));
-//            redisUtils.del(oldTokenkey);
-//            redisUtils.del(userKey);
-//        }
-//        redisUtils.set(userKey, newToken,(JwtTokenUtil.EXPIRATION*2/1000)+2);
+        String userKey = redisUtils.generateKey(CacheConstant.SYS_USER_TOKEN + ":" + username);
+        String oldToken = (String) redisUtils.get(userKey);
+        if (StringUtils.isNotBlank(oldToken)) {
+            String oldTokenkey = redisUtils.generateKey(CacheConstant.SYS_USER_TOKEN + ":" + JwtTokenUtil.md5Encode(oldToken));
+            redisUtils.del(oldTokenkey);
+            redisUtils.del(userKey);
+        }
+        redisUtils.set(userKey, newToken,(JwtTokenUtil.EXPIRATION*2/1000)+2);
 
 
         String tokenKey= redisUtils.generateKey(CacheConstant.SYS_USER_TOKEN+":"+JwtTokenUtil.md5Encode(newToken));
@@ -142,9 +189,14 @@
     @Override
     public void logout() {
         String jwtToken = request.getHeader(JwtTokenUtil.USER_LOGIN_TOKEN);
-        String key= redisUtils.generateKey(CacheConstant.SYS_USER_TOKEN+":"+JwtTokenUtil.md5Encode(jwtToken));
-        //删除redis缓存
-        redisUtils.del(key);
+        if(StringUtils.isNotBlank(jwtToken)){
+            String username=JwtTokenUtil.getUsername(jwtToken);
+            String userKey = redisUtils.generateKey(CacheConstant.SYS_USER_TOKEN + ":" + username);
+            String tokenKey= redisUtils.generateKey(CacheConstant.SYS_USER_TOKEN+":"+JwtTokenUtil.md5Encode(jwtToken));
+            //删除redis缓存
+            redisUtils.del(tokenKey);
+            redisUtils.del(userKey);
+        }
     }
 
     @Override
@@ -163,8 +215,25 @@
 
     @Override
     public CommonPage<SysUser> expertList(SysUser user) {
+        SysUser currentUser= ShiroUtils.getSysUser();
+        if(!currentUser.getIdentity().equals(UserIdentityEnum.MONITOR.getCode())){
+            //机构用户只能查看本机构的专家
+            if(currentUser.getAgencyId()==null){
+                throw new ApiException("用户机构id为空");
+            }
+            user.setAgencyId(currentUser.getAgencyId());
+        }
         PageUtil.startPage();
         List<SysUser> users=baseMapper.expertList(user);
+        if(users.size()>0) {
+            //统计用户参与项目的信息
+            List<Long> userIds = users.stream().map(item -> item.getId()).collect(Collectors.toList());
+            List<PersonProjectVO> personProjectVOList = projectMapper.getProjectByPersonIds(userIds);
+            Map<Long, PersonProjectVO> maps = personProjectVOList.stream().collect(Collectors.toMap(PersonProjectVO::getPersonId, a -> a));
+            for (SysUser sysUser : users) {
+                sysUser.setPersonProjectVO(maps.get(sysUser.getId()));
+            }
+        }
         return CommonPage.restPage(users);
     }
 
@@ -216,8 +285,10 @@
         }
         String originPsword=Base64.decodeStr(user.getPassword());
         validatorPassword(originPsword);
+        //密码生成规则:md5(username+password+salt)
         user.setPassword(JwtTokenUtil.encryptPassword(user.getUsername(),originPsword,user.getSalt()));
         user.setIdentity(UserIdentityEnum.MONITOR.getCode());
+        user.setCreateBy(ShiroUtils.getSysUser().getUsername());
         boolean b=save(user);
         if(!b){
             throw new ApiException("创建监管用户信息失败");
@@ -246,15 +317,16 @@
         if(!agencyService.checkAgencyNameUnique(new SysAgency().setName(agency.getName()))){
             throw new ApiException("机构名称已存在");
         }
-        int i=agencyMapper.insert(agency);
-        if(i<1){
+        agency.setCreateBy(ShiroUtils.getSysUser().getUsername());
+        boolean b=agencyService.save(agency);
+        if(!b){
             throw new ApiException("保存机构信息失败");
         }
         user.setIdentity(UserIdentityEnum.AGENCY.getCode());
         user.setAgencyId(agency.getId());
         user.setPassword(JwtTokenUtil.encryptPassword(user.getUsername(),originPsword,user.getSalt()));
-
-        boolean b=save(user);
+        user.setCreateBy(ShiroUtils.getSysUser().getUsername());
+        b=save(user);
         if(!b){
             throw new ApiException("创建机构用户信息失败");
         }
@@ -264,6 +336,8 @@
     @Override
     @Transactional(rollbackFor = RuntimeException.class)
     public int addExpert(SysUser user) {
+        user.setIdentity(UserIdentityEnum.EXPERT.getCode());
+        checkUserAllowed(user);
         //校验用户信息
         if(!checkUsernameUnique(new SysUser().setUsername(user.getUsername()))){
             throw new ApiException("用户名已存在");
@@ -271,11 +345,19 @@
         if(!checkPhoneUnique(new SysUser().setUsername(user.getPhone()))){
             throw new ApiException("手机号已存在");
         }
+        String major=user.getMajor();
+        List<Integer> majors=new ArrayList<>();
+        JSONObject jsonObject=JSONObject.parseObject(major);
+        jsonObject.forEach((key,value)-> {
+            majors.add(Integer.valueOf(key));
+        });
+        user.setMajor(StringUtils.join(",",majors));
+        user.setCertificateNo(major);
         String originPsword=Base64.decodeStr(user.getPassword());
         validatorPassword(originPsword);
-        user.setIdentity(UserIdentityEnum.EXPERT.getCode());
         user.setCreateBy(ShiroUtils.getSysUser().getUsername());
         user.setPassword(JwtTokenUtil.encryptPassword(user.getUsername(),originPsword,user.getSalt()));
+
         boolean b=save(user);
         if(!b){
             throw new ApiException("创建专家信息失败");
@@ -322,22 +404,31 @@
     @Override
     @Transactional(rollbackFor = RuntimeException.class)
     public int deleteUserById(Long userId) {
-        SysUser user=getUserById(userId);
-        if(user==null){
-            throw new ApiException("用户不存在");
-        }
+        SysUser currentUser=ShiroUtils.getSysUser();
+        SysUser user=checkUserDataScope(userId);
         if(Objects.equals(ShiroUtils.getUserId(), userId)){
             throw new ApiException("不能删除自己账号");
         }
-        //机构用户,将机构信息设置成删除状态
-        if(user.getIdentity().equals(UserIdentityEnum.AGENCY.getCode())){
-            if(user.getAgencyId()==null){
-                throw new ApiException("获取机构id为空");
+        if(user.getIdentity().equals(UserIdentityEnum.AGENCY.getCode())||user.getIdentity().equals(UserIdentityEnum.MONITOR.getCode())){
+            if(!currentUser.getIdentity().equals(UserIdentityEnum.MONITOR.getCode())){
+                throw new ApiException("没有权限,只有监管用户才能操作");
             }
-            agencyMapper.deleteAgencyById(user.getAgencyId());
+            //机构用户,将机构信息设置成删除状态
+            if(user.getIdentity().equals(UserIdentityEnum.AGENCY.getCode())) {
+                if (user.getAgencyId() == null) {
+                    throw new ApiException("获取机构id为空");
+                }
+                SysAgency agency=new SysAgency().setId(user.getAgencyId());
+                agency.setUpdateBy(ShiroUtils.getSysUser().getUsername());
+                agency.setDelFlag(DeleteFlagEnum.DELETED.getCode());
+                agencyService.updateById(agency);
+            }
         }
         delCacheByUsername(user.getUsername());
-        return baseMapper.deleteUserById(userId);
+        user=new SysUser().setId(userId);
+        user.setUpdateBy(ShiroUtils.getSysUser().getUsername());
+        user.setDelFlag(DeleteFlagEnum.DELETED.getCode());
+        return baseMapper.updateById(user);
     }
 
     @Override
@@ -351,6 +442,7 @@
         }
         delCacheByUsername(user.getUsername());
         user.setPassword(null);
+        user.setUpdateBy(ShiroUtils.getSysUser().getUsername());
         boolean b=updateById(user);
         if(!b){
             throw new ApiException("更新监管用户信息失败");
@@ -380,8 +472,10 @@
         }
 
         delCacheByUsername(user.getUsername());
+        agency.setUpdateBy(ShiroUtils.getSysUser().getUsername());
         agencyService.updateById(agency);
         user.setPassword(null);
+        user.setUpdateBy(ShiroUtils.getSysUser().getUsername());
         boolean b=updateById(user);
         if(!b){
             throw new ApiException("更新用户失败");
@@ -391,6 +485,7 @@
 
     @Override
     public int editExpert(SysUser user) {
+        checkUserDataScope(user.getId());
         //校验用户信息
         if(!checkUsernameUnique(user)){
             throw new ApiException("用户名已存在");
@@ -398,13 +493,23 @@
         if(!checkPhoneUnique(user)){
             throw new ApiException("手机号已存在");
         }
-        user.setPassword(null);
-        boolean b=updateById(user);
-        if(!b){
-            throw new ApiException("更新专家信息失败");
+        String major=user.getMajor();
+        if(StringUtils.isNotBlank(major)){
+            List<Integer> majors=new ArrayList<>();
+            JSONObject jsonObject=JSONObject.parseObject(major);
+            jsonObject.forEach((key,value)-> {
+                majors.add(Integer.valueOf(key));
+            });
+            user.setMajor(StringUtils.join(",",majors));
+            user.setCertificateNo(major);
         }
-        //刪除旧数据
-        attachService.deleteAttachsByUserId(user.getId(),null);
+        user.setPassword(null);
+        user.setUpdateBy(ShiroUtils.getSysUser().getUsername());
+        int row=baseMapper.updateById(user);
+
+        List<SysAttach> existAttaches=attachService.getAttachsByUserId(user.getId(),null);
+        // 刪除旧数据
+        // attachService.deleteAttachsByUserId(user.getId(),null);
 
         List<SysAttach> socialAttach=user.getSocialAttach();
         List<SysAttach> medicalAttach=user.getMedicalAttach();
@@ -425,9 +530,20 @@
             attach.setUserId(user.getId());
             attaches.add(attach);
         }
-        attachService.saveBatch(attaches);
+        attachService.saveOrUpdateBatch(attaches);
+
+        List<Long> newIds=attaches.stream().map(SysAttach::getId).collect(Collectors.toList());
+        List<Long> delIds=new ArrayList<>();
+        for(SysAttach attach:existAttaches){
+            if(!newIds.contains(attach.getId())){
+                delIds.add(attach.getId());
+            }
+        }
+        if(!delIds.isEmpty()){
+            attachService.deleteAttachsByIds(delIds);
+        }
         delCacheByUsername(user.getUsername());
-        return 1;
+        return row;
     }
 
 
@@ -435,7 +551,6 @@
     public boolean resetUserPwd(SysUser user) {
         String originPsword=Base64.decodeStr(user.getPassword());
         validatorPassword(originPsword);
-        checkUserAllowed(user);
         SysUser oldUser=checkUserDataScope(user.getId());
         SysUser newUser=new SysUser().setId(user.getId()).setPassword(JwtTokenUtil.encryptPassword(oldUser.getUsername(),originPsword,oldUser.getSalt()));
         newUser.setUpdateBy(ShiroUtils.getSysUser().getUsername());
@@ -478,7 +593,15 @@
 
     @Override
     public void checkUserAllowed(SysUser user) {
-
+        SysUser currentUser=ShiroUtils.getSysUser();
+        if(!Objects.equals(currentUser.getIdentity(), UserIdentityEnum.MONITOR.getCode())){
+            if(Objects.equals(user.getIdentity(), UserIdentityEnum.MONITOR.getCode())){
+                throw new ApiException("无权操作监管用户");
+            }
+            if(!Objects.equals(currentUser.getAgencyId(), user.getAgencyId())){
+                throw new ApiException("无权操作其他机构用户");
+            }
+        }
     }
 
     @Override
@@ -486,67 +609,19 @@
         if(userId==null){
             throw new ApiException("用户id为空!");
         }
-        SysUser user = baseMapper.getUserById(userId);
+        SysUser user = getById(userId);
         if (ObjectUtil.isNull(user))
         {
             throw new ApiException("用户数据不存在!");
         }
+        checkUserAllowed(user);
         return user;
     }
 
-    @Override
-    public String importUser(List<SysUser> userList,Boolean isUpdateSupport) {
-        if(ObjectUtil.isEmpty(userList)||userList.size()==0){
-            throw new ApiException("导入用户数据不能为空");
-        }
-        int successNum=0;
-        int failureNum=0;
-        StringBuilder successMsg=new StringBuilder();
-        StringBuilder failureMsg=new StringBuilder();
-        String password=configService.getConfigByKey("sys.user.initPassword");
-        for(SysUser user:userList){
-            try {
-                SysUser u = baseMapper.getUserByUsername(user.getUsername());
-                if (ObjectUtil.isNull(u)) {
-                    BeanValidators.validateWithException(validator, user);
-                    user.setPassword(JwtTokenUtil.md5Encode(user.getUsername() + password));
-                    user.setCreateBy("");
-                    save(user);
-                    successNum++;
-                    successMsg.append("<br/>" + successNum + "、账号 " + user.getUsername() + " 导入成功");
-                } else if (isUpdateSupport) {
-                    BeanValidators.validateWithException(validator, user);
-                    checkUserAllowed(u);
-                    checkUserDataScope(u.getId());
-                    user.setId(u.getId());
-                    user.setUpdateBy("");
-                    updateById(user);
-                    successNum++;
-                    successMsg.append("<br/>" + successNum + "、账号 " + user.getUsername() + " 更新成功");
-                } else {
-                    failureNum++;
-                    failureMsg.append("<br/>" + failureNum + "、账号 " + user.getUsername() + " 已存在");
-                }
-            }catch (Exception e){
-                failureNum++;
-                String msg = "<br/>" + failureNum + "、账号 " + user.getUsername() + " 导入失败:";
-                failureMsg.append(msg + e.getMessage());
-                log.error(msg, e);
-            }
-        }
-        if (failureNum > 0){
-            failureMsg.insert(0, "很抱歉,导入失败!共 " + failureNum + " 条数据格式不正确,错误如下:");
-            throw new ApiException(failureMsg.toString());
-        }else{
-            successMsg.insert(0, "恭喜您,数据已全部导入成功!共 " + successNum + " 条,数据如下:");
-        }
 
-        return successMsg.toString();
-    }
 
     @Override
     public boolean changeUserStatus(SysUser user) {
-        checkUserAllowed(user);
         SysUser existUser=checkUserDataScope(user.getId());
         SysUser su=new SysUser().setId(user.getId()).setStatus(user.getStatus());
         su.setUpdateBy(ShiroUtils.getSysUser().getUsername());
@@ -556,7 +631,6 @@
 
     @Override
     public boolean changeApprove(SysUser user) {
-        checkUserAllowed(user);
         SysUser existUser=checkUserDataScope(user.getId());
         SysUser su=new SysUser().setId(user.getId()).setState(user.getState());
         su.setUpdateBy(ShiroUtils.getSysUser().getUsername());

--
Gitblit v1.9.2