package com.xxfc.platform.app.mapper;

import com.xxfc.platform.app.entity.Banner;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;


/**
 * 首页banner图
 * 
 * @author zjw
 * @email nishijjo@qq.com
 * @date 2019-06-06 11:41:51
 */
@Repository
public interface BannerMapper extends Mapper<Banner> {

    @Select("select * from `banner` where is_del=#{isDel} order by rank ASC")
    List<Banner> findBannerListByisDelOrderByRank(Banner banner);


    @Select("select * from `banner` where `is_del`=0 and `type`=#{type} order by rank asc ")
    List<Banner> findBannerListByType(Integer type);
}
