From d3ca5fbb31fd0d52be2099e1be9a2f1b245686c6 Mon Sep 17 00:00:00 2001
From: puzhibing <393733352@qq.com>
Date: 星期三, 06 三月 2024 18:19:28 +0800
Subject: [PATCH] 添加方法
---
cloud-server-communityWorldCup/src/main/resources/mapper/WorldCupMapper.xml | 26 ++++++++++++++++++++++++++
1 files changed, 26 insertions(+), 0 deletions(-)
diff --git a/cloud-server-communityWorldCup/src/main/resources/mapper/WorldCupMapper.xml b/cloud-server-communityWorldCup/src/main/resources/mapper/WorldCupMapper.xml
index a7ac853..a295f55 100644
--- a/cloud-server-communityWorldCup/src/main/resources/mapper/WorldCupMapper.xml
+++ b/cloud-server-communityWorldCup/src/main/resources/mapper/WorldCupMapper.xml
@@ -122,4 +122,30 @@
and status= #{item.status}
</if>
</select>
+
+
+
+ <select id="worldCupGameStatistics" resultType="map">
+ select
+ a.id,
+ a.`name`,
+ DATE_FORMAT(a.startTime, '%Y.%m.%d %H:%i') as startTime,
+ DATE_FORMAT(a.endTime, '%Y.%m.%d %H:%i') as endTime,
+ from t_world_cup a
+ where 1 = 1
+ <if test="null != item.name and '' != item.name">
+ and a.`name` like CONCAT('%', #{item.name}, '%')
+ </if>
+ order by a.createTime desc limit #{item.offset}, #{item.limit}
+ </select>
+
+ <select id="worldCupGameStatisticsCount" resultType="int">
+ select
+ count(*)
+ from t_world_cup a
+ where 1 = 1
+ <if test="null != item.name and '' != item.name">
+ and a.`name` like CONCAT('%', #{item.name}, '%')
+ </if>
+ </select>
</mapper>
\ No newline at end of file
--
Gitblit v1.7.1