From dbff53150cdc807faa56c0d1a947d24b69f372b9 Mon Sep 17 00:00:00 2001
From: jiangqs <jiangqs>
Date: 星期四, 31 八月 2023 18:43:20 +0800
Subject: [PATCH] bug

---
 ruoyi-modules/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/staff/SysStaffServiceImpl.java |  156 ++++++++++++++++++++++++++++++++++++++++++++++++----
 1 files changed, 144 insertions(+), 12 deletions(-)

diff --git a/ruoyi-modules/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/staff/SysStaffServiceImpl.java b/ruoyi-modules/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/staff/SysStaffServiceImpl.java
index 03acb69..4a82092 100644
--- a/ruoyi-modules/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/staff/SysStaffServiceImpl.java
+++ b/ruoyi-modules/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/staff/SysStaffServiceImpl.java
@@ -18,7 +18,9 @@
 import com.ruoyi.system.api.service.RemoteShopService;
 import com.ruoyi.system.domain.dto.MgtStaffEditDto;
 import com.ruoyi.system.domain.dto.MgtStaffPageDto;
+import com.ruoyi.system.domain.dto.MgtSysStaffImportDto;
 import com.ruoyi.system.domain.pojo.staff.SysStaff;
+import com.ruoyi.system.domain.vo.DeptSimpleVo;
 import com.ruoyi.system.domain.vo.MgtDeptStaffListVo;
 import com.ruoyi.system.domain.vo.MgtStaffPageVo;
 import com.ruoyi.system.mapper.staff.SysStaffMapper;
@@ -28,8 +30,12 @@
 import org.springframework.stereotype.Service;
 
 import javax.annotation.Resource;
+import java.util.Date;
 import java.util.List;
+import java.util.Map;
 import java.util.concurrent.TimeUnit;
