From a8bfc865c10c1ad75322510c1901edd8a46b12de Mon Sep 17 00:00:00 2001 From: puzhibing <393733352@qq.com> Date: 星期四, 07 三月 2024 11:11:14 +0800 Subject: [PATCH] 合并代码 --- cloud-server-communityWorldCup/src/main/resources/mapper/WorldCupCompetitorMapper.xml | 12 ++++++++++-- 1 files changed, 10 insertions(+), 2 deletions(-) diff --git a/cloud-server-communityWorldCup/src/main/resources/mapper/WorldCupCompetitorMapper.xml b/cloud-server-communityWorldCup/src/main/resources/mapper/WorldCupCompetitorMapper.xml index d3f9fb2..265f7f5 100644 --- a/cloud-server-communityWorldCup/src/main/resources/mapper/WorldCupCompetitorMapper.xml +++ b/cloud-server-communityWorldCup/src/main/resources/mapper/WorldCupCompetitorMapper.xml @@ -178,7 +178,11 @@ appUserId, count(*) as num from t_world_cup_competitor - where worldCupId = #{worldCupId} group by participantType, participantId, appUserId + where 1 = 1 + <if test="null != worldCupId"> + and worldCupId = #{worldCupId} + </if> + group by participantType, participantId, appUserId ) as a left join ( select @@ -187,7 +191,11 @@ appUserId, count(*) as num from t_world_cup_competitor - where matchResult = 1 and worldCupId = #{worldCupId} group by participantType, participantId, appUserId + where matchResult = 1 + <if test="null != worldCupId"> + and worldCupId = #{worldCupId} + </if> + group by participantType, participantId, appUserId ) as b on (a.participantId = b.participantId and a.participantType = b.participantType) ) as aa order by aa.totalSession desc </select> -- Gitblit v1.7.1