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 |  293 ++++++++++++++++++++++++++++++++++++++++------------------
 1 files changed, 200 insertions(+), 93 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 6bc6097..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,9 +5,13 @@
 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;
@@ -17,31 +21,40 @@
 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.dto.MemberDTO;
-import com.ruoyi.system.api.domain.dto.MemberDTO;
+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.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.Set;
 import java.util.concurrent.TimeUnit;
 import javax.annotation.Resource;
 import org.apache.commons.io.IOUtils;
@@ -119,11 +132,17 @@
     @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 {
@@ -173,11 +192,9 @@
                         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);
@@ -216,7 +233,6 @@
                 if (member != null) {
                     sysUser = sysUserService.getSysUser(member.getUserId()).getData();
                 }
-
                 LambdaQueryWrapper<Member> wrapper1= Wrappers.lambdaQuery();
                 wrapper1.eq(Member::getMiniOpenid,openid);
                 Member member1=this.getOne(wrapper1);
@@ -235,8 +251,6 @@
                         if (sysUser==null){
                             sysUser = sysUserService.getSysUser(member.getUserId()).getData();
                         }
-
-
                         member = new Member();
                         member.setUserId(sysUser.getUserId());
                         member.setDelFlag(0);
@@ -245,7 +259,6 @@
                         member.setWxUnionid(unionid);
                         member.setMiniOpenid(openid);
                         this.save(member);
-
                     appMiniLoginVo.setMiniOpenid(member.getMiniOpenid());
                     appMiniLoginVo.setWxUnionid(member.getWxUnionid());
                     appMiniLoginVo.setSysUser(sysUser);
@@ -294,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;
@@ -332,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);
@@ -340,7 +350,6 @@
         if (sex.equals("男")){
             member.setGender(GenderEnum.MALE);
         }
-
         this.updateById(member);
     }
 
@@ -348,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();
@@ -365,97 +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.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.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 {
@@ -499,6 +504,108 @@
         }
         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