AiDOPWarehouse/server/Plugins/Admin.NET.Plugin.AiDOP/Dto/S8/OrderFlow/AdoS8OrderFlowDtos.cs

namespace Admin.NET.Plugin.AiDOP.Dto.S8.OrderFlow;

/// <summary>
/// ORDER-FLOW-S8-INTEGRATED-DOMAIN-RESET-1 t3a：S8 订单执行链路 DTO 契约。
/// 仅定义类型，不携带业务常量 / 不引用 Entity / 不接 service 逻辑。
/// 后续 t3b/t3c 切片负责 service + controller 把 DTO 接到 ado_s8_order_flow_* 与 ado_s8_exception 实时聚合。
/// </summary>

#region 订单档案

public class AdoS8OrderFlowOrderQueryDto
{
    public string? Keyword { get; set; }
    public string? CurrentFlowCode { get; set; }
    public string? CustomerCode { get; set; }
    public string? ProductLine { get; set; }
    public string? Region { get; set; }
    public string? WorkflowStatus { get; set; }
    public string? ScenarioCode { get; set; }
}

public class AdoS8OrderFlowOrderListItemDto
{
    // ── REAL runtime（mdp_std_so）新增字段 ─────────────────────────────────────────────
    // SEED 路径（ado_s8_order_flow_*）不填这些，保持 null；REAL 路径不填 SEED 的周期/偏差字段。
    // 两条路径互不混用：靠 DataSource 区分（SEED / MDP_STD_SO）。

    /// <summary>
    /// 真实销售订单头 Id = <c>mdp_std_so.order_id</c> = <c>crm_seorder.Id</c>。
    /// <b>REAL runtime 的唯一订单身份</b>；SEED 路径为 null。
    /// 前端必须用它定位订单，禁止再用订单号文本或字符串拼接构造 id。
    /// </summary>
    public long? SalesOrderId { get; set; }

    /// <summary>真实销售订单号 = <c>mdp_std_so.order_no</c>。**仅展示 / 搜索**，不作主键。</summary>
    public string? OrderNo { get; set; }

    /// <summary>客户 Id（Header Authority）。</summary>
    public long? CustomerId { get; set; }

    /// <summary>下单日期（Header Authority）。</summary>
    public DateTime? OrderDate { get; set; }

    /// <summary>订单类型（Header Authority，源端为 int 域）。</summary>
    public int? OrderType { get; set; }

    /// <summary>订单状态 OPEN/CLOSED（Header Authority）。</summary>
    public string? OrderStatus { get; set; }

    /// <summary>流程状态（Header Authority）。</summary>
    public string? FlowState { get; set; }

    // ── 既有字段 ─────────────────────────────────────────────────────────────────────

    public string OrderCode { get; set; } = string.Empty;
    public string ProductName { get; set; } = string.Empty;
    public string ProductLine { get; set; } = string.Empty;
    public string CustomerCode { get; set; } = string.Empty;
    public string CustomerName { get; set; } = string.Empty;
    public string CustomerType { get; set; } = string.Empty;
    public string Region { get; set; } = string.Empty;
    public string Priority { get; set; } = string.Empty;
    public string WorkflowStatus { get; set; } = string.Empty;
    public string CurrentOrderFlowCode { get; set; } = string.Empty;
    public string CurrentOrderFlowName { get; set; } = string.Empty;
    public string CurrentStatus { get; set; } = string.Empty;
    /// <summary>SEED 的下达时间。REAL runtime 无对应 Authority → null（改用 <see cref="OrderDate"/>）。</summary>
    public DateTime? ReleaseAt { get; set; }

    /// <summary>SEED 的目标周期。**REAL runtime 必须为 null** —— 真实订单没有目标周期 Authority，不得回落 SEED。</summary>
    public decimal? TargetCycleDays { get; set; }

    public decimal? ActualCycleDays { get; set; }
    public decimal? CurrentCycleDays { get; set; }
    public decimal? NodeVarianceDays { get; set; }
    public decimal? CumulativeVarianceDays { get; set; }

    /// <summary>来自 ado_s8_exception 实时聚合（order 主档表无 exception_count 列）。</summary>
    public int ExceptionCount { get; set; }
    public string ExceptionStatus { get; set; } = string.Empty;

