| | |
|---|
| | | import com.doumee.dao.business.YwPatrolTaskMapper; |
|---|
| | | import com.doumee.dao.business.YwPatrolTaskRecordMapper; |
|---|
| | | import com.doumee.dao.business.model.*; |
|---|
| | | import com.doumee.dao.system.SystemUserMapper; |
|---|
| | | import com.doumee.dao.system.model.SystemUser; |
|---|
| | | import com.doumee.service.business.YwPatrolSchemeService; |
|---|
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
|---|
| | |
|---|
| | | private YwLinePointMapper ywLinePointMapper; |
|---|
| | | @Autowired |
|---|
| | | private YwPatrolTaskRecordMapper ywPatrolTaskRecordMapper; |
|---|
| | | @Autowired |
|---|
| | | private SystemUserMapper systemUserMapper; |
|---|
| | | @Autowired |
|---|
| | | private RedisTemplate<String, Object> redisTemplate; |
|---|
| | | |
|---|
| | |
|---|
| | | YwPatrolScheme model = pageWrap.getModel(); |
|---|
| | | queryWrapper.selectAll(YwPatrolScheme.class) |
|---|
| | | .select(" t2.realName as createUserName ") |
|---|
| | | .select(" t1.realName as userName ") |
|---|
| | | .leftJoin(SystemUser.class,SystemUser::getId,YwPatrolScheme::getUserIds) |
|---|
| | | // .select(" t1.realName as userName ") |
|---|
| | | // .leftJoin(SystemUser.class,SystemUser::getId,YwPatrolScheme::getUserIds) |
|---|
| | | .leftJoin(" system_user t2 on t.creator = t2.id ") |
|---|
| | | .eq(YwPatrolScheme::getIsdeleted,Constants.ZERO) |
|---|
| | | .like(StringUtils.isNotBlank(model.getTitle()),YwPatrolScheme::getTitle,model.getTitle()) |
|---|
| | |
|---|
| | | IPage<YwPatrolScheme> iPage = ywPatrolSchemeMapper.selectJoinPage(page,YwPatrolScheme.class,queryWrapper); |
|---|
| | | for (YwPatrolScheme ywPatrolScheme:iPage.getRecords()) { |
|---|
| | | this.getSchemeStatus(ywPatrolScheme); |
|---|
| | | //巡检人员 |
|---|
| | | this.getUserNames(ywPatrolScheme); |
|---|
| | | } |
|---|
| | | return PageData.from(iPage); |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | public void getUserNames(YwPatrolScheme ywPatrolScheme){ |
|---|
| | | if(Objects.nonNull(ywPatrolScheme)&&StringUtils.isNotBlank(ywPatrolScheme.getUserIds())){ |
|---|
| | | List<SystemUser> systemUserList = systemUserMapper.selectList(new QueryWrapper<SystemUser>().lambda() |
|---|
| | | .apply(" find_in_set(id,'"+ywPatrolScheme.getUserIds()+"') ") |
|---|
| | | ); |
|---|
| | | String userName = String.join(",",systemUserList.stream().map(i->i.getRealname()).collect(Collectors.toList())); |
|---|
| | | ywPatrolScheme.setUserName(userName); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | //获取状态 |
|---|
| | | public void getSchemeStatus(YwPatrolScheme ywPatrolScheme){ |
|---|
| | | List<YwPatrolTask> ywPatrolTaskList = ywPatrolTaskMapper.selectList(new QueryWrapper<YwPatrolTask>().lambda() |
|---|
