From dedacd79c93f8ef95e0cb986f5e7fbd27ddbd907 Mon Sep 17 00:00:00 2001
From: zhaowenxuan <chacca165@163.com>
Date: 星期四, 03 七月 2025 09:12:49 +0800
Subject: [PATCH] 2025-07-03
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java | 129 +++++++++++++++++++++++++++++++-----------
1 files changed, 95 insertions(+), 34 deletions(-)
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java
index 5e22811..390cf0f 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java
@@ -217,40 +217,36 @@
@Param("nn")String nn);
@DataSource(value = DataSourceType.SLAVE_PACS)
- @Select({"<script>" +
- "select * from V_JCBGLBHIS where mzh is not null " +
-// "<when test='name != null'>" +
-// "and name = #{name}" +
-// "</when>" +
-// "<when test='mzh != null'>" +
-// "and mzh = #{mzh}" +
- "and (mzh = #{mzh} or name like CONCAT('%', #{name}, '%') )" +
-// "</when>" +
-// "<when test='start != null and end != null'>" +
-// "and examinationDate between #{start} and #{end}" +
-// "</when>" +
- "order by examinationDate" +
+// @Select({"<script>" +
+// "select * from V_JCBGLBHIS where mzh is not null " +
+// "and (mzh = #{mzh} or name = #{name} )" +
+// "order by examinationDate" +
+// "</script>"})
+ @Select({"<script>",
+ "SELECT * FROM V_JCBGLBHIS ",
+ "WHERE name = #{name} ",
+ "<if test='mzh != null and mzh != \"\"'>",
+ " OR mzh = #{mzh} ",
+ "</if>",
+ "ORDER BY examinationDate",
"</script>"})
- List<Map<String ,Object>> getPacsJcList(@Param("name")String name,@Param("mzh")String mzh,@Param("start")String start,@Param("end")String end);
+ List<Map<String, Object>> getPacsJcList(@Param("name") String name, @Param("mzh") String mzh, @Param("start") String start, @Param("end") String end);
+
@DataSource(value = DataSourceType.SLAVE_HIS)
- @Select({"<script>" +
- "select * from V_JYBGHIS where mzh is not null " +
-// "<when test='name != null'>" +
-// "and name = #{name}" +
-// "</when>" +
-// "<when test='mzh != null'>" +
-// "and mzh = #{mzh}" +
- "and (mzh = #{mzh} or name like CONCAT('%', #{name}, '%') )" +
-// "</when>" +
-// "<when test='start != null and end != null'>" +
-// "and examinationDate between #{start} and #{end}" +
-// "</when>" +
- "order by examinationDate" +
+// @Select({"<script>" +
+// "select * from V_JYBGHIS where mzh is not null " +
+// "and (mzh = #{mzh} or name = #{name} )" +
+// "order by examinationDate" +
+// "</script>"})
+ @Select({"<script>",
+ "select * from V_JYBGHIS where name = #{name}",
+ "<if test='mzh != null and mzh != \"\"'>",
+ " OR mzh = #{mzh} ",
+ "</if>",
+ "order by examinationDate",
"</script>"})
List<Map<String ,Object>> getLisJyList(@Param("name")String name,@Param("mzh")String mzh,@Param("start")String start,@Param("end")String end);
-
-
@DataSource(value = DataSourceType.SLAVE_LIS)
@Select("select t.* from vi_his_patientresult t \n" +
@@ -278,8 +274,8 @@
" \n" +
"FROM\n" +
" vi_his_patientinfo a\n" +
- "WHERE a.PATIENTTYPE=3 AND a.GH_PATIENTNO =#{tjNum}")
- List<LtkjHysqd> getCcXZxYyLtkjHysqdByLisVi(String tjNum);
+ "WHERE a.PATIENTTYPE=3 AND a.GH_PATIENTNO =#{tjNum} AND a.HOSPITALID =#{dqyyyqbm}")
+ List<LtkjHysqd> getCcXZxYyLtkjHysqdByLisVi(@Param("tjNum") String tjNum,@Param("dqyyyqbm") String dqyyyqbm);
@@ -307,7 +303,7 @@
"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);
@@ -383,8 +379,8 @@
" SYSDATE create_time\n" +
" \n" +
"FROM\n" +
- " ris.V_TJ_JCBGXX_NEWTJ a WHERE trim(a.HIS_ID)=#{tjNum}")
- List<LtkjExamJcsqd> getCcXZxYyPacsLtkjExamJcsqd(String tjNum);
+ " ris.V_TJ_JCBGXX_NEWTJ a WHERE trim(a.HIS_ID)=#{tjNum} AND a.HOSTPITALID =#{dqyyyqbm} ")
+ List<LtkjExamJcsqd> getCcXZxYyPacsLtkjExamJcsqd(@Param("tjNum") String tjNum,@Param("dqyyyqbm") String dqyyyqbm);
@DataSource(value = DataSourceType.SLAVE_PACS)
@@ -456,4 +452,69 @@
@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_gnkssctp where gnlx=#{gnlx}")
+ List<Map<String ,Object>> getExeUploadImgListByGnLx(@Param("gnlx") String gnlx);
+
+ @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" +
+ " a.SAMPLEID '鏉＄爜鍙�',\n" +
+ " a.ITEMCODE '妫�鏌ラ」鐩甀D',\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_PACS)
+ @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" +
+ "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.MASTER)
+ @Select("call pro_tbDictAfter()")
+ void updTbProHisPrice();
}
--
Gitblit v1.8.0