From 14f9208da19b7030a1c65a40897f9f4146a74d44 Mon Sep 17 00:00:00 2001
From: 赵文轩 <1652863494@qq.com>
Date: 星期五, 01 十一月 2024 08:37:14 +0800
Subject: [PATCH] 增加申请业务类型

---
 ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java |   57 ++++++++++++++++++++++++++++++++++++++++++++-------------
 1 files changed, 44 insertions(+), 13 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 1ed2198..5d45f06 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
@@ -30,7 +30,7 @@
     @Select("SELECT * FROM histjv_Ltkj_middle_head")
     public List<LtkjMiddleHead> getMiddleHead();
 
-    @DataSource(value = DataSourceType.SLAVE_LIS)
+    @DataSource(value = DataSourceType.SLAVE_HIS)
     @Select("SELECT * FROM histjv_Ltkj_middle_head where fead_id=#{partId}")
     public LtkjMiddleHead getMiddleHeadByPartId(String partId);
 
@@ -41,20 +41,21 @@
     @Select("SELECT * FROM histjv_LTKJVTJPAT")
     public List<LtkjTjPat> getTjPat();
 
-    @DataSource(value = DataSourceType.SLAVE_PACS)
+    @DataSource(value = DataSourceType.SLAVE_HIS)
     @Select({"<script> select isnull(fcard_no,'涓嶈') xh,fcard_iD pacCode,pat_name pacName,\n" +
             " (case when patsex_id='0' then '鐢�' when patsex_id='1' then '濂�' else '鏈煡' end )+';'+brnl detail,\n" +
-            " pat_id price , mobile pacRemark" +
+            " pat_id price , mobile+tjbz pacRemark" +
             "  from histjv_ltkjvtjpat where 1=1 "+
             " <when test='pacCode!=null'>" +
-            "  AND fcard_no = #{pacCode}" +
+            "  AND fcard_no like '%'+#{pacCode}+'%'" +
             "</when>" +
             " <when test='pacName!=null'>" +
-            "  AND pat_name = #{pacName}" +
+            "  AND pat_name like '%'+#{pacName}+'%' " +
             "</when>" +
             " <when test='pacRemark!=null'>" +
             "  AND mobile = #{pacRemark}" +
             "</when>" +
+            " order by fcard_iD desc"+
             "</script>"})
     public List<Map<String,Object>> newGetTjPat(@Param("pacCode")String pacCode,
                                                 @Param("pacName")String pacName,
@@ -81,6 +82,16 @@
                                    @Param("orderId")String orderId,
                                    @Param("tjnum")String tjnum,
                                    @Param("dockerId")String dockerId);
+
+    @DataSource(value = DataSourceType.MASTER)
+    @Select("call tj_jc_update_detatil(#{cardId,mode=IN},#{orderId,mode=IN},#{tjnum,mode=IN},#{dockerId,mode=IN})")
+    public void updateDetailByTjJcCall(@Param("cardId") String cardId,
+                                   @Param("orderId")String orderId,
+                                   @Param("tjnum")String tjnum,
+                                   @Param("dockerId")String dockerId);
+
+
+
 
     @DataSource(value = DataSourceType.SLAVE_HIS)
     @Select("SELECT * FROM histjv_exam_jcbgd")
@@ -157,23 +168,43 @@
 
 
 
-    @DataSource(value = DataSourceType.SLAVE_PACS)
-    @Select({"<script> select isnull(fcard_no,'涓嶈') xh,fcard_iD pacCode,pat_name pacName,\n" +
-            " (case when patsex_id='0' then '鐢�' when patsex_id='1' then '濂�' else '鏈煡' end )+';'+brnl detail,\n" +
-            " pat_id price , mobile pacRemark" +
-            "  from histjv_ltkjvtjpat where 1=1 "+
+    @DataSource(value = DataSourceType.SLAVE_LIS)
+    @Select({"<script> select  *"+
+            "  from histjv_Ltkj_hyxm where 1=1 "+
             " <when test='pacCode!=null'>" +
-            "  AND fcard_no = #{pacCode}" +
+            "  AND pacCode like '%'+#{pacCode}+'%'" +
             "</when>" +
             " <when test='pacName!=null'>" +
-            "  AND pat_name = #{pacName}" +
+            "  AND pacName like '%'+#{pacName}+'%' " +
             "</when>" +
             " <when test='pacRemark!=null'>" +
-            "  AND mobile = #{pacRemark}" +
+            "  AND pacRemark = #{pacRemark}" +
             "</when>" +
             "</script>"})
     public List<Map<String,Object>> getTjHyBgList(@Param("pacCode")String pacCode,
                                                   @Param("pacName")String pacName,
                                                   @Param("pacRemark")String pacRemark);
 
+    @Select("SELECT * FROM histjv_ltkj_userinfo")
+    @DataSource(value = DataSourceType.SLAVE_HIS)
+    public List<LtkjHisUser> getLtkjHisUser();
+
+
+    @DataSource(value = DataSourceType.SLAVE_PACS)
+    @Select({"<script> select bgid xh,patname pacName ,rptid  pacCode,patage+patagename+'['+sex+']'+patbirth detail,djrq+jcxm pacRemark,lxhd price \n" +
+            "\tfrom V_HIS_PACS_SQ\n" +
+            "\twhere 1=1 " +
+            " <when test='patname!=null'>" +
+            "  AND patname=#{patname}" +
+            "</when>"+
+            " <when test='sex!=null'>" +
+            "  AND  sex=#{sex} "+
+            "</when>"+
+            " <when test='nn!=null'>" +
+             " AND  patage+patagename=#{nn}" +
+             "</when>"+
+            "</script>"})
+    public List<Map<String,Object>> getTjYxjcList(@Param("patname")String patname,
+                                                  @Param("sex")String sex,
+                                                  @Param("nn")String nn);
 }

--
Gitblit v1.8.0