    public int? ResponseMinutes { get; set; }
    public int? ProcessingMinutes { get; set; }
    public int? TotalLossMinutes { get; set; }
    public string ScenarioCode { get; set; } = string.Empty;
    public string DataSource { get; set; } = string.Empty;
}

public class AdoS8OrderFlowOrderDetailDto : AdoS8OrderFlowOrderListItemDto
{
    public List<AdoS8OrderFlowStageDto> Lifecycle { get; set; } = new();
}

#endregion

#region 阶段 / L2 / L3

public class AdoS8OrderFlowStageDto
{
    public string OrderFlowCode { get; set; } = string.Empty;
    public string OrderFlowName { get; set; } = string.Empty;
    public string? OwnerDept { get; set; }
    public int SortNo { get; set; }
    /// <summary>SEED 的计划天数。REAL runtime 无 Authority → null。</summary>
    public decimal? PlannedDays { get; set; }

    /// <summary>SEED 的实际天数。REAL runtime 无 Authority → null。**不得把小时塞进这里**（它已被 KPI 反推逻辑占用）。</summary>
    public decimal? ActualDays { get; set; }

    /// <summary>SEED 的目标时间。REAL runtime 无 Authority → null。</summary>
    public DateTime? TargetAt { get; set; }

    public DateTime? ActualStartAt { get; set; }
    public DateTime? ActualEndAt { get; set; }

    /// <summary>
    /// 阶段实际耗时（小时）。REAL runtime 下 ORDER_REVIEW 取
    /// <c>dwd_order_review_kpi.actual_hours</c>；其余阶段与 SEED 路径为 null。
    /// <b>独立字段，绝不复用 <see cref="ActualDays"/></b>（单位与语义都不同）。
    /// </summary>
    public decimal? ActualHours { get; set; }

    /// <summary>
    /// Stage-1 KPI 计算状态：OK / NO_START / IN_PROGRESS / INVALID / INVALID_TIME_SEQUENCE。
    /// 仅 REAL runtime 的 ORDER_REVIEW 有值。
    /// </summary>
    public string? CalculationStatus { get; set; }

    public string Status { get; set; } = string.Empty;
    public decimal? NodeVarianceDays { get; set; }
    public decimal? CumulativeVarianceDays { get; set; }
    public List<AdoS8OrderFlowSubstepDto> Substeps { get; set; } = new();

    // ── 阶段数据态（通用，不是某个阶段专属）─────────────────────────────────────
    //
    // 起因：REAL runtime 下 Status 恒为 "pending"，前端只能按「有没有时间」细分标签。
    // 对没有时间 Authority 的阶段（如材料采购），这会把「已经有真实在办数据」
    // 说成「未到达」—— 与同页详情直接矛盾。下面四个字段让阶段能在不伪造时间的前提下
    // 如实表达自己有多少可信数据。仅有 REAL Authority 的阶段填，其余保持 null。

    /// <summary>
    /// 阶段数据态：<c>NO_DATA</c>（无可归属对象）/ <c>IN_PROGRESS</c>（有可归属对象）/
    /// <c>UNKNOWN</c>（取数失败，技术故障不得当业务结论）。
    /// <para><b>刻意没有 COMPLETED</b>：现有 Authority 只覆盖「能可靠归属到该订单的对象」，
    /// 不是该阶段的完整需求集合，据此宣称阶段完成会是错的。</para>
    /// </summary>
    public string? DataState { get; set; }

    /// <summary>数据范围，如 <c>ATTRIBUTED_ONLY</c>。消费方据此避免把子集当全集。</summary>
    public string? DataScope { get; set; }

    /// <summary>该阶段已可靠归属到本订单的对象数（材料采购 = 已归属采购行数）。</summary>
    public int? KnownItemCount { get; set; }

    /// <summary>上述对象中已完成的数量（材料采购 = 采购已完成行数）。</summary>
    public int? CompletedItemCount { get; set; }
}

