From 32ec3be58557fb96c97585bcedfd383c1953822e Mon Sep 17 00:00:00 2001
From: liujie <1793218484@qq.com>
Date: 星期三, 20 八月 2025 15:52:01 +0800
Subject: [PATCH] 赛事模块
---
cloud-server-communityWorldCup/src/main/resources/mapper/WorldCupCompetitorMapper.xml | 5 ++++-
1 files changed, 4 insertions(+), 1 deletions(-)
diff --git a/cloud-server-communityWorldCup/src/main/resources/mapper/WorldCupCompetitorMapper.xml b/cloud-server-communityWorldCup/src/main/resources/mapper/WorldCupCompetitorMapper.xml
index 58c0905..7161067 100644
--- a/cloud-server-communityWorldCup/src/main/resources/mapper/WorldCupCompetitorMapper.xml
+++ b/cloud-server-communityWorldCup/src/main/resources/mapper/WorldCupCompetitorMapper.xml
@@ -33,7 +33,7 @@
a.opponentScore,
DATE_FORMAT(a.startTime, '%Y-%m-%d %H:%i') as startTime,
a.matchResult,
- (a.participationIntegral + a.winIntegral) as award
+ (a.participationIntegral + a.winIntegral+a.drawIntegral+a.loseIntegral) as award
from t_world_cup_competitor a
left join t_world_cup b on (a.worldCupId = b.id)
where a.matchResult is not null and a.participantId = #{item.id} and a.participantType = #{item.isStudent}
@@ -351,6 +351,9 @@
left join t_world_cup_payment b on (a.worldCupPaymentId = b.id)
left join t_world_cup c on (b.worldCupId = c.id)
where a.participantId = #{item.id} and b.payStatus = 2 and b.refundTime is null and b.state = 1
+ <if test="null != item.name">
+ and c.name like CONCAT('%', #{item.name}, '%')
+ </if>
order by a.createTime desc
</select>
</mapper>
\ No newline at end of file
--
Gitblit v1.7.1