package com.dsh.competition.service.impl;
|
|
import com.alibaba.fastjson.JSON;
|
import com.alibaba.fastjson.JSONArray;
|
import com.alibaba.fastjson.JSONObject;
|
import com.alibaba.nacos.common.utils.UuidUtils;
|
import com.alipay.api.AlipayApiException;
|
import com.alipay.api.AlipayClient;
|
import com.alipay.api.DefaultAlipayClient;
|
import com.alipay.api.domain.AlipayTradeOrderSettleModel;
|
import com.alipay.api.domain.OpenApiRoyaltyDetailInfoPojo;
|
import com.alipay.api.domain.RoyaltyDetailInfos;
|
import com.alipay.api.request.AlipayTradeOrderSettleRequest;
|
import com.alipay.api.request.AlipayTradeRoyaltyRelationBindRequest;
|
import com.alipay.api.response.AlipayTradeOrderSettleResponse;
|
import com.alipay.api.response.AlipayTradeQueryResponse;
|
import com.alipay.api.response.AlipayTradeRoyaltyRelationBindResponse;
|
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import com.dsh.competition.entity.*;
|
import com.dsh.competition.enums.CompetitionStatusEnum;
|
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.CompetitionUser;
|
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.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 com.dsh.competition.util.wx.WxV3PayConfig;
|
import cn.mb.cloud.common.core.exception.BusinessException;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
import org.springframework.util.StringUtils;
|
import org.springframework.transaction.annotation.Transactional;
|
|
import javax.annotation.Resource;
|
import java.math.BigDecimal;
|
import java.math.RoundingMode;
|
import java.text.SimpleDateFormat;
|
import java.util.*;
|
import java.util.stream.Collectors;
|
|
/**
|
* <p>
|
* 服务实现类
|
* </p>
|
*
|
* @author jqs
|
* @since 2023-06-26
|
*/
|
@Service
|
public class CompetitionServiceImpl extends ServiceImpl<CompetitionMapper, Competition> implements CompetitionService {
|
|
@Resource
|
private StoreClient storeClient;
|
|
@Autowired
|
private IPaymentCompetitionService paymentCompetitionService;
|
|
@Autowired
|
private UserCompetitionService userCompetitionService;
|
|
@Autowired
|
private IParticipantService participantService;
|
|
@Resource
|
private AppUserClient appUserClient;
|
|
@Resource
|
private StudentClient studentClient;
|
|
@Resource
|
private CoursePackagePaymentClient coursePackagePaymentClient;
|
|
@Autowired
|
private PayMoneyUtil payMoneyUtil;
|
|
|
@Autowired
|
private CompetitionService cttService;
|
|
/**
|
* 修改活动，并确保修改不会破坏既有报名记录。
|
*
|
* @param competition 管理端提交的活动信息
|
* @throws BusinessException 活动不存在、时间范围非法或人数容量不足时抛出
|
*/
|
@Override
|
@Transactional(rollbackFor = Exception.class)
|
public void updateCompetition(Competition competition) throws BusinessException {
|
validateUpdateRequest(competition);
|
|
// STEP 1: 读取原活动，避免前端传入部分字段时覆盖既有数据。
|
Competition originalCompetition = getById(competition.getId());
|
if (originalCompetition == null) {
|
throw new BusinessException("活动不存在或已删除");
|
}
|
|
// STEP 2: 校验人数容量，保证已报名记录始终处于有效的活动容量内。
|
validateApplicantsNumber(competition);
|
|
// STEP 3: 仅更新活动配置；支付订单金额为快照，价格调整不会修改既有订单。
|
competition.setStatus(resolveCompetitionStatus(originalCompetition, competition));
|
updateById(competition);
|
}
|
|
/**
|
* 校验编辑请求中必填字段和基础数值范围。
|
*
|
* @param competition 待校验的活动信息
|
*/
|
private void validateUpdateRequest(Competition competition) throws BusinessException {
|
if (competition == null || competition.getId() == null) {
|
throw new BusinessException("活动编号不能为空");
|
}
|
if (competition.getStartTime() == null || competition.getEndTime() == null
|
|| competition.getRegisterEndTime() == null) {
|
throw new BusinessException("活动时间和截止报名时间不能为空");
|
}
|
if (competition.getApplicantsNumber() == null || competition.getApplicantsNumber() < 0) {
|
throw new BusinessException("报名人数必须为非负整数");
|
}
|
if (competition.getBaseNumber() != null && competition.getBaseNumber() < 0) {
|
throw new BusinessException("基础报名人数必须为非负整数");
|
}
|
if (competition.getStartAge() != null && competition.getEndAge() != null
|
&& competition.getStartAge() > competition.getEndAge()) {
|
throw new BusinessException("报名最小年龄不能大于最大年龄");
|
}
|
validatePrices(competition);
|
}
|
|
/**
|
* 校验各支付价格不可为负数。
|
*
|
* @param competition 待校验的活动信息
|
*/
|
private void validatePrices(Competition competition) throws BusinessException {
|
if ((competition.getCashPrice() != null && competition.getCashPrice() < 0)
|
|| (competition.getPlayPaiCoin() != null && competition.getPlayPaiCoin() < 0)
|
|| (competition.getClassPrice() != null && competition.getClassPrice() < 0)) {
|
throw new BusinessException("支付价格不能小于零");
|
}
|
}
|
|
/**
|
* 校验调整后的容量不会小于当前已报名人数。
|
*
|
* @param competition 待校验的活动信息
|
*/
|
private void validateApplicantsNumber(Competition competition) throws BusinessException {
|
int registeredCount = userCompetitionService.count(new LambdaQueryWrapper<UserCompetition>()
|
.eq(UserCompetition::getCompetitionId, competition.getId()));
|
if (competition.getApplicantsNumber() < registeredCount) {
|
throw new BusinessException("报名人数不能小于已报名人数" + registeredCount);
|
}
|
}
|
|
/**
|
* 根据当前时间刷新活动状态，并保持已取消活动的取消状态。
|
*
|
* @param originalCompetition 数据库中的原活动
|
* @param competition 待保存的活动信息
|
* @return 计算后的活动状态编码
|
*/
|
private Integer resolveCompetitionStatus(Competition originalCompetition, Competition competition) {
|
if (CompetitionStatusEnum.CANCELED.getCode().equals(originalCompetition.getStatus())) {
|
return CompetitionStatusEnum.CANCELED.getCode();
|
}
|
Date currentTime = new Date();
|
if (currentTime.before(competition.getStartTime())) {
|
return CompetitionStatusEnum.NOT_STARTED.getCode();
|
}
|
if (currentTime.before(competition.getEndTime())) {
|
return CompetitionStatusEnum.IN_PROGRESS.getCode();
|
}
|
return CompetitionStatusEnum.ENDED.getCode();
|
}
|
|
|
private String aliAppid = "2021004105665036";//支付宝appid
|
|
private String appPrivateKey = "MIIEvwIBADANBgkqhkiG9w0BAQEFAASCBKkwggSlAgEAAoIBAQCi5i9nW/hGLJ3A06cZxTQdviFC7THpdSihoTYGLr9q006hu0V26ecBMY/o4w5bvIX0Ok/yofmZsVcCJpAPvbXL/uqVrIjnRRxXiaeBFThlxoBUTdunvbUSDYfzlEhJr5NvUKI6H6lz2niXlQGx4qy8Hau4ccWit9kM8jwUvsBVQoFgJA+xrjMvooA7YLopQtpOD+UJr5thApTSf1xrnr1W12yolTLEH15JmNV372cqXrYUuqnY0QsaPtxeqJUGAOcGdVLllQ7easEznP8DFBvDdHATcmp2SHNQDUEWN6MCVPbMgY06NQVqAXxqjTAYSVh+6TRu6bofPmpYC3TZB003AgMBAAECggEBAJAcR2+PA3NBYUYHeFrqBRMS8uX8ZR19kjZ7IgoSLTFaQsP9opRylPSPXhrPVBKAE5leRQAHn4MCSlESwHvMfxo7KFjFTFAc6dffZZpipYQUOc9bGampwJh58/3e/pyBgVMG6J23CPf/HJQtNFSkjd/V9+ayb/9l2dUEL3bC0fAZ/dbx8HsxdLw8wn3fLlWLj68hOMqa2deCZe3JdSVsPbeWqkh56FFsMLug0Nd+Ar4TgRl9/jnhXF0JWiD0LmPUYLhboY7EfUBzN4w1iYbDi1P+3zvoOYsiVKAXox9GMhQ2VzOO2UcSTuizSza2e98mGpabl/GpKmCz+RDFjtkX6eECgYEA2MyCij65eO3aGIm3FUe93DULRBYTfX8qJQSJq2WOWA3mmQlEW6L3O2B5/lG2h+8WmN6iLEs9eHpgycGYp7vAqgrANEn16ACVcuyx0scFtrZfZ+kmHMzFfiUWxJjVYk/6YngsGVBLdw6ueM42C8TTP67X9tU5TdVGoGWuqEj4W98CgYEAwFqwprXOch5Pqk/RPbb49r0Ou03K/UbciWnWWKzUhFFNS8MdlQPoDvQZbMwHLeWsa2VhaKITK3x5biLQb3U+0GLOn6lTvEyrEUH+ucREyLgVYTRAvwBPtnvlrzpyxPk2HnslQjju8WrvvLLBMKWUjlTrTOzhaHT21gz3pHMiOakCgYEAhLmfaXdBITGshb054sNLDtdCkGpbgEcrzAHdLps769iGxkYQHXHFngpQZUwtTUcoNGqIKknd1jZFrv7gsD+XkgKG7PwimehRlkwmCX5ilxtLiVgJRzRt6+5U5AMVD90a0tHzXYP0z2yjj73fBJF5KtGl0a10KZxaYrQdm1UhB00CgYBZZgzx/k9rtHC8LAqIj1CYhHejT92G53c6Gkl3vyOqN4sgKhfGmSEySfrDGPRBPZxr8ZtbIPCd5mUdberH0osWGMYFaJI1UsCy7aQwvGpniz7MhZeN7dweaOjwDs8mgtjHQ96mL4XGCDhR0BZ/wIURvZ/6iaGdhbbu9unlsWj3uQKBgQCmZYdsbbZkd3ev6f8rwyvMz+DrCQyYpY44cegBYuJgrZiQnL2fJioeN7ixX0UM48SfwsZEIrzshP/LGAwnc2MdjxKUl4jLN8SEe0NAjXOnz9Zaw740+aOmLpXcLWdP4uM2gIhWsvW1tEkQZCXmm7c9s/RsU8Pmzv+YL3+fSijOzA==";//支付宝开发者应用私钥
|
|
private String alipayPublicKey = "MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAouYvZ1v4RiydwNOnGcU0Hb4hQu0x6XUooaE2Bi6/atNOobtFdunnATGP6OMOW7yF9DpP8qH5mbFXAiaQD721y/7qlayI50UcV4mngRU4ZcaAVE3bp721Eg2H85RISa+Tb1CiOh+pc9p4l5UBseKsvB2ruHHForfZDPI8FL7AVUKBYCQPsa4zL6KAO2C6KULaTg/lCa+bYQKU0n9ca569VtdsqJUyxB9eSZjVd+9nKl62FLqp2NELGj7cXqiVBgDnBnVS5ZUO3mrBM5z/AxQbw3RwE3JqdkhzUA1BFjejAlT2zIGNOjUFagF8ao0wGElYfuk0bum6Hz5qWAt02QdNNwIDAQAB";//支付宝应用公钥
|
|
private String alipay_public_key = "MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAmu8n/4yTHWbn7VOrNc9OsLtDL1bEQ8gC1dHkj8Wy5z0mkaOsjJRIG/28ze12M0V8jdCKuuDr5Z1OPKiqf+XO3ypguEh+mYUVMBM/cZodDFQfTY1TKLWjvQCuaqlA+QUTCK6f7T7stsgyQ1o9Jj0rXZDz6PM4QHSTzjrLIBaeqM5WIBvH+fy/X+QG5Utd+/UT0kc0JyvuKhZ65yVUd/C9VcwJJAPliRsAQNrqYterwAJ9zvw9tF11wj9W0XgJ8Ccu4x3gR1vrlLRJJo/OA97RmxPQ+5hSacWQZCUd1dwiBq+YCrKVHGTj14izRHXrLc0yBlRXo7tBOIqcy3IsvKVthQIDAQAB";//支付宝支付公钥
|
private String smid = "2088330203191220";//平台支付宝商户号
|
|
/**
|
* 获取赛事列表
|
*
|
* @param content
|
* @param registerCondition
|
* @param heat
|
* @return
|
*/
|
@Override
|
public List<CompetitionListVo> queryCompetitionList(String cityCode, String content, Integer registerCondition, String heat) throws Exception {
|
List<CompetitionListVo> competitionListVos = this.baseMapper.queryCompetitionList(cityCode, content, registerCondition, heat);
|
|
for (CompetitionListVo competitionListVo : competitionListVos) {
|
Integer counts = this.baseMapper.counts(competitionListVo.getId());
|
competitionListVo.setHeat(competitionListVo.getHeat() + counts);
|
}
|
|
|
return competitionListVos;
|
}
|
|
|
/**
|
* 获取赛事详情
|
*
|
* @param uid
|
* @param id
|
* @return
|
* @throws Exception
|
*/
|
@Override
|
public CompetitionInfo queryCompetitionInfo(Integer uid, Integer id, String lon, String lat) throws Exception {
|
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm");
|
Competition competition = this.getById(id);
|
CompetitionInfo competitionInfo = new CompetitionInfo();
|
competitionInfo.setId(competition.getId().longValue());
|
competitionInfo.setImgs(competition.getImgs());
|
competitionInfo.setName(competition.getName());
|
competitionInfo.setRegisterCondition(competition.getRegisterCondition());
|
|
// 2.0
|
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 store = storeClient.queryStoreById(Integer.valueOf(s));
|
map.put("name", store.getName());
|
|
|
String str = store.getAddress();
|
str = str.substring(str.indexOf("省") + 1);
|
|
// 去掉第一个“市”及之前的字符串
|
str = str.substring(str.indexOf("市") + 1);
|
|
// 去掉第一个“区”及之前的字符串
|
str = str.substring(str.indexOf("区") + 1);
|
|
map.put("address", str);
|
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);
|
|
|
competitionInfo.setRegisterEndTime(sdf.format(competition.getRegisterEndTime()));
|
competitionInfo.setStartTime(sdf.format(competition.getStartTime()));
|
competitionInfo.setIsReal(competition.getRealName());
|
competitionInfo.setEndTime(sdf.format(competition.getEndTime()));
|
competitionInfo.setAge(competition.getStartAge() + "-" + competition.getEndAge());
|
competitionInfo.setProvince(competition.getProvince());
|
competitionInfo.setCity(competition.getCity());
|
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(0);
|
competitionInfo.setStatus(competition.getStatus());
|
PaymentCompetition one = paymentCompetitionService.getOne(new QueryWrapper<PaymentCompetition>().eq("competitionId", id).eq("appUserId", uid).ne("payStatus", 1).orderByDesc("insertTime").last(" limit 1"));
|
if (null != one) {
|
competitionInfo.setApply(1);
|
List<ParticipantVo> participant = new ArrayList<>();
|
List<UserCompetition> list = userCompetitionService.list(new QueryWrapper<UserCompetition>().eq("paymentCompetitionId", one.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);
|
participant.add(participantVo);
|
}
|
competitionInfo.setParticipant(participant);
|
if (one.getPayStatus() == 3) {
|
competitionInfo.setStatus(4);
|
}
|
}
|
return competitionInfo;
|
}
|
|
|
/**
|
* 赛事报名
|
*
|
* @param uid
|
* @param paymentCompetitionVo
|
* @return
|
* @throws Exception
|
*/
|
@Override
|
public ResultUtil paymentCompetition(Integer uid, PaymentCompetitionVo paymentCompetitionVo) throws Exception {
|
AppUser appUser = appUserClient.queryAppUser(uid);
|
JSONArray jsonArray = JSON.parseArray(paymentCompetitionVo.getIds());
|
Competition competition = this.getById(paymentCompetitionVo.getId());
|
|
List<PaymentCompetition> list = paymentCompetitionService.list(new QueryWrapper<PaymentCompetition>()
|
.eq("competitionId", paymentCompetitionVo.getId()).ne("payStatus", 3));
|
List<Long> pays = new ArrayList<>();
|
for (PaymentCompetition paymentCompetition : list) {
|
pays.add(paymentCompetition.getId());
|
}
|
|
int competitionId = 0;
|
if (!pays.isEmpty()) {
|
competitionId = userCompetitionService.count(new QueryWrapper<UserCompetition>().in("paymentCompetitionId", pays));
|
}
|
|
|
if ((competitionId + jsonArray.size()) > competition.getApplicantsNumber()) {
|
return ResultUtil.error("报名人数超过最大限制");
|
}
|
BigDecimal money = null;
|
if (paymentCompetitionVo.getPayType() == 1 || paymentCompetitionVo.getPayType() == 2) {
|
money = new BigDecimal(competition.getCashPrice()).multiply(new BigDecimal(jsonArray.size())).setScale(2, RoundingMode.HALF_EVEN);
|
}
|
if (paymentCompetitionVo.getPayType() == 3) {//玩湃币
|
money = new BigDecimal(competition.getPlayPaiCoin()).multiply(new BigDecimal(jsonArray.size())).setScale(2, RoundingMode.HALF_EVEN);
|
if (money.compareTo(new BigDecimal(appUser.getPlayPaiCoins())) > 0) {
|
return new ResultUtil(2, "报名失败，玩湃币不足，请充值");
|
}
|
}
|
if (paymentCompetitionVo.getPayType() == 4) {//课程
|
money = new BigDecimal(competition.getClassPrice()).multiply(new BigDecimal(jsonArray.size())).setScale(2, RoundingMode.HALF_EVEN);
|
Integer integer = coursePackagePaymentClient.queryResidueClassHourById(paymentCompetitionVo.getCoursePaymentId());
|
if (new BigDecimal(integer).compareTo(money) < 0) {
|
return new ResultUtil(3, "剩余课时不足，无法完成支付。");
|
}
|
}
|
|
SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHmmssSSS");
|
PaymentCompetition paymentCompetition = new PaymentCompetition();
|
String code = sdf.format(new Date()) + UUIDUtil.getNumberRandom(5);
|
paymentCompetition.setCode(code);
|
paymentCompetition.setCompetitionId(paymentCompetitionVo.getId());
|
paymentCompetition.setCompetitionStoreIds(competition.getStoreId());
|
paymentCompetition.setAppUserId(uid);
|
paymentCompetition.setPayType(paymentCompetitionVo.getPayType());
|
paymentCompetition.setAmount(money.doubleValue());
|
paymentCompetition.setPayStatus(1);
|
paymentCompetition.setState(1);
|
paymentCompetition.setInsertTime(new Date());
|
paymentCompetitionService.save(paymentCompetition);
|
|
SimpleDateFormat sdf1 = new SimpleDateFormat("yyyy");
|
for (int i = 0; i < jsonArray.size(); i++) {
|
JSONObject jsonObject = jsonArray.getJSONObject(i);
|
Integer id = jsonObject.getInteger("id");
|
|
TStudent tStudent = studentClient.queryById(id);
|
if( competition.getRealName()==1){
|
if(tStudent==null || tStudent.getIdCard()==null || "".equals(tStudent.getIdCard()) ){
|
return ResultUtil.error("选择人员未进行实名认证!");
|
}
|
}
|
|
|
|
if (competition.getStartAge() > (Integer.valueOf(sdf1.format(new Date())) - Integer.valueOf(sdf1.format(tStudent.getBirthday())))) {
|
return ResultUtil.error("【" + tStudent.getName() + "】年龄不符合要求");
|
}
|
if (competition.getEndAge() < (Integer.valueOf(sdf1.format(new Date())) - Integer.valueOf(sdf1.format(tStudent.getBirthday())))) {
|
return ResultUtil.error("【" + tStudent.getName() + "】年龄不符合要求");
|
}
|
Integer isStudent = jsonObject.getInteger("isStudent");
|
UserCompetition userCompetition = new UserCompetition();
|
userCompetition.setAppUserId(uid);
|
userCompetition.setCompetitionId(paymentCompetitionVo.getId());
|
userCompetition.setParticipantId(id);
|
userCompetition.setParticipantType(isStudent == 0 ? 2 : 1);
|
userCompetition.setPaymentCompetitionId(paymentCompetition.getId());
|
userCompetition.setInsertTime(new Date());
|
userCompetitionService.save(userCompetition);
|
}
|
if (paymentCompetitionVo.getPayType() == 1) {//微信
|
Competition byId = competitionService.getById(paymentCompetitionVo.getId());
|
String[] split = byId.getStoreId().split(",");
|
|
Store store = storeClient.queryStoreById(Integer.valueOf(split[0]));
|
Integer operatorId = store.getOperatorId();
|
if (operatorId!=null && operatorId != 0){
|
// 运营商
|
String s = storeClient.getmerchantNumberByOperatorId(operatorId);
|
if(!StringUtils.hasLength(s)){
|
return ResultUtil.error("运营商未配置微信商户号，获取支付失败!");
|
}
|
return payMoneyUtil.weixinpayV3(s,"报名赛事",code,
|
"/base/competition/weChatPaymentCompetitionCallback1",
|
money.toString());
|
}else{
|
return payMoneyUtil.weixinpay("报名赛事", "", code, money.toString(),
|
"/base/competition/weChatPaymentCompetitionCallback", "APP", "");
|
}
|
|
}
|
|
if (paymentCompetitionVo.getPayType() == 2) {//支付宝
|
String resSmid=smid;
|
// 判断当前赛事属于哪个运营商
|
Competition byId = competitionService.getById(paymentCompetitionVo.getId());
|
String[] split = byId.getStoreId().split(",");
|
|
Store store = storeClient.queryStoreById(Integer.valueOf(split[0]));
|
Integer operatorId = store.getOperatorId();
|
if (operatorId == null || operatorId == 0 ){
|
// 说明是平台
|
return aliPaymentCompetition(operatorId,smid,code, money);
|
}
|
// 获取该运营商的商户号
|
String smid = storeClient.getmerchantNumberAliByOperatorId(operatorId);
|
if (!StringUtils.hasLength(smid)){
|
return ResultUtil.error("运营商未配置支付宝商户号，获取支付失败!");
|
}
|
return aliPaymentCompetition(operatorId,smid,code, money);
|
}
|
if (paymentCompetitionVo.getPayType() == 3) {//玩湃币
|
appUser.setPlayPaiCoins(appUser.getPlayPaiCoins() - money.intValue());
|
appUserClient.updateAppUser(appUser);
|
|
paymentCompetition = paymentCompetitionService.getById(paymentCompetition.getId());
|
paymentCompetition.setAppUserId(null);
|
paymentCompetition.setPayStatus(2);
|
paymentCompetition.setPayTime(new Date());
|
paymentCompetition.setPayOrderNo("");
|
paymentCompetitionService.updateById(paymentCompetition);
|
|
this.updateById(competition);
|
}
|
if (paymentCompetitionVo.getPayType() == 4) {//课程
|
for (int i = 0; i < jsonArray.size(); i++) {
|
JSONObject jsonObject = jsonArray.getJSONObject(i);
|
Integer id = jsonObject.getInteger("id");
|
Integer isStudent = jsonObject.getInteger("isStudent");
|
if(isStudent == 0){
|
continue;
|
}
|
//扣减课时
|
PaymentDeductionClassHour paymentDeductionClassHour = new PaymentDeductionClassHour();
|
paymentDeductionClassHour.setId(id);
|
paymentDeductionClassHour.setClassHour(competition.getClassPrice());
|
paymentDeductionClassHour.setCode(code);
|
paymentDeductionClassHour.setCourseId(paymentCompetitionVo.getCoursePaymentId());
|
paymentDeductionClassHour.setUid(uid);
|
coursePackagePaymentClient.paymentDeductionClassHour(paymentDeductionClassHour);
|
}
|
|
paymentCompetition = paymentCompetitionService.getById(paymentCompetition.getId());
|
paymentCompetition.setAppUserId(null);
|
paymentCompetition.setPayStatus(2);
|
paymentCompetition.setPayTime(new Date());
|
paymentCompetition.setPayOrderNo("");
|
paymentCompetitionService.updateById(paymentCompetition);
|
|
competition.setBaseNumber(competition.getBaseNumber() + 1);
|
this.updateById(competition);
|
}
|
return ResultUtil.success();
|
}
|
|
/**
|
* 赛事微信支付
|
*
|
* @param code
|
* @param money
|
* @return
|
* @throws Exception
|
*/
|
public ResultUtil weChatPaymentCompetition(String code, BigDecimal money,Integer isFenZhang,Integer operatorId) throws Exception {
|
//
|
// payMoneyUtil.weixinpayV3(WxV3PayConfig.smidVx,"报名赛事",code,
|
// "/base/competition/weChatPaymentCompetitionCallback1",
|
// Long.valueOf(money.toString()));
|
ResultUtil weixinpay = payMoneyUtil.weixinpay("报名赛事"+"-"+isFenZhang, "", code, money.toString(),
|
"/base/competition/weChatPaymentCompetitionCallback", "APP", "");
|
return weixinpay;
|
|
|
}
|
|
|
/**
|
* 赛事支付宝支付
|
*
|
* @param code
|
* @param money
|
* @return
|
* @throws Exception
|
*/
|
public ResultUtil aliPaymentCompetition(Integer operatorId,String smid,String code, BigDecimal money) throws Exception {
|
String resSmid=smid;
|
ResultUtil alipay = payMoneyUtil.alipay
|
(smid,"报名赛事", "", "", code, money.toString(), "/base/competition/aliPaymentCompetitionCallback");
|
if (alipay.getCode() == 200) {
|
new Thread(new Runnable() {
|
@Override
|
public void run() {
|
try {
|
int num = 1;
|
int wait = 0;
|
while (num <= 10) {
|
int min = 5000;
|
wait += (min * num);
|
Thread.sleep(wait);
|
PaymentCompetition paymentCompetition = paymentCompetitionService.getOne(new QueryWrapper<PaymentCompetition>().eq("code", code).eq("payType", 2));
|
if (paymentCompetition.getPayStatus() == 2) {
|
break;
|
}
|
AlipayTradeQueryResponse resultUtil = payMoneyUtil.queryALIOrder(code);
|
if (resultUtil.getCode().equals("10000") && paymentCompetition.getPayStatus() == 1) {
|
/**
|
* WAIT_BUYER_PAY（交易创建，等待买家付款）、
|
* TRADE_CLOSED（未付款交易超时关闭，或支付完成后全额退款）、
|
* TRADE_SUCCESS（交易支付成功）、
|
* TRADE_FINISHED（交易结束，不可退款）
|
*/
|
// Map<String, String> data1 = resultUtil.getData();
|
// String s = data1.get("tradeStatus");
|
// String tradeNo = data1.get("tradeNo");
|
String tradeNo = resultUtil.getTradeNo();
|
String s = resultUtil.getTradeStatus();
|
|
if ("TRADE_CLOSED".equals(s) || "TRADE_FINISHED".equals(s) || num == 10) {
|
paymentCompetition.setAppUserId(null);
|
paymentCompetition.setState(3);
|
userCompetitionService.remove(new QueryWrapper<UserCompetition>().eq("paymentCompetitionId", paymentCompetition.getId()));
|
|
break;
|
}
|
if ("TRADE_SUCCESS".equals(s)) {
|
paymentCompetition.setAppUserId(null);
|
paymentCompetition.setPayStatus(2);
|
paymentCompetition.setPayTime(new Date());
|
paymentCompetition.setPayOrderNo(tradeNo);
|
paymentCompetitionService.updateById(paymentCompetition);
|
Competition competition = cttService.getById(paymentCompetition.getCompetitionId());
|
competition.setApplicantsNumber(competition.getApplicantsNumber() + 1);
|
cttService.updateById(competition);
|
// 结算资金到商户账号
|
Thread.sleep(30000);
|
payMoneyUtil.confirm(resSmid,code,tradeNo,money.toString());
|
break;
|
}
|
if ("WAIT_BUYER_PAY".equals(s)) {
|
num++;
|
}
|
}
|
}
|
} catch (Exception e) {
|
e.printStackTrace();
|
}
|
}
|
}).start();
|
}
|
return alipay;
|
}
|
private void extracted(Integer operatorId, BigDecimal money, String tradeNo) throws Exception {
|
// 分账
|
AlipayClient alipayClient = new DefaultAlipayClient("https://openapi.alipay.com/gateway.do",
|
"2021004105665036",
|
"MIIEvwIBADANBgkqhkiG9w0BAQEFAASCBKkwggSlAgEAAoIBAQCi5i9nW/hGLJ3A06cZxTQdviFC7THpdSihoTYGLr9q006hu0V26ecBMY/o4w5bvIX0Ok/yofmZsVcCJpAPvbXL/uqVrIjnRRxXiaeBFThlxoBUTdunvbUSDYfzlEhJr5NvUKI6H6lz2niXlQGx4qy8Hau4ccWit9kM8jwUvsBVQoFgJA+xrjMvooA7YLopQtpOD+UJr5thApTSf1xrnr1W12yolTLEH15JmNV372cqXrYUuqnY0QsaPtxeqJUGAOcGdVLllQ7easEznP8DFBvDdHATcmp2SHNQDUEWN6MCVPbMgY06NQVqAXxqjTAYSVh+6TRu6bofPmpYC3TZB003AgMBAAECggEBAJAcR2+PA3NBYUYHeFrqBRMS8uX8ZR19kjZ7IgoSLTFaQsP9opRylPSPXhrPVBKAE5leRQAHn4MCSlESwHvMfxo7KFjFTFAc6dffZZpipYQUOc9bGampwJh58/3e/pyBgVMG6J23CPf/HJQtNFSkjd/V9+ayb/9l2dUEL3bC0fAZ/dbx8HsxdLw8wn3fLlWLj68hOMqa2deCZe3JdSVsPbeWqkh56FFsMLug0Nd+Ar4TgRl9/jnhXF0JWiD0LmPUYLhboY7EfUBzN4w1iYbDi1P+3zvoOYsiVKAXox9GMhQ2VzOO2UcSTuizSza2e98mGpabl/GpKmCz+RDFjtkX6eECgYEA2MyCij65eO3aGIm3FUe93DULRBYTfX8qJQSJq2WOWA3mmQlEW6L3O2B5/lG2h+8WmN6iLEs9eHpgycGYp7vAqgrANEn16ACVcuyx0scFtrZfZ+kmHMzFfiUWxJjVYk/6YngsGVBLdw6ueM42C8TTP67X9tU5TdVGoGWuqEj4W98CgYEAwFqwprXOch5Pqk/RPbb49r0Ou03K/UbciWnWWKzUhFFNS8MdlQPoDvQZbMwHLeWsa2VhaKITK3x5biLQb3U+0GLOn6lTvEyrEUH+ucREyLgVYTRAvwBPtnvlrzpyxPk2HnslQjju8WrvvLLBMKWUjlTrTOzhaHT21gz3pHMiOakCgYEAhLmfaXdBITGshb054sNLDtdCkGpbgEcrzAHdLps769iGxkYQHXHFngpQZUwtTUcoNGqIKknd1jZFrv7gsD+XkgKG7PwimehRlkwmCX5ilxtLiVgJRzRt6+5U5AMVD90a0tHzXYP0z2yjj73fBJF5KtGl0a10KZxaYrQdm1UhB00CgYBZZgzx/k9rtHC8LAqIj1CYhHejT92G53c6Gkl3vyOqN4sgKhfGmSEySfrDGPRBPZxr8ZtbIPCd5mUdberH0osWGMYFaJI1UsCy7aQwvGpniz7MhZeN7dweaOjwDs8mgtjHQ96mL4XGCDhR0BZ/wIURvZ/6iaGdhbbu9unlsWj3uQKBgQCmZYdsbbZkd3ev6f8rwyvMz+DrCQyYpY44cegBYuJgrZiQnL2fJioeN7ixX0UM48SfwsZEIrzshP/LGAwnc2MdjxKUl4jLN8SEe0NAjXOnz9Zaw740+aOmLpXcLWdP4uM2gIhWsvW1tEkQZCXmm7c9s/RsU8Pmzv+YL3+fSijOzA==",
|
"json", "GBK",
|
"MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAmu8n/4yTHWbn7VOrNc9OsLtDL1bEQ8gC1dHkj8Wy5z0mkaOsjJRIG/28ze12M0V8jdCKuuDr5Z1OPKiqf+XO3ypguEh+mYUVMBM/cZodDFQfTY1TKLWjvQCuaqlA+QUTCK6f7T7stsgyQ1o9Jj0rXZDz6PM4QHSTzjrLIBaeqM5WIBvH+fy/X+QG5Utd+/UT0kc0JyvuKhZ65yVUd/C9VcwJJAPliRsAQNrqYterwAJ9zvw9tF11wj9W0XgJ8Ccu4x3gR1vrlLRJJo/OA97RmxPQ+5hSacWQZCUd1dwiBq+YCrKVHGTj14izRHXrLc0yBlRXo7tBOIqcy3IsvKVthQIDAQAB",
|
"RSA2");
|
AlipayTradeOrderSettleRequest request = new AlipayTradeOrderSettleRequest();
|
String randomCode = UUIDUtil.getRandomCode(16);
|
String proportionByOperatorId = storeClient.getProportionByOperatorId(operatorId);
|
// 支付宝分账比例
|
String s1 = proportionByOperatorId.split(",")[1];
|
double i = Double.parseDouble(s1);
|
double v = i * 0.01;
|
BigDecimal bigDecimal1 = new BigDecimal(String.valueOf(v));
|
BigDecimal cashPayment = money;
|
// 分账金额
|
BigDecimal bigDecimal2 = cashPayment.multiply(bigDecimal1).setScale(2, RoundingMode.DOWN);
|
request.setBizContent("{" +
|
" \"out_request_no\":\"" + randomCode + "\"," +
|
" \"trade_no\":\"" + tradeNo + "\"," +
|
" \"royalty_parameters\":[" +
|
" {" +
|
" \"royalty_type\":\"transfer\"," +
|
" \"trans_out\":\"" + storeClient.getSMIDByOperatorId(operatorId) + "\"," +
|
" \"trans_out_type\":\"userId\"," +
|
" \"trans_in_type\":\"userId\"," +
|
" \"trans_in\":\"" + smid + "\"," +
|
" \"amount\":" + bigDecimal2 + "," +
|
" \"desc\":\"平台服务费\"," +
|
" \"royalty_scene\":\"平台服务费\"," +
|
" }" +
|
" ]," +
|
" \"extend_params\":{" +
|
" \"royalty_finish\":\"true\"" +
|
" }," +
|
" \"royalty_mode\":\"async\"" +
|
"}");
|
AlipayTradeOrderSettleResponse response = alipayClient.execute(request);
|
if (response.isSuccess()) {
|
System.out.println("调用成功");
|
} else {
|
System.out.println("调用失败");
|
}
|
}
|
// @Autowired
|
//private IPaymentCompetitionService paymentCompetitionService;
|
|
@Autowired
|
private CompetitionService competitionService;
|
|
public void moneyOut(String outNum, String tradeNo,String code) throws AlipayApiException {
|
AlipayClient alipayClient = new DefaultAlipayClient("https://openapi.alipay.com/gateway.do", aliAppid, appPrivateKey, "json", "UTF-8", alipay_public_key, "RSA2");
|
AlipayTradeOrderSettleRequest request = new AlipayTradeOrderSettleRequest();
|
AlipayTradeOrderSettleModel model = new AlipayTradeOrderSettleModel();
|
model.setOutRequestNo(outNum);
|
model.setTradeNo(tradeNo);
|
List<RoyaltyDetailInfos> royaltyDetailInfos = new ArrayList<>();
|
|
|
AlipayTradeRoyaltyRelationBindRequest request1 = new AlipayTradeRoyaltyRelationBindRequest();
|
|
|
request1.setBizContent("{" +
|
" \"receiver_list\":[" +
|
" {" +
|
" \"type\":\"loginName\"," +
|
" \"account\":\"19522115070\"," +
|
" \"name\":\"罗易胜\"," +
|
" \"memo\":\"分账给测试商户\"," +
|
" }" +
|
" ]," +
|
" \"out_request_no\":\"" + tradeNo + "\"" +
|
"}");
|
AlipayTradeRoyaltyRelationBindResponse response = alipayClient.execute(request1);
|
if (response.isSuccess()) {
|
System.out.println("绑定调用成功");
|
} else {
|
System.out.println("调用失败");
|
}
|
|
|
|
|
PaymentCompetition code1 = paymentCompetitionService.getOne(new QueryWrapper<PaymentCompetition>().eq("code", code));
|
Competition byId1 = competitionService.getById(code1.getCompetitionId());
|
|
OperatorUser operatorUser = storeClient.queryByStoreId(byId1.getOperatorId());
|
|
|
|
|
OpenApiRoyaltyDetailInfoPojo op = new OpenApiRoyaltyDetailInfoPojo();
|
op.setTransOutType("loginName");
|
op.setTransOut("happysports@weparklife.com");
|
op.setTransInType("loginName");
|
// op.setTransInType("userId");
|
op.setTransIn("19522115070");
|
// op.setTransIn(operatorUser.getAlipayNum());
|
// op.setAmountPercentage(Long.valueOf(operatorUser.getAlipayProportion()));
|
op.setAmountPercentage(100L);
|
|
List<OpenApiRoyaltyDetailInfoPojo> ops = new ArrayList<>();
|
ops.add(op);
|
model.setRoyaltyParameters(ops);
|
|
request.setBizModel(model);
|
|
|
AlipayTradeOrderSettleResponse response1 = alipayClient.execute(request);
|
if (response1.isSuccess()) {
|
System.out.println("调用成功");
|
} else {
|
System.out.println("调用失败");
|
}
|
}
|
|
/**
|
* 定时任务修改赛事状态
|
*/
|
|
@Override
|
public void taskSetStatus() {
|
this.baseMapper.taskSetStatusStart();
|
this.baseMapper.taskSetStatusEnd();
|
|
Date currentTime = new Date();
|
Calendar calendar = Calendar.getInstance();
|
calendar.setTime(currentTime);
|
calendar.add(Calendar.MINUTE, -10);
|
Date tenMinutesAgo = calendar.getTime();
|
List<PaymentCompetition> payStatus = paymentCompetitionService.list(new QueryWrapper<PaymentCompetition>().eq("payStatus", 1).le("insertTime", tenMinutesAgo));
|
List<Long> pays = new ArrayList<>();
|
for (PaymentCompetition status : payStatus) {
|
pays.add(status.getId());
|
}
|
if (!pays.isEmpty()) {
|
this.baseMapper.deleteTenMinutes(pays);
|
}
|
}
|
|
@Override
|
public ResultUtil paymentCompetitionCourseList(Integer uid, Integer id) {
|
Competition competition = this.baseMapper.selectById(id);
|
// 获取门店id 找出符合这些门店的课包
|
String storeId = competition.getStoreId();
|
|
List<PayCourseRes> list = coursePackagePaymentClient.paymentCompetitionCourseList(uid + "_" + storeId);
|
return ResultUtil.success(list);
|
}
|
|
@Override
|
public void moneyOut() throws AlipayApiException {
|
Date date = new Date();
|
List<Competition> list = competitionService.list(new QueryWrapper<Competition>().lt("endTime",date).ne("isOut",1));
|
if(list.size() > 0){
|
List<Integer> coms = new ArrayList<>();
|
for (Competition competition : list) {
|
coms.add(competition.getId());
|
competition.setIsOut(1);
|
}
|
List<PaymentCompetition> pays = paymentCompetitionService.list(new QueryWrapper<PaymentCompetition>().in("competitionId", coms));
|
for (PaymentCompetition pay : pays) {
|
moneyOut(pay.getPayOrderNo(),pay.getPayOrderNo(),pay.getCode());
|
}
|
competitionService.updateBatchById(list);
|
}
|
|
|
}
|
}
|