/// <summary>
/// 阶段数据态取值。
///
/// <para><b>这里没有、也不会有 <c>COMPLETED</c>。</b>现有 Authority 只覆盖「能可靠归属到该订单的
/// 对象」（<see cref="AdoS8OrderFlowStageDto.DataScope"/> = <c>ATTRIBUTED_ONLY</c>），
/// 不是该阶段的完整需求集合。即便已归属对象全部完成，也推不出「该阶段已完成」——
/// 那要等完整需求集合的 Authority 建立之后才谈得上。谁想加 COMPLETED，先拿出那个 Authority。</para>
/// </summary>
public static class AdoS8StageDataState
{
    /// <summary>有可归属对象（在办）。</summary>
    public const string InProgress = "IN_PROGRESS";

    /// <summary>无可归属对象。注意是「没查到」，不是「不需要」。</summary>
    public const string NoData = "NO_DATA";

    /// <summary>取数失败。技术故障，不得渲染成任何业务结论。</summary>
    public const string Unknown = "UNKNOWN";
}

public class AdoS8OrderFlowSubstepDto
{
    public string SubstepCode { get; set; } = string.Empty;
    public string SubstepName { get; set; } = string.Empty;
    public decimal PiHours { get; set; }
    public decimal? ActualHours { get; set; }
    public string Status { get; set; } = string.Empty;
    public int SortNo { get; set; }
    public List<AdoS8OrderFlowSubstepUnitDto> Units { get; set; } = new();
}

public class AdoS8OrderFlowSubstepUnitDto
{
    public string UnitCode { get; set; } = string.Empty;
    public string UnitName { get; set; } = string.Empty;
    public decimal PiHours { get; set; }
    public decimal? ActualHours { get; set; }
    public string Status { get; set; } = string.Empty;
    public int SortNo { get; set; }
}

#endregion

#region 订单 + 采购透视组合

public class AdoS8OrderFlowChainDto
{
    public AdoS8OrderFlowOrderDetailDto Order { get; set; } = new();
    public AdoS8OrderFlowProcurementPivotDto? ProcurementPivot { get; set; }
}

#endregion

#region 聚合 / Baseline

public class AdoS8OrderFlowAggregateQueryDto
{
    public string Scope { get; set; } = string.Empty;

    /// <summary>
    /// S8-STEP5B-P2-FILTER-SUBSET-CERT-1：订单编码 CSV，与 procurement / manufacturing /
    /// final-assembly / drawings 四个 pivot DTO 的 OrderCodes 口径统一（服务侧走 ParseOrderCodesCsv）。
    /// 原类型是 <c>List&lt;string&gt;?</c>——aggregate 是唯一没跟上该约定的端点。实测：
    /// <c>orderCodes=SO-001,SO-002</c> 被默认集合绑定器绑成 **单元素** <c>["SO-001,SO-002"]</c>，
    /// 与任何 order_code 都不相等 → totalOrders=0（静默返回空聚合，而非报错）；
    /// <c>orderCodes[]=X</c> 则整体绑不上 → 静默退回全量。两种失败都不会暴露为 4xx/5xx。
    /// </summary>
    public string? OrderCodes { get; set; }
}

public class AdoS8OrderFlowAggregateDto
{
    public string Scope { get; set; } = string.Empty;
    public int TotalOrders { get; set; }
    public int TotalCustomers { get; set; }
    public decimal AvgResponseMinutes { get; set; }
    public decimal AvgProcessingMinutes { get; set; }
    public decimal AvgLossMinutes { get; set; }
    public List<AdoS8OrderFlowStageAggregateDto> StageAggregates { get; set; } = new();

    /// <summary>
    /// FINAL_ASSEMBLY_DELIVERY 末端协同聚合摘要（基线 / 当前两条路径均填充）。
    /// 派生自 ado_s8_exception 现有异常类型，不新增业务表 / 不新增异常类型 / 不读 S0|S4 业务表。
    /// 字段全 nullable，老调用方无感知。
    /// </summary>
    public AdoS8FinalAssemblyCollabSummaryDto? FinalAssemblyCollabSummary { get; set; }
}

public class AdoS8FinalAssemblyCollabSummaryDto
{
    /// <summary>主门禁（GATE）—— key 为前端固定 object_code（如 GOODS_HANDOVER / SHIPMENT_CONFIRMATION）。无映射的门禁不出现在字典中。</summary>
    public Dictionary<string, AdoS8FinalAssemblyObjectStatDto> Gates { get; set; } = new();

