From 58f2c54f59b536f546812868393a2cf5b427eaa6 Mon Sep 17 00:00:00 2001 From: eight <641137800@qq.com> Date: 星期五, 23 八月 2024 11:24:18 +0800 Subject: [PATCH] update --- jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/service/queue/queueServiceImpl.java | 18 ------------------ jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/dal/mysql/queue/queueMapper.java | 12 ------------ jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/service/queue/queueService.java | 5 ----- 3 files changed, 0 insertions(+), 35 deletions(-) diff --git a/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/dal/mysql/queue/queueMapper.java b/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/dal/mysql/queue/queueMapper.java index 8467e63..8c8df04 100644 --- a/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/dal/mysql/queue/queueMapper.java +++ b/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/dal/mysql/queue/queueMapper.java @@ -66,22 +66,10 @@ "</script>") List<BedQueueStatisticDO> bedQueueStatistic(@Param("roomId")Long roomId, @Param("bedNo")String bedNo); - @Select("<script>" + - "SELECT * FROM lihu.queue where status in (" + - " <foreach collection='statusList' separator=',' item='status'>" + - " #{status} " + - " </foreach> )" + - " order by book_timeslot, create_time " + - "</script>") - List<QueueDO> getOrderedQueue(@Param("statusList")List<Byte> statusList); - @Update("update lihu.queue set status = #{newStatus} where seq_num = \n" + "(select a.min_seq_num from \n" + " (select min(seq_num) as min_seq_num from lihu.queue where room_id = #{roomId} and bed_no = #{bedNo} and status = #{curStatus}) a )") Integer updateQueueStatus(@Param("roomId")Long roomId, @Param("bedNo")String bedNo, @Param("curStatus")Byte curStatus, @Param("newStatus")Byte newStatus); - - @Select("select * from lihu.queue where status = #{status} order by book_timeslot, create_time limit 1") - QueueDO getFirstInQueueByStatus(Byte status); @Select("<script>" + "SELECT * FROM lihu.queue " + diff --git a/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/service/queue/queueService.java b/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/service/queue/queueService.java index ea7c88d..3b1fb2b 100644 --- a/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/service/queue/queueService.java +++ b/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/service/queue/queueService.java @@ -66,11 +66,6 @@ void initQueue(); /** - * 寮�璇婂墠涓�鍒伙紝瀵� 灏辫瘖鍑嗗鐨� 浜哄憳 閲嶆柊鎺掑簭 - */ - void reorderQueue(); - - /** * 鎶婂尰鐢熷�欒瘖鐨勯槦鍒楀婊� */ void hurryup(); diff --git a/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/service/queue/queueServiceImpl.java b/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/service/queue/queueServiceImpl.java index f7bd7f9..1a7489b 100644 --- a/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/service/queue/queueServiceImpl.java +++ b/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/service/queue/queueServiceImpl.java @@ -126,24 +126,6 @@ } /** - * 杩欎釜閫昏緫 涓嶉渶瑕佷簡 - */ - public void reorderQueue() { - // 鏍规嵁棰勭害鍓嶅悗锛屼粠DB 鑾峰彇 闃熷垪涓� 灏辫瘖鍑嗗涓汉鍛� 鍒楄〃 - List<Byte> queueStatusList = new ArrayList<>(); - queueStatusList.add(QueueStatusEnum.READY.getStatus()); - List<QueueDO> queueDOList = queueMapper.getOrderedQueue(queueStatusList); - if (queueDOList.isEmpty()) - return; - - AtomicInteger seqNum = new AtomicInteger(1); - queueDOList.forEach(item -> {item.setSeqNum(seqNum.getAndIncrement());}); - queueMapper.updateBatch(queueDOList); - - curSeqNum.set( seqNum.get() ); - } - - /** * TODO 鏂板紑闃熷垪鏃讹紝闇�瑕佹妸鎺掗槦涓殑浜� 杞埌 灏辫瘖鍑嗗 鐘舵�� * 绛夊埌鍙栦笅涓�涓� 鎺掗槦涓汉鍛� 鐨勯�昏緫瀹屾垚鍚庯紝鍐嶅洖鏉ヤ笉閿� */ -- Gitblit v1.9.3