From c35f907f1ab5c2cd45a55bf757bb2fc17a5bcf1e Mon Sep 17 00:00:00 2001
From: 44323 <443237572@qq.com>
Date: 星期四, 23 十一月 2023 18:45:54 +0800
Subject: [PATCH] 后台bug修改
---
cloud-server-competition/src/main/java/com/dsh/competition/service/impl/PaymentCompetitionServiceImpl.java | 327 ++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 327 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..857eda0 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,302 @@
*/
@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