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

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

/// <summary>
/// 异常主表（业务实体；列表为查询该表及关联展示字段，非独立「列表视图表」）。
/// </summary>
[SugarTable("ado_s8_exception", "S8 异常主表")]
// S8-TENANT-ONLY-BATCH6：单号唯一性收敛为 (租户, 单号)。
// 旧键含 factory_id，而本批之后新建异常的 factory_id 恒为 0、历史行非 0，
// 混合状态下同租户可出现两条相同 exception_code —— 对外单号重号。
// 其余 (tenant_id, factory_id, ...) 辅助索引本批刻意不动：前导列仍是 tenant_id，查询能走前缀。
[SugarIndex("uk_ado_s8_exception_tenant_code", nameof(TenantId), OrderByType.Asc, nameof(ExceptionCode), OrderByType.Asc, IsUnique = true)]
[SugarIndex("idx_ado_s8_exception_type_time", nameof(TenantId), OrderByType.Asc, nameof(FactoryId), OrderByType.Asc, nameof(ExceptionTypeCode), OrderByType.Asc, nameof(CreatedAt), OrderByType.Desc)]
[SugarIndex("idx_s8_exception_dedup_key", nameof(TenantId), OrderByType.Asc, nameof(FactoryId), OrderByType.Asc, nameof(DedupKey), OrderByType.Asc)]
[SugarIndex("idx_s8_exception_source_rule_code", nameof(TenantId), OrderByType.Asc, nameof(FactoryId), OrderByType.Asc, nameof(SourceRuleCode), OrderByType.Asc)]
[SugarIndex("idx_s8_exception_source_object", nameof(TenantId), OrderByType.Asc, nameof(FactoryId), OrderByType.Asc, nameof(SourceObjectType), OrderByType.Asc, nameof(SourceObjectId), OrderByType.Asc)]
[SugarIndex("idx_s8_exception_last_detected_at", nameof(LastDetectedAt), OrderByType.Asc)]
[SugarIndex("idx_s8_exception_related_object_code", nameof(TenantId), OrderByType.Asc, nameof(FactoryId), OrderByType.Asc, nameof(RelatedObjectCode), OrderByType.Asc, nameof(IsDeleted), OrderByType.Asc)]
[SugarIndex("idx_s8_exception_order_flow", nameof(TenantId), OrderByType.Asc, nameof(FactoryId), OrderByType.Asc, nameof(OrderFlowCode), OrderByType.Asc, nameof(Status), OrderByType.Asc, nameof(IsDeleted), OrderByType.Asc)]
[SugarIndex("idx_s8_exception_related_flow", nameof(TenantId), OrderByType.Asc, nameof(FactoryId), OrderByType.Asc, nameof(RelatedObjectCode), OrderByType.Asc, nameof(OrderFlowCode), OrderByType.Asc)]
[SugarIndex("idx_s8_exception_assignee_status", nameof(TenantId), OrderByType.Asc, nameof(FactoryId), OrderByType.Asc, nameof(AssigneeUserId), OrderByType.Asc, nameof(Status), OrderByType.Asc, nameof(IsDeleted), OrderByType.Asc)]
[SugarIndex("idx_s8_exception_verifier_status", nameof(TenantId), OrderByType.Asc, nameof(FactoryId), OrderByType.Asc, nameof(VerifierUserId), OrderByType.Asc, nameof(Status), OrderByType.Asc, nameof(IsDeleted), OrderByType.Asc)]
public class AdoS8Exception
{
    [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; }

    [SugarColumn(ColumnName = "exception_code", Length = 64)]
    public string ExceptionCode { get; set; } = string.Empty;

    [SugarColumn(ColumnName = "title", Length = 256)]
    public string Title { get; set; } = string.Empty;

    [SugarColumn(ColumnName = "description", Length = 4000, IsNullable = true)]
    public string? Description { get; set; }

    [SugarColumn(ColumnName = "scene_code", Length = 64)]
    public string SceneCode { get; set; } = string.Empty;

    [SugarColumn(ColumnName = "source_type", Length = 32)]
    public string SourceType { get; set; } = "MANUAL";

    [SugarColumn(ColumnName = "status", Length = 32)]
    public string Status { get; set; } = "NEW";

    /// <summary>S8-SEVERITY-FOLLOW-SERIOUS-STANDARDIZE-EXEC-1：业务枚举 FOLLOW（关注）/ SERIOUS（严重）。</summary>
    [SugarColumn(ColumnName = "severity", Length = 32)]
    public string Severity { get; set; } = "FOLLOW";

