AiDOPWarehouse/server/Admin.NET.Web.Entry/UpdateScripts/1.0.150.sql

-- 1.0.150.sql
-- S8-ORDER-CHAIN-BODY-PRODUCTION-ORDER-LEVEL-SEED-FIX-1
-- 本体生产「工序明细 / 损失因素 / 操作员表现」三表 DDL + 幂等 DELETE + 221 行 INSERT SEED。
--
-- DDL：3 个 CREATE TABLE IF NOT EXISTS（与 CodeFirst 实体一致；CodeFirst 已建表时 no-op）。
-- DML：3 个幂等 DELETE（仅本批 SEED，保护 IMPORT/AGG）+ 3 个 INSERT（baseline 13 行 + order-level 208 行 = 221 行）。
-- 与 procurement 1.0.148.sql 同模式；启动时由 Admin.NET UpdateScripts 模块自动按版本号执行。
--
-- 字段精度与实体一致：
--   process.pi_days / actual_days  DECIMAL(6,3)
--   process.achievement_rate       DECIMAL(5,4)
--   loss_factor.ratio_pct          DECIMAL(5,2)
--   loss_factor.loss_hours         DECIMAL(8,2)
--   operator.avg_hours             DECIMAL(6,2)
--
-- order_id IS NULL 表示 baseline 行（scenario_code=BASELINE_PPT）；
-- order_id IS NOT NULL 表示订单级行（scenario_code=ORDER_LEVEL）。

