using System.Collections.Concurrent; using System.Text.Json; using System.Threading.Channels; using ClassNotify.Server.Data; using ClassNotify.Server.Domain.Entities; using ClassNotify.Server.Infrastructure.Correlation; using ClassNotify.Shared.Models; using Microsoft.EntityFrameworkCore; namespace ClassNotify.Server.Services; public sealed class SelfCheckDispatchNotifier : ISelfCheckDispatchNotifier { private readonly Channel _channel = Channel.CreateBounded(new BoundedChannelOptions(1) { FullMode = BoundedChannelFullMode.DropOldest }); public void Notify() { _channel.Writer.TryWrite(1); } public async Task WaitAsync(CancellationToken ct) { await _channel.Reader.WaitToReadAsync(ct); while (_channel.Reader.TryRead(out _)) { } } } public class SelfCheckBatchService : ISelfCheckBatchService { private static readonly ConcurrentDictionary _batchCreationLocks = new(); private readonly ClassNotifyDbContext _db; private readonly ICorrelationContext _correlationContext; private readonly ISelfCheckDispatchNotifier _dispatchNotifier; private readonly IDevicePresenceService _presenceService; private readonly ILogger _logger; public SelfCheckBatchService( ClassNotifyDbContext db, ICorrelationContext correlationContext, ISelfCheckDispatchNotifier dispatchNotifier, IDevicePresenceService presenceService, ILogger logger) { _db = db; _correlationContext = correlationContext; _dispatchNotifier = dispatchNotifier; _presenceService = presenceService; _logger = logger; } public async Task CreateBatchAsync( CreateSelfCheckBatchRequest request, string actorUserId, string actorIp, CancellationToken ct) { if (request == null || request.DeviceIds == null) { throw new ArgumentException("请求体不可为空。"); } var deviceIds = request.DeviceIds .Where(x => !string.IsNullOrWhiteSpace(x)) .Distinct() .ToArray(); if (deviceIds.Length == 0) { throw new ArgumentException("至少选择一台设备。"); } if (deviceIds.Length > 100) { throw new ArgumentException("单批次最多允许 100 台设备。"); } if (string.IsNullOrWhiteSpace(request.ClientRequestId)) { request.ClientRequestId = Guid.NewGuid().ToString("N"); } var lockKey = $"{actorUserId}:{request.ClientRequestId}"; var gate = _batchCreationLocks.GetOrAdd(lockKey, _ => new SemaphoreSlim(1, 1)); await gate.WaitAsync(ct); try { // 1. Idempotency Check: Same ClientRequestId by same user returns existing batch var existing = await _db.DeviceSelfCheckBatches .AsNoTracking() .FirstOrDefaultAsync( x => x.CreatedByUserId == actorUserId && x.ClientRequestId == request.ClientRequestId, ct); if (existing != null) { _logger.LogInformation("Idempotent hit for self-check batch ClientRequestId={ClientRequestId}, returning existing BatchId={BatchId}", request.ClientRequestId, existing.Id); return new SelfCheckBatchCreatedDto { BatchId = existing.Id, Status = existing.Status, TargetDeviceCount = existing.TargetDeviceCount, CreatedAtUtc = existing.CreatedAtUtc, DeadlineAtUtc = existing.DeadlineAtUtc }; } // 2. Validate all devices exist var devices = await _db.Devices .Where(x => deviceIds.Contains(x.Id)) .ToListAsync(ct); if (devices.Count != deviceIds.Length) { var foundIds = devices.Select(d => d.Id).ToHashSet(); var missing = deviceIds.Where(id => !foundIds.Contains(id)).ToArray(); throw new ArgumentException($"存在无效设备: {string.Join(", ", missing)}"); } var now = DateTimeOffset.UtcNow; var batchId = $"scb_{now.ToUnixTimeMilliseconds()}_{Guid.NewGuid():N}"[..24]; var correlationId = !string.IsNullOrWhiteSpace(_correlationContext.CorrelationId) ? _correlationContext.CorrelationId : $"sc_corr_{Guid.NewGuid():N}"[..20]; var batch = new DeviceSelfCheckBatch { Id = batchId, CorrelationId = correlationId, ClientRequestId = request.ClientRequestId, CreatedByUserId = actorUserId, CreatedAtUtc = now, DeadlineAtUtc = now.AddSeconds(60), TargetDeviceCount = devices.Count, Status = "Running", UpdatedAtUtc = now }; var runs = devices.Select(device => new DeviceSelfCheckRun { Id = $"sc_{DateTimeOffset.UtcNow.ToUnixTimeMilliseconds()}_{Guid.NewGuid():N}"[..24], BatchId = batch.Id, TenantId = device.TenantId, DeviceId = device.Id, CorrelationId = $"sc_corr_{Guid.NewGuid():N}"[..20], RequestedByUserId = actorUserId, RequestedAtUtc = now, DeadlineAtUtc = batch.DeadlineAtUtc, RunState = SelfCheckRunStates.PendingDispatch, Status = "Pending" }).ToArray(); var tenantCount = devices.Select(d => d.TenantId).Distinct().Count(); var audit = new AdminAuditEvent { Id = Guid.NewGuid().ToString("N"), OccurredAt = now, ActorUsername = actorUserId, ActorRole = "SuperAdmin", Action = "SELF_CHECK_BATCH_REQUESTED", TargetType = "DeviceSelfCheckBatch", TargetId = batch.Id, Details = JsonSerializer.Serialize(new { batchId = batch.Id, targetDeviceCount = batch.TargetDeviceCount, tenantCount = tenantCount }), IpAddress = actorIp }; // Atomic Transaction: Batch + Runs + Audit must succeed together await using var tx = await _db.Database.BeginTransactionAsync(ct); try { _db.DeviceSelfCheckBatches.Add(batch); _db.DeviceSelfChecks.AddRange(runs); _db.AdminAuditEvents.Add(audit); await _db.SaveChangesAsync(ct); await tx.CommitAsync(ct); } catch (DbUpdateException dbEx) { _logger.LogWarning(dbEx, "DbUpdateException during batch creation for ClientRequestId={ClientRequestId}. Checking for concurrent collision.", request.ClientRequestId); var collisionExisting = await _db.DeviceSelfCheckBatches .AsNoTracking() .FirstOrDefaultAsync(x => x.CreatedByUserId == actorUserId && x.ClientRequestId == request.ClientRequestId, ct); if (collisionExisting != null) { return new SelfCheckBatchCreatedDto { BatchId = collisionExisting.Id, Status = collisionExisting.Status, TargetDeviceCount = collisionExisting.TargetDeviceCount, CreatedAtUtc = collisionExisting.CreatedAtUtc, DeadlineAtUtc = collisionExisting.DeadlineAtUtc }; } throw; } catch (Exception ex) { _logger.LogError(ex, "Transaction failed while creating self-check batch {BatchId}. Rolled back.", batch.Id); throw; } _logger.LogInformation("Self-check batch created: BatchId={BatchId}, Devices={Count}, Tenants={Tenants}, CorrelationId={CorrelationId}", batch.Id, batch.TargetDeviceCount, tenantCount, batch.CorrelationId); // Notify background dispatch worker to immediately process pending runs _dispatchNotifier.Notify(); return new SelfCheckBatchCreatedDto { BatchId = batch.Id, Status = batch.Status, TargetDeviceCount = batch.TargetDeviceCount, CreatedAtUtc = batch.CreatedAtUtc, DeadlineAtUtc = batch.DeadlineAtUtc }; } finally { gate.Release(); } } public async Task GetBatchAsync(string batchId, CancellationToken ct) { var batch = await _db.DeviceSelfCheckBatches .AsNoTracking() .FirstOrDefaultAsync(x => x.Id == batchId, ct); if (batch == null) return null; var runs = await _db.DeviceSelfChecks .AsNoTracking() .Where(r => r.BatchId == batchId) .ToListAsync(ct); var (summary, probeFailures) = CalculateSummaryAndProbes(batch, runs); return new SelfCheckBatchDetailDto { BatchId = batch.Id, Status = batch.Status, CreatedAtUtc = batch.CreatedAtUtc, DeadlineAtUtc = batch.DeadlineAtUtc, CompletedAtUtc = batch.CompletedAtUtc, Summary = summary, ProbeFailures = probeFailures }; } public async Task> GetBatchesAsync(string? status, int take, CancellationToken ct) { var limit = take <= 0 ? 20 : (take > 100 ? 100 : take); var query = _db.DeviceSelfCheckBatches.AsNoTracking(); if (!string.IsNullOrWhiteSpace(status)) { query = query.Where(b => b.Status == status); } var batches = await query .OrderByDescending(b => b.CreatedAtUtc) .Take(limit) .ToListAsync(ct); if (batches.Count == 0) return Array.Empty(); var batchIds = batches.Select(b => b.Id).ToList(); var allRuns = await _db.DeviceSelfChecks .AsNoTracking() .Where(r => r.BatchId != null && batchIds.Contains(r.BatchId)) .ToListAsync(ct); var runsByBatch = allRuns.GroupBy(r => r.BatchId!).ToDictionary(g => g.Key, g => g.ToList()); var result = new List(); foreach (var b in batches) { runsByBatch.TryGetValue(b.Id, out var batchRuns); var (summary, _) = CalculateSummaryAndProbes(b, batchRuns ?? new List()); result.Add(summary); } return result; } public async Task GetBatchDevicesAsync( string batchId, SelfCheckBatchDeviceQuery query, CancellationToken ct) { var runsQuery = _db.DeviceSelfChecks .AsNoTracking() .Include(r => r.Device) .ThenInclude(d => d!.Tenant) .Include(r => r.Device) .ThenInclude(d => d!.Classroom) .Where(r => r.BatchId == batchId); var allRuns = await runsQuery.ToListAsync(ct); // In-memory multi-dimensional filtering var filtered = allRuns.AsEnumerable(); if (!string.IsNullOrWhiteSpace(query.TenantId)) { filtered = filtered.Where(r => r.TenantId == query.TenantId); } if (!string.IsNullOrWhiteSpace(query.Health)) { var h = query.Health.Trim(); if (h.Equals("Healthy", StringComparison.OrdinalIgnoreCase)) { filtered = filtered.Where(r => r.RunState == SelfCheckRunStates.Completed && r.OverallStatus == "Healthy"); } else if (h.Equals("Warning", StringComparison.OrdinalIgnoreCase)) { filtered = filtered.Where(r => r.RunState == SelfCheckRunStates.Completed && r.OverallStatus == "Warning"); } else if (h.Equals("Failed", StringComparison.OrdinalIgnoreCase)) { filtered = filtered.Where(r => r.RunState == SelfCheckRunStates.Completed && r.OverallStatus == "Failed"); } else if (h.Equals("Unreachable", StringComparison.OrdinalIgnoreCase)) { filtered = filtered.Where(r => r.RunState == SelfCheckRunStates.Unreachable); } else if (h.Equals("TimedOut", StringComparison.OrdinalIgnoreCase)) { filtered = filtered.Where(r => r.RunState == SelfCheckRunStates.TimedOut); } else if (h.Equals("Pending", StringComparison.OrdinalIgnoreCase)) { filtered = filtered.Where(r => r.RunState == SelfCheckRunStates.PendingDispatch || r.RunState == SelfCheckRunStates.Dispatched); } } if (!string.IsNullOrWhiteSpace(query.Probe)) { var normProbe = SelfCheckProbeKeys.Normalize(query.Probe); filtered = filtered.Where(r => { if (string.IsNullOrWhiteSpace(r.ResultJson)) return false; try { var res = JsonSerializer.Deserialize(r.ResultJson!); if (res?.Checks == null) return false; var probeCheck = res.Checks.FirstOrDefault(c => SelfCheckProbeKeys.Normalize(c.Name) == normProbe); if (probeCheck == null) return false; if (!string.IsNullOrWhiteSpace(query.Health)) { if (query.Health.Equals("Failed", StringComparison.OrdinalIgnoreCase)) return probeCheck.Status == SelfCheckStatus.Failed; if (query.Health.Equals("Warning", StringComparison.OrdinalIgnoreCase)) return probeCheck.Status == SelfCheckStatus.Warning; if (query.Health.Equals("Healthy", StringComparison.OrdinalIgnoreCase)) return probeCheck.Status == SelfCheckStatus.Healthy; } return probeCheck.Status == SelfCheckStatus.Failed || probeCheck.Status == SelfCheckStatus.Warning; } catch { return false; } }); } if (!string.IsNullOrWhiteSpace(query.Q)) { var q = query.Q.Trim(); filtered = filtered.Where(r => r.DeviceId.Contains(q, StringComparison.OrdinalIgnoreCase) || (r.Device?.Hostname != null && r.Device.Hostname.Contains(q, StringComparison.OrdinalIgnoreCase)) || (r.Device?.Classroom?.DisplayName != null && r.Device.Classroom.DisplayName.Contains(q, StringComparison.OrdinalIgnoreCase)) || (r.Device?.ClassroomId != null && r.Device.ClassroomId.Contains(q, StringComparison.OrdinalIgnoreCase)) ); } var list = filtered.OrderBy(r => r.DeviceId).ToList(); var total = list.Count; var page = query.Page <= 0 ? 1 : query.Page; var pageSize = query.PageSize <= 0 ? 50 : (query.PageSize > 100 ? 100 : query.PageSize); var pagedItems = list.Skip((page - 1) * pageSize).Take(pageSize).ToList(); var items = pagedItems.Select(r => MapDeviceItem(r, _presenceService)).ToList(); return new SelfCheckBatchDevicePagedResultDto { Total = total, Page = page, PageSize = pageSize, Items = items }; } public async Task GetBatchDeviceRunDetailAsync(string batchId, string runId, CancellationToken ct) { var run = await _db.DeviceSelfChecks .AsNoTracking() .Include(r => r.Device) .ThenInclude(d => d!.Tenant) .Include(r => r.Device) .ThenInclude(d => d!.Classroom) .FirstOrDefaultAsync(r => r.BatchId == batchId && r.Id == runId, ct); if (run == null) return null; return MapDeviceItem(run, _presenceService); } private static SelfCheckBatchDeviceItemDto MapDeviceItem(DeviceSelfCheckRun r, IDevicePresenceService presenceService) { var checks = new List(); if (!string.IsNullOrWhiteSpace(r.ResultJson)) { try { var parsed = JsonSerializer.Deserialize(r.ResultJson); if (parsed?.Checks != null) { checks = parsed.Checks; } } catch { } } bool isOnline = r.Device != null && presenceService.IsOnline(r.Device.Id, r.Device.LastHeartbeatAt); return new SelfCheckBatchDeviceItemDto { RunId = r.Id, DeviceId = r.DeviceId, TenantId = r.TenantId, SchoolName = r.Device?.Tenant?.Name ?? r.TenantId, ClassroomId = r.Device?.ClassroomId ?? "", ClassroomName = r.Device?.Classroom?.DisplayName ?? r.Device?.ClassroomId ?? "", Hostname = r.Device?.Hostname ?? "", IsOnline = isOnline, ServiceVersion = r.Device?.ServiceVersion, ClientVersion = r.Device?.ClientVersion, RunState = r.RunState, OverallStatus = r.OverallStatus, Checks = checks, RequestedAtUtc = r.RequestedAtUtc, DispatchedAtUtc = r.DispatchedAtUtc, CompletedAtUtc = r.CompletedAtUtc, CorrelationId = r.CorrelationId }; } private static (SelfCheckBatchSummaryDto Summary, List ProbeFailures) CalculateSummaryAndProbes( DeviceSelfCheckBatch batch, IReadOnlyList runs) { var pending = runs.Count(r => r.RunState == SelfCheckRunStates.PendingDispatch || r.RunState == SelfCheckRunStates.Dispatched); var healthy = runs.Count(r => r.RunState == SelfCheckRunStates.Completed && r.OverallStatus == "Healthy"); var warning = runs.Count(r => r.RunState == SelfCheckRunStates.Completed && r.OverallStatus == "Warning"); var failed = runs.Count(r => r.RunState == SelfCheckRunStates.Completed && r.OverallStatus == "Failed"); var unreachable = runs.Count(r => r.RunState == SelfCheckRunStates.Unreachable); var timedOut = runs.Count(r => r.RunState == SelfCheckRunStates.TimedOut); var completed = healthy + warning + failed; var summary = new SelfCheckBatchSummaryDto { BatchId = batch.Id, Status = batch.Status, Target = batch.TargetDeviceCount, Pending = pending, Completed = completed, Healthy = healthy, Warning = warning, Failed = failed, Unreachable = unreachable, TimedOut = timedOut, CreatedAtUtc = batch.CreatedAtUtc, CompletedAtUtc = batch.CompletedAtUtc }; var probeCounts = new Dictionary(StringComparer.OrdinalIgnoreCase); foreach (var pk in SelfCheckProbeKeys.All) { probeCounts[pk] = (0, 0); } foreach (var run in runs.Where(r => r.RunState == SelfCheckRunStates.Completed && !string.IsNullOrWhiteSpace(r.ResultJson))) { try { var res = JsonSerializer.Deserialize(run.ResultJson!); if (res?.Checks != null) { foreach (var check in res.Checks) { var normKey = SelfCheckProbeKeys.Normalize(check.Name); if (probeCounts.TryGetValue(normKey, out var current)) { if (check.Status == SelfCheckStatus.Warning) { probeCounts[normKey] = (current.Warning + 1, current.Failed); } else if (check.Status == SelfCheckStatus.Failed) { probeCounts[normKey] = (current.Warning, current.Failed + 1); } } } } } catch { } } var failures = SelfCheckProbeKeys.All .Select(k => new ProbeFailureCountDto { Probe = k, WarningCount = probeCounts[k].Warning, FailedCount = probeCounts[k].Failed }) .ToList(); return (summary, failures); } }