    /// <summary>并行准备（PARALLEL）—— key 为前端固定 object_code（如 SHIPPING_PLAN）。无映射的准备项不出现在字典中。</summary>
    public Dictionary<string, AdoS8FinalAssemblyObjectStatDto> Parallels { get; set; } = new();
}

public class AdoS8FinalAssemblyObjectStatDto
{
    /// <summary>主门禁口径下的"影响订单"数 = 命中候选异常类型的去重 RelatedObjectCode 数；并行准备口径下保持 null。</summary>
    public int? ImpactedOrderCount { get; set; }

    /// <summary>并行准备口径下的"风险订单"数 = 命中候选异常类型的去重 RelatedObjectCode 数；主门禁口径下保持 null。</summary>
    public int? RiskOrderCount { get; set; }

    /// <summary>主要风险标题：候选异常中按 Severity(SERIOUS 优先) → CreatedAt(降序) 取首条 Title。无命中保持 null。</summary>
    public string? TopRiskTitle { get; set; }

    /// <summary>主要风险严重度：与 TopRiskTitle 来自同一条异常。无命中保持 null。</summary>
    public string? TopRiskSeverity { get; set; }
}

public class AdoS8OrderFlowStageAggregateDto
{
    public string OrderFlowCode { get; set; } = string.Empty;
    public string OrderFlowName { get; set; } = string.Empty;
    public decimal KpiAvgDays { get; set; }
    public decimal ActualAvgDays { get; set; }

    /// <summary>整数百分比（例如 59 / 96 / 85 / 89 / 96），不是 0.59 小数。</summary>
    public int OnTimeRate { get; set; }

    public int Green { get; set; }
    public int Yellow { get; set; }
    public int Red { get; set; }
    public int Pending { get; set; }
}

#endregion

#region 采购透视

public class AdoS8OrderFlowProcurementPivotQueryDto
{
    public string Scope { get; set; } = string.Empty;

    /// <summary>
    /// 订单编码 CSV（与产品设计 drawings API 对齐）。
    /// 例如：单订单 "SO-2026-001"；多订单 "SO-2026-001,SO-2026-002,SO-2026-006"。
    /// 与 axios 默认 brackets 序列化不兼容，统一用 CSV 字符串避免 ASP.NET Core List 绑定二义性。
    /// </summary>
    public string? OrderCodes { get; set; }
}

public class AdoS8OrderFlowProcurementPivotDto
{
    public string Scope { get; set; } = string.Empty;
    public List<AdoS8OrderFlowKeyMaterialDto> KeyMaterials { get; set; } = new();
    public List<AdoS8OrderFlowSupplierBreakdownDto> SupplierBreakdown { get; set; } = new();
    public List<AdoS8OrderFlowSpecBreakdownDto> SpecBreakdown { get; set; } = new();
    public Dictionary<string, List<AdoS8OrderFlowProcurementMatrixRowDto>> MatrixByMaterial { get; set; } = new();
}

public class AdoS8OrderFlowKeyMaterialDto
{
    public string MaterialCode { get; set; } = string.Empty;
    public decimal AvgCycleDays { get; set; }
    public string CycleStatus { get; set; } = string.Empty;
    public int? ImpactCount { get; set; }
    public decimal? KitRate { get; set; }
    public string ResultStatus { get; set; } = string.Empty;
}

public class AdoS8OrderFlowSupplierBreakdownDto
{
    public string MaterialCode { get; set; } = string.Empty;
    public string SupplierCode { get; set; } = string.Empty;
    public decimal AvgCycleDays { get; set; }
    public string Status { get; set; } = string.Empty;
}

public class AdoS8OrderFlowSpecBreakdownDto
{
    public string MaterialCode { get; set; } = string.Empty;
    public string SpecCode { get; set; } = string.Empty;
    public decimal AvgCycleDays { get; set; }
    public string Status { get; set; } = string.Empty;
}

public class AdoS8OrderFlowProcurementMatrixRowDto
{
    public string SupplierCode { get; set; } = string.Empty;
    public Dictionary<string, AdoS8OrderFlowProcurementMatrixCellDto> Cells { get; set; } = new();
}

