-- 阿敏(敏小丫)自热火锅工艺路线初始化 2026-11-05 -- 1. 清理与自热火锅无关的演示工序与工艺路线(软删除,保留历史可追溯) UPDATE mes_pro_route_process SET deleted = b'1', update_time = NOW() WHERE deleted = b'0' AND route_id IN (1, 2, 3, 4, 5, 6, 7); UPDATE mes_pro_route_product SET deleted = b'1', update_time = NOW() WHERE deleted = b'0' AND route_id IN (1, 2, 3, 4, 5, 6, 7); UPDATE mes_pro_route SET deleted = b'1', update_time = NOW() WHERE deleted = b'0' AND id IN (1, 2, 3, 4, 5, 6, 7); UPDATE mes_pro_process_content SET deleted = b'1', update_time = NOW() WHERE deleted = b'0' AND process_id BETWEEN 1 AND 15; UPDATE mes_pro_process_param SET deleted = b'1', update_time = NOW() WHERE deleted = b'0' AND process_id BETWEEN 1 AND 15; UPDATE mes_pro_process SET deleted = b'1', update_time = NOW() WHERE deleted = b'0' AND id BETWEEN 1 AND 15; -- 2. 补充自热火锅生产所需工序 INSERT INTO mes_pro_process (code, name, attention, status, remark) SELECT 'PRO-BRAISE', '卤制', NULL, 0, '肉类、卤味原料卤制' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM mes_pro_process WHERE code = 'PRO-BRAISE'); INSERT INTO mes_pro_process (code, name, attention, status, remark) SELECT 'PRO-STIR', '底料炒制', NULL, 0, '火锅底料、红油炒制' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM mes_pro_process WHERE code = 'PRO-STIR'); INSERT INTO mes_pro_process (code, name, attention, status, remark) SELECT 'PRO-STERILIZE', '灭菌', NULL, 0, '料包封装后灭菌' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM mes_pro_process WHERE code = 'PRO-STERILIZE'); -- 3. 建立牛肉自热火锅工艺路线(对应成品 FG-001) INSERT INTO mes_pro_route (code, name, description, status, remark) SELECT 'RT_20261105001', '牛肉自热火锅工艺路线', '依据 BOM:食材处理→配料称量→卤制→底料炒制→封口包装→灭菌→组装→装箱', 0, '成品 FG-001 牛肉自热火锅' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM mes_pro_route WHERE code = 'RT_20261105001' AND deleted = b'0'); SET @route_id := (SELECT id FROM mes_pro_route WHERE code = 'RT_20261105001' AND deleted = b'0' LIMIT 1); UPDATE mes_pro_route_process SET deleted = b'1', update_time = NOW() WHERE route_id = @route_id AND deleted = b'0'; INSERT INTO mes_pro_route_process (route_id, process_id, sort, link_type, prepare_time, wait_time, key_flag, check_flag, backflush_flag) SELECT @route_id, p.id, x.sort, 3, x.prepare_time, x.wait_time, b'0', b'0', b'0' FROM ( SELECT 'PRO-FOOD' AS process_code, 1 AS sort, 1 AS prepare_time, 1 AS wait_time UNION ALL SELECT 'PRO-SEASON', 2, 1, 1 UNION ALL SELECT 'PRO-BRAISE', 3, 30, 10 UNION ALL SELECT 'PRO-STIR', 4, 30, 10 UNION ALL SELECT 'PRO-SEAL', 5, 5, 5 UNION ALL SELECT 'PRO-STERILIZE', 6, 10, 10 UNION ALL SELECT 'PRO-ASSEMBLY', 7, 5, 5 UNION ALL SELECT 'PRO-PACK', 8, 5, 5 ) x JOIN mes_pro_process p ON p.code = x.process_code AND p.deleted = b'0'; UPDATE mes_pro_route_process rp JOIN mes_pro_route_process np ON np.route_id = rp.route_id AND np.sort = rp.sort + 1 AND np.deleted = b'0' SET rp.next_process_id = np.process_id WHERE rp.route_id = @route_id AND rp.deleted = b'0'; UPDATE mes_pro_route_product SET deleted = b'1', update_time = NOW() WHERE route_id = @route_id AND deleted = b'0'; INSERT INTO mes_pro_route_product (route_id, item_id, quantity) VALUES (@route_id, 1001, 1);