| | | 1 | | using Microsoft.EntityFrameworkCore; |
| | | 2 | | using OzonDomains.Models; |
| | | 3 | | using OzonDomains.Models.SupplierStatuses; |
| | | 4 | | using OzonRepositories.Context; |
| | | 5 | | |
| | | 6 | | namespace OzonOrdersWeb.WebServices.Orders; |
| | | 7 | | |
| | | 8 | | public interface IOrderSupplierStateInfoService |
| | | 9 | | { |
| | | 10 | | /// <summary> |
| | | 11 | | /// Проецирует состояние у поставщика на [NotMapped] поля заказов страницы. |
| | | 12 | | /// Один запрос на страницу — модель Order при этом не расширяется. |
| | | 13 | | /// </summary> |
| | | 14 | | Task PopulateForOrdersAsync(IReadOnlyList<Order> ordersForPage, CancellationToken cancellationToken = default); |
| | | 15 | | } |
| | | 16 | | |
| | | 17 | | public sealed class OrderSupplierStateInfoService : IOrderSupplierStateInfoService |
| | | 18 | | { |
| | | 19 | | private readonly ApplicationDbContext _context; |
| | | 20 | | |
| | 5 | 21 | | public OrderSupplierStateInfoService(ApplicationDbContext context) |
| | | 22 | | { |
| | 5 | 23 | | _context = context; |
| | 5 | 24 | | } |
| | | 25 | | |
| | | 26 | | public async Task PopulateForOrdersAsync( |
| | | 27 | | IReadOnlyList<Order> ordersForPage, CancellationToken cancellationToken = default) |
| | | 28 | | { |
| | 5 | 29 | | if (ordersForPage.Count == 0) |
| | | 30 | | { |
| | 0 | 31 | | return; |
| | | 32 | | } |
| | | 33 | | |
| | 10 | 34 | | var orderIds = ordersForPage.Select(o => o.Id).Distinct().ToList(); |
| | | 35 | | |
| | | 36 | | // Активных строк на заказ может быть несколько (позиция разведена по двум поставщикам) — |
| | | 37 | | // в узкую ячейку списка помещается одна, берём самую свежую по смене статуса. |
| | 5 | 38 | | var stateMap = await _context.OrderSupplierStates |
| | 5 | 39 | | .AsNoTracking() |
| | 5 | 40 | | .Where(s => s.ActiveOrderId != null && orderIds.Contains(s.OrderId)) |
| | 5 | 41 | | .Select(s => new |
| | 5 | 42 | | { |
| | 5 | 43 | | s.OrderId, |
| | 5 | 44 | | s.ProviderKey, |
| | 5 | 45 | | s.Stage, |
| | 5 | 46 | | s.ExternalOrderNumber, |
| | 5 | 47 | | s.LastStatusChangeAt, |
| | 5 | 48 | | s.DeliveryDaysMin, |
| | 5 | 49 | | s.DeliveryDaysMax, |
| | 5 | 50 | | s.Direction, |
| | 5 | 51 | | s.OrderedAt, |
| | 5 | 52 | | s.CreatedAt, |
| | 5 | 53 | | StatusName = s.SupplierStatus != null ? s.SupplierStatus.Name : null, |
| | 5 | 54 | | StatusColor = s.SupplierStatus != null && s.SupplierStatus.StatusColor != null |
| | 5 | 55 | | ? s.SupplierStatus.StatusColor.ColorCode |
| | 5 | 56 | | : null, |
| | 5 | 57 | | SupplierName = s.SupplierStatus != null && s.SupplierStatus.Supplier != null |
| | 5 | 58 | | ? s.SupplierStatus.Supplier.Name |
| | 5 | 59 | | : null |
| | 5 | 60 | | }) |
| | 5 | 61 | | .ToListAsync(cancellationToken); |
| | | 62 | | |
| | 5 | 63 | | var latestByOrderId = stateMap |
| | 5 | 64 | | .GroupBy(x => x.OrderId) |
| | 5 | 65 | | .ToDictionary( |
| | 4 | 66 | | g => g.Key, |
| | 14 | 67 | | g => g.OrderByDescending(x => x.LastStatusChangeAt ?? DateTime.MinValue).First()); |
| | | 68 | | |
| | 20 | 69 | | foreach (var order in ordersForPage) |
| | | 70 | | { |
| | 5 | 71 | | if (!latestByOrderId.TryGetValue(order.Id, out var state)) |
| | | 72 | | { |
| | | 73 | | continue; |
| | | 74 | | } |
| | | 75 | | |
| | 4 | 76 | | order.SupplierStateProviderKey = state.ProviderKey; |
| | 4 | 77 | | order.SupplierStateStage = state.Stage; |
| | 4 | 78 | | order.SupplierStatusName = state.StatusName; |
| | 4 | 79 | | order.SupplierStatusColor = state.StatusColor; |
| | 4 | 80 | | order.SupplierStateExternalOrderNumber = state.ExternalOrderNumber; |
| | 4 | 81 | | order.SupplierStateChangedAt = state.LastStatusChangeAt; |
| | 4 | 82 | | order.SupplierStateSupplierName = state.SupplierName ?? ResolveDisplayName(state.ProviderKey); |
| | 4 | 83 | | order.SupplierStateDeliveryDaysMin = state.DeliveryDaysMin; |
| | 4 | 84 | | order.SupplierStateDeliveryDaysMax = state.DeliveryDaysMax; |
| | 4 | 85 | | order.SupplierStateDirection = state.Direction; |
| | | 86 | | // Хранятся в БД в UTC — приводим к локальному времени сервера, как и остальные даты заказа |
| | | 87 | | // (ProcessingDate/ShippingDate считаются уже в местном времени, TimeLeft сравнивает с DateTime.Now). |
| | 4 | 88 | | order.SupplierStateOrderedAt = state.OrderedAt?.ToLocalTime(); |
| | 4 | 89 | | order.SupplierStateCartCreatedAt = state.CreatedAt.ToLocalTime(); |
| | | 90 | | } |
| | 5 | 91 | | } |
| | | 92 | | |
| | | 93 | | /// <summary>Запасное имя, когда связь провайдера с записью справочника Supplier не настроена.</summary> |
| | 4 | 94 | | private static string ResolveDisplayName(string providerKey) => providerKey switch |
| | 4 | 95 | | { |
| | 3 | 96 | | ApiSupplierSettings.AvdProviderKey => "АВД", |
| | 1 | 97 | | ApiSupplierSettings.ArmtekProviderKey => "Армтек", |
| | 0 | 98 | | ApiSupplierSettings.ArmtekByProviderKey => "Армтек BY", |
| | 0 | 99 | | ApiSupplierSettings.MlAutoProviderKey => "ML-Auto BY", |
| | 0 | 100 | | ApiSupplierSettings.MlAutoRuProviderKey => "ML-Auto RU", |
| | 0 | 101 | | ApiSupplierSettings.FavoritPartsProviderKey => "Фаворит Союз", |
| | 0 | 102 | | ApiSupplierSettings.FavoritPartsIstraProviderKey => "Фаворит Истра", |
| | 0 | 103 | | _ => providerKey |
| | 4 | 104 | | }; |
| | | 105 | | } |