AiDOPWarehouse/server/Plugins/Admin.NET.Plugin.AiDOP/Service/S8/S8ExceptionService.cs

using Admin.NET.Plugin.AiDOP.Dto.S8;
using Admin.NET.Plugin.AiDOP.Entity.S0.Manufacturing;
using Admin.NET.Plugin.AiDOP.Entity.S0.Warehouse;
using Admin.NET.Plugin.AiDOP.Entity.S8;
using Admin.NET.Plugin.AiDOP.Infrastructure;
using Admin.NET.Plugin.AiDOP.Infrastructure.S8;
using Microsoft.Extensions.Options;

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

public class S8ExceptionService : ITransient
{
    private readonly SqlSugarRepository<AdoS8Exception> _rep;
    private readonly SqlSugarRepository<AdoS0DepartmentMaster> _deptRep;
    private readonly SqlSugarRepository<AdoS0EmployeeMaster> _empRep;
    private readonly SqlSugarRepository<SysUser> _sysUserRep;
    private readonly S8ImpactMetricsService _impactMetricsService;
    // S8-EXCEPTION-DEPT-NAME-HYDRATION-MASTERDATA-FACTORY-FIX-1：部门名水合按 DepartmentMaster 主数据 factory 解析。
    private readonly S8MasterDataOptions _masterDataOptions;

    // S8-DEMO-IMPACT-SORT-NOTICE-1：影响排序的候选集合上限。
    // 超过此阈值时降级为 CreatedAt DESC 走 DB 分页，避免全量取 → 内存排序在生产规模下退化。
    private const int ImpactSortCandidateCap = 2000;

    // S8-EXCEPTION-DEPT-NAME-HYDRATION-MASTERDATA-FACTORY-FIX-1：未归属部门 codename（与 S8ManualReportService 同协议常量值）。
    private const string UnassignedDepartmentCode = "D-UNASSIGNED";

    public S8ExceptionService(
        SqlSugarRepository<AdoS8Exception> rep,
        SqlSugarRepository<AdoS0DepartmentMaster> deptRep,
        SqlSugarRepository<AdoS0EmployeeMaster> empRep,
        SqlSugarRepository<SysUser> sysUserRep,
        S8ImpactMetricsService impactMetricsService,
        IOptions<S8MasterDataOptions> masterDataOptions)
    {
        _rep = rep;
        _deptRep = deptRep;
        _empRep = empRep;
        _sysUserRep = sysUserRep;
        _impactMetricsService = impactMetricsService;
        _masterDataOptions = masterDataOptions.Value;
    }

