| | |
|---|
| | | .selectAll(InsuranceApply.class) |
|---|
| | | .selectAs(Solutions::getName,InsuranceApply::getSolutionsName) |
|---|
| | | .selectAs(Solutions::getEmail,InsuranceApply::getSolutionEmail) |
|---|
| | | .leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId) |
|---|
| | | .selectAs(Company::getName,InsuranceApply::getCompanyName) |
|---|
| | | .leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId) |
|---|
| | | .leftJoin(Company.class,Company::getId,InsuranceApply::getCompanyId) |
|---|
| | | .eq(InsuranceApply::getStatus,Constants.InsuranceApplyStatus.WAIT_SIGNATURE.getKey()) |
|---|
| | | .isNotNull(InsuranceApply::getSignApplyNo)); |
|---|
