shanxia2.0/docs/sql/work_order_unification_phase1.sql

-- ============================================================
-- 工单融合 Phase 1：菜单收口 + 数据修正 + 删除废弃临时表
-- Date: 2026-05-24
--
-- 执行顺序：
--   1) 若库中仍有 biz_temp_* 表 → 先执行 merge_work_order_tables.sql
--   2) 再执行本脚本
--
-- 说明：zkxw.sql 全量基线已无 biz_temp_* 表；本脚本 DROP 用于清理历史库残留。
-- ============================================================

-- 1. 菜单重命名与软删临时工单菜单
UPDATE sys_menu SET menu_name = '质检工单', update_time = NOW()
WHERE id = '70000000000000000000000000000007' AND del_flag = 0;

UPDATE sys_menu SET menu_name = '生产工单', update_time = NOW()
WHERE id = '90000000000000000000000000000011' AND del_flag = 0;

UPDATE sys_menu SET del_flag = 1, update_time = NOW()
WHERE id IN (
  '70000000000000000000000000000012',
  '90000000000000000000000000000110'
) AND del_flag = 0;

-- 2. 临时工单 reception_id 空串修正为 NULL（避免 uk_qc_wo_reception 冲突）
UPDATE biz_qc_work_order
SET reception_id = NULL,
    protocol_sample_id = NULL,
    collection_protocol_id = NULL,
    update_time = NOW()
WHERE work_order_type = 'temporary'
  AND del_flag = 0
  AND (reception_id = '' OR reception_id IS NULL);

UPDATE biz_production_work_order
SET reception_id = NULL,
    protocol_sample_id = NULL,
    collection_protocol_id = NULL,
    update_time = NOW()
WHERE work_order_type = 'temporary'
  AND del_flag = 0
  AND (reception_id = '' OR reception_id IS NULL);

-- 3. 删除已废弃的临时工单表（ORM/代码已不再使用）
--    若表内仍有未迁移数据，请先执行 merge_work_order_tables.sql 再 DROP
DROP TABLE IF EXISTS biz_temp_qc_work_order;
DROP TABLE IF EXISTS biz_temp_production_work_order;