package com.doumee.service.business.impl; import cn.binarywang.wx.miniapp.bean.WxMaJscode2SessionResult; import cn.binarywang.wx.miniapp.bean.WxMaPhoneNumberInfo; import com.alibaba.fastjson.JSONObject; import com.doumee.biz.system.SystemDictDataBiz; import com.doumee.biz.zbom.ZbomZhongTaiService; import com.doumee.biz.zbom.model.zhongtai.ZTBaseRequst; import com.doumee.biz.zbom.model.zhongtai.ZTUserGetTokenRequest; import com.doumee.biz.zbom.model.zhongtai.ZTUserInfoUpdateRequest; import com.doumee.biz.zbom.model.zhongtai.response.ZTUserGetTokenResponse; import com.doumee.config.Jwt.JwtPayLoad; import com.doumee.config.Jwt.JwtTokenUtil; import com.doumee.core.constants.ResponseStatus; import com.doumee.core.exception.BusinessException; import com.doumee.core.model.PageData; import com.doumee.core.model.PageWrap; import com.doumee.core.oss.FileModel; import com.doumee.core.utils.CodeVerifyUtils; import com.doumee.core.utils.Constants; import com.doumee.core.utils.DateUtil; import com.doumee.core.utils.Utils; import com.doumee.core.wx.WxMiniConfig; import com.doumee.dao.business.MemberMapper; import com.doumee.dao.business.UsersMapper; import com.doumee.dao.business.model.InterfaceLog; import com.doumee.dao.business.model.Member; import com.doumee.dao.business.model.Users; import com.doumee.dao.web.reqeust.EditMemberRequest; import com.doumee.dao.web.reqeust.WxPhoneRequest; import com.doumee.dao.web.response.AccountResponse; import com.doumee.service.business.MemberService; 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 me.chanjar.weixin.common.error.WxErrorException; import okhttp3.OkHttpClient; import okhttp3.Request; import okhttp3.Response; import org.apache.catalina.User; import org.apache.commons.lang3.StringUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.data.redis.core.RedisTemplate; import org.springframework.stereotype.Service; import org.springframework.util.CollectionUtils; import java.io.ByteArrayInputStream; import java.io.InputStream; import java.util.*; import java.util.concurrent.TimeUnit; /** * 用户信息表Service实现 * @author 江蹄蹄 * @date 2024/07/04 14:40 */ @Service public class MemberServiceImpl implements MemberService { @Autowired private MemberMapper memberMapper; @Autowired private UsersMapper usersMapper; @Autowired private SystemDictDataBiz systemDictDataBiz; @Autowired private ZbomZhongTaiService zbomZhongTaiService; @Autowired private RedisTemplate redisTemplate; @Override public Long create(Member member) { memberMapper.insert(member); return member.getId(); } @Override public void deleteById(Long id) { memberMapper.deleteById(id); } @Override public void delete(Member member) { UpdateWrapper deleteWrapper = new UpdateWrapper<>(member); memberMapper.delete(deleteWrapper); } @Override public void deleteByIdInBatch(List ids) { if (CollectionUtils.isEmpty(ids)) { return; } memberMapper.deleteBatchIds(ids); } @Override public void updateById(Member member) { memberMapper.updateById(member); } @Override public void updateByIdInBatch(List members) { if (CollectionUtils.isEmpty(members)) { return; } for (Member member: members) { this.updateById(member); } } @Override public Member findById(Long id) { return memberMapper.selectById(id); } @Override public Member findOne(Member member) { QueryWrapper wrapper = new QueryWrapper<>(member); return memberMapper.selectOne(wrapper); } @Override public List findList(Member member) { QueryWrapper wrapper = new QueryWrapper<>(member); return memberMapper.selectList(wrapper); } @Override public PageData findPage(PageWrap pageWrap) { IPage page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); QueryWrapper queryWrapper = new QueryWrapper<>(); Utils.MP.blankToNull(pageWrap.getModel()); if (pageWrap.getModel().getId() != null) { queryWrapper.lambda().eq(Member::getId, pageWrap.getModel().getId()); } if (pageWrap.getModel().getCreator() != null) { queryWrapper.lambda().eq(Member::getCreator, pageWrap.getModel().getCreator()); } if (pageWrap.getModel().getCreateDate() != null) { queryWrapper.lambda().ge(Member::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate())); queryWrapper.lambda().le(Member::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getCreateDate())); } if (pageWrap.getModel().getEditor() != null) { queryWrapper.lambda().eq(Member::getEditor, pageWrap.getModel().getEditor()); } if (pageWrap.getModel().getEditDate() != null) { queryWrapper.lambda().ge(Member::getEditDate, Utils.Date.getStart(pageWrap.getModel().getEditDate())); queryWrapper.lambda().le(Member::getEditDate, Utils.Date.getEnd(pageWrap.getModel().getEditDate())); } if (pageWrap.getModel().getIsdeleted() != null) { queryWrapper.lambda().eq(Member::getIsdeleted, pageWrap.getModel().getIsdeleted()); } if (pageWrap.getModel().getRemark() != null) { queryWrapper.lambda().eq(Member::getRemark, pageWrap.getModel().getRemark()); } if (pageWrap.getModel().getImgurl() != null) { queryWrapper.lambda().eq(Member::getImgurl, pageWrap.getModel().getImgurl()); } if (pageWrap.getModel().getType() != null) { queryWrapper.lambda().eq(Member::getType, pageWrap.getModel().getType()); } if (pageWrap.getModel().getNickname() != null) { queryWrapper.lambda().eq(Member::getNickname, pageWrap.getModel().getNickname()); } if (pageWrap.getModel().getName() != null) { queryWrapper.lambda().eq(Member::getName, pageWrap.getModel().getName()); } if (pageWrap.getModel().getBirthday() != null) { queryWrapper.lambda().ge(Member::getBirthday, Utils.Date.getStart(pageWrap.getModel().getBirthday())); queryWrapper.lambda().le(Member::getBirthday, Utils.Date.getEnd(pageWrap.getModel().getBirthday())); } if (pageWrap.getModel().getPhone() != null) { queryWrapper.lambda().eq(Member::getPhone, pageWrap.getModel().getPhone()); } if (pageWrap.getModel().getOpenid() != null) { queryWrapper.lambda().eq(Member::getOpenid, pageWrap.getModel().getOpenid()); } if (pageWrap.getModel().getStatus() != null) { queryWrapper.lambda().eq(Member::getStatus, pageWrap.getModel().getStatus()); } if (pageWrap.getModel().getTokenDate() != null) { queryWrapper.lambda().ge(Member::getTokenDate, Utils.Date.getStart(pageWrap.getModel().getTokenDate())); queryWrapper.lambda().le(Member::getTokenDate, Utils.Date.getEnd(pageWrap.getModel().getTokenDate())); } if (pageWrap.getModel().getToken() != null) { queryWrapper.lambda().eq(Member::getToken, pageWrap.getModel().getToken()); } if (pageWrap.getModel().getSex() != null) { queryWrapper.lambda().eq(Member::getSex, pageWrap.getModel().getSex()); } if (pageWrap.getModel().getLastLoginDate() != null) { queryWrapper.lambda().ge(Member::getLastLoginDate, Utils.Date.getStart(pageWrap.getModel().getLastLoginDate())); queryWrapper.lambda().le(Member::getLastLoginDate, Utils.Date.getEnd(pageWrap.getModel().getLastLoginDate())); } if (pageWrap.getModel().getLoginNum() != null) { queryWrapper.lambda().eq(Member::getLoginNum, pageWrap.getModel().getLoginNum()); } if (pageWrap.getModel().getProvinceName() != null) { queryWrapper.lambda().eq(Member::getProvinceName, pageWrap.getModel().getProvinceName()); } if (pageWrap.getModel().getCityName() != null) { queryWrapper.lambda().eq(Member::getCityName, pageWrap.getModel().getCityName()); } if (pageWrap.getModel().getAreaName() != null) { queryWrapper.lambda().eq(Member::getAreaName, pageWrap.getModel().getAreaName()); } if (pageWrap.getModel().getProvinceCode() != null) { queryWrapper.lambda().eq(Member::getProvinceCode, pageWrap.getModel().getProvinceCode()); } if (pageWrap.getModel().getCityCode() != null) { queryWrapper.lambda().eq(Member::getCityCode, pageWrap.getModel().getCityCode()); } if (pageWrap.getModel().getAreaCode() != null) { queryWrapper.lambda().eq(Member::getAreaCode, pageWrap.getModel().getAreaCode()); } if (pageWrap.getModel().getDistrict() != null) { queryWrapper.lambda().eq(Member::getDistrict, pageWrap.getModel().getDistrict()); } if (pageWrap.getModel().getHousetype() != null) { queryWrapper.lambda().eq(Member::getHousetype, pageWrap.getModel().getHousetype()); } if (pageWrap.getModel().getLongitude() != null) { queryWrapper.lambda().eq(Member::getLongitude, pageWrap.getModel().getLongitude()); } if (pageWrap.getModel().getLatitude() != null) { queryWrapper.lambda().eq(Member::getLatitude, pageWrap.getModel().getLatitude()); } if (pageWrap.getModel().getAuthStatus() != null) { queryWrapper.lambda().eq(Member::getAuthStatus, pageWrap.getModel().getAuthStatus()); } if (pageWrap.getModel().getAuthDate() != null) { queryWrapper.lambda().ge(Member::getAuthDate, Utils.Date.getStart(pageWrap.getModel().getAuthDate())); queryWrapper.lambda().le(Member::getAuthDate, Utils.Date.getEnd(pageWrap.getModel().getAuthDate())); } if (pageWrap.getModel().getAuthInfo() != null) { queryWrapper.lambda().eq(Member::getAuthInfo, pageWrap.getModel().getAuthInfo()); } if (pageWrap.getModel().getQueryStartDate() != null) { queryWrapper.lambda().ge(Member::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getQueryStartDate())); } if (pageWrap.getModel().getQueryEndDate() != null) { queryWrapper.lambda().le(Member::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getQueryEndDate())); } for(PageWrap.SortData sortData: pageWrap.getSorts()) { if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) { queryWrapper.orderByDesc(sortData.getProperty()); } else { queryWrapper.orderByAsc(sortData.getProperty()); } } return PageData.from(memberMapper.selectPage(page, queryWrapper)); } @Override public long count(Member member) { QueryWrapper wrapper = new QueryWrapper<>(member); return memberMapper.selectCount(wrapper); } @Override public AccountResponse wxLogin(String code){ try { // 获取微信敏感数据 WxMaJscode2SessionResult session = WxMiniConfig.wxCustomerService.getUserService().getSessionInfo(code); String openId = session.getOpenid(); if (com.baomidou.mybatisplus.core.toolkit.StringUtils.isBlank(openId)) { throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"获取openid失败！请联系管理员"); } Member member = memberMapper.selectOne(new QueryWrapper().eq("OPENID", openId)); if (member == null) { member = new Member(); member.setNickname("微信用户"+ CodeVerifyUtils.createVerificationCode(4)); member.setCreateDate(new Date()); member.setIsdeleted(Constants.ZERO); member.setType(Constants.ZERO); memberMapper.insert(member); } //创建token JwtPayLoad payLoad = new JwtPayLoad(member.getId(),Constants.ZERO); String token = JwtTokenUtil.generateToken(payLoad); AccountResponse accountResponse = new AccountResponse(); accountResponse.setToken(token); accountResponse.setSessionKey(session.getSessionKey()); accountResponse.setMember(member); return accountResponse; } catch (WxErrorException e) { e.printStackTrace(); } throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"微信登录异常！请联系管理员"); } @Override public String getWxMiniPhone(WxPhoneRequest wxPhoneRequest){ try { WxMaPhoneNumberInfo userPhoneInfo = WxMiniConfig.wxCustomerService.getUserService().getPhoneNoInfo( wxPhoneRequest.getSessionKey(), wxPhoneRequest.getEncryptedData(), wxPhoneRequest.getIv()); //获取手机号 String phone= userPhoneInfo.getPurePhoneNumber(); if(Objects.isNull(phone)){ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"未获取到手机号"); } return phone; } catch (Exception e) { e.printStackTrace(); } throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"更新手机号失败"); } @Override public void updMemberDetail(EditMemberRequest editMemberRequest){ Member member = memberMapper.selectById(editMemberRequest.getMemberId()); ZTUserInfoUpdateRequest ztUserInfoUpdateRequest = new ZTUserInfoUpdateRequest(); ztUserInfoUpdateRequest.setOpenId(member.getOpenid()); String appId = systemDictDataBiz.queryByCode(Constants.WX_MINI_CONFIG,Constants.WX_APPID_CUSTOMER).getCode(); ztUserInfoUpdateRequest.setAppId(appId); ztUserInfoUpdateRequest.setPlatform(Constants.PLATFORM); ztUserInfoUpdateRequest.setPhone(editMemberRequest.getPhone()); ztUserInfoUpdateRequest.setName(editMemberRequest.getName()); ztUserInfoUpdateRequest.setAddress(editMemberRequest.getProvinceName()+editMemberRequest.getCityName()+editMemberRequest.getAreaName()); ztUserInfoUpdateRequest.setFullAddress(editMemberRequest.getAddress()); String prefix = systemDictDataBiz.queryByCode(Constants.OBJCET_STORAGE, Constants.RESOURCE_PATH).getCode() + systemDictDataBiz.queryByCode(Constants.OBJCET_STORAGE, Constants.MEMBER).getCode(); if(StringUtils.isNotBlank(editMemberRequest.getImgurl())){ ztUserInfoUpdateRequest.setAvatarUrl(prefix + editMemberRequest.getImgurl()); } ztUserInfoUpdateRequest.setUptown(editMemberRequest.getDistrict()); ztUserInfoUpdateRequest.setHouseArea(editMemberRequest.getHousearea().toString()); ztUserInfoUpdateRequest.setHouseLayout(Constants.getHouseLayout(editMemberRequest.getHousetype())); ZTUserGetTokenResponse userUpdateInfo = zbomZhongTaiService.userUpdateInfo(ztUserInfoUpdateRequest); if(Objects.isNull(userUpdateInfo)){ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"中台信息更新失败，请联系管理员"); } memberMapper.update(new UpdateWrapper() .lambda() .set(StringUtils.isNotBlank(editMemberRequest.getImgurl()),Member::getImgurl,editMemberRequest.getImgurl()) .set(StringUtils.isNotBlank(editMemberRequest.getName()),Member::getName,editMemberRequest.getName()) .set(StringUtils.isNotBlank(editMemberRequest.getPhone()),Member::getPhone,editMemberRequest.getPhone()) .set(StringUtils.isNotBlank(editMemberRequest.getProvinceName()),Member::getProvinceName,editMemberRequest.getProvinceName()) .set(StringUtils.isNotBlank(editMemberRequest.getProvinceCode()),Member::getProvinceCode,editMemberRequest.getProvinceCode()) .set(StringUtils.isNotBlank(editMemberRequest.getCityCode()),Member::getCityCode,editMemberRequest.getCityCode()) .set(StringUtils.isNotBlank(editMemberRequest.getCityName()),Member::getCityName,editMemberRequest.getCityName()) .set(StringUtils.isNotBlank(editMemberRequest.getAreaCode()),Member::getAreaCode,editMemberRequest.getAreaCode()) .set(StringUtils.isNotBlank(editMemberRequest.getAreaName()),Member::getAreaName,editMemberRequest.getAreaName()) .set(StringUtils.isNotBlank(editMemberRequest.getAddress()),Member::getAddress,editMemberRequest.getAddress()) .set(StringUtils.isNotBlank(editMemberRequest.getDistrict()),Member::getDistrict,editMemberRequest.getDistrict()) .set(Objects.nonNull(editMemberRequest.getHousearea()),Member::getHousearea,editMemberRequest.getHousearea()) .set(StringUtils.isNotBlank(editMemberRequest.getHousetype()),Member::getHousetype,editMemberRequest.getHousetype()) .set(Objects.nonNull(editMemberRequest.getLatitude()),Member::getLatitude,editMemberRequest.getLatitude()) .set(Objects.nonNull(editMemberRequest.getLongitude()),Member::getLongitude,editMemberRequest.getLongitude()) .set(Member::getToken,userUpdateInfo.getToken()) .eq(Member::getId,editMemberRequest.getMemberId())); } @Override public Member getMemberInfo(Long memberId){ Member member = memberMapper.selectById(memberId); if(Objects.isNull(member)){ throw new BusinessException(ResponseStatus.DATA_EMPTY); } String prefix = systemDictDataBiz.queryByCode(Constants.OBJCET_STORAGE, Constants.RESOURCE_PATH).getCode() + systemDictDataBiz.queryByCode(Constants.OBJCET_STORAGE, Constants.MEMBER).getCode(); member.setPrefix(prefix); return member; } public static String getZTToken(ZbomZhongTaiService zbomZhongTaiService, MemberMapper memberMapper, UsersMapper usersMapper, SystemDictDataBiz systemDictDataBiz, String id, String userType){ if(userType.equals(Constants.CUSTOMER)){ Member member = memberMapper.selectById(id); if(Objects.isNull(member)){ throw new BusinessException(ResponseStatus.BAD_REQUEST); } //如果无有效期/已过期 重新获取 if(Objects.isNull(member.getTokenDate()) || member.getTokenDate().getTime()<=System.currentTimeMillis() ){ ZTUserGetTokenRequest param = new ZTUserGetTokenRequest(); //查询APPID String appId = systemDictDataBiz.queryByCode(Constants.WX_MINI_CONFIG,Constants.WX_APPID_CUSTOMER).getCode(); param.setAppId(appId); param.setOpenId(member.getOpenid()); ZTUserGetTokenResponse ztUserGetTokenResponse = zbomZhongTaiService.getUserToken(param); if(Objects.nonNull(ztUserGetTokenResponse)){ member.setToken(ztUserGetTokenResponse.getToken()); //TODO 暂无过期日期 memberMapper.update(new UpdateWrapper().lambda().set(Member::getToken,ztUserGetTokenResponse.getToken()) .eq(Member::getId,member.getId())); return ztUserGetTokenResponse.getToken(); }else{ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"中台TOKEN获取失败，请联系管理员"); } } return member.getToken(); }else if(userType.equals(Constants.BUSINESS)){ Users users = usersMapper.selectById(id); if(Objects.isNull(users)){ throw new BusinessException(ResponseStatus.BAD_REQUEST); } if(Objects.isNull(users.getTokenDate()) || users.getTokenDate().getTime()<=System.currentTimeMillis() ){ ZTUserGetTokenRequest param = new ZTUserGetTokenRequest(); //查询APPID String appId = systemDictDataBiz.queryByCode(Constants.WX_MINI_CONFIG,Constants.WX_APPID_CUSTOMER).getCode(); param.setAppId(appId); param.setOpenId(users.getOpenid()); ZTUserGetTokenResponse ztUserGetTokenResponse = zbomZhongTaiService.getUserToken(param); if(Objects.nonNull(ztUserGetTokenResponse)){ users.setToken(ztUserGetTokenResponse.getToken()); //TODO 暂无过期日期 usersMapper.update(new UpdateWrapper().lambda().set(Users::getToken,ztUserGetTokenResponse.getToken()) .eq(Users::getId,users.getId())); return ztUserGetTokenResponse.getToken(); }else{ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"中台TOKEN获取失败，请联系管理员"); } } return users.getToken(); }else{ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"参数错误"); } } @Override public void logOff(Long memberId){ Member member = memberMapper.selectById(memberId); if(Objects.isNull(member)){ throw new BusinessException(ResponseStatus.DATA_EMPTY); } if(StringUtils.isBlank(member.getPhone())){ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"用户已注销"); } //校验用户token信息 MemberServiceImpl.getZTToken(zbomZhongTaiService,memberMapper,usersMapper,systemDictDataBiz,member.getId().toString(),Constants.CUSTOMER); //调起中台注销接口 ZTBaseRequst ztBaseRequst = new ZTBaseRequst(); ztBaseRequst.setUserType(Constants.CUSTOMER); ztBaseRequst.setOpenId(member.getOpenid()); ztBaseRequst.setToken(member.getToken()); Boolean logoutFlag = zbomZhongTaiService.userLogout(ztBaseRequst); if(logoutFlag){ memberMapper.update(new UpdateWrapper().lambda() .set(Member::getPhone,null) .set(Member::getEditDate,new Date()) .eq(Member::getId,member.getId()) ); return; } throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"中台注销失败，请联系管理员"); } }