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