调整rediskey问题

zhaowenxuan

2025-06-12 6f20698550b6b61da9b8a58ae0cc23aeba700ab2

 ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java

@@ -302,6 +302,30 @@



    @DataSource(value = DataSourceType.SLAVE_LIS)
    @Select("SELECT\n" +
            "  a.GH_PATIENTNO '体检号',\n" +
            "  a.SAMPLEID '条码号',\n" +
            "  a.SFXMID '项目ID',\n" +
            "  REPLACE(a.SFXMNAME,'tj_','') '项目名',\n" +
            "  a.SENDDATE '申请时间',\n" +
            "  a.SENDDOCTOR '申请医生',\n" +
            "  a.CHECKDATE '报告时间',\n" +
            "  a.TXM '申请单号',\n" +
            "  a.SENDDOCTOR '申请人姓名',\n" +
            "  '8001' '申请人代码',\n" +
            "  a.AUDITDOCTOR '审核人姓名',\n" +
            "  '已审' '检验报告结果'\n" +
            "  \n" +
            "FROM\n" +
            "  vi_his_patientinfo a\n" +
            "WHERE  a.PATIENTTYPE=3 AND a.GH_PATIENTNO =#{tjNum} AND a.HOSPITALID = #{hosp}")
    List<Map<String, Object>> sysgetCcXZxYyLtkjHysqdByLisVi(@Param("tjNum") String tjNum,@Param("hosp") String hosp);






    @DataSource(value = DataSourceType.SLAVE_LIS)
    @Select("SELECT\n" +
@@ -325,8 +349,30 @@
            "FROM\n" +
            "  vi_his_patientresult a JOIN vi_his_patientinfo b ON b.SAMPLEID=a.SAMPLEID\n" +
            "WHERE  b.PATIENTTYPE=3 AND\n" +
            "  a.SAMPLEID = #{tmh}")
            "  a.SAMPLEID = #{tmh}  ORDER BY a.PRINTORDER")
    List<LtkjHybgd> getCcXZxYyLtkjHybgdByLisVi(String tmh);


    @DataSource(value = DataSourceType.SLAVE_LIS)
    @Select("SELECT\n" +
            "  a.SAMPLEID '条码号',\n" +
            "  a.ITEMCODE '检查项目ID',\n" +
            "  a.ITEMNAME '检查项目',\n" +
            "  a.RESULT '检验结果',\n" +
            "  a.UNIT '结果单位',\n" +
            "  a.RANGEDOWN '范围最小值',\n" +
            "  a.RANGEUP '范围最大值',\n" +
            "  CONCAT(a.RANGEDOWN,'-',a.RANGEUP) '范围值',\n" +
            "  b.CHECKDATE '检验时间',\n" +
            "  b.CHECKER '检验医生',\n" +
            "  b.AUDITDATE '审核时间',\n" +
            "  b.AUDITDOCTOR '审核医生',\n" +
            "  a.JUDGE '异常标志'\n" +
            "FROM\n" +
            "  vi_his_patientresult a JOIN vi_his_patientinfo b ON b.SAMPLEID=a.SAMPLEID\n" +
            "WHERE  b.PATIENTTYPE=3 AND\n" +
            "  a.SAMPLEID = #{tmh}")
    List<Map<String, Object>> sysgetCcXZxYyLtkjHybgdByLisVi(String tmh);


//    @DataSource(value = DataSourceType.SLAVE_WS)
@@ -406,23 +452,43 @@


    @DataSource(value = DataSourceType.SLAVE_PACS)
//    @Select(" SELECT\n" +
    @Select(" SELECT\n" +
            "  trim(a.HIS_ID) 体检号,\n" +
            "  trim(a.HIS_ID) 条码号,\n" +
            "  trim(a.JCMID) 项目代码,\n" +
            "  a.JCMC 项目名称,\n" +
            "  TRIM(a.JCSJ) 报告内容,\n" +
            "  a.SHYS 审核医生代码,\n" +
            "  a.SHYS 审核医生姓名,\n" +
            "  TRIM(a.JCJL) 异常表现,\n" +
            "  a.BGSJ 诊断时间,\n" +
            "  a.SQRJ 申请时间,\n" +
            "  a.JCBW 检查部位\n" +
            "FROM\n" +
            "ris.V_TJ_JCBGXX_NEWTJ a  WHERE a.HIS_ID=#{tjNum} AND a.HOSTPITALID = #{hosp}")
    List<Map<String, Object>> sysgetCcXZxYyPacsLtkjExamJcsqd(@Param("tjNum") String tjNum,@Param("hosp") String hosp);



    @DataSource(value = DataSourceType.SLAVE_PACS)
