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

-- 1.0.144.sql
-- S8-ORDER-CHAIN-PRODUCT-DESIGN-20ORDER-GENERATION-CONSISTENCY-AUDIT-1
-- 重建 ado_s8_order_flow_product_design_drawing 数据，使 AVG(drawing.actual_days)=stage.actual_days 守恒。
-- 关联前置：
--   * S8OrderFlowProductDesignDrawingSeedData.cs 已重写为 DeriveLayout 守恒模型；
--   * 服务层 BuildProductDesignCategory 已去 STANDARD/TOTAL 强制 null 守门。
-- 守恒约束：
--   AVG(drawing.actual_days WHERE order_code=X) = ado_s8_order_flow_stage.actual_days WHERE order_flow_code='PRODUCT_DESIGN'
-- 守恒模型：
--   A) pending  → 3 std NULL pending
--   B) green 无非标 → 3 std A green
--   C) green 有非标 → 6 std 1.25 green + 1 nstd 13.50 red, AVG=3.00
--   D) red 无非标 → 5 std A red
--   E) red 有非标 → 6 std 4.50 red + 1 nstd 8.00 red, AVG=5.00
-- 总图号数：106 行；DELETE 旧 63 行 + INSERT 新 106 行。
-- 授权范围：仅 aidopdev；仅 ado_s8_order_flow_product_design_drawing；仅 PRODUCT_DESIGN drawing。
-- 幂等性：脚本两步顺序执行；重复运行第二次 DELETE 106 行 + INSERT 106 行，最终状态等同。
--   * 不依赖临时表；不读写其它任何表。
-- 安全边界：
--   * DELETE 严格按 tenant_id=1 AND factory_id=1 AND is_deleted=0 AND order_code IN (SO-2026-001..020) 限定；
--   * 不动 ado_s8_order_flow_stage / ado_s8_order_flow_order / 订单评审 substep/unit / 其它阶段表；
--   * 无 ALTER；无 schema 变更；无 UPDATE。
-- 2026-06-01

-- 1) DELETE 旧产品设计图号（严格按 20 单 order_code IN 限定，不无条件清表）
DELETE FROM ado_s8_order_flow_product_design_drawing
 WHERE tenant_id = 1
   AND factory_id = 1
   AND is_deleted = 0
   AND order_code IN ('SO-2026-001', 'SO-2026-002', 'SO-2026-003', 'SO-2026-004', 'SO-2026-005', 'SO-2026-006', 'SO-2026-007', 'SO-2026-008', 'SO-2026-009', 'SO-2026-010', 'SO-2026-011', 'SO-2026-012', 'SO-2026-013', 'SO-2026-014', 'SO-2026-015', 'SO-2026-016', 'SO-2026-017', 'SO-2026-018', 'SO-2026-019', 'SO-2026-020');

-- 2) INSERT 新 106 行 drawing（守恒模型生成）
INSERT INTO ado_s8_order_flow_product_design_drawing
  (id, tenant_id, factory_id, order_code, drawing_no, product_type, product_quantity,
   responsible_person, planned_start_date, planned_end_date,
   actual_start_date, actual_end_date, kpi_days, actual_days,
   is_achieved, status, sort_no, is_deleted, create_time, update_time)
