From e890eddcac0e51e67ce4e5ee8f69f58497c84af3 Mon Sep 17 00:00:00 2001
From: doum <doum>
Date: 星期四, 29 一月 2026 18:03:22 +0800
Subject: [PATCH] 提交忽略文件

---
 server/services/src/main/java/com/doumee/service/business/impl/ImportRecordServiceImpl.java |  424 ++++++++++++++++++++++++++++++++++++++++++++++++----
 1 files changed, 385 insertions(+), 39 deletions(-)

diff --git a/server/services/src/main/java/com/doumee/service/business/impl/ImportRecordServiceImpl.java b/server/services/src/main/java/com/doumee/service/business/impl/ImportRecordServiceImpl.java
index d3ca1de..1503157 100644
--- a/server/services/src/main/java/com/doumee/service/business/impl/ImportRecordServiceImpl.java
+++ b/server/services/src/main/java/com/doumee/service/business/impl/ImportRecordServiceImpl.java
@@ -1,20 +1,54 @@
 package com.doumee.service.business.impl;
 
+import com.doumee.biz.system.SystemDictDataBiz;
+import com.doumee.core.annotation.excel.ExcelImporter;
+import com.doumee.core.constants.Constants;
+import com.doumee.core.constants.ResponseStatus;
+import com.doumee.core.exception.BusinessException;
+import com.doumee.core.model.LoginUserInfo;
 import com.doumee.core.model.PageData;
 import com.doumee.core.model.PageWrap;
+import com.doumee.core.utils.DateUtil;
+import com.doumee.core.utils.tyyun.TyyZosUtil;
+import com.doumee.dao.business.CasesMapper;
+import com.doumee.dao.business.CategoryMapper;
+import com.doumee.dao.business.MemberMapper;
+import com.doumee.dao.business.dto.CasesImport;
+import com.doumee.dao.business.dto.MemberImport;
+import com.doumee.dao.business.model.Cases;
+import com.doumee.dao.business.model.Category;
 import com.doumee.dao.business.model.ImportRecord;
 import com.doumee.core.utils.Utils;
 import com.doumee.dao.business.ImportRecordMapper;
+import com.doumee.dao.business.model.Member;
+import com.doumee.dao.system.model.SystemUser;
 import com.doumee.service.business.ImportRecordService;
 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.extension.plugins.pagination.Page;
+import com.github.yulichang.wrapper.MPJLambdaWrapper;
+import com.sun.xml.internal.messaging.saaj.util.ByteInputStream;
+import lombok.extern.slf4j.Slf4j;
+import org.apache.commons.lang3.StringUtils;
+import org.apache.poi.ss.usermodel.CellType;
+import org.apache.poi.xssf.usermodel.XSSFPictureData;
+import org.apache.shiro.SecurityUtils;
+import org.checkerframework.checker.units.qual.A;
+import org.checkerframework.checker.units.qual.C;
 import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.data.redis.core.RedisTemplate;
+import org.springframework.scheduling.annotation.Async;
 import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
 import org.springframework.util.CollectionUtils;
+import org.springframework.web.multipart.MultipartFile;
 
-import java.util.List;
+import javax.annotation.Resource;
+import java.io.ByteArrayInputStream;
+import java.math.BigDecimal;
+import java.util.*;
+import java.util.concurrent.TimeUnit;
 
 /**
  * 鍒嗙被淇℃伅琛⊿ervice瀹炵幇
@@ -22,13 +56,34 @@
  * @date 2026-01-27 16:02:37
  */
 @Service
