From 640ff18d2d7f4be02ddb7f8f75e899f05545eb98 Mon Sep 17 00:00:00 2001
From: puzhibing <393733352@qq.com>
Date: 星期一, 05 二月 2024 11:56:52 +0800
Subject: [PATCH] 更新bug修改

---
 cloud-server-competition/src/main/java/com/dsh/competition/service/impl/PaymentCompetitionServiceImpl.java |  328 ++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 328 insertions(+), 0 deletions(-)

diff --git a/cloud-server-competition/src/main/java/com/dsh/competition/service/impl/PaymentCompetitionServiceImpl.java b/cloud-server-competition/src/main/java/com/dsh/competition/service/impl/PaymentCompetitionServiceImpl.java
index ec3eed7..45d3a29 100644
--- a/cloud-server-competition/src/main/java/com/dsh/competition/service/impl/PaymentCompetitionServiceImpl.java
+++ b/cloud-server-competition/src/main/java/com/dsh/competition/service/impl/PaymentCompetitionServiceImpl.java
@@ -1,10 +1,39 @@
 package com.dsh.competition.service.impl;
 
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.dsh.competition.entity.Competition;
+import com.dsh.competition.entity.Participant;
 import com.dsh.competition.entity.PaymentCompetition;
+import com.dsh.competition.entity.UserCompetition;
+import com.dsh.competition.feignclient.account.AppUserClient;
+import com.dsh.competition.feignclient.account.StudentClient;
+import com.dsh.competition.feignclient.account.model.AppUser;
+import com.dsh.competition.feignclient.account.model.Student;
+import com.dsh.competition.feignclient.account.model.TStudent;
+import com.dsh.competition.feignclient.course.CoursePackagePaymentClient;
+import com.dsh.competition.feignclient.course.model.PaymentDeductionClassHour;
+import com.dsh.competition.feignclient.model.BillingRequest;
+import com.dsh.competition.feignclient.other.StoreClient;
+import com.dsh.competition.feignclient.other.model.Store;
+import com.dsh.competition.mapper.CompetitionMapper;
 import com.dsh.competition.mapper.PaymentCompetitionMapper;
+import com.dsh.competition.model.*;
+import com.dsh.competition.service.CompetitionService;
+import com.dsh.competition.service.IParticipantService;
 import com.dsh.competition.service.IPaymentCompetitionService;
