From fce96ef468291fb9a0e6a4d34ab371315e9485d4 Mon Sep 17 00:00:00 2001
From: yxh <172933527@qq.com>
Date: 星期六, 03 十月 2026 00:59:44 +0800
Subject: [PATCH] ai优化

---
 jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/service/callingscreen/CallingScreenServiceImpl.java |  276 +++++++++++++++++++++++++++++++++++++++++++++----------
 1 files changed, 225 insertions(+), 51 deletions(-)

diff --git a/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/service/callingscreen/CallingScreenServiceImpl.java b/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/service/callingscreen/CallingScreenServiceImpl.java
index fa9b52c..0f8a490 100644
--- a/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/service/callingscreen/CallingScreenServiceImpl.java
+++ b/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/service/callingscreen/CallingScreenServiceImpl.java
@@ -1,10 +1,12 @@
 package cn.lihu.jh.module.ecg.service.callingscreen;
 
-import cn.lihu.jh.framework.common.exception.ErrorCode;
-import cn.lihu.jh.framework.common.exception.enums.GlobalErrorCodeConstants;
+import cn.lihu.jh.framework.common.pojo.PageResult;
+import cn.lihu.jh.module.ecg.controller.admin.checktype.vo.CheckTypePageReqVO;
+import cn.lihu.jh.module.ecg.dal.dataobject.checktype.CheckTypeDO;
 import cn.lihu.jh.module.ecg.dal.dataobject.queue.QueueDO;
 import cn.lihu.jh.module.ecg.dal.dataobject.room.RoomDO;
-import cn.lihu.jh.module.ecg.dal.mysql.queue.queueMapper;
+import cn.lihu.jh.module.ecg.dal.mysql.checktype.CheckTypeMapper;
+import cn.lihu.jh.module.ecg.dal.mysql.queue.QueueMapper;
 import cn.lihu.jh.module.ecg.dal.mysql.room.RoomMapper;
 import cn.lihu.jh.module.ecg.enums.QueueStatusEnum;
 import lombok.extern.slf4j.Slf4j;
@@ -14,8 +16,7 @@
 
 import javax.annotation.Resource;
 import java.util.*;
-
-import static cn.lihu.jh.module.ecg.enums.ErrorCodeConstants.PATIENT_NOT_EXISTS;
+import java.util.stream.Collectors;
 
 /**
  * 鎺掗槦 Service 瀹炵幇绫�
@@ -28,12 +29,26 @@
 public class CallingScreenServiceImpl implements CallingScreenService {
 
     @Resource
-    private queueMapper queueMapper;
+    private QueueMapper queueMapper;
 
     @Resource
     private RoomMapper roomMapper;
 
+    /**
+     * 闇�姹�1锛氱敤浜庡洖濉偅鑰呬俊鎭紙鎬у埆/鍑虹敓鏃ユ湡/鐥呭尯/搴婂彿/鐢佃瘽/鏉ユ簮/寮�鍗曞尰甯堢瓑锛夈��
+     * <p>
+     * 涓嬪垪灞忓箷鏌ヨ鏄�**鐩存帴鏌� queueMapper** 鐨勶紝涓嶇粡杩� QueueService 鐨勬煡璇㈡柟娉曪紝
+     * 鍥犳蹇呴』鏄惧紡璋冪敤 fillAppointmentInfo 琛ラ綈锛涘惁鍒欏ぇ灞�/璇婇棿灞忓彧鏈夊鍚嶃��
+     */
+    @Resource
+    private cn.lihu.jh.module.ecg.service.queue.QueueService queueService;
+
+    @Resource
+    private CheckTypeMapper checkTypeMapper;
+
     BigScreenConfig bigScreenConfig;
+
+    Map<Integer, Integer> mapCheckTypeVsDisplayColumn = null;
 
     Integer waitingFrom = 0;
     Integer passedFrom = 0;
@@ -43,69 +58,228 @@
         this.bigScreenConfig = bigScreenConfig;
     }
 
+
     @Override