    public async Task<(int total, List<AdoS8ExceptionListItemDto> list)> GetPagedAsync(AdoS8ExceptionQueryDto q)
    {
        (q.Page, q.PageSize) = PagingGuard.Normalize(q.Page, q.PageSize);
        var pendingStatuses = new[] { "NEW", "ASSIGNED", "IN_PROGRESS", "PENDING_VERIFICATION" };

        var includeUnclassified = q.IncludeUnclassified == true;
        // S8-SLA-TIMEOUT-RUNTIME-1（P3）：方法入口取一次 now，供 q.TimeoutFlag 筛选 + 投影写 TimeoutFlag 共用，避免分页前后不一致。
        var timeoutNow = DateTime.Now;

        var query = _rep.Context.Queryable<AdoS8Exception>()
            .LeftJoin<AdoS8SceneConfig>((e, sc) =>
                e.TenantId == sc.TenantId && e.FactoryId == sc.FactoryId && e.SceneCode == sc.SceneCode)
            .LeftJoin<AdoS8WatchRule>((e, sc, wr) =>
                e.TenantId == wr.TenantId && e.FactoryId == wr.FactoryId && e.SourceRuleCode == wr.RuleCode)
            .Where((e, sc, wr) => e.TenantId == q.TenantId && e.FactoryId == q.FactoryId && !e.IsDeleted)
            .WhereIF(!includeUnclassified, (e, sc, wr) => !SqlFunc.IsNullOrEmpty(e.ExceptionTypeCode))
            .WhereIF(!string.IsNullOrWhiteSpace(q.Status), (e, sc, wr) => e.Status == q.Status)
            .WhereIF(string.IsNullOrWhiteSpace(q.Status) && q.StatusBucket == "pending",
                (e, sc, wr) => pendingStatuses.Contains(e.Status))
            // S8-SEVERITY-FOLLOW-SERIOUS-STANDARDIZE-EXEC-1：legacy 兼容 — q.Severity 传 LOW/MEDIUM/HIGH/CRITICAL 时
            // 通过 Normalize 映射为 FOLLOW/SERIOUS 再过滤。
            .WhereIF(!string.IsNullOrWhiteSpace(q.Severity),
                (e, sc, wr) => e.Severity == S8SeverityCode.Normalize(q.Severity))
            .WhereIF(!string.IsNullOrWhiteSpace(q.SceneCode), (e, sc, wr) => e.SceneCode == q.SceneCode)
            .WhereIF(!string.IsNullOrWhiteSpace(q.ModuleCode), (e, sc, wr) => e.ModuleCode == q.ModuleCode)
            // S8-DASHBOARD-DATA-ALIGN-S1S7-1：看板明细表传 OnlyS1S7Modules=true 时与 KPI 口径对齐；
            // 异常列表页不传该参数，行为保持不变（仍可见 NULL module 的 legacy 行）。
            .WhereIF(q.OnlyS1S7Modules == true, (e, sc, wr) => S8ModuleCode.All.Contains(e.ModuleCode))
            .WhereIF(q.DeptId.HasValue, (e, sc, wr) => e.ResponsibleDeptId == q.DeptId!.Value || e.OccurrenceDeptId == q.DeptId!.Value)
            // S8-SLA-TIMEOUT-RUNTIME-1（P3）：q.TimeoutFlag 由 timeout_flag 字段筛选切到 sla_deadline + status 在线计算。
            // q.TimeoutFlag=true → 当前超时；q.TimeoutFlag=false → 未当前超时（含未配 SLA / 已关闭 / 已恢复）。
            .WhereIF(q.TimeoutFlag == true, (e, sc, wr) => e.SlaDeadline != null && e.SlaDeadline < timeoutNow && e.Status != "CLOSED" && e.Status != "RECOVERED")
            .WhereIF(q.TimeoutFlag == false, (e, sc, wr) => !(e.SlaDeadline != null && e.SlaDeadline < timeoutNow && e.Status != "CLOSED" && e.Status != "RECOVERED"))
            .WhereIF(q.BeginTime.HasValue, (e, sc, wr) => e.CreatedAt >= q.BeginTime!.Value)
            .WhereIF(q.EndTime.HasValue, (e, sc, wr) => e.CreatedAt <= q.EndTime!.Value)
            .WhereIF(!string.IsNullOrWhiteSpace(q.ProcessNodeCode), (e, sc, wr) => e.ProcessNodeCode == q.ProcessNodeCode)
            .WhereIF(!string.IsNullOrWhiteSpace(q.RelatedObjectCode), (e, sc, wr) => e.RelatedObjectCode == q.RelatedObjectCode)
            .WhereIF(!string.IsNullOrWhiteSpace(q.OrderFlowCode), (e, sc, wr) => e.OrderFlowCode == q.OrderFlowCode)
            .WhereIF(!string.IsNullOrWhiteSpace(q.StageCode), (e, sc, wr) => e.StageCode == q.StageCode)
            .WhereIF(!string.IsNullOrWhiteSpace(q.RuleMechanism), (e, sc, wr) => e.RuleMechanism == q.RuleMechanism)
            .WhereIF(q.RecoveredStatus == "RECOVERED", (e, sc, wr) => e.RecoveredAt != null)
            .WhereIF(q.RecoveredStatus == "ACTIVE", (e, sc, wr) => e.RecoveredAt == null)
            .WhereIF(!string.IsNullOrWhiteSpace(q.RuleType), (e, sc, wr) => wr.RuleType == q.RuleType)
            .WhereIF(!string.IsNullOrWhiteSpace(q.Keyword),
                (e, sc, wr) => e.Title.Contains(q.Keyword!) || e.ExceptionCode.Contains(q.Keyword!));

        var total = await query.CountAsync();

        // S8-DEMO-IMPACT-SORT-NOTICE-1：候选集合 <= ImpactSortCandidateCap 时走"全量取 → 内存填影响 → 排序 → 分页"，
        // 支持 impactScore / repeatCount30d / cumulativeLossHours30d 等运行期字段排序；超过则降级 DB 分页 createdAt DESC。
        var useImpactSort = total > 0 && total <= ImpactSortCandidateCap;

        List<AdoS8ExceptionListItemDto> list;
        if (useImpactSort)
        {
            // 先按 query 命中集合一次性取候选，order 仅 createdAt DESC 用于稳定性，后续内存覆写排序。
            var candidates = await query
                .OrderBy((e, sc, wr) => e.CreatedAt, OrderByType.Desc)
                .Take(ImpactSortCandidateCap)
                .Select((e, sc, wr) => new AdoS8ExceptionListItemDto
                {
                    Id = e.Id,
                    FactoryId = e.FactoryId,
                    ExceptionCode = e.ExceptionCode,
                    Title = e.Title,
                    Status = e.Status,
                    Severity = e.Severity,
                    PriorityScore = e.PriorityScore,
                    PriorityLevel = e.PriorityLevel,
                    SceneCode = e.SceneCode,
                    SceneName = sc.SceneName,
                    ModuleCode = e.ModuleCode,
                    ResponsibleDeptId = e.ResponsibleDeptId,
                    OccurrenceDeptId = e.OccurrenceDeptId,
                    AssigneeId = e.AssigneeId,
                    SlaDeadline = e.SlaDeadline,
                    TimeoutFlag = e.SlaDeadline != null && e.SlaDeadline < timeoutNow && e.Status != "CLOSED" && e.Status != "RECOVERED",
                    CreatedAt = e.CreatedAt,
                    ClosedAt = e.ClosedAt,
                    ExceptionTypeCode = e.ExceptionTypeCode,
                    RecoveredAt = e.RecoveredAt,
                    SourceRuleCode = e.SourceRuleCode,
                    SourceObjectType = e.SourceObjectType,
                    SourceObjectId = e.SourceObjectId,
                    DedupKey = e.DedupKey,
                    LastDetectedAt = e.LastDetectedAt,
                    RuleType = wr.RuleType,
                    RelatedObjectCode = e.RelatedObjectCode,
                    OrderFlowCode = e.OrderFlowCode,
                    StageCode = e.StageCode,
                    RuleMechanism = e.RuleMechanism,
                })
                .ToListAsync();

            // DTO 后处理：损失时间 / 是否超时关闭 / 标签。
            foreach (var r in candidates)
            {
                r.StatusLabel = S8Labels.StatusLabel(r.Status);
                r.SeverityLabel = S8Labels.SeverityLabel(r.Severity);
                r.ModuleName = string.IsNullOrWhiteSpace(r.ModuleCode) ? null : S8ModuleCode.Label(r.ModuleCode!);
                var (lossHours, isOverdueClosed) = ComputeClosureMetrics(r.CreatedAt, r.ClosedAt, r.SlaDeadline);
                r.LossHours = lossHours;
                r.IsOverdueClosed = isOverdueClosed;
            }

            // 影响统计批量填充（30 天窗口聚合一次性 GROUP BY，O(n) 回填，无 N+1）。
            var impactRows = candidates
                .Select(r => new ExceptionImpactRow
                {
                    Id = r.Id,
                    ExceptionTypeCode = r.ExceptionTypeCode,
                    Severity = r.Severity,
                    CreatedAt = r.CreatedAt,
                    ClosedAt = r.ClosedAt,
                    TimeoutFlag = r.TimeoutFlag,
                })
                .ToList();
            await _impactMetricsService.FillBatchAsync(q.TenantId, q.FactoryId, impactRows);
            var impactById = impactRows.ToDictionary(x => x.Id);
            foreach (var r in candidates)
            {
                if (!impactById.TryGetValue(r.Id, out var snap)) continue;
                r.RepeatCount30d = snap.RepeatCount30d;
                r.CumulativeLossHours30d = snap.CumulativeLossHours30d;
                r.ImpactScore = snap.ImpactScore;
                r.SuggestedAttentionLevel = snap.SuggestedAttentionLevel;
                r.SuggestedAttentionLabel = snap.SuggestedAttentionLabel;
                r.ImpactReason = snap.ImpactReason;
            }

            // 内存排序（白名单，非白名单回退 createdAt DESC）。
            var sorted = ApplyImpactSort(candidates, q.SortField, q.SortOrder);

            // 内存分页。
            list = sorted
                .Skip((q.Page - 1) * q.PageSize)
                .Take(q.PageSize)
                .ToList();
        }
        else
        {
            // 降级路径：候选 > ImpactSortCandidateCap，DB 分页 createdAt DESC，不填充影响字段（前端展示 0/null）。
            list = await query
                .OrderBy((e, sc, wr) => e.CreatedAt, OrderByType.Desc)
                .Select((e, sc, wr) => new AdoS8ExceptionListItemDto
                {
                    Id = e.Id,
                    FactoryId = e.FactoryId,
                    ExceptionCode = e.ExceptionCode,
                    Title = e.Title,
                    Status = e.Status,
                    Severity = e.Severity,
                    PriorityScore = e.PriorityScore,
                    PriorityLevel = e.PriorityLevel,
                    SceneCode = e.SceneCode,
                    SceneName = sc.SceneName,
                    ModuleCode = e.ModuleCode,
                    ResponsibleDeptId = e.ResponsibleDeptId,
                    OccurrenceDeptId = e.OccurrenceDeptId,
                    AssigneeId = e.AssigneeId,
                    SlaDeadline = e.SlaDeadline,
                    TimeoutFlag = e.SlaDeadline != null && e.SlaDeadline < timeoutNow && e.Status != "CLOSED" && e.Status != "RECOVERED",
                    CreatedAt = e.CreatedAt,
                    ClosedAt = e.ClosedAt,
                    ExceptionTypeCode = e.ExceptionTypeCode,
                    RecoveredAt = e.RecoveredAt,
                    SourceRuleCode = e.SourceRuleCode,
                    SourceObjectType = e.SourceObjectType,
                    SourceObjectId = e.SourceObjectId,
                    DedupKey = e.DedupKey,
                    LastDetectedAt = e.LastDetectedAt,
                    RuleType = wr.RuleType,
                    RelatedObjectCode = e.RelatedObjectCode,
                    OrderFlowCode = e.OrderFlowCode,
                    StageCode = e.StageCode,
                    RuleMechanism = e.RuleMechanism,
                })
                .ToPageListAsync(q.Page, q.PageSize);

            foreach (var r in list)
            {
                r.StatusLabel = S8Labels.StatusLabel(r.Status);
                r.SeverityLabel = S8Labels.SeverityLabel(r.Severity);
                r.ModuleName = string.IsNullOrWhiteSpace(r.ModuleCode) ? null : S8ModuleCode.Label(r.ModuleCode!);
                var (lossHours, isOverdueClosed) = ComputeClosureMetrics(r.CreatedAt, r.ClosedAt, r.SlaDeadline);
                r.LossHours = lossHours;
                r.IsOverdueClosed = isOverdueClosed;
            }
        }

        await FillDisplayNamesAsync(list, q.FactoryId);
        return (total, list);
    }

