| | |
|---|
| | | return unionApplyMapper.selectCount(wrapper); |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public UnionApply findDetailForExport(UnionApply model){ |
|---|
| | | UnionApply insuranceApply = detail(model.getId()); |
|---|
| | | if(Objects.isNull(insuranceApply)){ |
|---|
| | | throw new BusinessException(ResponseStatus.DATA_EMPTY); |
|---|
| | | } |
|---|
| | | |
|---|
| | | MPJLambdaWrapper<ApplyDetail> queryWrapper = new MPJLambdaWrapper<>(); |
|---|
| | | queryWrapper.selectAll(ApplyDetail.class); |
|---|
| | | queryWrapper.selectAs(DispatchUnit::getName,ApplyDetail::getDuName); |
|---|
| | | queryWrapper.selectAs(Company::getName,ApplyDetail::getCompanyName); |
|---|
| | | queryWrapper.selectAs(Worktype::getName,ApplyDetail::getWorkTypeName); |
|---|
| | | queryWrapper.selectAs(Member::getIdcardNo,ApplyDetail::getIdcardNo); |
|---|
| | | queryWrapper.selectAs(Member::getName,ApplyDetail::getMemberName); |
|---|
| | | queryWrapper.leftJoin(DispatchUnit.class,DispatchUnit::getId,ApplyDetail::getDuId); |
|---|
| | | queryWrapper.leftJoin(Worktype.class,Worktype::getId,ApplyDetail::getWorktypeId); |
|---|
| | | queryWrapper.leftJoin(Member.class,Member::getId,ApplyDetail::getMemberId); |
|---|
| | | queryWrapper.leftJoin(Company.class,Company::getId,Member::getCompanyId); |
|---|
| | | queryWrapper.eq( ApplyDetail::getUnionApplyId,model.getId()); |
|---|
| | | List<ApplyDetail> detailList= applyDetailJoinMapper.selectJoinList( ApplyDetail.class, queryWrapper); |
|---|
| | | //查询明细 |
|---|
| | | if(detailList!=null){ |
|---|
| | | insuranceApply.setInsureNum(detailList.size()); |
|---|
| | | insuranceApply.setApplyDetailList(detailList); |
|---|
| | | } |
|---|
| | | insuranceApply.setRemark(model.getRemark()); |
|---|
| | | return insuranceApply; |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | @Override |
|---|
| | |
|---|
| | | .selectAs(Solutions::getName,UnionApply::getSolutionName) |
|---|
| | | .selectAs(Company::getName,UnionApply::getCompanyName) |
|---|
| | | .select(" ( select count(DISTINCT(ad.MEMBER_ID)) from apply_detail ad where ad.UNION_APPLY_ID = t.id ) as insureNum") |
|---|
| | | .select(" ( select group_concat(DISTINCT(cd.name)) from insurance_apply ad left join company cd on ad.company_id = cd.id where ad.UNION_APPLY_ID = t.id ) as companyNames") |
|---|
| | | .leftJoin(Solutions.class,Solutions::getId,UnionApply::getSolutionId) |
|---|
| | | .leftJoin(Company.class,Company::getId,UnionApply::getCompanyId) |
|---|
| | | .eq(UnionApply::getId,applyId) |
|---|
