From 05c1b69b9a694cf99e9f07f12ebf034cb2450f5f Mon Sep 17 00:00:00 2001 From: mitao <2763622819@qq.com> Date: 星期一, 10 二月 2025 10:15:38 +0800 Subject: [PATCH] websocket改造 --- ruoyi-modules/ruoyi-member/src/main/java/com/ruoyi/member/service/impl/MemberServiceImpl.java | 629 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 626 insertions(+), 3 deletions(-) diff --git a/ruoyi-modules/ruoyi-member/src/main/java/com/ruoyi/member/service/impl/MemberServiceImpl.java b/ruoyi-modules/ruoyi-member/src/main/java/com/ruoyi/member/service/impl/MemberServiceImpl.java index 21a995e..ba48a02 100644 --- a/ruoyi-modules/ruoyi-member/src/main/java/com/ruoyi/member/service/impl/MemberServiceImpl.java +++ b/ruoyi-modules/ruoyi-member/src/main/java/com/ruoyi/member/service/impl/MemberServiceImpl.java @@ -1,10 +1,72 @@ package com.ruoyi.member.service.impl; -import com.ruoyi.member.domain.pojo.Member; -import com.ruoyi.member.mapper.MemberMapper; -import com.ruoyi.member.service.IMemberService; + +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.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> @@ -14,7 +76,568 @@ * @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); + } } + + + -- Gitblit v1.7.1