VipCardLogServiceImpl.java 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405
  1. package beilv.vipCardLog.service.impl;
  2. import beilv.admissionticket.domain.AdmissionTicket;
  3. import beilv.admissionticket.mapper.AdmissionTicketMapper;
  4. import beilv.admissionticket.service.IAdmissionTicketService;
  5. import beilv.carinformation.domain.CarInformation;
  6. import beilv.carinformation.service.ICarInformationService;
  7. import beilv.common.core.domain.AjaxResult;
  8. import beilv.common.core.text.Convert;
  9. import beilv.common.utils.DateUtils;
  10. import beilv.common.utils.StringUtils;
  11. import beilv.common.utils.uuid.IdUtils;
  12. import beilv.competition.domain.Competition;
  13. import beilv.competition.service.ICompetitionService;
  14. import beilv.system.service.ISysConfigService;
  15. import beilv.usermembershipcard.domain.UserMembershipCard;
  16. import beilv.usermembershipcard.service.IUserMembershipCardService;
  17. import beilv.vipCard.domain.VipCard;
  18. import beilv.vipCard.service.IVipCardService;
  19. import beilv.vipCardAmountLog.domain.VipCardAmountLog;
  20. import beilv.vipCardAmountLog.mapper.VipCardAmountLogMapper;
  21. import beilv.vipCardLog.domain.VipCardLog;
  22. import beilv.vipCardLog.mapper.VipCardLogMapper;
  23. import beilv.vipCardLog.service.IVipCardLogService;
  24. import org.checkerframework.checker.units.qual.A;
  25. import org.springframework.beans.factory.annotation.Autowired;
  26. import org.springframework.data.redis.core.StringRedisTemplate;
  27. import org.springframework.stereotype.Service;
  28. import javax.annotation.Resource;
  29. import java.math.BigDecimal;
  30. import java.math.RoundingMode;
  31. import java.text.SimpleDateFormat;
  32. import java.time.LocalDateTime;
  33. import java.time.format.DateTimeFormatter;
  34. import java.time.temporal.ChronoUnit;
  35. import java.util.List;
  36. import java.util.Map;
  37. import static beilv.competition.domain.Constant.ORDER_QUEUE;
  38. /**
  39. * 充值记录Service业务层处理
  40. *
  41. * @author LG
  42. * @date 2025-11-12
  43. */
  44. @Service
  45. public class VipCardLogServiceImpl implements IVipCardLogService {
  46. @Resource
  47. private VipCardLogMapper vipCardLogMapper;
  48. @Autowired
  49. private IVipCardService vipCardService;
  50. @Autowired
  51. private ICompetitionService competitionService;
  52. @Autowired
  53. private IUserMembershipCardService userMembershipCardService;
  54. @Autowired
  55. private ICarInformationService carInformationService;
  56. @Autowired
  57. private IAdmissionTicketService ticketService;
  58. @Autowired
  59. private ISysConfigService configService;
  60. @Resource
  61. private VipCardAmountLogMapper amountLogMapper;
  62. @Autowired
  63. private StringRedisTemplate stringRedisTemplate;
  64. /**
  65. * 查询充值记录
  66. *
  67. * @param id 充值记录主键
  68. * @return 充值记录
  69. */
  70. @Override
  71. public VipCardLog selectVipCardLogById(String id) {
  72. return vipCardLogMapper.selectVipCardLogById(id);
  73. }
  74. /**
  75. * 查询充值记录列表
  76. *
  77. * @param vipCardLog 充值记录
  78. * @return 充值记录
  79. */
  80. @Override
  81. public List<VipCardLog> selectVipCardLogList(VipCardLog vipCardLog) {
  82. return vipCardLogMapper.selectVipCardLogList(vipCardLog);
  83. }
  84. /**
  85. * 新增充值记录
  86. *
  87. * @param vipCardLog 充值记录
  88. * @return 结果
  89. */
  90. @Override
  91. public int insertVipCardLog(VipCardLog vipCardLog) {
  92. return vipCardLogMapper.insertVipCardLog(vipCardLog);
  93. }
  94. /**
  95. * 修改充值记录
  96. *
  97. * @param vipCardLog 充值记录
  98. * @return 结果
  99. */
  100. @Override
  101. public int updateVipCardLog(VipCardLog vipCardLog) {
  102. return vipCardLogMapper.updateVipCardLog(vipCardLog);
  103. }
  104. /**
  105. * 批量删除充值记录
  106. *
  107. * @param ids 需要删除的充值记录主键
  108. * @return 结果
  109. */
  110. @Override
  111. public int deleteVipCardLogByIds(String ids) {
  112. return vipCardLogMapper.deleteVipCardLogByIds(Convert.toStrArray(ids));
  113. }
  114. /**
  115. * 删除充值记录信息
  116. *
  117. * @param id 充值记录主键
  118. * @return 结果
  119. */
  120. @Override
  121. public int deleteVipCardLogById(String id) {
  122. return vipCardLogMapper.deleteVipCardLogById(id);
  123. }
  124. @Override
  125. public int updateVipCardLogByOrderId(VipCardLog vipCardLog) {
  126. //验证订单编号是否为空
  127. if (StringUtils.isEmpty(vipCardLog.getId())) {
  128. return 0;
  129. }
  130. //拉去订单信息
  131. VipCardLog orderInfo = vipCardLogMapper.selectVipCardLogById(vipCardLog.getId());
  132. //充值订单和其他订单处理方式不同
  133. if ("chongzhi".equals(orderInfo.getOrderType())) {
  134. charging(vipCardLog, orderInfo);
  135. } else {
  136. other(vipCardLog, orderInfo);
  137. }
  138. //更新订单状态
  139. return vipCardLogMapper.updateVipCardLog(vipCardLog);
  140. }
  141. /**
  142. * 充值回调
  143. *
  144. * @param vipCardLog 订单请求信息
  145. * @param orderInfo 原订单信息
  146. * @return
  147. */
  148. private void charging(VipCardLog vipCardLog, VipCardLog orderInfo) {
  149. if ("payment_status_have_paid".equals(vipCardLog.getPaymentStatus())) {
  150. //拉取订单信息
  151. // VipCardLog orderInfo = vipCardLogMapper.selectVipCardLogById(vipCardLog.getId());
  152. //获取会员卡信息
  153. VipCard vipCard = vipCardService.selectVipCardByUserId(orderInfo.getUserId());
  154. //获取当前余额
  155. BigDecimal balance = BigDecimal.ZERO;
  156. String vipCardId;
  157. if (null == vipCard) {
  158. //true 没有会员卡; 新增会员卡, 并且设置本次充值金额
  159. vipCardId = vipCardService.insertVipCard(new VipCard(Long.parseLong(orderInfo.getUserId()), orderInfo.getPracticalMoney(), BigDecimal.ZERO));
  160. } else {
  161. balance = vipCard.getBalance();
  162. vipCardId = vipCard.getId();
  163. //false 有会员卡,
  164. vipCardService.updateVipCard(new VipCard(Long.parseLong(orderInfo.getUserId()), orderInfo.getPracticalMoney().add(vipCard.getBalance()).setScale(2, RoundingMode.HALF_UP), vipCard.getScore()));
  165. }
  166. //设定支付时间
  167. vipCardLog.setPaymentTime(DateUtils.getNowDate());
  168. //写入会员卡流水
  169. insertAmountLog(new VipCardAmountLog(orderInfo.getUserId(), vipCardId, orderInfo.getId(), balance, orderInfo.getPracticalMoney(),"1"));
  170. //支付成功移除定时任务
  171. stringRedisTemplate.delete(ORDER_QUEUE+orderInfo.getId());
  172. } else if ("payment_status_cancelled".equals(vipCardLog.getPaymentStatus())) {
  173. //如果是取消, 设置支付状态为取消支付
  174. vipCardLog.setCancellationTime(DateUtils.getNowDate());
  175. }
  176. }
  177. /**
  178. * 其他支付回调
  179. *
  180. * @param vipCardLog
  181. * @return
  182. */
  183. private void other(VipCardLog vipCardLog, VipCardLog orderInfo) {
  184. //拉取订单信息
  185. // VipCardLog orderInfo = vipCardLogMapper.selectVipCardLogById(vipCardLog.getId());
  186. if ("payment_status_have_paid".equals(vipCardLog.getPaymentStatus())) {
  187. //支付成功流程
  188. //设置支付时间
  189. vipCardLog.setPaymentTime(DateUtils.getNowDate());
  190. //获取订单类型
  191. String orderType = orderInfo.getOrderType();
  192. if ("gouka".equals(orderType)) {
  193. //如果是购买次卡订单, 拉去卡种信息
  194. CarInformation carInformation = carInformationService.selectCarInformationById(Long.valueOf(orderInfo.getBusId()));
  195. //购卡订单, 支付成功, 生成卡片写入到次卡表
  196. userMembershipCardService.insertUserMembershipCard(new UserMembershipCard(orderInfo.getUserId(), vipCardLog.getId(), carInformation.getTotalNumber(), "0", "3", DateUtils.getNowDate(), orderInfo.getBusId()));
  197. }
  198. if("yueqiu".equals(orderType)){
  199. //如果是约球订单
  200. AdmissionTicket admissionTicket = new AdmissionTicket();
  201. admissionTicket.setId(orderInfo.getBusId());
  202. //创建场次定时任务, 到时间自动核销
  203. ticketService.createTask(admissionTicket);
  204. }
  205. } else if ("payment_status_cancelled".equals(vipCardLog.getPaymentStatus())) {
  206. //如果是取消订单,设置支付状态为取消支付
  207. vipCardLog.setCancellationTime(DateUtils.getNowDate());
  208. if ("yueqiu".equals(orderInfo.getOrderType())) {
  209. //如果是约球订单, 修改球场信息
  210. AdmissionTicket admissionTicket = new AdmissionTicket();
  211. admissionTicket.setId(orderInfo.getBusId());
  212. admissionTicket.setAdmissionTicketStatus("0");
  213. ticketService.updateBeilvAdmissionTicket(admissionTicket);
  214. }
  215. }
  216. }
  217. @Override
  218. public int getRegistrantsNumber(VipCardLog vipCardLog) {
  219. return vipCardLogMapper.getRegistrantsNumber(vipCardLog);
  220. }
  221. @Override
  222. public AjaxResult refundById(VipCardLog vipCardLog, boolean isOnline) {
  223. if(StringUtils.isEmpty(vipCardLog.getId())){
  224. return AjaxResult.error("订单编号不能为空!");
  225. }
  226. //拉去订单信息
  227. VipCardLog orderInfo = vipCardLogMapper.selectVipCardLogById(vipCardLog.getId());
  228. if ("payment_status_to_be_paid".equals(orderInfo.getPaymentStatus())) {
  229. return AjaxResult.error("订单未支付, 无需退款!");
  230. }
  231. if ("payment_status_cancelled".equals(orderInfo.getPaymentStatus())) {
  232. return AjaxResult.error("订单已取消, 无需退款!");
  233. }
  234. if ("payment_status_refunded".equals(orderInfo.getPaymentStatus())) {
  235. return AjaxResult.error("订单已退款, 无需重复操作!");
  236. }
  237. if ("payment_status_verification".equals(orderInfo.getPaymentStatus())) {
  238. return AjaxResult.error("订单已核销, 无法退款!");
  239. }
  240. //退款金额
  241. BigDecimal refundPrice = BigDecimal.valueOf(0);
  242. int refundSum = 0;
  243. if ("yueqiu".equals(orderInfo.getOrderType())) {
  244. if (isOnline) {
  245. // 获取设定的取消时间范围(分钟)
  246. long cancelMinutes = Long.parseLong(configService.selectConfigByKey("cancel.minutes"));
  247. // 根据订单获取约场的开始时间
  248. AdmissionTicket admissionTicket = ticketService.selectBeilvAdmissionTicketById(orderInfo.getBusId());
  249. String format = new SimpleDateFormat("yyyy-MM-dd").format(admissionTicket.getTicketDate());
  250. String startTime = admissionTicket.getSession().split("-")[0]; // 10:00
  251. // 当前时间
  252. LocalDateTime now = LocalDateTime.now();
  253. // 定义日期时间格式器
  254. DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm");
  255. // 将 startTime 转换为 LocalDateTime
  256. LocalDateTime startDateTime = LocalDateTime.parse(format + " " + startTime, formatter);
  257. // 计算 startTime 减去 cancelMinutes 后的时间
  258. LocalDateTime cancelTime = startDateTime.minus(cancelMinutes, ChronoUnit.MINUTES);
  259. // 判断当前时间是否可以退款
  260. if (cancelTime.isBefore(now)) {
  261. return AjaxResult.error("距离开场不足" + cancelMinutes + "分钟, 不允许线上退款!如需退款请线下联系工作人员!");
  262. }
  263. admissionTicket.setAdmissionTicketStatus("0");
  264. ticketService.updateBeilvAdmissionTicket(admissionTicket);
  265. }
  266. if ("numCard".equals(orderInfo.getPaymentType())) {
  267. refundSum++;
  268. } else {
  269. refundPrice = refundPrice.add(orderInfo.getPracticalMoney());
  270. }
  271. } else if ("gouka".equals(orderInfo.getOrderType())) {
  272. //拿到次卡信息, 得到剩余使用次数
  273. UserMembershipCard userMembershipCard = userMembershipCardService.selectUserMembershipCardRecordId(orderInfo.getId());
  274. //获取原价信息
  275. CarInformation carInformation = carInformationService.selectCarInformationById(Long.valueOf(orderInfo.getBusId()));
  276. //计算已使用次数
  277. BigDecimal useSum = BigDecimal.valueOf(carInformation.getTotalNumber() - userMembershipCard.getRemainingNumber());
  278. //计算需要支付的金额
  279. BigDecimal userPrice = useSum.multiply(carInformation.getOriginalPrice());
  280. //实际支付的金额 - 需要支付的金额 = 退款金额
  281. BigDecimal refundMoner = orderInfo.getMemberPrice().subtract(userPrice);
  282. //判断如果退款金额 不大于0, 则设置退款金额为0
  283. refundMoner = refundMoner.compareTo(BigDecimal.ZERO) > 0 ? refundMoner : BigDecimal.ZERO;
  284. //计算退款金额
  285. refundPrice = refundPrice.add(refundMoner);
  286. } else if ("cansai".equals(orderInfo.getOrderType()) || "menpiao".equals(orderInfo.getOrderType())) {
  287. //验证赛事状态, 已经开始/已经结束/已经关闭 无法退款
  288. Competition competition = competitionService.selectCompetitionById(Integer.valueOf(orderInfo.getBusId()));
  289. if ("competiton_state_5".equals(competition.getCompetitionState())) {
  290. return AjaxResult.error("赛事已开始, 无法退票!");
  291. }
  292. if ("competiton_state_6".equals(competition.getCompetitionState())) {
  293. return AjaxResult.error("赛事已结束, 无法退票!");
  294. }
  295. if ("competiton_state_3".equals(competition.getCompetitionState())) {
  296. return AjaxResult.error("报名已结束, 无法退票!");
  297. }
  298. if ("competiton_state_4".equals(competition.getCompetitionState())) {
  299. return AjaxResult.error("赛事已关闭, 无法退票!");
  300. }
  301. //计算退款金额
  302. refundPrice = refundPrice.add(orderInfo.getPracticalMoney());
  303. }
  304. vipCardLog.setRefundPrice(refundPrice);
  305. if("vipCard".equals(orderInfo.getPaymentType())){
  306. //查询会员卡信息
  307. VipCard vipCard = vipCardService.selectVipCardById(orderInfo.getPaymentId());
  308. //写入会员卡流水
  309. VipCardAmountLog vipCardAmountLog = new VipCardAmountLog(orderInfo.getUserId(), orderInfo.getPaymentId(), orderInfo.getId(), vipCard.getBalance(), refundPrice, "1");
  310. amountLogMapper.insertVipCardAmountLog(vipCardAmountLog);
  311. vipCard.setBalance(vipCardAmountLog.getRemainingAmount());
  312. vipCardService.updateVipCard(vipCard);
  313. } else if ("weChart".equals(orderInfo.getPaymentType())) {
  314. orderInfo.setRefundPrice(refundPrice);
  315. } else if ("numCard".equals(orderInfo.getPaymentType())) {
  316. //查询次卡信息
  317. UserMembershipCard userMembershipCard = userMembershipCardService.selectUserMembershipCardById(Long.valueOf(orderInfo.getPaymentId()));
  318. //剩余使用次数+1
  319. userMembershipCard.setRemainingNumber(userMembershipCard.getRemainingNumber() + refundSum);
  320. //更新次卡信息
  321. userMembershipCardService.updateUserMembershipCard(userMembershipCard);
  322. }
  323. vipCardLog.setRefundTime(DateUtils.getNowDate());
  324. vipCardLog.setPaymentStatus("payment_status_refunded");
  325. vipCardLogMapper.updateVipCardLog(vipCardLog);
  326. if ("weChart".equals(orderInfo.getPaymentType())){
  327. return AjaxResult.success(orderInfo);
  328. }
  329. return AjaxResult.success("退款成功!");
  330. }
  331. @Override
  332. public List<Map<String, Object>> selectYueQiuList(VipCardLog vipCardLog) {
  333. vipCardLog.setOrderType("yueqiu");
  334. return vipCardLogMapper.selectYueQiuList(vipCardLog);
  335. }
  336. @Override
  337. public List<Map<String, Object>> selectCanSaiList(VipCardLog vipCardLog) {
  338. return vipCardLogMapper.selectCanSaiList(vipCardLog);
  339. }
  340. public void insertAmountLog(VipCardAmountLog vipCardAmountLog){
  341. amountLogMapper.insertVipCardAmountLog(vipCardAmountLog);
  342. }
  343. }