package com.mzl.flower.mapper.film;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.mzl.flower.dto.request.film.FilmCategoryQueryDTO;
import com.mzl.flower.dto.response.film.FilmCategoryTreeDTO;
import com.mzl.flower.entity.film.FilmCategory;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface FilmCategoryMapper extends BaseMapper<FilmCategory> {

    /**
     * 查询分类列表
     */
    List<FilmCategoryTreeDTO> selectCategoryList(FilmCategoryQueryDTO dto);

    /**
     * 查询分类树列表
     */
    List<FilmCategoryTreeDTO> selectTreeList(FilmCategoryQueryDTO dto);


    @Select("select  * from  t_film_category where  parent_id is null and shown = '1' and deleted = '0' ")
    List<FilmCategory> getParentCategoryList();
}