using ClassNotify.Server.Configuration; using ClassNotify.Server.Data; using ClassNotify.Shared.Enums; using ClassNotify.Shared.Models; using Microsoft.EntityFrameworkCore; using Microsoft.Extensions.Options; namespace ClassNotify.Server.Services; public interface IFleetVersionService { Task GetFleetVersionSummaryAsync(CancellationToken ct = default); Task> GetFleetDevicesAsync(FleetDeviceVersionQuery query, CancellationToken ct = default); } public sealed class FleetVersionService : IFleetVersionService { private readonly ClassNotifyDbContext _db; private readonly IDeviceVersionEvaluator _versionEvaluator; private readonly IDevicePresenceService _presenceService; private readonly DeviceVersionPolicyOptions _policy; public FleetVersionService( ClassNotifyDbContext db, IDeviceVersionEvaluator versionEvaluator, IDevicePresenceService presenceService, IOptions options) { _db = db; _versionEvaluator = versionEvaluator; _presenceService = presenceService; _policy = options.Value; } public async Task GetFleetVersionSummaryAsync(CancellationToken ct = default) { var devices = await _db.Devices .AsNoTracking() .Select(d => new { d.ServiceVersion, d.ClientVersion, d.ProtocolVersion }) .ToListAsync(ct); int current = 0; int outdated = 0; int unsupported = 0; int unknown = 0; foreach (var d in devices) { var result = _versionEvaluator.Evaluate( d.ServiceVersion, d.ClientVersion, d.ProtocolVersion); switch (result.Status) { case FleetVersionStatus.Current: current++; break; case FleetVersionStatus.Outdated: outdated++; break; case FleetVersionStatus.Unsupported: unsupported++; break; default: unknown++; break; } } return new FleetVersionSummaryDto { Total = devices.Count, Current = current, Outdated = outdated, Unsupported = unsupported, Unknown = unknown, GeneratedAtUtc = DateTimeOffset.UtcNow, Policy = BuildPolicyDto() }; } public async Task> GetFleetDevicesAsync( FleetDeviceVersionQuery query, CancellationToken ct = default) { var devices = await _db.Devices .AsNoTracking() .ToListAsync(ct); var tenants = await _db.Tenants .AsNoTracking() .ToDictionaryAsync(t => t.Id, t => t.Name, ct); var classrooms = await _db.Classrooms .AsNoTracking() .ToDictionaryAsync(c => $"{c.TenantId}_{c.Id}", c => c.DisplayName, ct); var results = new List(); foreach (var d in devices) { var eval = _versionEvaluator.Evaluate( d.ServiceVersion, d.ClientVersion, d.ProtocolVersion); var isOnline = _presenceService.IsOnline(d.Id, d.LastHeartbeatAt); tenants.TryGetValue(d.TenantId, out var tenantName); tenantName ??= d.TenantId; classrooms.TryGetValue($"{d.TenantId}_{d.ClassroomId}", out var classroomName); classroomName ??= d.ClassroomId; // 1. Status Filter if (!string.IsNullOrWhiteSpace(query.Status) && !string.Equals(query.Status, "all", StringComparison.OrdinalIgnoreCase)) { if (!string.Equals(eval.Status.ToString(), query.Status.Trim(), StringComparison.OrdinalIgnoreCase)) { continue; } } // 2. Tenant Filter if (!string.IsNullOrWhiteSpace(query.TenantId) && !string.Equals(query.TenantId, "all", StringComparison.OrdinalIgnoreCase)) { if (!string.Equals(d.TenantId, query.TenantId.Trim(), StringComparison.OrdinalIgnoreCase)) { continue; } } // 3. Online Filter if (query.Online.HasValue) { if (isOnline != query.Online.Value) { continue; } } // 4. Keyword Query (DeviceId, Hostname, ClassroomName, TenantName) if (!string.IsNullOrWhiteSpace(query.Q)) { var q = query.Q.Trim(); bool matches = d.Id.Contains(q, StringComparison.OrdinalIgnoreCase) || (d.Hostname != null && d.Hostname.Contains(q, StringComparison.OrdinalIgnoreCase)) || classroomName.Contains(q, StringComparison.OrdinalIgnoreCase) || tenantName.Contains(q, StringComparison.OrdinalIgnoreCase); if (!matches) { continue; } } results.Add(new FleetDeviceVersionDto { DeviceId = d.Id, TenantId = d.TenantId, TenantName = tenantName, ClassroomId = d.ClassroomId, ClassroomName = classroomName, Hostname = d.Hostname, IsOnline = isOnline, LastHeartbeatAt = d.LastHeartbeatAt, ServiceVersion = d.ServiceVersion, ClientVersion = d.ClientVersion, ProtocolVersion = d.ProtocolVersion, OsVersion = d.OsVersion, Architecture = d.Architecture, VersionStatus = eval.Status, Reasons = eval.Reasons.ToList() }); } // Ordered by risk: Unsupported first (0), Outdated (1), Unknown (2), Current (3), then by Tenant & Class return results .OrderBy(r => GetSeverityRank(r.VersionStatus)) .ThenBy(r => r.TenantName) .ThenBy(r => r.ClassroomName) .ToList(); } private static int GetSeverityRank(FleetVersionStatus status) => status switch { FleetVersionStatus.Unsupported => 0, FleetVersionStatus.Outdated => 1, FleetVersionStatus.Unknown => 2, FleetVersionStatus.Current => 3, _ => 4 }; private DeviceVersionPolicyViewDto BuildPolicyDto() { return new DeviceVersionPolicyViewDto { MinimumServiceVersion = _policy.MinimumServiceVersion, RecommendedServiceVersion = _policy.RecommendedServiceVersion, MinimumClientVersion = _policy.MinimumClientVersion, RecommendedClientVersion = _policy.RecommendedClientVersion, MinimumProtocolVersion = _policy.MinimumProtocolVersion > 0 ? _policy.MinimumProtocolVersion : 2 }; } }