~yxh/ecg.git - Gitblit

			@@ -39,6 +39,9 @@
			@Select("SELECT max(seq_num) FROM lihu.queue")
			Integer getMaxSeqNum();

			@Select("SELECT * FROM lihu.queue where pat_id = #{patId}")
			QueueDO getQueueByPatId(@Param("patId")String patId);

			@Select("<script>" +
			"SELECT * FROM lihu.queue " +
			"where room_id = #{roomId} and status in (" +
			@@ -100,12 +103,9 @@
			" <foreach collection='statusList' separator=',' item='status'>" +
			" #{status} " +
			" </foreach> )" +
			" order by seq_num" +
			" order by status desc, seq_num" +
			"</script>")
			List<QueueDO> getDoctorQueueByStatus(@Param("roomId")Long roomId, @Param("bedNo")String bedNo, @Param("statusList")List<Byte> statusList);

			@Update( "update lihu.queue set called = 1 where pat_id = #{patId}" )
			Integer markCalled(@Param("patId")String patId);

			@Update("update lihu.queue set status = #{newStatus} where seq_num = \n" +
			"(select a.min_seq_num from \n" +
			@@ -115,9 +115,10 @@
			@Update("update lihu.queue set status = #{newStatus}, room_id = #{roomId}, room_name = #{roomName}, \n" +
			" bed_no = #{bedNo}, seq_num = #{seqNum} where id = \n" +
			" (select a.id from \n" +
			" (select id from lihu.queue where status = #{curStatus} order by jump_flag desc, book_timeslot, create_time limit 1) a)")
			" (select id from lihu.queue where status = #{curStatus} and book_check_type= #{checkType} order by jump_flag desc, book_timeslot, create_time limit 1) a)")
			Integer preemptPatient(@Param("roomId")Long roomId, @Param("roomName")String roomName, @Param("bedNo")String bedNo,
			@Param("seqNum")Integer seqNum, @Param("curStatus")Byte curStatus, @Param("newStatus")Byte newStatus);
			@Param("seqNum")Integer seqNum, @Param("curStatus")Byte curStatus, @Param("newStatus")Byte newStatus,
			@Param("checkType")Integer checkType);

			@Update("update lihu.queue set status = #{newStatus}, seq_num = #{seqNum}, passed = 1 " +
			" where id = " +