From 6f20698550b6b61da9b8a58ae0cc23aeba700ab2 Mon Sep 17 00:00:00 2001
From: zhaowenxuan <chacca165@163.com>
Date: 星期四, 12 六月 2025 17:56:53 +0800
Subject: [PATCH] 调整rediskey问题

---
 ltkj-admin/src/main/resources/sql/陕健医.sql |   63 +++++++++++++++++++++++++++++--
 1 files changed, 58 insertions(+), 5 deletions(-)

diff --git "a/ltkj-admin/src/main/resources/sql/\351\231\225\345\201\245\345\214\273.sql" "b/ltkj-admin/src/main/resources/sql/\351\231\225\345\201\245\345\214\273.sql"
index 0a6732e..762ea92 100644
--- "a/ltkj-admin/src/main/resources/sql/\351\231\225\345\201\245\345\214\273.sql"
+++ "b/ltkj-admin/src/main/resources/sql/\351\231\225\345\201\245\345\214\273.sql"
@@ -1,17 +1,70 @@
 # lis銆乸acs瑙嗗浘
-鍦板潃锛�10.100.100.205
-鏁版嵁搴撳悕锛歭tkjview
-鐢ㄦ埛锛歭tkjview
-瀵嗙爜锛歭tkj@view
-瑙嗗浘
+# 鍦板潃锛�10.100.100.205
+# 鏁版嵁搴撳悕锛歭tkjview
+# 鐢ㄦ埛锛歭tkjview
+# 瀵嗙爜锛歭tkj@view
+# 瑙嗗浘
+/*
 ltkjview.lis_sqd | his_bodycheck
 ltkjview.lis_xm | hjlis_ylsf
 ltkjview.pacs_sqd | v_examhisorderdata
 ltkjview.pacs_xm | v_examitem
+*/
 
 # 杩畨澶栭�佸鎺�
   # 閲戝爢鍩�
 CREATE USER 'ltkjwsdian'@'%' IDENTIFIED BY 'ltkj@ws20250320';
 GRANT INSERT, UPDATE, DELETE,SELECT ON ltkjpeis10_jdczgzyy.ws_import_result_group TO 'ltkjwsdian'@'%';
+GRANT INSERT, UPDATE, DELETE,SELECT ON ltkjpeis10_jdczgzyy.ws_import_pdf_group TO 'ltkjwsdian'@'%';
 GRANT SELECT ON ltkjpeis10_jdczgzyy.ws_export_sample_group TO 'ltkjwsdian'@'%';
+GRANT SELECT ON ltkjpeis10_jdczgzyy.ws_import_pdf_group TO 'ltkjwsdian'@'%';
 FLUSH PRIVILEGES;
+
+# 澶栭�丳DF鎶ュ憡琛�
+CREATE TABLE ws_import_pdf_group(
+    id bigint AUTO_INCREMENT COMMENT '搴忓彿',
+    sample_no varchar(100) NULL COMMENT '鎸囨牱鏈湪LIS鐨勫敮涓�ID鍙枫�傚鏋滄病鏈夛紝灏卞～鏍锋湰鏉＄爜鍙枫��',
+    hos_code varchar(100) NULL COMMENT '璐村湪璇曠涓婄殑鏍锋湰鍖婚櫌鏉＄爜鍙枫��',
+    patient_no varchar(100) NULL COMMENT '鎮ｈ�呭敮涓�ID锛屾垨鑰呭敮涓�灏辫瘖鍗″彿銆佺ぞ淇濆崱鍙�',
+    out_patient_no varchar(100) NULL COMMENT '闂ㄨ瘖鍙�',
+    pdf_file varchar(255) NULL COMMENT '鎶ュ憡鏂囦欢璺緞',
+    report_date datetime NULL COMMENT '鎶ュ憡鏃ユ湡',
+    is_read varchar(30) NULL COMMENT '鏄惁涓嬭浇',
+    create_time datetime NULL COMMENT '鍒涘缓鏃ユ湡',
+    da_barcode varchar(100) NULL COMMENT '杩畨鏉＄爜',
+    pdf_base64 text NULL COMMENT 'pdf鎶ュ憡鍗昩ase64涓�',
+    jpg_base64 text NULL COMMENT 'jpg鎶ュ憡鍗昩ase64涓�'
+) COMMENT '澶栭�丳DF鍥炰紶';
+
+# 娓呭簱
+TRUNCATE TABLE tb_transition;
+TRUNCATE TABLE tj_order;
+TRUNCATE TABLE tj_order_ycxm;
+TRUNCATE TABLE tj_order_detail;
+TRUNCATE TABLE tj_order_remark;
+TRUNCATE TABLE tj_order_detail_rules;
+TRUNCATE TABLE ltkj_hysqd;
+TRUNCATE TABLE ltkj_hybgd;
+TRUNCATE TABLE ltkj_exam_jcsqd;
+TRUNCATE TABLE ltkj_exam_jcbgd;
+TRUNCATE TABLE tj_jcycxm;
+TRUNCATE TABLE tj_sampling;
+TRUNCATE TABLE tj_report;
+TRUNCATE TABLE tj_reservation;
+TRUNCATE TABLE tj_wsxm;
+TRUNCATE TABLE tj_zhxm;
+TRUNCATE TABLE tj_xd_picture;
+TRUNCATE TABLE tj_xdtgmdjg;
+TRUNCATE TABLE tj_report_print;
+TRUNCATE TABLE tj_flowing_water;
+TRUNCATE TABLE tj_flowing_water_his;
+TRUNCATE TABLE tj_dw_grouping;
+TRUNCATE TABLE tj_grouping_pro;
+TRUNCATE TABLE tj_customer;
+TRUNCATE TABLE tj_dw_dept;
+TRUNCATE TABLE tj_customer_black;
+TRUNCATE TABLE tj_ask_historys;
+TRUNCATE TABLE tj_ask_medical_history;
+TRUNCATE TABLE tj_ask_work_log;
+
+

--
Gitblit v1.8.0