| | |
|---|
| | | // applyLogMapper.insert(log); |
|---|
| | | // |
|---|
| | | // startSendEmail(f, model.getCompanyName(),model.getSolutionsName(),model.getSolutionEmail()); |
|---|
| | | |
|---|
| | | |
|---|
| | | Constants.ApplyLogType applyLogType = Constants.ApplyLogType.IA_HBD_SIGNATURE_TBD; |
|---|
| | | ApplyLog log = new ApplyLog(model,applyLogType.getName(), null |
|---|
| | | ,model.getId(),applyLogType.getKey(),null, JSONObject.toJSONString(model)); |
|---|
| | | applyLogMapper.insert(log); |
|---|
| | | |
|---|
| | | return f; |
|---|
| | | } |
|---|
| | | |
|---|
| | |
|---|
| | | .selectAs(Solutions::getTimeUnit,InsuranceApply::getTimeUnit) |
|---|
| | | .selectAs(Solutions::getType,InsuranceApply::getSolutionType) |
|---|
| | | .selectAs(Solutions::getName,InsuranceApply::getSolutionsName) |
|---|
| | | .selectAs(Solutions::getName,InsuranceApply::getShopName) |
|---|
| | | .selectAs(Company::getName,InsuranceApply::getCompanyName) |
|---|
| | | .select(" ( select max(ac.APPLY_START_TIME) from apply_change ac where ac.apply_id = t.id and ac.status = 2 ) as lastChangeDate") |
|---|
| | | .select(" ( select count(DISTINCT(ad.MEMBER_ID)) from apply_detail ad where ad.apply_id = t.id ) as insureNum") |
|---|
| | | .select(" t3.name as shopName") |
|---|
| | | .leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId) |
|---|
| | | .leftJoin(Company.class,Company::getId,InsuranceApply::getCompanyId) |
|---|
| | | .leftJoin(Company.class,Company::getId,Solutions::getShopId) |
|---|