//    @Select("SELECT\n" +
//            "  trim(a.HIS_ID) tjh,\n" +
//            "  trim(a.HIS_ID) tmh,\n" +
//            "  trim(a.JCMID) xmdm,\n" +
//            "  a.JCMC xmmc,\n" +
//            "  NULL bg_mig,\n" +
//            "  NULL bg_url,\n" +
//            "  TRIM(a.JCSJ) bg_nr,\n" +
//            "  a.SHYS shysdm,\n" +
//            "  a.SHYS shysxm,\n" +
//            "  TRIM(a.JCJL) yxbx,\n" +
//            "  a.BGSJ zdsj,\n" +
//            "  a.JCLX jclx,\n" +
//            "  NULL jczlx,\n" +
//            "  a.BGYS bgys,\n" +
//            "  NULL bgysid,\n" +
//            "  a.SQRJ sqsj,\n" +
//            "  a.JCBW jcbw,\n" +
//            "  a.BGSJ jgsj,\n" +
//            "  REPLACE(a.JCMC,'tj_','') jcxmmc,\n" +
//            "  trim(a.JCMID) jcxmid,\n" +
//            "  a.JCBW bw,\n" +
//            "  TRIM(a.JCJL) jgzt,\n" +
//            "  TRIM(a.JCSJ) jgbx,\n" +
//            "  SYSDATE create_time\n" +
//            "   \n" +
//            "FROM\n" +
//            "  ris.V_TJ_JCBGXX_NEWTJ a  WHERE a.HIS_ID=#{tjNum}")
//            "  ris.V_TJ_JCBGXX_NEWTJ a  WHERE trim(a.HIS_ID)=#{tjNum} AND a.HOSTPITALID = #{hosp}")
    @Select(" SELECT\n" +
            "  trim(a.HIS_ID) tjh,\n" +
            "  trim(a.HIS_ID) tmh,\n" +
@@ -439,7 +505,7 @@
            "  a.JCBW jcbw,\n" +
            "  SYSDATE create_time\n" +
            "FROM\n" +
            "  ris.V_TJ_JCBGXX_NEWTJ a  WHERE a.HIS_ID=#{tjNum} AND a.HOSTPITALID = #{hosp}")
            "  ris.V_TJ_JCBGXX_NEWTJ a  WHERE a.HIS_ID=#{tjNum}  AND a.HOSTPITALID = #{hosp} ")
    List<LtkjExamJcbgd> getCcXZxYyPacsLtkjExamJcbgd(@Param("tjNum") String tjNum,@Param("hosp") String hosp);


@@ -488,13 +554,12 @@
            "  LTEMR.V_TJ_JCBGXX_NEWTJ a  WHERE trim(a.HIS_ID)=#{tjNum}")
    List<LtkjExamJcbgd> getCcXZxYyPacsLtkjExamJcbgd1(String tjNum);

    @DataSource(value = DataSourceType.MASTER)
    @Select("call tj_bingzhongtongji(#{p_start,mode=IN},#{p_end,mode=IN})")
    List<Map<String ,Object>> getBingZhongInfo(@Param("p_start") String start,@Param("p_end") String end);

    @Select("SELECT * FROM v_ws_sqd WHERE tjh = #{tjh}")
    List<LtkjHysqd> getWsHySqdByView(@Param("tjh") String tjh);

    @Select("SELECT * FROM v_ws_bgd WHERE tmh = #{tjh}")
    @Select("SELECT * FROM v_ws_bgd WHERE tmh = #{tmh}")
    List<LtkjHybgd> getWsHyBgdByView(@Param("tmh") String tmh);
}