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

namespace Admin.NET.Plugin.AiDOP;

/// <summary>
/// S8 大屏卡片配置基线种子（灌入 ado_s8_dashboard_cell_config）。
/// 全局基线：tenant_id=0 / factory_id=0；覆盖 4 个大屏的全部稳定锚点卡片。
/// 依赖 S8ExceptionTypeSeedData：EXCEPTION_TYPE 绑定的 exception_type_code 必须先存在。
/// G-09 一期：补齐 UI 配置字段（icon/layout_area/display_mode/remark），
/// 让新装环境跑 SeedData 即可获得完整渲染配置；现有环境通过手工 INSERT SQL 灌入同样数据。
/// G-09 三期 F-CLEAN-1：show_in_sidebar 当前不参与 cell→layout 派生，SeedData 不再写入；Entity/DB 列保留。
/// </summary>
[IncreSeed]
public class S8DashboardCellConfigSeedData : ISqlSugarEntitySeedData<Entity.S8.AdoS8DashboardCellConfig>
{
    public IEnumerable<Entity.S8.AdoS8DashboardCellConfig> HasData()
    {
        var ct = DateTime.Parse("2026-04-18 00:00:00");
        long seq = 1329908200001L;
        var list = new List<Entity.S8.AdoS8DashboardCellConfig>();

        // ── OVERVIEW 页面 ──
        // S1-S7 模块卡（7 张，CUSTOM 聚合，layout_area=MODULES, display_mode=STAGE_CARD）
        // S8-DASHBOARD-P0-CATEGORY-SEED-FIX-1：标题与侧栏菜单业务名 + S8ModuleCode.Label 对齐。
        var overviewModules = new (string code, string title, string icon)[]
        {
            ("S1", "S1 产销协同", "Checked"),
            ("S2", "S2 制造协同", "TrendCharts"),
            ("S3", "S3 供应协同", "ShoppingBag"),
            ("S4", "S4 采购执行", "Tools"),
            ("S5", "S5 物料仓储", "DataAnalysis"),
            ("S6", "S6 生产执行", "Box"),
            ("S7", "S7 成品仓储", "Van"),
        };
        var sort = 100;
        foreach (var (m, title, icon) in overviewModules)
            list.Add(Custom(seq++, "OVERVIEW", $"OVERVIEW_{m}", title, "OPEN_COUNT", "LAST_24H", sort++, ct,
                icon: icon, layoutArea: "MODULES", displayMode: "STAGE_CARD"));

        // 部门效率聚合
        list.Add(Aggregate(seq++, "OVERVIEW", "OVERVIEW_BY_DEPT", "部门异常聚合", "ALL", "OPEN_COUNT", "LAST_24H", "OWNER", sort++, ct,
            icon: "DataAnalysis", layoutArea: "SIDEBAR", displayMode: "DEPT_CLUSTER"));

        // 类别异常卡（5 张，按场景聚合，layout_area=ANALYSIS, display_mode=CATEGORY_CARD）
        var overviewCats = new (string code, string title, string icon)[]
        {
            ("OVERVIEW_CAT_ORDER_REVIEW",     "订单评审异常", "DataAnalysis"),
            ("OVERVIEW_CAT_PRODUCT_DESIGN",   "产品设计异常", "ShoppingBag"),
            ("OVERVIEW_CAT_MATERIAL_PURCHASE","物料采购异常", "Tools"),
            ("OVERVIEW_CAT_BODY_PRODUCTION",  "主体生产异常", "Van"),
            ("OVERVIEW_CAT_FINAL_ASSEMBLY",   "总装交付异常", "Van"),
        };
        foreach (var (code, title, icon) in overviewCats)
            list.Add(Aggregate(seq++, "OVERVIEW", code, title, "ALL", "FREQUENCY", "LAST_7D", "OWNER", sort++, ct,
                icon: icon, layoutArea: "ANALYSIS", displayMode: "CATEGORY_CARD"));

        // 整体响应效能 + 状态统计条（CUSTOM，无 icon）
        list.Add(Custom(seq++, "OVERVIEW", "OVERVIEW_OVERALL_EFFICIENCY", "整体响应效能", "CLOSE_RATE", "LAST_7D", sort++, ct,
            icon: null, layoutArea: "SIDEBAR", displayMode: "CUSTOM"));
        list.Add(Custom(seq++, "OVERVIEW", "OVERVIEW_STATUS_BAR",         "状态统计条",   "OPEN_COUNT", "TODAY",   sort++, ct,
            icon: null, layoutArea: "ANALYSIS", displayMode: "CUSTOM"));

        // ── DELIVERY 页面 ──
        // S8-DASHBOARD-P0-CATEGORY-SEED-FIX-1：模块卡标题与 S8ModuleCode.Label 对齐。
        sort = 100;
        list.Add(Custom(seq++, "DELIVERY", "DELIVERY_S1", "S1 产销协同", "OPEN_COUNT", "LAST_24H", sort++, ct,
            icon: "Checked", layoutArea: "MODULES", displayMode: "STAGE_CARD"));
        list.Add(Custom(seq++, "DELIVERY", "DELIVERY_S7", "S7 成品仓储", "OPEN_COUNT", "LAST_24H", sort++, ct,
            icon: "Van", layoutArea: "MODULES", displayMode: "STAGE_CARD"));

        // 异常类型卡（3 张：sidebar compact，OPEN_COUNT 总数）
        list.Add(ExceptionType(seq++, "DELIVERY", "DELIVERY_ANOMALY_ORDER_CHANGE",   "订单变更",     "ORDER_CHANGE",     "OPEN_COUNT", "LAST_24H", sort++, ct,
            icon: "Checked", layoutArea: "SIDEBAR", displayMode: "CATEGORY_COMPACT"));
        list.Add(ExceptionType(seq++, "DELIVERY", "DELIVERY_ANOMALY_DELIVERY_DELAY", "交期延迟",     "DELIVERY_DELAY",   "OPEN_COUNT", "LAST_24H", sort++, ct,
            icon: "Van",     layoutArea: "SIDEBAR", displayMode: "CATEGORY_COMPACT"));
        list.Add(ExceptionType(seq++, "DELIVERY", "DELIVERY_ANOMALY_STOCK_PENDING",  "入库待发",     "PENDING_SHIPMENT", "OPEN_COUNT", "LAST_24H", sort++, ct,
            icon: "Van",     layoutArea: "SIDEBAR", displayMode: "CATEGORY_COMPACT"));

        // 异常多维分析卡（3 张：analysis 大卡，FREQUENCY/AVG_DURATION/CLOSE_RATE）
        list.Add(ExceptionType(seq++, "DELIVERY", "DELIVERY_CAT_ORDER_CHANGE",   "订单变更多维分析",   "ORDER_CHANGE",     "FREQUENCY",    "LAST_7D", sort++, ct,
            icon: "Checked", layoutArea: "ANALYSIS", displayMode: "CATEGORY_CARD"));
        list.Add(ExceptionType(seq++, "DELIVERY", "DELIVERY_CAT_DELIVERY_DELAY", "交期延迟多维分析",   "DELIVERY_DELAY",   "AVG_DURATION", "LAST_7D", sort++, ct,
            icon: "Van",     layoutArea: "ANALYSIS", displayMode: "CATEGORY_CARD"));
        list.Add(ExceptionType(seq++, "DELIVERY", "DELIVERY_CAT_STOCK_PENDING",  "入库待发多维分析",   "PENDING_SHIPMENT", "CLOSE_RATE",   "LAST_7D", sort++, ct,
            icon: "Van",     layoutArea: "ANALYSIS", displayMode: "CATEGORY_CARD"));

        list.Add(Custom(seq++, "DELIVERY", "DELIVERY_STATUS_BAR", "状态统计条", "OPEN_COUNT", "TODAY", sort++, ct,
            icon: null, layoutArea: "ANALYSIS", displayMode: "CUSTOM"));

        // ── PRODUCTION 页面 ──
        // S8-DASHBOARD-P0-CATEGORY-SEED-FIX-1：模块卡标题与 S8ModuleCode.Label 对齐。
        sort = 100;
        list.Add(Custom(seq++, "PRODUCTION", "PRODUCTION_S2", "S2 制造协同", "OPEN_COUNT", "LAST_24H", sort++, ct,
            icon: "TrendCharts", layoutArea: "MODULES", displayMode: "STAGE_CARD"));
        list.Add(Custom(seq++, "PRODUCTION", "PRODUCTION_S6", "S6 生产执行", "OPEN_COUNT", "LAST_24H", sort++, ct,
            icon: "Box",         layoutArea: "MODULES", displayMode: "STAGE_CARD"));

        list.Add(ExceptionType(seq++, "PRODUCTION", "PRODUCTION_ANOMALY_EQUIPMENT_FAULT", "设备异常", "EQUIP_FAULT",       "OPEN_COUNT", "LAST_24H", sort++, ct,
            icon: "Tools",       layoutArea: "SIDEBAR", displayMode: "CATEGORY_COMPACT"));
        // S8-DEPRECATED-EXCEPTION-TYPE-MIGRATE-1：MATERIAL_SHORTAGE→MFG_MATERIAL_ABNORMAL / QUALITY_DEFECT→MFG_QUALITY_ABNORMAL。
        list.Add(ExceptionType(seq++, "PRODUCTION", "PRODUCTION_ANOMALY_MATERIAL_FAULT",  "物料异常", "MFG_MATERIAL_ABNORMAL", "OPEN_COUNT", "LAST_24H", sort++, ct,
            icon: "Box",         layoutArea: "SIDEBAR", displayMode: "CATEGORY_COMPACT"));
        list.Add(ExceptionType(seq++, "PRODUCTION", "PRODUCTION_ANOMALY_QUALITY_FAULT",   "质量异常", "MFG_QUALITY_ABNORMAL",  "OPEN_COUNT", "LAST_24H", sort++, ct,
            icon: "TrendCharts", layoutArea: "SIDEBAR", displayMode: "CATEGORY_COMPACT"));

        list.Add(ExceptionType(seq++, "PRODUCTION", "PRODUCTION_CAT_EQUIPMENT_FAULT", "设备异常多维分析", "EQUIP_FAULT",            "FREQUENCY",    "LAST_7D", sort++, ct,
            icon: "Tools",       layoutArea: "ANALYSIS", displayMode: "CATEGORY_CARD"));
        list.Add(ExceptionType(seq++, "PRODUCTION", "PRODUCTION_CAT_MATERIAL_FAULT",  "物料异常多维分析", "MFG_MATERIAL_ABNORMAL", "AVG_DURATION", "LAST_7D", sort++, ct,
            icon: "Box",         layoutArea: "ANALYSIS", displayMode: "CATEGORY_CARD"));
        list.Add(ExceptionType(seq++, "PRODUCTION", "PRODUCTION_CAT_QUALITY_FAULT",   "质量异常多维分析", "MFG_QUALITY_ABNORMAL",  "CLOSE_RATE",   "LAST_7D", sort++, ct,
            icon: "TrendCharts", layoutArea: "ANALYSIS", displayMode: "CATEGORY_CARD"));

        list.Add(Custom(seq++, "PRODUCTION", "PRODUCTION_STATUS_BAR", "状态统计条", "OPEN_COUNT", "TODAY", sort++, ct,
            icon: null, layoutArea: "ANALYSIS", displayMode: "CUSTOM"));

        // ── SUPPLY 页面 ──
        // S8-DASHBOARD-P0-CATEGORY-SEED-FIX-1：模块卡标题与 S8ModuleCode.Label 对齐。
        sort = 100;
        list.Add(Custom(seq++, "SUPPLY", "SUPPLY_S3", "S3 供应协同", "OPEN_COUNT", "LAST_24H", sort++, ct,
            icon: "ShoppingBag",  layoutArea: "MODULES", displayMode: "STAGE_CARD"));
        list.Add(Custom(seq++, "SUPPLY", "SUPPLY_S4", "S4 采购执行", "OPEN_COUNT", "LAST_24H", sort++, ct,
            icon: "Tools",        layoutArea: "MODULES", displayMode: "STAGE_CARD"));
        list.Add(Custom(seq++, "SUPPLY", "SUPPLY_S5", "S5 物料仓储", "OPEN_COUNT", "LAST_24H", sort++, ct,
            icon: "DataAnalysis", layoutArea: "MODULES", displayMode: "STAGE_CARD"));

        // 供应域 7 类异常：类型卡（sidebar） + 分析卡（analysis）
        var supplyTypes = new (string typeCode, string anchor, string title, string icon)[]
        {
            ("SUPPLIER_ETA_ISSUE",  "SUPPLIER_REPLY_DELAY",  "供应商回复交期异常", "ShoppingBag"),
            ("SUPPLIER_SHIP_ISSUE", "SUPPLIER_SHIP_FAULT",   "供应商发货异常",     "Van"),
            // S8-DEPRECATED-EXCEPTION-TYPE-MIGRATE-1：WH_INBOUND_ISSUE→WAREHOUSE_RECEIPT_ABNORMAL /
            //   WH_KIT_ISSUE→WORK_ORDER_KITTING_ABNORMAL / WH_ISSUE_OUT_ISSUE→WORK_ORDER_ISSUE_ABNORMAL。
            ("WAREHOUSE_RECEIPT_ABNORMAL",   "WAREHOUSE_RECEIPT",     "仓库收货异常",       "Box"),
            ("IQC_ISSUE",                    "IQC_INSPECTION",        "IQC 检验异常",       "DataAnalysis"),
            ("WH_PUTAWAY_ISSUE",             "WAREHOUSE_SHELVING",    "仓库上架入库异常",   "Document"),
            ("WORK_ORDER_KITTING_ABNORMAL",  "WORK_ORDER_PREPARE",    "工单备料异常",       "Promotion"),
            ("WORK_ORDER_ISSUE_ABNORMAL",    "WORK_ORDER_ISSUE",      "工单发料异常",       "Tools"),
        };
        foreach (var (typeCode, anchor, title, icon) in supplyTypes)
            list.Add(ExceptionType(seq++, "SUPPLY", $"SUPPLY_ANOMALY_{anchor}", title, typeCode, "OPEN_COUNT", "LAST_24H", sort++, ct,
                icon: icon, layoutArea: "SIDEBAR", displayMode: "CATEGORY_COMPACT"));

        foreach (var (typeCode, anchor, title, icon) in supplyTypes)
            list.Add(ExceptionType(seq++, "SUPPLY", $"SUPPLY_CAT_{anchor}", $"{title}多维分析", typeCode, "FREQUENCY", "LAST_7D", sort++, ct,
                icon: icon, layoutArea: "ANALYSIS", displayMode: "CATEGORY_CARD"));

        list.Add(Custom(seq++, "SUPPLY", "SUPPLY_STATUS_BAR", "状态统计条", "OPEN_COUNT", "TODAY", sort++, ct,
            icon: null, layoutArea: "ANALYSIS", displayMode: "CUSTOM"));

        return list;
    }

