From 2b31fa203f3435a582be51f45899d99164c9917a Mon Sep 17 00:00:00 2001
From: zhuguifei <312353457@qq.com>
Date: 星期四, 09 四月 2026 13:34:59 +0800
Subject: [PATCH] Merge branch 'master' of http://lanpucloud.cn:1111/r/SC/gfzl

---
 RuoYi-Vue-Plus/开发日志.md |  120 +++++------------------------------------------------------
 1 files changed, 11 insertions(+), 109 deletions(-)

diff --git "a/RuoYi-Vue-Plus/\345\274\200\345\217\221\346\227\245\345\277\227.md" "b/RuoYi-Vue-Plus/\345\274\200\345\217\221\346\227\245\345\277\227.md"
index 1de3019..6f8a86f 100644
--- "a/RuoYi-Vue-Plus/\345\274\200\345\217\221\346\227\245\345\277\227.md"
+++ "b/RuoYi-Vue-Plus/\345\274\200\345\217\221\346\227\245\345\277\227.md"
@@ -6,114 +6,16 @@
 
 #### 20260226
 - 1.鏂板鎴愬搧妫� 妫�楠屾壒娆� 绠＄悊椤甸潰
-- 2.寤鸿〃sql
+- 2.鏁版嵁搴撹〃锛� qm_batch
 ```
--- 鍒涘缓妫�楠屾壒娆¤〃
-CREATE TABLE QM_BATCH (
-    ID VARCHAR(50) NOT NULL,
-    BATCH_CODE VARCHAR(50),
-    BATCH_NAME VARCHAR(50),
-    TYP VARCHAR(20),
-    EQP_CODE VARCHAR(50),
-    MAT_CODE VARCHAR(50),
-    JUDGE_CODE VARCHAR(50),
-    BATCH_DATE DATE,
-    ISFLAG VARCHAR(2),
-    ENABLED VARCHAR(2),
-    TOTAL_NUM NUMERIC(22),
-    RESULTS VARCHAR(50),
-    APPROVER VARCHAR(50),
-    AUDITOR VARCHAR(50),
-    CREATER VARCHAR(50),
-    TAB_DATE DATE,
-    VER_NAME VARCHAR(50),
-    VER_CODE VARCHAR(50),
-    ARCH_DATE VARCHAR(50),
-    FLAG VARCHAR(20),
-    TO_MES_DATE DATE,
-    FROM_MES_DATE DATE,
-    DELETED NUMERIC(22),
-    BATCH_DES VARCHAR(200),
-    CATEGORY VARCHAR(2),
-    MAKENO VARCHAR(60),
-    SHIFTEQPNO VARCHAR(32),
-    BOXNO VARCHAR(60),
-    PID VARCHAR(50),
-    REVIEWER VARCHAR(50),
-    RVCOUNT NUMERIC(22),
-    STATE VARCHAR(2),
-    REVIEW_TIME DATE,
-    AUDIT_TIME DATE,
-    SPEC VARCHAR(50),
-    APPROVE_TIME DATE,
-    UNIT VARCHAR(50),
-    ARRIVAL_TIME DATE,
-    STORAGE_PLACE VARCHAR(50),
-    CHECKER VARCHAR(20),
-    RECEIVE_TIME DATE,
-    INSP_TIME DATE,
-    STORER VARCHAR(50),
-    ISVERIFY VARCHAR(10),
-    ISCHK VARCHAR(10),
-    BAK1 VARCHAR(100),
-    BAK2 VARCHAR(100),
-    CONSTRAINT PK_QM_BATCH PRIMARY KEY (ID)
-);
-
--- 娣诲姞娉ㄩ噴锛堝彲閫夛級
-COMMENT ON TABLE QM_BATCH IS '妫�楠屾壒娆¤〃';
-
-COMMENT ON COLUMN QM_BATCH.ID IS '缂栫爜';
-COMMENT ON COLUMN QM_BATCH.BATCH_CODE IS '鎵规浠ｇ爜';
-COMMENT ON COLUMN QM_BATCH.BATCH_NAME IS '鎵规鍚嶇О';
-COMMENT ON COLUMN QM_BATCH.TYP IS 'A-鍒朵笣 B-鎴愬瀷 C-鍗峰寘 D-灏佺 E-绯栭鏂�';
-COMMENT ON COLUMN QM_BATCH.EQP_CODE IS '鏈哄彴浠ｇ爜';
-COMMENT ON COLUMN QM_BATCH.MAT_CODE IS '鐗屽彿';
-COMMENT ON COLUMN QM_BATCH.JUDGE_CODE IS '鍒ゅ畾渚濇嵁浠ｇ爜';
-COMMENT ON COLUMN QM_BATCH.BATCH_DATE IS '鎵规鐢熸垚鏃ユ湡';
-COMMENT ON COLUMN QM_BATCH.ISFLAG IS '浣跨敤鏍囧織';
-COMMENT ON COLUMN QM_BATCH.ENABLED IS '鍚敤鏍囧織';
-COMMENT ON COLUMN QM_BATCH.TOTAL_NUM IS '鍒拌揣鎬婚噺';
-COMMENT ON COLUMN QM_BATCH.RESULTS IS '缁煎悎鍒ゅ畾';
-COMMENT ON COLUMN QM_BATCH.APPROVER IS '鎵瑰噯浜�';
-COMMENT ON COLUMN QM_BATCH.AUDITOR IS '瀹℃牳浜�';
-COMMENT ON COLUMN QM_BATCH.CREATER IS '鍒涘缓浜�';
-COMMENT ON COLUMN QM_BATCH.TAB_DATE IS '鍒惰〃鏃ユ湡';
-COMMENT ON COLUMN QM_BATCH.VER_NAME IS '鐗堟湰鍚嶇О';
-COMMENT ON COLUMN QM_BATCH.VER_CODE IS '鐗堟湰缂栧彿';
-COMMENT ON COLUMN QM_BATCH.ARCH_DATE IS '淇濆瓨鏈�';
-COMMENT ON COLUMN QM_BATCH.FLAG IS '0-鏈笂浼爉es,1-宸蹭笂浼�, 3-浠嶮ES涓嬭浇';
-COMMENT ON COLUMN QM_BATCH.TO_MES_DATE IS '涓婁紶MES鏃堕棿';
-COMMENT ON COLUMN QM_BATCH.FROM_MES_DATE IS '浠嶮ES鏃堕棿涓嬭浇';
-COMMENT ON COLUMN QM_BATCH.DELETED IS '鍒犻櫎鏍囧織';
-COMMENT ON COLUMN QM_BATCH.BATCH_DES IS '鎵规鎻忚堪';
-COMMENT ON COLUMN QM_BATCH.CATEGORY IS '绫诲埆 0锛氭垚鍝� 1锛氳緟鏉�';
-COMMENT ON COLUMN QM_BATCH.MAKENO IS '鍗峰埗宸ュ彿';
-COMMENT ON COLUMN QM_BATCH.SHIFTEQPNO IS '鐝鏈哄彿';
-COMMENT ON COLUMN QM_BATCH.BOXNO IS '瑁呯鍙�';
-COMMENT ON COLUMN QM_BATCH.PID IS '鐖舵壒娆″彿';
-COMMENT ON COLUMN QM_BATCH.REVIEWER IS '澶嶆牳浜�';
-COMMENT ON COLUMN QM_BATCH.RVCOUNT IS '澶嶆娆℃暟';
-COMMENT ON COLUMN QM_BATCH.STATE IS '鎵规鐘舵��';
-COMMENT ON COLUMN QM_BATCH.REVIEW_TIME IS '澶嶆牳鏃ユ湡';
-COMMENT ON COLUMN QM_BATCH.AUDIT_TIME IS '瀹℃牳鏃ユ湡';
-COMMENT ON COLUMN QM_BATCH.SPEC IS '瑙勬牸';
-COMMENT ON COLUMN QM_BATCH.APPROVE_TIME IS '鎵瑰噯鏃堕棿';
-COMMENT ON COLUMN QM_BATCH.UNIT IS '鍒拌揣鍗曚綅';
-COMMENT ON COLUMN QM_BATCH.ARRIVAL_TIME IS '鍒拌揣鏃ユ湡';
-COMMENT ON COLUMN QM_BATCH.STORAGE_PLACE IS '瀛樻斁鍦扮偣';
-COMMENT ON COLUMN QM_BATCH.CHECKER IS '妫�楠屽憳';
-COMMENT ON COLUMN QM_BATCH.RECEIVE_TIME IS '鎺ュ崟鏃ユ湡';
-COMMENT ON COLUMN QM_BATCH.INSP_TIME IS '鎶ユ鏃ユ湡';
-COMMENT ON COLUMN QM_BATCH.STORER IS '浠撳簱淇濈鍛�';
-COMMENT ON COLUMN QM_BATCH.ISVERIFY IS '鏄惁楠岃瘉';
-COMMENT ON COLUMN QM_BATCH.ISCHK IS '鏄惁妫�楠�';
-COMMENT ON COLUMN QM_BATCH.BAK1 IS '澶囩敤1';
-COMMENT ON COLUMN QM_BATCH.BAK2 IS '澶囩敤2';
-
--- 鍒涘缓绱㈠紩锛堟牴鎹父鐢ㄦ煡璇㈡潯浠跺垱寤猴級
-CREATE INDEX IDX_QM_BATCH_BATCH_CODE ON QM_BATCH(BATCH_CODE);
-CREATE INDEX IDX_QM_BATCH_BATCH_DATE ON QM_BATCH(BATCH_DATE);
-CREATE INDEX IDX_QM_BATCH_TYP ON QM_BATCH(TYP);
-CREATE INDEX IDX_QM_BATCH_MAT_CODE ON QM_BATCH(MAT_CODE);
 ```
