| | |
| | | //本月新增投保企业 |
| | | insuranceApplyDataVO.setMonthAddInsuranceCompanyNum(Objects.nonNull(monthAddInsuranceCompanyNum)?monthAddInsuranceCompanyNum:Constants.ZERO); |
| | | //直保保单数量 |
| | | insuranceApplyDataVO.setZbInsuranceNum(insuranceApplyList.stream().filter(i -> Constants.equalsInteger(i.getSolutionType(), Constants.ZERO)).collect(Collectors.toList()).size()); |
| | | insuranceApplyDataVO.setZbInsuranceNum(insuranceApplyList.stream().filter(i -> Constants.equalsInteger(i.getSolutionType(), Constants.ZERO) |
| | | &&(Constants.equalsInteger(i.getStatus(), Constants.InsuranceApplyStatus.UPLOAD_INSURANCE.getKey()) |
| | | || Constants.equalsInteger(i.getStatus(), Constants.InsuranceApplyStatus.WTB_DONE.getKey()))) |
| | | .collect(Collectors.toList()).size()); |
| | | //委托保保单数量 |
| | | insuranceApplyDataVO.setWtbInsuranceNum(insuranceApplyList.stream().filter(i -> Constants.equalsInteger(i.getSolutionType(), Constants.ONE)).collect(Collectors.toList()).size()); |
| | | insuranceApplyDataVO.setWtbInsuranceNum(insuranceApplyList.stream().filter(i -> Constants.equalsInteger(i.getSolutionType(), Constants.ONE) |
| | | &&(Constants.equalsInteger(i.getStatus(), Constants.InsuranceApplyStatus.UPLOAD_INSURANCE.getKey()) |
| | | || Constants.equalsInteger(i.getStatus(), Constants.InsuranceApplyStatus.WTB_DONE.getKey()))).collect(Collectors.toList()).size()); |
| | | } |
| | | |
| | | //合计总费用 |
| | |
| | | DataListVO dataListVOA = new DataListVO(); |
| | | dataListVOA.setDataFirst("不在保"); |
| | | dataListVOA.setDataSecond( |
| | | applyDetailJoinMapper.selectJoinCount( new MPJLambdaWrapper<ApplyDetail>() |
| | | applyDetailJoinMapper.selectJoinList(ApplyDetail.class, new MPJLambdaWrapper<ApplyDetail>() |
| | | .select(ApplyDetail::getMemberId) |
| | | .leftJoin(InsuranceApply.class, InsuranceApply::getId, ApplyDetail::getApplyId) |
| | | .eq(ApplyDetail::getIsdeleted, Constants.ZERO) |
| | | .eq(InsuranceApply::getIsdeleted, Constants.ZERO) |
| | | .in(InsuranceApply::getStatus,Constants.InsuranceApplyStatus.UPLOAD_INSURANCE.getKey(),Constants.InsuranceApplyStatus.WTB_DONE.getKey()) |
| | | .eq(InsuranceApply::getCompanyId,loginUserInfo.getCompanyId()) |
| | | .apply(" t.END_TIME < now() ")).toString() |
| | | |
| | | .apply(" t.END_TIME < now() ") |
| | | .groupBy(ApplyDetail::getMemberId) |
| | | |
| | | ).size()+"" |
| | | |
| | | ); |
| | | dataListVOList.add(dataListVOA); |
| | |
| | | DataListVO dataListVOB = new DataListVO(); |
| | | dataListVOB.setDataFirst("保障中"); |
| | | dataListVOB.setDataSecond( |
| | | applyDetailJoinMapper.selectJoinCount( new MPJLambdaWrapper<ApplyDetail>() |
| | | applyDetailJoinMapper.selectJoinList(ApplyDetail.class, new MPJLambdaWrapper<ApplyDetail>() |
| | | .select(ApplyDetail::getMemberId) |
| | | .leftJoin(InsuranceApply.class, InsuranceApply::getId, ApplyDetail::getApplyId) |
| | | .eq(ApplyDetail::getIsdeleted, Constants.ZERO) |
| | | .eq(InsuranceApply::getIsdeleted, Constants.ZERO) |
| | | .in(InsuranceApply::getStatus,Constants.InsuranceApplyStatus.UPLOAD_INSURANCE.getKey(),Constants.InsuranceApplyStatus.WTB_DONE.getKey()) |
| | | .eq(InsuranceApply::getCompanyId,loginUserInfo.getCompanyId()) |
| | | .apply(" t.END_TIME >= now() ")).toString() |
| | | .apply(" t.END_TIME >= now() ").groupBy(ApplyDetail::getMemberId)).size()+"" |
| | | ); |
| | | |
| | | dataListVOList.add(dataListVOB); |