+@Slf4j
 public class ImportRecordServiceImpl implements ImportRecordService {
 
     @Autowired
     private ImportRecordMapper importRecordMapper;
+    @Autowired
+    private CategoryMapper categoryMapper;
+    @Autowired
+    private MemberMapper memberMapper;
+    @Autowired
+    private CasesMapper casesMapper;
+    @Resource
+    private RedisTemplate<String, Object> redisTemplate;
+    @Resource
+    private SystemDictDataBiz systemDictDataBiz;
 
     @Override
     public Integer create(ImportRecord importRecord) {
+        if(StringUtils.isBlank(importRecord.getImgurl())){
+            throw new BusinessException(ResponseStatus.BAD_REQUEST);
+        }
+        LoginUserInfo loginUserInfo = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
+        importRecord.setDeleted(Constants.ZERO);
+        importRecord.setStatus(Constants.ZERO);
+        importRecord.setCreateTime(new Date());
+        importRecord.setCreateUser(loginUserInfo.getId());
+        importRecord.setUpdateTime(new Date());
+        importRecord.setUpdateUser(loginUserInfo.getId());
         importRecordMapper.insert(importRecord);
         return importRecord.getId();
     }
@@ -87,45 +142,29 @@
     @Override
     public PageData<ImportRecord> findPage(PageWrap<ImportRecord> pageWrap) {
         IPage<ImportRecord> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity());
-        QueryWrapper<ImportRecord> queryWrapper = new QueryWrapper<>();
+        MPJLambdaWrapper<ImportRecord> queryWrapper = new MPJLambdaWrapper<>();
         Utils.MP.blankToNull(pageWrap.getModel());
-               queryWrapper.lambda().eq(pageWrap.getModel().getId() != null,ImportRecord::getId, pageWrap.getModel().getId());
-               queryWrapper.lambda().eq(pageWrap.getModel().getDeleted() != null,ImportRecord::getDeleted, pageWrap.getModel().getDeleted());
-               queryWrapper.lambda().eq(pageWrap.getModel().getCreateUser() != null,ImportRecord::getCreateUser, pageWrap.getModel().getCreateUser());
-             if (pageWrap.getModel().getId() != null) {
-                  queryWrapper.lambda().ge(ImportRecord::getCreateTime, Utils.Date.getStart(pageWrap.getModel().getCreateTime()));
-                  queryWrapper.lambda().le(ImportRecord::getCreateTime, Utils.Date.getEnd(pageWrap.getModel().getCreateTime()));
-             }
-               queryWrapper.lambda().eq(pageWrap.getModel().getUpdateUser() != null,ImportRecord::getUpdateUser, pageWrap.getModel().getUpdateUser());
-             if (pageWrap.getModel().getId() != null) {
-                  queryWrapper.lambda().ge(ImportRecord::getUpdateTime, Utils.Date.getStart(pageWrap.getModel().getUpdateTime()));
-                  queryWrapper.lambda().le(ImportRecord::getUpdateTime, Utils.Date.getEnd(pageWrap.getModel().getUpdateTime()));
-             }
-               queryWrapper.lambda().eq(pageWrap.getModel().getRemark() != null,ImportRecord::getRemark, pageWrap.getModel().getRemark());
-               queryWrapper.lambda().eq(pageWrap.getModel().getStatus() != null,ImportRecord::getStatus, pageWrap.getModel().getStatus());
-               queryWrapper.lambda().eq(pageWrap.getModel().getTitle() != null,ImportRecord::getTitle, pageWrap.getModel().getTitle());
-               queryWrapper.lambda().eq(pageWrap.getModel().getTotalNum() != null,ImportRecord::getTotalNum, pageWrap.getModel().getTotalNum());
-               queryWrapper.lambda().eq(pageWrap.getModel().getDetail() != null,ImportRecord::getDetail, pageWrap.getModel().getDetail());
-               queryWrapper.lambda().eq(pageWrap.getModel().getImgurl() != null,ImportRecord::getImgurl, pageWrap.getModel().getImgurl());
-             if (pageWrap.getModel().getId() != null) {
-                  queryWrapper.lambda().ge(ImportRecord::getStartDate, Utils.Date.getStart(pageWrap.getModel().getStartDate()));
-                  queryWrapper.lambda().le(ImportRecord::getStartDate, Utils.Date.getEnd(pageWrap.getModel().getStartDate()));
-             }
-             if (pageWrap.getModel().getId() != null) {
-                  queryWrapper.lambda().ge(ImportRecord::getEndDate, Utils.Date.getStart(pageWrap.getModel().getEndDate()));
-                  queryWrapper.lambda().le(ImportRecord::getEndDate, Utils.Date.getEnd(pageWrap.getModel().getEndDate()));
-             }
-               queryWrapper.lambda().eq(pageWrap.getModel().getSortnum() != null,ImportRecord::getSortnum, pageWrap.getModel().getSortnum());
-               queryWrapper.lambda().eq(pageWrap.getModel().getType() != null,ImportRecord::getType, pageWrap.getModel().getType());
-               queryWrapper.lambda().eq(pageWrap.getModel().getDoneNum() != null,ImportRecord::getDoneNum, pageWrap.getModel().getDoneNum());
-               queryWrapper.lambda().eq(pageWrap.getModel().getErrorNum() != null,ImportRecord::getErrorNum, pageWrap.getModel().getErrorNum());
-        for(PageWrap.SortData sortData: pageWrap.getSorts()) {
-            if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) {
-                queryWrapper.orderByDesc(sortData.getProperty());
-            } else {
-                queryWrapper.orderByAsc(sortData.getProperty());
-            }
-        }
+        queryWrapper.selectAll(ImportRecord.class )
+        .selectAs(SystemUser::getRealname,ImportRecord::getUpdateUserName)
+                .leftJoin(SystemUser.class,SystemUser::getId,ImportRecord::getUpdateUser);
+       queryWrapper.eq(pageWrap.getModel().getId() != null,ImportRecord::getId, pageWrap.getModel().getId());
+       queryWrapper.eq(pageWrap.getModel().getDeleted() != null,ImportRecord::getDeleted, pageWrap.getModel().getDeleted());
+       queryWrapper.eq(pageWrap.getModel().getCreateUser() != null,ImportRecord::getCreateUser, pageWrap.getModel().getCreateUser());
+       queryWrapper.eq(pageWrap.getModel().getUpdateUser() != null,ImportRecord::getUpdateUser, pageWrap.getModel().getUpdateUser());
+       queryWrapper.eq(pageWrap.getModel().getRemark() != null,ImportRecord::getRemark, pageWrap.getModel().getRemark());
+       queryWrapper.eq(pageWrap.getModel().getStatus() != null,ImportRecord::getStatus, pageWrap.getModel().getStatus());
+       queryWrapper.eq(pageWrap.getModel().getTitle() != null,ImportRecord::getTitle, pageWrap.getModel().getTitle());
+       queryWrapper.eq(pageWrap.getModel().getTotalNum() != null,ImportRecord::getTotalNum, pageWrap.getModel().getTotalNum());
+       queryWrapper.eq(pageWrap.getModel().getDetail() != null,ImportRecord::getDetail, pageWrap.getModel().getDetail());
+       queryWrapper.eq(pageWrap.getModel().getImgurl() != null,ImportRecord::getImgurl, pageWrap.getModel().getImgurl());
+       queryWrapper.eq(pageWrap.getModel().getSortnum() != null,ImportRecord::getSortnum, pageWrap.getModel().getSortnum());
+       queryWrapper.eq(pageWrap.getModel().getType() != null,ImportRecord::getType, pageWrap.getModel().getType());
+       queryWrapper.eq(pageWrap.getModel().getDoneNum() != null,ImportRecord::getDoneNum, pageWrap.getModel().getDoneNum());
+       queryWrapper.eq(pageWrap.getModel().getErrorNum() != null,ImportRecord::getErrorNum, pageWrap.getModel().getErrorNum());
+       queryWrapper.like(StringUtils.isNotBlank(pageWrap.getModel().getUpdateUserName()),SystemUser::getRealname, pageWrap.getModel().getUpdateUserName());
+       queryWrapper.ge(pageWrap.getModel().getEndtime() != null,ImportRecord::getCreateTime, pageWrap.getModel().getEndtime());
+       queryWrapper.ne(pageWrap.getModel().getStarttime() != null,ImportRecord::getCreateTime, pageWrap.getModel().getStarttime());
+       queryWrapper.orderByDesc(ImportRecord::getId);
         return PageData.from(importRecordMapper.selectPage(page, queryWrapper));
     }
 
