| | |
|---|
| | | 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); |
|---|
| | | queryWrapper.leftJoin(DispatchUnit.class,DispatchUnit::getId,ApplyChagneDetail::getOldDuId); |
|---|
| | | queryWrapper.leftJoin(Company.class,Company::getId,Member::getCompanyId); |
|---|
| | | queryWrapper.exists(!Objects.isNull(applyDetailPageDTO.getApplyId()), |
|---|
| | | " select 1 from apply_change ac where ac.isdeleted = 0 and ac.status in (1,2) and ac.apply_id = "+applyDetailPageDTO.getApplyId()+" and ac.id = t.apply_change_id "); |
|---|
| | | queryWrapper.eq(!Objects.isNull(applyDetailPageDTO.getDuId()),ApplyChagneDetail::getDuId,applyDetailPageDTO.getDuId()); |
|---|
| | |
|---|
| | | List<ApplyChagneDetail> list = applyChangeDetailJoinMapper.selectJoinList(ApplyChagneDetail.class, queryWrapper); |
|---|
| | | for (ApplyChagneDetail applyChagneDetail:list) { |
|---|
| | | applyChagneDetail.setAge(Constants.getAgeByIdCard(applyChagneDetail.getMemberIdcardNo())); |
|---|
| | | |
|---|
| | | } |
|---|
| | | return list; |
|---|
| | | } |
|---|
