From 2f2eb2bb2c6a5a16b7081dbbe3b683acf18d04bc Mon Sep 17 00:00:00 2001
From: rentaiming <806181062@qq.com>
Date: 星期二, 11 六月 2024 18:18:05 +0800
Subject: [PATCH] 用户端商品
---
ruoyi-modules/ruoyi-member/src/main/java/com/ruoyi/member/service/impl/MemberServiceImpl.java | 598 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 595 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..be3b6b2 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,9 +1,71 @@
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.IMemberLevelService;
+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.constants.SecurityConstant;
+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 java.util.concurrent.TimeUnit;
+import javax.annotation.Resource;
+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;
/**
@@ -17,4 +79,534 @@
@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 = "";
+ //明文查询地址
+ 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 = "wxe91f1af7638aa5dd";
+
+ private static final String WX_SECRET = "a787e1a462715604e0c9528b6d8960d1";
+
+ //支付寶
+ /**
+ * 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 = "2021004147684313";
+ /**
+ * 私钥
+ */
+ private static final String APP_PRIVATE_KEY = "MIIEvQIBADANBgkqhkiG9w0BAQEFAASCBKcwggSjAgEAAoIBAQCg31tKXap7oTKKKDtfXc/hQjriSJkKopfRkh9j1UA/BpY+6GLkbJhg8kw9CRCILjfi5M0F3FCu+j1ogeDE1ivRGJlX1l/TGj+HuM1g8qLx/tD5D+9nJq5UHfaoKxXPko8H3AWcN1n/MAq3kRwUJRkeYJyYrZ7Sd6RU2taVLktWu92lqoUahjFkQSkdJoKi77v5i1T56PLRFfClt72tnvgol4OXBfFEjpGVrnuYoiHCgLV9eN5Qmvdas/04TtU396p+atYycU2P/dU9fdc8NFFFJo+eYH7astJXIQsowpLtTS7lavQuzCcLvC20pRBPhql5+5X96DVdnOLMbdUKwLQ9AgMBAAECggEAZLuXgVhnYSSN7f7FNrEaczWyg3DsC8HGCN9TsoKcyRpJyDhhfCEXxVTTMkDTzkIKkpOsYagUCYz+GMuCwB5Pr42Ur3C37gr4jvbD+5nTOG7T0bENumx5Kojco27fKGvgDg7SoH/0ZZtiipFdoKueL+xVAjFtSuLJzqx9Q0qKuFLJH0lrQfHYyGcq9ZzrPKLrMZb3Ve3upmpaLjIddZmqnzK7g5lx/OLHEujXIR9u0VWzzxqeaFkgCAMuyzkNYwlpqtiTJsEggbnG9YsLf0n156F0dXo2i44fUav+bKU2ksv7YmENx3R9gPDuPAKH+MwQlwVIc6tR8jKoz0cUbmaujQKBgQDhvaQd4jg9zszdVw1enPWKWViu4rsEFirIz3CUBRB3g2mkZ+tXpQQps7bL7KLBFfXmVYiVMu4EoOfZlkAjJPbFMj9aSPZ3pbx0VnHG8+3T9T2eJdzZp/CehG3MyycNHxAbbl2B04Chiiyf67R0b4ZLMHoElQgJP9jF1q3Xiloi0wKBgQC2b73S4LZWlWkyIsmHYHmXyWta64W2whlL4Nsy97tl4kZNfLCG7mgG5FhHhi16lT7J6Sw1D2FgFov2B1r9+yGBRxckGzWoY5m6FtBE/l+42+gxsB41+kEgirVjlEaX7YBXmnux2LntPVlJOG6HTizjcUnTesGIRvwbmbR2tuXCrwKBgQCMJwKq7xW+AhQdY/vP/yFPaRNvWSOFcQHVNT2PGOnVWciQI1jxTGmePo7CY0PVH35RKE+pWjp+syvfYrKlX0C6w+yjcGNde4/apwTy4eWJ0FwWQSmyFNuGf2/wUz0Gn3+PmGEDxr25DaGRFHUwSUGWkx1elOytWW+LvTKnfKVjswKBgGuh50MnskvI4IRkw7Mr9vDXM5AzjfLx9syuf4RFZflJEyMaImeo9hTC2VZxUhmVPbMP7zXqug9fnflsA4H+jJjh4UQ7DWAoSwTf+sYJsV211/qgpmJAH/Zb/4Idc7yksWh9yuZ1L9RIsomhUoxfUdpp9x1euhl1j72U5ER5yXofAoGAZNrIYFWk4S8mqFY8/h0YVGxT7Hj0ppLsq20N4OzglScoEEG+aYmWDOQU9kWcxsD44bMdzk2k0DyOhHbp8Tjd1hp0UFb03s8HgERcFHMZMzQ5oqtWQEoYiyQZxReXZZvWUbV+dg1HXXG8I26XAKb3OWFUIBBfKa2/Ig9ensY9m+M=";
+ /**
+ * 支付宝公钥
+ */
+ private static final String ALIPAY_PUBLIC_KEY = "MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAh+tCVKqUmlHDL8Ki1TUJtzE5IKV1irJuoHWZTvndJCKJJ8bdWxL9mu5xsy8KkfrnS6wJIKBMLTxMoYQHG7l2Gt07YyUCYHS5+yvbHtTkyFFy2KRPeUEWXz1Tm4juvInDvvr+n7v9ETepToGhC+UDlQcBvuSppw8N+463E+1GRrC4APwXYGLzaIvYvDHcQAULkWhXsjzxJSmeSi12kqWKlgnVJC1y0FT8xQtvhwShfaIqKwzErn9S2z7JjdXboJMUYQHoqF1A4SmWY8c0qawqvx2hGP36W3RDQ4cczzFwUHS1Cylhsbgh1COc4OdANCX4Np2NUzaRDCNzN0WVFKtK+QIDAQAB";
+
+
+ @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::getZfbOpenid,response.getOpenId());
+ 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());
+ redisService.setCacheObject(SecurityConstant.SESSION_KEY + response.getUserId(), null, 1L, TimeUnit.DAYS);
+ }else{
+ //创建新用户
+ String memberId = IdUtils.simpleUUID();
+ sysUser = new SysUser();
+ sysUser.setUserName(memberId);
+ sysUser.setNickName("白金用户");
+ sysUser.setPhonenumber(response.getOpenId());
+ sysUser.setAvatar("https://hongruitang.oss-cn-beijing.aliyuncs.com/default.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://hongruitang.oss-cn-beijing.aliyuncs.com/default.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::getMiniOpenid,session.getOpenid());
+ Member member=this.getOne(wrapper);
+ SysUser sysUser = null;
+ if (member != null) {
+ sysUser = sysUserService.getSysUser(member.getUserId()).getData();
+ }
+ LambdaQueryWrapper<Member> wrapper1= Wrappers.lambdaQuery();
+ wrapper1.eq(Member::getMiniOpenid,openid);
+ Member member1=this.getOne(wrapper1);
+
+ if (member1==null){
+
+ //创建新用户
+ String memberId = IdUtils.simpleUUID();
+ sysUser = new SysUser();
+ sysUser.setUserName(memberId);
+ sysUser.setNickName("白金用户");
+ sysUser.setAvatar("https://hongruitang.oss-cn-beijing.aliyuncs.com/default.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://hongruitang.oss-cn-beijing.aliyuncs.com/default.png");
+ member.setWxUnionid(unionid);
+ member.setMiniOpenid(openid);
+ this.save(member);
+ appMiniLoginVo.setMiniOpenid(member.getMiniOpenid());
+ appMiniLoginVo.setWxUnionid(member.getWxUnionid());
+ appMiniLoginVo.setSysUser(sysUser);
+ appMiniLoginVo.setMemberid(member.getId());
+ } else {
+ sysUser = sysUserService.getSysUser(member.getUserId()).getData();
+ appMiniLoginVo.setMiniOpenid(member.getMiniOpenid());
+ appMiniLoginVo.setWxUnionid(member.getWxUnionid());
+ appMiniLoginVo.setSysUser(sysUser);
+ appMiniLoginVo.setMemberid(member.getId());
+ }
+
+
+
+ redisService.setCacheObject(SecurityConstant.SESSION_KEY + openid, sessionKey, 1L, TimeUnit.DAYS);
+ }
+ }
+
+ 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());
+ member.setIdNumber(memberDTO.getIdNumber());
+ member.setRealName(memberDTO.getRealName());
+ String realname = "";// 姓名
+ String idcard = "";// 身份证
+ int type = 1;// 普通版,不需要加密
+ Map<String, Object> params = new HashMap<>();
+ params.put("realname", realname);
+ params.put("idcard", idcard);
+ 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(e);
+ }
+ }
+ JSONObject jsonObject= JSON.parseObject(result);
+ 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(idcard);
+ if (sex.equals("女")){
+ member.setGender(GenderEnum.FEMALE);
+ }
+ if (sex.equals("男")){
+ member.setGender(GenderEnum.MALE);
+ }
+ 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 void mobile(MobileDTO mobileDTO) {
+ Member byId = this.getById(mobileDTO.getMemberid());
+ 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, "VSpPcLQjLSoTz6Yd7KNoyQ==", charset);
+ } catch (AlipayApiException e) {
+ //解密异常, 记录日志
+ e.getMessage();
+ }
+ } else {
+ plainData = content;
+ }
+
+ Map<String, String> openapiResult1 = JSON.parseObject(plainData,
+ new TypeReference<Map<String, String>>() {
+ }, Feature.OrderedField);
+
+ byId.setPhone(openapiResult1.get("mobile"));
+ this.updateById(byId);
+ }
+ }else{
+ 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());
+ } catch (Exception e) {
+ throw new RuntimeException(e);
+ }
+ JSONObject jsonUserPhoneNumber = JSONObject.parseObject(responseUserPhoneNumber);
+ String phoneInfo = jsonUserPhoneNumber.getString("phone_info");
+ JSONObject jsonUserPhoneInfo = JSONObject.parseObject(phoneInfo);
+ String mobile = jsonUserPhoneInfo.getString("purePhoneNumber");
+ byId.setPhone(mobile);
+ this.updateById(byId);
+ }
+ }
+
+ 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()
+ .select(Member::getId, Member::getNickname, Member::getRealName, Member::getPhone,
+ Member::getIdNumber)
+ .like(StringUtils.isNotBlank(query.getRealName()), Member::getRealName,
+ query.getRealName())
+ .like(StringUtils.isNotBlank(query.getPhone()), Member::getPhone, query.getPhone())
+ .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
+ 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=byId.getTotalPoints()-dMembeOneDTO.getTotalPoints();
+ byId.setTotalPoints(big);
+ }
+ }
+ this.updateById(byId);
+ LambdaQueryWrapper<MemberLevel> wrapper= Wrappers.lambdaQuery();
+ List<MemberLevel> list = memberLevelMapper.selectList(wrapper);
+ for (int i=0;i<list.size();i++){
+ if (i==0){
+ int ia = byId.getMoney().compareTo(list.get(0).getCumulativeConsumption());
+ if (ia<0){
+ byId.setLevel(0);
+ break;
+ }
+ }
+ if (i==list.size()-1){
+ BigDecimal cumulative = list.get(i - 1).getCumulativeConsumption();
+ BigDecimal cumulative1 = list.get(i).getCumulativeConsumption();
+ if (cumulative.compareTo(byId.getMoney()) <= 0 && cumulative1.compareTo(byId.getMoney()) >= 0) {
+ byId.setLevel(list.get(i).getLevel());
+ }else{
+ byId.setLevel(list.get(i).getLevel());
+ }
+ }else {
+ BigDecimal cumulative = list.get(i - 1).getCumulativeConsumption();
+ BigDecimal cumulative1 = list.get(i).getCumulativeConsumption();
+ if (cumulative.compareTo(byId.getMoney()) <= 0 && cumulative1.compareTo(byId.getMoney()) >= 0) {
+ byId.setLevel(list.get(i).getLevel());
+ }
+ }
+
+ }
+
+ }
+
+ /**
+ * 获取用户详情
+ *
+ * @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();
+ }
}
+
+
+
--
Gitblit v1.7.1