From 4a8ff39b0fab0627ef8f7459587d514cc01c3676 Mon Sep 17 00:00:00 2001
From: rk <94314517@qq.com>
Date: 星期一, 20 十月 2025 10:52:02 +0800
Subject: [PATCH] Merge branch 'wuhuyancao' of http://139.186.142.91:10010/r/productDev/dmvisit into wuhuyancao
---
server/system_service/src/main/java/com/doumee/service/system/impl/SystemUserServiceImpl.java | 137 ++++++++++++++++++++++++++++++++++++++-------
1 files changed, 115 insertions(+), 22 deletions(-)
diff --git a/server/system_service/src/main/java/com/doumee/service/system/impl/SystemUserServiceImpl.java b/server/system_service/src/main/java/com/doumee/service/system/impl/SystemUserServiceImpl.java
index 087530c..0a045a9 100644
--- a/server/system_service/src/main/java/com/doumee/service/system/impl/SystemUserServiceImpl.java
+++ b/server/system_service/src/main/java/com/doumee/service/system/impl/SystemUserServiceImpl.java
@@ -2,18 +2,22 @@
import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.doumee.biz.system.SystemDictDataBiz;
-import com.doumee.core.model.PageData;
-import com.doumee.core.model.PageWrap;
+import com.doumee.dao.business.model.Member;
+import com.doumee.service.business.third.model.PageData;
+import com.doumee.service.business.third.model.PageWrap;
import com.doumee.core.utils.Constants;
import com.doumee.core.utils.Utils;
+import com.doumee.dao.business.model.Company;
import com.doumee.dao.system.SystemUserJoinMapper;
import com.doumee.dao.system.SystemUserMapper;
import com.doumee.dao.system.dto.QuerySystemUserDTO;
-import com.doumee.dao.system.model.SystemDepartment;
import com.doumee.dao.system.model.SystemUser;
import com.doumee.dao.system.vo.SystemDepartmentListVO;
import com.doumee.dao.system.vo.SystemUserListVO;
+import com.doumee.dao.system.vo.UserResponse;
import com.doumee.service.aware.DepartmentDataPermissionAware;
import com.doumee.service.system.SystemDepartmentService;
import com.doumee.service.system.SystemPositionService;
@@ -30,7 +34,7 @@
import java.util.ArrayList;
import java.util.List;
-import java.util.stream.Collectors;
+import java.util.Objects;
/**
* 绯荤粺鐢ㄦ埛Service瀹炵幇
@@ -111,14 +115,34 @@
@Override
public SystemUser findOne(SystemUser systemUser) {
- Wrapper<SystemUser> wrapper = new QueryWrapper<>(systemUser);
- return systemUserMapper.selectOne(wrapper);
+ QueryWrapper<SystemUser> wrapper = new QueryWrapper<SystemUser>(systemUser);
+ return systemUserMapper.selectOne(wrapper.lambda().last("limit 1"));
}
@Override
public List<SystemUser> findList(SystemUser systemUser) {
- Wrapper<SystemUser> wrapper = new QueryWrapper<>(systemUser);
- return systemUserMapper.selectList(wrapper);
+ MPJLambdaWrapper<SystemUser> wrapper = new MPJLambdaWrapper<>();
+ wrapper.selectAll(SystemUser.class )
+ .selectAs(Company::getName,SystemUser::getCompanyName)
+ .eq(SystemUser::getDeleted,Constants.ZERO)
+ .leftJoin(Company.class,Company::getId,SystemUser::getCompanyId)
+ .eq( systemUser.getCompanyId() !=null,SystemUser::getCompanyId,systemUser.getCompanyId())
+ .eq( systemUser.getCompanyType() !=null,Company::getType,systemUser.getCompanyType())
+ .like(StringUtils.isNotBlank(systemUser.getRealname()),SystemUser::getRealname,systemUser.getRealname())
+ .like(StringUtils.isNotBlank(systemUser.getMobile()),SystemUser::getMobile,systemUser.getMobile())
+ .like(StringUtils.isNotBlank(systemUser.getUsername()),SystemUser::getUsername,systemUser.getUsername())
+ .like(StringUtils.isNotBlank(systemUser.getCompanyName()),Company::getName,systemUser.getCompanyName())
+ .orderByAsc( Company::getPinyin )
+ .orderByAsc(SystemUser::getPinyin)
+ ;
+ return systemUserMapper.selectJoinList(SystemUser.class,wrapper);
+ }
+
+ @Override
+ public List<UserResponse> getUserList(Integer bookingsId) {
+ return systemUserMapper.getUserList(new QueryWrapper<UserResponse>()
+ .exists(" select 1 from meeting_user_rel u where u.USER_ID = c.id and u.ISDELETED = 0 and u.OBJ_ID = "+bookingsId+" and u.OBJ_TYPE = 1 ")
+ );
}
@Override
@@ -131,6 +155,15 @@
List<Integer> collect = list.stream().map(s -> s.getId()).collect(Collectors.toList());
pageWrap.getModel().setDepartmentIds(collect);
}*/
+
+ //鏌ヨ鐗规畩鐨�42浜洪厤缃�
+ if(Objects.nonNull(pageWrap.getModel()) && Constants.equalsInteger(pageWrap.getModel().getQuerySpecial(),Constants.ONE)){
+ String companySpecialId = systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.SPECIAL_COMPANY_ID).getCode();
+ if(StringUtils.isNotBlank(companySpecialId)){
+ pageWrap.getModel().setCompanySpecialId(companySpecialId);
+ }
+ }
+
// 鎵ц鏌ヨ
PageHelper.startPage(pageWrap.getPage(), pageWrap.getCapacity());
List<SystemUserListVO> userList = systemUserMapper.selectManageList(pageWrap.getModel(), pageWrap.getOrderByClause());
@@ -141,6 +174,19 @@
// user.setPositions(systemPositionService.findByUserId(user.getId()));
}
return PageData.from(new PageInfo<>(userList));
+ }
+ @Override
+ public PageData<SystemUser> findDriverPage(PageWrap<SystemUser> pageWrap) {
+ IPage<SystemUser> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity());
+ QueryWrapper<SystemUser> queryWrapper = new QueryWrapper<>();
+ Utils.MP.blankToNull(pageWrap.getModel());
+ queryWrapper.lambda()
+ .like(StringUtils.isNotBlank(pageWrap.getModel().getRealname()),SystemUser::getRealname,pageWrap.getModel().getRealname())
+ .like(StringUtils.isNotBlank(pageWrap.getModel().getMobile()),SystemUser::getMobile,pageWrap.getModel().getMobile())
+ .like(StringUtils.isNotBlank(pageWrap.getModel().getUsername()),SystemUser::getUsername,pageWrap.getModel().getUsername())
+ .eq( pageWrap.getModel().getType()!=null,SystemUser::getType,pageWrap.getModel().getType())
+ .eq (SystemUser::getDeleted,Constants.ZERO);
+ return PageData.from(systemUserMapper.selectPage(page, queryWrapper));
}
@Override
@@ -197,22 +243,54 @@
@Override
- public List<SystemUser> findAllList(SystemUser pageWrap) {
+ public List<SystemUser> findAllList(SystemUser systemUser) {
+ //鏌ヨ鐗规畩鐨�42浜洪厤缃�
+ if( Constants.equalsInteger(systemUser.getQuerySpecial(),Constants.ONE)){
+ String companySpecialId = systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.SPECIAL_COMPANY_ID).getCode();
+ if(StringUtils.isNotBlank(companySpecialId)){
+ systemUser.setCompanySpecialId(companySpecialId);
+ }
+ }
- MPJLambdaWrapper<SystemUser> queryWrapper = new MPJLambdaWrapper<>();
- Utils.MP.blankToNull(pageWrap);
- queryWrapper.selectAll(SystemUser.class);
- queryWrapper.eq(SystemUser::getDeleted, Constants.ZERO);
- queryWrapper.and(StringUtils.isNotBlank(pageWrap.getUsername()),ms->ms.like(SystemUser::getUsername,pageWrap.getUsername())
- .or().like(SystemUser::getMobile,pageWrap.getUsername())
- .or().like(SystemUser::getRealname,pageWrap.getUsername())
- );
- queryWrapper.orderByDesc(SystemUser::getCreateTime);
-
-
-
- List<SystemUser> result = systemUserJoinMapper.selectJoinList( SystemUser.class, queryWrapper);
+ MPJLambdaWrapper<SystemUser> wrapper = new MPJLambdaWrapper<>();
+ wrapper.selectAll(SystemUser.class )
+ .selectAs(Company::getCompanyNamePath,SystemUser::getCompanyName)
+ .selectAs(Member::getFaceImg,SystemUser::getFaceImg)
+ .eq(SystemUser::getDeleted,Constants.ZERO)
+ .leftJoin(Company.class,Company::getId,SystemUser::getCompanyId)
+ .leftJoin(Member.class,Member::getId,SystemUser::getMemberId)
+ .leftJoin(" position p on p.id = t2.POSITION_ID ")
+ .and(StringUtils.isNotBlank(systemUser.getUsername()),ms->ms.like(SystemUser::getUsername,systemUser.getUsername())
+ .or().like(SystemUser::getMobile,systemUser.getUsername())
+ .or().like(SystemUser::getRealname,systemUser.getUsername()))
+ .and(StringUtils.isNotBlank(systemUser.getQueryParam()),ms->ms.like(SystemUser::getUsername,systemUser.getUsername())
+ .or().like(SystemUser::getMobile,systemUser.getQueryParam())
+ .or().like(Company::getName,systemUser.getQueryParam())
+ .or().like(SystemUser::getRealname,systemUser.getQueryParam()))
+ .eq( systemUser.getCompanyId() !=null,SystemUser::getCompanyId,systemUser.getCompanyId())
+ .eq( systemUser.getCompanyType() !=null,Company::getType,systemUser.getCompanyType())
+ .eq( systemUser.getWorkStatus() !=null,Member::getWorkStatus,systemUser.getWorkStatus())
+ .like(StringUtils.isNotBlank(systemUser.getRealname()),SystemUser::getRealname,systemUser.getRealname())
+ .like(StringUtils.isNotBlank(systemUser.getMobile()),SystemUser::getMobile,systemUser.getMobile())
+ .like(StringUtils.isNotBlank(systemUser.getUsername()),SystemUser::getUsername,systemUser.getUsername())
+ .like(StringUtils.isNotBlank(systemUser.getCompanyName()),Company::getName,systemUser.getCompanyName())
+ .apply(StringUtils.isNotBlank(systemUser.getCompanySpecialId())," find_in_set('"+systemUser.getCompanySpecialId()+"',REPLACE(t1.company_path,'/',','))")
+ .orderByAsc( Company::getSortnum )
+ .orderByAsc( " p.SORTNUM " )
+ .orderByAsc(SystemUser::getPinyin)
+ ;
+ List<SystemUser> result = systemUserJoinMapper.selectJoinList( SystemUser.class, wrapper);
+ if(result!=null){
+ String prefixUrl = systemDictDataBiz.queryByCode(Constants.FTP,Constants.FTP_RESOURCE_PATH).getCode() +
+ systemDictDataBiz.queryByCode(Constants.FTP,Constants.MEMBER_IMG).getCode();
+ for (SystemUser memberInfoDTO:result) {
+ //鎷兼帴鍓嶇紑
+ if (StringUtils.isNotBlank(memberInfoDTO.getFaceImg())) {
+ memberInfoDTO.setFaceImg(prefixUrl + memberInfoDTO.getFaceImg());
+ }
+ }
+ }
return result;
}
@@ -221,5 +299,20 @@
+ @Override
+ public List<SystemUser> findInternalList() {
+ MPJLambdaWrapper<SystemUser> queryWrapper = new MPJLambdaWrapper<>();
+ queryWrapper.selectAll(SystemUser.class);
+ queryWrapper.eq(SystemUser::getDeleted, Constants.ZERO);
+ queryWrapper.leftJoin(Company.class,Company::getId,SystemUser::getCompanyId)
+ .leftJoin(" position p on p.id = t2.POSITION_ID ");
+ queryWrapper.eq(Company::getType,Constants.ONE)
+ .orderByAsc( Company::getSortnum )
+ .orderByAsc( " p.SORTNUM " )
+ .orderByAsc(SystemUser::getPinyin);
+ List<SystemUser> result = systemUserJoinMapper.selectJoinList( SystemUser.class, queryWrapper);
+ return result;
+ }
+
}
--
Gitblit v1.9.3