l1024-jav/src/main/java/top/lvzhiqiang/mapper/PictureInfoMapper.java

package top.lvzhiqiang.mapper;

import org.apache.ibatis.annotations.Select;
import top.lvzhiqiang.entity.FileImage;
import top.lvzhiqiang.entity.VideoCast;
import top.lvzhiqiang.entity.VideoGenres;

import java.util.List;
import java.util.Map;

/**
 * 照片信息Mapper
 *
 * @author lvzhiqiang
 * 2024/8/26 11:02
 */
public interface PictureInfoMapper {


    @Select("select main_who AS name, count(id) AS count from video_info_infantry where type = #{infantryType} group by main_who order by count(id) desc")
    List<VideoCast> findCast(String infantryType);

    @Select("select fic.category_name AS name, count(fi.category_id) AS count " +
            "from file_image fi " +
            "         left join file_image_category fic on fi.category_id = fic.id " +
            "group by fi.category_id " +
            "order by count(fi.category_id) desc ")
    List<VideoGenres> findUploadGenres();

    @Select({"<script>" +
            "select fi.*,fic.category_name from file_image fi left join file_image_category fic on fi.category_id = fic.id WHERE 1 = 1" +
            "<if test=\"keyword != null and keyword != ''\">" +
            "   and fi.remark like concat('%',#{keyword},'%')" +
            "</if>" +
            "<if test=\"genres != null and genres != ''\">" +
            "   and fic.category_name = #{genres}" +
            "</if>" +
            "</script>"})
    List<FileImage> getUploadImageInfoList(Map<String, Object> params);
}