-- 新高电力条码配置:仅补当前字典中存在、且尚未配置的业务类型。 -- 模板只使用条码生成器支持的 {BUSINESSCODE} 占位符;统一采用二维码。 -- 重复执行不会覆盖已有有效配置,也不会恢复逻辑删除的旧配置。 INSERT INTO mes_wm_barcode_config (format, biz_type, content_format, content_example, auto_generate_flag, status, remark, creator, updater, deleted) SELECT 1, seed.biz_type, CONCAT(seed.prefix, '-{BUSINESSCODE}'), CONCAT(seed.prefix, '-DEMO001'), b'1', 0, '新高电力业务类型默认条码配置', '1', '1', b'0' FROM ( SELECT 102 AS biz_type, 'WH' AS prefix UNION ALL SELECT 103, 'LOC' UNION ALL SELECT 104, 'AREA' UNION ALL SELECT 105, 'PKG' UNION ALL SELECT 106, 'STOCK' UNION ALL SELECT 107, 'BATCH' UNION ALL SELECT 109, 'SN' UNION ALL SELECT 300, 'CARD' UNION ALL SELECT 301, 'WO' UNION ALL SELECT 302, 'TRANS' UNION ALL SELECT 400, 'EQUIP' UNION ALL SELECT 500, 'TOOL' UNION ALL SELECT 600, 'ITEM' UNION ALL SELECT 601, 'VENDOR' UNION ALL SELECT 602, 'WS' UNION ALL SELECT 603, 'WORKSHOP' UNION ALL SELECT 604, 'USER' UNION ALL SELECT 605, 'CLIENT' ) seed WHERE EXISTS ( SELECT 1 FROM system_dict_data dict WHERE dict.dict_type = 'mes_wm_barcode_biz_type' AND CAST(dict.value AS UNSIGNED) = seed.biz_type AND dict.status = 0 AND dict.deleted = b'0' ) AND NOT EXISTS ( SELECT 1 FROM mes_wm_barcode_config config WHERE config.biz_type = seed.biz_type AND config.deleted = b'0' ); -- 下列旧模板使用未实现的占位符,会被渲染为空串,导致后续条码内容重复。 -- 仅对完全匹配的错误模板修正,保留用户自行维护的其它模板。 UPDATE mes_wm_barcode_config SET content_format = 'WH-{BUSINESSCODE}', content_example = 'WH-WH001' WHERE biz_type = 102 AND content_format = 'SN-{serialNo}' AND deleted = b'0'; UPDATE mes_wm_barcode_config SET content_format = 'BATCH-{BUSINESSCODE}' WHERE biz_type = 107 AND content_format = 'BATCH-{batchCode}' AND deleted = b'0'; UPDATE mes_wm_barcode_config SET content_format = 'SN-{BUSINESSCODE}' WHERE biz_type = 109 AND content_format = 'SN-{serialNo}' AND deleted = b'0'; UPDATE mes_wm_barcode_config SET content_format = 'ITEM-{BUSINESSCODE}' WHERE biz_type = 600 AND content_format = 'ITEM-{code}' AND deleted = b'0';