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
- */
- @Service
- public 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;
- }
- }
|