From 22271e641e4505ba906c3770905b7e84e3ad8d85 Mon Sep 17 00:00:00 2001 From: MrShi <1878285526@qq.com> Date: 星期二, 02 四月 2024 17:05:57 +0800 Subject: [PATCH] mrshi --- server/service/src/main/java/com/doumee/service/business/impl/SolutionsServiceImpl.java | 118 ++++++++++++++++++++++++++++++++++++++++++++++++++--------- 1 files changed, 100 insertions(+), 18 deletions(-) diff --git a/server/service/src/main/java/com/doumee/service/business/impl/SolutionsServiceImpl.java b/server/service/src/main/java/com/doumee/service/business/impl/SolutionsServiceImpl.java index faa93b4..3f3a8e3 100644 --- a/server/service/src/main/java/com/doumee/service/business/impl/SolutionsServiceImpl.java +++ b/server/service/src/main/java/com/doumee/service/business/impl/SolutionsServiceImpl.java @@ -7,10 +7,7 @@ import com.doumee.core.model.PageWrap; import com.doumee.core.utils.Constants; import com.doumee.core.utils.Utils; -import com.doumee.dao.business.InsuranceMapper; -import com.doumee.dao.business.SolutionWorktypeMapper; -import com.doumee.dao.business.SolutionsMapper; -import com.doumee.dao.business.WorktypeMapper; +import com.doumee.dao.business.*; import com.doumee.dao.business.join.SolutionWorktypeJoinMapper; import com.doumee.dao.business.join.SolutionsJoinMapper; import com.doumee.dao.business.model.*; @@ -26,6 +23,7 @@ import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; +import org.springframework.transaction.annotation.Transactional; import org.springframework.util.CollectionUtils; import java.math.BigDecimal; @@ -52,11 +50,25 @@ private SolutionWorktypeJoinMapper solutionWorktypeJoinMapper; @Autowired private InsuranceMapper insuranceMapper; + @Autowired + private CompanySolutionMapper companySolutionMapper; + @Autowired + private DuSolutionMapper duSolutionMapper; @Override + @Transactional(rollbackFor = {BusinessException.class,Exception.class}) public Integer create(Solutions solutions) { LoginUserInfo user= (LoginUserInfo)SecurityUtils.getSubject().getPrincipal(); initCreateParam(solutions);//宸ョ鏁版嵁鏈夋晥鎬ф楠岋紝鍘婚櫎绌虹櫧琛屾暟鎹� + + + if(solutionsMapper.selectCount(new QueryWrapper<Solutions>().lambda() + .eq(Solutions::getName,solutions.getName()) + .eq(Solutions::getIsdeleted,Constants.ZERO) + .eq(Solutions::getDataType,Constants.ZERO) + )>Constants.ZERO){ + throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"淇濋櫓鏂规鍚嶇О宸插瓨鍦�"); + } solutions.setIsdeleted(Constants.ZERO); solutions.setCreator(user.getId()); @@ -85,7 +97,7 @@ throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"瀵逛笉璧凤紝璇ヤ繚闄╁叕鍙镐俊鎭笉瀛樺湪锛岃灏濊瘯鍒锋柊椤甸潰閲嶈瘯~" ); } if( !Constants.equalsInteger(model.getStatus(),Constants.ZERO)){ - throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"瀵逛笉璧凤紝璇ヤ繚闄╁叕鍙稿凡琚紝璇峰皾璇曞埛鏂伴〉闈㈤噸璇晘" ); + throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"瀵逛笉璧凤紝璇ヤ繚闄╁叕鍙稿凡琚鐢紝璇峰皾璇曞埛鏂伴〉闈㈤噸璇晘" ); } List<Worktype> worktypeList = worktypeMapper.selectList(new QueryWrapper<Worktype>().lambda() .eq(Worktype::getInsuranceId,solutions.getInsuranceId()) @@ -154,6 +166,7 @@ } @Override + @Transactional(rollbackFor = {BusinessException.class,Exception.class}) public void updateById(Solutions solutions) { LoginUserInfo user= (LoginUserInfo)SecurityUtils.getSubject().getPrincipal(); Solutions model = findById(solutions.getId()); @@ -163,11 +176,30 @@ } //鏁版嵁鏈夋晥鎬ф牎楠� initCreateParam(solutions); - + if(solutionsMapper.selectCount(new QueryWrapper<Solutions>().lambda() + .eq(Solutions::getName,solutions.getName()) + .eq(Solutions::getIsdeleted,Constants.ZERO) + .eq(Solutions::getDataType,Constants.ZERO) + .ne(Solutions::getId,solutions.getId()) + )>Constants.ZERO){ + throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"淇濋櫓鏂规鍚嶇О宸插瓨鍦�"); + } solutions.setEditor(user.getId()); solutions.setVersion(UUID.randomUUID().toString()); solutions.setEditDate(new Date()); solutionsMapper.updateById(solutions); + + Solutions oldVersion = solutionsMapper.selectOne(new QueryWrapper<Solutions>() + .lambda() + .eq(Solutions::getBaseId,solutions.getId()) + .eq(Solutions::getDataType,Constants.TWO) + .last("limit 1") + ); + + + if(Objects.isNull(oldVersion)){ + throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"鏈煡璇㈠埌鍘嗗彶鐗堟湰鏁版嵁"); + } //濡傛灉淇敼锛屽垯浜х敓涓�涓柊鐨勫巻鍙茬増鏈� ~ Solutions newModel = new Solutions(); @@ -184,15 +216,35 @@ .lambda() .eq(SolutionWorktype::getSolutionId,solutions.getId()) ); + + solutionsMapper.update(null,new UpdateWrapper<Solutions>() .lambda() .ne(Solutions::getId,newModel.getId()) .eq(Solutions::getBaseId,solutions.getId()) .eq(Solutions::getDataType,Constants.TWO) .set(Solutions::getDataType,Constants.ONE) + .set(StringUtils.isNotBlank(solutions.getSignKeyword()),Solutions::getSignKeyword,solutions.getSignKeyword()) ); - //澶勭悊宸ヤ綔淇℃伅锛屾柊澧炴渶鏂扮殑锛屽悓鏃朵骇鐢熷巻鍙茬増鏈� + //澶勭悊宸ョ淇℃伅锛屾柊澧炴渶鏂扮殑锛屽悓鏃朵骇鐢熷巻鍙茬増鏈� dealWorkType(solutions,newModel,solutions.getWorktypeIdList(),false); + + //鏇存柊company_solution 浣跨敤鏂扮増鏈殑鏁版嵁 + companySolutionMapper.update(null, + new UpdateWrapper<CompanySolution>() + .lambda() + .eq(CompanySolution::getStatus,Constants.ZERO) + .set(CompanySolution::getSolutionId,newModel.getId()) + .eq(CompanySolution::getSolutionBaseId,solutions.getId()) + ); + //鏇存柊 du_solution 浣跨敤鏂扮増鏈殑鏁版嵁 + duSolutionMapper.update(null, + new UpdateWrapper<DuSolution>() + .lambda() + .eq(DuSolution::getIsdeleted, Constants.ZERO) + .eq(DuSolution::getStatus, Constants.ONE) + .set(DuSolution::getSolutionId,newModel.getId()) + .eq(DuSolution::getSolutionId,oldVersion.getId())); } @Override @@ -261,6 +313,7 @@ @Override public List<Solutions> findList(Solutions solutions) { solutions.setIsdeleted(Constants.ZERO); + solutions.setStatus(Constants.ZERO); if(solutions.getDataType() == null){ solutions.setDataType(Constants.TWO); } @@ -279,7 +332,10 @@ queryWrapper.selectAll(Solutions.class); queryWrapper.selectAs(Insurance::getName,Solutions::getInsuranceName); queryWrapper.leftJoin(Insurance.class,Insurance::getId,Solutions::getInsuranceId); - + LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal(); + if(user.getType().equals(Constants.ONE)){ + queryWrapper.exists(("select 1 from company_solution b where b.isdeleted=0 and b.company_id="+user.getCompanyId()+" and b.SOLUTION_BASE_ID = t.id")); + } if (pageWrap.getModel().getId() != null) { queryWrapper.eq(Solutions::getId, pageWrap.getModel().getId()); } @@ -357,9 +413,7 @@ if (pageWrap.getModel().getOrtherInfo() != null) { queryWrapper.eq(Solutions::getOrtherInfo, pageWrap.getModel().getOrtherInfo()); } - if (pageWrap.getModel().getSolutionBaseId() != null) { - queryWrapper.eq(Solutions::getSolutionBaseId, pageWrap.getModel().getSolutionBaseId()); - } + if (pageWrap.getModel().getVersion() != null) { queryWrapper.eq(Solutions::getVersion, pageWrap.getModel().getVersion()); } @@ -411,24 +465,52 @@ @Override - public List<Solutions> findListForCompany() { + public List<Solutions> findListForCompany(Integer dataType) { LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal(); List<Solutions> solutionsList = solutionsJoinMapper.selectJoinList(Solutions.class,new MPJLambdaWrapper<Solutions>() .selectAll(Solutions.class) - .leftJoin(CompanySolution.class,CompanySolution::getSolutionBaseId,Solutions::getId) + .leftJoin(CompanySolution.class,CompanySolution::getSolutionId,Solutions::getId) + .leftJoin(Company.class,Company::getId,CompanySolution::getCompanyId) + .leftJoin(Insurance.class,Insurance::getId,Solutions::getInsuranceId) .eq(Solutions::getIsdeleted,Constants.ZERO) - .eq(Solutions::getDataType,Constants.TWO) + .eq(Solutions::getStatus,Constants.ZERO) + .eq(Solutions::getDataType,dataType) .eq(CompanySolution::getIsdeleted,Constants.ZERO) .eq(CompanySolution::getCompanyId,user.getCompanyId()) + .eq(Company::getIsdeleted,Constants.ZERO) + .eq(Company::getStatus,Constants.ZERO) + .eq(Insurance::getIsdeleted,Constants.ZERO) + .eq(Insurance::getStatus,Constants.ZERO) .orderByAsc(Solutions::getSortnum) ); return solutionsList; } - - - - + /** + * 鏍规嵁鍘嗗彶鐗堟湰鏌ヨ褰撳墠鏈�鏂板惎鐢ㄧ増鏈� + * @param solutionId + * @return + */ + @Override + public Solutions getNewVersion(Integer solutionId){ + Solutions solutions = solutionsMapper.selectById(solutionId); + if(Objects.isNull(solutions)){ + throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"鏈煡璇㈠埌鍘嗗彶鏂规淇℃伅"); + } + if(solutions.getDataType().equals(Constants.TWO)){ + return solutions; + } + Solutions newVersion = solutionsMapper.selectOne(new QueryWrapper<Solutions>().lambda() + .eq(Solutions::getIsdeleted,Constants.ZERO) + .eq(Solutions::getDataType,Constants.TWO) + .eq(Solutions::getBaseId,solutions.getBaseId()) + .last("limit 1") + ); + if(Objects.isNull(newVersion)){ + throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"鏈煡璇㈠埌鏈�鏂扮増鏈暟鎹�"); + } + return newVersion; + } @Override -- Gitblit v1.9.3