From 5e7341ad54041a1c17a60fc4269eb71f44529476 Mon Sep 17 00:00:00 2001 From: k94314517 <8417338+k94314517@user.noreply.gitee.com> Date: 星期二, 05 三月 2024 14:30:22 +0800 Subject: [PATCH] 111 --- server/service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java | 63 +++++++++++++++++++++++++++++++ 1 files changed, 62 insertions(+), 1 deletions(-) diff --git a/server/service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java b/server/service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java index bdafd31..ffd6741 100644 --- a/server/service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java +++ b/server/service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java @@ -10,9 +10,11 @@ import com.doumee.core.utils.DateUtil; import com.doumee.core.utils.Utils; import com.doumee.dao.business.MemberMapper; +import com.doumee.dao.business.WorktypeMapper; import com.doumee.dao.business.dto.MemberImport; import com.doumee.dao.business.dto.MemberQueryDTO; import com.doumee.dao.business.dto.WorktypeImport; +import com.doumee.dao.business.join.DispatchUnitJoinMapper; import com.doumee.dao.business.join.MemberJoinMapper; import com.doumee.dao.business.model.*; import com.doumee.service.business.MemberService; @@ -45,6 +47,12 @@ @Autowired private MemberJoinMapper memberJoinMapper; + + @Autowired + private DispatchUnitJoinMapper dispatchUnitJoinMapper; + + @Autowired + private WorktypeMapper worktypeMapper; @Override public Integer create(Member member) { @@ -285,7 +293,7 @@ @Override - public List<MemberImport> importBatch(MultipartFile file){ + public List<MemberImport> importBatch(MultipartFile file,Integer solutionId){ LoginUserInfo loginUserInfo = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal(); if(!loginUserInfo.getType().equals(Constants.ONE)){ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"闈炰紒涓氫汉鍛樻棤娉曡繘琛岃鎿嶄綔"); @@ -316,7 +324,40 @@ if(idCardList.size() != set.size()){ throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"瀵逛笉璧凤紝褰曞叆鏁版嵁瀛樺湪韬唤璇佸彿鐩稿悓鏁版嵁锛�"); } + List<DispatchUnit> dispatchUnitList = new ArrayList<>(); + if(!Objects.isNull(solutionId)){ + dispatchUnitList = dispatchUnitJoinMapper.selectJoinList(DispatchUnit.class, + new MPJLambdaWrapper<DispatchUnit>() + .selectAll(DispatchUnit.class) + .select("(select b.id from du_solution b where b.isdeleted=0 and b.dispatch_unit_id=t.id and b.solution_id="+solutionId+" limit 1) as du_solution_id" ) + .eq(DispatchUnit::getIsdeleted,Constants.ZERO) + .eq(DispatchUnit::getStatus,Constants.ZERO) + .eq(DispatchUnit::getDataType,Constants.TWO) + .eq(loginUserInfo.getType().equals(Constants.ONE),DispatchUnit::getCompanyId,loginUserInfo.getCompanyId()) + .exists("select b.id from du_solution b where b.isdeleted=0 and b.dispatch_unit_id=t.id and b.status = 1 and b.solution_id="+solutionId ) + ); + if(CollectionUtils.isNotEmpty(dispatchUnitList)){ + for (DispatchUnit dispatchUnit:dispatchUnitList) { + List<Worktype> worktypeList = worktypeMapper.selectList(new QueryWrapper<Worktype>().lambda() + .eq(Worktype::getIsdeleted,Constants.ZERO) + .eq(Worktype::getDataType,Constants.TWO) + .eq(Worktype::getStatus,Constants.ZERO) + .apply("id in ( select dw.work_type_id from du_worktype dw where dw.status = 1" + + " and dw.du_solution_id = "+dispatchUnit.getDuSolutionId()+" )") + ); + dispatchUnit.setWorktypeList(worktypeList); + } + } + } + long index = Constants.TWO; for(MemberImport model : dataList){ + if(StringUtils.isBlank(model.getIdCard())||model.getIdCard().length()!=18){ + throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝绗�"+index+"琛屾暟鎹韩浠借瘉淇℃伅寮傚父锛�"); + } + if(StringUtils.isBlank(model.getName())){ + throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝绗�"+index+"琛屾暟鎹鍚嶄俊鎭紓甯革紒"); + } + index = index + Constants.ONE; if(CollectionUtils.isNotEmpty(list)){ Optional<Member> memberOptional= list.stream().filter(m->m.getIdcardNo().equals(model.getIdCard())).findFirst(); if(memberOptional.isPresent()){ @@ -329,6 +370,26 @@ }else{ model.setSex(Constants.getSexByIdCard(model.getIdCard())); } + if(StringUtils.isNotBlank(model.getDuName())&&CollectionUtils.isNotEmpty(dispatchUnitList)){ + Optional<DispatchUnit> dispatchUnitOptional= dispatchUnitList.stream().filter(m->m.getName().equals(model.getDuName())).findFirst(); + if(dispatchUnitOptional.isPresent()){ + DispatchUnit dispatchUnit = dispatchUnitOptional.get(); + model.setDuId(dispatchUnit.getId()); + if(StringUtils.isNotBlank(model.getWorkTypeName())&&CollectionUtils.isNotEmpty(dispatchUnit.getWorktypeList())){ + Optional<Worktype> worktypeOptional= dispatchUnit.getWorktypeList().stream().filter(m->m.getName().equals(model.getWorkTypeName())).findFirst(); + if(worktypeOptional.isPresent()){ + Worktype worktype = worktypeOptional.get(); + model.setWorktypeId(worktype.getId()); + } + } + } + } + if(Objects.isNull(model.getDuId())){ + model.setWorkTypeName(null); + model.setDuName(null); + }else if(Objects.isNull(model.getWorktypeId())){ + model.setWorkTypeName(null); + } } return dataList; } -- Gitblit v1.9.3