From 18f59ad508af9d49705b579b5094251687a9e3dd Mon Sep 17 00:00:00 2001 From: cloudroam <cloudroam> Date: 星期六, 05 七月 2025 11:26:34 +0800 Subject: [PATCH] add:动态注册定时任务 --- src/main/java/com/mzl/flower/mapper/film/FilmWorksMapper.java | 17 +++++++++++++++++ 1 files changed, 17 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 e259f11..89f70b4 100644 --- a/src/main/java/com/mzl/flower/mapper/film/FilmWorksMapper.java +++ b/src/main/java/com/mzl/flower/mapper/film/FilmWorksMapper.java @@ -2,13 +2,16 @@ import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.mzl.flower.dto.request.film.FilmWorksQueryDTO; +import com.mzl.flower.dto.response.film.FilmLocationNameDTO; import com.mzl.flower.dto.response.film.FilmWorksVO; import com.mzl.flower.entity.film.FilmWorks; import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import org.apache.ibatis.annotations.MapKey; import org.apache.ibatis.annotations.Param; import org.apache.ibatis.annotations.Select; import java.util.List; +import java.util.Map; /** * <p> @@ -30,4 +33,18 @@ //获取权重最高的数据 @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(); + + + @Select("<script>" + + "select * from film_works where deleted = '0' " + + "and id IN " + + "<foreach item='id' collection='list' open='(' separator=',' close=')'>" + + "#{id}" + + "</foreach>" + + "</script>") + @MapKey("id") + List<FilmWorksVO> getFilmWorksByIds(@Param("list") List<Long> ids); } -- Gitblit v1.9.3