From aad87bdfab3ef685a27b3540b1114b36059c8cc7 Mon Sep 17 00:00:00 2001
From: puzhibing <393733352@qq.com>
Date: 星期四, 01 六月 2023 23:33:21 +0800
Subject: [PATCH] 提交数据库

---
 user/guns-admin/src/main/java/com/supersavedriving/user/modular/system/service/impl/AppUserServiceImpl.java |  258 ++++++++++++++++++++++++++++++++++++++++++++++++--
 1 files changed, 244 insertions(+), 14 deletions(-)

diff --git a/user/guns-admin/src/main/java/com/supersavedriving/user/modular/system/service/impl/AppUserServiceImpl.java b/user/guns-admin/src/main/java/com/supersavedriving/user/modular/system/service/impl/AppUserServiceImpl.java
index fd81855..35f1aee 100644
--- a/user/guns-admin/src/main/java/com/supersavedriving/user/modular/system/service/impl/AppUserServiceImpl.java
+++ b/user/guns-admin/src/main/java/com/supersavedriving/user/modular/system/service/impl/AppUserServiceImpl.java
@@ -2,6 +2,7 @@
 
 import com.alibaba.fastjson.JSON;
 import com.alibaba.fastjson.JSONObject;
+import com.alipay.api.domain.RechargeDetail;
 import com.baomidou.mybatisplus.mapper.EntityWrapper;
 import com.baomidou.mybatisplus.service.impl.ServiceImpl;
 import com.supersavedriving.user.core.common.constant.JwtConstants;
@@ -10,31 +11,35 @@
 import com.supersavedriving.user.core.util.JwtTokenUtil;
 import com.supersavedriving.user.core.util.ToolUtil;
 import com.supersavedriving.user.modular.system.dao.AppUserMapper;
-import com.supersavedriving.user.modular.system.model.AppUser;
-import com.supersavedriving.user.modular.system.model.Coupon;
-import com.supersavedriving.user.modular.system.model.UserToCoupon;
-import com.supersavedriving.user.modular.system.service.IAppUserService;
-import com.supersavedriving.user.modular.system.service.ICouponService;
-import com.supersavedriving.user.modular.system.service.IUserToCouponService;
+import com.supersavedriving.user.modular.system.model.*;
+import com.supersavedriving.user.modular.system.service.*;
+import com.supersavedriving.user.modular.system.util.MallBook.model.InterfaceResponse;
+import com.supersavedriving.user.modular.system.util.MallBook.model.PaymentOrder;
+import com.supersavedriving.user.modular.system.util.MallBook.model.PaymentOrderGood;
+import com.supersavedriving.user.modular.system.util.MallBook.model.QueryOrder;
+import com.supersavedriving.user.modular.system.util.MallBook.util.TrhRequest;
+import com.supersavedriving.user.modular.system.util.PayMoneyUtil;
 import com.supersavedriving.user.modular.system.util.RedisUtil;
 import com.supersavedriving.user.modular.system.util.ResultUtil;
+import com.supersavedriving.user.modular.system.util.UUIDUtil;
 import com.supersavedriving.user.modular.system.util.weChat.WXCore;
 import com.supersavedriving.user.modular.system.util.weChat.WeChatUtil;
 import com.supersavedriving.user.modular.system.util.weChat.model.Code2Session;
-import com.supersavedriving.user.modular.system.warpper.CouponWarpper;
-import com.supersavedriving.user.modular.system.warpper.SignInToRegister;
-import com.supersavedriving.user.modular.system.warpper.SignInToRegisterWarpper;
+import com.supersavedriving.user.modular.system.warpper.*;
 import org.apache.shiro.authc.SimpleAuthenticationInfo;
 import org.apache.shiro.authc.UsernamePasswordToken;
 import org.apache.shiro.authc.credential.HashedCredentialsMatcher;
 import org.apache.shiro.crypto.hash.Md5Hash;
 import org.apache.shiro.util.ByteSource;
 import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.beans.factory.annotation.Value;
 import org.springframework.stereotype.Service;
 import org.springframework.web.context.request.RequestContextHolder;
 import org.springframework.web.context.request.ServletRequestAttributes;
 
 import javax.servlet.http.HttpServletRequest;
+import java.net.InetAddress;
+import java.text.SimpleDateFormat;
 import java.util.ArrayList;
 import java.util.Date;
 import java.util.List;
