#

LSH

2023-12-16 514ced16d0d2aa62f042e7c10fbe81e1539578b3

#

 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();