#

LSH

2023-12-07 df5e0dee7606532ec5ab226fc4114dfeb3949565

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
package com.zy.crm.manager.controller;
 
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.core.annotations.ManagerAuth;
import com.core.common.R;
import com.zy.crm.common.web.BaseController;
import com.zy.crm.manager.entity.ContractSales;
import com.zy.crm.manager.entity.Plan;
import com.zy.crm.manager.entity.PlanType;
import com.zy.crm.manager.entity.ProcessPermissions;
import com.zy.crm.manager.service.PlanService;
import com.zy.crm.manager.service.PlanTypeService;
import com.zy.crm.manager.service.ProcessPermissionsService;
import com.zy.crm.system.entity.User;
import com.zy.crm.system.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
 
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
 
@RestController
public class BIController extends BaseController {
 
    @Autowired
    private PlanService planService;
    @Autowired
    private PlanTypeService planTypeService;
    @Autowired
    private UserService userService;
    @Autowired
    private ProcessPermissionsService processPermissionsService;
 
    @RequestMapping(value = "/pending/approval/auth")
    @ManagerAuth
    public R get() {
        // 传入用户id查询规划单 区分，通过区分出来的规划单类型查询 规划申请单
        //
        EntityWrapper<Plan> wrapper = new EntityWrapper<>();
        wrapper.setSqlSelect("user_id");
        wrapper.eq("settle",2).eq("assistant_host_sign",0).groupBy("user_id");
        List<Map<String, Object>> maps = planService.selectMaps(wrapper);
        return R.ok().add(maps);
    }
 
    @RequestMapping(value = "/pending/user/approval/auth")
    @ManagerAuth
    public R getPlanByUser() {
        PlanType planType = new PlanType();
        planType.setType(1);
        planType.setType(1);
        User planLeader = planTypeService.findPlanLeader(planType);
        List<User> users = userService.selectList(new EntityWrapper<User>().eq("dept_id", planLeader.getDeptId()));
        List<ProcessPermissions> processPermissionsList = processPermissionsService.selectList(new EntityWrapper<ProcessPermissions>().eq("process_memo", 101));
        for (ProcessPermissions processPermissions:processPermissionsList){
            User user = userService.selectById(processPermissions.getUserId());
            users.add(user);
        }
        List<Map<String, Object>> result = new ArrayList<>();
 
        for (User user:users){
            List<Plan> plans = planService.selctPlanListByDirector(user.getId());
            String userList = "";
            for (Plan plan:plans){
                userList = userList+","+plan.getUserId$();
            }
            int director = planService.selectCount(new EntityWrapper<Plan>().eq("director", user.getId()));
 
 
            Map<String, Object> map = new HashMap<>();
            map.put("user", user.getNickname());
            map.put("value", userList);
            map.put("anfme", director);
            result.add(map);
        }
 
//        List<PlanType> planTypes = planTypeService.selectList(new EntityWrapper<PlanType>().eq("type", "1").eq("host_id",1));
//        for (PlanType planType2:planTypes){
//
//        }
 
        // 传入用户id查询规划单 区分，通过区分出来的规划单类型查询 规划申请单
        //
        EntityWrapper<Plan> wrapper = new EntityWrapper<>();
        wrapper.setSqlSelect("user_id");
        wrapper.eq("settle",2).eq("assistant_host_sign",0).groupBy("user_id");
        List<Map<String, Object>> maps = planService.selectMaps(wrapper);
        return R.ok().add(maps);
    }
}