From 13a34d2197b001799ef8f0f09e5b48af2add0926 Mon Sep 17 00:00:00 2001 From: lsh <lsh@163.com> Date: 星期一, 15 四月 2024 09:25:31 +0800 Subject: [PATCH] # --- src/main/java/com/zy/crm/manager/controller/BIController.java | 16 ++++++++++------ 1 files changed, 10 insertions(+), 6 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 ba184bd..911b619 100644 --- a/src/main/java/com/zy/crm/manager/controller/BIController.java +++ b/src/main/java/com/zy/crm/manager/controller/BIController.java @@ -34,13 +34,17 @@ private ProcessPermissionsService processPermissionsService; @RequestMapping(value = "/pending/approval/auth") - @ManagerAuth + //@ManagerAuth 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(); @@ -54,7 +58,7 @@ } @RequestMapping(value = "/pending/user/approval/auth") - @ManagerAuth + //@ManagerAuth public R getPlanByUser() { PlanType planType = new PlanType(); planType.setType(2); @@ -95,7 +99,7 @@ @RequestMapping(value = "/pending/sum/auth") - @ManagerAuth + //@ManagerAuth public R getAllPlan() { EntityWrapper<Plan> wrapper = new EntityWrapper<>(); wrapper.setSqlSelect("count(0) count","MONTH(create_time) month"); @@ -105,7 +109,7 @@ } @RequestMapping(value = "/user/sumyear/auth") - @ManagerAuth + //@ManagerAuth public R getUserYear() { PlanType planType = new PlanType(); planType.setType(2); -- Gitblit v1.9.1