public class AdoS8OrderFlowProcurementMatrixCellDto
{
    public decimal CycleDays { get; set; }
    public string Status { get; set; } = string.Empty;
}

#endregion

#region 关联异常

public class AdoS8OrderFlowRelatedExceptionQueryDto
{
    public string OrderCode { get; set; } = string.Empty;
    public string? OrderFlowCode { get; set; }
}

#endregion

#region 产品设计图号

/// <summary>
/// S8-ORDER-CHAIN-PRODUCT-DESIGN-DRAWING-PERSIST-1：产品设计图号查询入参。
/// orderCodes 为空 → 默认聚合全 20 单（scope=BASELINE_PPT）；
/// orderCodes 非空 → 仅命中订单范围聚合（scope=CURRENT_FILTERED）。
/// productType 仅过滤 drawings 列表，不改变 summary.categories 的"常规/非标/合计"三档结构。
/// </summary>
public class AdoS8OrderFlowProductDesignDrawingsQueryDto
{
    /// <summary>逗号分隔订单号；为空时默认全 20 单。</summary>
    public string? OrderCodes { get; set; }
    /// <summary>STANDARD / NON_STANDARD；为空时返回全量并保留三档汇总。</summary>
    public string? ProductType { get; set; }
}

/// <summary>查询条件回显，便于前端固定下钻状态。</summary>
public class AdoS8OrderFlowProductDesignFilterDto
{
    public List<string> OrderCodes { get; set; } = new();
    public string? ProductType { get; set; }
}

public class AdoS8OrderFlowProductDesignDrawingItemDto
{
    public string OrderCode { get; set; } = string.Empty;
    public string DrawingNo { get; set; } = string.Empty;
    /// <summary>STANDARD / NON_STANDARD。</summary>
    public string ProductType { get; set; } = string.Empty;
    /// <summary>责任单位/岗位（研发中心 / 结构设计组 / 电气设计组 / 工艺设计组 / 设计审核组）。</summary>
    public string ResponsiblePerson { get; set; } = string.Empty;
    public DateTime PlannedStartDate { get; set; }
    public DateTime PlannedEndDate { get; set; }
    public DateTime? ActualStartDate { get; set; }
    public DateTime? ActualEndDate { get; set; }
    public decimal KpiDays { get; set; }
    public decimal? ActualDays { get; set; }
    public bool IsAchieved { get; set; }
    /// <summary>green / yellow / red / pending。</summary>
    public string Status { get; set; } = string.Empty;
    /// <summary>该图号对应台数；台数/占比/加权达成率三种口径的唯一来源。</summary>
    public int ProductQuantity { get; set; }
}

public class AdoS8OrderFlowProductDesignOverallSummaryDto
{
    public int DrawingCount { get; set; }
    public int TotalQuantity { get; set; }
    public decimal KpiDays { get; set; }
    /// <summary>图号 actual_days 算术平均（非加权），保留小数原值，由前端格式化为 2 位。</summary>
    public decimal AvgActualDays { get; set; }
    /// <summary>按 product_quantity 加权达标率，小数 0~1，由前端格式化为整数百分比。</summary>
    public decimal AchievementRate { get; set; }
}

public class AdoS8OrderFlowProductDesignCategorySummaryDto
{
    /// <summary>STANDARD / NON_STANDARD / TOTAL。</summary>
    public string ProductType { get; set; } = string.Empty;
    public string Name { get; set; } = string.Empty;
    public int DrawingCount { get; set; }
    public int TotalQuantity { get; set; }
    /// <summary>product_quantity 占合计比例，小数 0~1，由前端格式化为 1 位百分比。</summary>
    public decimal Ratio { get; set; }
    /// <summary>S8-ORDER-CHAIN-PRODUCT-DESIGN-PPT-STATIC-AND-SINGLE-ORDER-ALIGN-1：常规/合计返回 null，前端展示 --；非标返回真实平均设计周期。</summary>
    public decimal? AvgActualDays { get; set; }
    /// <summary>常规/合计返回 null，前端展示 --；非标返回 3 天 PRODUCT_DESIGN 阶段 KPI。</summary>
    public decimal? KpiDays { get; set; }
    /// <summary>常规/合计返回 null，前端展示 --；非标返回加权达成率。</summary>
    public decimal? AchievementRate { get; set; }
    /// <summary>green / yellow / red / ''（空 = 无数据，前端展示 --）。由 achievement_rate 分档得出，不再二次判定。</summary>
    public string Status { get; set; } = string.Empty;
}

