ltkj_peis.git - gitblit

			@@ -2,11 +2,13 @@

			import java.util.List;
			import java.util.Map;
			import java.util.Set;

			import com.baomidou.mybatisplus.core.mapper.BaseMapper;
			import com.ltkj.hosp.domain.TjOrderRemark;
			import com.ltkj.hosp.vodomain.CsProVo;
			import org.apache.ibatis.annotations.*;
			import org.apache.ibatis.annotations.Param;

			/**
			* 医生备注Mapper接口
			@@ -59,10 +61,11 @@
			"tj_number,\n" +
			"update_by,\n" +
			"update_time,\n" +
			"update_id\n" +
			"update_id,\n" +
			"type\n" +
			")\n" +
			"\n" +
			"SELECT b.pro_id,b.dept_id,SYSDATE(),#{userName},#{userId},#{tjNumber},#{userName},SYSDATE(),#{userId} FROM tj_order_detail a " +
			"SELECT b.pro_id,b.dept_id,SYSDATE(),#{userName},#{userId},#{tjNumber},#{userName},SYSDATE(),#{userId},IF(b.need_report<>'Y',1,0) FROM tj_order_detail a " +
			"LEFT JOIN tj_project b ON a.pro_id=b.pro_id WHERE a.order_id=#{orderId} AND\n" +
			"b.pro_parent_id=0")
			boolean saveTjOrderRemarkByOrderId(@Param("tjNumber")String tjNumber,@Param("userName") String userName,@Param("userId") String userId,@Param("orderId")String orderId);
			@@ -129,10 +132,13 @@
			" LEFT JOIN tj_project pro ON re.pro_id = pro.pro_id\n" +
			" LEFT JOIN sys_user us ON us.user_id = re.doctor_name\n" +
			" WHERE\n" +
			" re.type != 2\n" +
			" AND re.tj_number = #{tjNumber} and re.dept_id !=532 and pro.pro_name not like '%费%'" +
			// " re.type != 2 AND\n" +
			" re.tj_number = #{tjNumber} and pro.need_report='Y'" +
			" <when test='sfzpacs == true'> " +
			" AND dep.org_type = 2"+
			" </when>"+
			" <when test='sfzpacs == false'>"+
			" AND re.dept_id != 532 AND pro.pro_name not like '%费%'"+
			" </when>"+
			"</script>"})
			List<CsProVo> cSWebGetProByTjNumAndOrderId(@Param("tjNumber") String tjNumber,@Param("sfzpacs") boolean sfzpacs );
			@@ -194,4 +200,93 @@

			@Select("SELECT COUNT(*) a FROM tj_order_remark a WHERE a.deleted=0 AND a.tj_number=#{tjNum} AND a.type in(0,3);")
			int panduaniswancheng(String tjNum);

			@Update("\n" +
			"UPDATE tj_order_remark a JOIN tj_order b ON b.tj_number=a.tj_number\n" +
			"SET\n" +
			" a.sfbz=#{ls}\n" +
			"WHERE b.order_id=#{orderId} AND a.jxbz=#{jxbz}")
			void updateTjOrderRemarkSfbzByJxbz(@Param("orderId") String orderId,@Param("jxbz") String jxbz,@Param("ls") String ls);


			@Update("\n" +
			"UPDATE tj_order_remark a JOIN tj_order b ON b.tj_number=a.tj_number\n" +
			"SET\n" +
			" a.sfbz=#{ls}\n" +
			"WHERE b.order_id=#{orderId} AND ISNULL(a.jxbz)")
			void updateTjOrderRemarkSfbzByJxbzisnull(@Param("orderId") String orderId,@Param("ls") String ls);


			@Select({"<script>", "SELECT a.* FROM tj_order_remark a JOIN tj_project b ON b.pro_id=a.pro_id JOIN sys_dept c ON c.dept_id=a.dept_id ",
			" WHERE b.need_report='Y' AND c.org_type !=1 AND !ISNULL(a.sfbz) AND a.type !=2 AND a.tj_number=#{tjNumber} and a.dept_id in ",
			"<foreach collection='split' item='id' open='(' separator=',' close=')'>",
			"#{id}",
			"</foreach>",
			"</script>" })
			List<TjOrderRemark> yiShengJianChaGetPrentPro(@Param("tjNumber") String tjNumber,@Param("split") Set<Integer> split);


			@Select("SELECT a.* FROM tj_order_remark a JOIN tj_project b ON b.pro_id=a.pro_id JOIN sys_dept c ON c.dept_id=a.dept_id\n" +
			"\n" +
			"WHERE b.need_report='Y' AND c.org_type !=1 AND !ISNULL(a.sfbz) AND a.type !=2 AND a.tj_number=#{tjNumber} \n")
			List<TjOrderRemark> yiShengJianChaGetPrentProCJGLY(@Param("tjNumber") String tjNumber);



			@Select({"<script>" +
			"SELECT\n" +
			" pro.pro_id,\n" +
			" dep.dept_name,\n" +
			" dep.dept_id,\n" +
			" pro.pro_name,\n" +
			" re.type,\n" +
			" us.nick_name doctor_name,\n" +
			" us.nick_name bcdoctor_name,\n" +
			" '统收' sffs,\n" +
			" '已收费' is_pay,\n" +
			" re.create_time qdcreate_time,\n" +
			" re.update_time bcupdate_time,\n" +
			" re.update_time zhupdate_time\n" +
			" FROM\n" +
			" tj_order_remark re\n" +
			" LEFT JOIN sys_dept dep ON re.dept_id = dep.dept_id\n" +
			" LEFT JOIN tj_project pro ON re.pro_id = pro.pro_id\n" +
			" LEFT JOIN sys_user us ON us.user_id = re.doctor_name\n" +
			" WHERE\n" +
			" re.tj_number = #{tjNumber} and re.dept_id !=532 and pro.pro_name not like '%费%' " +
			" AND dep.org_type in (1,2 )"+
			"</script>"})
			List<CsProVo> ysjcGetProByTjNumAndOrderId(@Param("tjNumber") String tjNumber);

			@Select({"<script>" +
			"SELECT\n" +
			" pro.pro_id,\n" +
			" dep.dept_name,\n" +
			" dep.dept_id,\n" +
			" pro.pro_name,\n" +
			" re.type,\n" +
			" us.nick_name doctor_name,\n" +
			" us.nick_name bcdoctor_name,\n" +
			" '统收' sffs,\n" +
			" '已收费' is_pay,\n" +
			" re.create_time qdcreate_time,\n" +
			" re.update_time bcupdate_time,\n" +
			" re.update_time zhupdate_time\n" +
			" FROM\n" +
			" tj_order_remark re\n" +
			" LEFT JOIN sys_dept dep ON re.dept_id = dep.dept_id\n" +
			" LEFT JOIN tj_project pro ON re.pro_id = pro.pro_id\n" +
			" LEFT JOIN sys_user us ON us.user_id = re.doctor_name\n" +
			" WHERE\n" +
			// " re.type != 2 AND\n" +
			" re.tj_number = #{tjNumber} and re.dept_id !=532 and pro.pro_name not like '%费%'" +
			" AND dep.org_type = 1"+
			"</script>"})
			List<CsProVo> cSWebGetProByTjNumAndOrderIdJy(String tjNumber);



			List<TjOrderRemark> shoufeiyemianyishoufei(@Param("tjNumber") String tjNumber, @Param("jxbz") String jxbz);

			List<TjOrderRemark> shoufeiyemianweishoufei(@Param("tjNumber") String tjNumber, @Param("jxbz") String jxbz);
			}