#完善工具类

LSH

2024-03-26 861efe8a7ddc3d52dddbcce83d3a43f476a7418c

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