From 68ff33beff11310e830b0615b5a81f83fad0f683 Mon Sep 17 00:00:00 2001
From: yxh <172933527@qq.com>
Date: 星期日, 08 十一月 2026 23:33:14 +0800
Subject: [PATCH] ai优化
---
jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/dal/mysql/call/CallMapper.java | 14 ++++++++++++++
1 files changed, 14 insertions(+), 0 deletions(-)
diff --git a/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/dal/mysql/call/CallMapper.java b/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/dal/mysql/call/CallMapper.java
index e6cdbdf..a5e3ee7 100644
--- a/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/dal/mysql/call/CallMapper.java
+++ b/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/dal/mysql/call/CallMapper.java
@@ -37,6 +37,20 @@
@Select("select * from lihu.call_patient where pat_id = #{patId} order by id desc limit 1")
CallDO getLatestPatientCall(@Param("patId") String patId);
+ /**
+ * 鍚勬偅鑰�**鏈�杩戜竴娆″彨鍙疯褰�**鐨� id锛坘ey=pat_id锛寁alue=鏈�鏂� id锛夈��
+ *
+ * <p>銆愰噸鍙紙鏈渶姹傦級銆戝ぇ灞�/璇婇棿灞忛潬"鏁版嵁鍙樺寲"瑙﹀彂鎾姤锛岄噸鍙湰韬笉浼氭敼鍙橀槦鍒楁暟鎹紝
+ * 鍥犳涓嬪彂杩欎釜 callId锛氬尰鐢熸瘡鐐逛竴娆￠噸鍙兘浼�**鏂板涓�鏉″彨鍙疯褰�**锛堣 {@code CallService#callAgain}锛夛紝
+ * callId 闅忎箣鍙樺ぇ 鈫� 灞忓箷鎹閲嶆柊鎾姤銆�
+ *
+ * <p>鐢� create_time 闄愬畾杩� 2 澶╋紙call_patient 浼氳姣忔棩娓呯悊锛岃 clearCall锛夛紝
+ * 閬垮厤鍏ㄨ〃 group by锛涗笉渚濊禆 book_date锛堝彲鑳戒负绌猴級銆�
+ */
+ @Select("select pat_id as patId, max(id) as callId from lihu.call_patient " +
+ "where create_time >= date_sub(now(), interval 2 day) group by pat_id")
+ List<Map<String, Object>> selectLatestCallIds();
+
// call_type 0 澶у睆
@Select("select * from lihu.call_patient where called = 0 and call_type = 0 order by id limit 1")
CallDO getNextCall( );
--
Gitblit v1.9.3