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 |  224 ++++++++++++++++++++++++++++++-------------------------
 1 files changed, 121 insertions(+), 103 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 a14c80a..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
@@ -33,12 +33,10 @@
 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;
@@ -55,8 +53,8 @@
 import java.util.HashMap;
 import java.util.List;
 import java.util.Map;
-import java.util.concurrent.TimeUnit;
 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;
@@ -67,6 +65,8 @@
 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>
@@ -76,6 +76,7 @@
  * @author mitao
  * @since 2024-05-16
  */
+@Slf4j
 @Service
 public class MemberServiceImpl extends ServiceImpl<MemberMapper, Member> implements IMemberService {
 
@@ -90,9 +91,9 @@
     //微信
     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_APPID = "wx69e3ac6e13a889b7";
 
-    private static final String WX_SECRET = "a787e1a462715604e0c9528b6d8960d1";
+    private static final String WX_SECRET = "1b8bcfcb681524ac553e72054e5271ef";
 
     //支付寶
     /**
@@ -172,7 +173,7 @@
                     String user1= response.getOpenId();
 
                     LambdaQueryWrapper<Member> wrapper= Wrappers.lambdaQuery();
-                    wrapper.eq(Member::getZfbOpenid,response.getOpenId());
+                    wrapper.eq(Member::getPhone, appMiniLoginDto.getPhone());
                     Member member=this.getOne(wrapper);
                     SysUser sysUser = null;
                     if (member != null) {
@@ -180,15 +181,22 @@
                         appMiniLoginVo.setZfbuserid(response.getOpenId());
                         appMiniLoginVo.setSysUser(sysUser);
                         appMiniLoginVo.setMemberid(member.getId());
-                        redisService.setCacheObject(SecurityConstant.SESSION_KEY + response.getUserId(), null, 1L, TimeUnit.DAYS);
+                        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://hongruitang.oss-cn-beijing.aliyuncs.com/default.png");
+                        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();
@@ -199,7 +207,9 @@
                         member.setUserId(sysUser.getUserId());
                         member.setDelFlag(0);
                         member.setNickname("白酒用户");
-                        member.setAvatar("https://hongruitang.oss-cn-beijing.aliyuncs.com/default.png");
+                        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());
@@ -227,53 +237,52 @@
                 sessionKey = session.getSessionKey();
                 //获取用户
                 LambdaQueryWrapper<Member> wrapper= Wrappers.lambdaQuery();
-                wrapper.eq(Member::getMiniOpenid,session.getOpenid());
+                wrapper.eq(Member::getPhone, appMiniLoginDto.getPhone());
                 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());
+                    Member byId = this.getById(member.getId());
+                    byId.setMiniOpenid(openid);
+                    byId.setWxUnionid(unionid);
+                    if (appMiniLoginDto.getPhone() != null) {
+                        byId.setPhone(appMiniLoginDto.getPhone());
+                        this.updateById(byId);
                     }
-
-
-
-                redisService.setCacheObject(SecurityConstant.SESSION_KEY + openid, sessionKey, 1L, TimeUnit.DAYS);
+                } 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());
+                }
             }
         }
 
@@ -287,6 +296,7 @@
     public Member getMembeid(MemberDTO memberDTO) {
         return  this.getById(memberDTO.getMemberid());
     }
+
 
     @Override
     public void updateMembeid(MemberDTO memberDTO) {
@@ -340,13 +350,13 @@
                 response.close();
                 httpClient.close();
             } catch (IOException e) {
-                throw new RuntimeException(e);
+                throw new RuntimeException("姓名或者身份证号有误");
             }
         }
      JSONObject jsonObject= JSON.parseObject(result);
         String object1= jsonObject.get("reason").toString();
         if(!object1.equals("成功")){
-            throw new ServiceException(object1);
+            throw new ServiceException("实名认证失败,姓名或者身份证号有误");
         }
 
 
@@ -391,8 +401,9 @@
     }
 
     @Override
-    public void mobile(MobileDTO mobileDTO) {
+    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 {
@@ -430,7 +441,7 @@
                 String plainData = null;
                 if (isDataEncrypted) {
                     try {
-                        plainData = AlipayEncrypt.decryptContent(content, encryptType, "VSpPcLQjLSoTz6Yd7KNoyQ==", charset);
+                        plainData = AlipayEncrypt.decryptContent(content, encryptType, "XABBSOeWDakvuG9TDez4Qg====", charset);
                     } catch (AlipayApiException e) {
                         //解密异常, 记录日志
                         e.getMessage();
@@ -442,38 +453,39 @@
                 Map<String, String> openapiResult1 = JSON.parseObject(plainData,
                         new TypeReference<Map<String, String>>() {
                         }, Feature.OrderedField);
-
-                byId.setPhone(openapiResult1.get("mobile"));
-                this.updateById(byId);
+                log.info("支付宝获取手机号返回值:{}", JSON.toJSONString(openapiResult1));
+                mobile=openapiResult1.get("mobile");
             }
         }else{
-            String responseAccessToken = null;
-            try {
-                responseAccessToken = getAccessTokenByWX();
-            } catch (Exception e) {
-                throw new RuntimeException(e);
-            }
+            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);
+                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");
             }
-            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);
         }
+        return mobile;
     }
 
     public static String getAccessTokenByWX() throws Exception {
@@ -506,11 +518,11 @@
     @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())
+                .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());
@@ -519,6 +531,7 @@
     }
 
     @Override
+    @Transactional(propagation = Propagation.REQUIRES_NEW)
     public void updMembeOne(updMembeOneDTO dMembeOneDTO) {
         Member byId = this.getById(dMembeOneDTO.getMemberId());
         if (dMembeOneDTO.getMoney()!=null){
@@ -534,39 +547,39 @@
                 Integer big=byId.getTotalPoints()+dMembeOneDTO.getTotalPoints();
                 byId.setTotalPoints(big);
             }else {
-                Integer big=byId.getTotalPoints()-dMembeOneDTO.getTotalPoints();
+                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);
-        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());
-                }
+        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;
     }
 
     /**
@@ -619,6 +632,11 @@
                 .orderByDesc(Member::getLevel)
                 .list();
     }
+
+    @Override
+    public Member getMemberByUserId(Long userId) {
+        return this.lambdaQuery().eq(Member::getUserId, userId).oneOpt().orElse(null);
+    }
 }
 
 

--
Gitblit v1.7.1