+import com.dsh.competition.service.UserCompetitionService;
+import com.dsh.competition.util.*;
+import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
+import org.springframework.util.StringUtils;
+
+import javax.annotation.Resource;
+import java.math.BigDecimal;
+import java.math.RoundingMode;
+import java.text.SimpleDateFormat;
+import java.util.*;
+import java.util.stream.Collectors;
 
 /**
  * @author zhibing.pu
@@ -12,4 +41,303 @@
  */
 @Service
 public class PaymentCompetitionServiceImpl extends ServiceImpl<PaymentCompetitionMapper, PaymentCompetition> implements IPaymentCompetitionService {
+
+    @Autowired
+    private CompetitionService competitionService;
+
+    @Resource
+    private StoreClient storeClient;
+
+    @Autowired
+    private UserCompetitionService userCompetitionService;
+
+    @Autowired
+    private IParticipantService participantService;
+
+    @Autowired
+    private PayMoneyUtil payMoneyUtil;
+
+    @Resource
+    private AppUserClient appUserClient;
+
+    @Resource
+    private CoursePackagePaymentClient coursePackagePaymentClient;
+
+    @Resource
+    private StudentClient studentClient;
+    @Autowired
+    private PaymentCompetitionMapper paymentCompetitionMapper;
+
+
+    @Resource
+    private CompetitionMapper competitionMapper;
+
+    /**
+     * 获取我的报名赛事记录
+     *
+     * @param uid
+     * @param type
+     * @param pageSize
+     * @param pageNo
+     * @return
+     * @throws Exception
+     */
+    @Override
+    public List<CompetitionListVo> queryMyCompetitionList(Integer uid, Integer type, Integer pageSize, Integer pageNo) throws Exception {
+        pageNo = (pageNo - 1) * pageSize;
+        if (0 == type) {
+            type = null;
+        }
+        List<CompetitionListVo> competitionListVos = this.baseMapper.queryMyCompetitionList(uid, type, pageSize, pageNo);
+        for (CompetitionListVo competitionListVo : competitionListVos) {
+            Integer counts = competitionMapper.counts(competitionListVo.getPId());
+            competitionListVo.setHeat(competitionListVo.getHeat() + counts);
+        }
+        return competitionListVos;
+    }
+
+
+    /**
+     * 获取我报名的赛事详情
+     *
+     * @param id
+     * @return
+     * @throws Exception
+     */
+    @Override
+    public CompetitionInfo queryMyCompetitionInfo(Long id) throws Exception {
+        PaymentCompetition paymentCompetition = this.getById(id);
+        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm");
+        Competition competition = competitionService.getById(paymentCompetition.getCompetitionId());
+        CompetitionInfo competitionInfo = new CompetitionInfo();
+        competitionInfo.setId(id);
+        competitionInfo.setImgs(competition.getImgs());
+        competitionInfo.setName(competition.getName());
+        competitionInfo.setRegisterCondition(competition.getRegisterCondition());
+        Store store = storeClient.queryStoreById(Integer.valueOf(competition.getStoreId().split(",")[0]));
+        competitionInfo.setStoreName(store.getName());
+        competitionInfo.setStoreAddress(store.getAddress());
+        competitionInfo.setStoreLon(store.getLon());
+        competitionInfo.setStoreLat(store.getLat());
+        competitionInfo.setStoreCoverDrawing(store.getCoverDrawing());
+        competitionInfo.setRegisterEndTime(sdf.format(competition.getRegisterEndTime()));
+        competitionInfo.setStartTime(sdf.format(competition.getStartTime()));
+        competitionInfo.setEndTime(sdf.format(competition.getEndTime()));
+        competitionInfo.setAge(competition.getStartAge() + "-" + competition.getEndAge());
+        competitionInfo.setProvince(competition.getEntryProvince());
+        competitionInfo.setCity(competition.getEntryCity());
+
+        String str = competition.getAddress();
+        str = str.substring(str.indexOf("省") + 1);
+
+        // 去掉第一个“市”及之前的字符串
+        str = str.substring(str.indexOf("市") + 1);
+
+        // 去掉第一个“区”及之前的字符串
+        str = str.substring(str.indexOf("区") + 1);
+
+
+        competitionInfo.setAddress(str);
+        competitionInfo.setCashPrice(competition.getCashPrice());
+        competitionInfo.setPlayPaiCoin(competition.getPlayPaiCoin());
+        competitionInfo.setClassPrice(competition.getClassPrice());
+        competitionInfo.setIntroduction(competition.getIntroduction());
+        competitionInfo.setRegistrationNotes(competition.getRegistrationNotes());
+        competitionInfo.setApply(1);
+        ArrayList<Map<String, Object>> objects = new ArrayList<>();
+
+        if (null != competition.getStoreId()) {
+            String storeId = competition.getStoreId();
+            for (String s : storeId.split(",")) {
+                HashMap<String, Object> map = new HashMap<>();
+                Store store1 = storeClient.queryStoreById(Integer.valueOf(s));
+                map.put("name", store1.getName());
+
+
+                String str1 = store1.getAddress();
+                str1 = str1.substring(str1.indexOf("省") + 1);
+
+                // 去掉第一个“市”及之前的字符串
+                str1 = str1.substring(str1.indexOf("市") + 1);
+
+                // 去掉第一个“区”及之前的字符串
+                str1 = str1.substring(str1.indexOf("区") + 1);
+
+                map.put("address", str1);
+                map.put("storeLon", store.getLon());
+                map.put("storeLat", store.getLat());
+                map.put("storeCoverDrawing", store.getCoverDrawing());
+//                if(ToolUtil.isNotEmpty(lon) && ToolUtil.isNotEmpty(lat)){
+//                    Map<String, Double> distance = GeodesyUtil.getDistance(lon + "," + lat, store.getLon() + "," + store.getLat());
+//                    double wgs84 = new BigDecimal(distance.get("WGS84")).divide(new BigDecimal(1000)).setScale(2, RoundingMode.HALF_EVEN).doubleValue();
+//                    map.put("distance",wgs84);
+//                }
+                objects.add(map);
+            }
+
+        }
+        competitionInfo.setStoreInfos(objects);
+
+
+        List<ParticipantVo> participant = new ArrayList<>();
+        List<UserCompetition> list = userCompetitionService.list(new QueryWrapper<UserCompetition>().eq("paymentCompetitionId", paymentCompetition.getId()));
+        List<Integer> collect = list.stream().map(UserCompetition::getParticipantId).collect(Collectors.toList());
+        if (collect.size() == 0) {
+            collect.add(-1);
+        }
+        List<Participant> participants = participantService.listByIds(collect);
+        SimpleDateFormat sdf_year = new SimpleDateFormat("yyyy");
+        for (Participant participant1 : participants) {
+            ParticipantVo participantVo = new ParticipantVo();
+            participantVo.setId(participant1.getId());
+            participantVo.setName(participant1.getName());
+            participantVo.setIdcard(participant1.getIdcard());
+            Integer age = Integer.valueOf(sdf_year.format(new Date())) - Integer.valueOf(sdf_year.format(participant1.getBirthday()));
+            participantVo.setAge(age);
+            participantVo.setPhone(participant1.getPhone());
+            participant.add(participantVo);
+        }
+
+
+        for (Integer i : collect) {
+            TStudent tStudent = studentClient.queryById(i);
+            if (tStudent != null) {
+                ParticipantVo participantVo = new ParticipantVo();
+                participantVo.setId(tStudent.getId());
+                participantVo.setName(tStudent.getName());
+                participantVo.setIdcard(tStudent.getIdCard());
+                Integer age = Integer.valueOf(sdf_year.format(new Date())) - Integer.valueOf(sdf_year.format(tStudent.getBirthday()));
+                participantVo.setAge(age);
+                participantVo.setPhone(tStudent.getPhone());
+                participant.add(participantVo);
+            }
+
+        }
+
+        competitionInfo.setParticipant(participant);
+        competitionInfo.setStatus(competition.getStatus());
+        if (paymentCompetition.getPayStatus() == 3) {
+            competitionInfo.setStatus(4);
+        }
+        competitionInfo.setPayMoney(paymentCompetition.getAmount());
+        competitionInfo.setPayType(paymentCompetition.getPayType());
+        return competitionInfo;
+    }
+
+
+    /**
+     * 取消赛事报名
+     *
+     * @param id
+     * @return
+     * @throws Exception
+     */
+    @Override
+    public ResultUtil cancelMyCompetition(Long id) throws Exception {
+        PaymentCompetition paymentCompetition = this.getById(id);
+        if (paymentCompetition.getPayStatus() == 3) {
+            return ResultUtil.error("不能重复取消");
+        }
+        String code = paymentCompetition.getCode();
+        Double amount = paymentCompetition.getAmount();
+        Competition competition = competitionService.getById(paymentCompetition.getCompetitionId());
+        if (System.currentTimeMillis() >= competition.getRegisterEndTime().getTime()) {
+            return ResultUtil.error("赛事已结束报名,无法取消");
+        }
+
+        String payOrderNo = paymentCompetition.getPayOrderNo();
+        if (paymentCompetition.getPayType() == 1) {//微信支付
+            Map<String, String> map = payMoneyUtil.wxRefund(payOrderNo, code, amount.toString(), amount.toString(), "/base/competition/weChatCancelPaymentCompetitionCallback");
+            String return_code = map.get("return_code");
+            if (!"SUCCESS".equals(return_code)) {
+                return ResultUtil.error(map.get("return_msg"));
+            }
+            String refund_id = map.get("refund_id");
+            paymentCompetition.setRefundOrderNo(refund_id);
+            this.updateById(paymentCompetition);
+
+            storeClient.addBackRecord(paymentCompetition.getAmount() + "_" + paymentCompetition.getAppUserId());
+
+
+        }
+        if (paymentCompetition.getPayType() == 2) {//支付宝支付
+            Map<String, String> map = payMoneyUtil.aliRefund(payOrderNo, amount.toString());
+            String return_code = map.get("code");
+            if (!"10000".equals(return_code)) {
+                return ResultUtil.error(map.get("msg"));
+            }
+            String refund_id = map.get("trade_no");
+            paymentCompetition.setRefundOrderNo(refund_id);
+            paymentCompetition.setRefundTime(new Date());
+            paymentCompetition.setPayStatus(3);
+            paymentCompetition.setAppUserId(null);
+            this.updateById(paymentCompetition);
+
+//            competition.setApplicantsNumber(competition.getApplicantsNumber() - 1);
+            competitionService.updateById(competition);
+        }
+        if (paymentCompetition.getPayType() == 3) {//玩湃币支付
+            AppUser appUser = appUserClient.queryAppUser(paymentCompetition.getAppUserId());
+            appUser.setPlayPaiCoins(appUser.getPlayPaiCoins() + amount.intValue());
+            appUserClient.updateAppUser(appUser);
+
+            paymentCompetition.setRefundOrderNo("");
+            paymentCompetition.setRefundTime(new Date());
+            paymentCompetition.setPayStatus(3);
+            paymentCompetition.setAppUserId(null);
+            this.updateById(paymentCompetition);
+
+//            competition.setApplicantsNumber(competition.getApplicantsNumber() - 1);
+            competitionService.updateById(competition);
+        }
+        if (paymentCompetition.getPayType() == 4) {//课程支付
+            List<UserCompetition> list = userCompetitionService.list(new QueryWrapper<UserCompetition>().eq("paymentCompetitionId", paymentCompetition.getId()));
+            for (UserCompetition userCompetition : list) {
+//                Participant participant = participantService.getById(userCompetition.getId());
+//                Student student = studentClient.queryStudentByPhone(participant.getPhone());
+                PaymentDeductionClassHour paymentDeductionClassHour = new PaymentDeductionClassHour();
+                paymentDeductionClassHour.setId(userCompetition.getParticipantId());
+                paymentDeductionClassHour.setClassHour(competition.getClassPrice());
+                paymentDeductionClassHour.setCode(code);
+                coursePackagePaymentClient.rollbackPaymentDeductionClassHour(paymentDeductionClassHour);
+            }
+
+            paymentCompetition.setRefundOrderNo("");
+            paymentCompetition.setRefundTime(new Date());
+            paymentCompetition.setPayStatus(3);
+            paymentCompetition.setAppUserId(null);
+            this.updateById(paymentCompetition);
+
+//            competition.setApplicantsNumber(competition.getApplicantsNumber() - 1);
+            competitionService.updateById(competition);
+        }
+        return ResultUtil.success();
+    }
+
+    @Override
+    public List<BillingRequest> queryDatas(Integer appUserId, String monthStart, String monthEnd) {
+        return this.baseMapper.queryDatas(appUserId, monthStart, monthEnd);
+    }
+
+    @Override
+    public List<BillingRequest> queryCancelDatas(Integer appUserId, String monthStart, String monthEnd) {
+        return this.baseMapper.queryCancelDatas(appUserId, monthStart, monthEnd);
+    }
+
+    @Override
+    public List<PaymentCompetition> listAll(CompetitionQuery query) {
+        String STime = null;
+        String ETime = null;
+        if (StringUtils.hasLength(query.getTime())) {
+            STime = query.getTime().split(" - ")[0] + " 00:00:00";
+            ETime = query.getTime().split(" - ")[1] + " 23:59:59";
+        }
+
+        return paymentCompetitionMapper.listAll(query, STime, ETime, query.getAmount());
+    }
+
+    @Override
+    public Integer queryByCode(String code) {
+        return this.baseMapper.queryBycode(code);
+    }
 }

--
Gitblit v1.7.1