From a2f793f0fcacdf29e39af83f8cd4b81c6329d494 Mon Sep 17 00:00:00 2001 From: liu <2021943741@qq.com> Date: 星期一, 19 十月 2026 13:10:34 +0800 Subject: [PATCH] fix(mes): 新增生产任务编码规则 PRO_TASK_CODE 初始化脚本 --- sql/mes_pro_task_code_rule_init.sql | 54 ++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 54 insertions(+), 0 deletions(-) diff --git a/sql/mes_pro_task_code_rule_init.sql b/sql/mes_pro_task_code_rule_init.sql new file mode 100644 index 0000000..0d904ba --- /dev/null +++ b/sql/mes_pro_task_code_rule_init.sql @@ -0,0 +1,54 @@ +-- ============================================================ +-- 鐢熶骇浠诲姟缂栫爜瑙勫垯锛圥RO_TASK_CODE锛夊垵濮嬪寲 +-- +-- 鑳屾櫙锛� +-- 鈥滅敓浜ф帓浜р�濋〉闈㈡柊澧炵敓浜т换鍔℃椂锛孧esProTaskServiceImpl 璋冪敤 +-- generateAutoCode(PRO_TASK_CODE)锛岃嫢搴撲腑缂哄皯璇ヨ鍒欙紝 +-- 浼氭姏鍑衡�滅紪鐮佽鍒欎笉瀛樺湪鈥濓紝瀵艰嚧鎺掍骇鎻愪氦澶辫触銆� +-- +-- 璇存槑锛� +-- 1. 鑴氭湰鍙噸澶嶆墽琛岋紙宸插瓨鍦ㄥ垯璺宠繃锛夈�� +-- 2. 鐢熸垚鐨勭紪鐮佹牸寮忥細RW + yyMMdd + 4 浣嶆祦姘村彿锛屼緥濡� RW2610190001锛� +-- 涓庡簱涓棦鏈変换鍔$紪鐮侊紙RW2610150062锛変繚鎸佷竴鑷淬�� +-- 3. 鍒嗘绫诲瀷锛�2=褰撳墠鏃ユ湡锛�3=鍥哄畾瀛楃锛�4=娴佹按鍙凤紱 +-- 寰幆鏂瑰紡锛�3=鎸夊ぉ锛涙祦姘村彿鎸夊ぉ浠� 1 寮�濮嬶紝姝ラ暱 1銆� +-- ============================================================ + +-- 1. 缂栫爜瑙勫垯涓昏〃 +INSERT INTO mes_md_auto_code_rule + (code, name, description, max_length, padded, padded_char, padded_method, status, remark, creator, updater, create_time, update_time, deleted) +SELECT 'PRO_TASK_CODE', '鐢熶骇浠诲姟缂栫爜', '鐢熶骇鎺掍骇浠诲姟鑷姩缂栫爜', 12, b'0', '0', 1, 0, NULL, '1', '1', NOW(), NOW(), b'0' +FROM DUAL +WHERE NOT EXISTS ( + SELECT 1 FROM mes_md_auto_code_rule WHERE code = 'PRO_TASK_CODE' AND deleted = b'0' +); + +-- 2. 瑙勫垯鍒嗘锛氬浐瀹氬墠缂� RW +INSERT INTO mes_md_auto_code_part + (rule_id, sort, type, length, date_format, fix_character, serial_start_no, serial_step, cycle_flag, cycle_method, remark, creator, updater, create_time, update_time, deleted) +SELECT r.id, 1, 3, 2, NULL, 'RW', NULL, NULL, NULL, NULL, '鍥哄畾鍓嶇紑', '1', '1', NOW(), NOW(), b'0' +FROM mes_md_auto_code_rule r +WHERE r.code = 'PRO_TASK_CODE' AND r.deleted = b'0' + AND NOT EXISTS ( + SELECT 1 FROM mes_md_auto_code_part p WHERE p.rule_id = r.id AND p.sort = 1 AND p.deleted = b'0' + ); + +-- 3. 瑙勫垯鍒嗘锛氭棩鏈� yyMMdd +INSERT INTO mes_md_auto_code_part + (rule_id, sort, type, length, date_format, fix_character, serial_start_no, serial_step, cycle_flag, cycle_method, remark, creator, updater, create_time, update_time, deleted) +SELECT r.id, 2, 2, 6, 'yyMMdd', NULL, NULL, NULL, NULL, NULL, '鏃ユ湡', '1', '1', NOW(), NOW(), b'0' +FROM mes_md_auto_code_rule r +WHERE r.code = 'PRO_TASK_CODE' AND r.deleted = b'0' + AND NOT EXISTS ( + SELECT 1 FROM mes_md_auto_code_part p WHERE p.rule_id = r.id AND p.sort = 2 AND p.deleted = b'0' + ); + +-- 4. 瑙勫垯鍒嗘锛氭祦姘村彿锛堟寜澶╁惊鐜紝浠� 1 寮�濮嬶紝姝ラ暱 1锛� +INSERT INTO mes_md_auto_code_part + (rule_id, sort, type, length, date_format, fix_character, serial_start_no, serial_step, cycle_flag, cycle_method, remark, creator, updater, create_time, update_time, deleted) +SELECT r.id, 3, 4, 4, NULL, NULL, 1, 1, b'1', 3, '娴佹按鍙�-鎸夊ぉ寰幆', '1', '1', NOW(), NOW(), b'0' +FROM mes_md_auto_code_rule r +WHERE r.code = 'PRO_TASK_CODE' AND r.deleted = b'0' + AND NOT EXISTS ( + SELECT 1 FROM mes_md_auto_code_part p WHERE p.rule_id = r.id AND p.sort = 3 AND p.deleted = b'0' + ); -- Gitblit v1.9.3