public class AdoS8OrderFlowProductDesignSummaryDto
{
    public AdoS8OrderFlowProductDesignOverallSummaryDto Overall { get; set; } = new();
    public List<AdoS8OrderFlowProductDesignCategorySummaryDto> Categories { get; set; } = new();
}

public class AdoS8OrderFlowProductDesignDrawingsDto
{
    /// <summary>BASELINE_PPT（默认全 20 单）/ CURRENT_FILTERED（命中订单子集）。</summary>
    public string Scope { get; set; } = string.Empty;
    public AdoS8OrderFlowProductDesignFilterDto Filter { get; set; } = new();
    public AdoS8OrderFlowProductDesignSummaryDto Summary { get; set; } = new();
    public List<AdoS8OrderFlowProductDesignDrawingItemDto> Drawings { get; set; } = new();
}

#endregion

#region 本体生产（设备制造） — S8-ORDER-CHAIN-BODY-PRODUCTION-ORDER-LEVEL-SEED-FIX-1

/// <summary>
/// 本体生产「工序明细 / 损失因素 / 操作员表现」三表透视查询入参。
/// orderCodes CSV：与产品设计 drawings API、采购透视 API 对齐，避免 axios brackets 与 ASP.NET Core List 绑定二义性。
/// scope=BASELINE_PPT 时 orderCodes 忽略；scope=CURRENT_FILTERED 时 orderCodes 为空返回空骨架（不静默 fallback baseline）。
/// </summary>
public class AdoS8OrderFlowManufacturingPivotQueryDto
{
    /// <summary>BASELINE_PPT | CURRENT_FILTERED</summary>
    public string Scope { get; set; } = string.Empty;
    /// <summary>逗号分隔订单号；scope=CURRENT_FILTERED 时使用。</summary>
    public string? OrderCodes { get; set; }
}

/// <summary>
/// 工序明细行：P10 / P20 / P30 / P40 / TOTAL。
/// pi_days / actual_days 保留 decimal(6,3) 精度；plan_qty 在 TOTAL 行为 null。
/// achievement_rate 在 TOTAL 行 baseline 来自 fixture（0.9000）、订单级按 plan_qty 加权平均；其它行 baseline 复用。
/// </summary>
public class AdoS8OrderFlowManufacturingProcessDto
{
    public string ProcessCode { get; set; } = string.Empty;
    public string ProcessName { get; set; } = string.Empty;
    public decimal PiDays { get; set; }
    public decimal ActualDays { get; set; }
    public string CycleStatus { get; set; } = string.Empty;
    public int? PlanQty { get; set; }
    public decimal? AchievementRate { get; set; }
    public string AchievementStatus { get; set; } = string.Empty;
    public int SortNo { get; set; }
}

/// <summary>损失因素行：MATERIAL / EQUIPMENT / QUALITY / EFFICIENCY / SUBTOTAL。</summary>
public class AdoS8OrderFlowManufacturingLossFactorDto
{
    public string FactorCode { get; set; } = string.Empty;
    public string FactorName { get; set; } = string.Empty;
    public int? CountValue { get; set; }
    public decimal? RatioPct { get; set; }
    public decimal? LossHours { get; set; }
    public int SortNo { get; set; }
}

/// <summary>操作员表现行：OP_ZHANG / OP_LI / OP_WANG。</summary>
public class AdoS8OrderFlowManufacturingOperatorDto
{
    public string OperatorCode { get; set; } = string.Empty;
    public string OperatorName { get; set; } = string.Empty;
    public decimal AvgHours { get; set; }
    public string Status { get; set; } = string.Empty;
    public int SortNo { get; set; }
}