VALUES
  (1329909130001, 1, 1, 'SO-2026-001', 'D-SO-2026-001-G01', 'STANDARD', 7, '李海峰', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-24 21:00:00', 3.00, 4.50, 0, 'red', 1, 0, '2026-05-12 00:00:00', NULL),
  (1329909130002, 1, 1, 'SO-2026-001', 'D-SO-2026-001-G02', 'STANDARD', 7, '陈思远', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-24 21:00:00', 3.00, 4.50, 0, 'red', 2, 0, '2026-05-12 00:00:00', NULL),
  (1329909130003, 1, 1, 'SO-2026-001', 'D-SO-2026-001-G03', 'STANDARD', 7, '王明华', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-24 21:00:00', 3.00, 4.50, 0, 'red', 3, 0, '2026-05-12 00:00:00', NULL),
  (1329909130004, 1, 1, 'SO-2026-001', 'D-SO-2026-001-G04', 'STANDARD', 7, '赵建国', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-24 21:00:00', 3.00, 4.50, 0, 'red', 4, 0, '2026-05-12 00:00:00', NULL),
  (1329909130005, 1, 1, 'SO-2026-001', 'D-SO-2026-001-G05', 'STANDARD', 7, '刘振宇', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-24 21:00:00', 3.00, 4.50, 0, 'red', 5, 0, '2026-05-12 00:00:00', NULL),
  (1329909130006, 1, 1, 'SO-2026-001', 'D-SO-2026-001-G06', 'STANDARD', 7, '周启明', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-24 21:00:00', 3.00, 4.50, 0, 'red', 6, 0, '2026-05-12 00:00:00', NULL),
  (1329909130007, 1, 1, 'SO-2026-001', 'D-SO-2026-001-X01', 'NON_STANDARD', 2, '李海峰', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-28 09:00:00', 3.00, 8.00, 0, 'red', 7, 0, '2026-05-12 00:00:00', NULL),
  (1329909130008, 1, 1, 'SO-2026-002', 'D-SO-2026-002-G01', 'STANDARD', 7, '陈思远', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 1, 0, '2026-05-12 00:00:00', NULL),
  (1329909130009, 1, 1, 'SO-2026-002', 'D-SO-2026-002-G02', 'STANDARD', 7, '王明华', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 2, 0, '2026-05-12 00:00:00', NULL),
  (1329909130010, 1, 1, 'SO-2026-002', 'D-SO-2026-002-G03', 'STANDARD', 7, '赵建国', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 3, 0, '2026-05-12 00:00:00', NULL),
  (1329909130011, 1, 1, 'SO-2026-002', 'D-SO-2026-002-G04', 'STANDARD', 7, '刘振宇', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 4, 0, '2026-05-12 00:00:00', NULL),
  (1329909130012, 1, 1, 'SO-2026-002', 'D-SO-2026-002-G05', 'STANDARD', 7, '周启明', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 5, 0, '2026-05-12 00:00:00', NULL),
  (1329909130013, 1, 1, 'SO-2026-002', 'D-SO-2026-002-G06', 'STANDARD', 7, '李海峰', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 6, 0, '2026-05-12 00:00:00', NULL),
  (1329909130014, 1, 1, 'SO-2026-002', 'D-SO-2026-002-X01', 'NON_STANDARD', 2, '陈思远', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-05-03 21:00:00', 3.00, 13.50, 0, 'red', 7, 0, '2026-05-12 00:00:00', NULL),
  (1329909130015, 1, 1, 'SO-2026-003', 'D-SO-2026-003-G01', 'STANDARD', 7, '王明华', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 1, 0, '2026-05-12 00:00:00', NULL),
  (1329909130016, 1, 1, 'SO-2026-003', 'D-SO-2026-003-G02', 'STANDARD', 7, '赵建国', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 2, 0, '2026-05-12 00:00:00', NULL),
  (1329909130017, 1, 1, 'SO-2026-003', 'D-SO-2026-003-G03', 'STANDARD', 7, '刘振宇', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 3, 0, '2026-05-12 00:00:00', NULL),
  (1329909130018, 1, 1, 'SO-2026-003', 'D-SO-2026-003-G04', 'STANDARD', 7, '周启明', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 4, 0, '2026-05-12 00:00:00', NULL),
  (1329909130019, 1, 1, 'SO-2026-003', 'D-SO-2026-003-G05', 'STANDARD', 7, '李海峰', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 5, 0, '2026-05-12 00:00:00', NULL),
  (1329909130020, 1, 1, 'SO-2026-003', 'D-SO-2026-003-G06', 'STANDARD', 7, '陈思远', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 6, 0, '2026-05-12 00:00:00', NULL),
  (1329909130021, 1, 1, 'SO-2026-003', 'D-SO-2026-003-X01', 'NON_STANDARD', 2, '王明华', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-05-03 21:00:00', 3.00, 13.50, 0, 'red', 7, 0, '2026-05-12 00:00:00', NULL),
  (1329909130022, 1, 1, 'SO-2026-004', 'D-SO-2026-004-G01', 'STANDARD', 7, '赵建国', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-25 09:00:00', 3.00, 5.00, 0, 'red', 1, 0, '2026-05-12 00:00:00', NULL),
  (1329909130023, 1, 1, 'SO-2026-004', 'D-SO-2026-004-G02', 'STANDARD', 7, '刘振宇', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-25 09:00:00', 3.00, 5.00, 0, 'red', 2, 0, '2026-05-12 00:00:00', NULL),
  (1329909130024, 1, 1, 'SO-2026-004', 'D-SO-2026-004-G03', 'STANDARD', 7, '周启明', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-25 09:00:00', 3.00, 5.00, 0, 'red', 3, 0, '2026-05-12 00:00:00', NULL),
  (1329909130025, 1, 1, 'SO-2026-004', 'D-SO-2026-004-G04', 'STANDARD', 7, '李海峰', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-25 09:00:00', 3.00, 5.00, 0, 'red', 4, 0, '2026-05-12 00:00:00', NULL),
  (1329909130026, 1, 1, 'SO-2026-004', 'D-SO-2026-004-G05', 'STANDARD', 7, '陈思远', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-25 09:00:00', 3.00, 5.00, 0, 'red', 5, 0, '2026-05-12 00:00:00', NULL),
  (1329909130027, 1, 1, 'SO-2026-005', 'D-SO-2026-005-G01', 'STANDARD', 7, '王明华', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-25 09:00:00', 3.00, 5.00, 0, 'red', 1, 0, '2026-05-12 00:00:00', NULL),
  (1329909130028, 1, 1, 'SO-2026-005', 'D-SO-2026-005-G02', 'STANDARD', 7, '赵建国', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-25 09:00:00', 3.00, 5.00, 0, 'red', 2, 0, '2026-05-12 00:00:00', NULL),
  (1329909130029, 1, 1, 'SO-2026-005', 'D-SO-2026-005-G03', 'STANDARD', 7, '刘振宇', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-25 09:00:00', 3.00, 5.00, 0, 'red', 3, 0, '2026-05-12 00:00:00', NULL),
  (1329909130030, 1, 1, 'SO-2026-005', 'D-SO-2026-005-G04', 'STANDARD', 7, '周启明', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-25 09:00:00', 3.00, 5.00, 0, 'red', 4, 0, '2026-05-12 00:00:00', NULL),
  (1329909130031, 1, 1, 'SO-2026-005', 'D-SO-2026-005-G05', 'STANDARD', 7, '李海峰', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-25 09:00:00', 3.00, 5.00, 0, 'red', 5, 0, '2026-05-12 00:00:00', NULL),
  (1329909130032, 1, 1, 'SO-2026-006', 'D-SO-2026-006-G01', 'STANDARD', 7, '陈思远', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 1, 0, '2026-05-12 00:00:00', NULL),
  (1329909130033, 1, 1, 'SO-2026-006', 'D-SO-2026-006-G02', 'STANDARD', 7, '王明华', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 2, 0, '2026-05-12 00:00:00', NULL),
  (1329909130034, 1, 1, 'SO-2026-006', 'D-SO-2026-006-G03', 'STANDARD', 7, '赵建国', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 3, 0, '2026-05-12 00:00:00', NULL),
  (1329909130035, 1, 1, 'SO-2026-006', 'D-SO-2026-006-G04', 'STANDARD', 7, '刘振宇', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 4, 0, '2026-05-12 00:00:00', NULL),
  (1329909130036, 1, 1, 'SO-2026-006', 'D-SO-2026-006-G05', 'STANDARD', 7, '周启明', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 5, 0, '2026-05-12 00:00:00', NULL),
  (1329909130037, 1, 1, 'SO-2026-006', 'D-SO-2026-006-G06', 'STANDARD', 7, '李海峰', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 6, 0, '2026-05-12 00:00:00', NULL),
  (1329909130038, 1, 1, 'SO-2026-006', 'D-SO-2026-006-X01', 'NON_STANDARD', 2, '陈思远', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-05-03 21:00:00', 3.00, 13.50, 0, 'red', 7, 0, '2026-05-12 00:00:00', NULL),
  (1329909130039, 1, 1, 'SO-2026-007', 'D-SO-2026-007-G01', 'STANDARD', 7, '王明华', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 1, 0, '2026-05-12 00:00:00', NULL),
  (1329909130040, 1, 1, 'SO-2026-007', 'D-SO-2026-007-G02', 'STANDARD', 7, '赵建国', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 2, 0, '2026-05-12 00:00:00', NULL),
  (1329909130041, 1, 1, 'SO-2026-007', 'D-SO-2026-007-G03', 'STANDARD', 7, '刘振宇', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 3, 0, '2026-05-12 00:00:00', NULL),
  (1329909130042, 1, 1, 'SO-2026-007', 'D-SO-2026-007-G04', 'STANDARD', 7, '周启明', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 4, 0, '2026-05-12 00:00:00', NULL),
  (1329909130043, 1, 1, 'SO-2026-007', 'D-SO-2026-007-G05', 'STANDARD', 7, '李海峰', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 5, 0, '2026-05-12 00:00:00', NULL),
  (1329909130044, 1, 1, 'SO-2026-007', 'D-SO-2026-007-G06', 'STANDARD', 7, '陈思远', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 6, 0, '2026-05-12 00:00:00', NULL),
  (1329909130045, 1, 1, 'SO-2026-007', 'D-SO-2026-007-X01', 'NON_STANDARD', 2, '王明华', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-05-03 21:00:00', 3.00, 13.50, 0, 'red', 7, 0, '2026-05-12 00:00:00', NULL),
  (1329909130046, 1, 1, 'SO-2026-008', 'D-SO-2026-008-G01', 'STANDARD', 7, '赵建国', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 1, 0, '2026-05-12 00:00:00', NULL),
  (1329909130047, 1, 1, 'SO-2026-008', 'D-SO-2026-008-G02', 'STANDARD', 7, '刘振宇', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 2, 0, '2026-05-12 00:00:00', NULL),
  (1329909130048, 1, 1, 'SO-2026-008', 'D-SO-2026-008-G03', 'STANDARD', 7, '周启明', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 3, 0, '2026-05-12 00:00:00', NULL),
  (1329909130049, 1, 1, 'SO-2026-008', 'D-SO-2026-008-G04', 'STANDARD', 7, '李海峰', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 4, 0, '2026-05-12 00:00:00', NULL),
  (1329909130050, 1, 1, 'SO-2026-008', 'D-SO-2026-008-G05', 'STANDARD', 7, '陈思远', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 5, 0, '2026-05-12 00:00:00', NULL),
  (1329909130051, 1, 1, 'SO-2026-008', 'D-SO-2026-008-G06', 'STANDARD', 7, '王明华', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 6, 0, '2026-05-12 00:00:00', NULL),
  (1329909130052, 1, 1, 'SO-2026-008', 'D-SO-2026-008-X01', 'NON_STANDARD', 2, '赵建国', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-05-03 21:00:00', 3.00, 13.50, 0, 'red', 7, 0, '2026-05-12 00:00:00', NULL),
  (1329909130053, 1, 1, 'SO-2026-009', 'D-SO-2026-009-G01', 'STANDARD', 7, '刘振宇', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-23 09:00:00', 3.00, 3.00, 1, 'green', 1, 0, '2026-05-12 00:00:00', NULL),
  (1329909130054, 1, 1, 'SO-2026-009', 'D-SO-2026-009-G02', 'STANDARD', 7, '周启明', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-23 09:00:00', 3.00, 3.00, 1, 'green', 2, 0, '2026-05-12 00:00:00', NULL),
  (1329909130055, 1, 1, 'SO-2026-009', 'D-SO-2026-009-G03', 'STANDARD', 7, '李海峰', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-23 09:00:00', 3.00, 3.00, 1, 'green', 3, 0, '2026-05-12 00:00:00', NULL),
  (1329909130056, 1, 1, 'SO-2026-010', 'D-SO-2026-010-G01', 'STANDARD', 7, '陈思远', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-25 09:00:00', 3.00, 5.00, 0, 'red', 1, 0, '2026-05-12 00:00:00', NULL),
  (1329909130057, 1, 1, 'SO-2026-010', 'D-SO-2026-010-G02', 'STANDARD', 7, '王明华', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-25 09:00:00', 3.00, 5.00, 0, 'red', 2, 0, '2026-05-12 00:00:00', NULL),
  (1329909130058, 1, 1, 'SO-2026-010', 'D-SO-2026-010-G03', 'STANDARD', 7, '赵建国', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-25 09:00:00', 3.00, 5.00, 0, 'red', 3, 0, '2026-05-12 00:00:00', NULL),
  (1329909130059, 1, 1, 'SO-2026-010', 'D-SO-2026-010-G04', 'STANDARD', 7, '刘振宇', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-25 09:00:00', 3.00, 5.00, 0, 'red', 4, 0, '2026-05-12 00:00:00', NULL),
  (1329909130060, 1, 1, 'SO-2026-010', 'D-SO-2026-010-G05', 'STANDARD', 7, '周启明', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-25 09:00:00', 3.00, 5.00, 0, 'red', 5, 0, '2026-05-12 00:00:00', NULL),
  (1329909130061, 1, 1, 'SO-2026-011', 'D-SO-2026-011-G01', 'STANDARD', 7, '李海峰', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-23 09:00:00', 3.00, 3.00, 1, 'green', 1, 0, '2026-05-12 00:00:00', NULL),
  (1329909130062, 1, 1, 'SO-2026-011', 'D-SO-2026-011-G02', 'STANDARD', 7, '陈思远', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-23 09:00:00', 3.00, 3.00, 1, 'green', 2, 0, '2026-05-12 00:00:00', NULL),
  (1329909130063, 1, 1, 'SO-2026-011', 'D-SO-2026-011-G03', 'STANDARD', 7, '王明华', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-23 09:00:00', 3.00, 3.00, 1, 'green', 3, 0, '2026-05-12 00:00:00', NULL),
  (1329909130064, 1, 1, 'SO-2026-012', 'D-SO-2026-012-G01', 'STANDARD', 7, '赵建国', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 1, 0, '2026-05-12 00:00:00', NULL),
  (1329909130065, 1, 1, 'SO-2026-012', 'D-SO-2026-012-G02', 'STANDARD', 7, '刘振宇', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 2, 0, '2026-05-12 00:00:00', NULL),
  (1329909130066, 1, 1, 'SO-2026-012', 'D-SO-2026-012-G03', 'STANDARD', 7, '周启明', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 3, 0, '2026-05-12 00:00:00', NULL),
  (1329909130067, 1, 1, 'SO-2026-012', 'D-SO-2026-012-G04', 'STANDARD', 7, '李海峰', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 4, 0, '2026-05-12 00:00:00', NULL),
  (1329909130068, 1, 1, 'SO-2026-012', 'D-SO-2026-012-G05', 'STANDARD', 7, '陈思远', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 5, 0, '2026-05-12 00:00:00', NULL),
  (1329909130069, 1, 1, 'SO-2026-012', 'D-SO-2026-012-G06', 'STANDARD', 7, '王明华', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 6, 0, '2026-05-12 00:00:00', NULL),
  (1329909130070, 1, 1, 'SO-2026-012', 'D-SO-2026-012-X01', 'NON_STANDARD', 2, '赵建国', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-05-03 21:00:00', 3.00, 13.50, 0, 'red', 7, 0, '2026-05-12 00:00:00', NULL),
  (1329909130071, 1, 1, 'SO-2026-013', 'D-SO-2026-013-G01', 'STANDARD', 7, '刘振宇', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-23 09:00:00', 3.00, 3.00, 1, 'green', 1, 0, '2026-05-12 00:00:00', NULL),
  (1329909130072, 1, 1, 'SO-2026-013', 'D-SO-2026-013-G02', 'STANDARD', 7, '周启明', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-23 09:00:00', 3.00, 3.00, 1, 'green', 2, 0, '2026-05-12 00:00:00', NULL),
  (1329909130073, 1, 1, 'SO-2026-013', 'D-SO-2026-013-G03', 'STANDARD', 7, '李海峰', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-23 09:00:00', 3.00, 3.00, 1, 'green', 3, 0, '2026-05-12 00:00:00', NULL),
  (1329909130074, 1, 1, 'SO-2026-014', 'D-SO-2026-014-G01', 'STANDARD', 7, '陈思远', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-23 09:00:00', 3.00, 3.00, 1, 'green', 1, 0, '2026-05-12 00:00:00', NULL),
  (1329909130075, 1, 1, 'SO-2026-014', 'D-SO-2026-014-G02', 'STANDARD', 7, '王明华', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-23 09:00:00', 3.00, 3.00, 1, 'green', 2, 0, '2026-05-12 00:00:00', NULL),
  (1329909130076, 1, 1, 'SO-2026-014', 'D-SO-2026-014-G03', 'STANDARD', 7, '赵建国', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-23 09:00:00', 3.00, 3.00, 1, 'green', 3, 0, '2026-05-12 00:00:00', NULL),
  (1329909130077, 1, 1, 'SO-2026-015', 'D-SO-2026-015-G01', 'STANDARD', 7, '刘振宇', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-23 09:00:00', 3.00, 3.00, 1, 'green', 1, 0, '2026-05-12 00:00:00', NULL),
  (1329909130078, 1, 1, 'SO-2026-015', 'D-SO-2026-015-G02', 'STANDARD', 7, '周启明', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-23 09:00:00', 3.00, 3.00, 1, 'green', 2, 0, '2026-05-12 00:00:00', NULL),
  (1329909130079, 1, 1, 'SO-2026-015', 'D-SO-2026-015-G03', 'STANDARD', 7, '李海峰', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-23 09:00:00', 3.00, 3.00, 1, 'green', 3, 0, '2026-05-12 00:00:00', NULL),
  (1329909130080, 1, 1, 'SO-2026-016', 'D-SO-2026-016-G01', 'STANDARD', 7, '陈思远', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', NULL, 3.00, NULL, 0, 'pending', 1, 0, '2026-05-12 00:00:00', NULL),
  (1329909130081, 1, 1, 'SO-2026-016', 'D-SO-2026-016-G02', 'STANDARD', 7, '王明华', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', NULL, 3.00, NULL, 0, 'pending', 2, 0, '2026-05-12 00:00:00', NULL),
  (1329909130082, 1, 1, 'SO-2026-016', 'D-SO-2026-016-G03', 'STANDARD', 7, '赵建国', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', NULL, 3.00, NULL, 0, 'pending', 3, 0, '2026-05-12 00:00:00', NULL),
  (1329909130083, 1, 1, 'SO-2026-017', 'D-SO-2026-017-G01', 'STANDARD', 7, '刘振宇', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', NULL, 3.00, NULL, 0, 'pending', 1, 0, '2026-05-12 00:00:00', NULL),
  (1329909130084, 1, 1, 'SO-2026-017', 'D-SO-2026-017-G02', 'STANDARD', 7, '周启明', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', NULL, 3.00, NULL, 0, 'pending', 2, 0, '2026-05-12 00:00:00', NULL),
  (1329909130085, 1, 1, 'SO-2026-017', 'D-SO-2026-017-G03', 'STANDARD', 7, '李海峰', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', NULL, 3.00, NULL, 0, 'pending', 3, 0, '2026-05-12 00:00:00', NULL),
  (1329909130086, 1, 1, 'SO-2026-018', 'D-SO-2026-018-G01', 'STANDARD', 7, '陈思远', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 1, 0, '2026-05-12 00:00:00', NULL),
  (1329909130087, 1, 1, 'SO-2026-018', 'D-SO-2026-018-G02', 'STANDARD', 7, '王明华', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 2, 0, '2026-05-12 00:00:00', NULL),
  (1329909130088, 1, 1, 'SO-2026-018', 'D-SO-2026-018-G03', 'STANDARD', 7, '赵建国', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 3, 0, '2026-05-12 00:00:00', NULL),
  (1329909130089, 1, 1, 'SO-2026-018', 'D-SO-2026-018-G04', 'STANDARD', 7, '刘振宇', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 4, 0, '2026-05-12 00:00:00', NULL),
  (1329909130090, 1, 1, 'SO-2026-018', 'D-SO-2026-018-G05', 'STANDARD', 7, '周启明', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 5, 0, '2026-05-12 00:00:00', NULL),
  (1329909130091, 1, 1, 'SO-2026-018', 'D-SO-2026-018-G06', 'STANDARD', 7, '李海峰', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 6, 0, '2026-05-12 00:00:00', NULL),
  (1329909130092, 1, 1, 'SO-2026-018', 'D-SO-2026-018-X01', 'NON_STANDARD', 2, '陈思远', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-05-03 21:00:00', 3.00, 13.50, 0, 'red', 7, 0, '2026-05-12 00:00:00', NULL),
  (1329909130093, 1, 1, 'SO-2026-019', 'D-SO-2026-019-G01', 'STANDARD', 7, '王明华', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 1, 0, '2026-05-12 00:00:00', NULL),
  (1329909130094, 1, 1, 'SO-2026-019', 'D-SO-2026-019-G02', 'STANDARD', 7, '赵建国', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 2, 0, '2026-05-12 00:00:00', NULL),
  (1329909130095, 1, 1, 'SO-2026-019', 'D-SO-2026-019-G03', 'STANDARD', 7, '刘振宇', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 3, 0, '2026-05-12 00:00:00', NULL),
  (1329909130096, 1, 1, 'SO-2026-019', 'D-SO-2026-019-G04', 'STANDARD', 7, '周启明', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 4, 0, '2026-05-12 00:00:00', NULL),
  (1329909130097, 1, 1, 'SO-2026-019', 'D-SO-2026-019-G05', 'STANDARD', 7, '李海峰', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 5, 0, '2026-05-12 00:00:00', NULL),
  (1329909130098, 1, 1, 'SO-2026-019', 'D-SO-2026-019-G06', 'STANDARD', 7, '陈思远', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 6, 0, '2026-05-12 00:00:00', NULL),
  (1329909130099, 1, 1, 'SO-2026-019', 'D-SO-2026-019-X01', 'NON_STANDARD', 2, '王明华', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-05-03 21:00:00', 3.00, 13.50, 0, 'red', 7, 0, '2026-05-12 00:00:00', NULL),
  (1329909130100, 1, 1, 'SO-2026-020', 'D-SO-2026-020-G01', 'STANDARD', 7, '赵建国', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 1, 0, '2026-05-12 00:00:00', NULL),
  (1329909130101, 1, 1, 'SO-2026-020', 'D-SO-2026-020-G02', 'STANDARD', 7, '刘振宇', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 2, 0, '2026-05-12 00:00:00', NULL),
  (1329909130102, 1, 1, 'SO-2026-020', 'D-SO-2026-020-G03', 'STANDARD', 7, '周启明', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 3, 0, '2026-05-12 00:00:00', NULL),
  (1329909130103, 1, 1, 'SO-2026-020', 'D-SO-2026-020-G04', 'STANDARD', 7, '李海峰', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 4, 0, '2026-05-12 00:00:00', NULL),
  (1329909130104, 1, 1, 'SO-2026-020', 'D-SO-2026-020-G05', 'STANDARD', 7, '陈思远', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 5, 0, '2026-05-12 00:00:00', NULL),
  (1329909130105, 1, 1, 'SO-2026-020', 'D-SO-2026-020-G06', 'STANDARD', 7, '王明华', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-04-21 15:00:00', 3.00, 1.25, 1, 'green', 6, 0, '2026-05-12 00:00:00', NULL),
  (1329909130106, 1, 1, 'SO-2026-020', 'D-SO-2026-020-X01', 'NON_STANDARD', 2, '赵建国', '2026-04-20 09:00:00', '2026-04-23 09:00:00', '2026-04-20 09:00:00', '2026-05-03 21:00:00', 3.00, 13.50, 0, 'red', 7, 0, '2026-05-12 00:00:00', NULL);