~yxh/ecg.git - Gitblit

			@@ -91,17 +91,17 @@
			@Update("update lihu.queue set status = #{newStatus}, seq_num = #{seqNum}, passed = 1 " +
			" where id = " +
			" (select a.id from \n" +
			" (select id from lihu.queue where status = #{curStatus} and room_id = #{roomId} and room_name = #{roomName} and bed_no = #{bedNo} order by seq_num limit 1) a)")
			" (select id from lihu.queue where room_id = #{roomId} and bed_no = #{bedNo} and status = #{curStatus} order by seq_num limit 1) a)")
			Integer procPassedReturnPatient(@Param("roomId")Long roomId, @Param("roomName")String roomName, @Param("bedNo")String bedNo,
			@Param("seqNum")Integer seqNum, @Param("curStatus")Byte curStatus, @Param("newStatus")Byte newStatus);

			@Update("update lihu.queue set status = #{newStatus} " +
			" where pat_id = #{patId} and status = #{curStatus} and room_id = #{roomId} and bed_no = #{bedNo}")
			" where room_id = #{roomId} and bed_no = #{bedNo} and status = #{curStatus} and pat_id = #{patId} ")
			Integer passedPatientReturn(@Param("roomId")Long roomId, @Param("bedNo")String bedNo, @Param("patId")String patId,
			@Param("curStatus")Byte curStatus, @Param("newStatus")Byte newStatus);

			@Update("update lihu.queue set jump_flag = #{jumped} " +
			" where pat_id = #{patId} and status = #{curStatus}")
			" where status = #{curStatus} and pat_id = #{patId}")
			Integer queueJump(@Param("patId")String patId, @Param("curStatus")Byte curStatus, @Param("jumped")Byte jumped );
			}

			@@ -52,20 +52,23 @@
			`book_check_type` tinyint DEFAULT NULL COMMENT '预约检查类型',
			`seq_num` int DEFAULT NULL COMMENT '排队序号',
			`status` tinyint NOT NULL COMMENT '10:排队中 20:候诊准备 30:就诊中 40:就诊完成 50:过号 60:过期',
			`passed` tinyint DEFAULT 0 COMMENT '过号标记',
			`expired` tinyint DEFAULT 0 COMMENT '预约过期标记',
			`jump_flag` tinyint DEFAULT 0 COMMENT '插队标记',
			`room_id` BIGINT DEFAULT 0 COMMENT '诊室编号',
			`room_name` varchar(10) DEFAULT "" COMMENT '诊室名称',
			`bed_no` varchar(10) DEFAULT "" COMMENT '诊疗床编号',
			`tenant_id` int DEFAULT 1 COMMENT '租户编号',
			`passed` tinyint DEFAULT '0' COMMENT '过号标记',
			`expired` tinyint DEFAULT '0' COMMENT '预约过期标记',
			`jump_flag` tinyint DEFAULT '0' COMMENT '插队标记',
			`room_id` bigint DEFAULT '0' COMMENT '诊室编号',
			`room_name` varchar(10) DEFAULT '' COMMENT '诊室名称',
			`bed_no` varchar(10) DEFAULT '' COMMENT '诊疗床编号',
			`tenant_id` int DEFAULT '1' COMMENT '租户编号',
			`creator` varchar(10) DEFAULT '' COMMENT '创建者',
			`create_time` datetime NOT NULL COMMENT '创建时间',
			`updater` varchar(10) DEFAULT '' COMMENT '更新者',
			`update_time` datetime NOT NULL COMMENT '更新时间',
			`deleted` bit DEFAULT 0 COMMENT '删除标记',
			PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='排队表';
			`deleted` bit(1) DEFAULT b'0' COMMENT '删除标记',
			PRIMARY KEY (`id`),
			KEY `idx_status` (`status`) USING BTREE,
			KEY `idx_seq_num` (`seq_num`) USING BTREE,
			KEY `idx_room_bed_status` (`room_id`,`bed_no`,`status`) USING BTREE
			) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='排队表';


			-- ----------------------------

	jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/dal/mysql/queue/queueMapper.java	6 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	sql/mysql/jh.sql	23 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史