| | |
| | | package com.mzl.flower.mapper.film; |
| | | |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import com.mzl.flower.dto.request.film.FilmCollectsQueryDTO; |
| | | import com.mzl.flower.dto.response.film.FilmCollectsVO; |
| | | import com.mzl.flower.entity.film.FilmCollects; |
| | | import org.apache.ibatis.annotations.Param; |
| | | import org.apache.ibatis.annotations.Select; |
| | |
| | | import org.springframework.stereotype.Repository; |
| | | |
| | | import java.time.LocalDate; |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * <p> |
| | |
| | | |
| | | @Select("SELECT COUNT(*) FROM film_collects WHERE film_id = #{filmId} AND DATE(create_time) = #{date} and deleted = '0' ") |
| | | int countByFilmIdAndDate(Long id, LocalDate yesterday); |
| | | |
| | | List<FilmCollectsVO> queryPage(@Param("dto")FilmCollectsQueryDTO dto, Page page); |
| | | } |