    // S8-DEMO-IMPACT-SORT-NOTICE-1：白名单排序；severity 自定义键（SERIOUS=2 / FOLLOW=1 / 其他=0）。
    // sortField 空或非白名单 → createdAt DESC；sortOrder 非 asc/desc → desc。
    private static List<AdoS8ExceptionListItemDto> ApplyImpactSort(
        List<AdoS8ExceptionListItemDto> rows, string? sortField, string? sortOrder)
    {
        var asc = string.Equals(sortOrder, "asc", StringComparison.OrdinalIgnoreCase);
        var key = (sortField ?? string.Empty).Trim();
        return key switch
        {
            "impactScore" => asc
                ? rows.OrderBy(r => r.ImpactScore).ThenByDescending(r => r.CreatedAt).ToList()
                : rows.OrderByDescending(r => r.ImpactScore).ThenByDescending(r => r.CreatedAt).ToList(),
            "repeatCount30d" => asc
                ? rows.OrderBy(r => r.RepeatCount30d).ThenByDescending(r => r.CreatedAt).ToList()
                : rows.OrderByDescending(r => r.RepeatCount30d).ThenByDescending(r => r.CreatedAt).ToList(),
            "cumulativeLossHours30d" => asc
                ? rows.OrderBy(r => r.CumulativeLossHours30d).ThenByDescending(r => r.CreatedAt).ToList()
                : rows.OrderByDescending(r => r.CumulativeLossHours30d).ThenByDescending(r => r.CreatedAt).ToList(),
            "severity" => asc
                ? rows.OrderBy(r => SeveritySortKey(r.Severity)).ThenByDescending(r => r.CreatedAt).ToList()
                : rows.OrderByDescending(r => SeveritySortKey(r.Severity)).ThenByDescending(r => r.CreatedAt).ToList(),
            "priorityScore" => asc
                ? rows.OrderBy(r => r.PriorityScore).ThenByDescending(r => r.CreatedAt).ToList()
                : rows.OrderByDescending(r => r.PriorityScore).ThenByDescending(r => r.CreatedAt).ToList(),
            "createdAt" => asc
                ? rows.OrderBy(r => r.CreatedAt).ToList()
                : rows.OrderByDescending(r => r.CreatedAt).ToList(),
            _ => rows.OrderByDescending(r => r.CreatedAt).ToList(),
        };
    }

