AiDOPWarehouse/server/Plugins/Admin.NET.Plugin.AiDOP/Manufacturing/Dto/S6ProductionInstructionDto.cs

namespace Admin.NET.Plugin.AiDOP.Manufacturing.Dto;

/// <summary>
/// S6 生产指令单列表 查询入参（只读）。
/// 数据源：数据中台标准层 mdp_std_work_order_schedule（S2 从 WorkOrdMaster 贴源标准化，Specification 由 ItemMaster.Descr1 enrich）。
/// 租户只来自认证后 JWT，忽略前端传入的任何 tenantId（见 AidopTenantScope.ResolveOrThrow）。
/// </summary>
public class S6ProductionInstructionInput
{
    /// <summary>页码（从 1 开始）</summary>
    public int Page { get; set; } = 1;

    /// <summary>每页条数</summary>
    public int PageSize { get; set; } = 10;

    /// <summary>工单编号（work_order，模糊匹配）</summary>
    public string? WorkOrderNo { get; set; }

    /// <summary>批次号（lot_serial，模糊匹配）</summary>
    public string? LotSerial { get; set; }

    /// <summary>物料编码（item_code，模糊匹配）</summary>
    public string? ItemCode { get; set; }

    /// <summary>规格型号（specification，模糊匹配）</summary>
    public string? Specification { get; set; }

    /// <summary>生产状态（status，精确匹配）</summary>
    public string? Status { get; set; }

    /// <summary>开工日期起（order_date &gt;=，含当日）</summary>
    public string? OrderDateStart { get; set; }

    /// <summary>开工日期止（order_date &lt;=，含当日）</summary>
    public string? OrderDateEnd { get; set; }
}

/// <summary>
/// S6 生产指令单列表 行（只读）。字段对齐前端列 prop（camelCase）。
/// 全部来自 mdp_std_work_order_schedule；不暴露 tenant_id / sync 元数据 / 内部技术字段。
/// </summary>
public class S6ProductionInstructionRow
{
    /// <summary>主键 id（mdp_std_work_order_schedule.id，仅作前端 row-key）</summary>
    public long Id { get; set; }

    /// <summary>工单编号（work_order ← WorkOrdMaster.WorkOrd）</summary>
    public string? WorkOrderNo { get; set; }

    /// <summary>批次号（lot_serial ← WorkOrdMaster.LotSerial）</summary>
    public string? LotSerial { get; set; }

    /// <summary>物料编码（item_code ← WorkOrdMaster.ItemNum）</summary>
    public string? ItemCode { get; set; }

    /// <summary>物料名称（item_name ← WorkOrdMaster.ItemName）</summary>
    public string? ItemName { get; set; }

    /// <summary>规格型号（specification ← ItemMaster.Descr1，S2 转换层 enrich）</summary>
    public string? Specification { get; set; }

    /// <summary>图纸号（drawing_no ← WorkOrdMaster.Drawing）</summary>
    public string? DrawingNo { get; set; }

    /// <summary>项目（project ← WorkOrdMaster.Project）</summary>
    public string? Project { get; set; }

    /// <summary>订单数量（qty_ordered ← WorkOrdMaster.QtyOrded）</summary>
    public decimal? OrderQty { get; set; }

    /// <summary>报工/完成数量（qty_completed ← WorkOrdMaster.QtyCompleted）</summary>
    public decimal? CompletedQty { get; set; }

    /// <summary>开工日期（order_date ← WorkOrdMaster.OrdDate）</summary>
    public DateTime? OrderDate { get; set; }

    /// <summary>计划完成日期（due_date ← WorkOrdMaster.DueDate）</summary>
    public DateTime? DueDate { get; set; }

    /// <summary>生产状态（status ← WorkOrdMaster.Status，可信源文本原样透出）</summary>
    public string? Status { get; set; }

    /// <summary>工单类型（work_order_type ← WorkOrdMaster.WoTyped）</summary>
    public string? WorkOrderType { get; set; }

    // ── Phase 1E 列表状态（LEFT JOIN process_inspection_bill/result/flow；无单据则为空）──
    /// <summary>过程检验单 id（null=尚未生成检验单）。</summary>
    public long? BillId { get; set; }
    /// <summary>检验结果状态（NOT_STARTED/IN_PROGRESS/COMPLETED）。</summary>
    public string? InspectionResultStatus { get; set; }
    /// <summary>整单质量结果（PASS/FAIL/PENDING/INVALID）。</summary>
    public string? OverallResult { get; set; }
    /// <summary>审核流实例状态原始值（0草稿/1运行/2通过/3驳回/4撤回/5终止；null=未发起）。</summary>
    public int? FlowStatusRaw { get; set; }
}