| | |
| | | .leftJoin(InsuranceApply.class,InsuranceApply::getId,ApplyDetail::getApplyId) |
| | | .leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId) |
| | | .eq(ApplyDetail::getIdcardNo,idCode) |
| | | .eq(ApplyDetail::getIsdeleted,Constants.ZERO) |
| | | .eq(Solutions::getBaseId,solutionId) |
| | | .ne(Objects.nonNull(applyId),InsuranceApply::getId,applyId) |
| | | .notIn(InsuranceApply::getStatus |
| | |
| | | .leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId) |
| | | .eq(ApplyDetail::getIdcardNo,idCode) |
| | | .eq(Solutions::getBaseId,solutionId) |
| | | .eq(ApplyDetail::getIsdeleted,Constants.ZERO) |
| | | .notIn(InsuranceApply::getStatus |
| | | ,Constants.InsuranceApplyStatus.CLOSE.getKey() |
| | | ,Constants.InsuranceApplyStatus.WTB_CLOSED.getKey() ) |