|  |  | 
 |  |  |         queryWrapper.leftJoin(Company.class,Company::getId,Member::getCompanyId); | 
 |  |  |         queryWrapper.eq( applyDetailPageDTO.getApplyId()!=null,ApplyDetail::getApplyId,applyDetailPageDTO.getApplyId()); | 
 |  |  |         queryWrapper.eq( applyDetailPageDTO.getUnionApplyId()!=null,ApplyDetail::getUnionApplyId,applyDetailPageDTO.getUnionApplyId()); | 
 |  |  |         queryWrapper.ge(Objects.nonNull(applyDetailPageDTO.getIsExcel())&&Constants.equalsInteger(applyDetailPageDTO.getIsExcel(),Constants.ONE), | 
 |  |  |                 ApplyDetail::getEndTime,DateUtil.getPlusTime2(new Date())); | 
 |  |  |         List<ApplyDetail> pageData=  applyDetailJoinMapper.selectJoinList( ApplyDetail.class, queryWrapper); | 
 |  |  |         if(pageData!=null){ | 
 |  |  |             int num = 1; | 
 |  |  | 
 |  |  |         queryWrapper.selectAs(Member::getIdcardNo,ApplyDetail::getIdcardNo); | 
 |  |  |         queryWrapper.selectAs(Member::getName,ApplyDetail::getMemberName); | 
 |  |  |         queryWrapper.selectAs(Solutions::getName,ApplyDetail::getSolutionName); | 
 |  |  |         queryWrapper.selectAs(Solutions::getType,ApplyDetail::getSolutionType); | 
 |  |  |         queryWrapper.selectAs(Company::getName,ApplyDetail::getCompanyName); | 
 |  |  |         queryWrapper.selectAs(InsuranceApply::getStatus,ApplyDetail::getSolutionName); | 
 |  |  |         queryWrapper.selectAs(InsuranceApply::getStatus,ApplyDetail::getStatus); | 
 |  |  |         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.le(StringUtils.isNotBlank(applyDetailPageDTO.getStartTimeE()),ApplyDetail::getStartTime,applyDetailPageDTO.getStartTimeE()+" 23:59:59.0"); | 
 |  |  |         queryWrapper.ge(StringUtils.isNotBlank(applyDetailPageDTO.getEndTimeS()),ApplyDetail::getEndTime,applyDetailPageDTO.getEndTimeS()+" 00:00:00.0"); | 
 |  |  |         queryWrapper.le(StringUtils.isNotBlank(applyDetailPageDTO.getEndTimeE()),ApplyDetail::getEndTime,applyDetailPageDTO.getEndTimeE()+" 23:59:59.0"); | 
 |  |  |         queryWrapper.ge(Objects.nonNull(applyDetailPageDTO.getIsExcel())&&Constants.equalsInteger(applyDetailPageDTO.getIsExcel(),Constants.ONE), | 
 |  |  |                 ApplyDetail::getEndTime,DateUtil.getPlusTime2(new Date())); | 
 |  |  |  | 
 |  |  |         for(PageWrap.SortData sortData: pageWrap.getSorts()) { | 
 |  |  |             if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) { | 
 |  |  |                 queryWrapper.orderByDesc(sortData.getProperty()); | 
 |  |  |             } else { | 
 |  |  |                 queryWrapper.orderByAsc(sortData.getProperty()); | 
 |  |  |         if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(pageWrap.getSorts())){ | 
 |  |  |             for(PageWrap.SortData sortData: pageWrap.getSorts()) { | 
 |  |  |                 if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) { | 
 |  |  |                     queryWrapper.orderByDesc(sortData.getProperty()); | 
 |  |  |                 } else { | 
 |  |  |                     queryWrapper.orderByAsc(ApplyDetail::getSortnum); | 
 |  |  |                 } | 
 |  |  |             } | 
 |  |  |         }else{ | 
 |  |  |             queryWrapper.orderByAsc(ApplyDetail::getSortnum); | 
 |  |  |         } | 
 |  |  |         PageData<ApplyDetail> pageData = PageData.from(applyDetailJoinMapper.selectJoinPage(page,ApplyDetail.class, queryWrapper)); | 
 |  |  |         if(pageData.getRecords()!=null){ | 
 |  |  | 
 |  |  |                 }else{ | 
 |  |  |                     d.setApplyStatus(Constants.ZERO); | 
 |  |  |                 } | 
 |  |  |  | 
 |  |  |                 if(Objects.nonNull(d.getReduceMoney())){ | 
 |  |  |                     d.setFee(d.getFee().add(d.getReduceMoney())); | 
 |  |  |                 } | 
 |  |  |             } | 
 |  |  |         } | 
 |  |  |         return pageData; |