ltkj_peis.git - gitblit

			@@ -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,23 @@
			@Param("orderId")String orderId,
			@Param("tjnum")String tjnum,
			@Param("dockerId")String dockerId);

			@DataSource(value = DataSourceType.MASTER)
			@Select("call tj_update_detatil_by_vi(#{tjnum,mode=IN}")
			public void tjUpdateDetatilByVi(@Param("tjnum")String tjnum);




			@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 +175,113 @@



			@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);

			@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}" +
			"</when>" +
			"<when test='start != null and end != null'>" +
			"and examinationDate between #{start} and #{end}" +
			"</when>" +
			"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);



			@DataSource(value = DataSourceType.SLAVE_LIS)
			@Select("SELECT * FROM vi_his_patientresult ")
			List<Map<String, Object>> getCcXZxYyLisJgSt();


			@DataSource(value = DataSourceType.SLAVE_LIS)
			@Select("SELECT\n" +
			" a.GH_PATIENTNO tjh,\n" +
			" a.SAMPLEID tmh,\n" +
			" NULL bbbh,\n" +
			" NULL bbmc,\n" +
			" a.SFXMID xmid,\n" +
			" a.SFXMNAME xmmc,\n" +
			" a.SENDDATE sqsj,\n" +
			" a.SENDDOCTOR sqys,\n" +
			" a.CHECKDATE jgsj,\n" +
			" a.TXM sqdh,\n" +
			" a.SENDDOCTOR sqrxm,\n" +
			" '8001' sqrdm,\n" +
			" a.AUDITDOCTOR shrxm,\n" +
			" '已审' jybgjg\n" +
			" \n" +
			"FROM\n" +
			" vi_his_patientinfo a\n" +
			"WHERE a.HOSPITALID='chkwyy' AND a.PATIENTTYPE=3 AND a.GH_PATIENTNO =#{tjNum}")
			List<LtkjHysqd> getCcXZxYyLtkjHysqdByLisVi(String tjNum);


			@DataSource(value = DataSourceType.SLAVE_LIS)
			@Select("SELECT\n" +
			" a.SAMPLEID tmh,\n" +
			" a.ITEMCODE jcxmid,\n" +
			" a.ITEMNAME jcxm,\n" +
			" NULL tdh,\n" +
			" a.RESULT jyjg,\n" +
			" a.UNIT jgdw,\n" +
			" a.RANGEDOWN fwzdz,\n" +
			" a.RANGEUP fwzgz,\n" +
			" CONCAT(a.RANGEDOWN,'-',a.RANGEUP) fwz,\n" +
			" b.CHECKDATE jysj,\n" +
			" b.CHECKER jyys,\n" +
			" b.AUDITDATE shsj,\n" +
			" NULL shys,\n" +
			" b.AUDITDOCTOR shysmc,\n" +
			" NULL tpurl,\n" +
			" a.JUDGE ycbz\n" +
			"FROM\n" +
			" vi_his_patientresult a JOIN vi_his_patientinfo b ON b.SAMPLEID=a.SAMPLEID\n" +
			"WHERE b.HOSPITALID='chkwyy' AND b.PATIENTTYPE=3 AND\n" +
			" a.SAMPLEID = #{tmh}")
			List<LtkjHybgd> getCcXZxYyLtkjHybgdByLisVi(String tmh);
			}