+import java.util.function.Function;
+import java.util.stream.Collectors;
 
 /**
  * <p>
@@ -163,6 +169,7 @@
         sysStaff.setStaffPost(mgtStaffEditDto.getStaffPost());
         sysStaff.setStaffAvatar(mgtStaffEditDto.getStaffAvatar());
         sysStaff.setHeadFlag(mgtStaffEditDto.getHeadFlag());
+        sysStaff.setWxUserId(mgtStaffEditDto.getWxUserId());
         this.saveOrUpdate(sysStaff);
         MgtShopStaffEditDto mgtShopStaffEditDto = new MgtShopStaffEditDto();
         mgtShopStaffEditDto.setUserId(sysStaff.getUserId());
@@ -218,19 +225,7 @@
     }
 
 
-    /**
-     * @description  同步组织架构
-     * @author  jqs
-     * @date    2023/7/18 19:06
-     * @param
-     * @return  void
-     */
-    @Override
-    public void synchronizeOrganizationalStructure(){
-        String accessToken = getQYToken();
 
-
-    }
 
 
     /**
@@ -291,4 +286,141 @@
         }
         this.saveOrUpdate(sysStaff);
     }
+
+    /**
+     * @description  导入员工
+     * @author  jqs
+     * @date    2023/8/18 16:04
+     * @param
+     * @return  void
+     */
+    @Override
+    public String importSysStaff(List<MgtSysStaffImportDto> staffImportDtoList){
+        if (StringUtils.isNull(staffImportDtoList) || staffImportDtoList.size() == 0) {
+            throw new ServiceException("导入数据不能为空!");
+        }
+        int successNum = 0;
+        int failureNum = 0;
+        StringBuilder successMsg = new StringBuilder();
+        StringBuilder failureMsg = new StringBuilder();
+        SysStaff sysStaff;
+        Date nowTime = new Date();
+        String mobile;
+        String userName;
+        String department;
+        String departmentFirst;
+        String departmentSecond;
+        String departmentThird;
+        int lastIndex;
+        int firstIndex;
+        int secondIndex;
+        int thirdIndex;
+        DeptSimpleVo deptSimpleVo;
+        SysUser sysUser;
+        List<DeptSimpleVo> deptSimpleVoList = sysStaffMapper.listSimpleDept();
+        Map<String, DeptSimpleVo> deptMap = deptSimpleVoList.stream()
+                .collect(Collectors.toMap(DeptSimpleVo::getDeptName, Function.identity()));
+        for (MgtSysStaffImportDto entity : staffImportDtoList) {
+            try {
+                if(StringUtils.isNotBlank(entity.getMobile())){
+                    if(StringUtils.isNotBlank(entity.getUserStatus())&&entity.getUserStatus().equals("禁用")){
+                        continue;
+                    }
+                    department = entity.getDepartment();
+                    lastIndex = department.indexOf(";");
+                    department = (lastIndex != -1) ? department.substring(0, lastIndex) : department;
+                    firstIndex = department.lastIndexOf("/");
+                    secondIndex = department.lastIndexOf('/', firstIndex - 1);
+                    thirdIndex = department.lastIndexOf('/', secondIndex - 1);
+                    departmentFirst = department.substring(firstIndex + 1);
+                    deptSimpleVo = deptMap.get(departmentFirst);
+                    if(deptSimpleVo==null){
+                        departmentSecond = department.substring(secondIndex + 1, firstIndex);
+                        deptSimpleVo = deptMap.get(departmentSecond);
+                    }
+                    if(deptSimpleVo==null){
+                        departmentThird = department.substring(thirdIndex + 1, secondIndex);
+                        deptSimpleVo = deptMap.get(departmentThird);
+                    }
+                    if(deptSimpleVo!=null&&StringUtils.isNotBlank(entity.getMobile())){
+                        LambdaQueryWrapper<SysStaff> queryWrapper = new LambdaQueryWrapper();
+                        queryWrapper.eq(SysStaff::getDelFlag,0);
+                        queryWrapper.eq(SysStaff::getStaffMobile,entity.getMobile());
+                        SysStaff sysStaffSame = this.getOne(queryWrapper, false);
+                        if(sysStaffSame!=null){
+                            sysStaffSame.setStaffName(entity.getStaffName());
+                            sysStaffSame.setStaffPost(entity.getPost());
+                            sysStaffSame.setWxUserId(entity.getUserName());
+                            if(StringUtils.isNotBlank(entity.getEmail())){
+                                sysStaffSame.setStaffEmail(entity.getEmail());
+                            }
+                            this.saveOrUpdate(sysStaffSame);
+                            sysUser = sysUserService.selectUserById(sysStaffSame.getUserId());
+                            sysUser.setDeptId(deptSimpleVo.getDeptId());
+                            sysUser.setNickName(entity.getStaffName());
+                            if(entity.getGender().equals("男")){
+                                sysUser.setSex("0");
+                            }else if(entity.getGender().equals("女")){
+                                sysUser.setSex("1");
+                            }else{
+                                sysUser.setSex("2");
+                            }
+                            if(StringUtils.isNotBlank(entity.getEmail())){
+                                sysUser.setEmail(entity.getEmail());
+                            }
+                            sysUserService.updateOnlyUser(sysUser);
+                            successNum = successNum + 1;
+                        }else{
+                            MgtStaffEditDto mgtStaffEditDto = new MgtStaffEditDto();
+                            mgtStaffEditDto.setDeptId(deptSimpleVo.getDeptId());
+                            mgtStaffEditDto.setStaffName(entity.getStaffName());
+                            mgtStaffEditDto.setStaffMobile(entity.getMobile());
+                            mgtStaffEditDto.setStaffEmail(entity.getEmail());
+                            mgtStaffEditDto.setStaffPost(entity.getPost());
+                            mgtStaffEditDto.setStaffAvatar("https://hongruitang.oss-cn-beijing.aliyuncs.com/2023/8/26/362e964917304255aaa36a874063d198.jpg");
+                            mgtStaffEditDto.setHeadFlag("0");
+                            mgtStaffEditDto.setWxUserId(entity.getUserName());
+                            this.mgtStaffEdit(mgtStaffEditDto);
+                            successNum = successNum + 1;
+                        }
+                    }
+                }
+                /*tagName = entity.getTagName();
+                sysTagSame = null;
+                // 验证是否存在这个用户
+                queryWrapper = new LambdaQueryWrapper<>();
+                queryWrapper.eq(SysTag::getDelFlag, 0) // 查询条件:delFlag=0
+                        .eq(SysTag::getTagType, tagType) // 查询条件:tagType=mgtTagEditDto的tagType属性
+                        .eq(SysTag::getTagName, tagName); // 查询条件:tagName=mgtTagEditDto的tagName属性
+                // 执行查询,获取与查询条件匹配的SysTag对象
+                sysTagSame = this.getOne(queryWrapper);
+                if (sysTagSame == null) {
+                    sysTagNew = new SysTag();
+                    sysTagNew.setDelFlag(0);
+                    sysTagNew.setTagType(tagType);
+                    sysTagNew.setTagName(tagName);
+                    sysTagNew.setCreateTime(nowTime);
+                    sysTagNew.setSynFlag(0);
+                    this.save(sysTagNew);
+                    successNum++;
+                    successMsg.append("<br/>" + successNum + "、标签 " + sysTagNew.getTagName() + " 导入成功");
+                } else {
+                    failureNum++;
+                    failureMsg.append("<br/>" + failureNum + "、标签 " + sysTagSame.getTagName() + " 已存在");
+                }*/
+            } catch (Exception e) {
+                failureNum++;
+                String msg = "<br/>" + failureNum + "员工 " + entity.getStaffName() + " 导入失败:";
+                failureMsg.append(msg + e.getMessage());
+                log.error(msg, e);
+            }
+        }
+        if (failureNum > 0) {
+            failureMsg.insert(0, "很抱歉,导入失败!共 " + failureNum + " 条数据格式不正确,错误如下:");
+            throw new ServiceException(failureMsg.toString());
+        } else {
+            successMsg.insert(0, "恭喜您,数据已全部导入成功!共 " + successNum + " 条,数据如下:");
+        }
+        return successMsg.toString();
+    }
 }

--
Gitblit v1.7.1