| | |
| | | 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.leftJoin(InsuranceApply.class,InsuranceApply::getId,ApplyDetail::getApplyId); |
| | | queryWrapper.leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId); |
| | | queryWrapper.leftJoin(Company.class,Company::getId,InsuranceApply::getCompanyId); |
| | | queryWrapper.eq(ApplyDetail::getIsdeleted,Constants.ZERO); |
| | | |
| | | ApplyDetailPageDTO applyDetailPageDTO = pageWrap.getModel(); |
| | | |
| | |
| | | //在保 |
| | | if(!Objects.isNull(applyDetailPageDTO.getApplyStatus()) |
| | | &&applyDetailPageDTO.getApplyStatus().equals(Constants.ONE)){ |
| | | queryWrapper.apply(" now() <= t.END_TIME "); |
| | | queryWrapper.apply(" now() <= t.END_TIME and now() >= t.START_TIME "); |
| | | queryWrapper.in(InsuranceApply::getStatus,Constants.InsuranceApplyStatus.UPLOAD_INSURANCE.getKey(),Constants.InsuranceApplyStatus.WTB_DONE.getKey()); |
| | | } |
| | | //不在保 |
| | | if(!Objects.isNull(applyDetailPageDTO.getApplyStatus()) |
| | | &&applyDetailPageDTO.getApplyStatus().equals(Constants.TWO)){ |
| | | queryWrapper.apply("now() > t.END_TIME "); |
| | | queryWrapper.in(InsuranceApply::getStatus,Constants.InsuranceApplyStatus.UPLOAD_INSURANCE.getKey(),Constants.InsuranceApplyStatus.WTB_DONE.getKey()); |
| | | } |
| | | //待生效 |
| | | if(!Objects.isNull(applyDetailPageDTO.getApplyStatus()) |
| | | &&applyDetailPageDTO.getApplyStatus().equals(Constants.THREE)){ |
| | | queryWrapper.apply("now() < t.START_TIME "); |
| | | queryWrapper.in(InsuranceApply::getStatus,Constants.InsuranceApplyStatus.UPLOAD_INSURANCE.getKey(),Constants.InsuranceApplyStatus.WTB_DONE.getKey()); |
| | | } |
| | | |
| | | queryWrapper.eq(!Objects.isNull(applyDetailPageDTO.getDuId()),ApplyDetail::getDuId,applyDetailPageDTO.getDuId()); |
| | |
| | | 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())); |
| | | |
| | | if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(pageWrap.getSorts())){ |
| | | for(PageWrap.SortData sortData: pageWrap.getSorts()) { |
| | |
| | | int num = 1; |
| | | for (ApplyDetail d : pageData.getRecords()){ |
| | | d.setSortnum(num++); |
| | | if(d.getEndTime().compareTo(new Date())<0){ |
| | | d.setApplyStatus(Constants.ONE); |
| | | if(Constants.equalsInteger(d.getStatus(),Constants.InsuranceApplyStatus.UPLOAD_INSURANCE.getKey()) |
| | | || Constants.equalsInteger(d.getStatus(),Constants.InsuranceApplyStatus.WTB_DONE.getKey())){ |
| | | if(d.getEndTime().getTime()< System.currentTimeMillis()){ |
| | | d.setApplyStatus(Constants.ONE); |
| | | }else if(d.getStartTime().getTime()> System.currentTimeMillis()){ |
| | | d.setApplyStatus(Constants.TWO); |
| | | }else{ |
| | | d.setApplyStatus(Constants.ZERO); |
| | | } |
| | | }else{ |
| | | d.setApplyStatus(Constants.ZERO); |
| | | d.setApplyStatus(-Constants.ONE); |
| | | } |
| | | if(Objects.nonNull(d.getReduceMoney())){ |
| | | d.setFee(d.getFee().add(d.getReduceMoney())); |
| | | } |
| | | |
| | | // d.setPrice(Constants.getTwoPoint(d.getPrice())); |
| | | // d.setFee(Constants.getTwoPoint(d.getFee())); |
| | | |
| | | |
| | | } |
| | | } |