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.HomeConfigQueryDTO;
import com.mzl.flower.dto.response.film.HomeConfigVO;
import com.mzl.flower.entity.film.HomeConfig;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;


/**
 *
 * @author generator@Fang
 * @since 2025-05-29
 */
@Repository
public interface HomeConfigMapper extends BaseMapper<HomeConfig> {

    List<HomeConfigVO> queryPage(@Param("dto")HomeConfigQueryDTO homeConfigQueryDTO, Page page);

    @Select("select * from home_config where status = #{name} and deleted = '0'")
    List<HomeConfig> queryList(String name);


    @Select("select * from home_config where status = 'published' and deleted = '0' limit 1")
    HomeConfigVO getHomeConfigInfo();
}