From 54130a901757db72ae1d7c8d20cdfc2123749244 Mon Sep 17 00:00:00 2001
From: MrShi <1878285526@qq.com>
Date: 星期三, 25 六月 2025 10:06:09 +0800
Subject: [PATCH] Merge branch '2.0.1' of http://139.186.142.91:10010/r/productDev/yunyibao into 2.0.1
---
server/service/src/main/java/com/doumee/service/business/impl/InsuranceApplyOnServiceImpl.java | 411 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 410 insertions(+), 1 deletions(-)
diff --git a/server/service/src/main/java/com/doumee/service/business/impl/InsuranceApplyOnServiceImpl.java b/server/service/src/main/java/com/doumee/service/business/impl/InsuranceApplyOnServiceImpl.java
index b38bc6c..fc37177 100644
--- a/server/service/src/main/java/com/doumee/service/business/impl/InsuranceApplyOnServiceImpl.java
+++ b/server/service/src/main/java/com/doumee/service/business/impl/InsuranceApplyOnServiceImpl.java
@@ -23,6 +23,9 @@
import com.doumee.dao.business.model.*;
import com.doumee.dao.business.vo.ApplyPowerVO;
import com.doumee.dao.business.vo.CountCyclePriceVO;
+import com.doumee.dao.business.vo.dataBoard.DataListVO;
+import com.doumee.dao.business.vo.dataBoard.InsuranceApplyDataVO;
+import com.doumee.dao.business.vo.dataBoard.InsuranceApplyReportDataVO;
import com.doumee.dao.system.SystemUserMapper;
import com.doumee.dao.system.model.SystemUser;
import com.doumee.service.business.InsuranceApplyOnService;
@@ -83,7 +86,7 @@
@Autowired
private ApplyLogJoinMapper applyLogJoinMapper;
@Autowired
- private SolutionsMapper solutionsMapper;
+ private SolutionsJoinMapper solutionsMapper;
@Autowired
private MemberMapper memberMapper;
@Autowired
@@ -108,6 +111,10 @@
private SystemUserMapper systemUserMapper;
@Autowired
private CompanyDepartmentMapper companyDepartmentMapper;
+ @Autowired
+ private ApplyChangeDetailJoinMapper applyChangeDetailJoinMapper;
+ @Autowired
+ private SettleClaimsMapper settleClaimsMapper;
@Override
@Transactional(rollbackFor = {Exception.class,BusinessException.class})
@@ -613,6 +620,408 @@
}
return list;
}
+
+
+ @Override
+ public InsuranceApplyDataVO getInsuranceApplyDataVO() {
+ InsuranceApplyDataVO insuranceApplyDataVO = new InsuranceApplyDataVO();
+ insuranceApplyDataVO.setInsuranceNum(Constants.ZERO);
+ insuranceApplyDataVO.setMonthAddInsuranceNum(Constants.ZERO);
+ insuranceApplyDataVO.setInsuranceCompanyNum(Constants.ZERO);
+ insuranceApplyDataVO.setMonthAddInsuranceCompanyNum(Constants.ZERO);
+ insuranceApplyDataVO.setMemberNum(Constants.ZERO);
+ insuranceApplyDataVO.setMonthAddMemberNum(Constants.ZERO);
+ insuranceApplyDataVO.setTotalFee(BigDecimal.ZERO);
+ insuranceApplyDataVO.setMonthAddTotalFee(BigDecimal.ZERO);
+ insuranceApplyDataVO.setUseCompanyNum(Constants.ZERO);
+ insuranceApplyDataVO.setUseInsuranceNum(Constants.ZERO);
+ insuranceApplyDataVO.setUseMemberNum(Constants.ZERO);
+
+ List<InsuranceApply> insuranceApplyList = insuranceApplyJoinMapper.selectJoinList(InsuranceApply.class,
+ new MPJLambdaWrapper<InsuranceApply>()
+ .selectAll(InsuranceApply.class)
+ .selectAs(Solutions::getType, InsuranceApply::getSolutionType)
+ .leftJoin(Solutions.class, Solutions::getId, InsuranceApply::getSolutionId)
+ .eq(InsuranceApply::getIsdeleted, Constants.ZERO)
+ .notIn(InsuranceApply::getStatus,
+ Constants.InsuranceApplyStatus.COMPANY_BACK_APPLY_PASS.getKey(),
+ Constants.InsuranceApplyStatus.CLOSE.getKey(),
+ Constants.InsuranceApplyStatus.WTB_RETURN.getKey(),
+ Constants.InsuranceApplyStatus.WTB_CLOSED.getKey()
+ )
+ );
+
+ String monthDate = DateUtil.getFomartDate(new Date(), "yyyy-MM");
+
+ if (CollectionUtils.isNotEmpty(insuranceApplyList)) {
+ //绱鏈夋晥淇濆崟
+ insuranceApplyDataVO.setInsuranceNum(
+ insuranceApplyList.stream().filter(i -> Constants.equalsInteger(i.getStatus(), Constants.InsuranceApplyStatus.UPLOAD_INSURANCE.getKey())
+ || Constants.equalsInteger(i.getStatus(), Constants.InsuranceApplyStatus.WTB_DONE.getKey())
+ ).collect(Collectors.toList()).size()
+ );
+ //鏈湀鏂板鏈夋晥淇濆崟
+ insuranceApplyDataVO.setMonthAddInsuranceNum(
+ insuranceApplyList.stream().filter(i -> (Constants.equalsInteger(i.getStatus(), Constants.InsuranceApplyStatus.UPLOAD_INSURANCE.getKey())
+ || Constants.equalsInteger(i.getStatus(), Constants.InsuranceApplyStatus.WTB_DONE.getKey()))
+ && DateUtil.formatDate(i.getCreateDate(), "yyyy-MM").equals(monthDate)
+ ).collect(Collectors.toList()).size()
+ );
+ //鍦ㄤ繚浼佷笟鏁伴噺
+ List<Integer> useCompanyNum = insuranceApplyList.stream().filter(i -> (Constants.equalsInteger(i.getStatus(), Constants.InsuranceApplyStatus.UPLOAD_INSURANCE.getKey())
+ || Constants.equalsInteger(i.getStatus(), Constants.InsuranceApplyStatus.WTB_DONE.getKey()))
+ && i.getStartTime().getTime() <= System.currentTimeMillis() && i.getEndTime().getTime() >= System.currentTimeMillis()
+ ).map(i -> i.getCompanyId()).collect(Collectors.toList());
+ insuranceApplyDataVO.setUseCompanyNum(new HashSet<>(useCompanyNum).size());
+
+ //鍦ㄤ繚淇濆崟鏁伴噺
+ insuranceApplyDataVO.setUseInsuranceNum(
+ insuranceApplyList.stream().filter(i -> (Constants.equalsInteger(i.getStatus(), Constants.InsuranceApplyStatus.UPLOAD_INSURANCE.getKey())
+ || Constants.equalsInteger(i.getStatus(), Constants.InsuranceApplyStatus.WTB_DONE.getKey()))
+ && i.getStartTime().getTime() <= System.currentTimeMillis() && i.getEndTime().getTime() >= System.currentTimeMillis()
+ ).collect(Collectors.toList()).size()
+ );
+ List<Integer> companyIds = insuranceApplyList.stream().map(i -> i.getCompanyId()).collect(Collectors.toList());
+ if (CollectionUtils.isNotEmpty(companyIds)) {
+ //绱鎶曚繚浼佷笟鏁伴噺
+ insuranceApplyDataVO.setInsuranceCompanyNum(new HashSet<>(companyIds).size());
+ }
+ Integer monthAddInsuranceCompanyNum = insuranceApplyJoinMapper.selectJoinCount(
+ new MPJLambdaWrapper<InsuranceApply>()
+ .eq(InsuranceApply::getIsdeleted, Constants.ZERO)
+ .notIn(InsuranceApply::getStatus,
+ Constants.InsuranceApplyStatus.COMPANY_BACK_APPLY_PASS.getKey(),
+ Constants.InsuranceApplyStatus.CLOSE.getKey(),
+ Constants.InsuranceApplyStatus.WTB_RETURN.getKey(),
+ Constants.InsuranceApplyStatus.WTB_CLOSED.getKey()
+ )
+ .apply(" company_id in ( select c.id from company c where c.ISDELETED = 0 and DATE_FORMAT(c.CREATE_DATE, '%Y-%m') = DATE_FORMAT(now(), '%Y-%m') ) ")
+ .groupBy(InsuranceApply::getCompanyId)
+ );
+ //鏈湀鏂板鎶曚繚浼佷笟
+ 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.setWtbInsuranceNum(insuranceApplyList.stream().filter(i -> Constants.equalsInteger(i.getSolutionType(), Constants.ONE)).collect(Collectors.toList()).size());
+ }
+
+ //鍚堣鎬昏垂鐢�
+ insuranceApplyDataVO.setTotalFee(new BigDecimal(applyDetailJoinMapper.selectJoinMap( new MPJLambdaWrapper<ApplyDetail>()
+ .select("ifnull(sum(t.fee),0) as fee")
+ .selectAs(InsuranceApply::getStatus, ApplyDetail::getApplyStatus)
+ .leftJoin(InsuranceApply.class, InsuranceApply::getId, ApplyDetail::getApplyId)
+ .eq(ApplyDetail::getIsdeleted, Constants.ZERO)
+ .eq(InsuranceApply::getIsdeleted, Constants.ZERO)
+ .notIn(InsuranceApply::getStatus,
+ Constants.InsuranceApplyStatus.COMPANY_BACK_APPLY_PASS.getKey(),
+ Constants.InsuranceApplyStatus.CLOSE.getKey(),
+ Constants.InsuranceApplyStatus.WTB_RETURN.getKey(),
+ Constants.InsuranceApplyStatus.WTB_CLOSED.getKey()
+ )
+ ).get("fee").toString()));
+ //鏈湀鏂板璐圭敤
+ insuranceApplyDataVO.setMonthAddTotalFee(
+ new BigDecimal(applyDetailJoinMapper.selectJoinMap( new MPJLambdaWrapper<ApplyDetail>()
+ .select("ifnull(sum(t.fee),0) as fee")
+ .leftJoin(InsuranceApply.class, InsuranceApply::getId, ApplyDetail::getApplyId)
+ .eq(ApplyDetail::getIsdeleted, Constants.ZERO)
+ .eq(InsuranceApply::getIsdeleted, Constants.ZERO)
+ .notIn(InsuranceApply::getStatus,
+ Constants.InsuranceApplyStatus.COMPANY_BACK_APPLY_PASS.getKey(),
+ Constants.InsuranceApplyStatus.CLOSE.getKey(),
+ Constants.InsuranceApplyStatus.WTB_RETURN.getKey(),
+ Constants.InsuranceApplyStatus.WTB_CLOSED.getKey()
+ )
+ .apply(" DATE_FORMAT(t.CREATE_DATE, '%Y-%m') = DATE_FORMAT(now(), '%Y-%m') ")
+ ).get("fee").toString())
+
+ );
+
+ //绱鎶曚繚浜烘
+ insuranceApplyDataVO.setMemberNum(
+ Integer.valueOf(applyDetailJoinMapper.selectJoinMap( new MPJLambdaWrapper<ApplyDetail>()
+ .select("count(distinct t.MEMBER_ID) as memberTimes")
+ .leftJoin(InsuranceApply.class, InsuranceApply::getId, ApplyDetail::getApplyId)
+ .eq(ApplyDetail::getIsdeleted, Constants.ZERO)
+ .eq(InsuranceApply::getIsdeleted, Constants.ZERO)
+ .notIn(InsuranceApply::getStatus,
+ Constants.InsuranceApplyStatus.COMPANY_BACK_APPLY_PASS.getKey(),
+ Constants.InsuranceApplyStatus.CLOSE.getKey(),
+ Constants.InsuranceApplyStatus.WTB_RETURN.getKey(),
+ Constants.InsuranceApplyStatus.WTB_CLOSED.getKey()
+ )
+ ).get("memberTimes").toString())
+ );
+ //鏈湀鏂板鎶曚繚浜烘
+ insuranceApplyDataVO.setMonthAddMemberNum(
+ Integer.valueOf(applyDetailJoinMapper.selectJoinMap( new MPJLambdaWrapper<ApplyDetail>()
+ .select("count(distinct t.MEMBER_ID) as memberTimes")
+ .leftJoin(InsuranceApply.class, InsuranceApply::getId, ApplyDetail::getApplyId)
+ .eq(ApplyDetail::getIsdeleted, Constants.ZERO)
+ .eq(InsuranceApply::getIsdeleted, Constants.ZERO)
+ .notIn(InsuranceApply::getStatus,
+ Constants.InsuranceApplyStatus.COMPANY_BACK_APPLY_PASS.getKey(),
+ Constants.InsuranceApplyStatus.CLOSE.getKey(),
+ Constants.InsuranceApplyStatus.WTB_RETURN.getKey(),
+ Constants.InsuranceApplyStatus.WTB_CLOSED.getKey()
+ )
+ .apply(" DATE_FORMAT(t.CREATE_DATE, '%Y-%m') = DATE_FORMAT(now(), '%Y-%m') ")
+ ).get("memberTimes").toString())
+
+ );
+
+
+ //褰撳墠淇濋殰浜哄憳
+ insuranceApplyDataVO.setUseMemberNum(
+
+
+ Integer.valueOf(applyDetailJoinMapper.selectJoinMap( new MPJLambdaWrapper<ApplyDetail>()
+ .select("count(distinct t.MEMBER_ID) as memberTimes")
+ .leftJoin(InsuranceApply.class, InsuranceApply::getId, ApplyDetail::getApplyId)
+ .eq(ApplyDetail::getIsdeleted, Constants.ZERO)
+ .eq(InsuranceApply::getIsdeleted, Constants.ZERO)
+ .notIn(InsuranceApply::getStatus,
+ Constants.InsuranceApplyStatus.COMPANY_BACK_APPLY_PASS.getKey(),
+ Constants.InsuranceApplyStatus.CLOSE.getKey(),
+ Constants.InsuranceApplyStatus.WTB_RETURN.getKey(),
+ Constants.InsuranceApplyStatus.WTB_CLOSED.getKey()
+ )
+ .apply(" t.start_time <= now() and t.end_time >= now() ")
+ ).get("memberTimes").toString())
+
+ );
+ return insuranceApplyDataVO;
+
+ }
+
+
+ @Override
+ public InsuranceApplyReportDataVO getInsuranceApplyReportDataVO(){
+ InsuranceApplyReportDataVO insuranceApplyReportDataVO = new InsuranceApplyReportDataVO();
+ List<DataListVO> companyTopFeeList = applyDetailJoinMapper.selectJoinList(DataListVO.class, new MPJLambdaWrapper<ApplyDetail>()
+ .select(" t2.name as dataFirst, ROUND(ifnull(sum(t.fee),0),2) as dataSecond ")
+ .leftJoin(InsuranceApply.class, InsuranceApply::getId, ApplyDetail::getApplyId)
+ .leftJoin(Company.class,Company::getId,InsuranceApply::getCompanyId)
+ .eq(ApplyDetail::getIsdeleted, Constants.ZERO)
+ .eq(InsuranceApply::getIsdeleted, Constants.ZERO)
+ .notIn(InsuranceApply::getStatus,
+ Constants.InsuranceApplyStatus.COMPANY_BACK_APPLY_PASS.getKey(),
+ Constants.InsuranceApplyStatus.CLOSE.getKey(),
+ Constants.InsuranceApplyStatus.WTB_RETURN.getKey(),
+ Constants.InsuranceApplyStatus.WTB_CLOSED.getKey()
+ )
+ .groupBy(" t1.company_id,t2.name")
+ .orderByDesc(" sum(t.fee) ")
+ .last(" limit 10")
+ );
+ insuranceApplyReportDataVO.setCompanyTopFeeList(companyTopFeeList);
+
+
+ List<DataListVO> hotSolutionList = insuranceApplyJoinMapper.selectJoinList(DataListVO.class, new MPJLambdaWrapper<InsuranceApply>()
+ .select(" solution_id as dataFirst, count(1) as dataSecond ")
+ .eq(InsuranceApply::getIsdeleted, Constants.ZERO)
+ .notIn(InsuranceApply::getStatus,
+ Constants.InsuranceApplyStatus.COMPANY_BACK_APPLY_PASS.getKey(),
+ Constants.InsuranceApplyStatus.CLOSE.getKey(),
+ Constants.InsuranceApplyStatus.WTB_RETURN.getKey(),
+ Constants.InsuranceApplyStatus.WTB_CLOSED.getKey()
+ )
+ .groupBy(" t.solution_id")
+ .orderByDesc(" count(1) ")
+ .last(" limit 10")
+ );
+
+ if(CollectionUtils.isNotEmpty(hotSolutionList)){
+ List<Solutions> solutionsList = solutionsMapper.selectJoinList(Solutions.class,new MPJLambdaWrapper<Solutions>()
+ .select("t.id, t.NAME , t1.name as solutionBaseName ,t.PRICE,t.TIME_UNIT ")
+ .leftJoin(SolutionsBase.class,SolutionsBase::getId,Solutions::getParentId)
+ .in(Solutions::getId,hotSolutionList.stream().map(i->i.getDataFirst()).collect(Collectors.toList())));
+ if(CollectionUtils.isNotEmpty(solutionsList)){
+ for (DataListVO dataListVO:hotSolutionList) {
+ List<Solutions> solutions = solutionsList.stream().filter(i->Constants.equalsInteger(i.getId(),Integer.valueOf(dataListVO.getDataFirst()))).collect(Collectors.toList());
+ if(CollectionUtils.isNotEmpty(solutions)){
+ dataListVO.setSolutions(solutions.get(Constants.ZERO));
+ }
+ }
+ }
+ insuranceApplyReportDataVO.setHotSolutionList(hotSolutionList);
+ }
+
+ LoginUserInfo loginUserInfo = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
+ insuranceApplyReportDataVO.setMonthAddReduceList(this.getAddReduceData(loginUserInfo));
+ return insuranceApplyReportDataVO;
+ }
+
+
+
+ @Override
+ public List<DataListVO> getAddReduceData(LoginUserInfo loginUserInfo){
+ List<DataListVO> monthAddReduceList = new ArrayList<>();
+ for (int i = -11; i <= 0 ; i++) {
+ String month = DateUtil.DateToStr(
+ DateUtil.afterDateByType(new Date(),1,i),"yyyy-MM");
+ DataListVO dataListVO = new DataListVO();
+ dataListVO.setDataFirst(month);
+ dataListVO.setDataSecond(
+ applyChangeDetailJoinMapper.selectJoinCount(new MPJLambdaWrapper<ApplyChagneDetail>()
+ .leftJoin(ApplyChange.class,ApplyChange::getId,ApplyChagneDetail::getApplyChangeId)
+ .leftJoin(InsuranceApply.class,InsuranceApply::getId,ApplyChange::getApplyId)
+ .eq(ApplyChagneDetail::getType,Constants.ZERO)
+ .eq(Objects.nonNull(loginUserInfo)&&Constants.equalsInteger(loginUserInfo.getType(),Constants.ONE),InsuranceApply::getCompanyId,loginUserInfo.getCompanyId())
+ .apply(" DATE_FORMAT(t.CREATE_DATE, '%Y-%m') = '"+month+"'")
+ ) +""
+ );
+ dataListVO.setDataThird("-"+
+ applyChangeDetailJoinMapper.selectJoinCount(new MPJLambdaWrapper<ApplyChagneDetail>()
+ .leftJoin(ApplyChange.class,ApplyChange::getId,ApplyChagneDetail::getApplyChangeId)
+ .leftJoin(InsuranceApply.class,InsuranceApply::getId,ApplyChange::getApplyId)
+ .eq(ApplyChagneDetail::getType,Constants.ONE)
+ .eq(Objects.nonNull(loginUserInfo)&&Constants.equalsInteger(loginUserInfo.getType(),Constants.ONE)
+ ,InsuranceApply::getCompanyId,loginUserInfo.getCompanyId())
+ .apply(" DATE_FORMAT(t.CREATE_DATE, '%Y-%m') = '"+month+"'")
+ )
+ );
+ monthAddReduceList.add(dataListVO);
+ }
+ return monthAddReduceList;
+ }
+
+
+
+ @Override
+ public InsuranceApplyDataVO getInsuranceNum(){
+ List<InsuranceApply> insuranceApplyList = insuranceApplyJoinMapper.selectJoinList(InsuranceApply.class,
+ new MPJLambdaWrapper<InsuranceApply>()
+ .selectAll(InsuranceApply.class)
+ .selectAs(Solutions::getType, InsuranceApply::getSolutionType)
+ .leftJoin(Solutions.class, Solutions::getId, InsuranceApply::getSolutionId)
+ .eq(InsuranceApply::getIsdeleted, Constants.ZERO)
+ .notIn(InsuranceApply::getStatus,
+ Constants.InsuranceApplyStatus.COMPANY_BACK_APPLY_PASS.getKey(),
+ Constants.InsuranceApplyStatus.CLOSE.getKey(),
+ Constants.InsuranceApplyStatus.WTB_RETURN.getKey(),
+ Constants.InsuranceApplyStatus.WTB_CLOSED.getKey()
+ )
+ );
+ InsuranceApplyDataVO insuranceApplyDataVO = new InsuranceApplyDataVO();
+ //鐩翠繚淇濆崟鏁伴噺
+ insuranceApplyDataVO.setZbInsuranceNum(insuranceApplyList.stream().filter(i -> Constants.equalsInteger(i.getSolutionType(), Constants.ZERO)).collect(Collectors.toList()).size());
+ //濮旀墭淇濅繚鍗曟暟閲�
+ insuranceApplyDataVO.setWtbInsuranceNum(insuranceApplyList.stream().filter(i -> Constants.equalsInteger(i.getSolutionType(), Constants.ONE)).collect(Collectors.toList()).size());
+ return insuranceApplyDataVO;
+
+ }
+
+
+ @Override
+ public List<DataListVO> getSettleClaimsMoney(){
+ List<SettleClaims> settleClaimsList = settleClaimsMapper.selectList(new QueryWrapper<SettleClaims>().lambda()
+ .eq(SettleClaims::getStatus,Constants.SettleClaimsStatus.CLOSE_CASE.getKey())
+ .eq(SettleClaims::getIsdeleted,Constants.ZERO));
+ List<DataListVO> monthTotalMoneyDataList = new ArrayList<>();
+ for (int i = -11; i <= 0 ; i++) {
+ String month = DateUtil.DateToStr(
+ DateUtil.afterDateByType(new Date(),1,i),"yyyy-MM");
+ DataListVO dataListVO = new DataListVO();
+ dataListVO.setDataFirst(month);
+ if (CollectionUtils.isNotEmpty(settleClaimsList)) {
+ BigDecimal hpAccount = settleClaimsList.stream().filter(j->DateUtil.DateToStr(j.getCreateDate(),"yyyy-MM").equals(month))
+ .map(j->j.getHpAccount().add(j.getHpOtherAccount())).reduce(BigDecimal.ZERO,BigDecimal::add);
+ dataListVO.setDataSecond(hpAccount.compareTo(BigDecimal.ZERO)>Constants.ZERO?
+ hpAccount.divide(new BigDecimal("10000"),2,BigDecimal.ROUND_HALF_UP).toString():"0"
+ );
+ }else{
+ dataListVO.setDataSecond("0");
+ }
+
+ monthTotalMoneyDataList.add(dataListVO);
+ }
+ return monthTotalMoneyDataList;
+ }
+
+ @Override
+ public List<DataListVO> getInsuranceApplyStatusData(LoginUserInfo loginUserInfo){
+ List<DataListVO> dataListVOList = new ArrayList<>();
+ //寰呯敓鏁�
+ DataListVO dataListVOA = new DataListVO();
+ dataListVOA.setDataFirst("寰呯敓鏁�");
+ dataListVOA.setDataSecond(
+ insuranceApplyMapper.selectCount(new QueryWrapper<InsuranceApply>().lambda().eq(InsuranceApply::getIsdeleted,Constants.ZERO)
+ .in(InsuranceApply::getStatus,Constants.InsuranceApplyStatus.UPLOAD_INSURANCE.getKey(),Constants.InsuranceApplyStatus.WTB_DONE.getKey())
+ .eq(InsuranceApply::getCompanyId,loginUserInfo.getCompanyId())
+ .apply(" start_time > now() ")
+ ).toString()
+ );
+ dataListVOList.add(dataListVOA);
+
+ //淇濋殰涓�
+ DataListVO dataListVOB = new DataListVO();
+ dataListVOB.setDataFirst("淇濋殰涓�");
+ dataListVOB.setDataSecond(
+ insuranceApplyMapper.selectCount(new QueryWrapper<InsuranceApply>().lambda().eq(InsuranceApply::getIsdeleted,Constants.ZERO)
+ .in(InsuranceApply::getStatus,Constants.InsuranceApplyStatus.UPLOAD_INSURANCE.getKey(),Constants.InsuranceApplyStatus.WTB_DONE.getKey())
+ .eq(InsuranceApply::getCompanyId,loginUserInfo.getCompanyId())
+ .apply(" start_time <= now() and end_time >= now()")
+ ).toString()
+ );
+
+ dataListVOList.add(dataListVOB);
+
+ //宸茶繃鏈�
+ DataListVO dataListVOC = new DataListVO();
+ dataListVOC.setDataFirst("宸茶繃鏈�");
+
+ dataListVOC.setDataSecond(
+ insuranceApplyMapper.selectCount(new QueryWrapper<InsuranceApply>().lambda().eq(InsuranceApply::getIsdeleted,Constants.ZERO)
+ .in(InsuranceApply::getStatus,Constants.InsuranceApplyStatus.UPLOAD_INSURANCE.getKey(),Constants.InsuranceApplyStatus.WTB_DONE.getKey())
+ .eq(InsuranceApply::getCompanyId,loginUserInfo.getCompanyId())
+ .apply(" end_time < now()")
+ ).toString()
+ );
+ dataListVOList.add(dataListVOC);
+ return dataListVOList;
+ }
+
+
+
+
+ @Override
+ public List<DataListVO> getInsuranceMemberData(LoginUserInfo loginUserInfo){
+ List<DataListVO> dataListVOList = new ArrayList<>();
+ //寰呯敓鏁�
+ DataListVO dataListVOA = new DataListVO();
+ dataListVOA.setDataFirst("涓嶅湪淇�");
+ dataListVOA.setDataSecond(
+ applyDetailJoinMapper.selectJoinCount( new MPJLambdaWrapper<ApplyDetail>()
+ .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()
+
+ );
+ dataListVOList.add(dataListVOA);
+
+ //淇濋殰涓�
+ DataListVO dataListVOB = new DataListVO();
+ dataListVOB.setDataFirst("淇濋殰涓�");
+ dataListVOB.setDataSecond(
+ applyDetailJoinMapper.selectJoinCount( new MPJLambdaWrapper<ApplyDetail>()
+ .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()
+ );
+
+ dataListVOList.add(dataListVOB);
+ return dataListVOList;
+ }
+
+
}
--
Gitblit v1.9.3