From bcf40504dd6dbad43d4d54a5c099abceb8de6d71 Mon Sep 17 00:00:00 2001 From: k94314517 <8417338+k94314517@user.noreply.gitee.com> Date: 星期一, 01 四月 2024 17:04:41 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/1.0.1' into 1.0.1 --- server/service/src/main/java/com/doumee/service/business/impl/UnionApplyServiceImpl.java | 40 ++++++++++++++++++++++++++++++++++++---- 1 files changed, 36 insertions(+), 4 deletions(-) diff --git a/server/service/src/main/java/com/doumee/service/business/impl/UnionApplyServiceImpl.java b/server/service/src/main/java/com/doumee/service/business/impl/UnionApplyServiceImpl.java index 2f3d670..138b050 100644 --- a/server/service/src/main/java/com/doumee/service/business/impl/UnionApplyServiceImpl.java +++ b/server/service/src/main/java/com/doumee/service/business/impl/UnionApplyServiceImpl.java @@ -258,6 +258,35 @@ return unionApplyMapper.selectCount(wrapper); } + @Override + public UnionApply findDetailForExport(UnionApply model){ + UnionApply insuranceApply = detail(model.getId()); + if(Objects.isNull(insuranceApply)){ + throw new BusinessException(ResponseStatus.DATA_EMPTY); + } + + MPJLambdaWrapper<ApplyDetail> queryWrapper = new MPJLambdaWrapper<>(); + queryWrapper.selectAll(ApplyDetail.class); + queryWrapper.selectAs(DispatchUnit::getName,ApplyDetail::getDuName); + queryWrapper.selectAs(Company::getName,ApplyDetail::getCompanyName); + queryWrapper.selectAs(Worktype::getName,ApplyDetail::getWorkTypeName); + queryWrapper.selectAs(Member::getIdcardNo,ApplyDetail::getIdcardNo); + queryWrapper.selectAs(Member::getName,ApplyDetail::getMemberName); + queryWrapper.leftJoin(DispatchUnit.class,DispatchUnit::getId,ApplyDetail::getDuId); + queryWrapper.leftJoin(Worktype.class,Worktype::getId,ApplyDetail::getWorktypeId); + queryWrapper.leftJoin(Member.class,Member::getId,ApplyDetail::getMemberId); + queryWrapper.leftJoin(Company.class,Company::getId,Member::getCompanyId); + queryWrapper.eq( ApplyDetail::getUnionApplyId,model.getId()); + List<ApplyDetail> detailList= applyDetailJoinMapper.selectJoinList( ApplyDetail.class, queryWrapper); + //鏌ヨ鏄庣粏 + if(detailList!=null){ + insuranceApply.setInsureNum(detailList.size()); + insuranceApply.setApplyDetailList(detailList); + } + insuranceApply.setRemark(model.getRemark()); + return insuranceApply; + } + @Override @@ -268,6 +297,7 @@ .selectAs(Solutions::getName,UnionApply::getSolutionName) .selectAs(Company::getName,UnionApply::getCompanyName) .select(" ( select count(DISTINCT(ad.MEMBER_ID)) from apply_detail ad where ad.UNION_APPLY_ID = t.id ) as insureNum") + .select(" ( select group_concat(DISTINCT(cd.name)) from insurance_apply ad left join company cd on ad.company_id = cd.id where ad.UNION_APPLY_ID = t.id ) as companyNames") .leftJoin(Solutions.class,Solutions::getId,UnionApply::getSolutionId) .leftJoin(Company.class,Company::getId,UnionApply::getCompanyId) .eq(UnionApply::getId,applyId) @@ -354,6 +384,8 @@ UnionApply unionApply = new UnionApply(); unionApply.setCreateDate(new Date()); unionApply.setCreator(user.getId()); + unionApply.setEditor(user.getId()); + unionApply.setEditDate(new Date()); unionApply.setCompanyId(user.getCompanyId()); unionApply.setStartTime(saveUnionApplyDTO.getStartDate()); unionApply.setEndTime(saveUnionApplyDTO.getEndDate()); @@ -410,7 +442,9 @@ if(!user.getType().equals(Constants.TWO)){ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"闈炲晢鎴风敤鎴凤紝鏃犳硶杩涜璇ユ搷浣滐紒"); } - if(Objects.isNull(closeDTO)||Objects.isNull(closeDTO.getId())){ + if(Objects.isNull(closeDTO) + ||Objects.isNull(closeDTO.getId()) + ||StringUtils.isBlank(closeDTO.getReason())){ throw new BusinessException(ResponseStatus.BAD_REQUEST); } UnionApply unionApply = unionApplyMapper.selectById(closeDTO.getId()); @@ -456,8 +490,6 @@ info = info.replace("${param}", closeDTO.getReason()); ApplyLog log = new ApplyLog(unionApply,applyLogType.getName(), info ,unionApply.getId(),applyLogType.getKey(),null, null); - applyLogMapper.insert(log); - applyLogMapper.insert(log); } @@ -738,7 +770,7 @@ .set(UnionApply::getCurrentFee,sumCurrFee) .eq(UnionApply::getId,unionApply.getId()) ); - //鍚堝苟鍗� 鎬讳繚鍗� + //鍚堝苟鍗� 鏂囦欢 if(StringUtils.isNotBlank(unionApplyBXDDTO.getFileUrl())){ Multifile multifile = new Multifile(); multifile.setIsdeleted(Constants.ZERO); -- Gitblit v1.9.3