From d866e43afbe901bfc640776e02f767b9045acbc2 Mon Sep 17 00:00:00 2001 From: 赵文轩 <1652863494@qq.com> Date: 星期三, 12 六月 2024 09:04:56 +0800 Subject: [PATCH] Merge branch 'master' of http://101.42.27.146:5001/r/ltkj_peis --- ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java | 191 ++++++++++++++++++++++++++++++++++++++++++++--- 1 files changed, 178 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 6c255ef..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 @@ -1,16 +1,13 @@ package com.ltkj.hosp.mapper; -import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.ltkj.common.annotation.DataSource; import com.ltkj.common.enums.DataSourceType; -import com.ltkj.hosp.sqlDomain.LtkjMiddleDetail; -import com.ltkj.hosp.sqlDomain.LtkjMiddleHead; -import com.ltkj.hosp.sqlDomain.LtkjTjPat; +import com.ltkj.hosp.sqlDomain.*; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; import org.apache.ibatis.annotations.Select; - import java.util.List; +import java.util.Map; /** * @Company: 瑗垮畨璺嘲绉戞妧鏈夐檺鍏徃 @@ -18,28 +15,196 @@ * @Date: 2023/12/11 14:51 */ @Mapper -@DataSource(value = DataSourceType.SLAVE) public interface TestMapper{ - @Select("SELECT * FROM tjv_Ltkj_middle_detail") + @Select("SELECT * FROM histjv_Ltkj_middle_detail") + @DataSource(value = DataSourceType.SLAVE_HIS) public List<LtkjMiddleDetail> getMiddleDetail(); - @Select("SELECT * FROM tjv_Ltkj_middle_head") + + @Select("SELECT * FROM histjv_Ltkj_middle_detail where fhead_id=#{feadId}") + @DataSource(value = DataSourceType.SLAVE_HIS) + public List<LtkjMiddleDetail> getMiddleDetailByFeadId(String feadId); + + @DataSource(value = DataSourceType.SLAVE_LIS) + @Select("SELECT * FROM histjv_Ltkj_middle_head") public List<LtkjMiddleHead> getMiddleHead(); -// @Select("SELECT * FROM tjv_LTKJVBJITEM") + @DataSource(value = DataSourceType.SLAVE_HIS) + @Select("SELECT * FROM histjv_Ltkj_middle_head where fead_id=#{partId}") + public LtkjMiddleHead getMiddleHeadByPartId(String partId); + +// @Select("SELECT * FROM histjv_LTKJVBJITEM") // public List<LtkjVbjitem> getVbjitem(); - @Select("SELECT * FROM tjv_LTKJVTJPAT") + @DataSource(value = DataSourceType.SLAVE_PACS) + @Select("SELECT * FROM histjv_LTKJVTJPAT") public List<LtkjTjPat> getTjPat(); + @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+tjbz pacRemark" + + " from histjv_ltkjvtjpat where 1=1 "+ + " <when test='pacCode!=null'>" + + " AND fcard_no like '%'+#{pacCode}+'%'" + + "</when>" + + " <when test='pacName!=null'>" + + " 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, + @Param("pacRemark")String pacRemark); - @Select("SELECT * FROM tjv_LTKJVTJPAT where pat_id=#{id}") + + @DataSource(value = DataSourceType.SLAVE_HIS) + @Select("SELECT * FROM histjv_LTKJVTJPAT where Ltrim(Rtrim(fcard_no)) = #{id} or Ltrim(Rtrim(fcard_id))=#{id} ") + public LtkjTjPat getTjPatByIdCard(String id); + + + @DataSource(value = DataSourceType.MASTER) + @Select("call pro_his_tjpart(#{sfzh,mode=IN})") + public void getTjPatByCusId(String cusId); + + @DataSource(value = DataSourceType.MASTER) + @Select("call pro_his_middle(#{sfzh,mode=IN},#{sfzbm,mode=IN})") + public void saveTjProByCusId(@Param("sfzh") String sfzh,@Param("sfzbm")String sfzbm); + + + @DataSource(value = DataSourceType.MASTER) + @Select("call tj_update_detatil(#{cardId,mode=IN},#{orderId,mode=IN},#{tjnum,mode=IN},#{dockerId,mode=IN})") + public void updateDetailByCall(@Param("cardId") String cardId, + @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") + public List<LtkjExamJcbgd> getExamJcbgd(); + + @DataSource(value = DataSourceType.SLAVE_HIS) + @Select("SELECT * FROM histjv_exam_jcsqd") + public List<LtkjExamJcsqd> getExamJcsqd(); + + @DataSource(value = DataSourceType.SLAVE_HIS) + @Select("SELECT * FROM histjv_Ltkj_hybgd") + public List<LtkjHybgd> getHybgd(); + + @DataSource(value = DataSourceType.SLAVE_HIS) + @Select("SELECT * FROM histjv_Ltkj_hysqd") + public List<LtkjHysqd> getHysqd(); + + @DataSource(value = DataSourceType.SLAVE_HIS) + @Select("SELECT * FROM histjv_LTKJVTJPAT where pat_id=#{id}") public LtkjTjPat getTjPatById(String id); - @Select("SELECT * FROM tjv_Ltkj_middle_detail where fdetall_id=#{id}") + @DataSource(value = DataSourceType.SLAVE_HIS) + @Select("SELECT * FROM histjv_Ltkj_middle_detail where fdetall_id=#{id}") public LtkjMiddleDetail getMiddleDetailById(String id); - @Select("SELECT * FROM tjv_Ltkj_middle_head where fead_id=#{id}") + @DataSource(value = DataSourceType.SLAVE_HIS) + @Select("SELECT * FROM histjv_Ltkj_middle_head where fead_id=#{id}") public LtkjMiddleHead getMiddleHeadById(String id); + + @DataSource(value = DataSourceType.SLAVE_HIS) + @Select("SELECT * FROM histjv_exam_jcbgd where tmh=#{id}") + public LtkjExamJcbgd getExamJcbgdById(String id); + + @DataSource(value = DataSourceType.SLAVE_HIS) + @Select("SELECT * FROM histjv_exam_jcsqd where tjh=#{id}") + public LtkjExamJcsqd getExamJcsqdById(String id); + + @DataSource(value = DataSourceType.SLAVE_HIS) + @Select("SELECT * FROM histjv_Ltkj_hybgd where tmh=#{id}") + public LtkjHybgd getHybgdById(String id); + + @DataSource(value = DataSourceType.SLAVE_HIS) + @Select("SELECT * FROM histjv_Ltkj_hysqd where tmh=#{id}") + public LtkjHysqd getHysqdById(String id); + + //浣撴鐧昏鎺ュ彛 璋冪敤鍚� 鏌ヨ鏀惰垂鍗曟嵁鍜岃鎯� + @DataSource(value = DataSourceType.SLAVE_HIS) + @Select("SELECT * FROM histjv_Ltkj_middle_head where pat_bar_code=#{id}") + public List<LtkjMiddleHead> saveMiddleHeadByPatId(String id); + + @DataSource(value = DataSourceType.SLAVE_HIS) + @Select("SELECT * FROM histjv_Ltkj_middle_detail where fead_id=#{id}") + public List<LtkjMiddleDetail> getMiddleDetailByHeadId(String id); + + //鏍规嵁浣撴鍙� 瀵瑰簲鐨� 鍖栭獙椤圭洰 +鏍囨湰 + @DataSource(value = DataSourceType.SLAVE_HIS) + @Select("SELECT * FROM histjv_Ltkj_hysqd where tjh=#{id}") + public List<LtkjHysqd> getHysqdByTmh(String id); + + //鍖栭獙椤圭洰涓嬬殑瀛愰」 浼犱笂闈㈢殑鎺ュ彛鐨則mh + @DataSource(value = DataSourceType.SLAVE_HIS) + @Select("SELECT * FROM histjv_Ltkj_hybgd where tmh=#{id}") + public List<LtkjHybgd> getHybgdByTmh(String id); + + //鏍规嵁浣撴鍙� 瀵瑰簲鐨� 妫�鏌ラ」鐩� + @DataSource(value = DataSourceType.SLAVE_HIS) + @Select("SELECT * FROM histjv_Ltkj_hybgd where tjh=#{id}") + public List<LtkjExamJcsqd> getExamJcsqdTmh(String id); + + //妫�鏌ラ」鐩搴旂殑妫�鏌ョ粨鏋� 浼犱笂闈㈢殑鎺ュ彛鐨勭粨鏋渢mh + @DataSource(value = DataSourceType.SLAVE_HIS) + @Select("SELECT * FROM histjv_exam_jcbgd where tmh=#{id}") + public List<LtkjExamJcbgd> getExamJcbgdByTjh(String id); + + + + @DataSource(value = DataSourceType.SLAVE_LIS) + @Select({"<script> select *"+ + " from histjv_Ltkj_hyxm where 1=1 "+ + " <when test='pacCode!=null'>" + + " AND pacCode like '%'+#{pacCode}+'%'" + + "</when>" + + " <when test='pacName!=null'>" + + " AND pacName like '%'+#{pacName}+'%' " + + "</when>" + + " <when test='pacRemark!=null'>" + + " 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