package com.mzl.flower.mapper.film;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.mzl.flower.entity.film.FilmCollects;
|
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>
|
* 影视作品收藏表 Mapper 接口
|
* </p>
|
*
|
* @author generator@Fang
|
* @since 2025-05-29
|
*/
|
@Repository
|
public interface FilmCollectsMapper extends BaseMapper<FilmCollects> {
|
|
@Select("select * from film_collects where film_id = #{filmId} and create_by = #{createBy}")
|
FilmCollects getFilmCollectsByfilmIdAndCreateBy(Integer filmId, String createBy);
|
|
@Update("UPDATE film_collects 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_collects WHERE film_id = #{filmId} AND DATE(create_time) = #{date} and deleted = '0' ")
|
int countByFilmIdAndDate(Long id, LocalDate yesterday);
|
}
|