    private static int SeveritySortKey(string severity) => severity switch
    {
        "SERIOUS" => 2,
        "FOLLOW" => 1,
        _ => 0,
    };

    public async Task<object> GetFilterOptionsAsync(long tenantId, long factoryId)
    {
        var scenes = await _rep.Context.Queryable<AdoS8SceneConfig>()
            .Where(x => x.TenantId == tenantId && x.FactoryId == factoryId && x.Enabled)
            .OrderBy(x => x.SortNo)
            .Select(x => new { value = x.SceneCode, label = x.SceneName })
            .ToListAsync();
        var departments = await _deptRep.AsQueryable()
            .Where(x => x.FactoryRefId == factoryId)
            .OrderBy(x => x.Department)
            .Take(500)
            .Select(x => new { value = x.Id, label = x.Descr ?? x.Department })
            .ToListAsync();

        // S8-EXCEPTION-MODULE-DISPLAY-1：业务展示主口径切到 module_code（S1-S7）。
        // scenes 保留兼容期，前端筛选已切到 modules。
        var modules = S8ModuleCode.All
            .Select(code => new { value = code, label = S8ModuleCode.Label(code) })
            .ToList();

        return new
        {
            statuses = S8Labels.StatusOptions(),
            severities = S8Labels.SeverityOptions(),
            scenes,
            modules,
            departments
        };
    }

