From 8b02c916fec8819f4f1b27b21a26cca6c41b5f5d Mon Sep 17 00:00:00 2001
From: cloudroam <cloudroam>
Date: 星期一, 14 七月 2025 09:54:05 +0800
Subject: [PATCH] add:定时任务配置，热门城市
---
src/main/java/com/mzl/flower/mapper/film/FilmLikesMapper.java | 16 ++++++++++++++++
1 files changed, 16 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/mzl/flower/mapper/film/FilmLikesMapper.java b/src/main/java/com/mzl/flower/mapper/film/FilmLikesMapper.java
index 81f01a2..8192fe6 100644
--- a/src/main/java/com/mzl/flower/mapper/film/FilmLikesMapper.java
+++ b/src/main/java/com/mzl/flower/mapper/film/FilmLikesMapper.java
@@ -2,7 +2,12 @@
import com.mzl.flower.entity.film.FilmLikes;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Select;
+import org.apache.ibatis.annotations.Update;
import org.springframework.stereotype.Repository;
+
+import java.time.LocalDate;
/**
* <p>
@@ -15,4 +20,15 @@
@Repository
public interface FilmLikesMapper extends BaseMapper<FilmLikes> {
+
+ @Select("select * from film_likes where film_id = #{filmId} and create_by = #{createBy}")
+ FilmLikes getFilmLikesByfilmIdAndCreateBy(Integer filmId, String createBy);
+
+ @Update("UPDATE film_likes SET status = #{status}, update_by = #{updateBy}, update_time = NOW() WHERE id = #{id}")
+ int updateStatusById(@Param("id") Long id,
+ @Param("status") Boolean status,
+ @Param("updateBy") String updateBy);
+
+ @Select("SELECT COUNT(*) FROM film_likes WHERE film_id = #{filmId} AND DATE(create_time) = #{date} and deleted = '0' ")
+ int countByFilmIdAndDate(Long id, LocalDate yesterday);
}
--
Gitblit v1.9.3