/// <summary>本体生产透视聚合结果：scope + 工序 / 损失 / 操作员 三组。</summary>
public class AdoS8OrderFlowManufacturingPivotDto
{
    /// <summary>BASELINE_PPT | CURRENT_FILTERED</summary>
    public string Scope { get; set; } = string.Empty;
    public List<AdoS8OrderFlowManufacturingProcessDto> Processes { get; set; } = new();
    public List<AdoS8OrderFlowManufacturingLossFactorDto> LossFactors { get; set; } = new();
    public List<AdoS8OrderFlowManufacturingOperatorDto> Operators { get; set; } = new();
}

#endregion

#region 总装发货 — S8-ORDER-CHAIN-ASSEMBLY-DELIVERY-DATA-LINEAGE-AUDIT-1

/// <summary>
/// 总装发货「主门禁里程碑 / 并行准备」透视查询入参。
/// orderCodes CSV：与本体生产 / 产品设计 / 采购透视 API 对齐，规避 axios brackets 与 ASP.NET Core List 绑定二义性。
/// scope=BASELINE_PPT 时 orderCodes 忽略；scope=CURRENT_FILTERED 时 orderCodes 为空返回空骨架（不静默 fallback baseline）。
/// 与既有 aggregate.finalAssemblyCollabSummary 通道独立：本 API 提供门禁 KPI / 实际 / 偏差 / 齐套率，
/// aggregate 仍保留异常派生通道作为补充。
/// </summary>
public class AdoS8FinalAssemblyPivotQueryDto
{
    /// <summary>BASELINE_PPT | CURRENT_FILTERED</summary>
    public string Scope { get; set; } = string.Empty;
    /// <summary>逗号分隔订单号；scope=CURRENT_FILTERED 时使用。</summary>
    public string? OrderCodes { get; set; }
}

/// <summary>
/// 主门禁里程碑行：ASSEMBLY_COMPLETION / QUALITY_RELEASE / PACKAGING_COMPLETION / GOODS_HANDOVER / SHIPMENT_CONFIRMATION。
/// planned_offset_days 为累计里程碑（0.6/1.2/1.8/2.4/3.0）；末位 SHIPMENT_CONFIRMATION.actual_offset_days 守恒为 stage.actual_days。
/// pending 单不进入聚合结果。
/// </summary>
public class AdoS8FinalAssemblyGateDto
{
    public string GateCode { get; set; } = string.Empty;
    public string GateName { get; set; } = string.Empty;
    public decimal PlannedOffsetDays { get; set; }
    public decimal? ActualOffsetDays { get; set; }
    public decimal? VarianceDays { get; set; }
    public string Status { get; set; } = string.Empty;
    public int? ImpactedOrderCount { get; set; }
    public int? RiskOrderCount { get; set; }
    public string? TopRiskType { get; set; }
    public string? TopRiskLabel { get; set; }
    public string? OwnerSideText { get; set; }
    public int SortNo { get; set; }
}

/// <summary>
/// 并行准备行：PACKAGING_MATERIAL_PREP / LABEL_DOC_PREP / SHIPPING_PLAN / SHIPPING_DOC_PREP。
/// kitting_rate 取值 0.0000~1.0000；status 按 ≥0.95 green / ≥0.85 yellow / 否则 red 派生（seed 时固化，运行期不重判）。
/// </summary>
public class AdoS8FinalAssemblyParallelDto
{
    public string PrepCode { get; set; } = string.Empty;
    public string PrepName { get; set; } = string.Empty;
    public decimal? KittingRate { get; set; }
    public string Status { get; set; } = string.Empty;
    public int? ImpactedOrderCount { get; set; }
    public int? RiskOrderCount { get; set; }
    public string? TopRiskType { get; set; }
    public string? TopRiskLabel { get; set; }
    public string? OwnerSideText { get; set; }
    public int SortNo { get; set; }
}

/// <summary>总装发货透视聚合结果：scope + 5 门禁 + 4 并行准备。</summary>
public class AdoS8FinalAssemblyPivotDto
{
    /// <summary>BASELINE_PPT | CURRENT_FILTERED</summary>
    public string Scope { get; set; } = string.Empty;
    public List<AdoS8FinalAssemblyGateDto> Gates { get; set; } = new();
    public List<AdoS8FinalAssemblyParallelDto> ParallelPreps { get; set; } = new();
}

#endregion