From cdf974d19bab00ac22fe2896eb34b920d58d74a6 Mon Sep 17 00:00:00 2001 From: renkang <8417338+k94314517@user.noreply.gitee.com> Date: 星期四, 09 一月 2025 18:30:40 +0800 Subject: [PATCH] 客户资料 巡检任务业务 --- server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwPatrolSchemeServiceImpl.java | 21 +++++++++++++++++++-- 1 files changed, 19 insertions(+), 2 deletions(-) diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwPatrolSchemeServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwPatrolSchemeServiceImpl.java index 375b2f6..96a4593 100644 --- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwPatrolSchemeServiceImpl.java +++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwPatrolSchemeServiceImpl.java @@ -15,6 +15,7 @@ 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; @@ -48,6 +49,8 @@ private YwLinePointMapper ywLinePointMapper; @Autowired private YwPatrolTaskRecordMapper ywPatrolTaskRecordMapper; + @Autowired + private SystemUserMapper systemUserMapper; @Autowired private RedisTemplate<String, Object> redisTemplate; @@ -315,8 +318,8 @@ 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()) @@ -333,10 +336,24 @@ 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() -- Gitblit v1.9.3