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);
|
}
|
