package thyyxxk.webserver.dao.lis;

import com.baomidou.dynamic.datasource.annotation.DS;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import thyyxxk.webserver.pojo.examinations.covidexam.CovidExamResult;

import java.util.List;

@Mapper
@DS("lis")
public interface CovidExamDao {

    @Select("select " +
            "a.ptnt_name as ptntName, a.id_card as idCard, c.itm_str_value as itmStrValue, " +
            "b.ordr_create_date as ordrCreateDate " +
            "from m_ordr_info(nolock) as a " +
            "inner join m_ordr(nolock) as b on a.ordr_info_id = b.ordr_info_id " +
            "inner join m_ordr_item(nolock) as c on b.ordr_id = c.ordr_id " +
            "where b.audt_status = 1 " +
            "and (c.itm_id = 1855) " +
            "and (b.ordr_create_date >= #{start} and b.ordr_create_date < #{end}) " +
            "order by ordr_create_date, REPLICATE(0,20-len(b.smpl_num))+b.smpl_num")
    List<CovidExamResult> selectHstResult(@Param("start") String start, @Param("end") String end);

    @Select("select " +
            "a.ptnt_name as ptntName, a.id_card as idCard, c.itm_str_value as itmStrValue, " +
            "b.ordr_create_date as ordrCreateDate " +
            "from m_ordr_info(nolock) as a " +
            "inner join m_ordr(nolock) as b on a.ordr_info_id = b.ordr_info_id " +
            "inner join m_ordr_item(nolock) as c on b.ordr_id = c.ordr_id " +
            "where b.audt_status = 1 " +
            "and (c.itm_id in ( 1865,1870,1871)) " +
            "and (b.ordr_create_date >= #{start} and b.ordr_create_date < #{end}) " +
            "order by ordr_create_date, REPLICATE(0,20-len(b.smpl_num))+b.smpl_num")
    List<CovidExamResult> selectKtResult(@Param("start") String start, @Param("end") String end);
}