AiDOPWarehouse/server/Plugins/Admin.NET.Plugin.AiDOP/Entity/S8/AdoS8DashboardCellConfig.cs

namespace Admin.NET.Plugin.AiDOP.Entity.S8;

/// <summary>
/// S8 大屏卡片内容配置。描述"哪个页面的哪个卡片显示什么"。
/// UI 视觉层保持现状，本表仅承载卡片的数据绑定与统计口径配置。
/// 采用"全局基线 + 工厂可覆盖"策略：tenant_id=0 / factory_id=0 表示全局默认。
/// </summary>
[SugarTable("ado_s8_dashboard_cell_config", "S8 大屏卡片配置")]
[SugarIndex("uk_ado_s8_dashboard_cell_config_tenant_factory_page_cell", nameof(TenantId), OrderByType.Asc, nameof(FactoryId), OrderByType.Asc, nameof(PageCode), OrderByType.Asc, nameof(CellCode), OrderByType.Asc, IsUnique = true)]
[SugarIndex("idx_ado_s8_dashboard_cell_config_page_enabled_sort", nameof(PageCode), OrderByType.Asc, nameof(Enabled), OrderByType.Asc, nameof(SortNo), OrderByType.Asc)]
public class AdoS8DashboardCellConfig
{
    [SugarColumn(ColumnName = "id", IsPrimaryKey = true, IsIdentity = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnName = "tenant_id", ColumnDataType = "bigint")]
    public long TenantId { get; set; }

    [SugarColumn(ColumnName = "factory_id", ColumnDataType = "bigint")]
    public long FactoryId { get; set; }

    /// <summary>归属页面：OVERVIEW / DELIVERY / PRODUCTION / SUPPLY</summary>
    [SugarColumn(ColumnName = "page_code", Length = 32)]
    public string PageCode { get; set; } = string.Empty;

    /// <summary>卡片编码，页面内唯一。与前端视觉结构中的稳定锚点（grid-item i、v-for key）对齐。</summary>
    [SugarColumn(ColumnName = "cell_code", Length = 64)]
    public string CellCode { get; set; } = string.Empty;

    /// <summary>卡片标题（覆盖前端默认；留空时前端使用组件内默认标题）</summary>
    [SugarColumn(ColumnName = "cell_title", Length = 128, IsNullable = true)]
    public string? CellTitle { get; set; }

    /// <summary>绑定类型：EXCEPTION_TYPE（绑单个异常类型） / AGGREGATE（按域聚合） / CUSTOM（保持现有逻辑）</summary>
    [SugarColumn(ColumnName = "binding_type", Length = 16)]
    public string BindingType { get; set; } = "CUSTOM";

    /// <summary>binding_type=EXCEPTION_TYPE 时使用，关联 ado_s8_exception_type.type_code</summary>
    [SugarColumn(ColumnName = "exception_type_code", Length = 64, IsNullable = true)]
    public string? ExceptionTypeCode { get; set; }

    /// <summary>binding_type=AGGREGATE 时使用：DOMAIN_DELIVERY / DOMAIN_PRODUCTION / DOMAIN_SUPPLY / ALL</summary>
    [SugarColumn(ColumnName = "aggregate_scope", Length = 32, IsNullable = true)]
    public string? AggregateScope { get; set; }

    /// <summary>统计指标：OPEN_COUNT / FREQUENCY / AVG_DURATION / CLOSE_RATE</summary>
    [SugarColumn(ColumnName = "stat_metric", Length = 16)]
    public string StatMetric { get; set; } = "OPEN_COUNT";

    /// <summary>时间窗：TODAY / LAST_24H / LAST_7D / LAST_30D</summary>
    [SugarColumn(ColumnName = "time_window", Length = 16)]
    public string TimeWindow { get; set; } = "LAST_24H";

    /// <summary>额外筛选表达式（按部门、订单范围等），留给后续扩展</summary>
    [SugarColumn(ColumnName = "filter_expression", Length = 1000, IsNullable = true)]
    public string? FilterExpression { get; set; }

    /// <summary>部门聚合维度：OWNER（责任部门，默认） / OCCUR（发生部门）。仅 binding_type=AGGREGATE 且聚合含部门时生效。</summary>
    [SugarColumn(ColumnName = "dept_group_by", Length = 8)]
    public string DeptGroupBy { get; set; } = "OWNER";

    [SugarColumn(ColumnName = "enabled", ColumnDataType = "boolean")]
    public bool Enabled { get; set; } = true;

    [SugarColumn(ColumnName = "sort_no")]
    public int SortNo { get; set; }

    [SugarColumn(ColumnName = "created_at")]
    public DateTime CreatedAt { get; set; } = DateTime.Now;

    [SugarColumn(ColumnName = "updated_at", IsNullable = true)]
    public DateTime? UpdatedAt { get; set; }
}