    [SugarColumn(ColumnName = "priority_score", ColumnDataType = "decimal(10,2)")]
    public decimal PriorityScore { get; set; }

    [SugarColumn(ColumnName = "priority_level", Length = 16)]
    public string PriorityLevel { get; set; } = "P3";

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

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

    [SugarColumn(ColumnName = "responsible_group_id", ColumnDataType = "bigint", IsNullable = true)]
    public long? ResponsibleGroupId { get; set; }

    /// <summary>
    /// 处理人。<b>SYSUSER ID ONLY</b> —— 值域是 <c>SysUser.Id</c>，不是 <c>EmployeeMaster.RecID</c>。
    ///
    /// <para>列名从 <c>assignee_id</c> 显式改为 <c>assignee_user_id</c>（迁移 1.0.496）。
    /// 旧列名两种解读都说得通，历史上也确实同时存在过两种写法：
    /// 认领写 Employee.RecID、审批流回调写 SysUser.Id，实测 34 个非空值里 14 个两边都解析不出来。
    /// 名字里带 <c>user</c> 是为了让下一次误用在<b>读代码时</b>就被发现，而不是等到线上通知发不出去。</para>
    /// </summary>
    [SugarColumn(ColumnName = "assignee_user_id", ColumnDataType = "bigint", IsNullable = true)]
    public long? AssigneeUserId { get; set; }

    /// <summary>提报人。<b>SYSUSER ID ONLY</b>，口径同 <see cref="AssigneeUserId"/>。</summary>
    [SugarColumn(ColumnName = "reporter_user_id", ColumnDataType = "bigint", IsNullable = true)]
    public long? ReporterUserId { get; set; }

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

    [SugarColumn(ColumnName = "timeout_flag", ColumnDataType = "boolean")]
    public bool TimeoutFlag { get; set; }

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

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

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

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

    /// <summary>所属模块码（S1-S7），标识异常产生于哪个业务环节</summary>
    [SugarColumn(ColumnName = "module_code", Length = 16, IsNullable = true)]
    public string? ModuleCode { get; set; }

    [SugarColumn(ColumnName = "process_node_code", Length = 64, IsNullable = true)]
    public string? ProcessNodeCode { get; set; }

    [SugarColumn(ColumnName = "related_object_code", Length = 64, IsNullable = true)]
    public string? RelatedObjectCode { get; set; }

    /// <summary>当前进行中的审批实例ID（用于并发控制）</summary>
    [SugarColumn(ColumnName = "active_flow_instance_id", IsNullable = true)]
    public long? ActiveFlowInstanceId { get; set; }

    /// <summary>当前进行中的审批业务类型（EXCEPTION_ESCALATION / EXCEPTION_CLOSURE）</summary>
    [SugarColumn(ColumnName = "active_flow_biz_type", Length = 32, IsNullable = true)]
    public string? ActiveFlowBizType { get; set; }

    [SugarColumn(ColumnName = "is_deleted", ColumnDataType = "boolean")]
    public bool IsDeleted { get; set; }

    [SugarColumn(ColumnName = "created_by", Length = 64, IsNullable = true)]
    public string? CreatedBy { get; set; }

    [SugarColumn(ColumnName = "updated_by", Length = 64, IsNullable = true)]
    public string? UpdatedBy { get; set; }

    /// <summary>异常类型编码（关联 ado_s8_exception_type.type_code）。配置化改造后新增。</summary>
    [SugarColumn(ColumnName = "exception_type_code", Length = 64, IsNullable = true)]
    public string? ExceptionTypeCode { get; set; }

    /// <summary>来源数据源 ID（自动建单时填充；人工提报为空）。关联 ado_s8_data_source.id</summary>
    [SugarColumn(ColumnName = "source_data_source_id", ColumnDataType = "bigint", IsNullable = true)]
    public long? SourceDataSourceId { get; set; }

    /// <summary>来源监视规则 ID（自动建单时填充）。关联 ado_s8_watch_rule.id</summary>
    [SugarColumn(ColumnName = "source_rule_id", ColumnDataType = "bigint", IsNullable = true)]
    public long? SourceRuleId { get; set; }

    /// <summary>命中规则时的原始数据快照（JSON 文本，便于追溯）</summary>
    [SugarColumn(ColumnName = "source_payload", Length = 4000, IsNullable = true)]
    public string? SourcePayload { get; set; }