    // F-CLEAN-1：show_in_sidebar 在 Phase 2/3 当前模型下不参与 cell→layout 派生
    // （前端 effectiveSidebarTypes 仅按 layout_area+display_mode 过滤，DTO 也不映射该字段），
    // 因此 SeedData 不再写入。Entity/DB 列保留以避免 schema 破坏，待未来重新定义语义或下版本统一 DROP。
    private static Entity.S8.AdoS8DashboardCellConfig Custom(
        long id, string pageCode, string cellCode, string cellTitle,
        string statMetric, string timeWindow, int sortNo, DateTime ct,
        string? icon = null, string layoutArea = "ANALYSIS", string displayMode = "CATEGORY_CARD",
        string? remark = null) =>
        new()
        {
            Id = id,
            TenantId = 0,
            FactoryId = 0,
            PageCode = pageCode,
            CellCode = cellCode,
            CellTitle = cellTitle,
            BindingType = "CUSTOM",
            ExceptionTypeCode = null,
            AggregateScope = null,
            StatMetric = statMetric,
            TimeWindow = timeWindow,
            FilterExpression = null,
            DeptGroupBy = "OWNER",
            Enabled = true,
            SortNo = sortNo,
            Icon = icon,
            LayoutArea = layoutArea,
            DisplayMode = displayMode,
            Remark = remark,
            CreatedAt = ct,
        };