@@ -60,6 +65,21 @@
     @Autowired
     private IUserToCouponService userToCouponService;
 
+    @Autowired
+    private IRechargeRecordService rechargeRecordService;
+
+    @Autowired
+    private PayMoneyUtil payMoneyUtil;
+
+    @Autowired
+    private IAccountChangeDetailService accountChangeDetailService;
+
+    @Value("${callbackPath}")
+    private String callbackPath;//支付回调网关地址
+
+    @Value("${wx.appletsAppid}")
+    private String appletsAppid;
+
 
 
     @Override
@@ -69,12 +89,9 @@
             return ResultUtil.error(code2Session.getErrmsg());
         }
         String openid = code2Session.getOpenid();
-        AppUser appUser = this.selectOne(new EntityWrapper<AppUser>().eq("openid", openid).ne("status", 3));
+        AppUser appUser = this.selectOne(new EntityWrapper<AppUser>().eq("openid", openid).eq("status", 1));
         if(null == appUser){
             return ResultUtil.error("无效的账号");
-        }
-        if(appUser.getStatus() == 2){
-            return ResultUtil.error("账号被冻结");
         }
         String token = getToken(appUser);
         if(ToolUtil.isEmpty(token)){
@@ -112,6 +129,7 @@
                 key = token.substring(token.length() - 16);
             }
             redisUtil.setStrValue(key, appUser.getId().toString(), 7 * 24 * 60 * 60);
+            redisUtil.setStrValue("USER_" + appUser.getPhone(), key, 7 * 24 * 60 * 60);
             return token;
         }
         return null;
