From 887e897d5a554c470a77ef63c7eaf26653c87d93 Mon Sep 17 00:00:00 2001
From: tuqin <tuqin@local>
Date: 星期三, 04 十一月 2026 15:19:38 +0800
Subject: [PATCH] docs(sql): 补记「生产仓库」菜单 visible 变更到留档脚本

---
 sql/mysql/bfkj_sale_order_auto_approve_and_menu_visible.sql |   22 ++++++++++++++--------
 1 files changed, 14 insertions(+), 8 deletions(-)

diff --git a/sql/mysql/bfkj_sale_order_auto_approve_and_menu_visible.sql b/sql/mysql/bfkj_sale_order_auto_approve_and_menu_visible.sql
index 4a82e9f..ccabb12 100644
--- a/sql/mysql/bfkj_sale_order_auto_approve_and_menu_visible.sql
+++ b/sql/mysql/bfkj_sale_order_auto_approve_and_menu_visible.sql
@@ -1,5 +1,5 @@
 -- =====================================================================
--- 鍖楁柟绉戞妧锛氶攢鍞鍗曞厤鍗忓悓瀹℃壒 + 鏄剧ず閿�鍞粨搴撹彍鍗�
+-- 鍖楁柟绉戞妧锛氶攢鍞鍗曞厤鍗忓悓瀹℃壒 + 鏄剧ず浠撳偍鐗╂祦鐩稿叧鑿滃崟
 --
 -- 鑳屾櫙锛�
 --   1) 瀹㈡埛瑕佹眰閿�鍞鍗曚笉闇�瑕佸鎵癸紝鎻愪氦鍗冲鏍搁�氳繃銆�
@@ -7,16 +7,21 @@
 --      鍙嫋浜嗕竴涓�屽彂璧蜂汉銆嶈妭鐐广�佹病鏈変换浣曞鎵硅妭鐐癸紝瀵艰嚧娴佺▼瀹炰緥 0.3~1.7 绉�
 --      灏辫嚜鍔ㄧ粨鏉燂紝璁㈠崟琚鏀规垚銆屽凡瀹℃牳銆嶏紝鍓嶇鍗翠粛鎻愮ず銆岃鍒板崗鍚屽姙鍏腑澶勭悊銆嶏紝
 --      鐢ㄦ埛鍘诲崗鍚屽姙鍏篃鎵句笉鍒板緟鍔炪��
---   2) 浠撳偍鐗╂祦 鈫� 閿�鍞粨搴� 涓嬬殑銆屽彂璐ч�氱煡銆嶃�岄攢鍞��璐с�嶈彍鍗曟鍓嶈璁句负闅愯棌
---      锛坴isible=0锛夛紝鍓嶇渚ц竟鏍忕湅涓嶅埌锛屽鑷淬�屼粠閿�鍞鍗曠敓鎴愬彂璐ч�氱煡銆嶇殑闇�姹�
---      鏃犳硶楠岃瘉銆�
+--   2) 浠撳偍鐗╂祦涓嬬殑澶氫釜鑿滃崟姝ゅ墠琚涓洪殣钘忥紙visible=0锛夛紝鍓嶇渚ц竟鏍忕湅涓嶅埌锛�
+--      - 閿�鍞粨搴� 鈫� 鍙戣揣閫氱煡(5867)銆侀攢鍞��璐�(5847)
+--        鈫� 瀵艰嚧銆屼粠閿�鍞鍗曠敓鎴愬彂璐ч�氱煡銆嶇殑闇�姹傛棤娉曢獙璇�
+--      - 鐢熶骇浠撳簱(602478) 鏁翠釜鐩綍
+--        鈫� 瀵艰嚧銆屼骇鍝佸叆搴撱�嶇瓑鍏ュ彛鐪嬩笉鍒帮紝鐢ㄦ埛鏃犳硶缁欑墿鏂欏叆搴擄紝杩涜�屾棤娉曟嫞璐�
 --
 -- 鏈鍙樻洿锛�
 --   A. bpm_process_auto_approve_config 澧炲姞 sale_order_approve = 1
 --      锛堜粎閿�鍞鍗曞厤瀹℃壒锛屽叏灞�鎬诲紑鍏充繚鎸佸叧闂紝涓嶅奖鍝嶈鍋囩瓑鍏朵粬娴佺▼锛�
 --      閰嶅鍚庣 ErpSaleOrderServiceImpl.submitSaleOrder 鐢�
 --      isGlobalAutoApprove() 鏀逛负 isAutoApprove(processDefinitionKey)銆�
---   B. system_menu 鎶娿�屽彂璐ч�氱煡銆�(5867)銆併�岄攢鍞��璐с��(5847) 鐨� visible 缃负 1銆�
+--   B. system_menu 鏀惧紑浠ヤ笅鑿滃崟鐨� visible锛�
+--      - 5867 鍙戣揣閫氱煡
+--      - 5847 閿�鍞��璐�
+--      - 602478 鐢熶骇浠撳簱锛堢洰褰曪紝鍏朵笅鍚� 鐢熶骇棰嗘枡/鐢熶骇閫�鏂�/浜у搧鍏ュ簱锛�
 --
 -- 濡傞渶鎭㈠瀹℃壒锛�
 --   UPDATE bpm_process_auto_approve_config SET auto_approve = b'0'
@@ -37,12 +42,13 @@
     ('sale_order_approve', b'1', '鍖楁柟绉戞妧锛氶攢鍞鍗曚笉璧板崗鍚屽鎵癸紝鎻愪氦鍗冲鏍搁�氳繃',
      '1', NOW(), '1', NOW(), b'0');
 
--- B. 鏄剧ず鍙戣揣閫氱煡銆侀攢鍞��璐ц彍鍗�
-UPDATE system_menu SET visible = 1 WHERE id IN (5867, 5847);
+-- B. 鏀惧紑浠撳偍鐗╂祦鐩稿叧鑿滃崟鏄剧ず
+--    5867 鍙戣揣閫氱煡 / 5847 閿�鍞��璐� / 602478 鐢熶骇浠撳簱锛堝惈浜у搧鍏ュ簱锛�
+UPDATE system_menu SET visible = 1 WHERE id IN (5867, 5847, 602478);
 
 -- 楠岃瘉
 SELECT process_definition_key, CAST(auto_approve AS UNSIGNED) AS 鍏嶅鎵�
 FROM bpm_process_auto_approve_config WHERE deleted = b'0';
 
 SELECT id, name, CAST(visible AS UNSIGNED) AS visible_num
-FROM system_menu WHERE id IN (5847, 5867, 5970);
+FROM system_menu WHERE id IN (5847, 5867, 5970, 602478) ORDER BY id;

--
Gitblit v1.9.3