    public async Task<AdoS8ExceptionDetailDto?> GetDetailAsync(long id, long tenantId, long factoryId)
    {
        // S8-SLA-TIMEOUT-RUNTIME-1（P3）：详情 TimeoutFlag 与 list 同口径，运行时计算。
        var timeoutNow = DateTime.Now;
        var rows = await _rep.Context.Queryable<AdoS8Exception>()
            .LeftJoin<AdoS8SceneConfig>((e, sc) =>
                e.TenantId == sc.TenantId && e.FactoryId == sc.FactoryId && e.SceneCode == sc.SceneCode)
            .LeftJoin<AdoS8WatchRule>((e, sc, wr) =>
                e.TenantId == wr.TenantId && e.FactoryId == wr.FactoryId && e.SourceRuleCode == wr.RuleCode)
            .Where((e, sc, wr) => e.Id == id && e.TenantId == tenantId && e.FactoryId == factoryId && !e.IsDeleted)
            .Select((e, sc, wr) => new AdoS8ExceptionDetailDto
            {
                Id = e.Id,
                FactoryId = e.FactoryId,
                ExceptionCode = e.ExceptionCode,
                Title = e.Title,
                Description = e.Description,
                Status = e.Status,
                Severity = e.Severity,
                PriorityScore = e.PriorityScore,
                PriorityLevel = e.PriorityLevel,
                SceneCode = e.SceneCode,
                SceneName = sc.SceneName,
                ModuleCode = e.ModuleCode,
                SourceType = e.SourceType,
                OccurrenceDeptId = e.OccurrenceDeptId,
                ResponsibleDeptId = e.ResponsibleDeptId,
                ResponsibleGroupId = e.ResponsibleGroupId,
                AssigneeId = e.AssigneeId,
                ReporterId = e.ReporterId,
                SlaDeadline = e.SlaDeadline,
                // S8-SLA-TIMEOUT-RUNTIME-1（P3）：详情展示 TimeoutFlag = 在线计算。
                TimeoutFlag = e.SlaDeadline != null && e.SlaDeadline < timeoutNow && e.Status != "CLOSED" && e.Status != "RECOVERED",
                CreatedAt = e.CreatedAt,
                ClosedAt = e.ClosedAt,
                AssignedAt = e.AssignedAt,
                UpdatedAt = e.UpdatedAt,
                ActiveFlowInstanceId = e.ActiveFlowInstanceId,
                ActiveFlowBizType = e.ActiveFlowBizType,
                VerifierId = e.VerifierId,
                VerificationAssignedAt = e.VerificationAssignedAt,
                VerifiedAt = e.VerifiedAt,
                VerificationResult = e.VerificationResult,
                VerificationRemark = e.VerificationRemark,
                SourceRuleId = e.SourceRuleId,
                RelatedObjectCode = e.RelatedObjectCode,
                DedupKey = e.DedupKey,
                LastDetectedAt = e.LastDetectedAt,
                RecoveredAt = e.RecoveredAt,
                SourceRuleCode = e.SourceRuleCode,
                SourceObjectType = e.SourceObjectType,
                SourceObjectId = e.SourceObjectId,
                ExceptionTypeCode = e.ExceptionTypeCode,
                RuleType = wr.RuleType,
                OrderFlowCode = e.OrderFlowCode,
                StageCode = e.StageCode,
                RuleMechanism = e.RuleMechanism,
            })
            .Take(1)
            .ToListAsync();

        if (rows.Count == 0) return null;
        var d = rows[0];
        d.StatusLabel = S8Labels.StatusLabel(d.Status);
        d.SeverityLabel = S8Labels.SeverityLabel(d.Severity);
        d.ModuleName = string.IsNullOrWhiteSpace(d.ModuleCode) ? null : S8ModuleCode.Label(d.ModuleCode!);
        // S8-DEMO-CORE-FIELD-COMPLETE-1：详情与列表同口径，DTO 后处理计算损失时间 / 是否超时关闭。
        var (lossHours, isOverdueClosed) = ComputeClosureMetrics(d.CreatedAt, d.ClosedAt, d.SlaDeadline);
        d.LossHours = lossHours;
        d.IsOverdueClosed = isOverdueClosed;
        await FillDisplayNamesAsync(new[] { d }, factoryId);
        return d;
    }

