From b0fee54f8475336b05c50ef3154c51f60ebd63aa Mon Sep 17 00:00:00 2001
From: cloudroam <cloudroam>
Date: 星期日, 22 六月 2025 17:55:12 +0800
Subject: [PATCH] add:首页配置
---
src/main/java/com/mzl/flower/mapper/film/FilmWorksMapper.java | 7 +++++++
1 files changed, 7 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/mzl/flower/mapper/film/FilmWorksMapper.java b/src/main/java/com/mzl/flower/mapper/film/FilmWorksMapper.java
index 700fe84..c792a10 100644
--- a/src/main/java/com/mzl/flower/mapper/film/FilmWorksMapper.java
+++ b/src/main/java/com/mzl/flower/mapper/film/FilmWorksMapper.java
@@ -26,4 +26,11 @@
List<FilmWorksVO> queryPage(@Param("dto") FilmWorksQueryDTO dto, Page page);
FilmWorksVO selectInfoById(@Param("id") Long id, @Param("userId") String userId);
+
+ //获取权重最高的数据
+ @Select("select * from film_works where sticky_weight = (select max(sticky_weight) from film_works) limit 1")
+ FilmWorks getTopStickyWeight();
+
+ @Select("select * from film_works where deleted = '0' and status = 'pending_create'")
+ List<FilmWorksVO> pendingCreate();
}
--
Gitblit v1.9.3