    /// <summary>检验人（提交复检时手选）。<b>SYSUSER ID ONLY</b>，口径同 <see cref="AssigneeUserId"/>。</summary>
    [SugarColumn(ColumnName = "verifier_user_id", ColumnDataType = "bigint", IsNullable = true)]
    public long? VerifierUserId { get; set; }

    /// <summary>提交复检时间</summary>
    [SugarColumn(ColumnName = "verification_assigned_at", IsNullable = true)]
    public DateTime? VerificationAssignedAt { get; set; }

    /// <summary>检验完成时间</summary>
    [SugarColumn(ColumnName = "verified_at", IsNullable = true)]
    public DateTime? VerifiedAt { get; set; }

    /// <summary>检验结果（APPROVED / REJECTED）</summary>
    [SugarColumn(ColumnName = "verification_result", Length = 32, IsNullable = true)]
    public string? VerificationResult { get; set; }

    /// <summary>检验意见</summary>
    [SugarColumn(ColumnName = "verification_remark", Length = 2000, IsNullable = true)]
    public string? VerificationRemark { get; set; }

    /// <summary>R1 持久化去重键（首版仅普通列，唯一约束在后续小步加）。</summary>
    [SugarColumn(ColumnName = "dedup_key", Length = 128, IsNullable = true)]
    public string? DedupKey { get; set; }

    /// <summary>R1 最近一次被规则检测命中的时间（首版仅落列，service 暂不写）。</summary>
    [SugarColumn(ColumnName = "last_detected_at", IsNullable = true)]
    public DateTime? LastDetectedAt { get; set; }

    /// <summary>R1 规则恢复时间（首版仅落列，service 暂不写）。</summary>
    [SugarColumn(ColumnName = "recovered_at", IsNullable = true)]
    public DateTime? RecoveredAt { get; set; }

    /// <summary>R1 来源规则人读编码（与 source_rule_id 配合，首版仅落列）。</summary>
    [SugarColumn(ColumnName = "source_rule_code", Length = 64, IsNullable = true)]
    public string? SourceRuleCode { get; set; }

    /// <summary>R1 源对象类型（DEVICE / ORDER 等，首版仅落列）。</summary>
    [SugarColumn(ColumnName = "source_object_type", Length = 64, IsNullable = true)]
    public string? SourceObjectType { get; set; }

    /// <summary>R1 源对象主键或业务 ID（字符串以适配跨表/跨域，首版仅落列）。</summary>
    [SugarColumn(ColumnName = "source_object_id", Length = 64, IsNullable = true)]
    public string? SourceObjectId { get; set; }

    // ============================================================
    // S8-SCHED-SCHEMA-1：已建异常的抗抖累计字段（仅落列，本轮不接逻辑）
    // 仅用于已建异常后的刷新/恢复抗抖；建单前抗抖落在 AdoS8RuleDetectionState。
    // ============================================================

    /// <summary>已建异常被规则连续命中的次数（用于刷新阶段抗抖）。</summary>
    [SugarColumn(ColumnName = "consecutive_hit_count")]
    public int ConsecutiveHitCount { get; set; } = 1;

    /// <summary>已建异常被规则连续未命中的次数（用于恢复阶段抗抖）。</summary>
    [SugarColumn(ColumnName = "consecutive_miss_count")]
    public int ConsecutiveMissCount { get; set; } = 0;

    // ============================================================
    // TASK-002-RESET-DIMENSION-MODEL-DEV-2A：业务维度归属字段（仅落列，建单写入由后续切片接入）
    // ============================================================

    /// <summary>S_STAGE 维度节点（S1-S7）；首版与 module_code 同值，DEV-4 后聚合逐步切到此字段。</summary>
    [SugarColumn(ColumnName = "stage_code", Length = 16, IsNullable = true)]
    public string? StageCode { get; set; }

    /// <summary>ORDER_FLOW 维度节点；首版允许 NULL，由规则携带后透传到异常。</summary>
    [SugarColumn(ColumnName = "order_flow_code", Length = 64, IsNullable = true)]
    public string? OrderFlowCode { get; set; }

    /// <summary>报警机制：MANUAL_REPORT / DATE / RATIO / VALUE_RANGE。与 source_type 不同。</summary>
    [SugarColumn(ColumnName = "rule_mechanism", Length = 32, IsNullable = true)]
    public string? RuleMechanism { get; set; }
}