@@ -134,4 +173,311 @@
         QueryWrapper<ImportRecord> wrapper = new QueryWrapper<>(importRecord);
         return importRecordMapper.selectCount(wrapper);
     }
+    @Override
+    public ImportRecord importBatch(MultipartFile file,int type ){
+        Boolean importing = (Boolean) redisTemplate.opsForValue().get(Constants.RedisKeys.IMPORTING_RECORD);
+        if(importing!=null && importing){
+            throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝宸插瓨鍦ㄥ鍏ヤ换鍔℃鍦ㄦ墽琛屼腑锛岃绋嶅悗鍐嶈瘯锛�");
+        }
+        redisTemplate.opsForValue().set(Constants.RedisKeys.IMPORTING_RECORD,true,30, TimeUnit.MINUTES);
+        try {
+            List<Category> categoryList = null;
+            if(type == 0){
+              categoryList = categoryMapper.selectList(new QueryWrapper<Category>().lambda().eq(Category::getDeleted,Constants.ZERO));
+                if(categoryList == null || categoryList.size()==0){
+                    throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀵逛笉璧凤紝 璇诲彇鑰佸笀鍩烘暟鏁版嵁閰嶇疆鍑洪敊锛岃鍏堥厤缃熀纭�鏁版嵁淇℃伅锛�");
+                }
+            }
+            ImportRecord model = new ImportRecord();
+            LoginUserInfo loginUserInfo = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
+            model.setDeleted(Constants.ZERO);
+            model.setStatus(Constants.ONE);//寮傛澶勭悊涓�
+            model.setCreateTime(new Date());
+            model.setCreateUser(loginUserInfo.getId());
+            model.setUpdateTime(model.getCreateTime());
+            model.setUpdateUser(loginUserInfo.getId());
+            model.setType(type);
+            model.setTitle((type==1?"妗堜緥淇℃伅鎵归噺瀵煎叆":"鑰佸笀淇℃伅鎵归噺瀵煎叆,")+"鏂囦欢锛�"+file.getOriginalFilename());
+            model.setTotalNum(0);
+            ExcelImporter ie= new ExcelImporter(file,0,0, CellType.STRING); // 纭繚鍗曞厓鏍肩被鍨嬩负瀛楃涓�);
+            Map<String, XSSFPictureData> pics = ie.getExcelPictures();
+            if(type == 1) {
+              List<CasesImport> importList =  (ie.getDataList(CasesImport.class,null));
+              if(importList==null || importList.size()==0){
+                  throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"瀵煎叆鏂囦欢妗堜緥淇℃伅鍐呭涓虹┖锛�");
+              }
+              model.setTotalNum(model.getCaseList().size());
+            }else{
+               List<MemberImport> importList = (ie.getDataList(MemberImport.class,null));
+               model.setMemberList(isvalidImpartMemberParam(loginUserInfo,categoryList,pics,importList));
+               model.setTotalNum(model.getMemberList().size());
+            }
+            importRecordMapper.insert(model);
+            return model;
+        }catch (BusinessException e){
+            redisTemplate.delete(Constants.RedisKeys.IMPORTING_RECORD);
+            throw  e;
+        }catch (Exception e){
+            redisTemplate.delete(Constants.RedisKeys.IMPORTING_RECORD);
+            throw  new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"鏂囦欢淇℃伅璇诲彇澶辫触锛岃妫�鏌ユ枃浠跺唴瀹瑰悗閲嶈瘯锛�");
+        }finally {
+//            redisTemplate.delete(Constants.RedisKeys.IMPORTING_RECORD);
+        }
+    }
+    private  List<Member> isvalidImpartMemberParam(LoginUserInfo user, List<Category> categoryList ,Map<String, XSSFPictureData> pics, List<MemberImport> memberList) {
+        if(memberList ==null || memberList.size()==0){
+            throw  new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝鏈鍙栧埌鏈夋晥鏁版嵁");
+        }
+        if(pics ==null || pics.size()==0){
+            throw  new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝鏈鍙栧埌浠讳綍鑱屼笟鐓у浘鐗囨暟鎹�");
+        }
+        List<Member> insertMember = new ArrayList<>();
+        List<Member> allList = memberMapper.selectList(new QueryWrapper<Member>().lambda()
+                .eq(Member::getDeleted,Constants.ZERO));
+        allList=allList==null?new ArrayList<>():allList;
+        if(categoryList == null || categoryList.size()==0){
+            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀵逛笉璧凤紝 璇诲彇鑰佸笀鍩烘暟鏁版嵁閰嶇疆鍑洪敊锛岃鍏堥厤缃熀纭�鏁版嵁淇℃伅锛�");
+        }
+        Date date = new Date();
+        int index = 1;
+         for(MemberImport param :memberList){
+             index ++;
+             if(StringUtils.isBlank(param.getImgurl())
+             ||StringUtils.isBlank(param.getFee())
+             ||StringUtils.isBlank(param.getName())
+             ||StringUtils.isBlank(param.getInfo())
+             ||StringUtils.isBlank(param.getJobYear())
+             ||StringUtils.isBlank(param.getPosition())
+             ||StringUtils.isBlank(param.getFieldNames())
+             ||StringUtils.isBlank(param.getSex())
+             ||StringUtils.isBlank(param.getCode())
+             ||StringUtils.isBlank(param.getZqNames())
+             ||StringUtils.isBlank(param.getLevelName())
+             ||StringUtils.isBlank(param.getServeNum())
+             ||StringUtils.isBlank(param.getTypeNames())){
+                 continue;
+             }
+             Member member = new Member();
+             if(StringUtils.isBlank(param.getCode())){
+                 throw  new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝绗�"+index+"琛屾暟鎹紝 宸ュ彿淇℃伅涓嶈兘涓虹┖");
+             }
+             for(Member m : allList){
+                 if(StringUtils.equals(param.getCode(),m.getCode())){
+                     throw  new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝绗�"+index+"琛屾暟鎹紝 宸ュ彿銆�"+param.getCode()+"銆戜俊鎭凡瀛樺湪锛岃纭涓嶈閲嶅褰曞叆");
+                 }
+             }
+             for(Member m : insertMember){
+                 if(StringUtils.equals(param.getCode(),m.getCode())){
+                     throw  new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝绗�"+index+"琛屾暟鎹紝 宸ュ彿銆�"+param.getCode()+"銆戝湪鏂囨。涓噸澶嶅嚭鐜�");
+                 }
+             }
+             if(StringUtils.isBlank(param.getName())){
+                 throw  new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝绗�"+index+"琛屾暟鎹紝 濮撳悕淇℃伅涓嶈兘涓虹┖");
+             }
+             if(StringUtils.isBlank(param.getLevelName())){
+                 throw  new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝绗�"+index+"琛屾暟鎹紝 绛夌骇淇℃伅涓嶈兘涓虹┖");
+             }
+             if(StringUtils.isBlank(param.getJobYear())){
+                 throw  new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝绗�"+index+"琛屾暟鎹紝 浠庝笟骞翠唤淇℃伅涓嶈兘涓虹┖");
+             }
+             Integer year ;
+             try {
+                 year = Integer.parseInt(param.getJobYear());
+             }catch (Exception e){
+                 throw  new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝绗�"+index+"琛屾暟鎹紝 浠庝笟骞翠唤淇℃伅涓嶆纭�");
+             }
+             if(StringUtils.isBlank(param.getZqNames())){
+                 throw  new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝绗�"+index+"琛屾暟鎹紝 鏈嶅姟鎴樺尯淇℃伅涓嶈兘涓虹┖");
+             }
+             if(StringUtils.isBlank(param.getTypeNames())){
+                 throw  new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝绗�"+index+"琛屾暟鎹紝 鍟嗕笟鍖栫被鍨嬩俊鎭笉鑳戒负绌�");
+             }
+             if(StringUtils.isBlank(param.getFee())){
+                 throw  new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝绗�"+index+"琛屾暟鎹紝 璐圭敤鏍囧噯淇℃伅涓嶈兘涓虹┖");
+             }
+             if(pics!=null && StringUtils.isNotBlank(param.getImgurl())){
+                log.info("===================="+param.getImgurl());
+                int start = param.getImgurl().indexOf("(\"")+2;
+                int end = param.getImgurl().indexOf("\",");
+                if(start>=0&& end>=1 && end>start){
+                    String picId = param.getImgurl().substring(start,end);
+                    log.info("====================PICID:"+param.getImgurl());
+                    XSSFPictureData data = pics.get(picId);
+                    if(data!= null && data.getData() != null){
+                        member.setImgurlData(data.getData());
+                    }
+                }
+            }
+             if(member.getImgurlData() ==null || member.getImgurlData().length==0){
+                 throw  new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝绗�"+index+"琛屻��"+param.getName()+"銆戞暟鎹紝 鏈鍙栧埌浠讳綍鑱屼笟鐓у浘鐗囨暟鎹�");
+             }
+             //绫诲瀷:0=鎴樺尯;1=鍟嗕笟鍖�;2=鎿呴暱棰嗗煙;3=璁插笀绛夌骇;"
+             List<Category> list0 =  isValidCategoryParam(param.getZqNames(),Constants.ZERO,categoryList,index );//鎴樺尯
+             List<Category> list1 =  isValidCategoryParam(param.getTypeNames(),Constants.ONE,categoryList,index);//鍟嗕笟鍖�
+             List<Category> list2 =  isValidCategoryParam(param.getFieldNames(),Constants.TWO,categoryList,index);//鎿呴暱棰嗗煙
+             Category levelCate =  getCategoryModelByName(param.getLevelName(),Constants.THREE,categoryList);//璁插笀绛夌骇
+             if(levelCate == null){
+                 throw  new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝绗�"+index+"琛屾暟鎹紝 绛夌骇淇℃伅銆�"+param.getLevelName()+"銆戝皻鏈厤缃�");
+             }
+             member.setCreateTime(date);
+             member.setUpdateTime(date);
+             member.setCreateUser(user.getId());
+             member.setUpdateUser(user.getId());
+             member.setAddType(Constants.ONE);
+             member.setDeleted(Constants.ZERO);
+             member.setStatus(Constants.ZERO);
+             member.setName(param.getName());
+             member.setContent(param.getInfo());
+             member.setJobYear(year);
+             member.setCode(param.getCode());
+             member.setPositon(param.getPosition());
+             try {
+                 member.setServeNum(Integer.parseInt(param.getServeNum()));
+             }catch (Exception e){
+             }
+             try {
+                 member.setFee(new BigDecimal(param.getFee()));
+             }catch (Exception e){
+             }
+             member.setSex(StringUtils.equals(param.getSex(),"鐢�")?Constants.ZERO:(StringUtils.equals(param.getSex(),"濂�")?Constants.ZERO:null));
+             member.setZhanquIds(getIdStrListByList(list0));
+             member.setBustypeIds(getIdStrListByList(list1));
+             member.setFieldIds(getIdStrListByList(list2));
+             member.setLevelId(levelCate.getId());
+             insertMember.add(member);
+         }
+        if(insertMember ==null || insertMember.size()==0){
+            throw  new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝鏈鍙栧埌鏈夋晥鏁版嵁");
+        }
+         return insertMember;
+
+    }
+
+    private String getIdStrListByList(List<Category> categoryList) {
+         String[] idList = new String[categoryList.size()];
+        for (int i = 0; i <categoryList.size(); i++) {
+            idList[i]="["+categoryList.get(i).getId()+"]";
+        }
+        return String.join(",",idList);
+    }
+
+    private List<Category> isValidCategoryParam(String zqNames, int type, List<Category> categoryList,int index) {
+        if(StringUtils.isBlank(zqNames)){
+            return null;
+        }
+        //鑾峰绫伙綔甯傚満绫伙綔鍩硅绫�
+        List<Category> list = new ArrayList<>();
+        String names[] = zqNames.split("/");
+        String title = type==0?"鏈嶅姟鎴樺尯":( type==1?"鍟嗕笟鍖栫被鍨�":"鎿呴暱棰嗗煙");
+        for(String str : names){
+            if(StringUtils.isBlank(str)){
+                continue;
+            }
+            Category cate = getCategoryModelByName(str,type,categoryList);
+            if(cate == null){
+                throw  new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝绗�"+index+"琛屾暟鎹紝"+title+"涓��"+str+"銆戝皻鏈厤缃�");
+            }
+            list.add(cate);
+        }
+        if(list == null || list.size() ==0){
+            throw  new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝绗�"+index+"琛屾暟鎹紝"+title+"鏈煡璇㈠埌鏈夋晥閰嶇疆");
+        }
+        return list;
+    }
+    private Category getCategoryModelByName(String levelName, int type, List<Category> categoryList) {
+        for(Category c : categoryList){
+            if(Constants.equalsInteger(c.getType(),type)
+                    && StringUtils.equals(levelName.trim(),StringUtils.defaultString(c.getName(),"").trim())){
+                return c;
+            }
+        }
+        return null;
+    }
+
+    /**
+     * 寮傛鎵ц鏂囦欢浠诲姟
+     * @param importRecord
+     */
+    @Override
+    @Async
+    public void dealImporTask(ImportRecord importRecord){
+        int success = 0;
+        if(Constants.equalsInteger(importRecord.getType(),0)){
+           dealUserImportBiz(importRecord);
+        }else{
+            dealCaseImportBiz(importRecord);
+        }
+        importRecord.setStatus(Constants.TWO);
+        importRecord.setUpdateTime(new Date());
+        importRecordMapper.updateById(importRecord);
+
+    }
+
+    /**
+     * 澶勭悊妗堜緥瀵煎叆浠诲姟
+     * @param importRecord
+     */
+
+    private int dealCaseImportBiz(ImportRecord importRecord) {
+        int success=0;
+        String msg ="";
+        try {
+            for(Cases param:importRecord.getCaseList()){
+
+            }
+        }catch (Exception e){
+
+        }
+        importRecord.setDoneNum(success);
+        importRecord.setErrorNum(importRecord.getTotalNum() - success);
+        return success;
+    }
+
+    /**
+     * 澶勭悊浜哄憳瀵煎叆璁板綍
+     * @param importRecord
+     */
+    private int dealUserImportBiz(ImportRecord importRecord) {
+        int success=0;
+        String msg = "";
+        String nowDate =DateUtil.getNowShortDate();
+        try {
+            String bucket =systemDictDataBiz.queryByCode(Constants.OBJCET_STORAGE,Constants.BUCKETNAME).getCode();
+            String folder =systemDictDataBiz.queryByCode(Constants.OBJCET_STORAGE,Constants.MEMBER_FILES).getCode();
+            TyyZosUtil obs = new TyyZosUtil(systemDictDataBiz.queryByCode(Constants.OBJCET_STORAGE,Constants.ENDPOINT).getCode(),
+                    systemDictDataBiz.queryByCode(Constants.OBJCET_STORAGE,Constants.ACCESS_ID).getCode(),
+                    systemDictDataBiz.queryByCode(Constants.OBJCET_STORAGE,Constants.ACCESS_KEY).getCode());
+            for(Member param: importRecord.getMemberList()){
+                param.setImportId(importRecord.getId());
+                param.setAddType(Constants.ONE);
+                success +=  dealMemberInsert(obs,param,folder,nowDate,bucket);
+            }
+            obs.shutDown();
+        }catch (Exception e){
+            log.error("澶勭悊浜哄憳淇℃伅鍙戠敓寮傚父{}",e.getMessage());
+        }
+        importRecord.setDoneNum(success);
+        importRecord.setErrorNum(importRecord.getTotalNum() - success);
+        importRecord.setDetail(msg);
+        redisTemplate.delete(Constants.RedisKeys.IMPORTING_RECORD);
+        return success;
+    }
+
+
+    private int dealMemberInsert( TyyZosUtil obs,Member param,String folder,String nowDate,String bucketName) {
+        int success =0;
+        try {
+            String fileName = UUID.randomUUID() + ".png";
+            String tempFileName = nowDate + "/" + fileName;
+            String key = folder + tempFileName;// 鏂囦欢鍚�
+           if (obs.uploadInputstreamObjectNoShutdown(new ByteArrayInputStream(param.getImgurlData() ) ,bucketName,  key)) {
+               param.setImgurl(tempFileName);//璇佷欢鐓у湴鍧�
+               log.error("澶勭悊浜哄憳淇℃伅璇佷欢鐓ф垚鍔�=================={}",key );
+               success= memberMapper.insert(param);
+           }
+        }catch (Exception e){
+            log.error("澶勭悊浜哄憳淇℃伅{}==鍙戠敓寮傚父{}",param.getName(),e.getMessage());
+        }
+        return success;
+    }
 }

--
Gitblit v1.9.3