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 |  367 +++++++++++++++++++++++++++++++++++----------------
 1 files changed, 251 insertions(+), 116 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 c7f6ea2..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
@@ -5,38 +5,58 @@
 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.dto.MemberDTO;
+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 java.io.IOException;
-import java.io.UnsupportedEncodingException;
-import java.net.URLEncoder;
-import java.util.*;
-import java.util.concurrent.TimeUnit;
-import javax.annotation.Resource;
-
+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.AppMiniRegisterDTO;
+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;
@@ -92,15 +112,15 @@
     /**
      * appID
      **/
-    private static final String APP_ID_PROD = "wxe91f1af7638aa5dd";
+    private static final String APP_ID_PROD = "2021004147684313";
     /**
      * 私钥
      */
-    private static final String APP_PRIVATE_KEY = "";
+    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 = "";
+    private static final String ALIPAY_PUBLIC_KEY = "MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAh+tCVKqUmlHDL8Ki1TUJtzE5IKV1irJuoHWZTvndJCKJJ8bdWxL9mu5xsy8KkfrnS6wJIKBMLTxMoYQHG7l2Gt07YyUCYHS5+yvbHtTkyFFy2KRPeUEWXz1Tm4juvInDvvr+n7v9ETepToGhC+UDlQcBvuSppw8N+463E+1GRrC4APwXYGLzaIvYvDHcQAULkWhXsjzxJSmeSi12kqWKlgnVJC1y0FT8xQtvhwShfaIqKwzErn9S2z7JjdXboJMUYQHoqF1A4SmWY8c0qawqvx2hGP36W3RDQ4cczzFwUHS1Cylhsbgh1COc4OdANCX4Np2NUzaRDCNzN0WVFKtK+QIDAQAB";
 
 
     @Resource
@@ -112,11 +132,17 @@
     @Resource
     private RedisService redisService;
 
+    @Resource
+    private MemberLevelMapper memberLevelMapper;
+
+
+    @Resource
+    private IMemberPointsService memberPointsService;
+
 
     @Override
-    public AppMiniLoginVO loginThird(AppMiniLoginDTO appMiniLoginDto) {
+    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 {
@@ -138,19 +164,20 @@
                 }
                 //刷新令牌,上次换取访问令牌时得到。见出参的refresh_token字段
                 request.setRefreshToken(response.getAccessToken());
+
                 //返回成功时 就将唯一标识返回
                 if (response.isSuccess()) {
                     System.out.println("调用成功");
                     //我这里只返回了一个字段给前端用
-                    String user1= response.getUserId();
+                    String user1= response.getOpenId();
 
                     LambdaQueryWrapper<Member> wrapper= Wrappers.lambdaQuery();
-                    wrapper.eq(Member::getZfbOpenid,response.getUserId());
+                    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.getUserId());
+                        appMiniLoginVo.setZfbuserid(response.getOpenId());
                         appMiniLoginVo.setSysUser(sysUser);
                         appMiniLoginVo.setMemberid(member.getId());
                         redisService.setCacheObject(SecurityConstant.SESSION_KEY + response.getUserId(), null, 1L, TimeUnit.DAYS);
@@ -159,24 +186,23 @@
                         String memberId = IdUtils.simpleUUID();
                         sysUser = new SysUser();
                         sysUser.setUserName(memberId);
-                        sysUser.setUserType("03");
                         sysUser.setNickName("白金用户");
-                        sysUser.setPhonenumber(response.getUserId());
+                        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.getUserId());
+                        member.setZfbOpenid(response.getOpenId());
                         this.save(member);
-
-                        appMiniLoginVo.setMiniOpenid(member.getMiniOpenid());
-                        appMiniLoginVo.setWxUnionid(member.getWxUnionid());
+                        appMiniLoginVo.setZfbuserid(response.getUserId());
                         appMiniLoginVo.setSysUser(sysUser);
                         appMiniLoginVo.setMemberid(member.getId());
                     }
@@ -201,16 +227,15 @@
                 sessionKey = session.getSessionKey();
                 //获取用户
                 LambdaQueryWrapper<Member> wrapper= Wrappers.lambdaQuery();
-                wrapper.eq(Member::getZfbOpenid,session.getOpenid());
+                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(wrapper);
+                Member member1=this.getOne(wrapper1);
 
                 if (member1==null){
 
@@ -218,15 +243,14 @@
                         String memberId = IdUtils.simpleUUID();
                         sysUser = new SysUser();
                         sysUser.setUserName(memberId);
-                        sysUser.setUserType("03");
                         sysUser.setNickName("白金用户");
-                        sysUser.setPhonenumber(openid);
                         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);
@@ -235,7 +259,6 @@
                         member.setWxUnionid(unionid);
                         member.setMiniOpenid(openid);
                         this.save(member);
-
                     appMiniLoginVo.setMiniOpenid(member.getMiniOpenid());
                     appMiniLoginVo.setWxUnionid(member.getWxUnionid());
                     appMiniLoginVo.setSysUser(sysUser);
@@ -284,14 +307,12 @@
         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;
@@ -322,7 +343,6 @@
       if (Integer.valueOf(jsonObject1.get("res").toString())==2){
           throw new ServiceException("实名认证失败");
       }
-
       String  sex=getGender(idcard);
       if (sex.equals("女")){
           member.setGender(GenderEnum.FEMALE);
@@ -330,7 +350,6 @@
         if (sex.equals("男")){
             member.setGender(GenderEnum.MALE);
         }
-
         this.updateById(member);
     }
 