    private static Entity.S8.AdoS8DashboardCellConfig ExceptionType(
        long id, string pageCode, string cellCode, string cellTitle,
        string exceptionTypeCode, string statMetric, string timeWindow, int sortNo, DateTime ct,
        string? icon = null, string layoutArea = "ANALYSIS", string displayMode = "CATEGORY_CARD",
        string? remark = null) =>
        new()
        {
            Id = id,
            TenantId = 0,
            FactoryId = 0,
            PageCode = pageCode,
            CellCode = cellCode,
            CellTitle = cellTitle,
            BindingType = "EXCEPTION_TYPE",
            ExceptionTypeCode = exceptionTypeCode,
            AggregateScope = null,
            StatMetric = statMetric,
            TimeWindow = timeWindow,
            FilterExpression = null,
            DeptGroupBy = "OWNER",
            Enabled = true,
            SortNo = sortNo,
            Icon = icon,
            LayoutArea = layoutArea,
            DisplayMode = displayMode,
            Remark = remark,
            CreatedAt = ct,
        };

    private static Entity.S8.AdoS8DashboardCellConfig Aggregate(
        long id, string pageCode, string cellCode, string cellTitle,
        string aggregateScope, string statMetric, string timeWindow, string deptGroupBy,
        int sortNo, DateTime ct,
        string? icon = null, string layoutArea = "ANALYSIS", string displayMode = "CATEGORY_CARD",
        string? remark = null) =>
        new()
        {
            Id = id,
            TenantId = 0,
            FactoryId = 0,
            PageCode = pageCode,
            CellCode = cellCode,
            CellTitle = cellTitle,
            BindingType = "AGGREGATE",
            ExceptionTypeCode = null,
            AggregateScope = aggregateScope,
            StatMetric = statMetric,
            TimeWindow = timeWindow,
            FilterExpression = null,
            DeptGroupBy = deptGroupBy,
            Enabled = true,
            SortNo = sortNo,
            Icon = icon,
            LayoutArea = layoutArea,
            DisplayMode = displayMode,
            Remark = remark,
            CreatedAt = ct,
        };
}