| | | 1 | | using MechanicsSoftware.Application.Abstractions; |
| | | 2 | | using MechanicsSoftware.Domain.ValueObjects; |
| | | 3 | | using Microsoft.EntityFrameworkCore; |
| | | 4 | | |
| | | 5 | | namespace MechanicsSoftware.Application.UseCases.ServiceOrders.Handlers; |
| | | 6 | | |
| | 4 | 7 | | public sealed class GetAverageExecutionTimeHandler(IAppDbContext db) |
| | | 8 | | { |
| | | 9 | | public async Task<AverageExecutionTimeResponse> ExecuteAsync(CancellationToken cancellationToken = default) |
| | 4 | 10 | | { |
| | 4 | 11 | | var completedStatus = new ServiceOrderStatus(ServiceOrderStatus.Status.Completed); |
| | 4 | 12 | | var deliveredStatus = new ServiceOrderStatus(ServiceOrderStatus.Status.Delivered); |
| | | 13 | | |
| | 4 | 14 | | var completedOrders = await db.ServiceOrders |
| | 4 | 15 | | .Where(o => o.CompletedAt != null) |
| | 4 | 16 | | .Where(o => o.Status == completedStatus || o.Status == deliveredStatus) |
| | 4 | 17 | | .Select(o => new { o.CreatedAt, o.CompletedAt }) |
| | 4 | 18 | | .ToListAsync(cancellationToken); |
| | | 19 | | |
| | 4 | 20 | | if (completedOrders.Count == 0) |
| | 2 | 21 | | return new AverageExecutionTimeResponse(0, 0); |
| | | 22 | | |
| | 2 | 23 | | var averageHours = completedOrders |
| | 2 | 24 | | .Average(o => (o.CompletedAt!.Value - o.CreatedAt).TotalHours); |
| | | 25 | | |
| | 2 | 26 | | return new AverageExecutionTimeResponse( |
| | 2 | 27 | | Math.Round(averageHours, 2), |
| | 2 | 28 | | completedOrders.Count); |
| | 4 | 29 | | } |
| | | 30 | | } |