@@ -338,7 +357,6 @@
         int genderNum = Integer.parseInt(idNumber.substring(16, 17));
         return genderNum % 2 == 0 ? "女" : "男";
     }
-
 
     public static String urlencode(Map<String, ?> data) {
         StringBuilder sb = new StringBuilder();
@@ -355,99 +373,94 @@
     }
 
     @Override
-    public List<Member> getMemberListByIds(Set<Long> memberIdList) {
+    public List<Member> getMemberListByIds(Collection<Long> memberIdList) {
         return this.listByIds(memberIdList);
     }
 
     @Override
-    public AppMiniLoginVO miniRegister(AppMiniRegisterDTO appMiniRegisterDTO) {
-            AppMiniLoginVO appMiniLoginVO =new AppMiniLoginVO();
-           SysUser sysUser;
-            if (appMiniRegisterDTO.getType() == 1) {
-                LambdaQueryWrapper<Member> wrapper = Wrappers.lambdaQuery();
-                wrapper.eq(Member::getZfbOpenid, appMiniRegisterDTO.getZfbuserid());
-                Member member = this.getOne(wrapper);
+    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");
 
-                //获取用户为空则新建
-                if (member == null) {
-                    //创建新用户
-                    String memberId = IdUtils.simpleUUID();
-                    sysUser = new SysUser();
-                    sysUser.setUserName(memberId);
-                    sysUser.setUserType("03");
-                    sysUser.setNickName("白金用户");
-                    sysUser.setPhonenumber(appMiniRegisterDTO.getMiniOpenid());
-                    sysUser.setAvatar("https://hongruitang.oss-cn-beijing.aliyuncs.com/default.png");
-                    String password = "123456";
-                    sysUser.setPassword(SecurityUtils.encryptPassword(password));
-                    sysUser = sysUserService.registerUser(sysUser).getData();
+                //如果密文的
+                boolean isDataEncrypted = !content.startsWith("{");
+                boolean signCheckPass = false;
 
-                    member = new Member();
-                    member.setUserId(sysUser.getUserId());
-                    member.setDelFlag(0);
-                    member.setRealName("白酒用户");
-                    member.setAvatar("https://hongruitang.oss-cn-beijing.aliyuncs.com/default.png");
-                    member.setWxUnionid(appMiniRegisterDTO.getWxUnionid());
-                    member.setMiniOpenid(appMiniRegisterDTO.getMiniOpenid());
-                    this.save(member);
+                //2. 验签
+                String signContent = content;
 
-                    appMiniLoginVO.setMiniOpenid(member.getMiniOpenid());
-                    appMiniLoginVO.setWxUnionid(member.getWxUnionid());
-                    appMiniLoginVO.setSysUser(sysUser);
-                    appMiniLoginVO.setMemberid(member.getId());
-                } else {
-                    sysUser = sysUserService.getSysUser(member.getUserId()).getData();
-                    appMiniLoginVO.setZfbuserid( appMiniRegisterDTO.getZfbuserid());
-                    appMiniLoginVO.setSysUser(sysUser);
-                    appMiniLoginVO.setMemberid(member.getId());
+                //如果是加密的报文则需要在密文的前后添加双引号
+                if (isDataEncrypted) {
+                    signContent = "\"" + signContent + "\"";
+                }
+                try {
+                    signCheckPass = AlipaySignature.rsaCheck(signContent, sign, ALIPAY_PUBLIC_KEY, charset, signType);
+                } catch (AlipayApiException e) {
+                    //验签异常, 日志
+                }
+                if (!signCheckPass) {
+                    //验签不通过(异常或者报文被篡改),终止流程(不需要做解密)
                 }
 
-            }
-            if (appMiniRegisterDTO.getType() == 2) {
-                    LambdaQueryWrapper<Member> wrapper = Wrappers.lambdaQuery();
-                    wrapper.eq(Member::getMiniOpenid, appMiniRegisterDTO.getMiniOpenid());
-                    Member member = this.getOne(wrapper);
-                    //获取用户为空则新建
-                    if (member == null) {
-                        //创建新用户
-                        String memberId = IdUtils.simpleUUID();
-                        sysUser = new SysUser();
-                        sysUser.setUserName(memberId);
-                        sysUser.setUserType("03");
-                        sysUser.setNickName("白金用户");
-                        sysUser.setPhonenumber(appMiniRegisterDTO.getMiniOpenid());
-                        sysUser.setAvatar("https://hongruitang.oss-cn-beijing.aliyuncs.com/default.png");
-                        String password = "123456";
-                        sysUser.setPassword(SecurityUtils.encryptPassword(password));
-                        sysUser = sysUserService.registerUser(sysUser).getData();
-
-                        member = new Member();
-                        member.setUserId(sysUser.getUserId());
-                        member.setDelFlag(0);
-                        member.setRealName("白酒用户");
-                        member.setAvatar("https://hongruitang.oss-cn-beijing.aliyuncs.com/default.png");
-                        member.setWxUnionid(appMiniRegisterDTO.getWxUnionid());
-                        member.setMiniOpenid(appMiniRegisterDTO.getMiniOpenid());
-                        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());
+                //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);
             }
-             return appMiniLoginVO;
+        }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 {
@@ -471,6 +484,128 @@
         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