-    public Map<Integer, List<QueueDO>> callingData() {
-        List<Byte> queueStatusList = new ArrayList<>();
+    public Map<Integer, List<String>> getDisplayColInfo() {
+        CheckTypePageReqVO checkTypePageReqVO = new CheckTypePageReqVO();
+        checkTypePageReqVO.setPageSize(-1);
+        checkTypePageReqVO.setCallingColumn(-1); // 鍒楀彿 -1 鐨勪笉鏄剧ず
+        PageResult<CheckTypeDO> pageResult = checkTypeMapper.selectPageForCallingScreen(checkTypePageReqVO);
+
+        // 鏄剧ず鍒� 鍖呭惈鐨勬鏌ョ被鍨嬪垪琛�
+        Map<Integer, List<CheckTypeDO>> mapDisplayColName = pageResult.getList().stream().
+            collect(
+                Collectors.groupingBy(
+                    CheckTypeDO::getCallingColumn,
+                    Collectors.collectingAndThen(
+                        Collectors.toList(),
+                        list -> list.stream().sorted(Comparator.comparing(CheckTypeDO::getId)).toList()
+                    )
+                )
+            );
+
+        // 妫�鏌ョ被鍨� 瀵瑰簲鐨勬樉绀哄垪
+        mapCheckTypeVsDisplayColumn = pageResult.getList().stream().collect(Collectors.toMap(CheckTypeDO::getValue, item -> item.getCallingColumn()));
+
+        // 鏄剧ず鍒� 瀵瑰簲鐨勬鏌ョ被鍨嬪悕鍒楄〃
+        Map<Integer, List<String>> _map = new HashMap<>();
+        mapDisplayColName.keySet().forEach(key -> {
+            List<String> displayColNameList = mapDisplayColName.get(key).stream().map(item->item.getName()+item.getSeqPrefix()).toList();
+            _map.put(key, displayColNameList);
+        });
+        return _map;
+    }
+
+    /**
+     * 澶у睆鏄剧ず鐨勬偅鑰呬俊鎭�
+     * 涓嶄細鏈夊畨瑁呯浉鍏崇殑鎮h�呬俊鎭�
+     */
+    @Override
+    public Map<Integer, List<QueueDO>> getBigScreenPatient() {
+        Map<Integer, List<QueueDO>> mapDisplayColQueue = new HashMap<>();
+
+        // 銆愪慨澶� NPE銆戞寜**鐪熷疄 calling_column 鍊�**寤洪敭锛岃�屼笉鏄� 0..count-1銆�
+        //
+        // 鍘熷疄鐜帮細
+        //   int displayColCnt = distinct().count();          // 渚嬪 = 5
+        //   for (i = 0; i < displayColCnt; i++) put(i, ...); // 寤洪敭 0,1,2,3,4
+        // 浣嗕笅闈㈠彇鍊肩敤鐨勬槸**鐪熷疄 calling_column**锛堝 0,1,3,4,-1锛夛紝
+        // 鍏朵腑 -1锛堣〃绀�"涓嶅湪澶у睆鏄剧ず"锛夋案杩滀笉浼氳寤洪敭 鈫� get(-1) 杩斿洖 null 鈫� NPE锛�
+        // 瀵艰嚧**鏁翠釜澶у睆鎺ュ彛 500銆佹暣灞忕┖鐧�**銆傚疄娴� check_type 涓湁 7 涓被鍨嬬殑
+        // calling_column = -1锛�700/800/900/1200/1300/1400/1500锛夛紝鍙杩欎簺绫诲瀷鏈夋偅鑰�
+        // 鍦ㄦ帓闃燂紝灏变細瑙﹀彂锛堝ぇ灞� SQL 鏃� check_type 杩囨护锛屽繀鐒惰鎹炲嚭锛夈��
+        //
+        // 淇鍚庯細鍙负**鏈夋晥鐨勬樉绀哄垪**锛�>=0锛夊缓閿紱-1 鐨勭被鍨嬪湪澶у睆涓嶆樉绀猴紝
+        // 鐢变笅鏂� col 鍒ゅ畾璺宠繃锛屼笉鍐嶄骇鐢� NPE銆�
+        //
+        // 銆愬仴澹�с�憁apCheckTypeVsDisplayColumn 浠呭湪 getDisplayColInfo() 涓祴鍊�
+        // 锛堝0鏄庡涓� null锛夈�傛甯稿惎鍔ㄦ祦绋嬬敱 MySpringEventListener 璋冪敤璇ユ柟娉曞垵濮嬪寲锛�
+        // 浣嗚嫢鍚姩闃舵璇ヨ皟鐢ㄦ湭鎴愬姛锛堜緥濡� CheckTypeMapper 鏌ヨ寮傚父锛夛紝
+        // 杩欓噷浼氱洿鎺� NPE 鈫� 澶у睆鍐嶆 500銆傛晠鍏堝垽绌哄苟鎯版�у垵濮嬪寲銆�
+        if (null == mapCheckTypeVsDisplayColumn) {
+            log.warn("[getBigScreenPatient] 鏄剧ず鍒楁槧灏勫皻鏈垵濮嬪寲锛屽皾璇曟儼鎬у垵濮嬪寲");
+            try {
+                getDisplayColInfo();
+            } catch (Exception e) {
+                log.error("[getBigScreenPatient] 鏄剧ず鍒楁槧灏勫垵濮嬪寲澶辫触锛岃繑鍥炵┖缁撴灉", e);
+                return mapDisplayColQueue;   // 杩斿洖绌� map锛屽墠绔睍绀虹┖灞忚�岄潪 500
+            }
+        }
+        mapCheckTypeVsDisplayColumn.values().stream()
+                .filter(col -> col != null && col >= 0)
+                .distinct()
+                .forEach(col -> mapDisplayColQueue.put(col, new ArrayList<>()));
+
+        List<Integer> queueStatusList = new ArrayList<>();
         queueStatusList.add(QueueStatusEnum.READY.getStatus());
         queueStatusList.add(QueueStatusEnum.ONSTAGE.getStatus());
-        List<QueueDO> listReady = queueMapper.getQueueByStatus( queueStatusList );
-
-        queueStatusList.clear();
         queueStatusList.add(QueueStatusEnum.WAITING.getStatus());
         queueStatusList.add(QueueStatusEnum.RECALLED.getStatus());
-        List<QueueDO> listWaiting = queueMapper.getPartialQueueByStatus( queueStatusList, waitingFrom, bigScreenConfig.waitingSize );
-        if (listWaiting.size() < bigScreenConfig.waitingSize && waitingFrom != 0) {
-            List<QueueDO> listWaiting_next = queueMapper.getPartialQueueByStatus( queueStatusList, 0, bigScreenConfig.waitingSize - listWaiting.size());
-            listWaiting.addAll(listWaiting_next);
-        }
-        if (listWaiting.size() < bigScreenConfig.waitingSize) {
-            waitingFrom = 0;
-        } else {
-            waitingFrom = listWaiting.getLast().getId() + 1;
-        }
-
-        queueStatusList.clear();
         queueStatusList.add(QueueStatusEnum.PASSED.getStatus());
-        List<QueueDO> listPassed = queueMapper.getPartialQueueByStatus( queueStatusList, passedFrom, bigScreenConfig.passedSize );
-        if (listPassed.size() < bigScreenConfig.passedSize && passedFrom != 0) {
-            List<QueueDO> listPassed_next = queueMapper.getPartialQueueByStatus( queueStatusList, 0, bigScreenConfig.passedSize - listPassed.size());
-            listPassed.addAll(listPassed_next);
-        }
-        if (listPassed.size() < bigScreenConfig.passedSize) {
-            passedFrom = 0;
-        } else {
-            passedFrom = listPassed.getLast().getId();
-        }
+        queueStatusList.add(QueueStatusEnum.PASSED_WAITING.getStatus());
+        queueStatusList.add(QueueStatusEnum.AFFINITY.getStatus());
+        List<QueueDO> queueDOList = queueMapper.getBigScreenQueueByStatus( queueStatusList );
+        // 闇�姹�1锛氬洖濉偅鑰呬俊鎭紙鎬у埆/鍑虹敓鏃ユ湡/鐥呭尯/搴婂彿/鐢佃瘽/鏉ユ簮/寮�鍗曞尰甯堢瓑锛�
+        queueService.fillAppointmentInfo(queueDOList);
+        queueDOList.forEach(queueDO -> {
+            Integer col = mapCheckTypeVsDisplayColumn.get(queueDO.getBookCheckType());
+            // 鍙岄噸闃插尽锛氭槧灏勭己澶辨垨鍒椾负 -1锛堜笉鏄剧ず锛夋椂璺宠繃锛岄伩鍏� NPE
+            if (col == null || col < 0) {
+                return;
+            }
+            List<QueueDO> columnQueueData = mapDisplayColQueue.get(col);
+            if (columnQueueData == null) {
+                log.warn("[getBigScreenPatient][鏄剧ず鍒楁湭鍒濆鍖栵紝宸茶烦杩嘳 checkType={} callingColumn={}",
+                        queueDO.getBookCheckType(), col);
+                return;
+            }
+            columnQueueData.add( queueDO );
+        });
 
-        log.info( " waitingFrom: {} passedFrom: {} ", waitingFrom, passedFrom);
+        mapDisplayColQueue.values().forEach( _queueDOList -> {
+            //鎶� [浜插拰鐨刔 鎸埌涓婚」鍚庨潰
+            List<QueueDO> affinityWaitingList = new ArrayList<>();
+            ListIterator<QueueDO> iterator = _queueDOList.listIterator();
+            while (iterator.hasNext()) {
+                QueueDO item = iterator.next();
+                if (item.getStatus() == QueueStatusEnum.AFFINITY.getStatus()) {
+                    iterator.remove();
+                    affinityWaitingList.add(item);
+                }
+            }
+            affinityWaitingList.forEach( affinityWaitingItem -> {
+                for (int i = _queueDOList.size()-1; i >= 0; i--) {
+                    if ( affinityWaitingItem.getSeqNum() == _queueDOList.get(i).getSeqNum() ) {
+                        _queueDOList.add(i + 1, affinityWaitingItem);
+                        break;
+                    }
+                }
+            });
+        });
 
-        Map<Integer, List<QueueDO>> map = new HashMap<>();
-        map.put(1, listReady);
-        map.put(2, listWaiting);
-        map.put(3, listPassed);
-        return map;
+        return mapDisplayColQueue;
     }
 
     @Override
-    public List<QueueDO> getRoomQueue(String ip, List<Byte> statusList) {
-        List<RoomDO> roomDOList = roomMapper.queueByIp(ip);
-        Optional<RoomDO> optionalQueueDO = roomDOList.stream().filter(item -> StringUtils.hasLength(item.getIp())).findFirst();
-        if (!optionalQueueDO.isPresent()) {
-            return  new ArrayList<QueueDO>();
+    public List<QueueDO> getRoomCheckRelatedPatient(String ip, Long roomId) {
+        if (null == roomId) {
+            List<RoomDO> roomDOList = roomMapper.queueByIp(ip);
+            Optional<RoomDO> optionalQueueDO = roomDOList.stream().filter(item -> StringUtils.hasLength(item.getIp())).findFirst();
+            if (!optionalQueueDO.isPresent()) {
+                return new ArrayList<QueueDO>();
+            }
+            roomId = optionalQueueDO.get().getRoomId();
         }
 
-        Long roomId = optionalQueueDO.get().getRoomId();
-        List<QueueDO> queueDOList = queueMapper.getRoomQueueByStatus(roomId, statusList);
+        List<Integer> queueStatusList = new ArrayList<>();
+        queueStatusList.add(QueueStatusEnum.RECALLED.getStatus());
+        queueStatusList.add(QueueStatusEnum.READY.getStatus());
+        queueStatusList.add(QueueStatusEnum.ONSTAGE.getStatus());
+        queueStatusList.add(QueueStatusEnum.PASSED.getStatus());
+        // 銆愰渶姹�8 淇銆戣ˉ涓娿�屽凡杩囧彿-鎺掗槦銆�(3)銆�
+        //
+        // 闇�姹傚師鏂囷細銆岃繃鍙锋偅鑰呭簲鍑虹幇鍦�**澶у睆鍜岃瘖闂村睆**銆嶏紝涓斻�岃繃鍙蜂笌绛夊緟涓帓鍦ㄤ竴璧枫�佹寜搴忓彿鍗囧簭銆嶃��
+        // 澶у睆鐨� getBigScreenPatient 宸插惈 PASSED_WAITING(3)锛屼絾鏈柟娉曪紙璇婇棿灞忥級**婕忎簡**锛�
+        // 瀵艰嚧 status=3 鐨勬偅鑰呭湪澶у睆鍙銆佸湪璇婇棿灞忎笉鍙銆�
+        //
+        // 瀹炴祴澶嶇幇锛堟瀯閫� seq 1~5 鍏� 5 浣嶆偅鑰咃紝鍚� status=3 涓� 5锛夛細
+        //   澶у睆杩斿洖 5 浣� 鉁� 锛涜瘖闂村睆杩斿洖 4 浣嶏紙缂� status=3 閭d綅锛夝煍�
+        //
+        // 鎺掑簭鏃犻渶棰濆澶勭悊锛歡etRoomQueueByStatus 鐨� order by 宸叉妸 status in (3,5) 褰掍负鍚屼竴缁�
+        // 锛堟帓鍦ㄥ氨璇婁腑涔嬪悗銆佸�欒瘖涔嬪墠锛夛紝缁勫唴鍐嶆寜 seq_num銆乥ook_timeslot 鍗囧簭 鈥斺�� 姝e悎闇�姹傘��
+        queueStatusList.add(QueueStatusEnum.PASSED_WAITING.getStatus());
+        queueStatusList.add(QueueStatusEnum.AFFINITY.getStatus());
+        List<QueueDO> queueDOList = queueMapper.getRoomQueueByStatus(roomId, queueStatusList);
+        // 闇�姹�1锛氬洖濉偅鑰呬俊鎭紙璇婇棿灞�-妫�鏌ラ槦鍒楋級
+        queueService.fillAppointmentInfo(queueDOList);
+
+        //鎶� [浜插拰鐨刔 鎸埌涓婚」鍚庨潰
+        List<QueueDO> affinityWaitingList = new ArrayList<>();
+        ListIterator<QueueDO> iterator = queueDOList.listIterator();
+        while (iterator.hasNext()) {
+            QueueDO item = iterator.next();
+            if (item.getStatus() == QueueStatusEnum.AFFINITY.getStatus()) {
+                iterator.remove();
+                affinityWaitingList.add(item);
+            }
+        }
+        affinityWaitingList.forEach( affinityWaitingItem -> {
+            for (int i = queueDOList.size()-1; i >= 0; i--) {
+                if ( affinityWaitingItem.getSeqNum() == queueDOList.get(i).getSeqNum() ) {
+                    queueDOList.add(i + 1, affinityWaitingItem);
+                    break;
+                }
+            }
+        });
+
         return queueDOList;
     }
 
+    /**
+     * 璇婇棿灞� 瀹夎鎮h�呭垪琛�
+     */
     @Override
-    public ErrorCode markCalled(String patientId) {
-        Integer rowNum = queueMapper.markCalled(patientId);
-        if (rowNum == 1)
-            return GlobalErrorCodeConstants.SUCCESS;
+    public List<QueueDO> getRoomInstallRelatedPatient(String ip, Long roomId) {
+        if (null == roomId) {
+            List<RoomDO> roomDOList = roomMapper.queueByIp(ip);
+            Optional<RoomDO> optionalQueueDO = roomDOList.stream().filter(item -> StringUtils.hasLength(item.getIp())).findFirst();
+            if (!optionalQueueDO.isPresent()) {
+                return new ArrayList<QueueDO>();
+            }
 
-        return PATIENT_NOT_EXISTS;
+            roomId = optionalQueueDO.get().getRoomId();
+        }
+        
+        List<Integer> queueStatusList = new ArrayList<>();
+        queueStatusList.add(QueueStatusEnum.RECEIVED.getStatus());
+        queueStatusList.add(QueueStatusEnum.PASSED_INSTALL.getStatus());
+        queueStatusList.add(QueueStatusEnum.AFFINITY_INSTALL.getStatus());
+        queueStatusList.add(QueueStatusEnum.INSTALLING.getStatus());
+        queueStatusList.add(QueueStatusEnum.RECALLED_INSTALL.getStatus());
+        List<QueueDO> queueDOList = queueMapper.getRoomQueueByStatus(roomId, queueStatusList);
+        // 闇�姹�1锛氬洖濉偅鑰呬俊鎭紙璇婇棿灞�-瑁呮満闃熷垪锛�
+        queueService.fillAppointmentInfo(queueDOList);
+
+        //鎶� [浜插拰鐨刔 鎸埌涓婚」鍚庨潰
+        List<QueueDO> affinityReceivedList = new ArrayList<>();
+        ListIterator<QueueDO> iterator = queueDOList.listIterator();
+        while (iterator.hasNext()) {
+            QueueDO item = iterator.next();
+            if (item.getStatus() == QueueStatusEnum.AFFINITY_INSTALL.getStatus()) {
+                iterator.remove();
+                affinityReceivedList.add(item);
+            }
+        }
+        affinityReceivedList.forEach( affinityReceivedItem -> {
+            for (int i = queueDOList.size()-1; i >= 0; i--) {
+                if ( affinityReceivedItem.getSeqNum() == queueDOList.get(i).getSeqNum() ) {
+                    queueDOList.add(i + 1, affinityReceivedItem);
+                    break;
+                }
+            }
+        });
+
+        return queueDOList;
     }
 
 }

--
Gitblit v1.9.3