From 09ee5added9d59e90310a2586e846137ea597b19 Mon Sep 17 00:00:00 2001
From: LSH
Date: 星期五, 01 十二月 2023 13:15:42 +0800
Subject: [PATCH] #

---
 src/main/java/com/zy/crm/manager/service/impl/PlanServiceImpl.java   |    5 +++++
 src/main/resources/mapper/PlanMapper.xml                             |    7 +++++++
 src/main/java/com/zy/crm/manager/controller/DashboardController.java |    2 +-
 src/main/java/com/zy/crm/manager/service/PlanService.java            |    1 +
 src/main/java/com/zy/crm/manager/mapper/PlanMapper.java              |    1 +
 5 files changed, 15 insertions(+), 1 deletions(-)

diff --git a/src/main/java/com/zy/crm/manager/controller/DashboardController.java b/src/main/java/com/zy/crm/manager/controller/DashboardController.java
index 910bff4..78be2fb 100644
--- a/src/main/java/com/zy/crm/manager/controller/DashboardController.java
+++ b/src/main/java/com/zy/crm/manager/controller/DashboardController.java
@@ -133,7 +133,7 @@
         map.put("successCount", successCount);
 
         //鑾峰彇寰呭鐞嗕换鍔℃暟閲�
-        int planPendingTaskCount = planService.selectCount(new EntityWrapper<Plan>().eq("director", getUserId()).lt("settle",4));
+        int planPendingTaskCount = planService.selectPendingTaskCount(getUserId());
         map.put("planPendingTaskCount", planPendingTaskCount);
         int priOnlinePendingTaskCount = priOnline2Service.selectCount(new EntityWrapper<PriOnline2>().eq("member_id", getUserId()).lt("settle",2));
         map.put("priOnlinePendingTaskCount", priOnlinePendingTaskCount);
diff --git a/src/main/java/com/zy/crm/manager/mapper/PlanMapper.java b/src/main/java/com/zy/crm/manager/mapper/PlanMapper.java
index 621e0f3..f897021 100644
--- a/src/main/java/com/zy/crm/manager/mapper/PlanMapper.java
+++ b/src/main/java/com/zy/crm/manager/mapper/PlanMapper.java
@@ -14,6 +14,7 @@
 public interface PlanMapper extends BaseMapper<Plan> {
 
     Plan selectByUuid(@Param("hostId") Long hostId, @Param("uuid") String uuid);
+    Integer selectPendingTaskCount(@Param("director") Long director);
 
     Plan selectPlanByNewestUuid(@Param("hostId") Long hostId);
 
diff --git a/src/main/java/com/zy/crm/manager/service/PlanService.java b/src/main/java/com/zy/crm/manager/service/PlanService.java
index c19af2c..d0c3ac1 100644
--- a/src/main/java/com/zy/crm/manager/service/PlanService.java
+++ b/src/main/java/com/zy/crm/manager/service/PlanService.java
@@ -9,6 +9,7 @@
 public interface PlanService extends IService<Plan> {
 
     Plan selectByUuid(Long hostId, String uuid);
+    Integer selectPendingTaskCount(Long director);
 
     String getUuid(Long hostId);
 
diff --git a/src/main/java/com/zy/crm/manager/service/impl/PlanServiceImpl.java b/src/main/java/com/zy/crm/manager/service/impl/PlanServiceImpl.java
index f5b0165..34ca013 100644
--- a/src/main/java/com/zy/crm/manager/service/impl/PlanServiceImpl.java
+++ b/src/main/java/com/zy/crm/manager/service/impl/PlanServiceImpl.java
@@ -20,6 +20,11 @@
     }
 
     @Override
+    public Integer selectPendingTaskCount(Long director) {
+        return this.baseMapper.selectPendingTaskCount(director);
+    }
+
+    @Override
     public String getUuid(Long hostId) {
         String uuid = null;
         int times = 0;
diff --git a/src/main/resources/mapper/PlanMapper.xml b/src/main/resources/mapper/PlanMapper.xml
index bbdfb4c..5d8bf24 100644
--- a/src/main/resources/mapper/PlanMapper.xml
+++ b/src/main/resources/mapper/PlanMapper.xml
@@ -121,4 +121,11 @@
         ORDER BY mp.update_time DESC,mp.create_time DESC
     </select>
 
+    <select id="selectPendingTaskCount" resultType="java.lang.Integer">
+        select count(1) from man_plan
+        where 1=1
+        and director = #{director}
+        and settle &lt; settle_size
+    </select>
+
 </mapper>

--
Gitblit v1.9.1