CREATE TABLE IF NOT EXISTS ado_s8_order_flow_manufacturing_process (
    id BIGINT NOT NULL,
    order_id BIGINT NULL,
    order_code VARCHAR(64) NULL,
    process_code VARCHAR(16) NOT NULL,
    process_name VARCHAR(32) NOT NULL,
    pi_days DECIMAL(6,3) NOT NULL DEFAULT 0,
    actual_days DECIMAL(6,3) NOT NULL DEFAULT 0,
    cycle_status VARCHAR(16) NOT NULL DEFAULT 'green',
    plan_qty INT NULL,
    achievement_rate DECIMAL(5,4) NULL,
    achievement_status VARCHAR(16) NOT NULL DEFAULT '',
    sort_no INT NOT NULL DEFAULT 0,
    scenario_code VARCHAR(16) NOT NULL DEFAULT 'BASELINE_PPT',
    data_source VARCHAR(16) NOT NULL DEFAULT 'SEED',
    tenant_id BIGINT NOT NULL DEFAULT 1,
    factory_id BIGINT NOT NULL DEFAULT 1,
    created_at DATETIME NOT NULL,
    updated_at DATETIME NULL,
    is_deleted TINYINT(1) NOT NULL DEFAULT 0,
    PRIMARY KEY (id),
    KEY idx_order_flow_mfg_process_baseline (tenant_id, factory_id, process_code),
    KEY idx_order_flow_mfg_process_order    (tenant_id, factory_id, order_code),
    KEY idx_order_flow_mfg_process_scenario (tenant_id, factory_id, scenario_code, is_deleted)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
  COMMENT='S8 订单执行链路本体生产工序明细';

CREATE TABLE IF NOT EXISTS ado_s8_order_flow_manufacturing_loss_factor (
    id BIGINT NOT NULL,
    order_id BIGINT NULL,
    order_code VARCHAR(64) NULL,
    factor_code VARCHAR(32) NOT NULL,
    factor_name VARCHAR(32) NOT NULL,
    count_value INT NULL,
    ratio_pct DECIMAL(5,2) NULL,
    loss_hours DECIMAL(8,2) NULL,
    sort_no INT NOT NULL DEFAULT 0,
    scenario_code VARCHAR(16) NOT NULL DEFAULT 'BASELINE_PPT',
    data_source VARCHAR(16) NOT NULL DEFAULT 'SEED',
    tenant_id BIGINT NOT NULL DEFAULT 1,
    factory_id BIGINT NOT NULL DEFAULT 1,
    created_at DATETIME NOT NULL,
    updated_at DATETIME NULL,
    is_deleted TINYINT(1) NOT NULL DEFAULT 0,
    PRIMARY KEY (id),
    KEY idx_order_flow_mfg_loss_baseline (tenant_id, factory_id, factor_code),
    KEY idx_order_flow_mfg_loss_order    (tenant_id, factory_id, order_code),
    KEY idx_order_flow_mfg_loss_scenario (tenant_id, factory_id, scenario_code, is_deleted)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
  COMMENT='S8 订单执行链路本体生产损失因素';

CREATE TABLE IF NOT EXISTS ado_s8_order_flow_manufacturing_operator (
    id BIGINT NOT NULL,
    order_id BIGINT NULL,
    order_code VARCHAR(64) NULL,
    operator_code VARCHAR(32) NOT NULL,
    operator_name VARCHAR(64) NOT NULL,
    avg_hours DECIMAL(6,2) NOT NULL DEFAULT 0,
    status VARCHAR(16) NOT NULL DEFAULT 'green',
    sort_no INT NOT NULL DEFAULT 0,
    scenario_code VARCHAR(16) NOT NULL DEFAULT 'BASELINE_PPT',
    data_source VARCHAR(16) NOT NULL DEFAULT 'SEED',
    tenant_id BIGINT NOT NULL DEFAULT 1,
    factory_id BIGINT NOT NULL DEFAULT 1,
    created_at DATETIME NOT NULL,
    updated_at DATETIME NULL,
    is_deleted TINYINT(1) NOT NULL DEFAULT 0,
    PRIMARY KEY (id),
    KEY idx_order_flow_mfg_operator_baseline (tenant_id, factory_id, operator_code),
    KEY idx_order_flow_mfg_operator_order    (tenant_id, factory_id, order_code),
    KEY idx_order_flow_mfg_operator_scenario (tenant_id, factory_id, scenario_code, is_deleted)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
  COMMENT='S8 订单执行链路本体生产操作员表现';

-- ============================================================
-- 幂等 DELETE：仅本批 SEED（BASELINE_PPT + ORDER_LEVEL）；不触 IMPORT/AGG。
-- 重复 source 此 SQL 不会重复堆叠。
-- ============================================================

DELETE FROM ado_s8_order_flow_manufacturing_process
WHERE tenant_id = 1 AND factory_id = 1 AND is_deleted = 0
  AND data_source = 'SEED'
  AND scenario_code IN ('BASELINE_PPT', 'ORDER_LEVEL');

DELETE FROM ado_s8_order_flow_manufacturing_loss_factor
WHERE tenant_id = 1 AND factory_id = 1 AND is_deleted = 0
  AND data_source = 'SEED'
  AND scenario_code IN ('BASELINE_PPT', 'ORDER_LEVEL');

DELETE FROM ado_s8_order_flow_manufacturing_operator
WHERE tenant_id = 1 AND factory_id = 1 AND is_deleted = 0
  AND data_source = 'SEED'
  AND scenario_code IN ('BASELINE_PPT', 'ORDER_LEVEL');

-- ============================================================
-- INSERT：baseline (5+5+3) + order-level (16 单 × (5+5+3) = 208) = 221 行
-- 数据由 /tmp/gen_s8_body_production_seed_sql.py 生成（严格复刻
-- S8OrderFlowManufacturingSeedData.cs 算法 + S8-...-FIX-1R TOTAL.rate 锚定）。
--
-- baseline 行：order_id=NULL，scenario_code='BASELINE_PPT'，与 MANUFACTURING_DETAIL_FIXTURE 逐字段一致。
-- order-level 行：order_id=OrderIdBase+spec.Idx，scenario_code='ORDER_LEVEL'；
--   每非 pending 单按 ratio=A/6.8 缩放 process/loss/operator；
--   process TOTAL.rate=0.9000/yellow 锚定 fixture（不再 plan_qty 加权）；
--   守恒：Σ(P10..P40 actual) = TOTAL.actual = stage.actual_days；
--   pending 单 016/017/018/019 不生成 order-level 行。
-- ============================================================

-- ─── ado_s8_order_flow_manufacturing_process: 85 行 ───
INSERT INTO ado_s8_order_flow_manufacturing_process
  (id, order_id, order_code, process_code, process_name, pi_days, actual_days, cycle_status, plan_qty, achievement_rate, achievement_status, sort_no, scenario_code, data_source, tenant_id, factory_id, created_at, updated_at, is_deleted)
VALUES
  (1329909160001, NULL, NULL, 'P10', '10工序', 1.000, 2.400, 'red', 45, 0.5500, 'red', 1, 'BASELINE_PPT', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909160002, NULL, NULL, 'P20', '20工序', 1.000, 0.800, 'green', 3, 0.9700, 'yellow', 2, 'BASELINE_PPT', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909160003, NULL, NULL, 'P30', '30工序', 2.500, 3.000, 'yellow', 15, 0.8500, 'green', 3, 'BASELINE_PPT', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909160004, NULL, NULL, 'P40', '40工序', 1.500, 0.600, 'green', 2, 0.9800, 'red', 4, 'BASELINE_PPT', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909160005, NULL, NULL, 'TOTAL', '合计', 6.000, 6.800, 'yellow', NULL, 0.9000, 'yellow', 5, 'BASELINE_PPT', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170001, 1329909100001, 'SO-2026-001', 'P10', '10工序', 1.000, 1.765, 'red', 33, 0.5500, 'red', 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170002, 1329909100001, 'SO-2026-001', 'P20', '20工序', 1.000, 0.588, 'green', 2, 0.9700, 'green', 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170003, 1329909100001, 'SO-2026-001', 'P30', '30工序', 2.500, 2.206, 'green', 11, 0.8500, 'yellow', 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170004, 1329909100001, 'SO-2026-001', 'P40', '40工序', 1.500, 0.441, 'green', 1, 0.9800, 'green', 4, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170005, 1329909100001, 'SO-2026-001', 'TOTAL', '合计', 6.000, 5.000, 'green', NULL, 0.9000, 'yellow', 5, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170006, 1329909100002, 'SO-2026-002', 'P10', '10工序', 1.000, 2.118, 'red', 40, 0.5500, 'red', 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170007, 1329909100002, 'SO-2026-002', 'P20', '20工序', 1.000, 0.706, 'green', 3, 0.9700, 'green', 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170008, 1329909100002, 'SO-2026-002', 'P30', '30工序', 2.500, 2.647, 'yellow', 13, 0.8500, 'yellow', 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170009, 1329909100002, 'SO-2026-002', 'P40', '40工序', 1.500, 0.529, 'green', 2, 0.9800, 'green', 4, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170010, 1329909100002, 'SO-2026-002', 'TOTAL', '合计', 6.000, 6.000, 'green', NULL, 0.9000, 'yellow', 5, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170011, 1329909100003, 'SO-2026-003', 'P10', '10工序', 1.000, 2.824, 'red', 53, 0.5500, 'red', 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170012, 1329909100003, 'SO-2026-003', 'P20', '20工序', 1.000, 0.941, 'green', 4, 0.9700, 'green', 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170013, 1329909100003, 'SO-2026-003', 'P30', '30工序', 2.500, 3.529, 'red', 18, 0.8500, 'yellow', 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170014, 1329909100003, 'SO-2026-003', 'P40', '40工序', 1.500, 0.706, 'green', 2, 0.9800, 'green', 4, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170015, 1329909100003, 'SO-2026-003', 'TOTAL', '合计', 6.000, 8.000, 'red', NULL, 0.9000, 'yellow', 5, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170016, 1329909100004, 'SO-2026-004', 'P10', '10工序', 1.000, 2.118, 'red', 40, 0.5500, 'red', 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170017, 1329909100004, 'SO-2026-004', 'P20', '20工序', 1.000, 0.706, 'green', 3, 0.9700, 'green', 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170018, 1329909100004, 'SO-2026-004', 'P30', '30工序', 2.500, 2.647, 'yellow', 13, 0.8500, 'yellow', 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170019, 1329909100004, 'SO-2026-004', 'P40', '40工序', 1.500, 0.529, 'green', 2, 0.9800, 'green', 4, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170020, 1329909100004, 'SO-2026-004', 'TOTAL', '合计', 6.000, 6.000, 'green', NULL, 0.9000, 'yellow', 5, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170021, 1329909100005, 'SO-2026-005', 'P10', '10工序', 1.000, 2.118, 'red', 40, 0.5500, 'red', 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170022, 1329909100005, 'SO-2026-005', 'P20', '20工序', 1.000, 0.706, 'green', 3, 0.9700, 'green', 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170023, 1329909100005, 'SO-2026-005', 'P30', '30工序', 2.500, 2.647, 'yellow', 13, 0.8500, 'yellow', 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170024, 1329909100005, 'SO-2026-005', 'P40', '40工序', 1.500, 0.529, 'green', 2, 0.9800, 'green', 4, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170025, 1329909100005, 'SO-2026-005', 'TOTAL', '合计', 6.000, 6.000, 'green', NULL, 0.9000, 'yellow', 5, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170026, 1329909100006, 'SO-2026-006', 'P10', '10工序', 1.000, 2.118, 'red', 40, 0.5500, 'red', 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170027, 1329909100006, 'SO-2026-006', 'P20', '20工序', 1.000, 0.706, 'green', 3, 0.9700, 'green', 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170028, 1329909100006, 'SO-2026-006', 'P30', '30工序', 2.500, 2.647, 'yellow', 13, 0.8500, 'yellow', 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170029, 1329909100006, 'SO-2026-006', 'P40', '40工序', 1.500, 0.529, 'green', 2, 0.9800, 'green', 4, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170030, 1329909100006, 'SO-2026-006', 'TOTAL', '合计', 6.000, 6.000, 'green', NULL, 0.9000, 'yellow', 5, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170031, 1329909100007, 'SO-2026-007', 'P10', '10工序', 1.000, 2.824, 'red', 53, 0.5500, 'red', 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170032, 1329909100007, 'SO-2026-007', 'P20', '20工序', 1.000, 0.941, 'green', 4, 0.9700, 'green', 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170033, 1329909100007, 'SO-2026-007', 'P30', '30工序', 2.500, 3.529, 'red', 18, 0.8500, 'yellow', 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170034, 1329909100007, 'SO-2026-007', 'P40', '40工序', 1.500, 0.706, 'green', 2, 0.9800, 'green', 4, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170035, 1329909100007, 'SO-2026-007', 'TOTAL', '合计', 6.000, 8.000, 'red', NULL, 0.9000, 'yellow', 5, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170036, 1329909100008, 'SO-2026-008', 'P10', '10工序', 1.000, 2.824, 'red', 53, 0.5500, 'red', 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170037, 1329909100008, 'SO-2026-008', 'P20', '20工序', 1.000, 0.941, 'green', 4, 0.9700, 'green', 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170038, 1329909100008, 'SO-2026-008', 'P30', '30工序', 2.500, 3.529, 'red', 18, 0.8500, 'yellow', 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170039, 1329909100008, 'SO-2026-008', 'P40', '40工序', 1.500, 0.706, 'green', 2, 0.9800, 'green', 4, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170040, 1329909100008, 'SO-2026-008', 'TOTAL', '合计', 6.000, 8.000, 'red', NULL, 0.9000, 'yellow', 5, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170041, 1329909100009, 'SO-2026-009', 'P10', '10工序', 1.000, 2.118, 'red', 40, 0.5500, 'red', 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170042, 1329909100009, 'SO-2026-009', 'P20', '20工序', 1.000, 0.706, 'green', 3, 0.9700, 'green', 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170043, 1329909100009, 'SO-2026-009', 'P30', '30工序', 2.500, 2.647, 'yellow', 13, 0.8500, 'yellow', 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170044, 1329909100009, 'SO-2026-009', 'P40', '40工序', 1.500, 0.529, 'green', 2, 0.9800, 'green', 4, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170045, 1329909100009, 'SO-2026-009', 'TOTAL', '合计', 6.000, 6.000, 'green', NULL, 0.9000, 'yellow', 5, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170046, 1329909100010, 'SO-2026-010', 'P10', '10工序', 1.000, 2.118, 'red', 40, 0.5500, 'red', 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170047, 1329909100010, 'SO-2026-010', 'P20', '20工序', 1.000, 0.706, 'green', 3, 0.9700, 'green', 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170048, 1329909100010, 'SO-2026-010', 'P30', '30工序', 2.500, 2.647, 'yellow', 13, 0.8500, 'yellow', 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170049, 1329909100010, 'SO-2026-010', 'P40', '40工序', 1.500, 0.529, 'green', 2, 0.9800, 'green', 4, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170050, 1329909100010, 'SO-2026-010', 'TOTAL', '合计', 6.000, 6.000, 'green', NULL, 0.9000, 'yellow', 5, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170051, 1329909100011, 'SO-2026-011', 'P10', '10工序', 1.000, 2.118, 'red', 40, 0.5500, 'red', 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170052, 1329909100011, 'SO-2026-011', 'P20', '20工序', 1.000, 0.706, 'green', 3, 0.9700, 'green', 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170053, 1329909100011, 'SO-2026-011', 'P30', '30工序', 2.500, 2.647, 'yellow', 13, 0.8500, 'yellow', 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170054, 1329909100011, 'SO-2026-011', 'P40', '40工序', 1.500, 0.529, 'green', 2, 0.9800, 'green', 4, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170055, 1329909100011, 'SO-2026-011', 'TOTAL', '合计', 6.000, 6.000, 'green', NULL, 0.9000, 'yellow', 5, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170056, 1329909100012, 'SO-2026-012', 'P10', '10工序', 1.000, 2.118, 'red', 40, 0.5500, 'red', 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170057, 1329909100012, 'SO-2026-012', 'P20', '20工序', 1.000, 0.706, 'green', 3, 0.9700, 'green', 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170058, 1329909100012, 'SO-2026-012', 'P30', '30工序', 2.500, 2.647, 'yellow', 13, 0.8500, 'yellow', 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170059, 1329909100012, 'SO-2026-012', 'P40', '40工序', 1.500, 0.529, 'green', 2, 0.9800, 'green', 4, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170060, 1329909100012, 'SO-2026-012', 'TOTAL', '合计', 6.000, 6.000, 'green', NULL, 0.9000, 'yellow', 5, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170061, 1329909100013, 'SO-2026-013', 'P10', '10工序', 1.000, 2.824, 'red', 53, 0.5500, 'red', 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170062, 1329909100013, 'SO-2026-013', 'P20', '20工序', 1.000, 0.941, 'green', 4, 0.9700, 'green', 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170063, 1329909100013, 'SO-2026-013', 'P30', '30工序', 2.500, 3.529, 'red', 18, 0.8500, 'yellow', 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170064, 1329909100013, 'SO-2026-013', 'P40', '40工序', 1.500, 0.706, 'green', 2, 0.9800, 'green', 4, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170065, 1329909100013, 'SO-2026-013', 'TOTAL', '合计', 6.000, 8.000, 'red', NULL, 0.9000, 'yellow', 5, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170066, 1329909100014, 'SO-2026-014', 'P10', '10工序', 1.000, 2.118, 'red', 40, 0.5500, 'red', 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170067, 1329909100014, 'SO-2026-014', 'P20', '20工序', 1.000, 0.706, 'green', 3, 0.9700, 'green', 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170068, 1329909100014, 'SO-2026-014', 'P30', '30工序', 2.500, 2.647, 'yellow', 13, 0.8500, 'yellow', 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170069, 1329909100014, 'SO-2026-014', 'P40', '40工序', 1.500, 0.529, 'green', 2, 0.9800, 'green', 4, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170070, 1329909100014, 'SO-2026-014', 'TOTAL', '合计', 6.000, 6.000, 'green', NULL, 0.9000, 'yellow', 5, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170071, 1329909100015, 'SO-2026-015', 'P10', '10工序', 1.000, 2.118, 'red', 40, 0.5500, 'red', 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170072, 1329909100015, 'SO-2026-015', 'P20', '20工序', 1.000, 0.706, 'green', 3, 0.9700, 'green', 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170073, 1329909100015, 'SO-2026-015', 'P30', '30工序', 2.500, 2.647, 'yellow', 13, 0.8500, 'yellow', 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170074, 1329909100015, 'SO-2026-015', 'P40', '40工序', 1.500, 0.529, 'green', 2, 0.9800, 'green', 4, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170075, 1329909100015, 'SO-2026-015', 'TOTAL', '合计', 6.000, 6.000, 'green', NULL, 0.9000, 'yellow', 5, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170076, 1329909100020, 'SO-2026-020', 'P10', '10工序', 1.000, 2.118, 'red', 40, 0.5500, 'red', 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170077, 1329909100020, 'SO-2026-020', 'P20', '20工序', 1.000, 0.706, 'green', 3, 0.9700, 'green', 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170078, 1329909100020, 'SO-2026-020', 'P30', '30工序', 2.500, 2.647, 'yellow', 13, 0.8500, 'yellow', 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170079, 1329909100020, 'SO-2026-020', 'P40', '40工序', 1.500, 0.529, 'green', 2, 0.9800, 'green', 4, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909170080, 1329909100020, 'SO-2026-020', 'TOTAL', '合计', 6.000, 6.000, 'green', NULL, 0.9000, 'yellow', 5, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0);

-- ─── ado_s8_order_flow_manufacturing_loss_factor: 85 行 ───
INSERT INTO ado_s8_order_flow_manufacturing_loss_factor
  (id, order_id, order_code, factor_code, factor_name, count_value, ratio_pct, loss_hours, sort_no, scenario_code, data_source, tenant_id, factory_id, created_at, updated_at, is_deleted)
VALUES
  (1329909180001, NULL, NULL, 'MATERIAL', '材料影响', 9, 30.00, 9.00, 1, 'BASELINE_PPT', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909180002, NULL, NULL, 'EQUIPMENT', '设备影响', 6, 20.00, 4.50, 2, 'BASELINE_PPT', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909180003, NULL, NULL, 'QUALITY', '质量影响', 3, 10.00, 3.40, 3, 'BASELINE_PPT', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909180004, NULL, NULL, 'EFFICIENCY', '作业效率损失', 12, 40.00, 9.25, 4, 'BASELINE_PPT', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909180005, NULL, NULL, 'SUBTOTAL', '损失小计', 30, 100.00, 7.50, 5, 'BASELINE_PPT', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190001, 1329909100001, 'SO-2026-001', 'MATERIAL', '材料影响', 7, 30.00, 6.62, 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190002, 1329909100001, 'SO-2026-001', 'EQUIPMENT', '设备影响', 4, 20.00, 3.31, 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190003, 1329909100001, 'SO-2026-001', 'QUALITY', '质量影响', 2, 10.00, 2.50, 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190004, 1329909100001, 'SO-2026-001', 'EFFICIENCY', '作业效率损失', 9, 40.00, 6.80, 4, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190005, 1329909100001, 'SO-2026-001', 'SUBTOTAL', '损失小计', 22, 100.00, 5.51, 5, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190006, 1329909100002, 'SO-2026-002', 'MATERIAL', '材料影响', 8, 30.00, 7.94, 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190007, 1329909100002, 'SO-2026-002', 'EQUIPMENT', '设备影响', 5, 20.00, 3.97, 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190008, 1329909100002, 'SO-2026-002', 'QUALITY', '质量影响', 3, 10.00, 3.00, 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190009, 1329909100002, 'SO-2026-002', 'EFFICIENCY', '作业效率损失', 11, 40.00, 8.16, 4, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190010, 1329909100002, 'SO-2026-002', 'SUBTOTAL', '损失小计', 26, 100.00, 6.62, 5, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190011, 1329909100003, 'SO-2026-003', 'MATERIAL', '材料影响', 11, 30.00, 10.59, 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190012, 1329909100003, 'SO-2026-003', 'EQUIPMENT', '设备影响', 7, 20.00, 5.29, 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190013, 1329909100003, 'SO-2026-003', 'QUALITY', '质量影响', 4, 10.00, 4.00, 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190014, 1329909100003, 'SO-2026-003', 'EFFICIENCY', '作业效率损失', 14, 40.00, 10.88, 4, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190015, 1329909100003, 'SO-2026-003', 'SUBTOTAL', '损失小计', 35, 100.00, 8.82, 5, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190016, 1329909100004, 'SO-2026-004', 'MATERIAL', '材料影响', 8, 30.00, 7.94, 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190017, 1329909100004, 'SO-2026-004', 'EQUIPMENT', '设备影响', 5, 20.00, 3.97, 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190018, 1329909100004, 'SO-2026-004', 'QUALITY', '质量影响', 3, 10.00, 3.00, 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190019, 1329909100004, 'SO-2026-004', 'EFFICIENCY', '作业效率损失', 11, 40.00, 8.16, 4, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190020, 1329909100004, 'SO-2026-004', 'SUBTOTAL', '损失小计', 26, 100.00, 6.62, 5, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190021, 1329909100005, 'SO-2026-005', 'MATERIAL', '材料影响', 8, 30.00, 7.94, 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190022, 1329909100005, 'SO-2026-005', 'EQUIPMENT', '设备影响', 5, 20.00, 3.97, 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190023, 1329909100005, 'SO-2026-005', 'QUALITY', '质量影响', 3, 10.00, 3.00, 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190024, 1329909100005, 'SO-2026-005', 'EFFICIENCY', '作业效率损失', 11, 40.00, 8.16, 4, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190025, 1329909100005, 'SO-2026-005', 'SUBTOTAL', '损失小计', 26, 100.00, 6.62, 5, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190026, 1329909100006, 'SO-2026-006', 'MATERIAL', '材料影响', 8, 30.00, 7.94, 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190027, 1329909100006, 'SO-2026-006', 'EQUIPMENT', '设备影响', 5, 20.00, 3.97, 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190028, 1329909100006, 'SO-2026-006', 'QUALITY', '质量影响', 3, 10.00, 3.00, 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190029, 1329909100006, 'SO-2026-006', 'EFFICIENCY', '作业效率损失', 11, 40.00, 8.16, 4, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190030, 1329909100006, 'SO-2026-006', 'SUBTOTAL', '损失小计', 26, 100.00, 6.62, 5, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190031, 1329909100007, 'SO-2026-007', 'MATERIAL', '材料影响', 11, 30.00, 10.59, 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190032, 1329909100007, 'SO-2026-007', 'EQUIPMENT', '设备影响', 7, 20.00, 5.29, 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190033, 1329909100007, 'SO-2026-007', 'QUALITY', '质量影响', 4, 10.00, 4.00, 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190034, 1329909100007, 'SO-2026-007', 'EFFICIENCY', '作业效率损失', 14, 40.00, 10.88, 4, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190035, 1329909100007, 'SO-2026-007', 'SUBTOTAL', '损失小计', 35, 100.00, 8.82, 5, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190036, 1329909100008, 'SO-2026-008', 'MATERIAL', '材料影响', 11, 30.00, 10.59, 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190037, 1329909100008, 'SO-2026-008', 'EQUIPMENT', '设备影响', 7, 20.00, 5.29, 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190038, 1329909100008, 'SO-2026-008', 'QUALITY', '质量影响', 4, 10.00, 4.00, 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190039, 1329909100008, 'SO-2026-008', 'EFFICIENCY', '作业效率损失', 14, 40.00, 10.88, 4, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190040, 1329909100008, 'SO-2026-008', 'SUBTOTAL', '损失小计', 35, 100.00, 8.82, 5, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190041, 1329909100009, 'SO-2026-009', 'MATERIAL', '材料影响', 8, 30.00, 7.94, 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190042, 1329909100009, 'SO-2026-009', 'EQUIPMENT', '设备影响', 5, 20.00, 3.97, 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190043, 1329909100009, 'SO-2026-009', 'QUALITY', '质量影响', 3, 10.00, 3.00, 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190044, 1329909100009, 'SO-2026-009', 'EFFICIENCY', '作业效率损失', 11, 40.00, 8.16, 4, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190045, 1329909100009, 'SO-2026-009', 'SUBTOTAL', '损失小计', 26, 100.00, 6.62, 5, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190046, 1329909100010, 'SO-2026-010', 'MATERIAL', '材料影响', 8, 30.00, 7.94, 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190047, 1329909100010, 'SO-2026-010', 'EQUIPMENT', '设备影响', 5, 20.00, 3.97, 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190048, 1329909100010, 'SO-2026-010', 'QUALITY', '质量影响', 3, 10.00, 3.00, 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190049, 1329909100010, 'SO-2026-010', 'EFFICIENCY', '作业效率损失', 11, 40.00, 8.16, 4, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190050, 1329909100010, 'SO-2026-010', 'SUBTOTAL', '损失小计', 26, 100.00, 6.62, 5, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190051, 1329909100011, 'SO-2026-011', 'MATERIAL', '材料影响', 8, 30.00, 7.94, 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190052, 1329909100011, 'SO-2026-011', 'EQUIPMENT', '设备影响', 5, 20.00, 3.97, 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190053, 1329909100011, 'SO-2026-011', 'QUALITY', '质量影响', 3, 10.00, 3.00, 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190054, 1329909100011, 'SO-2026-011', 'EFFICIENCY', '作业效率损失', 11, 40.00, 8.16, 4, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190055, 1329909100011, 'SO-2026-011', 'SUBTOTAL', '损失小计', 26, 100.00, 6.62, 5, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190056, 1329909100012, 'SO-2026-012', 'MATERIAL', '材料影响', 8, 30.00, 7.94, 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190057, 1329909100012, 'SO-2026-012', 'EQUIPMENT', '设备影响', 5, 20.00, 3.97, 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190058, 1329909100012, 'SO-2026-012', 'QUALITY', '质量影响', 3, 10.00, 3.00, 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190059, 1329909100012, 'SO-2026-012', 'EFFICIENCY', '作业效率损失', 11, 40.00, 8.16, 4, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190060, 1329909100012, 'SO-2026-012', 'SUBTOTAL', '损失小计', 26, 100.00, 6.62, 5, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190061, 1329909100013, 'SO-2026-013', 'MATERIAL', '材料影响', 11, 30.00, 10.59, 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190062, 1329909100013, 'SO-2026-013', 'EQUIPMENT', '设备影响', 7, 20.00, 5.29, 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190063, 1329909100013, 'SO-2026-013', 'QUALITY', '质量影响', 4, 10.00, 4.00, 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190064, 1329909100013, 'SO-2026-013', 'EFFICIENCY', '作业效率损失', 14, 40.00, 10.88, 4, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190065, 1329909100013, 'SO-2026-013', 'SUBTOTAL', '损失小计', 35, 100.00, 8.82, 5, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190066, 1329909100014, 'SO-2026-014', 'MATERIAL', '材料影响', 8, 30.00, 7.94, 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190067, 1329909100014, 'SO-2026-014', 'EQUIPMENT', '设备影响', 5, 20.00, 3.97, 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190068, 1329909100014, 'SO-2026-014', 'QUALITY', '质量影响', 3, 10.00, 3.00, 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190069, 1329909100014, 'SO-2026-014', 'EFFICIENCY', '作业效率损失', 11, 40.00, 8.16, 4, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190070, 1329909100014, 'SO-2026-014', 'SUBTOTAL', '损失小计', 26, 100.00, 6.62, 5, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190071, 1329909100015, 'SO-2026-015', 'MATERIAL', '材料影响', 8, 30.00, 7.94, 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190072, 1329909100015, 'SO-2026-015', 'EQUIPMENT', '设备影响', 5, 20.00, 3.97, 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190073, 1329909100015, 'SO-2026-015', 'QUALITY', '质量影响', 3, 10.00, 3.00, 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190074, 1329909100015, 'SO-2026-015', 'EFFICIENCY', '作业效率损失', 11, 40.00, 8.16, 4, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190075, 1329909100015, 'SO-2026-015', 'SUBTOTAL', '损失小计', 26, 100.00, 6.62, 5, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190076, 1329909100020, 'SO-2026-020', 'MATERIAL', '材料影响', 8, 30.00, 7.94, 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190077, 1329909100020, 'SO-2026-020', 'EQUIPMENT', '设备影响', 5, 20.00, 3.97, 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190078, 1329909100020, 'SO-2026-020', 'QUALITY', '质量影响', 3, 10.00, 3.00, 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190079, 1329909100020, 'SO-2026-020', 'EFFICIENCY', '作业效率损失', 11, 40.00, 8.16, 4, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909190080, 1329909100020, 'SO-2026-020', 'SUBTOTAL', '损失小计', 26, 100.00, 6.62, 5, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0);

-- ─── ado_s8_order_flow_manufacturing_operator: 51 行 ───
INSERT INTO ado_s8_order_flow_manufacturing_operator
  (id, order_id, order_code, operator_code, operator_name, avg_hours, status, sort_no, scenario_code, data_source, tenant_id, factory_id, created_at, updated_at, is_deleted)
VALUES
  (1329909200001, NULL, NULL, 'OP_ZHANG', '张师傅', 20.00, 'red', 1, 'BASELINE_PPT', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909200002, NULL, NULL, 'OP_LI', '李师傅', 10.00, 'yellow', 2, 'BASELINE_PPT', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909200003, NULL, NULL, 'OP_WANG', '王师傅', 8.00, 'green', 3, 'BASELINE_PPT', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210001, 1329909100001, 'SO-2026-001', 'OP_ZHANG', '张师傅', 14.71, 'red', 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210002, 1329909100001, 'SO-2026-001', 'OP_LI', '李师傅', 7.35, 'yellow', 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210003, 1329909100001, 'SO-2026-001', 'OP_WANG', '王师傅', 5.88, 'green', 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210004, 1329909100002, 'SO-2026-002', 'OP_ZHANG', '张师傅', 17.65, 'red', 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210005, 1329909100002, 'SO-2026-002', 'OP_LI', '李师傅', 8.82, 'yellow', 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210006, 1329909100002, 'SO-2026-002', 'OP_WANG', '王师傅', 7.06, 'green', 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210007, 1329909100003, 'SO-2026-003', 'OP_ZHANG', '张师傅', 23.53, 'red', 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210008, 1329909100003, 'SO-2026-003', 'OP_LI', '李师傅', 11.76, 'yellow', 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210009, 1329909100003, 'SO-2026-003', 'OP_WANG', '王师傅', 9.41, 'green', 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210010, 1329909100004, 'SO-2026-004', 'OP_ZHANG', '张师傅', 17.65, 'red', 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210011, 1329909100004, 'SO-2026-004', 'OP_LI', '李师傅', 8.82, 'yellow', 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210012, 1329909100004, 'SO-2026-004', 'OP_WANG', '王师傅', 7.06, 'green', 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210013, 1329909100005, 'SO-2026-005', 'OP_ZHANG', '张师傅', 17.65, 'red', 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210014, 1329909100005, 'SO-2026-005', 'OP_LI', '李师傅', 8.82, 'yellow', 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210015, 1329909100005, 'SO-2026-005', 'OP_WANG', '王师傅', 7.06, 'green', 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210016, 1329909100006, 'SO-2026-006', 'OP_ZHANG', '张师傅', 17.65, 'red', 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210017, 1329909100006, 'SO-2026-006', 'OP_LI', '李师傅', 8.82, 'yellow', 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210018, 1329909100006, 'SO-2026-006', 'OP_WANG', '王师傅', 7.06, 'green', 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210019, 1329909100007, 'SO-2026-007', 'OP_ZHANG', '张师傅', 23.53, 'red', 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210020, 1329909100007, 'SO-2026-007', 'OP_LI', '李师傅', 11.76, 'yellow', 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210021, 1329909100007, 'SO-2026-007', 'OP_WANG', '王师傅', 9.41, 'green', 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210022, 1329909100008, 'SO-2026-008', 'OP_ZHANG', '张师傅', 23.53, 'red', 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210023, 1329909100008, 'SO-2026-008', 'OP_LI', '李师傅', 11.76, 'yellow', 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210024, 1329909100008, 'SO-2026-008', 'OP_WANG', '王师傅', 9.41, 'green', 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210025, 1329909100009, 'SO-2026-009', 'OP_ZHANG', '张师傅', 17.65, 'red', 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210026, 1329909100009, 'SO-2026-009', 'OP_LI', '李师傅', 8.82, 'yellow', 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210027, 1329909100009, 'SO-2026-009', 'OP_WANG', '王师傅', 7.06, 'green', 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210028, 1329909100010, 'SO-2026-010', 'OP_ZHANG', '张师傅', 17.65, 'red', 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210029, 1329909100010, 'SO-2026-010', 'OP_LI', '李师傅', 8.82, 'yellow', 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210030, 1329909100010, 'SO-2026-010', 'OP_WANG', '王师傅', 7.06, 'green', 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210031, 1329909100011, 'SO-2026-011', 'OP_ZHANG', '张师傅', 17.65, 'red', 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210032, 1329909100011, 'SO-2026-011', 'OP_LI', '李师傅', 8.82, 'yellow', 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210033, 1329909100011, 'SO-2026-011', 'OP_WANG', '王师傅', 7.06, 'green', 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210034, 1329909100012, 'SO-2026-012', 'OP_ZHANG', '张师傅', 17.65, 'red', 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210035, 1329909100012, 'SO-2026-012', 'OP_LI', '李师傅', 8.82, 'yellow', 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210036, 1329909100012, 'SO-2026-012', 'OP_WANG', '王师傅', 7.06, 'green', 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210037, 1329909100013, 'SO-2026-013', 'OP_ZHANG', '张师傅', 23.53, 'red', 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210038, 1329909100013, 'SO-2026-013', 'OP_LI', '李师傅', 11.76, 'yellow', 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210039, 1329909100013, 'SO-2026-013', 'OP_WANG', '王师傅', 9.41, 'green', 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210040, 1329909100014, 'SO-2026-014', 'OP_ZHANG', '张师傅', 17.65, 'red', 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210041, 1329909100014, 'SO-2026-014', 'OP_LI', '李师傅', 8.82, 'yellow', 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210042, 1329909100014, 'SO-2026-014', 'OP_WANG', '王师傅', 7.06, 'green', 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210043, 1329909100015, 'SO-2026-015', 'OP_ZHANG', '张师傅', 17.65, 'red', 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210044, 1329909100015, 'SO-2026-015', 'OP_LI', '李师傅', 8.82, 'yellow', 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210045, 1329909100015, 'SO-2026-015', 'OP_WANG', '王师傅', 7.06, 'green', 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210046, 1329909100020, 'SO-2026-020', 'OP_ZHANG', '张师傅', 17.65, 'red', 1, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210047, 1329909100020, 'SO-2026-020', 'OP_LI', '李师傅', 8.82, 'yellow', 2, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
  (1329909210048, 1329909100020, 'SO-2026-020', 'OP_WANG', '王师傅', 7.06, 'green', 3, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0);