From 8facc6153b5cc55dc76b420d49a932abbd71d06d Mon Sep 17 00:00:00 2001
From: 陈昶聿 <chychen@nbjetron.com>
Date: 星期五, 06 十一月 2026 16:49:33 +0800
Subject: [PATCH] 合并修改com/ruoyi/quartz/task/RyTacom/ruoyi/quartz/task/RyTask.java:3sk.java:3com/ruoyi/quart/task/RyTask.java:3

---
 sql/pat_specific_archive_generate_config_lishui_mch_20261104.sql |   95 +++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 95 insertions(+), 0 deletions(-)

diff --git a/sql/pat_specific_archive_generate_config_lishui_mch_20261104.sql b/sql/pat_specific_archive_generate_config_lishui_mch_20261104.sql
new file mode 100644
index 0000000..3a7fcd8
--- /dev/null
+++ b/sql/pat_specific_archive_generate_config_lishui_mch_20261104.sql
@@ -0,0 +1,95 @@
+-- =============================================================================
+-- 涓芥按甯傚骞间繚鍋ラ櫌 涓撶妗f鐢熸垚閰嶇疆锛堜緷鎹簲涓畬鎴愭帴璇婂叆鍙傦級
+-- orgid : 47226079133110211G1001
+-- date  : 2026-11-04
+-- 璇存槑  :
+--   1. 瀹屾垚鎺ヨ瘖娑堟伅 JZ_MZ_WanChengJZ 鍐欏叆 pat_med_outhosp 鍚庯紝鎸夋湰閰嶇疆鐢熸垚妗f銆�
+--   2. dept_codes / icd10_codes 鍧囦负 JSON 鏁扮粍瀛楃涓层��
+--   3. 鍖归厤鍏崇郴涓� OR锛氶儴闂ㄦ潯浠舵垨璇婃柇鏉′欢浠讳竴鍛戒腑鍗崇敓鎴愩��
+--   4. 鑴氭湰鎸� remark 鍋氬箓绛夛紝閲嶅鎵ц涓嶄細閲嶅鎻掑叆銆�
+-- =============================================================================
+
+-- 1. 濡囩-鏃╁瓡鍏崇埍
+--    鍏ュ弬锛欽iuZhenKSID=010104010601锛堟棭瀛曞叧鐖遍棬璇婏級锛屼富璇婃柇 Icd10=O26.900x206锛堝瓡19鍛級
+INSERT INTO pat_specific_archive_generate_config
+(dept_type, dept_category, archive_type, dept_codes, icd10_codes, remark,
+ orgid, campusid, create_by, create_time, del_flag)
+SELECT '1', '1', '1', '["010104010601"]', '["O26.900x206"]',
+       '涓芥按濡囧辜-鏃╁瓡鍏崇埍锛堝畬鎴愭帴璇婂叆鍙傦級',
+       '47226079133110211G1001', '1', 'system', NOW(), '0'
+FROM DUAL
+WHERE NOT EXISTS (
+    SELECT 1 FROM pat_specific_archive_generate_config
+    WHERE orgid = '47226079133110211G1001'
+      AND remark = '涓芥按濡囧辜-鏃╁瓡鍏崇埍锛堝畬鎴愭帴璇婂叆鍙傦級'
+);
+
+-- 2. 濡囩-鍥寸粷缁忔湡 MHI
+--    鍏ュ弬锛欽iuZhenKSID=010102010207锛堝绉戝唴鍒嗘硨闂ㄨ瘖锛夛紝涓昏瘖鏂� Icd10=N95.900
+INSERT INTO pat_specific_archive_generate_config
+(dept_type, dept_category, archive_type, dept_codes, icd10_codes, remark,
+ orgid, campusid, create_by, create_time, del_flag)
+SELECT '1', '1', '2', '["010102010207"]', '["N95.900"]',
+       '涓芥按濡囧辜-鍥寸粷缁忔湡MHI锛堝畬鎴愭帴璇婂叆鍙傦級',
+       '47226079133110211G1001', '1', 'system', NOW(), '0'
+FROM DUAL
+WHERE NOT EXISTS (
+    SELECT 1 FROM pat_specific_archive_generate_config
+    WHERE orgid = '47226079133110211G1001'
+      AND remark = '涓芥按濡囧辜-鍥寸粷缁忔湡MHI锛堝畬鎴愭帴璇婂叆鍙傦級'
+);
+
+-- 3. 鍎跨-钀ュ吇鎬х柧鐥�
+--    鍏ュ弬锛氫富璇婃柇 Icd10=E46.x00x003锛堣惀鍏讳笉鑹級
+--    璇存槑锛氳鏍蜂緥绉戝涓衡�滃効绔ュ績鐞�/璇█/琛屼负鍙戣偛闂ㄨ瘖鈥濓紝绉戝涓嶅叿澶囧尯鍒嗗害锛屽洜姝ゅ彧鎸夎瘖鏂尮閰嶃��
+INSERT INTO pat_specific_archive_generate_config
+(dept_type, dept_category, archive_type, dept_codes, icd10_codes, remark,
+ orgid, campusid, create_by, create_time, del_flag)
+SELECT '1', '2', '1', NULL, '["E46.x00x003"]',
+       '涓芥按濡囧辜-鍎跨钀ュ吇鎬х柧鐥咃紙瀹屾垚鎺ヨ瘖鍏ュ弬锛�',
+       '47226079133110211G1001', '1', 'system', NOW(), '0'
+FROM DUAL
+WHERE NOT EXISTS (
+    SELECT 1 FROM pat_specific_archive_generate_config
+    WHERE orgid = '47226079133110211G1001'
+      AND remark = '涓芥按濡囧辜-鍎跨钀ュ吇鎬х柧鐥咃紙瀹屾垚鎺ヨ瘖鍏ュ弬锛�'
+);
+
+-- 4. 鍎跨-瀛︿範鍥伴毦
+--    鍏ュ弬锛氫富璇婃柇 Icd10=F81.900锛堝涔犳妧鑳藉彂鑲查殰纰嶏級锛屽瓙璇婃柇鍚� F90.000锛堟椿鍔ㄤ笌娉ㄦ剰澶辫皟锛�
+--    璇存槑锛氳鏍蜂緥绉戝涓衡�滃効绔ヤ繚鍋ラ棬璇娾�濓紝绉戝涓嶅叿澶囧尯鍒嗗害锛屽洜姝ゅ彧鎸夎瘖鏂尮閰嶃��
+INSERT INTO pat_specific_archive_generate_config
+(dept_type, dept_category, archive_type, dept_codes, icd10_codes, remark,
+ orgid, campusid, create_by, create_time, del_flag)
+SELECT '1', '2', '2', NULL, '["F81.900","F90.000"]',
+       '涓芥按濡囧辜-鍎跨瀛︿範鍥伴毦锛堝畬鎴愭帴璇婂叆鍙傦級',
+       '47226079133110211G1001', '1', 'system', NOW(), '0'
+FROM DUAL
+WHERE NOT EXISTS (
+    SELECT 1 FROM pat_specific_archive_generate_config
+    WHERE orgid = '47226079133110211G1001'
+      AND remark = '涓芥按濡囧辜-鍎跨瀛︿範鍥伴毦锛堝畬鎴愭帴璇婂叆鍙傦級'
+);
+
+-- 5. 鍎跨-楂樺嵄鍎夸笓妗�
+--    鍏ュ弬锛欽iuZhenKSID=010104010405锛堟棭浜у効/楂樺嵄鍎块棬璇婏級锛屼富璇婃柇 Icd10=P96.800x904锛堥珮鍗卞効锛�
+INSERT INTO pat_specific_archive_generate_config
+(dept_type, dept_category, archive_type, dept_codes, icd10_codes, remark,
+ orgid, campusid, create_by, create_time, del_flag)
+SELECT '1', '2', '3', '["010104010405"]', '["P96.800x904"]',
+       '涓芥按濡囧辜-鍎跨楂樺嵄鍎夸笓妗堬紙瀹屾垚鎺ヨ瘖鍏ュ弬锛�',
+       '47226079133110211G1001', '1', 'system', NOW(), '0'
+FROM DUAL
+WHERE NOT EXISTS (
+    SELECT 1 FROM pat_specific_archive_generate_config
+    WHERE orgid = '47226079133110211G1001'
+      AND remark = '涓芥按濡囧辜-鍎跨楂樺嵄鍎夸笓妗堬紙瀹屾垚鎺ヨ瘖鍏ュ弬锛�'
+);
+
+-- 鏍搁獙锛氬簲杩斿洖 5 鏉¢厤缃�
+SELECT id, dept_category, archive_type, dept_codes, icd10_codes, remark
+FROM pat_specific_archive_generate_config
+WHERE orgid = '47226079133110211G1001'
+  AND del_flag = '0'
+  AND remark LIKE '涓芥按濡囧辜-%锛堝畬鎴愭帴璇婂叆鍙傦級'
+ORDER BY dept_category, archive_type;

--
Gitblit v1.9.3