package com.doumee.service.business.impl; import cn.binarywang.wx.miniapp.bean.WxMaJscode2SessionResult; import com.doumee.biz.system.SystemDictDataBiz; import com.doumee.biz.zbom.model.IamUserRoleModel; import com.doumee.biz.zbom.model.IamUserTypeModel; import com.doumee.config.Jwt.JwtPayLoad; import com.doumee.config.Jwt.JwtTokenUtil; import com.doumee.core.annotation.excel.ExcelImporter; import com.doumee.core.constants.ResponseStatus; import com.doumee.core.exception.BusinessException; import com.doumee.core.model.LoginUserInfo; import com.doumee.core.model.PageData; import com.doumee.core.model.PageWrap; import com.doumee.core.utils.Constants; import com.doumee.core.utils.Utils; import com.doumee.dao.admin.request.ShopImport; import com.doumee.dao.admin.request.UserImport; import com.doumee.dao.business.ShopMapper; import com.doumee.core.wx.WxMiniConfig; import com.doumee.dao.business.SmsEmailMapper; import com.doumee.dao.business.UsersMapper; import com.doumee.dao.business.model.*; import com.doumee.dao.system.model.SystemUser; import com.doumee.dao.web.response.AccountResponse; import com.doumee.service.business.UsersService; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.github.yulichang.wrapper.MPJLambdaWrapper; import org.apache.catalina.User; import org.apache.commons.lang3.StringUtils; import me.chanjar.weixin.common.error.WxErrorException; import org.apache.commons.lang3.StringUtils; import org.apache.shiro.SecurityUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.data.redis.core.RedisTemplate; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import org.springframework.util.CollectionUtils; import org.springframework.web.multipart.MultipartFile; import java.util.ArrayList; import java.util.Date; import java.util.List; import java.util.Objects; import java.util.concurrent.Callable; import java.util.concurrent.ExecutorService; import java.util.concurrent.Executors; /** * 员工信息表Service实现 * @author 江蹄蹄 * @date 2024/07/04 14:40 */ @Service public class UsersServiceImpl implements UsersService { ExecutorService executor = Executors.newFixedThreadPool(1); @Autowired private RedisTemplate redisTemplate; @Autowired private UsersMapper usersMapper; @Autowired private ShopMapper shopMapper; @Autowired private SmsEmailMapper smsEmailMapper; @Autowired private SystemDictDataBiz systemDictDataBiz; @Override public Long create(Users users) { usersMapper.insert(users); return users.getId(); } @Override public void deleteById(Long id) { usersMapper.deleteById(id); } @Override public void delete(Users users) { UpdateWrapper deleteWrapper = new UpdateWrapper<>(users); usersMapper.delete(deleteWrapper); } @Override public void deleteByIdInBatch(List ids) { if (CollectionUtils.isEmpty(ids)) { return; } usersMapper.deleteBatchIds(ids); } @Override public void updateById(Users users) { usersMapper.updateById(users); } @Override public void updateByIdInBatch(List userss) { if (CollectionUtils.isEmpty(userss)) { return; } for (Users users: userss) { this.updateById(users); } } @Override public Users findById(Long id) { return usersMapper.selectById(id); } @Override public Users findOne(Users users) { QueryWrapper wrapper = new QueryWrapper<>(users); return usersMapper.selectOne(wrapper); } @Override public List findList(Users users) { QueryWrapper wrapper = new QueryWrapper<>(users); return usersMapper.selectList(wrapper); } @Override public PageData findPage(PageWrap pageWrap) { IPage page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); MPJLambdaWrapper queryWrapper = new MPJLambdaWrapper<>(); queryWrapper.leftJoin(Shop.class,Shop::getId,Users::getDepartmentId) .selectAs(Shop::getNamePath,Users::getShopName) .selectAs(Shop::getType,Users::getShopType) .selectAs(Shop::getSecondType,Users::getShopSecType) .selectAll(Users.class); Utils.MP.blankToNull(pageWrap.getModel()); if (pageWrap.getModel().getId() != null) { queryWrapper.eq(Users::getId, pageWrap.getModel().getId()); } if (pageWrap.getModel().getCreator() != null) { queryWrapper.eq(Users::getCreator, pageWrap.getModel().getCreator()); } if (pageWrap.getModel().getCreateDate() != null) { queryWrapper.ge(Users::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate())); queryWrapper.le(Users::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getCreateDate())); } if (pageWrap.getModel().getEditor() != null) { queryWrapper.eq(Users::getEditor, pageWrap.getModel().getEditor()); } if (pageWrap.getModel().getEditDate() != null) { queryWrapper.ge(Users::getEditDate, Utils.Date.getStart(pageWrap.getModel().getEditDate())); queryWrapper.le(Users::getEditDate, Utils.Date.getEnd(pageWrap.getModel().getEditDate())); } if (pageWrap.getModel().getIsdeleted() != null) { queryWrapper.eq(Users::getIsdeleted, pageWrap.getModel().getIsdeleted()); } if (pageWrap.getModel().getRemark() != null) { queryWrapper.eq(Users::getRemark, pageWrap.getModel().getRemark()); } if (pageWrap.getModel().getDepartmentId() != null) { queryWrapper.eq(Users::getDepartmentId, pageWrap.getModel().getDepartmentId()); } if (pageWrap.getModel().getImgurl() != null) { queryWrapper.eq(Users::getImgurl, pageWrap.getModel().getImgurl()); } if (pageWrap.getModel().getType() != null) { queryWrapper.eq(Users::getType, pageWrap.getModel().getType()); } if (pageWrap.getModel().getName() != null) { queryWrapper.eq(Users::getName, pageWrap.getModel().getName()); } if (pageWrap.getModel().getBirthday() != null) { queryWrapper.ge(Users::getBirthday, Utils.Date.getStart(pageWrap.getModel().getBirthday())); queryWrapper.le(Users::getBirthday, Utils.Date.getEnd(pageWrap.getModel().getBirthday())); } if (pageWrap.getModel().getPhone() != null) { queryWrapper.eq(Users::getPhone, pageWrap.getModel().getPhone()); } if (pageWrap.getModel().getIdcardNo() != null) { queryWrapper.eq(Users::getIdcardNo, pageWrap.getModel().getIdcardNo()); } if (pageWrap.getModel().getCode() != null) { queryWrapper.eq(Users::getCode, pageWrap.getModel().getCode()); } if (pageWrap.getModel().getOpenid() != null) { queryWrapper.eq(Users::getOpenid, pageWrap.getModel().getOpenid()); } if (pageWrap.getModel().getStatus() != null) { queryWrapper.eq(Users::getStatus, pageWrap.getModel().getStatus()); } if (pageWrap.getModel().getIamStatus() != null) { queryWrapper.eq(Users::getIamStatus, pageWrap.getModel().getIamStatus()); } if (pageWrap.getModel().getIamDate() != null) { queryWrapper.ge(Users::getIamDate, Utils.Date.getStart(pageWrap.getModel().getIamDate())); queryWrapper.le(Users::getIamDate, Utils.Date.getEnd(pageWrap.getModel().getIamDate())); } if (pageWrap.getModel().getIamId() != null) { queryWrapper.eq(Users::getIamId, pageWrap.getModel().getIamId()); } if (pageWrap.getModel().getIamUsername() != null) { queryWrapper.like(Users::getIamUsername, pageWrap.getModel().getIamUsername()); } if (pageWrap.getModel().getPassword() != null) { queryWrapper.eq(Users::getPassword, pageWrap.getModel().getPassword()); } if (pageWrap.getModel().getSex() != null) { queryWrapper.eq(Users::getSex, pageWrap.getModel().getSex()); } if (pageWrap.getModel().getLastLoginDate() != null) { queryWrapper.ge(Users::getLastLoginDate, Utils.Date.getStart(pageWrap.getModel().getLastLoginDate())); queryWrapper.le(Users::getLastLoginDate, Utils.Date.getEnd(pageWrap.getModel().getLastLoginDate())); } if (pageWrap.getModel().getLoginNum() != null) { queryWrapper.eq(Users::getLoginNum, pageWrap.getModel().getLoginNum()); } if (pageWrap.getModel().getLastLoginPlat() != null) { queryWrapper.eq(Users::getLastLoginPlat, pageWrap.getModel().getLastLoginPlat()); } if (pageWrap.getModel().getCostomerNum() != null) { queryWrapper.eq(Users::getCostomerNum, pageWrap.getModel().getCostomerNum()); } if (pageWrap.getModel().getJobDate() != null) { queryWrapper.eq(Users::getJobDate, pageWrap.getModel().getJobDate()); } if (pageWrap.getModel().getSlogans() != null) { queryWrapper.eq(Users::getSlogans, pageWrap.getModel().getSlogans()); } if (pageWrap.getModel().getQrcodeImg() != null) { queryWrapper.eq(Users::getQrcodeImg, pageWrap.getModel().getQrcodeImg()); } if (pageWrap.getModel().getEmail() != null) { queryWrapper.eq(Users::getEmail, pageWrap.getModel().getEmail()); } if (pageWrap.getModel().getUserTypes() != null) { queryWrapper.eq(Users::getUserTypes, pageWrap.getModel().getUserTypes()); } if (pageWrap.getModel().getRoleIds() != null) { queryWrapper.eq(Users::getRoleIds, pageWrap.getModel().getRoleIds()); } if (StringUtils.isNotBlank(pageWrap.getModel().getRoleNames() )) { queryWrapper.eq(Users::getRoleNames, pageWrap.getModel().getRoleNames()); } if (StringUtils.isNotBlank(pageWrap.getModel().getShopName() )) { queryWrapper.eq(Shop::getName, pageWrap.getModel().getShopName()); } queryWrapper.eq(pageWrap.getModel().getShopType()!=null,Shop::getType,pageWrap.getModel().getShopType()); queryWrapper.eq(pageWrap.getModel().getShopSecType()!=null,Shop::getSecondType,pageWrap.getModel().getShopSecType()); if(StringUtils.isNotBlank(pageWrap.getModel().getQueryKeyword())){ queryWrapper.and(w ->{ w.eq(Users::getName,pageWrap.getModel().getQueryKeyword()) .or().eq(Users::getPhone,pageWrap.getModel().getQueryKeyword()) .or().eq(Users::getCode,pageWrap.getModel().getQueryKeyword()) ; } ); } if(pageWrap.getModel().getIamOrgId()!=null){ if(pageWrap.getModel().getIncludeChild()!=null &&pageWrap.getModel().getIncludeChild() ){ //如果包含下级组织 Shop shop = shopMapper.selectOne(new QueryWrapper().lambda().eq(Shop::getOrgId,pageWrap.getModel().getIamOrgId()).last("limit 1"));//查询组织信息 queryWrapper.likeRight(Shop::getIdPath,shop.getIdPath()); }else{ //不包含下级组织 queryWrapper.eq(Shop::getOrgId,pageWrap.getModel().getIamOrgId()); } } PageData pageData = PageData.from(usersMapper.selectJoinPage(page,Users.class, queryWrapper)); if(pageData!=null && pageData.getRecords()!=null && pageData.getRecords().size()>0){ String path = systemDictDataBiz.queryByCode(Constants.OBJCET_STORAGE,Constants.RESOURCE_PATH ).getCode() + systemDictDataBiz.queryByCode(Constants.OBJCET_STORAGE,Constants.USERS_FILE ).getCode(); for(Users f : pageData.getRecords()){ if(StringUtils.isNotBlank(f.getImgurl())){ f.setImgurlFull(path + f.getImgurl()); } if(StringUtils.isNotBlank(f.getQrcodeImg())){ f.setQrcodeImgFull(path + f.getQrcodeImg()); } } } return pageData; } @Override public long count(Users users) { QueryWrapper wrapper = new QueryWrapper<>(users); return usersMapper.selectCount(wrapper); } @Override public AccountResponse phoneLogin(String phone,String code){ if(StringUtils.isEmpty(phone)||StringUtils.isEmpty(code)){ throw new BusinessException(ResponseStatus.BAD_REQUEST); } Users users = usersMapper.selectOne(new QueryWrapper().lambda().eq(Users::getPhone,phone).last("limit 1")); if(Objects.isNull(users)){ throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"未查询到账户信息"); } if(!Constants.equalsInteger(users.getIsdeleted(), Constants.ZERO)){ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"当前账户已删除"); } if(!StringUtils.equals(users.getStatus(),Constants.ZERO+"")){ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"当前账户已停用,请联系管理员"); } //验证短信 SmsEmail model = smsEmailMapper.selectOne(new QueryWrapper().lambda() .eq(SmsEmail::getType, Constants.ZERO) .eq(SmsEmail::getPhone, phone) .eq(SmsEmail::getRemark, code) .eq(SmsEmail::getIsdeleted, Constants.ZERO) ); if(model == null){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"对不起,验证码不正确,请重新发送再试!"); } if(!Constants.equalsInteger(model.getStatus(),Constants.ZERO)){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"对不起,验证码已失效,请重新发送再试!"); } model.setStatus(Constants.ONE); model.setEditDate(new Date()); if(model.getCreateDate() !=null && System.currentTimeMillis() - model.getCreateDate().getTime() > 3*60*1000){ smsEmailMapper.updateById(model); throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"对不起,验证码已失效,请重新发送再试~"); } smsEmailMapper.updateById(model); //创建token JwtPayLoad payLoad = new JwtPayLoad(users.getId(),Constants.ONE); String token = JwtTokenUtil.generateToken(payLoad); AccountResponse accountResponse = new AccountResponse(); accountResponse.setToken(token); accountResponse.setUsers(users); return accountResponse; } @Override public AccountResponse wxLogin(String code){ try { //获取微信敏感数据 WxMaJscode2SessionResult session = WxMiniConfig.wxPersonnelService.getUserService().getSessionInfo(code); String openId = session.getOpenid(); if (com.baomidou.mybatisplus.core.toolkit.StringUtils.isBlank(openId)) { throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"获取openid失败!请联系管理员"); } AccountResponse accountResponse = new AccountResponse(); accountResponse.setSessionKey(session.getSessionKey()); Users users = usersMapper.selectOne(new QueryWrapper().lambda().eq(Users::getOpenid,openId).last("limit 1")); if(Objects.isNull(users)){ return accountResponse; } if(!Constants.equalsInteger(users.getIsdeleted(),Constants.ZERO)){ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"当前账户已删除"); } if(!StringUtils.equals(users.getStatus(),Constants.ZERO+"")){ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"当前账户已停用,请联系管理员"); } //创建token JwtPayLoad payLoad = new JwtPayLoad(users.getId(),Constants.ONE); String token = JwtTokenUtil.generateToken(payLoad); accountResponse.setToken(token); accountResponse.setUsers(users); return accountResponse; } catch (WxErrorException e) { e.printStackTrace(); } throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"微信登录异常!请联系管理员"); } @Override public void bindingOpenid(String code,Long userId){ try { //获取微信敏感数据 WxMaJscode2SessionResult session = WxMiniConfig.wxPersonnelService.getUserService().getSessionInfo(code); String openId = session.getOpenid(); if (com.baomidou.mybatisplus.core.toolkit.StringUtils.isBlank(openId)) { throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"获取openid失败!请联系管理员"); } usersMapper.update(new UpdateWrapper().lambda().set(Users::getOpenid,null).eq(Users::getOpenid,openId)); Users users = usersMapper.selectById(userId); users.setOpenid(openId); users.setEditDate(new Date()); usersMapper.updateById(users); } catch (WxErrorException e) { e.printStackTrace(); } } @Override @Transactional(rollbackFor = {BusinessException.class,Exception.class}) public String importBatch(MultipartFile file){ Boolean importing = (Boolean) redisTemplate.opsForValue().get(Constants.RedisKeys.IMPORTING_USERS); if(importing!=null && importing){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"对不起,已存在导入或者上下级重置任务正在执行中,请稍后再试!"); } redisTemplate.opsForValue().set(Constants.RedisKeys.IMPORTING_USERS,true); try { LoginUserInfo loginUserInfo = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal(); ExcelImporter ie = null; List dataList =null; try { ie = new ExcelImporter(file,0,0); dataList = ie.getDataList(UserImport.class,null); } catch (Exception e) { e.printStackTrace(); } if(dataList == null || dataList.size() ==0){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"对不起,录入数据为空!"); } Date date =new Date(); List finalDataList = dataList; Callable task = () -> { dealUserDataBiz(finalDataList,date,loginUserInfo); return "异步任务完成"; }; executor.submit(task); return "导入成功"; }catch (BusinessException e){ throw e; }catch (Exception e){ throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),"信息导入失败,请稍后重试"); } } private void dealUserDataBiz(List dataList, Date date, LoginUserInfo loginUserInfo) { try { List list = usersMapper.selectJoinList(Users.class,new MPJLambdaWrapper() .selectAll(Users.class) ); List insertList = new ArrayList<>(); List updateList = new ArrayList<>(); for(int i=0;i0){ int temp = 0; while(temp < insertList.size()){ int index; if(temp + 500 <= insertList.size()){ index = temp+500; }else{ index = insertList.size(); } usersMapper.insert(insertList.subList(temp,index)); temp = index; } } if(updateList .size() >0){ for(Users s : updateList){ //遍历更新数据 usersMapper.updateById(s); } } }catch (BusinessException e){ throw e; }catch (Exception e){ throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),"信息导入失败,请稍后重试"); }finally { executor.shutdown(); redisTemplate.delete(Constants.RedisKeys.IMPORTING_USERS); } } private Users getUserByUserID(String userId, List list) { if(list ==null || list.size() ==0){ return null; } for(Users s :list){ if(StringUtils.equals(s.getIamId(),userId)){ return s; } } return null; } private Users checkModelParam(UserImport model, List insertList, List updateList, int index, LoginUserInfo loginUserInfo, List list, Date date) { if(StringUtils.isBlank(model.getUserId())){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"对不起,第"+(index+3)+"行【编码】信息不完整,请检查表格内容!"); } if(StringUtils.isBlank(model.getName())){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"对不起,第"+(index+3)+"行【姓名】信息不完整,请检查表格内容!"); } if(StringUtils.isBlank(model.getAccountNo())){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"对不起,第"+(index+3)+"行【登录账号】信息不完整,请检查表格内容!"); } if(StringUtils.isBlank(model.getPhone())){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"对不起,第"+(index+3)+"行【手机号】信息不完整,请检查表格内容!"); } Users users = getUserByUserID(model.getUserId(),list); if(users == null){ users = new Users(); users.setCreator(loginUserInfo.getId()); users.setCreateDate(date); initUsersInfo(users,model,date,loginUserInfo); insertList.add(users); }else { initUsersInfo(users,model,date,loginUserInfo); updateList.add(users); } return users; } private void initUsersInfo(Users users, UserImport model,Date date,LoginUserInfo loginUserInfo ){ users.setEditor(loginUserInfo.getId()); users.setEditDate(date); users.setName(model.getName()); users.setIamUsername(model.getAccountNo()); users.setPhone(model.getPhone()); users.setStatus(model.getStatus()); users.setEmail(model.getEmail()); users.setIamId(model.getUserId()); users.setCode(model.getCode()); users.setSex(model.getSex()); users.setStatus(model.getStatus()); users.setIsdeleted(Constants.ZERO); users.setRoleIds(""); users.setRoleNames(""); users.setRoleCodes(""); users.setUserTypes(""); users.setIamOrgId(""); getDepartidByParam(users,model.getOrgIds()); setRolesInfo(users,model); getUserTypesByParam(users,model.getTypeCodes()); } private String getUserTypesByParam(Users users,String typeCodes) { if( typeCodes !=null){ String[] codes =typeCodes.split(","); for(String t : codes){ if(StringUtils.isBlank(users.getUserTypes())){ users.setUserTypes(""); } users.setUserTypes(users.getUserTypes()+"["+t+"];"); } } return users.getUserTypes(); } private void setRolesInfo(Users users, UserImport model) { if( model.getRoleCodes() !=null){ String[] codes = model.getRoleCodes().split(","); for(String t : codes){ if(StringUtils.isBlank(users.getRoleCodes())){ users.setRoleCodes(""); } users.setRoleCodes(users.getRoleCodes()+"["+t+"];"); } } if( model.getRoleIds() !=null){ String[] codes = model.getRoleIds().split(","); for(String t : codes){ if(StringUtils.isBlank(users.getRoleIds())){ users.setRoleIds(""); } users.setRoleIds(users.getRoleIds()+"["+t+"];"); } } if( model.getRoleNames() !=null){ String[] codes = model.getRoleNames().split(","); for(String t : codes){ if(StringUtils.isBlank(users.getRoleNames())){ users.setRoleNames(""); } users.setRoleNames(users.getRoleNames()+"["+t+"];"); } } } private Shop getDepartidByParam(Users users , String orgIds) { if( orgIds ==null){ return null; } String[] orgArray = orgIds.split(","); if( orgArray !=null && orgArray.length>0){ for(String t : orgArray){ Shop shop = shopMapper.selectOne(new QueryWrapper().lambda() .eq(Shop::getOrgId,t) .last("limit 1")); if(shop!=null) { users.setIamOrgId(t); users.setDepartmentId(shop.getId()); return shop; } } } users.setIamOrgId(orgIds+"--尚未同步到组织"); return null; } @Override public Users usersDetail(Long userId){ Users users = usersMapper.selectById(userId); if(Objects.isNull(users)){ throw new BusinessException(ResponseStatus.DATA_EMPTY); } String prefix = StringUtils.trimToNull(systemDictDataBiz.queryByCode(Constants.OBJCET_STORAGE,Constants.RESOURCE_PATH).getCode()) + StringUtils.trimToNull(systemDictDataBiz.queryByCode(Constants.OBJCET_STORAGE,Constants.USERS_FILE).getCode()); if(StringUtils.isNotBlank(users.getImgurl())){ users.setImgurlFull(prefix + users.getImgurl()); } if(StringUtils.isNotBlank(users.getQrcodeImg())){ users.setQrcodeImgFull(prefix + users.getQrcodeImg()); } if(StringUtils.isNotBlank(users.getCompanyQrcodeImg())){ users.setCompanyQrcodeImgFull(prefix + users.getCompanyQrcodeImg()); } if(Objects.nonNull(users.getDepartmentId())){ Shop shop = shopMapper.selectById(users.getDepartmentId()); if(Objects.nonNull(shop)){ users.setShopName(shop.getName()); if(StringUtils.isNotBlank(shop.getAddress())){ users.setShopAddress(shop.getAddress()); }else{ users.setShopAddress(shop.getProvinceName()+shop.getCityName()+shop.getAreaName()+shop.getTown()+shop.getRegAddr()); } } } return users; } }