AiDOPWarehouse/server/Plugins/Admin.NET.Plugin.AiDOP/SeedData/S8OrderFlowProductDesignDrawingSeedData.cs

using Admin.NET.Plugin.AiDOP.Entity.S8.OrderFlow;

namespace Admin.NET.Plugin.AiDOP.SeedData;

/// <summary>
/// S8-ORDER-CHAIN-PRODUCT-DESIGN-DRAWING-PERSIST-1：S8 订单链路产品设计阶段基准业务初始化数据种子。
/// 20 单 × 63 图号；严格满足七项不变量约束：
///   1) COUNT(DISTINCT drawing_no) = 63；STANDARD=52 / NON_STANDARD=11
///   2) SUM(product_quantity ALL) = 382；STANDARD=357 / NON_STANDARD=25
///   3) AVG(actual_days WHERE product_type='STANDARD')     落在 [1.17, 1.21]
///   4) AVG(actual_days WHERE product_type='NON_STANDARD') 落在 [9.25, 9.31]
///   5) AVG(actual_days ALL) ≈ 2.60 天
///   6) SUM(product_quantity WHERE is_achieved=false) 落在 [14, 16]
///   7) 加权达成率 = 达标 quantity / 总 quantity ≈ 96%
/// 图号编码：常规 D-{OrderCode}-G{NN}；非标 D-{OrderCode}-X{NN}（绑定 SO-2026-001..020 真实 OrderCode）。
/// 责任单位/岗位 5 选 1：研发中心 / 结构设计组 / 电气设计组 / 工艺设计组 / 设计审核组；不引入个人姓名。
/// </summary>
[IncreSeed]
public class S8OrderFlowProductDesignDrawingSeedData
    : ISqlSugarEntitySeedData<AdoS8OrderFlowProductDesignDrawing>
{
    public IEnumerable<AdoS8OrderFlowProductDesignDrawing> HasData()
        => S8OrderFlowProductDesignDrawingDataset.BuildDrawings();
}

internal static class S8OrderFlowProductDesignDrawingDataset
{
    /// <summary>图号 id 基址（与其他 S8 种子号段隔离）。</summary>
    internal const long IdBase = 1329909130000L;

    internal const string ProductTypeStandard = "STANDARD";
    internal const string ProductTypeNonStandard = "NON_STANDARD";

    /// <summary>常规产品 KPI（天）。</summary>
    internal const decimal StandardKpiDays = 3.00m;

    /// <summary>非标产品 KPI（天）。业务允许非标设计周期更长，落库为图号粒度独立 KPI。</summary>
    internal const decimal NonStandardKpiDays = 12.00m;

    /// <summary>责任单位/岗位（5 选 1，按 sort_no 循环分配；不使用个人姓名）。</summary>
    private static readonly string[] ResponsibleUnits =
    {
        "研发中心",
        "结构设计组",
        "电气设计组",
        "工艺设计组",
        "设计审核组",
    };

    /// <summary>
    /// 每订单 (常规图号数, 非标图号数)。20 行合计 52 / 11；其中 4 单 4 图、16 单 3 图。
    /// 非标集中在大客户、P1 优先级与 in_progress 订单上，与业务直觉一致。
    /// </summary>
    private static readonly (int StdCount, int NonStdCount)[] PerOrderConfig =
    {
        // SO-2026-001..005
        (3, 1), (3, 1), (3, 1), (3, 0), (3, 0),
        // SO-2026-006..010
        (2, 1), (2, 1), (2, 1), (3, 0), (3, 0),
        // SO-2026-011..015
        (3, 0), (2, 1), (3, 0), (3, 0), (3, 0),
        // SO-2026-016..020
        (3, 0), (2, 1), (2, 1), (2, 1), (2, 1),
    };

    /// <summary>52 张常规图号 spec：合计 actual_days=61.88、qty=357、1 张超期 (qty=3)。</summary>
    private static readonly DrawingSpec[] StandardSequence = BuildStandardSequence();

    /// <summary>11 张非标图号 spec：合计 actual_days=102.08、qty=25、2 张超期 (qty=6 each)。</summary>
    private static readonly DrawingSpec[] NonStandardSequence = BuildNonStandardSequence();

    /// <summary>单张图号的回卷规格：actual_days / quantity / is_achieved / status。</summary>
    internal readonly record struct DrawingSpec(decimal ActualDays, int Quantity, bool IsAchieved, string Status);