@@ -152,6 +170,7 @@
         if(null == appUser){
             appUser = new AppUser();
             appUser.setNickname("亲爱的用户");
+            appUser.setAvatar("https://csxdj.obs.cn-south-1.myhuaweicloud.com:443/66cc269703a84e4da87fb21e2c21ab1f.png");
             appUser.setPhone(purePhoneNumber);
             appUser.setOpenid(openid);
             appUser.setUnionid(code2Session.getUnionid());
@@ -187,7 +206,8 @@
      * @param userId
      */
     public List<CouponWarpper> pushCoupon(Integer userId){
-        List<Coupon> coupons = couponService.selectList(new EntityWrapper<Coupon>().eq("coupon_type", 2).eq("coupon_state", 1).gt("remaining_quantity", 0));
+        List<Coupon> coupons = couponService.selectList(new EntityWrapper<Coupon>().eq("coupon_type", 2)
+                .eq("coupon_state", 1).eq("status", 1).gt("remaining_quantity", 0));
         List<CouponWarpper> list = new ArrayList<>();
         for (Coupon coupon : coupons) {
             UserToCoupon userToCoupon = new UserToCoupon();
@@ -237,4 +257,214 @@
             return null;
         }
     }
+
+    /**
+     * 修改个人信息
+     * @param userInfo
+     * @return
+     * @throws Exception
+     */
+    @Override
+    public ResultUtil updateUserInfo(Integer uid, UserInfo userInfo) throws Exception {
+        AppUser appUser = this.selectById(uid);
+        if(ToolUtil.isNotEmpty(userInfo.getAvatar())){
+            appUser.setAvatar(userInfo.getAvatar());
+        }
+        if(ToolUtil.isNotEmpty(userInfo.getEmergencyContact())){
+            appUser.setEmergencyContact(userInfo.getEmergencyContact());
+        }
+        if(ToolUtil.isNotEmpty(userInfo.getEmergencyPhone())){
+            appUser.setEmergencyPhone(userInfo.getEmergencyPhone());
+        }
+        if(ToolUtil.isNotEmpty(userInfo.getNickname())){
+            appUser.setNickname(userInfo.getNickname());
+        }
+        if(ToolUtil.isNotEmpty(userInfo.getPhone())){
+            if(userInfo.getPhone().equals(appUser.getPhone())){
+                return ResultUtil.error("新手机不能和原手机号相同");
+            }
+            String value = redisUtil.getValue("+86" + userInfo.getPhone());
+            if(ToolUtil.isEmpty(value) || !value.equals(userInfo.getCode())){
+                return ResultUtil.error("验证码无效");
+            }
+            appUser.setPhone(userInfo.getPhone());
+        }
+        this.updateById(appUser);
+        return ResultUtil.success();
+    }
+
+    /**
+     * 余额充值
+     * @param uid
+     * @param amount
+     * @return
+     * @throws Exception
+     */
+    @Override
+    public ResultUtil rechargeBalance(Integer uid, Double amount) throws Exception {
+        if(0 >= amount){
+            return ResultUtil.error("充值金额必须大于0");
+        }
+        SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHmmssSSS");
+        String out_trade_no = sdf.format(new Date()) + UUIDUtil.getNumberRandom(3);
+        AppUser appUser = this.selectById(uid);
+        RechargeRecord rechargeRecord = new RechargeRecord();
+        rechargeRecord.setType(1);
+        rechargeRecord.setUserId(uid);
+        rechargeRecord.setCode(out_trade_no);
+        rechargeRecord.setAmount(amount);
+        rechargeRecord.setCreateTime(new Date());
+        rechargeRecord.setPayStatus(1);
+        rechargeRecord.setPayType(1);
+        rechargeRecordService.insert(rechargeRecord);
+//        ResultUtil weixinpay = payMoneyUtil.weixinpay("余额充值", "", out_trade_no, amount.toString(), "/base/appUser/rechargeBalanceCallback", "JSAPI", appUser.getOpenid());
+//        return weixinpay;
+
+        PaymentOrder paymentOrder = new PaymentOrder();
+        paymentOrder.setBizOrderId(out_trade_no);
+        paymentOrder.setAmount(String.valueOf(amount * 100));
+        paymentOrder.setOrderName("账户充值");
+        paymentOrder.setPayType("WX_MINI");
+        paymentOrder.setTransferType("0");
+        paymentOrder.setAsynSplitFlag("1");
+        paymentOrder.setAppid(appletsAppid);
+        paymentOrder.setOpenid(appUser.getOpenid());
+        paymentOrder.setTerminalIp(InetAddress.getLocalHost().getHostAddress());
+        List<PaymentOrderGood> goodsDetail = new ArrayList<>();
+        PaymentOrderGood paymentOrderGood = new PaymentOrderGood();
+        paymentOrderGood.setGoodsName("账户充值");
+        goodsDetail.add(paymentOrderGood);
+        paymentOrder.setGoodsDetail(goodsDetail);
+        paymentOrder.setFrontUrl("");
+        paymentOrder.setNotifyUrl(callbackPath + "/base/appUser/rechargeBalanceCallback");
+        paymentOrder.setParameter1(out_trade_no);
+
+        TrhRequest<PaymentOrder> request = new TrhRequest();
+        InterfaceResponse execute = request.execute(paymentOrder, PaymentOrder.SERVICE_CODE);
+        if(!"0000".equals(execute.getCode())){
+            return ResultUtil.error(execute.getMsg());
+        }
+        JSONObject jsonObject = JSON.parseObject(execute.getResult());
+        String status = jsonObject.getString("status");
+        if("2".equals(status)){
+            return ResultUtil.error("失败");
+        }
+        String payCode = jsonObject.getString("payCode");
+        if(ToolUtil.isNotEmpty(payCode)){
+            new Thread(new Runnable() {
+                @Override
+                public void run() {
+                    try {
+                        int num = 1;
+                        int wait = 0;
+                        while (num <= 10){
+                            int min = 5000;
+                            wait += (min * num);
+                            RechargeRecord rechargeRecord1 = rechargeRecordService.selectOne(new EntityWrapper<RechargeRecord>().eq("code", out_trade_no));
+                            if(rechargeRecord1.getPayStatus() != 1){
+                                return;
+                            }
+                            QueryOrder queryOrder = new QueryOrder();
+                            queryOrder.setOriginalMerOrderId(out_trade_no);
+                            queryOrder.setQueryType("1");
+                            TrhRequest<QueryOrder> request = new TrhRequest();
+                            InterfaceResponse execute1 = request.execute(queryOrder, QueryOrder.SERVICE_CODE);
+                            if("0000".equals(execute1.getCode())){
+                                JSONObject jsonObject1 = JSON.parseObject(execute1.getResult());
+                                String status1 = jsonObject1.getString("status");
+                                if("0".equals(status1)){//待处理
+                                    Thread.sleep(wait);
+                                    num++;
+                                }
+                                if("1".equals(status1)){//成功
+                                    String merOrderId = jsonObject1.getString("merOrderId");
+                                    AppUser appUser1 = AppUserServiceImpl.this.selectById(rechargeRecord1.getUserId());
+                                    AccountChangeDetail accountChangeDetail = new AccountChangeDetail();
+                                    accountChangeDetail.setUserType(1);
+                                    accountChangeDetail.setUserId(appUser1.getId());
+                                    accountChangeDetail.setCode(System.currentTimeMillis() + UUIDUtil.getNumberRandom(3));
+                                    accountChangeDetail.setChangeType(3);
+                                    accountChangeDetail.setType(1);
+                                    accountChangeDetail.setCreateTime(new Date());
+                                    accountChangeDetail.setExplain("账户充值");
+                                    accountChangeDetail.setOldData(appUser1.getAccountBalance());
+                                    appUser1.setAccountBalance(appUser1.getAccountBalance() + rechargeRecord1.getAmount());
+                                    accountChangeDetail.setNewData(appUser1.getAccountBalance());
+                                    AppUserServiceImpl.this.updateById(appUser1);
+                                    accountChangeDetailService.saveData(accountChangeDetail);
+
+                                    rechargeRecord1.setPayTime(new Date());
+                                    rechargeRecord1.setPayStatus(2);
+                                    rechargeRecord1.setOrderNumber(merOrderId);
+                                    rechargeRecord1.setSurplusDividedAmount(rechargeRecord1.getAmount());
+                                    rechargeRecordService.updateById(rechargeRecord1);
+                                    break;
+                                }
+                                if("2".equals(status1) || 10 == num){//失败
+                                    rechargeRecordService.deleteById(rechargeRecord1.getId());
+                                    break;
+                                }
+                            }else{
+                                Thread.sleep(wait);
+                                num++;
+                            }
+                        }
+                    }catch (Exception e){
+                        e.printStackTrace();
+                    }
+                }
+            }).start();
+        }
+        return ResultUtil.success(payCode);
+    }
+
+
+    /**
+     * 余额充值回调
+     * @param out_trade_no
+     * @param transaction_id
+     * @return
+     * @throws Exception
+     */
+    @Override
+    public void rechargeBalanceCallback(String out_trade_no, String transaction_id) throws Exception {
+        RechargeRecord rechargeRecord1 = rechargeRecordService.selectOne(new EntityWrapper<RechargeRecord>().eq("code", out_trade_no));
+        if(rechargeRecord1.getPayStatus() != 1){
+            return;
+        }
+        AppUser appUser = this.selectById(rechargeRecord1.getUserId());
+        AccountChangeDetail accountChangeDetail = new AccountChangeDetail();
+        accountChangeDetail.setUserType(1);
+        accountChangeDetail.setUserId(rechargeRecord1.getUserId());
+        accountChangeDetail.setCode(System.currentTimeMillis() + UUIDUtil.getNumberRandom(3));
+        accountChangeDetail.setChangeType(3);
+        accountChangeDetail.setType(1);
+        accountChangeDetail.setCreateTime(new Date());
+        accountChangeDetail.setExplain("余额充值");
+        accountChangeDetail.setOldData(appUser.getAccountBalance());
+        appUser.setAccountBalance(appUser.getAccountBalance() + rechargeRecord1.getAmount());
+        accountChangeDetail.setNewData(appUser.getAccountBalance());
+        this.updateById(appUser);
+        accountChangeDetailService.saveData(accountChangeDetail);
+
+        rechargeRecord1.setPayTime(new Date());
+        rechargeRecord1.setPayStatus(2);
+        rechargeRecord1.setOrderNumber(transaction_id);
+        rechargeRecord1.setSurplusDividedAmount(rechargeRecord1.getAmount());
+        rechargeRecordService.updateById(rechargeRecord1);
+    }
+
+    /**
+     * 获取用户优惠券列表
+     * @param uid
+     * @param state
+     * @param pageNum
+     * @param pageSize
+     * @return
+     * @throws Exception
+     */
+    @Override
+    public List<CouponsWarpper> queryMyCoupons(Integer uid, Integer state, Integer pageNum, Integer pageSize) throws Exception {
+        return null;
+    }
 }

--
Gitblit v1.7.1