From d91c343a39c795cf66638e71f6a7f2f1eb029e6b Mon Sep 17 00:00:00 2001
From: LSH
Date: 星期四, 28 三月 2024 15:22:40 +0800
Subject: [PATCH] #周计划
---
src/main/java/com/zy/crm/manager/controller/BIController.java | 8 ++++++--
1 files changed, 6 insertions(+), 2 deletions(-)
diff --git a/src/main/java/com/zy/crm/manager/controller/BIController.java b/src/main/java/com/zy/crm/manager/controller/BIController.java
index c62dc2e..911b619 100644
--- a/src/main/java/com/zy/crm/manager/controller/BIController.java
+++ b/src/main/java/com/zy/crm/manager/controller/BIController.java
@@ -38,9 +38,13 @@
public R get() {
// 浼犲叆鐢ㄦ埛id鏌ヨ瑙勫垝鍗� 鍖哄垎锛岄�氳繃鍖哄垎鍑烘潵鐨勮鍒掑崟绫诲瀷鏌ヨ 瑙勫垝鐢宠鍗�
//
+ PlanType planType = new PlanType();
+ planType.setType(2);
+ planType.setHostId(1L);
+ User planLeader = planTypeService.findPlanLeader(planType);
EntityWrapper<Plan> wrapper = new EntityWrapper<>();
- wrapper.setSqlSelect("user_id","director","count(id) count");
- wrapper.eq("settle",2).eq("assistant_host_sign",0).groupBy("user_id,director");
+ wrapper.setSqlSelect("user_id","director","count(id) as count");
+ wrapper.eq("director",planLeader.getId()).eq("settle",1).eq("assistant_host_sign",0).groupBy("user_id,director");
List<Map<String, Object>> maps = planService.selectMaps(wrapper);
for (Map<String, Object> map : maps) {
String user_id = map.get("user_id").toString();
--
Gitblit v1.9.1