commit 09ee07c69e989430e7acdace9f40d9b96cc8dc6c
author YelinCui <22301115@bjtu.edu.cn> Sat Jun 07 05:09:55 2025 +0800
committer YelinCui <22301115@bjtu.edu.cn> Sat Jun 07 09:39:34 2025 +0800
tree ddb79c14c7e8176a400e81c01b207a47f7913d72
parent fe5140c67959dc9e8f2958a1cfb5d0d93a3ca0f8

作弊&促销

Change-Id: Ibdee947370e11c3a98912569e1a290b5e0968fbe

src/main/java/com/example/myproject/mapper/PromotionMapper.java

diff --git a/src/main/java/com/example/myproject/mapper/PromotionMapper.java b/src/main/java/com/example/myproject/mapper/PromotionMapper.java
index a478835..caf96ee 100644
--- a/src/main/java/com/example/myproject/mapper/PromotionMapper.java
+++ b/src/main/java/com/example/myproject/mapper/PromotionMapper.java
@@ -24,7 +24,8 @@
     @Select("SELECT p.* FROM promotion p " +
             "WHERE p.is_deleted = false " +
             "AND p.start_time <= #{now} AND p.end_time >= #{now} " +
-            "AND FIND_IN_SET(#{torrentId}, p.applicable_torrent_ids) > 0")
+//            "AND FIND_IN_SET(#{torrentId}, p.applicable_torrent_ids) > 0"
+             "AND JSON_CONTAINS(p.applicable_torrent_ids, CAST(#{torrentId} AS JSON))")
     List<Promotion> findActivePromotionsForTorrent(
             @Param("torrentId") Long torrentId,
             @Param("now") LocalDateTime now);