package com.mzl.flower.mapper.film;

import com.mzl.flower.entity.film.CommentLikes;
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;

/**
 * 评论点赞表 Mapper
 */
@Repository
public interface CommentLikesMapper extends BaseMapper<CommentLikes> {

    /**
     * 根据评论id查询点赞数量
     */
    @Select("select count(1) from comment_likes where  status = '1' and comment_id =#{ id}  ")
    Long getLikeCountCommentId(Integer id);

    /**
     * 判断用户是否点赞
     */
    @Select("select status from comment_likes where comment_id = #{commentId} and create_by = #{userId} ")
    Boolean isLike(Integer commentId, String userId);

    /**
     * 查询人员有没有对应的评论点赞信息
     */

    @Select("select * from comment_likes where create_by = #{userId} and comment_id = #{commentId} ")
    CommentLikes getCommentLikeByUserIdAndCommentId(String userId, Integer commentId);


    @Update("UPDATE comment_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);
}