| | |
|---|
| | | .selectAs(Solutions::getType,InsuranceApply::getSolutionType) |
|---|
| | | .selectAs(Company::getName,InsuranceApply::getCompanyName) |
|---|
| | | .select(" ( select count(DISTINCT(ad.MEMBER_ID)) from apply_detail ad where ad.apply_id = t.id ) as insureNum") |
|---|
| | | .select(" isnull(( select count(DISTINCT(ad.MEMBER_ID)) from apply_detail ad inner join insurance_apply a on ad.apply_id = a.id and a.status in ( 5 , 27 ) where ad.apply_id = t.id and ad.END_TIME > now() ),0) as guaranteeNum") |
|---|
| | | .select(" ifnull(( select count(DISTINCT(ad.MEMBER_ID)) from apply_detail ad inner join insurance_apply a on ad.apply_id = a.id and a.status in ( 5 , 27 ) where ad.apply_id = t.id and ad.END_TIME > now() ),0) as guaranteeNum") |
|---|
| | | .leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId) |
|---|
| | | .leftJoin(Company.class,Company::getId,InsuranceApply::getCompanyId) |
|---|
| | | .eq(InsuranceApply::getId,model.getId()) |
|---|
