| | |
|---|
| | | .selectAs(Solutions::getTimeUnit,UnionApply::getTimeUnit) |
|---|
| | | .selectAs(Solutions::getOrtherInfo,UnionApply::getOrtherInfo) |
|---|
| | | .selectAs(Solutions::getSpecialAgreement,UnionApply::getSpecialAgreement) |
|---|
| | | .selectAs(Solutions::getSpecialInfo,UnionApply::getSpecialInfo); |
|---|
| | | .selectAs(Solutions::getSpecialInfo,UnionApply::getSpecialInfo) |
|---|
| | | .select(" (select c.NAME from insurance_apply i left join company c on i.COMPANY_ID = c.id where i.UNION_APPLY_ID = t.id limit 1 ) ",UnionApply::getCompanyName); |
|---|
| | | queryWrapper.select("(select count(distinct(b.MEMBER_ID)) from apply_detail b where b.isdeleted=0 and b.union_apply_id=t.id) as insureNum "); |
|---|
| | | queryWrapper.select(" ( select count(DISTINCT(b.MEMBER_ID)) from apply_detail b inner join insurance_apply a on b.apply_id = a.id and a.status in ( 5 , 27 ) where b.union_apply_id=t.id and b.END_TIME > now() ) as guaranteeNum"); |
|---|
| | | |
|---|
