package com.ruoyi.member.service.impl;
|
|
|
import cn.binarywang.wx.miniapp.api.WxMaService;
|
import cn.binarywang.wx.miniapp.bean.WxMaJscode2SessionResult;
|
import com.alibaba.fastjson.JSON;
|
import com.alibaba.fastjson.JSONObject;
|
import com.alibaba.fastjson.TypeReference;
|
import com.alibaba.fastjson.parser.Feature;
|
import com.alipay.api.AlipayApiException;
|
import com.alipay.api.AlipayClient;
|
import com.alipay.api.DefaultAlipayClient;
|
import com.alipay.api.internal.util.AlipayEncrypt;
|
import com.alipay.api.internal.util.AlipaySignature;
|
import com.alipay.api.request.AlipaySystemOauthTokenRequest;
|
import com.alipay.api.response.AlipaySystemOauthTokenResponse;
|
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
|
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import com.ruoyi.common.core.enums.GenderEnum;
|
import com.ruoyi.common.core.exception.ServiceException;
|
import com.ruoyi.common.core.utils.StringUtils;
|
import com.ruoyi.common.core.utils.page.BeanUtils;
|
import com.ruoyi.common.core.utils.page.PageDTO;
|
import com.ruoyi.common.core.utils.uuid.IdUtils;
|
import com.ruoyi.common.redis.service.RedisService;
|
import com.ruoyi.common.security.utils.SecurityUtils;
|
import com.ruoyi.member.controller.management.dto.MgtMemberDTO;
|
import com.ruoyi.member.controller.management.dto.MgtMemberPointsQuery;
|
import com.ruoyi.member.controller.management.dto.MgtMemberQuery;
|
import com.ruoyi.member.controller.management.vo.MgtMemberPointsVO;
|
import com.ruoyi.member.controller.management.vo.MgtMemberVO;
|
import com.ruoyi.member.domain.MemberLevel;
|
import com.ruoyi.member.mapper.MemberLevelMapper;
|
import com.ruoyi.member.mapper.MemberMapper;
|
import com.ruoyi.member.service.IMemberPointsService;
|
import com.ruoyi.member.service.IMemberService;
|
import com.ruoyi.member.util.HttpUtils;
|
import com.ruoyi.system.api.RemoteUserService;
|
import com.ruoyi.system.api.domain.AppMiniLoginVO;
|
import com.ruoyi.system.api.domain.Member;
|
import com.ruoyi.system.api.domain.MemberPoints;
|
import com.ruoyi.system.api.domain.SysUser;
|
import com.ruoyi.system.api.domain.dto.AppMiniLoginDTO;
|
import com.ruoyi.system.api.domain.dto.MemberDTO;
|
import com.ruoyi.system.api.domain.dto.MobileDTO;
|
import com.ruoyi.system.api.domain.dto.updMembeOneDTO;
|
import java.io.IOException;
|
import java.io.UnsupportedEncodingException;
|
import java.math.BigDecimal;
|
import java.net.URLEncoder;
|
import java.util.Collection;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
import javax.annotation.Resource;
|
import lombok.extern.slf4j.Slf4j;
|
import org.apache.commons.io.IOUtils;
|
import org.apache.http.HttpEntity;
|
import org.apache.http.HttpResponse;
|
import org.apache.http.client.config.RequestConfig;
|
import org.apache.http.client.methods.CloseableHttpResponse;
|
import org.apache.http.client.methods.HttpGet;
|
import org.apache.http.impl.client.CloseableHttpClient;
|
import org.apache.http.impl.client.HttpClients;
|
import org.apache.http.util.EntityUtils;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Propagation;
|
import org.springframework.transaction.annotation.Transactional;
|
|
/**
|
* <p>
|
* 会员表 服务实现类
|
* </p>
|
*
|
* @author mitao
|
* @since 2024-05-16
|
*/
|
@Slf4j
|
@Service
|
public class MemberServiceImpl extends ServiceImpl<MemberMapper, Member> implements IMemberService {
|
|
|
public static RequestConfig config = RequestConfig.custom().setConnectTimeout(5000).setSocketTimeout(5000).build();
|
// 配置您申请的KEY,在个人中心->我的数据,接口名称上方查看
|
public static final String APPKEY = "61ad64e1ea78a24e00c449c346caa5d7";
|
//明文查询地址
|
public static String query_url = "http://op.juhe.cn/idcard/query?key=" + APPKEY;
|
|
|
//微信
|
private static final String ACCESS_TOKEN_HOST = "https://api.weixin.qq.com/cgi-bin/token";
|
|
private static final String WX_APPID = "wx69e3ac6e13a889b7";
|
|
private static final String WX_SECRET = "1b8bcfcb681524ac553e72054e5271ef";
|
|
//支付寶
|
/**
|
* Alipay客户端
|
*/
|
private AlipayClient alipayClient;
|
|
/**支付宝网关*/
|
/**
|
* 沙箱的
|
*/
|
private static final String ALIPAY_BORDER_DEV = "https://openapi-sandbox.dl.alipaydev.com/gateway.do";
|
/**
|
* 个人用户的
|
*/
|
private static final String ALIPAY_BORDER_PROD = "https://openapi.alipay.com/gateway.do";
|
/**
|
* appID
|
**/
|
private static final String APP_ID_PROD = "2021004150664294";
|
/**
|
* 私钥
|
*/
|
private static final String APP_PRIVATE_KEY = "MIIEvAIBADANBgkqhkiG9w0BAQEFAASCBKYwggSiAgEAAoIBAQC3ap1qQ5GTe+syB8Tu/fH8nRdpjA7yNgLINR/kFq1VFzxDref7DQDUDWXt+s5QZyBjL1UfbQWtA96F+OpgmIiNMdZSn9FH/w5XSqSd7B4nAa1sgfdLdZDvm+crqzn8OzyEJTrO8tihF+9K+btBl37s3QfmmzCRl1PAAMGqfy/JcQ2aivY+hxb25V0kD5AAXM7mVC2zzcBrykzafQCXEnDC7ls4Hjy0agmq1bKSx8SLYTsXAzZiGk9E7yh76nDAB+P1+kKPEYJXociU3k4YRR7l+6tzBPd+/mVkL34nuV5IiAK/795CrP/9gC50nZK/6CqSPDlQlOaAaJ2uZvAOeKx3AgMBAAECggEAMzw5+swjJ0KvYYtgDK6tYTZ0qswwBKLnxgto/CsFgkZ6VCGJMszgFVwkxASSi00zc+Ft8thehIUXLO9qcU9Knb51MyFnsafi1qmIMIEbryO90RjA/rg5o2U2fzFWgkn9zqAjvFmEAAQSmSwHjfwGvZ3Erjtdpt3RzEmpz7m1nJxYuZ2JLdo8AIY+iYn1NeDxHMi27RtqsZje7RV5YXrqKtMMzW2atmj+Dbn/E1pxpF0Dz6l0TqQh5B+9j1XlPTZKcYOYHNI0ACV+dV1NZsqmdhX0lKtQbsj/Q67vhq7uCmQRKcEka/5Z0X/TOKbwJE6i2/YEuA4PUGLpBMZQXhSGYQKBgQD50IuUTG6fg1dqFt9bJXxq2i1lkIHvzaCkHqVnTMyTDs+VcO2S6YaAFy6BLSI933qvHLogkhqnHiN+BRHe/M5+4TAOx30SQlJYa5ojpNFwMnRSZgxLoEddwlfj6qTnCgDW3CsUPR85x85NjIhONy75muNnNG8GHdn3blk2Y7KhpwKBgQC79TQhz5eJ6cwiWPWMWnnSAVvFKW4iPZjkbk+Sl7JXuqzvsdE47gGN0Vk8iYWEc2WrnQY6vf7WnamQYi+Gr5ySfTSt9qwvRx0IRzHdSZkOsHJLBCnAt+Pf+pSBc2Z788iUXVbDRAIfF6YYG44P3jHspbnGPJt14PP0sHbPmh7YsQKBgGzGGYChJyndjpprCyYs1FfSWCH5IhrAdkn/7hVko08FC+4OFeP6Os5bSayFcntua4UEBSdZdrF9tgaRPo7RlTg55SsKQbNJnYFSmPMcOPWZgny+YmwrheeVT5+188eF24eypi9Rzd7i2Tl7D36/GH0mrA2sDwuiw92w9rdwAb/RAoGAf6RDZPqvNI87e8/h4RDITd9yTPCXxFUEcYygKTMvf/hb3ONq7DhlgcO70CqsK4iacPLP+jBw0Zp8PnsPP24e7DRvA/zSbcDjbG285URH1vvogh0vpZq7+60WENsnq+GgQ3EnrK+QqUDMIO8FiK0iRk09XexmvqSnx3HXHaDSdeECgYB9htO5mOn2/ugIeMw11g+JJkZ/hzE55/6fLf7zh3yel5EflmAdYRv0lHafjyXIzNrAnBgD95x4LKGLi9A5AMo9SJJu0ZOg1KujKPVY4ByCm9SO7ErJDuHI4AhtewdHhYDpnXMakoxm/medSjlt7GCVv7E/eDpNZs+MLi9MiTFx2g==";
|
/**
|
* 支付宝公钥
|
*/
|
private static final String ALIPAY_PUBLIC_KEY = "MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAlW2RMACojdqTa8H+j6411Lm5UipGXXbQiswq50rUflwjTj843zNVaVpk8uJmbdmtUBJlmblgBS/a31O4L4LrHB8WxJ+w0f9DBNTq9T6b80MiAVnU/3gXK365DmbzPWS5pR9wEgJVHnfOFUbsB5AVFHV0m9hUZcPv7xveuEp3BEoD5smaDJByR+KgFw0Q0JgINhhE6bsEa3UgJ198af269LtQ5HJl1TWLI8aeqW14HrxyADIt49NB9KZ8MOdKP+66HWcrXlipKFHtccy3dff72DqPmFdESoXfLXKZyhU5w9v4Q5F6UoAGTPwl9KQwikTobNeJ/7su7X3AB6+C14J4sQIDAQAB";
|
|
|
@Resource
|
private WxMaService wxMaService;
|
|
@Resource
|
private RemoteUserService sysUserService;
|
|
@Resource
|
private RedisService redisService;
|
|
@Resource
|
private MemberLevelMapper memberLevelMapper;
|
|
|
@Resource
|
private IMemberPointsService memberPointsService;
|
|
|
@Override
|
public AppMiniLoginVO loginThird(AppMiniLoginDTO appMiniLoginDto) throws Exception {
|
AppMiniLoginVO appMiniLoginVo = new AppMiniLoginVO();
|
if(appMiniLoginDto.getType()==1){
|
if (appMiniLoginDto.getAuth_code()== null || appMiniLoginDto.getAuth_code().length() == 0) {
|
} else {
|
AppMiniLoginVO user=new AppMiniLoginVO();
|
//String serverUrl, String appId, String privateKey, String format,String charset, String alipayPublicKey, String signType
|
//实例化客户端 参数：正式环境URL,Appid,商户私钥 PKCS8格式,字符编码格式,字符格式,支付宝公钥,签名方式
|
AlipayClient alipayClient = new DefaultAlipayClient(ALIPAY_BORDER_PROD,APP_ID_PROD, APP_PRIVATE_KEY, "json", "GBK", ALIPAY_PUBLIC_KEY, "RSA2");
|
AlipaySystemOauthTokenRequest request = new AlipaySystemOauthTokenRequest();
|
// 值为authorization_code时，代表用code换取
|
request.setGrantType("authorization_code");
|
//授权码，用户对应用授权后得到的
|
request.setCode(appMiniLoginDto.getAuth_code());
|
//这里使用execute方法
|
AlipaySystemOauthTokenResponse response = null;
|
try {
|
response = alipayClient.execute(request);
|
} catch (AlipayApiException e) {
|
throw new RuntimeException(e);
|
}
|
//刷新令牌，上次换取访问令牌时得到。见出参的refresh_token字段
|
request.setRefreshToken(response.getAccessToken());
|
|
//返回成功时 就将唯一标识返回
|
if (response.isSuccess()) {
|
System.out.println("调用成功");
|
//我这里只返回了一个字段给前端用
|
String user1= response.getOpenId();
|
|
LambdaQueryWrapper<Member> wrapper= Wrappers.lambdaQuery();
|
wrapper.eq(Member::getPhone, appMiniLoginDto.getPhone());
|
Member member=this.getOne(wrapper);
|
SysUser sysUser = null;
|
if (member != null) {
|
sysUser = sysUserService.getSysUser(member.getUserId()).getData();
|
appMiniLoginVo.setZfbuserid(response.getOpenId());
|
appMiniLoginVo.setSysUser(sysUser);
|
appMiniLoginVo.setMemberid(member.getId());
|
Member byId = this.getById(member.getId());
|
byId.setZfbOpenid(response.getOpenId());
|
if (appMiniLoginDto.getPhone()!=null){
|
byId.setPhone(appMiniLoginDto.getPhone());
|
this.updateById(byId);
|
}
|
}else{
|
//创建新用户
|
String memberId = IdUtils.simpleUUID();
|
sysUser = new SysUser();
|
sysUser.setUserName(memberId);
|
sysUser.setNickName("白金用户");
|
sysUser.setUserType("03");
|
sysUser.setPhonenumber(response.getOpenId());
|
sysUser.setAvatar(
|
"https://jyzx-obs.obs.cn-sccd1.ctyun.cn/ca8552a34fb64d4d846afa1b5b173cf9.png");
|
String password = "123456";
|
sysUser.setPassword(SecurityUtils.encryptPassword(password));
|
sysUser = sysUserService.registerUser(sysUser).getData();
|
if (sysUser==null){
|
sysUser = sysUserService.getSysUser(member.getUserId()).getData();
|
}
|
member = new Member();
|
member.setUserId(sysUser.getUserId());
|
member.setDelFlag(0);
|
member.setNickname("白酒用户");
|
member.setPhone(appMiniLoginDto.getPhone());
|
member.setAvatar(
|
"https://jyzx-obs.obs.cn-sccd1.ctyun.cn/ca8552a34fb64d4d846afa1b5b173cf9.png");
|
member.setZfbOpenid(response.getOpenId());
|
this.save(member);
|
appMiniLoginVo.setZfbuserid(response.getUserId());
|
appMiniLoginVo.setSysUser(sysUser);
|
appMiniLoginVo.setMemberid(member.getId());
|
}
|
|
}
|
}
|
}else{
|
WxMaJscode2SessionResult session = null;
|
String unionid;
|
String openid;
|
String sessionKey = null;
|
//获取session
|
try {
|
session = wxMaService.getUserService().getSessionInfo(appMiniLoginDto.getCode());
|
} catch (Exception e) {
|
e.printStackTrace();
|
return null;
|
}
|
if (session != null && StringUtils.isNotBlank(session.getOpenid())) {
|
unionid = session.getUnionid();
|
openid = session.getOpenid();
|
sessionKey = session.getSessionKey();
|
//获取用户
|
LambdaQueryWrapper<Member> wrapper= Wrappers.lambdaQuery();
|
wrapper.eq(Member::getPhone, appMiniLoginDto.getPhone());
|
Member member=this.getOne(wrapper);
|
SysUser sysUser = null;
|
if (member != null) {
|
sysUser = sysUserService.getSysUser(member.getUserId()).getData();
|
appMiniLoginVo.setMiniOpenid(member.getMiniOpenid());
|
appMiniLoginVo.setWxUnionid(member.getWxUnionid());
|
appMiniLoginVo.setSysUser(sysUser);
|
appMiniLoginVo.setMemberid(member.getId());
|
Member byId = this.getById(member.getId());
|
byId.setMiniOpenid(openid);
|
byId.setWxUnionid(unionid);
|
if (appMiniLoginDto.getPhone() != null) {
|
byId.setPhone(appMiniLoginDto.getPhone());
|
this.updateById(byId);
|
}
|
} else {
|
// 创建新用户
|
String memberId = IdUtils.simpleUUID();
|
sysUser = new SysUser();
|
sysUser.setUserName(memberId);
|
sysUser.setNickName("白金用户");
|
sysUser.setUserType("03");
|
sysUser.setAvatar(
|
"https://jyzx-obs.obs.cn-sccd1.ctyun.cn/ca8552a34fb64d4d846afa1b5b173cf9.png");
|
String password = "123456";
|
sysUser.setPassword(SecurityUtils.encryptPassword(password));
|
sysUser = sysUserService.registerUser(sysUser).getData();
|
if (sysUser == null) {
|
sysUser = sysUserService.getSysUser(member.getUserId()).getData();
|
}
|
member = new Member();
|
member.setUserId(sysUser.getUserId());
|
member.setDelFlag(0);
|
member.setNickname("白酒用户");
|
member.setAvatar(
|
"https://jyzx-obs.obs.cn-sccd1.ctyun.cn/ca8552a34fb64d4d846afa1b5b173cf9.png");
|
member.setWxUnionid(unionid);
|
member.setPhone(appMiniLoginDto.getPhone());
|
member.setMiniOpenid(openid);
|
this.save(member);
|
appMiniLoginVo.setMiniOpenid(member.getMiniOpenid());
|
appMiniLoginVo.setWxUnionid(member.getWxUnionid());
|
appMiniLoginVo.setSysUser(sysUser);
|
appMiniLoginVo.setMemberid(member.getId());
|
}
|
}
|
}
|
|
return appMiniLoginVo;
|
}
|
|
|
|
|
@Override
|
public Member getMembeid(MemberDTO memberDTO) {
|
return this.getById(memberDTO.getMemberid());
|
}
|
|
|
@Override
|
public void updateMembeid(MemberDTO memberDTO) {
|
Member member= this.getById(memberDTO.getMemberid());
|
if (memberDTO.getAvatar()!=null){
|
member.setAvatar(memberDTO.getAvatar());
|
}
|
if (memberDTO.getNickname()!=null){
|
member.setNickname(memberDTO.getNickname());
|
}
|
this.updateById(member);
|
|
}
|
|
@Override
|
public void authentificationMembe(MemberDTO memberDTO) {
|
Member member= this.getById(memberDTO.getMemberid());
|
member.setPhone(memberDTO.getPhone());
|
if(memberDTO.getIdNumber()==null){
|
throw new ServiceException("身份证号不能为空");
|
}
|
if(memberDTO.getRealName()==null){
|
throw new ServiceException("姓名不能为空");
|
}
|
member.setIdNumber(memberDTO.getIdNumber());
|
member.setRealName(memberDTO.getRealName());
|
String realname = "";// 姓名
|
String idcard = "";// 身份证
|
int type = 1;// 普通版,不需要加密
|
Map<String, Object> params = new HashMap<>();
|
params.put("realname", memberDTO.getRealName());
|
params.put("idcard", memberDTO.getIdNumber());
|
CloseableHttpClient httpClient = HttpClients.createDefault();
|
CloseableHttpResponse response = null;
|
String result = null;
|
String url = query_url;
|
try {
|
url = new StringBuffer(url).append("&").append(urlencode(params)).toString();
|
HttpGet httpget = new HttpGet(url);
|
httpget.setConfig(config);
|
response = httpClient.execute(httpget);
|
HttpEntity resEntity = response.getEntity();
|
if (resEntity != null) {
|
result = IOUtils.toString(resEntity.getContent(), "UTF-8");
|
}
|
EntityUtils.consume(resEntity);
|
} catch (Exception e) {
|
e.printStackTrace();
|
} finally {
|
try {
|
response.close();
|
httpClient.close();
|
} catch (IOException e) {
|
throw new RuntimeException("姓名或者身份证号有误");
|
}
|
}
|
JSONObject jsonObject= JSON.parseObject(result);
|
String object1= jsonObject.get("reason").toString();
|
if(!object1.equals("成功")){
|
throw new ServiceException("实名认证失败,姓名或者身份证号有误");
|
}
|
|
|
String object= jsonObject.get("result").toString();
|
JSONObject jsonObject1= JSON.parseObject(object);
|
if (Integer.valueOf(jsonObject1.get("res").toString())==2){
|
throw new ServiceException("实名认证失败");
|
}
|
String sex=getGender(memberDTO.getIdNumber());
|
if (sex.equals("女")){
|
member.setGender(GenderEnum.FEMALE);
|
}
|
if (sex.equals("男")){
|
member.setGender(GenderEnum.MALE);
|
}
|
member.setIsAuthentication(2);
|
this.updateById(member);
|
}
|
|
public static String getGender(String idNumber) {
|
int genderNum = Integer.parseInt(idNumber.substring(16, 17));
|
return genderNum % 2 == 0 ? "女" : "男";
|
}
|
|
public static String urlencode(Map<String, ?> data) {
|
StringBuilder sb = new StringBuilder();
|
for (Map.Entry<String, ?> i : data.entrySet()) {
|
try {
|
sb.append(i.getKey()).append("=").append(URLEncoder.encode(i.getValue() + "", "UTF-8")).append("&");
|
} catch (UnsupportedEncodingException e) {
|
e.printStackTrace();
|
}
|
}
|
String result = sb.toString();
|
result = result.substring(0, result.lastIndexOf("&"));
|
return result;
|
}
|
|
@Override
|
public List<Member> getMemberListByIds(Collection<Long> memberIdList) {
|
return this.listByIds(memberIdList);
|
}
|
|
@Override
|
public String mobile(MobileDTO mobileDTO) {
|
Member byId = this.getById(mobileDTO.getMemberid());
|
String mobile=null;
|
if (mobileDTO.getType()==1) {
|
if (mobileDTO.getAuth_code() == null || mobileDTO.getAuth_code().length() == 0) {
|
} else {
|
//1. 获取验签和解密所需要的参数
|
Map<String, String> openapiResult = JSON.parseObject(mobileDTO.getAuth_code(),
|
new TypeReference<Map<String, String>>() {
|
}, Feature.OrderedField);
|
String signType = "RSA2";
|
String charset = "UTF-8";
|
String encryptType = "AES";
|
String sign = openapiResult.get("sign");
|
String content = openapiResult.get("response");
|
|
//如果密文的
|
boolean isDataEncrypted = !content.startsWith("{");
|
boolean signCheckPass = false;
|
|
//2. 验签
|
String signContent = content;
|
|
//如果是加密的报文则需要在密文的前后添加双引号
|
if (isDataEncrypted) {
|
signContent = "\"" + signContent + "\"";
|
}
|
try {
|
signCheckPass = AlipaySignature.rsaCheck(signContent, sign, ALIPAY_PUBLIC_KEY, charset, signType);
|
} catch (AlipayApiException e) {
|
//验签异常, 日志
|
}
|
if (!signCheckPass) {
|
//验签不通过（异常或者报文被篡改），终止流程（不需要做解密）
|
}
|
|
//3. 解密
|
String plainData = null;
|
if (isDataEncrypted) {
|
try {
|
plainData = AlipayEncrypt.decryptContent(content, encryptType, "XABBSOeWDakvuG9TDez4Qg====", charset);
|
} catch (AlipayApiException e) {
|
//解密异常, 记录日志
|
e.getMessage();
|
}
|
} else {
|
plainData = content;
|
}
|
|
Map<String, String> openapiResult1 = JSON.parseObject(plainData,
|
new TypeReference<Map<String, String>>() {
|
}, Feature.OrderedField);
|
log.info("支付宝获取手机号返回值：{}", JSON.toJSONString(openapiResult1));
|
mobile=openapiResult1.get("mobile");
|
}
|
}else{
|
if (StringUtils.isNotBlank(mobileDTO.getCode())) {
|
String responseAccessToken = null;
|
try {
|
responseAccessToken = getAccessTokenByWX();
|
} catch (Exception e) {
|
throw new RuntimeException(e);
|
}
|
|
JSONObject jsonAccessToken = JSONObject.parseObject(responseAccessToken);
|
String accessToken = jsonAccessToken.getString("access_token");
|
String errmsg = jsonAccessToken.getString("errmsg");
|
Long expiresIn = jsonAccessToken.getLong("expires_in");
|
if (StringUtils.isBlank(accessToken)) {
|
throw new ServiceException(errmsg);
|
}
|
String responseUserPhoneNumber = null;
|
try {
|
responseUserPhoneNumber = getMobileByWX(accessToken, mobileDTO.getCode());
|
log.info("微信获取手机号返回值：{}", JSON.toJSONString(responseUserPhoneNumber));
|
} catch (Exception e) {
|
throw new RuntimeException(e);
|
}
|
JSONObject jsonUserPhoneNumber = JSONObject.parseObject(responseUserPhoneNumber);
|
String phoneInfo = jsonUserPhoneNumber.getString("phone_info");
|
JSONObject jsonUserPhoneInfo = JSONObject.parseObject(phoneInfo);
|
mobile = jsonUserPhoneInfo.getString("purePhoneNumber");
|
}
|
}
|
return mobile;
|
}
|
|
public static String getAccessTokenByWX() throws Exception {
|
String host = ACCESS_TOKEN_HOST + "?appid=" + WX_APPID + "&secret=" + WX_SECRET + "&grant_type=client_credential";
|
Map<String, String> headers = new HashMap<>(8);
|
HttpResponse response = HttpUtils.doGet(host, "", "GET", headers, null);
|
return EntityUtils.toString(response.getEntity());
|
}
|
|
public static String getMobileByWX(String accessToken, String code) throws Exception {
|
Map<String, String> headers = new HashMap<>(16);
|
headers.put("Content-Type", "application/json");
|
headers.put("Accept", "application/json");
|
Map<String, String> querys = new HashMap<>(16);
|
Map<String, String> bodys = new HashMap<>(16);
|
querys.put("access_token", accessToken);
|
bodys.put("code", code);
|
String body = JSONObject.toJSONString(bodys);
|
String host = "https://api.weixin.qq.com/wxa/business/getuserphonenumber";
|
HttpResponse response = HttpUtils.doPost(host, "", "POST", headers, querys, body);
|
return EntityUtils.toString(response.getEntity());
|
}
|
|
/**
|
* 获取会员管理分页列表
|
*
|
* @param query 会员列表查询对象
|
* @return PageDTO<MgtMemberVO>
|
*/
|
@Override
|
public PageDTO<MgtMemberVO> getMemberPage(MgtMemberQuery query) {
|
Page<Member> page = this.lambdaQuery()
|
.like(StringUtils.isNotBlank(query.getRealName()), Member::getRealName,
|
query.getRealName())
|
.like(StringUtils.isNotBlank(query.getPhone()), Member::getPhone, query.getPhone())
|
.eq(StringUtils.isNotBlank(query.getLevel()), Member::getLevel, query.getLevel())
|
.orderByDesc(Member::getCreateTime)
|
.page(new Page<>(query.getPageCurr(), query.getPageSize()));
|
if (StringUtils.isEmpty(page.getRecords())) {
|
return PageDTO.empty(page.getTotal(), page.getPages());
|
}
|
return PageDTO.of(page, MgtMemberVO.class);
|
}
|
|
@Override
|
@Transactional(propagation = Propagation.REQUIRES_NEW)
|
public void updMembeOne(updMembeOneDTO dMembeOneDTO) {
|
Member byId = this.getById(dMembeOneDTO.getMemberId());
|
if (dMembeOneDTO.getMoney()!=null){
|
if (dMembeOneDTO.getType()==1){
|
BigDecimal big=byId.getMoney().add(dMembeOneDTO.getMoney());
|
byId.setMoney(big);
|
}else {
|
BigDecimal big=byId.getMoney().subtract(dMembeOneDTO.getMoney());
|
byId.setMoney(big);
|
}
|
} if (dMembeOneDTO.getTotalPoints()!=null){
|
if (dMembeOneDTO.getType()==1){
|
Integer big=byId.getTotalPoints()+dMembeOneDTO.getTotalPoints();
|
byId.setTotalPoints(big);
|
}else {
|
Integer big = Math.max(byId.getTotalPoints() - dMembeOneDTO.getTotalPoints(), 0);
|
byId.setTotalPoints(big);
|
}
|
}
|
this.updateById(byId);
|
LambdaQueryWrapper<MemberLevel> wrapper= Wrappers.lambdaQuery();
|
List<MemberLevel> list = memberLevelMapper.selectList(wrapper);
|
int appropriateLevel = findAppropriateLevel(list, byId.getMoney());
|
byId.setLevel(appropriateLevel);
|
this.updateById(byId);
|
}
|
|
|
private static int findAppropriateLevel(List<MemberLevel> memberLevels, BigDecimal money) {
|
// 对于最开始的level，设置为0（假设0是最低等级）
|
int level = 0;
|
|
for (int i = 0; i < memberLevels.size(); i++) {
|
MemberLevel currentLevel = memberLevels.get(i);
|
BigDecimal currentCumulativeConsumption = currentLevel.getCumulativeConsumption();
|
|
// 如果当前成员的消费额小于等于当前等级的累积消费额
|
if (money.compareTo(currentCumulativeConsumption) < 0) {
|
return level;
|
}
|
|
// 更新level为当前等级，准备下一次比较
|
level = currentLevel.getLevel();
|
}
|
|
// 如果遍历完成后还没有返回，说明该成员的消费额高于所有已定义等级的累积消费额
|
level = memberLevels.get(memberLevels.size() - 1).getLevel();
|
return level;
|
}
|
|
/**
|
* 获取用户详情
|
*
|
* @param id 会员id
|
* @return MgtMemberVO
|
*/
|
@Override
|
public MgtMemberVO getMemberById(Long id) {
|
Member member = this.getById(id);
|
if (StringUtils.isNull(member)) {
|
throw new ServiceException("会员不存在");
|
}
|
return BeanUtils.copyBean(member, MgtMemberVO.class);
|
}
|
|
/**
|
* 获取积分明细分页列表
|
*
|
* @param query 会员积分明细查询对象
|
* @return PageDTO<MgtMemberPointsVO>
|
*/
|
@Override
|
public PageDTO<MgtMemberPointsVO> getMemberPoints(MgtMemberPointsQuery query) {
|
Page<MemberPoints> page = memberPointsService.lambdaQuery()
|
.eq(MemberPoints::getMemberId, query.getId())
|
.page(new Page<>(query.getPageCurr(), query.getPageSize()));
|
if (StringUtils.isEmpty(page.getRecords())) {
|
return PageDTO.empty(page);
|
}
|
return PageDTO.of(page, MgtMemberPointsVO.class);
|
}
|
|
@Override
|
public List<Member> getMemberListByCondition(MemberDTO memberDTO) {
|
return this.lambdaQuery()
|
.like(StringUtils.isNotBlank(memberDTO.getNickname()), Member::getNickname,
|
memberDTO.getNickname())
|
.like(StringUtils.isNotBlank(memberDTO.getRealName()), Member::getRealName,
|
memberDTO.getRealName())
|
.like(StringUtils.isNotBlank(memberDTO.getPhone()), Member::getPhone,
|
memberDTO.getPhone()).list();
|
}
|
|
@Override
|
public List<Member> getMemberListByLevel(List<String> memberLevelList) {
|
return this.lambdaQuery()
|
.in(StringUtils.isNotEmpty(memberLevelList), Member::getLevel, memberLevelList)
|
.orderByDesc(Member::getLevel)
|
.list();
|
}
|
|
@Override
|
public Member getMemberByUserId(Long userId) {
|
return this.lambdaQuery().eq(Member::getUserId, userId).oneOpt().orElse(null);
|
}
|
|
/**
|
* 编辑用户会员分类
|
* @param dto
|
* @return
|
*/
|
@Override
|
public void updMemberClassify(MgtMemberDTO dto) {
|
Member member = BeanUtils.copyBean(dto, Member.class);
|
updateById(member);
|
}
|
}
|
