From 46715d892da947c31f07796fdc79dbbef06677b3 Mon Sep 17 00:00:00 2001 From: cloudroam <cloudroam> Date: 星期一, 14 七月 2025 09:53:19 +0800 Subject: [PATCH] add:定时任务配置,热门城市 --- src/main/java/com/mzl/flower/mapper/film/FilmLocationMapper.java | 4 ++++ 1 files changed, 4 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/mzl/flower/mapper/film/FilmLocationMapper.java b/src/main/java/com/mzl/flower/mapper/film/FilmLocationMapper.java index 85c6cc1..1aa3157 100644 --- a/src/main/java/com/mzl/flower/mapper/film/FilmLocationMapper.java +++ b/src/main/java/com/mzl/flower/mapper/film/FilmLocationMapper.java @@ -42,4 +42,8 @@ "</script>") @MapKey("id") Map<Long, FilmLocationNameDTO> getLocationNamesByIds(@Param("list") List<Long> ids); + + + @Select("select * from film_location where is_enabled = '1' and deleted = '0' order by location_weight desc limit 3") + List<FilmLocationVO> getFilmLocationListTop3(); } -- Gitblit v1.9.3