| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161 | package org.jeecg.modules.system.service.impl;import java.util.ArrayList;import java.util.HashMap;import java.util.List;import java.util.Map;import java.util.stream.Collectors;import java.util.stream.Collectors;import com.baomidou.mybatisplus.core.conditions.Wrapper;import com.baomidou.mybatisplus.core.metadata.IPage;import com.baomidou.mybatisplus.extension.plugins.pagination.Page;import org.jeecg.common.util.oConvertUtils;import org.jeecg.modules.system.entity.SysDepart;import org.jeecg.modules.system.entity.SysUser;import org.jeecg.modules.system.entity.SysUserDepart;import org.jeecg.modules.system.mapper.SysUserDepartMapper;import org.jeecg.modules.system.model.DepartIdModel;import org.jeecg.modules.system.service.ISysDepartService;import org.jeecg.modules.system.service.ISysUserDepartService;import org.jeecg.modules.system.service.ISysUserService;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;/** * <P> * 用户部门表实现类 * <p/> * @Author ZhiLin *@since 2019-02-22 */@Servicepublic class SysUserDepartServiceImpl extends ServiceImpl<SysUserDepartMapper, SysUserDepart> implements ISysUserDepartService {	@Autowired	private ISysDepartService sysDepartService;	@Autowired	private ISysUserService sysUserService;		/**	 * 根据用户id查询部门信息	 */	@Override	public List<DepartIdModel> queryDepartIdsOfUser(String userId) {		LambdaQueryWrapper<SysUserDepart> queryUDep = new LambdaQueryWrapper<SysUserDepart>();		LambdaQueryWrapper<SysDepart> queryDep = new LambdaQueryWrapper<SysDepart>();		try {			queryUDep.eq(SysUserDepart::getUserId, userId);			List<String> depIdList = new ArrayList<>();			List<DepartIdModel> depIdModelList = new ArrayList<>();			List<SysUserDepart> userDepList = this.list(queryUDep);			if(userDepList != null && userDepList.size() > 0) {			for(SysUserDepart userDepart : userDepList) {					depIdList.add(userDepart.getDepId());				}			queryDep.in(SysDepart::getId, depIdList);			List<SysDepart> depList = sysDepartService.list(queryDep);			if(depList != null || depList.size() > 0) {				for(SysDepart depart : depList) {					depIdModelList.add(new DepartIdModel().convertByUserDepart(depart));				}			}			return depIdModelList;			}		}catch(Exception e) {			e.fillInStackTrace();		}		return null;					}	/**	 * 根据部门id查询用户信息	 */	@Override	public List<SysUser> queryUserByDepId(String depId) {		LambdaQueryWrapper<SysUserDepart> queryUDep = new LambdaQueryWrapper<SysUserDepart>();		queryUDep.eq(SysUserDepart::getDepId, depId);		List<String> userIdList = new ArrayList<>();		List<SysUserDepart> uDepList = this.list(queryUDep);		if(uDepList != null && uDepList.size() > 0) {			for(SysUserDepart uDep : uDepList) {				userIdList.add(uDep.getUserId());			}			List<SysUser> userList = (List<SysUser>) sysUserService.listByIds(userIdList);			//update-begin-author:taoyan date:201905047 for:接口调用查询返回结果不能返回密码相关信息			for (SysUser sysUser : userList) {				sysUser.setSalt("");				sysUser.setPassword("");			}			//update-end-author:taoyan date:201905047 for:接口调用查询返回结果不能返回密码相关信息			return userList;		}		return new ArrayList<SysUser>();	}	/**	 * 根据部门code,查询当前部门和下级部门的 用户信息	 */	@Override	public List<SysUser> queryUserByDepCode(String depCode,String realname) {		//update-begin-author:taoyan date:20210422 for: 根据部门选择用户接口代码优化		if(oConvertUtils.isNotEmpty(realname)){			realname = realname.trim();		}		List<SysUser> userList = this.baseMapper.queryDepartUserList(depCode, realname);		Map<String, SysUser> map = new HashMap<String, SysUser>();		for (SysUser sysUser : userList) {			// 返回的用户数据去掉密码信息			sysUser.setSalt("");			sysUser.setPassword("");			map.put(sysUser.getId(), sysUser);		}		return new ArrayList<SysUser>(map.values());		//update-end-author:taoyan date:20210422 for: 根据部门选择用户接口代码优化	}	@Override	public IPage<SysUser> queryDepartUserPageList(String departId, String username, String realname, int pageSize, int pageNo) {		IPage<SysUser> pageList = null;		// 部门ID不存在 直接查询用户表即可		Page<SysUser> page = new Page<SysUser>(pageNo, pageSize);		if(oConvertUtils.isEmpty(departId)){			LambdaQueryWrapper<SysUser> query = new LambdaQueryWrapper<>();			if(oConvertUtils.isNotEmpty(username)){				query.like(SysUser::getUsername, username);			}			pageList = sysUserService.page(page, query);		}else{			// 有部门ID 需要走自定义sql			SysDepart sysDepart = sysDepartService.getById(departId);			pageList = this.baseMapper.queryDepartUserPageList(page, sysDepart.getOrgCode(), username, realname);		}		List<SysUser> userList = pageList.getRecords();		if(userList!=null && userList.size()>0){			List<String> userIds = userList.stream().map(SysUser::getId).collect(Collectors.toList());			Map<String, SysUser> map = new HashMap<String, SysUser>();			if(userIds!=null && userIds.size()>0){				// 查部门名称				Map<String,String>  useDepNames = sysUserService.getDepNamesByUserIds(userIds);				userList.forEach(item->{					//TODO 临时借用这个字段用于页面展示					item.setOrgCodeTxt(useDepNames.get(item.getId()));					item.setSalt("");					item.setPassword("");					// 去重					map.put(item.getId(), item);				});			}			pageList.setRecords(new ArrayList<SysUser>(map.values()));		}		return pageList;	}}
 |