ltkj_peis.git - gitblit

			@@ -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 '检查项目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_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();
			}