|  |  |  | 
|---|
|  |  |  | 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()); | 
|---|
|  |  |  | 
|---|
|  |  |  | 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.leftJoin(ApplyChange.class,ApplyChange::getId,ApplyChagneDetail::getApplyChangeId); | 
|---|
|  |  |  | queryWrapper.leftJoin(InsuranceApply.class,InsuranceApply::getId,ApplyChange::getApplyId); | 
|---|
|  |  |  | queryWrapper.leftJoin(Company.class,Company::getId,InsuranceApply::getCompanyId); | 
|---|
|  |  |  | ApplyDetailPageDTO applyDetailPageDTO = pageWrap.getModel(); | 
|---|
|  |  |  | 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  "); | 
|---|