package thyyxxk.webserver.dao.his.yibao;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import thyyxxk.webserver.entity.dictionary.PureCodeName;
import thyyxxk.webserver.entity.medicalinsurance.inpatient.SpecialDiag;

import java.util.List;

@Mapper
public interface DictionaryDao {

    @Select("SELECT rtrim(code) code, rtrim(name) name FROM zd_visit_type")
    List<PureCodeName> getVisitType();

    @Select("SELECT rtrim(code) code,rtrim(name) name FROM zy_zd_responce_type WHERE (isnull(del_flag,0)) = 0")
    List<PureCodeName> getResponceType();

    @Select("SELECT RTRIM(code) AS code,rtrim(name) name FROM a_employee_mi WHERE isnull(del_flag,0)!=1 and py_code LIKE #{content}")
    List<PureCodeName> searchPhysicianByPinyin(String content);

    @Select("SELECT RTRIM(code) AS code,rtrim(name) name FROM a_employee_mi WHERE code LIKE #{content}")
    List<PureCodeName> searchPhysicianByCode(String content);

    @Select("SELECT RTRIM(code) AS code,rtrim(name) name FROM a_employee_mi WHERE name LIKE #{content}")
    List<PureCodeName> searchPhysicianByName(String content);

    @Select("SELECT rtrim(code) code,rtrim(name) name FROM yb_zd_xnh_cmisno WHERE py_code LIKE #{content}")
    List<PureCodeName> searchCmisNoByPinyin(String content);

    @Select("SELECT rtrim(code) code,rtrim(name) name FROM yb_zd_xnh_cmisno WHERE code LIKE #{content}")
    List<PureCodeName> searchCmisNoByCode(String content);

    @Select("SELECT rtrim(code) code,rtrim(name) name FROM yb_zd_xnh_cmisno WHERE name LIKE #{content}")
    List<PureCodeName> searchCmisNoByName(String content);

    @Select("SELECT rtrim(code) code,rtrim(name) name FROM zd_redeem_type_xnh where LEN(RTRIM(code))>2 and py_code LIKE #{content}")
    List<PureCodeName> searchRedeemByPinyin(String content);

    @Select("SELECT rtrim(code) code,rtrim(name) name FROM zd_redeem_type_xnh where LEN(RTRIM(code))>2 and code LIKE #{content}")
    List<PureCodeName> searchRedeemByCode(String content);

    @Select("SELECT rtrim(code) code,rtrim(name) name FROM zd_redeem_type_xnh where LEN(RTRIM(code))>2 and name LIKE #{content}")
    List<PureCodeName> searchRedeemByName(String content);


    @Select("select diagnosis_code as code, diagnosis_name as name from t_si_dl_dss_dns where py_code LIKE #{content}")
    List<PureCodeName> searchDiagnoseByPinyin(String content);

    @Select("select diagnosis_code as code, diagnosis_name as name from t_si_dl_dss_dns where diagnosis_code LIKE #{content}")
    List<PureCodeName> searchDiagnoseByCode(String content);

    @Select("select diagnosis_code as code, diagnosis_name as name from t_si_dl_dss_dns where diagnosis_name LIKE #{content}")
    List<PureCodeName> searchDiagnoseByName(String content);

    @Select("select code,disease_name as name from t_si_dl_slw_spc_chr where disease_name like #{content}")
    List<PureCodeName> selectSlwSpcDiag(String content);

    @Select("select * from ${table}")
    List<SpecialDiag> selectAllSpecialDiags(@Param("table") String table);

}