+
+#### 20260302
+- 寰呭姙浜嬮」
+- [ ] 鐩墠鍌ㄤ笣鏌滀俊鎭俊鎭病鏈変粠瑙嗗浘涓幏鍙栵紝浣跨敤oracle_store_silk琛ㄦā鎷�->浣跨敤鍒朵笣杞﹂棿鐪熷疄瑙嗗浘鏁版嵁婧�
+- [ ] 鍒朵笣闆嗘帶锛圤racle 瑙嗗浘锛変腑娌℃湁鍑烘枡缁撴潫鏃堕棿锛屼互鍙婂疄鏃堕噸閲忔槸濡備綍璁＄畻
+- [ ] 鍠備笣鏈哄搴斿叧绯伙紝鐩墠redis鏁版嵁搴撳懡鍚嶈鑼�3.4鏈�4鍙锋満锛屽疄闄呰溅闂存病鏈�4鍙锋満锛岄渶鍒扮幇鍦烘牎楠屽搴斿叧绯�
+- [x] 鍠備笣鏈哄搴斿叧绯伙紝fs寮�澶村偍瀛樼殑鐪熷疄鍊兼槸浠�涔堬紝鐩墠娴嬭瘯鏁版嵁浣跨敤鐨勬槸 fs11 -> 鍌ㄤ笣鏌滃彿  
+- [ ] 纭1鍙板杺涓濇満瀵瑰簲鐨�2鍙板偍涓濇煖鏄緷娆′緵涓濊繕鏄彲浠ュ苟琛屼緵涓�(<span style="color: red;">***骞惰渚涗笣鏃犳硶鍑嗙‘璁＄畻浜ч噺***</span>)
+- [ ] 纭 鍠備笣鏈哄搴斿叧绯讳腑(key->pipe01	value->1#鏈虹粍瀵瑰簲鐨勫杺涓濇満鍜岀閬�)value涓嶄細閲嶅  (<span style="color: red;">***閲嶅灏嗗鑷磋绠楅�昏緫鍑虹幇閿欒***</span>)
+

--
Gitblit v1.9.3