    // S8-DEMO-CORE-FIELD-COMPLETE-1：损失时间（小时，1 位小数）+ 是否超时关闭（冻结判定）。
    // 未关闭 → LossHours=null；未关闭或无 SLA → IsOverdueClosed=null。与运行时 TimeoutFlag 不复用。
    private static (decimal? lossHours, bool? isOverdueClosed) ComputeClosureMetrics(
        DateTime createdAt, DateTime? closedAt, DateTime? slaDeadline)
    {
        decimal? lossHours = closedAt == null
            ? (decimal?)null
            : Math.Round((decimal)(closedAt.Value - createdAt).TotalHours, 1);
        bool? isOverdueClosed = (closedAt == null || slaDeadline == null)
            ? (bool?)null
            : closedAt.Value > slaDeadline.Value;
        return (lossHours, isOverdueClosed);
    }

    // S8-DEPT-DISPLAY-CONSISTENCY-1（P0-A-2/A-3）：list 行也水合 OccurrenceDeptName；
    // 部门查询加 factory_ref_id 二次约束，避免跨 factory 同名 / 同 RecID 错位。
    private async Task FillDisplayNamesAsync(IEnumerable<AdoS8ExceptionListItemDto> rows, long factoryId)
    {
        var list = rows.ToList();
        if (list.Count == 0) return;

        var deptIds = list
            .Select(x => x.ResponsibleDeptId)
            .Concat(list.Select(x => x.OccurrenceDeptId))
            .Where(x => x > 0)
            .Distinct()
            .ToList();

        var empIds = list
            .Select(x => x.AssigneeId ?? 0L)
            .Concat(list.OfType<AdoS8ExceptionDetailDto>().Select(x => x.ReporterId ?? 0L))
            .Concat(list.OfType<AdoS8ExceptionDetailDto>().Select(x => x.VerifierId ?? 0L))
            .Where(x => x > 0)
            .Distinct()
            .ToList();

        // S8-EXCEPTION-DEPT-NAME-HYDRATION-MASTERDATA-FACTORY-FIX-1：
        // 部门主数据位于 S0 域 factory（与 S8 运营 factoryId 不同源），且 DepartmentMaster.tenant_id 属 S0 域租户。
        // 用主数据 factory + ClearFilter（factory_ref_id + 具体 dept_id 集合做硬边界，等价安全，无跨租户泄漏），
        // 取代旧的“运营 factoryId + 全局租户过滤”——后者必然查空 → 全部回落“部门ID:N”。
        var masterDataFactoryId = await ResolveMasterDataDepartmentFactoryRefIdAsync(factoryId);
        var deptMap = deptIds.Count == 0
            ? new Dictionary<long, string>()
            : (await _deptRep.AsQueryable().ClearFilter()
                .Where(x => deptIds.Contains(x.Id) && x.FactoryRefId == masterDataFactoryId)
                .Select(x => new { x.Id, Name = x.Descr ?? x.Department })
                .ToListAsync())
                .ToDictionary(x => x.Id, x => x.Name);

        // EmployeeMaster.tenant_id 与 SysUser.TenantId 历史错位（797403760988229 ≠ 系统租户），
        // 走全局 multi-tenant filter 会全过滤为空 → 详情页处理人/检验人姓名显示数字 ID。
        // 与 S8MasterDataAdapter.GetEmployeesAsync / S8TaskFlowService.GetEmployeeSysUserIdAsync 同口径，
        // 局部 ClearFilter + employee.Id 主键集合作为安全边界，无跨租户泄漏。
        var empMap = empIds.Count == 0
            ? new Dictionary<long, string>()
            : (await _empRep.AsQueryable().ClearFilter()
                .Where(x => empIds.Contains(x.Id))
                .Select(x => new { x.Id, Name = x.Name ?? x.Employee })
                .ToListAsync())
                .ToDictionary(x => x.Id, x => x.Name);

        // S8-REPORTER-IDSPACE-FIX-1（P0-B-1）：ReporterId 新协议 = EmployeeMaster.RecID（与 assignee/verifier 同 idspace）。
        // 水合优先级：EmployeeMaster.Name → fallback SysUser.RealName/Account（兼容旧数据 reporter=SysUser.Id）。
        // 旧注释 “ReporterId 现在记录 sysUser.Id” 已失效，由本批协议替代。
        var reporterUserIds = list.OfType<AdoS8ExceptionDetailDto>()
            .Select(x => x.ReporterId ?? 0L)
            .Where(x => x > 0)
            .Distinct()
            .ToList();
        var reporterUserMap = reporterUserIds.Count == 0
            ? new Dictionary<long, string>()
            : (await _sysUserRep.AsQueryable().ClearFilter()
                .Where(u => reporterUserIds.Contains(u.Id))
                .Select(u => new { u.Id, u.RealName, u.Account })
                .ToListAsync())
                .ToDictionary(
                    u => u.Id,
                    u => !string.IsNullOrWhiteSpace(u.RealName) ? u.RealName : u.Account);

        foreach (var row in list)
        {
            row.ResponsibleDeptName = ResolveDeptName(row.ResponsibleDeptId, deptMap);
            row.OccurrenceDeptName = ResolveDeptName(row.OccurrenceDeptId, deptMap);
            row.AssigneeName = row.AssigneeId.HasValue ? empMap.GetValueOrDefault(row.AssigneeId.Value) : null;

            if (row is AdoS8ExceptionDetailDto detail)
            {
                // S8-REPORTER-IDSPACE-FIX-1：empMap（EmployeeMaster.RecID）优先，reporterUserMap（SysUser.Id）兜底兼容旧数据。
                detail.ReporterName = detail.ReporterId.HasValue
                    ? (empMap.GetValueOrDefault(detail.ReporterId.Value) ?? reporterUserMap.GetValueOrDefault(detail.ReporterId.Value))
                    : null;
                detail.VerifierName = detail.VerifierId.HasValue ? empMap.GetValueOrDefault(detail.VerifierId.Value) : null;
            }
        }
    }

