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