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