    // S8-DEPT-DISPLAY-CONSISTENCY-1（P0-A-3）：dept fallback —— 0/缺失=未归属，查不到名=部门ID:{id}。
    private static string? ResolveDeptName(long deptId, Dictionary<long, string> deptMap)
    {
        if (deptId <= 0) return "未归属";
        return deptMap.TryGetValue(deptId, out var name) && !string.IsNullOrWhiteSpace(name)
            ? name
            : $"部门ID:{deptId}";
    }

    // S8-EXCEPTION-DEPT-NAME-HYDRATION-MASTERDATA-FACTORY-FIX-1：解析 DepartmentMaster 主数据所在 factory_ref_id。
    // 优先读配置 S8MasterData.DepartmentFactoryRefId；缺失（<=0）则推导“唯一 active D-UNASSIGNED 的 FactoryRefId”。
    // 显示路径不抛错：推导 0 条 / 不唯一时退回运营 factoryId（保持旧“部门ID:N”兜底，绝不让列表/详情查询失败）。
    private async Task<long> ResolveMasterDataDepartmentFactoryRefIdAsync(long fallbackFactoryId)
    {
        var configured = _masterDataOptions.DepartmentFactoryRefId;
        if (configured > 0) return configured;

        var factories = await _deptRep.AsQueryable().ClearFilter()
            .Where(x => x.Department == UnassignedDepartmentCode && x.IsActive)
            .Select(x => x.FactoryRefId)
            .Distinct()
            .ToListAsync();
        return factories.Count == 1 ? factories[0] : fallbackFactoryId;
    }

