package com.doumee.service.business.impl;
|
|
import cn.binarywang.wx.miniapp.bean.WxMaJscode2SessionResult;
|
import com.doumee.biz.system.SystemDictDataBiz;
|
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.UsersMapper;
|
import com.doumee.dao.business.model.Multifile;
|
import com.doumee.dao.business.model.News;
|
import com.doumee.dao.business.model.Shop;
|
import com.doumee.dao.business.model.Member;
|
import com.doumee.dao.business.model.Users;
|
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<String, Object> redisTemplate;
|
@Autowired
|
private UsersMapper usersMapper;
|
@Autowired
|
private ShopMapper shopMapper;
|
@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<Users> deleteWrapper = new UpdateWrapper<>(users);
|
usersMapper.delete(deleteWrapper);
|
}
|
|
@Override
|
public void deleteByIdInBatch(List<Long> ids) {
|
if (CollectionUtils.isEmpty(ids)) {
|
return;
|
}
|
usersMapper.deleteBatchIds(ids);
|
}
|
|
@Override
|
public void updateById(Users users) {
|
usersMapper.updateById(users);
|
}
|
|
@Override
|
public void updateByIdInBatch(List<Users> 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<Users> wrapper = new QueryWrapper<>(users);
|
return usersMapper.selectOne(wrapper);
|
}
|
|
@Override
|
public List<Users> findList(Users users) {
|
QueryWrapper<Users> wrapper = new QueryWrapper<>(users);
|
return usersMapper.selectList(wrapper);
|
}
|
|
@Override
|
public PageData<Users> findPage(PageWrap<Users> pageWrap) {
|
IPage<Users> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity());
|
MPJLambdaWrapper<Users> 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<Shop>().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<Users> 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<Users> 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<Users>().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(),"当前账户已停用，请联系管理员");
|
}
|
//TODO 验证短信信息
|
if(!StringUtils.equals(code,"123456")){
|
throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"验证码错误");
|
}
|
//创建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<Users>().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<Users>().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<UserImport> 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<UserImport> finalDataList = dataList;
|
Callable<String> 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<UserImport> finalDataList, Date date, LoginUserInfo loginUserInfo) {
|
|
}
|
|
}
|
