package jnpf.elnMapper;

import com.baomidou.mybatisplus.core.metadata.IPage;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface ElnDianziJiluMubanMapper {

    @Select("SELECT muban_file "
            + "FROM eln_dianzi_jilu_muban_guanli "
            + "WHERE f_tenant_id = #{tenantId} "
            + "AND jianyan_xiangmu = #{jianyanXiangmu} "
            + "AND COALESCE(f_delete_mark, 0) = 0 "
            + "AND biz_enabled = 'enabled' "
            + "AND shengxiao_riqi IS NOT NULL "
            + "AND shengxiao_riqi <= CURRENT_TIMESTAMP "
            + "AND muban_file IS NOT NULL "
            + "AND TRIM(muban_file) <> '' "
            + "ORDER BY shengxiao_riqi DESC, "
            + "CASE WHEN chuangjian_shijian IS NULL THEN 1 ELSE 0 END, "
            + "chuangjian_shijian DESC, f_id DESC")
    IPage<String> selectLatestMubanFiles(IPage<String> page,
                                         @Param("tenantId") String tenantId,
                                         @Param("jianyanXiangmu") String jianyanXiangmu);
}