From 0bbbd746e8c39d91ad7b47a4e36e29ab972dc98c Mon Sep 17 00:00:00 2001
From: liusheng <337615773@qq.com>
Date: 星期二, 20 十月 2026 16:56:54 +0800
Subject: [PATCH] 处理长期任务发送问题
---
ruoyi-inhospvisit/src/main/java/com/ruoyi/inhospvisit/mapper/PatMedInhospMapper.java | 17 +++++++++++++++++
1 files changed, 17 insertions(+), 0 deletions(-)
diff --git a/ruoyi-inhospvisit/src/main/java/com/ruoyi/inhospvisit/mapper/PatMedInhospMapper.java b/ruoyi-inhospvisit/src/main/java/com/ruoyi/inhospvisit/mapper/PatMedInhospMapper.java
index 6403a01..5dd60b8 100644
--- a/ruoyi-inhospvisit/src/main/java/com/ruoyi/inhospvisit/mapper/PatMedInhospMapper.java
+++ b/ruoyi-inhospvisit/src/main/java/com/ruoyi/inhospvisit/mapper/PatMedInhospMapper.java
@@ -64,6 +64,23 @@
public List<PatMedInhosp> selectPatMedInhospListByCondition(PatMedInhospVO patMedInhospVO);
/**
+ * 鏌ヨ鏌愭満鏋勪笅鍏ㄩ儴鍦ㄩ櫌璁板綍鐨�"鍒锋柊鍊欓��"锛堜緵鍦ㄩ櫌淇℃伅鍒锋柊鎸夋偅鑰呴�愭潯鏍稿浣嶇疆锛夈��
+ * <p>
+ * 涓� {@link #selectPatMedInhospList} 鐨勫尯鍒槸鍒绘剰鐨勶細
+ * <ul>
+ * <li>涓� join {@code pat_archive}銆佷笉鍋� GROUP BY 鈥斺�� 鏈敤閫斿彧鐪� {@code pat_med_inhosp} 鑷韩锛�
+ * <li>涓嶅甫 {@code a.idcardno IS NOT NULL} 杩欑被杩囨护锛堥偅浼氳"璇佷欢鍙疯繕娌¤ˉ涓婄殑鏂板叆闄㈡偅鑰�"
+ * 闈欓粯婕忓埛鏂� 鈥斺�� 閲囬泦閾捐矾鏈�鎬曠殑灏辨槸闈欓粯灏戞暟鎹級锛�
+ * <li>鍙� select 鍒锋柊鐢ㄥ緱鍒扮殑鍒楋紙inhospid / serialnum / patname / orgid / campusid /
+ * 绉戝涓夊垪 / 鐥呭尯涓夊垪 / bed_no锛夛紝3000 琛岄噺绾х殑姣忔棩鍏ㄩ噺鎵弿瓒冲杞汇��</li>
+ * </ul>
+ *
+ * @param orgid 鏈烘瀯ID锛堝 20001001锛�
+ * @return 鍦ㄩ櫌锛坽@code inhospstate='0' and del_flag='0'}锛夎褰曢泦鍚堬紝鎸� inhospid 鍗囧簭
+ */
+ public List<PatMedInhosp> selectInhospRefreshCandidates(@Param("orgid") String orgid);
+
+ /**
* 鏂板鎮ｈ�呬綇闄㈣褰�
*
* @param patMedInhosp 鎮ｈ�呬綇闄㈣褰�
--
Gitblit v1.9.3