From 99818446c00a5b435e41debe8918f3ded237ce7b Mon Sep 17 00:00:00 2001 From: liu <2021943741@qq.com> Date: 星期一, 19 十月 2026 13:10:44 +0800 Subject: [PATCH] fix(mes): 补录工作站编码规则 MD_WORKSTATION_CODE --- sql/mysql/mes_auto_code_rule_workstation_fix.sql | 35 +++++++++++++++++++++++++++++++++++ 1 files changed, 35 insertions(+), 0 deletions(-) diff --git a/sql/mysql/mes_auto_code_rule_workstation_fix.sql b/sql/mysql/mes_auto_code_rule_workstation_fix.sql new file mode 100644 index 0000000..f4b3859 --- /dev/null +++ b/sql/mysql/mes_auto_code_rule_workstation_fix.sql @@ -0,0 +1,35 @@ +-- ============================================= +-- 淇锛氬伐浣滅珯璁剧疆 -> 宸ヤ綔绔欑紪鐮� -> 鐢熸垚锛屾姤鈥滅紪鐮佽鍒欎笉瀛樺湪鈥� +-- 鍘熷洜锛歮es_md_auto_code_rule 涓己灏� code = 'MD_WORKSTATION_CODE' 鐨勮鍒欐暟鎹� +-- 璇存槑锛氭湰鑴氭湰鍙噸澶嶆墽琛岋紝涓嶄細鍒犻櫎/瑕嗙洊宸叉湁瑙勫垯 +-- 鐢熸垚鏍煎紡锛歐KS + 6 浣嶆祦姘村彿锛屼緥濡� WKS000001 +-- ============================================= + +-- 1. 宸ヤ綔绔欑紪鐮佽鍒欎富琛� +INSERT INTO mes_md_auto_code_rule + (code, name, description, max_length, padded, padded_char, padded_method, status, remark, creator, updater) +SELECT 'MD_WORKSTATION_CODE', '宸ヤ綔绔欑紪鐮�', '鐢ㄤ簬鐢熸垚宸ヤ綔绔欑紪鐮�', 12, b'0', NULL, NULL, 0, NULL, '1', '1' +FROM DUAL +WHERE NOT EXISTS ( + SELECT 1 FROM mes_md_auto_code_rule WHERE code = 'MD_WORKSTATION_CODE' +); + +-- 2. 鍥哄畾鍓嶇紑 WKS +INSERT INTO mes_md_auto_code_part + (rule_id, sort, type, length, fix_character, serial_start_no, serial_step, cycle_flag, remark, creator, updater) +SELECT r.id, 1, 3, 3, 'WKS', NULL, NULL, NULL, '鍥哄畾鍓嶇紑', '1', '1' +FROM mes_md_auto_code_rule r +WHERE r.code = 'MD_WORKSTATION_CODE' + AND NOT EXISTS ( + SELECT 1 FROM mes_md_auto_code_part p WHERE p.rule_id = r.id AND p.sort = 1 + ); + +-- 3. 6 浣嶆祦姘村彿锛堜粠 1 寮�濮嬶紝姝ラ暱 1锛屼笉寰幆锛� +INSERT INTO mes_md_auto_code_part + (rule_id, sort, type, length, fix_character, serial_start_no, serial_step, cycle_flag, remark, creator, updater) +SELECT r.id, 2, 4, 6, NULL, 1, 1, b'0', '娴佹按鍙�', '1', '1' +FROM mes_md_auto_code_rule r +WHERE r.code = 'MD_WORKSTATION_CODE' + AND NOT EXISTS ( + SELECT 1 FROM mes_md_auto_code_part p WHERE p.rule_id = r.id AND p.sort = 2 + ); -- Gitblit v1.9.3