    private static DrawingSpec[] BuildStandardSequence()
    {
        // 52 张分布：24×(1.13, qty=7) + 24×(1.12, qty=7) + 2×(1.13, qty=6) + 1×(1.12, qty=6) + 1×(4.50, qty=3, red)
        // actual_days 合计 = 24×1.13 + 24×1.12 + 2×1.13 + 1×1.12 + 4.50
        //                  = 27.12 + 26.88 + 2.26 + 1.12 + 4.50 = 61.88  → avg 1.190 (在 [1.17, 1.21])
        // quantity 合计    = 24×7 + 24×7 + 2×6 + 1×6 + 3 = 168 + 168 + 12 + 6 + 3 = 357
        var seq = new DrawingSpec[52];
        for (var i = 0; i < 24; i++) seq[i] = new DrawingSpec(1.13m, 7, true, "green");
        for (var i = 24; i < 48; i++) seq[i] = new DrawingSpec(1.12m, 7, true, "green");
        seq[48] = new DrawingSpec(1.13m, 6, true, "green");
        seq[49] = new DrawingSpec(1.13m, 6, true, "green");
        seq[50] = new DrawingSpec(1.12m, 6, true, "green");
        // 唯一一张超期常规图号：actual=4.50 > kpi=3 → (4.5-3)/3 = 0.50 > 0.20 → red
        seq[51] = new DrawingSpec(4.50m, 3, false, "red");
        return seq;
    }

    private static DrawingSpec[] BuildNonStandardSequence()
    {
        // 11 张分布：5×(8.34, qty=1) + 4×(8.34, qty=2) + 2×(13.51, qty=6, yellow)
        // actual_days 合计 = 9×8.34 + 2×13.51 = 75.06 + 27.02 = 102.08 → avg 9.28 (在 [9.25, 9.31])
        // quantity 合计    = 5×1 + 4×2 + 2×6 = 5 + 8 + 12 = 25
        var seq = new DrawingSpec[11];
        for (var i = 0; i < 5; i++) seq[i] = new DrawingSpec(8.34m, 1, true, "green");
        for (var i = 5; i < 9; i++) seq[i] = new DrawingSpec(8.34m, 2, true, "green");
        // 两张超期非标图号：actual=13.51 > kpi=12 → (13.51-12)/12 ≈ 0.126 ≤ 0.20 → yellow
        seq[9] = new DrawingSpec(13.51m, 6, false, "yellow");
        seq[10] = new DrawingSpec(13.51m, 6, false, "yellow");
        return seq;
    }

    public static IEnumerable<AdoS8OrderFlowProductDesignDrawing> BuildDrawings()
    {
        int stdCursor = 0, nonStdCursor = 0;
        long seq = 0;

        for (var i = 0; i < S8OrderFlowDataset.Specs.Length; i++)
        {
            var orderSpec = S8OrderFlowDataset.Specs[i];
            var (stdN, nonStdN) = PerOrderConfig[i];

            // 图号粒度计划开始 = release_at + 5 天（ORDER_REVIEW KPI=5 天结束后进入 PRODUCT_DESIGN）。
            // 所有图号同基准开始，actualEnd 由 actualDays 派生，保证 actualEnd - actualStart 严格等于 actualDays。
            var plannedStart = S8OrderFlowDataset.ReleaseBase.AddDays(5);

            var sortNo = 0;

            for (var g = 0; g < stdN; g++)
            {
                sortNo++;
                var spec = StandardSequence[stdCursor++];
                yield return BuildDrawing(
                    seq: ++seq,
                    orderSpec: orderSpec,
                    sortNo: sortNo,
                    drawingNo: $"D-{orderSpec.OrderCode}-G{g + 1:D2}",
                    productType: ProductTypeStandard,
                    kpiDays: StandardKpiDays,
                    plannedStart: plannedStart,
                    spec: spec);
            }

            for (var x = 0; x < nonStdN; x++)
            {
                sortNo++;
                var spec = NonStandardSequence[nonStdCursor++];
                yield return BuildDrawing(
                    seq: ++seq,
                    orderSpec: orderSpec,
                    sortNo: sortNo,
                    drawingNo: $"D-{orderSpec.OrderCode}-X{x + 1:D2}",
                    productType: ProductTypeNonStandard,
                    kpiDays: NonStandardKpiDays,
                    plannedStart: plannedStart,
                    spec: spec);
            }
        }
    }

    private static AdoS8OrderFlowProductDesignDrawing BuildDrawing(
        long seq,
        S8OrderFlowDataset.OrderSpec orderSpec,
        int sortNo,
        string drawingNo,
        string productType,
        decimal kpiDays,
        DateTime plannedStart,
        DrawingSpec spec)
    {
        var plannedEnd = plannedStart.AddDays((double)kpiDays);
        var actualStart = plannedStart;
        var actualEnd = actualStart.AddDays((double)spec.ActualDays);
        var responsible = ResponsibleUnits[(sortNo - 1) % ResponsibleUnits.Length];

        return new AdoS8OrderFlowProductDesignDrawing
        {
            Id = IdBase + seq,
            TenantId = 1,
            FactoryId = 1,
            OrderCode = orderSpec.OrderCode,
            DrawingNo = drawingNo,
            ProductType = productType,
            ProductQuantity = spec.Quantity,
            ResponsiblePerson = responsible,
            PlannedStartDate = plannedStart,
            PlannedEndDate = plannedEnd,
            ActualStartDate = actualStart,
            ActualEndDate = actualEnd,
            KpiDays = kpiDays,
            ActualDays = spec.ActualDays,
            IsAchieved = spec.IsAchieved,
            Status = spec.Status,
            SortNo = sortNo,
            IsDeleted = false,
            CreateTime = S8OrderFlowDataset.CreatedAt,
            UpdateTime = null,
        };
    }
}