From 64d4993478b5ba6a91aa8c535482ae151acaceb2 Mon Sep 17 00:00:00 2001 From: nidapeng <jp@doumee.com> Date: 星期四, 11 四月 2024 09:35:25 +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/ApplyChagneDetailServiceImpl.java | 7 ++++++- 1 files changed, 6 insertions(+), 1 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 ef76fd5..f74e0a9 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 @@ -98,10 +98,13 @@ queryWrapper.select("t3.name",ApplyChagneDetail::getDuName); queryWrapper.select("t4.name",ApplyChagneDetail::getOldWorkTypeName); queryWrapper.select("t5.name",ApplyChagneDetail::getOldDuName); + queryWrapper.selectAs(Company::getName,ApplyChagneDetail::getCompanyName); + queryWrapper.selectAs(Company::getId,ApplyChagneDetail::getCompanyId); 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(Company.class,Company::getId,Member::getCompanyId); queryWrapper.leftJoin(Worktype.class,Worktype::getId,ApplyChagneDetail::getWorktypeId); queryWrapper.leftJoin(DispatchUnit.class,DispatchUnit::getId,ApplyChagneDetail::getDuId); queryWrapper.leftJoin(Worktype.class,Worktype::getId,ApplyChagneDetail::getOldWorktypeId); @@ -111,6 +114,7 @@ queryWrapper.eq(!Objects.isNull(applyDetailPageDTO.getDuId()),ApplyChagneDetail::getDuId,applyDetailPageDTO.getDuId()); queryWrapper.eq(!Objects.isNull(applyDetailPageDTO.getWorktypeId()),ApplyChagneDetail::getWorktypeId,applyDetailPageDTO.getWorktypeId()); queryWrapper.eq(!Objects.isNull(applyDetailPageDTO.getApplyChangeId()),ApplyChagneDetail::getApplyChangeId,applyDetailPageDTO.getApplyChangeId()); + queryWrapper.eq(!Objects.isNull(applyDetailPageDTO.getUnionChangeId()),ApplyChagneDetail::getUnionChangeId,applyDetailPageDTO.getUnionChangeId()); queryWrapper.like(StringUtils.isNotBlank(applyDetailPageDTO.getMemberName()),Member::getName,applyDetailPageDTO.getMemberName()); List<ApplyChagneDetail> pageData = applyChangeDetailJoinMapper.selectJoinList( ApplyChagneDetail.class, queryWrapper); @@ -190,6 +194,7 @@ Utils.MP.blankToNull(pageWrap.getModel()); queryWrapper.selectAll(ApplyChagneDetail.class); queryWrapper.selectAs(Company::getName,ApplyChagneDetail::getCompanyName); + queryWrapper.selectAs(Company::getId,ApplyChagneDetail::getCompanyId); queryWrapper.select("t2.name",ApplyChagneDetail::getWorkTypeName); queryWrapper.select("t3.name",ApplyChagneDetail::getDuName); queryWrapper.select("t4.name",ApplyChagneDetail::getOldWorkTypeName); @@ -217,6 +222,7 @@ queryWrapper.eq(!Objects.isNull(applyDetailPageDTO.getDuId()),ApplyChagneDetail::getDuId,applyDetailPageDTO.getDuId()); queryWrapper.eq(!Objects.isNull(applyDetailPageDTO.getWorkTypeId()),ApplyChagneDetail::getWorktypeId,applyDetailPageDTO.getWorkTypeId()); queryWrapper.eq(!Objects.isNull(applyDetailPageDTO.getApplyChangeId()),ApplyChagneDetail::getApplyChangeId,applyDetailPageDTO.getApplyChangeId()); + queryWrapper.eq(!Objects.isNull(applyDetailPageDTO.getUnionChangeId()),ApplyChagneDetail::getUnionChangeId,applyDetailPageDTO.getUnionChangeId()); queryWrapper.like(StringUtils.isNotBlank(applyDetailPageDTO.getMemberName()),Member::getName,applyDetailPageDTO.getMemberName()); queryWrapper.ge(StringUtils.isNotBlank(applyDetailPageDTO.getStartTimeS()),ApplyChagneDetail::getStartTime,applyDetailPageDTO.getStartTimeS()+" 00:00:00"); queryWrapper.le(StringUtils.isNotBlank(applyDetailPageDTO.getStartTimeE()),ApplyChagneDetail::getStartTime,applyDetailPageDTO.getStartTimeE()+" 23:59:59"); @@ -260,7 +266,6 @@ List<ApplyChagneDetail> list = applyChangeDetailJoinMapper.selectJoinList(ApplyChagneDetail.class, queryWrapper); for (ApplyChagneDetail applyChagneDetail:list) { applyChagneDetail.setAge(Constants.getAgeByIdCard(applyChagneDetail.getMemberIdcardNo())); - } return list; } -- Gitblit v1.9.3