From 453ee097563df5788f96e102b38249f0ca70d82a Mon Sep 17 00:00:00 2001
From: xuhy <3313886187@qq.com>
Date: 星期二, 14 十月 2025 18:41:54 +0800
Subject: [PATCH] 诊所和供应商首页统计

---
 ruoyi-admin/src/main/java/com/ruoyi/web/controller/task/TaskUtil.java |   40 ++++++++++++++++++++++++++++++++++++++++
 1 files changed, 40 insertions(+), 0 deletions(-)

diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/task/TaskUtil.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/task/TaskUtil.java
index 49621b3..1550b2e 100644
--- a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/task/TaskUtil.java
+++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/task/TaskUtil.java
@@ -1,17 +1,29 @@
 package com.ruoyi.web.controller.task;
 
 import com.alibaba.fastjson2.JSONObject;
+import com.baomidou.mybatisplus.core.toolkit.Wrappers;
 import com.ruoyi.common.constant.Constants;
 import com.ruoyi.common.core.domain.R;
 import com.ruoyi.common.core.redis.RedisCache;
 import com.ruoyi.common.utils.http.HttpUtils;
+import com.ruoyi.system.model.TCrmClinic;
+import com.ruoyi.system.model.TErpProcurement;
+import com.ruoyi.system.service.TCrmClinicService;
+import com.ruoyi.system.service.TErpProcurementService;
 import com.ruoyi.system.utils.util.AIUtil;
+import com.ruoyi.system.vo.TCrmClinicVO;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.scheduling.annotation.Scheduled;
 import org.springframework.stereotype.Component;
+import org.springframework.util.CollectionUtils;
 
+import java.math.BigDecimal;
 import java.time.LocalDate;
+import java.util.Arrays;
+import java.util.List;
+import java.util.Objects;
 import java.util.Set;
+import java.util.stream.Collectors;
 
 /**
  * @author xiaochen
@@ -24,6 +36,10 @@
     private RedisCache redisCache;
     @Autowired
     private AIUtil aiUtil;
+    @Autowired
+    private TCrmClinicService crmClinicService;
+    @Autowired
+    private TErpProcurementService erpProcurementService;
 
     @Scheduled(fixedRate = 86460000)
 //    @Scheduled(cron = "10 0 0 * * ?")
@@ -44,5 +60,29 @@
         }
     }
 
+    @Scheduled(cron = "0 0 0 L * ?")
+    public void monthUpdateClinicPerformance() {
+        try {
+            // 判断哪些诊所本月没有业绩达标
+            List<TCrmClinic> clinics = crmClinicService.list();
+            List<TErpProcurement> procurements = erpProcurementService.list(Wrappers.lambdaQuery(TErpProcurement.class)
+                    .in(TErpProcurement::getStatus, Arrays.asList(3,4,5))
+                    .likeRight(TErpProcurement::getCreateTime, LocalDate.now()));
+            for (TCrmClinic clinic : clinics) {
+                List<TErpProcurement> procurementList = procurements.stream().filter(procurement -> procurement.getClinicId().equals(clinic.getId())).collect(Collectors.toList());
+                if(!CollectionUtils.isEmpty(procurementList)){
+                    BigDecimal monthPurchaseAmount = procurementList.stream().map(TErpProcurement::getPayMoney).reduce(BigDecimal.ZERO, BigDecimal::add);
+                    // 未达标
+                    if(monthPurchaseAmount.compareTo(clinic.getLowProcurementMoney())<0){
+                        clinic.setPerformanceCount(clinic.getPerformanceCount()+1);
+                    }
+                }
+            }
+            crmClinicService.updateBatchById(clinics);
+        } catch (Exception e) {
+            e.printStackTrace();
+        }
+    }
+
 
 }

--
Gitblit v1.7.1