    /// <summary>
    /// S2-EW：debug-only 软删 RelatedObjectCode 以 "TEST_G09_" 开头的异常。
    /// 调用方仅限 <see cref="Controllers.S8.AdoS8WatchDebugController"/>，由其 _debugEndpointEnabled 守门。
    /// 实现纪律：
    /// - 仅 SET IsDeleted=true，不动业务字段（status/closed_at/source_rule_id 等）。
    /// - 前缀字面量硬编码，不接受外部 prefix；防止前缀注入。
    /// - 不联动 timeline / decision / evidence；业务读路径以父 IsDeleted 屏蔽。
    /// </summary>
    public async Task<int> SoftDeleteTestPrefixAsync(long tenantId, long factoryId)
    {
        const string prefix = "TEST_G09_";
        var affected = await _rep.AsUpdateable()
            .SetColumns(e => new AdoS8Exception { IsDeleted = true })
            .Where(e => e.TenantId == tenantId
                     && e.FactoryId == factoryId
                     && !e.IsDeleted
                     && e.RelatedObjectCode != null
                     && e.RelatedObjectCode.StartsWith(prefix))
            .ExecuteCommandAsync();
        System.Diagnostics.Trace.TraceWarning(
            $"[S2-EW] soft-deleted {affected} TEST_G09_ exceptions, tenant={tenantId} factory={factoryId}");
        return affected;
    }
}