From 13ff112e45a64378cdc91aa2f05916721945f08a Mon Sep 17 00:00:00 2001 From: k94314517 <8417338+k94314517@user.noreply.gitee.com> Date: 星期四, 01 二月 2024 19:22:58 +0800 Subject: [PATCH] 111 --- server/service/src/main/java/com/doumee/service/business/impl/ApplyChagneDetailServiceImpl.java | 23 +++++++++++++++++++++++ 1 files changed, 23 insertions(+), 0 deletions(-) diff --git a/server/service/src/main/java/com/doumee/service/business/impl/ApplyChagneDetailServiceImpl.java b/server/service/src/main/java/com/doumee/service/business/impl/ApplyChagneDetailServiceImpl.java index a6e53bc..ef23ee2 100644 --- a/server/service/src/main/java/com/doumee/service/business/impl/ApplyChagneDetailServiceImpl.java +++ b/server/service/src/main/java/com/doumee/service/business/impl/ApplyChagneDetailServiceImpl.java @@ -232,6 +232,29 @@ return pageData; } + + @Override + public List<ApplyChagneDetail> findListForCompany(ApplyDetailPageDTO applyDetailPageDTO) { + MPJLambdaWrapper<ApplyChagneDetail> queryWrapper = new MPJLambdaWrapper<>(); + queryWrapper.selectAll(ApplyChagneDetail.class); + queryWrapper.select("t2.name",ApplyChagneDetail::getWorkTypeName); + queryWrapper.select("t3.name",ApplyChagneDetail::getDuName); + queryWrapper.select("t4.name",ApplyChagneDetail::getOldWorkTypeName); + queryWrapper.select("t5.name",ApplyChagneDetail::getOldDuName); + queryWrapper.selectAs(Member::getName,ApplyChagneDetail::getMemberName); + queryWrapper.selectAs(Member::getSex,ApplyChagneDetail::getSex); + queryWrapper.selectAs(Member::getIdcardNo,ApplyChagneDetail::getMemberIdcardNo); + queryWrapper.leftJoin(Member.class,Member::getId,ApplyChagneDetail::getMemberId); + queryWrapper.leftJoin(Worktype.class,Worktype::getId,ApplyChagneDetail::getWorktypeId); + queryWrapper.leftJoin(DispatchUnit.class,DispatchUnit::getId,ApplyChagneDetail::getDuId); + queryWrapper.leftJoin(Worktype.class,Worktype::getId,ApplyChagneDetail::getOldWorktypeId); + queryWrapper.leftJoin(DispatchUnit.class,DispatchUnit::getId,ApplyChagneDetail::getOldDuId); + queryWrapper.in(CollectionUtils.isNotEmpty(applyDetailPageDTO.getTypes()),ApplyChagneDetail::getType,applyDetailPageDTO.getTypes()); + queryWrapper.eq(!Objects.isNull(applyDetailPageDTO.getApplyChangId()),ApplyChagneDetail::getApplyChangeId,applyDetailPageDTO.getApplyChangId()); + return applyChangeDetailJoinMapper.selectJoinList(ApplyChagneDetail.class, queryWrapper); + } + + @Override public long count(ApplyChagneDetail applyChagneDetail) { QueryWrapper<ApplyChagneDetail> wrapper = new QueryWrapper<>(applyChagneDetail); -- Gitblit v1.9.3